How to transform to link query for MVC

Rijen Juni

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!!

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhushan Bhasme11y ago
try to simply take different day,month and year part and then compare
0
Manas Mohapatra11y ago
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;
0
Rijen Juni11y ago
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..
0
Manas Mohapatra11y ago
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.
0
Rijen Juni11y ago
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
0
Manas Mohapatra11y ago
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.
0
Rijen Juni11y ago
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?
0
Rijen Juni11y ago
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
0
Manas Mohapatra11y ago
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.
0