asp.net/C#: Handle datetime if null using LINQ

Question

I have null values in database specifically for Good Expiry Date, which is the field is:good_expiryDate.

What i want is to handle it in this way: If good_expiryDate is null i want to present it as "" or "-", if it has value it will show the value retrieved from database?

the LINQ query i write is like this, but it return MinValue if good_expiryDate is null(this is what i tried to do).

var query = (from cd in db.CDIndexes
             join gds in db.Goods on cd.cdin_CDIndexID equals gds.good_CDIndexId 
             join itms in db.Items on gds.good_ItemsID equals itms.item_ItemsID

            where
            cd.cdin_CompanyId==c.Comp_CompanyId&&
            (
                gds.good_RemainCBM > 0 ||
                gds.good_RemainWT > 0 ||
                gds.good_RemainPackages > 0 ||
                gds.good_RemainVolumeWT > 0
            )
            &&
            itms.item_ItemsID==customerId

            select new DataItem
            {
                 depNumber=(int)cd.cdin_Serial,
                 ItemDesc=gds.good_Name,
                 gdExpiryDate =(DateTime) gds.good_expiryDate==null?DateTime.MinValue: (DateTime)gds.good_expiryDate,
                 InvoicBalanceUnits = (decimal) gds.good_RemainPackages,
                 WTBal=(decimal)gds.good_RemainWT,
                 VolWT=(decimal)gds.good_RemainVolumeWT
            }
       );
return query.ToList();

Update: good_expiryDate is type of Datetime, nullable in database

gdExpiryDate should be string type. In this case you should use (DateTime)gds.good_expiryDate == null ? "-" : ((DateTime)gds.good_expiryDate).ToString("G") — M. Wiśnicki
– M. Wiśnicki, Commented Dec 28, 2016 at 7:31
May be you can try good_expiryDate = good_expiryDate.HasValue ? good_expiryDate.Value : null; — Mohit S
– Mohit S, Commented Dec 28, 2016 at 7:31
Can you compare with System.DBNull.Value instead of null — Harrison Nguyen
– Harrison Nguyen, Commented Dec 28, 2016 at 7:31

ViVi · Accepted Answer · 2016-12-28 07:30:32Z

1

Ensure that gdExpiryDate is of type string.

Then change this line

gdExpiryDate =(DateTime) gds.good_expiryDate==null?DateTime.MinValue: (DateTime)gds.good_expiryDate,

to

gdExpiryDate = gds.good_expiryDate==null? "-" : ((DateTime)gds.good_expiryDate).ToString(),

answered Dec 28, 2016 at 7:30

ViVi

4,4848 gold badges33 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

ViVi Over a year ago

You only mentioned about your requirement like this If good_expiryDate is null i want to present it as "" or "-", if it has value it will show the value retrieved from database. If you want to display - then it has to be string obviously. @faresAyyad

ViVi Over a year ago

I am speaking about gdExpiryDate and not good_expiryDate. good_expiryDate can be date time. But the gdExpiryDate should be string in order to keep the "-" value in it. @faresAyyad

fares Ayyad Over a year ago

Thank you, this was helpful

ViVi Over a year ago

Welcome. Glad to help.

fares Ayyad Over a year ago

but how can i present it as dd/mm/yyyy

|

Muhammad Omar ElShourbagy · Accepted Answer · 2016-12-28 07:39:39Z

0

Change gdExpiryDate type to string type and write like this:

    select new DataItem
             {
                 depNumber=(int)cd.cdin_Serial,
                 ItemDesc=gds.good_Name,
                 gdExpiryDate = gds.good_expiryDate == null ? "" :  gds.good_expiryDate.Value.ToString("dd.mm.yyyy"),
                 InvoicBalanceUnits = (decimal) gds.good_RemainPackages,
                 WTBal=(decimal)gds.good_RemainWT,
                 VolWT=(decimal)gds.good_RemainVolumeWT
             }

edited Dec 28, 2016 at 7:39

Muhammad Omar ElShourbagy

7,1182 gold badges34 silver badges51 bronze badges

answered Dec 28, 2016 at 7:35

Mubariz F

4124 silver badges16 bronze badges

1 Comment

fares Ayyad Over a year ago

I can't change the database field.

Collectives™ on Stack Overflow

asp.net/C#: Handle datetime if null using LINQ

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related