public ActionResult DeleteConfirmed(string id) { Employees_Other_Leave_Counts eolc = db.Employees_Other_Leave_Counts.Find(id); if (eolc != null) { db.Employees_Other_Leave_Counts.Remove(eolc); db.SaveChanges(); } var etl = db.Employees_Take_Leaves.Where(s => s.emp_code == id).ToList(); for (int i = 0; i < etl.Count(); i++) { Employees_Take_Leaves obj = db.Employees_Take_Leaves.Find(etl[i].id); db.Employees_Take_Leaves.Remove(obj); db.SaveChanges(); } Employee employee = db.Employees.Find(id); db.Employees.Remove(employee); db.SaveChanges(); return(RedirectToAction("Index")); }
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 Create([Bind(Include = "code,name,post_id,block_id,type_of_institute_id,posting_place_id,gender")] Employee employee) { if (ModelState.IsValid) { employee.code = "NHM" + employee.code; db.Employees.Add(employee); db.SaveChanges(); Employees_Other_Leave_Counts elc = new Employees_Other_Leave_Counts(); elc.code = employee.code; // granted to employee in a lifetime basis elc.maternity_leave_count_left = 2; elc.paternity_leave_count_left = 2; elc.child_adoption_leave_count_left = 2; db.Employees_Other_Leave_Counts.Add(elc); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(employee)); }