Checking Maximum Hours for month

Question

For my application, system should allow user to enter maximum of 2 hours per month. Start date of month is 26th of every month and End date of the month is 25th of every month. I want to check total hours between the period(26th - 25th). For example, For september month it should calculate from (26/08/2018 to 25/09/2018). Kindly suggest best way to achieve this. Thanks in advance.

Ashok K · Answer

I got solution for this SELECT DATEADD(DAY, 26-1, DATEADD(MONTH, -1, DATEADD(DAY, 1-DAY(getdate()), getdate()))); SELECT DATEADD(DAY, 24, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0));

Sai Kumar Koona · Answer

Hi Ashok, I think my code below will works for your requirement, you need to change some variable names and properties accordingly. Here in my code, you can observe the e following 1) Get the data of specific employee's leave list for given dates (26th of last month to 25th if this month). 2) Once you get data, you can count the hours/min he applied earlier/ 3) If it is exceeding 2 hours don't allow now.

Ashok K · Answer

My application is Employee portal, here user can apply permission max allowed 2 hours for month. Here month start date is 26th and end date is 25th of every month. System should not allow users to apply permission more than 2 hours for a month.(between 26 to 25 of the month) How to calculate hours and restrict user to apply more than 2 hours.

Sai Kumar Koona · Answer

Hi Ashok, As you didn't provide much about your application I used some random names to the model and variable. Please check the below code, where you can validate the dates and its hours List myModels = reposiotry.getMyModel(); var lst = myModels.Where(s => (s.myDate >= Convert.ToDateTime( "25/09/2018" ) && s.myDate "26/08/2018" ))).ToList(); int hoursCount = 0; lst.ForEach(s=>(hoursCount+= s.LoggedHours)); if (hoursCount > 2) { //do something here }

Rafnas T P · Answer

hi, try below code to get total hrs between two dates TimeSpan diff = Convert.ToDateTime("25/09/2018") - Convert.ToDateTime("26/08/2018"); double hours = diff.TotalHours;