Convert Date to Shamsi in linq query

Question

I want to convert Gregorian date to Shamsi in Linq query

This is my query

Contex = new RfidReaderEntities1();
var selectall = from myreads in Contex.V_DriverWithReadTags select new { myreads.RfidTagId, myreads.CarType, myreads.Plate, myreads.VisiteDate, myreads.Lname,myreads.shamsidate}; 
dataGridView1.DataSource = selectall.ToList();

I want to convert myreads.VisiteDate to Shamsi date.

possible duplicate of [In LINQ Query convert the string to datetime and check with today's date](http://stackoverflow.com/questions/21041296/in-linq-query-convert-the-string-to-datetime-and-check-with-todays-date) — Mahesh, Mar 04 '15 at 13:12
@ErnodeWeerd: Should we move it to music.stackexchange.com? Seriously, I don't understand what OP wants at all. — Falanwe, Mar 04 '15 at 13:15
You can use `PersianConverter` to convert Gregorian to Shamsi. — Aria, Mar 04 '15 at 13:17
You can use different calendars through the [System.Globalization.Calendar](https://msdn.microsoft.com/en-us/library/system.globalization.calendar%28v=vs.110%29.aspx) class and its derived classes, eg. [PersianCalendar](https://msdn.microsoft.com/en-us/library/system.globalization.persiancalendar(v=vs.110).aspx) — Panagiotis Kanavos, Mar 04 '15 at 13:18
var selectall = from myreads in Contex.V_DriverWithReadTags select new { myreads.RfidTagId, myreads.CarType, myreads.Plate, myfunctionC(myreads.VisiteDate), myreads.Lname,myreads.shamsidate}; — Javid Javidi, Mar 04 '15 at 13:29
Using Persia.Net Core can be of help to you. If you are not using .NET Core you can install the oldest version of this library. https://github.com/shahabfar/Persia-.NET-Core — Majid Shahabfar, Dec 03 '20 at 17:31

score 0 · Answer 1 · answered Mar 04 '15 at 13:32

0

First download FarsiLibrary.Utils because it convert Gregorian to Shamsi without any mistake add it's DLL files to your project to more information go Here.

then try this:

var selectall = from myreads in Contex.V_DriverWithReadTags select new {
            RfidTagId = myreads.RfidTagId,
            CarType = myreads.CarType, 
            Plate = myreads.Plate,
            VisiteDate = PersianDateConverter.ToPersianDate(myreads.VisiteDate), 
            Lname = myreads.Lname,
            shamsidate = myreads.shamsidate
        };

answered Mar 04 '15 at 13:32

Aria

3,724
1
20
51

Thank you But it does not show any data in datagridview – Javid Javidi Mar 04 '15 at 13:46
@JavidJavidi Did you download that library ? Did you set your DataGridView's DataSource property ? – Aria Mar 04 '15 at 13:50
Thank you yes download that library and set DataSource – Javid Javidi Mar 04 '15 at 13:58

score 0 · Answer 2 · answered Mar 04 '15 at 13:55

0

 Contex = new RfidReaderEntities1();


            var selectall = from myreads in Contex.V_DriverWithReadTags select new {
            RfidTagId = myreads.RfidTagId,
            CarType = myreads.CarType, 
            Plate = myreads.Plate,
            VisiteDate = PersianDateConverter.ToPersianDate((DateTime)myreads.VisiteDate), 
           // VisiteDate = myshamsifun.GetShamsiDateTime((DateTime)myreads.VisiteDate), 
            Lname = myreads.Lname,   
        };


            dataGridViewlisttoday.DataSource = selectall.ToList();

answered Mar 04 '15 at 13:55

Javid Javidi

1
1

What is the difference between this and my answer, it just copy and pasted. – Aria Mar 04 '15 at 14:01
@soheylaabbb hiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii test – Javid Javidi Mar 07 '15 at 07:23
What does that mean ? – Aria Mar 07 '15 at 07:27

Convert Date to Shamsi in linq query

2 Answers2