Checking Maximum Hours for month

Ashok K

8y818.NET

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.

5 Replies

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

Ashok K8y ago
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 Koona8y ago
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 K8y ago
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 Koona8y ago
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 <= Convert.ToDateTime("26/08/2018"))).ToList();

            int hoursCount = 0;

            lst.ForEach(s=>(hoursCount+= s.LoggedHours));

            if(hoursCount > 2)
            {
                //do something here
            }
Rafnas T P8y ago
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;