How to check null field column using C# in ASP.Net MVC

Question

insert into field end assignment with other event start dateexample if id 1  field enddateassignment  null then enddateassignment fill with new create with  contain same id

AnandM · Accepted Answer

Hi  Ruben12345You can achieve like below by checking whether the vehicleId already exists or not if exists then assign the end time with begin time and in else condition you need to add send end date null you can optimize your code according to your need i have just provided you the way how you can achieve your requirementShipmentAssignment getduplicatevehicle  dbShipmentAssignmentsWherem gt mvehicleid  modelvehicleid FirstOrDefaultif getduplicatevehicle  null    ShipmentAssignment shipment  new ShipmentAssignment            memberid  memberId        partnerid  intmodelpartnerid        vehicleid  intmodelvehicleid        shipmentno  modelshipmentno        begindatetime  modelbegindatetime        createdate  DateTimeNow        enddatetime  modelbegindatetime        active  true        dbShipmentAssignmentsAddshipment    dbSaveChanges    Session34UpdateMessage34  34Vehicle has been assign34

Ruben12345 · Answer

HI Anand  im just try my selft  it success with this query    if getduplicatevehicle  null getduplicatevehicle enddatetime  modelbegindatetime  its just simple i think anyway thanks for ur attention

How to check null field column using C# in ASP.Net MVC

Company

Explore

Follow us

Contact Us