Calculate salary for week based & distributed Month end

Prem Anandh J

I want to generate payroll for employees those are getting weekly salary.

Salary distributed at end of the month. So month end i have to calculate the salary based on each and every week. one week can assume from Mon to Sun(7 days) .

For ex,July month salary has to calculate

sal= 01-07-16 to 03-07-16(friday to sun) +

04-07-16 to 10-07-16(mon to sun) +

11-07-16 to 17-07-16(Mon to sun) +

18-07-16 to 24-07-16(mon to sun) +

25-07-16 to 31-07-16(mon to sun).

Each and every week their will be OT ,Allowance, Deductions,Paid Leave.

Here How to Split the week (Monday to Sunday) for the given salary date? Then only I can salary and OT for each and every week. I tried a code. It’s good for monthly salary but not correct for weekly salary..

I used Employee clocker punches as input. Based on that am calculating the working days.

Private void calculatePayroll(string ID, DateTime FromDate, DateTime ToDate)
{
float cworkedDay = 0, cPaidLeave = 0, cAbsent = 0;
TimeSpan vWorkHr, vweekOT, vsatOT, vsunOT;
while (FromDate <= ToDate)
{
var objAttMas = getAttendance(EmpID, FromDate);
var objLeaveMas = getLeave(empID, FromDate)if (objAttMas != null) //Present
{
if (FromDate.DayOfWeek.ToString() == "Sunday") //Allowance for Sunday work
{
sunOT = sunOT + sunOT
}
if (FromDate.DayOfWeek.ToString() == "Saturday") //Saturday 5 hr work
{
if (totalHour < new TimeSpan(5, 0, 0))
{
totalHour = WorkHr + totalHour )
;
}
else
{
satOT = satOT + totalHour - new TimeSpan(5, 0, 0) )
;
WorkHr = WorkHr + TimeSpan(5, 0, 0) )
;
}
}
else //Week day work
{
WorkHr = WorkHr + totalHour
}
cworkedDay += float.Parse(noOfDay.ToString());
}
if (objLeaveMas != null) //Leave
{
var objleaveType = getLeaveType(leaveType)if (objleaveType != null) //
{
if (FromDate.DayOfWeek.ToString() == "Saturday")
{
if (objleaveType.incWeekend == 1)
{
cPaidLeave += float.Parse(objLeaveMas.noOfDay.ToString());
}
else
{
cAbsent += float.Parse(objLeaveMas.noOfDay.ToString());
}
}
else
{
if (objleaveType.paidLeave == 1)
{
cPaidLeave += float.Parse(objLeaveMas.noOfDay.ToString());
}
else
{
cAbsent += float.Parse(objLeaveMas.noOfDay.ToString());
}
}
}
}
if (objAttMas != null && objLeaveMas != null) //Absent
{
if (FromDate.DayOfWeek.ToString() != "Sunday)
{
cAbsent += 1;
}
}
FromDate = FromDate.AddDays(1);
} //End of For loop
}

6 Replies

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

Prem Anandh J10y ago
Expected O/P
25-12-2015 TO 27-12-2015
28-12-2015 TO 3-1-2016
4-1-2016 TO 10-1-2016
11-1-2016 TO 17-1-2016
18-1-2016 TO 24-1-2016
for the input date 25-12-2015 and24-1-2016
I found the code
privatevoidDateCal(DateTimestart,DateTimeend)
{
DateTimestartDate=start;
DateTimeendDate=end;
DictionarydictDate=newDictionary();
TimeSpandiff=endDate-startDate;
intdays=diff.Days;
if(days>=1)
{
for(vari=0;i<=days;i++)
{
if((startDate.AddDays(7-(int)startDate.DayOfWeek)
{
dictDate.Add(startDate,startDate.AddDays(7-(int)startDate.DayOfWeek));
startDate=startDate.AddDays(8-(int)startDate.DayOfWeek);
DateTimetempDate;
tempDate=startDate.AddDays(8-(int)startDate.DayOfWeek);
i+=7-(int)startDate.DayOfWeek;
}
if(i>=days)
{
dictDate.Add(startDate,endDate);
break;
}
}
}
foreach(varitemindictDate)
Console.WriteLine(item.Key.ToString("d-M-yyyy")+"TO"+item.Value.ToString("d-M-yyyy"));
}
0
Nitin Sontakke10y ago
You are already looping through both the dates. You are already checking day of week Saturday, Sunday. In the loop can you not check for Monday? If it is a Monday, previous week is over and new week is started. Simple.
It's a classical do while...end kind of loop.
It is really not clear what you are expecting. That's why I am saying show some expected output then it will be clear.
0
Prem Anandh J10y ago
I want to split the some range date into week wise. no matter about the payroll calculation. I did payroll for Monthly salary employee. that cod only i given above
0
Nitin Sontakke10y ago
Either you are unnecessarily complicating the whole thing in your mind or I am not understanding the complexity of the issue.
Can you please give a sample of expected output?
That will give an idea what you are referring to as "Weekly Salary".
0
Prem Anandh J10y ago
Hello Nithin,
Salary not calculated every month . It between a date range .
I have found code to get weeks of month.
http://codereview.stackexchange.com/questions/5451/listing-the-weeks-in-a-given-month/136271#136271
But I need the get weeks between two dates.
0
Nitin Sontakke10y ago
You will maximum 5 weeks in a month. Why not create an array of 5 elements? Everytime you notice that today is Monday, you increment the array index.
If you are using SQL Server there is function which return Week Number of a given date (this is a very commonly used concept in USA) You can use this week number to automatically group dates in weeks.
I strongly suggest you try to do all of this in stored procedure.
0