public ActionResult Index(CheckLeaveViewModel checkLeaveViewModel) { Employees_Other_Leave_Counts eolc = new Employees_Other_Leave_Counts(); CheckLeaveModel checkLeaveModel = new CheckLeaveModel(); List <Employees_Take_Leaves> etlList = new List <Employees_Take_Leaves>(); checkLeaveViewModel.code = "NHM" + checkLeaveViewModel.code; var getRow = db.Employees_Other_Leave_Counts.FirstOrDefault(s => s.code == checkLeaveViewModel.code); if (getRow == null) { return(Content("<script language='javascript' type='text/javascript'>alert('Invalid Employee Code. Go back and Try Again!');</script>")); } var getTotalAbsentRows = db.Employees_Take_Leaves.Where(s => s.emp_code == checkLeaveViewModel.code).ToList(); var getLeaveDetails = db.Employees_Take_Leaves.Where(s => s.emp_code == checkLeaveViewModel.code).ToList(); var getLeaveTypes = db.Leaves.Select(row => row).ToList(); var getNameRow = db.Employees.FirstOrDefault(s => s.code == checkLeaveViewModel.code); checkLeaveModel.code = getRow.code; checkLeaveModel.name = getNameRow.name; checkLeaveModel.maternity_leave_count_left = getRow.maternity_leave_count_left; checkLeaveModel.paternity_leave_count_left = getRow.paternity_leave_count_left; checkLeaveModel.child_adoption_leave_count_left = getRow.child_adoption_leave_count_left; checkLeaveModel.absentDays = 0; for (int i = 0; i < getTotalAbsentRows.Count(); i++) { checkLeaveModel.absentDays += getTotalAbsentRows[i].absent_days; } /* * for (int i = 0; i < getLeaveTypes.Count(); i++) * { * for (int j = 0; j < getLeaveDetails.Count(); j++) * { * if (getLeaveDetails[j].leave_id == getLeaveTypes[i].id) * { * Employees_Take_Leaves etl = new Employees_Take_Leaves(); * etl.emp_code = getLeaveDetails[j].emp_code; * etl.leave_id = getLeaveDetails[j].leave_id; * etl.date_from = getLeaveDetails[j].date_from; * etl.date_to = getLeaveDetails[j].date_to; * etl.financial_year_start = getLeaveDetails[j].financial_year_start; * etl.financial_year_end = getLeaveDetails[j].financial_year_end; * etl.absent_days = getLeaveDetails[j].absent_days; * etlList.Add(etl); * //checkLeaveModel.persistantObjects.Add(etl); * } * } * } */ return(RedirectToAction("GetLeaveCounts", "CheckLeave", checkLeaveModel)); }
public ActionResult GetLeaveCounts(CheckLeaveModel checkLeaveModel) { return(View(checkLeaveModel)); }