public ActionResult GetPayrollDetailsByDate(string id, string franchisid, DateTime payrollDate)
{
int payrollid = Convert.ToInt32(id);
int payrollSearchid = payrollid;
vRpt_Payroll objpayroll = null;
if (payrollid == -1) // Get it by date instead
{
objpayroll = (from payroll in rptDB.vRpt_Payroll where payroll.PayrollDate == payrollDate select payroll).FirstOrDefault();
}
else
{
objpayroll = (from payroll in rptDB.vRpt_Payroll where payroll.PayrollID == payrollSearchid select payroll).FirstOrDefault();
}
if (objpayroll != null)
{
payrollid = objpayroll.PayrollID;
}
List <vRpt_PayrollDetail> objPayrollDetails = (from payrolldetails in rptDB.vRpt_PayrollDetail where payrolldetails.PayrollID == payrollid orderby payrolldetails.EmployeeID select payrolldetails).ToList();
List <Payroll_Details> objPayroll_Details = new List <Payroll_Details>();
foreach (var item in objPayrollDetails)
{
tbl_Employee objEmployees = (from emp in db.tbl_Employee where emp.EmployeeID == item.EmployeeID select emp).SingleOrDefault();
Payroll_Details oPayroll_Details = new Payroll_Details();
oPayroll_Details.PayType = "";
oPayroll_Details.Employee = objEmployees.Employee;
oPayroll_Details.JobCount = item.JobCount.Value;
oPayroll_Details.WeeklySalary = item.WeeklySalary;
oPayroll_Details.RegularHours = item.RegularHours;
oPayroll_Details.RegularPay = item.RegularPay;
oPayroll_Details.OTHours = item.OTHours;
oPayroll_Details.OTPay = item.OTPay;
oPayroll_Details.TotalCommission = (float)item.TotalCommission;
oPayroll_Details.OTAdditCommission = (float)item.OTAdditCommission;
oPayroll_Details.Adjustment = item.Adjustment;
oPayroll_Details.GrossPay = (float)item.GrossPay;
oPayroll_Details.PayrollLockDateString = (item.LockDate.HasValue) ? item.LockDate.Value.ToShortDateString() : null;
objPayroll_Details.Add(oPayroll_Details);
}
return(Json(objPayroll_Details));
}
public bool StopPayment(Payroll_Details p1)
{
bool res = false;
return(res);
}
public bool OverTimeAllowances(Payroll_Details p1)
{
bool res = false;
return(res);
}
public bool SalaryHike(Payroll_Details p1)
{
bool res = false;
return(res);
}
