How to transform to link query for MVC

Question

How i transform this query to link query in MVC? SELECT * FROM [dbo].[LapTriwulans] WHERE DATEPART(wkSubmitDate) = DATEPART(wk GETDATE()) AND YEAR(SubmitDate) = YEAR(GETDATE()) Thanks!!

Bhushan Bhasme · Answer

try to simply take different daymonth and year part and then compare

Manas Mohapatra · Answer

Please find updated code below: Calendar calendar = CultureInfo.CurrentCulture.Calendar; int weekNo = calendar.GetWeekOfYear(DateTime.Now CalendarWeekRule.FirstFullWeek DayOfWeek.Tuesday); var tempResultsult = from p in dbContext.LapTriwulans where p.SubmitDateYear.Year == DateTime.Now.Year && calendar.GetWeekOfYear(p.SubmitDateYear CalendarWeekRule.FirstFullWeek DayOfWeek.Tuesday) == weekNo select p;

Rijen Juni · Answer

Finaly i can get .Year from data with modify NUlldefaullt in model but its still not work because the error message give me  && can't use in 'string' 'int' operand..

Manas Mohapatra · Answer

SubmitDateYear property should be DatemTime datatype in your entity. Please check your entity(LapTriwulans). Please find updated code below: Calendar calendar = CultureInfo.CurrentCulture.Calendar; int weekNo = calendar.GetWeekOfYear(DateTime.Now CalendarWeekRule.FirstFullWeek DayOfWeek.Tuesday); var tempResultsult = from p in dbContext.LapTriwulans where p.SubmitDateYear.Year = DateTime.Now.Year && calendar.GetWeekOfYear(p.SubmitDateYear CalendarWeekRule.FirstFullWeek DayOfWeek.Tuesday) = weekNo select p; You can change week GetWeekOfYear as per your requirement. You can start your week from monday.

Rijen Juni · Answer

Yes I have Datetime type in database when i write p.SubmitDateYear. then system give me option EqualGetHashCode GetType HashValue ToString Value and there's no Yearday month error says System Nullabel doesnt definition for Year here my model public Nullable TanggalLapor { get; set; } and i'm using EF

Manas Mohapatra · Answer

If SubmitDateYear column is DateTime type in database then you will get easily Year from that. Secondly are you getting any error. If so please provide error details.

Rijen Juni · Answer

sir I think p.SubmitDateYear.year cant work because i only have DateTime Field so how i get Year value from DateTime which i was store in database?

Rijen Juni · Answer

Siir I have a problem in this link  I hope you can help me http://www.codeproject.com/Questions/1018457/How-To-automatic-update-counter-in-MVC

Manas Mohapatra · Answer

Please see below code: Calendar calendar = CultureInfo.CurrentCulture.Calendar; int weekNo = calendar.GetWeekOfYear(DateTime.Now CalendarWeekRule.FirstFullWeek DayOfWeek.Tuesday); var tempResultsult = from p in dbContext.LapTriwulans where p.SubmitDateYear.Year.ToString() = DateTime.Now.Year.ToString() && calendar.GetWeekOfYear(p.SubmitDateYear CalendarWeekRule.FirstFullWeek DayOfWeek.Tuesday) = weekNo select p; You can change week GetWeekOfYear as per your requirement. You can start your week from monday.