public List <EmployeeProjectAllocationModel> Employee_BillingTillDate(EmployeeProjectAllocationModel ObjEmp)
{
List <EmployeeProjectAllocationModel> objList = new List <EmployeeProjectAllocationModel>();
using (var _context = new RMS_Entities())
{
var db = _context.USP_Employee_BillingTillDate(Convert.ToString(ObjEmp.Flag), Convert.ToDateTime(ObjEmp.BillingTillDate), Convert.ToInt32(ObjEmp.EmpId),
Convert.ToInt32(ObjEmp.EPAId)).ToList <USP_Employee_BillingTillDate_Result>();
EmployeeProjectAllocationModel objEmpl = null;
foreach (var objSingle in db)
{
objEmpl = new EmployeeProjectAllocationModel();
objEmpl.EPAId = objSingle.EPAId;
objEmpl.EPAIdEncr = CommonRepository.Encode(objEmpl.EPAId.ToString());
objEmpl.EmpId = objSingle.EmpId;
objEmpl.EmployeeName = objSingle.EmployeeName;
ProjectResult objProject = new ProjectResult();
objProject.ProjectName = objSingle.ProjectName;
objEmpl.Projects = objProject;
objEmpl.StartDate = Convert.ToDateTime(objSingle.AllocationDate);
objEmpl.ActualRelDate = Convert.ToDateTime(objSingle.ReleaseDate);
objEmpl.BillingTillDate = Convert.ToDateTime(objSingle.BillingTillDate);
//objEmpl.FirstName= objSingle.p
objList.Add(objEmpl);
}
return(objList);
}
}
EmployeeTillBilledViewModel ListEmployeeBillDate(EmployeeTillBilledViewModel ObjEmpTillBilled, int EPAId, string Flag)
{
EmployeeProjectAllocationModel objEPA = new EmployeeProjectAllocationModel();
List <EmployeeProjectAllocationModel> lstObjEPA = new List <EmployeeProjectAllocationModel>();
objEPA.Flag = Flag;
objEPA.EPAId = EPAId;
if (objEPA.Flag == "U")
{
objEPA.BillingTillDate = ObjEmpTillBilled.BillingTillDate;
TempData["Message"] = "Billing updated successfully";
}
else if (objEPA.Flag == "D")
{
objEPA.BillingTillDate = DateTime.Today;
TempData["Message"] = "Billing deleted successfully";
}
else
{
objEPA.BillingTillDate = DateTime.Today;
}
lstObjEPA = _service.Employee_BillingTillDate(objEPA).ToList();
if (lstObjEPA.Count == 1 && EPAId != 0)
{
ObjEmpTillBilled.EmpId = lstObjEPA[0].EmpId;
ObjEmpTillBilled.EmployeeName = lstObjEPA[0].EmployeeName;
ObjEmpTillBilled.ProjectName = lstObjEPA[0].Projects.ProjectName;
ObjEmpTillBilled.StartDate = lstObjEPA[0].StartDate;
ObjEmpTillBilled.ActualRelDate = lstObjEPA[0].ActualRelDate;
ObjEmpTillBilled.BillingTillDate = lstObjEPA[0].BillingTillDate;
}
ObjEmpTillBilled.ListEmployeeBilled = new List <EmployeeProjectAllocationModel>();
ObjEmpTillBilled.ListEmployeeBilled = lstObjEPA;
return(ObjEmpTillBilled);
}
public List <EmployeeProjectAllocationModel> Employee_BillingTillDate(EmployeeProjectAllocationModel ObjEmp)
{
return(_IEmployeeRepository.Employee_BillingTillDate(ObjEmp));
}
