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(wk,SubmitDate) = DATEPART(wk, GETDATE()) AND YEAR(SubmitDate) = YEAR(GETDATE()) Thanks!!

Bhushan Bhasme · Answer

try to simply take different day,month 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 Equal,GetHashCode, GetType, HashValue, ToString, Value and there's no Year,day, 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.

How to transform to link query for MVC

Answers (9)