public ActionResult CreateLoc() { VMJCApplication vmDemo = new VMJCApplication(); vmDemo.LocEmployees = db.HR_Location.ToList(); vmDemo.TypeEmployees = db.HR_EmpType.ToList(); vmDemo.DeptEmployees = db.HR_Department.ToList(); vmDemo.SecEmployees = db.HR_Section.ToList(); vmDemo.ShiftEmployees = db.Att_Shift.ToList(); ViewBag.JobCardType = new SelectList(db.Att_JobCard.OrderBy(aa => aa.JCName).ToList(), "JCID", "JCName"); return(View(vmDemo)); }
public ActionResult SelectEmployee(FormCollection form) { try { string ErrorMessage = ""; List <EmpView> emps = new List <EmpView>(); ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp; emps = db.EmpViews.Where(aa => aa.Status == "Active").ToList(); List <EmpView> ViewEmps = new List <EmpView>(); List <EmpView> tempEmps = new List <EmpView>(); VMJCApplication vm = new VMJCApplication(); ViewEmps = emps.ToList(); vm.CardType = Request.Form["JobCardType"].ToString(); vm.DateEnded = Convert.ToDateTime(Request.Form["JobDateTo"]); vm.JCValue = Convert.ToInt32(Request.Form["JCValue"]); vm.DateStarted = Convert.ToDateTime(Request.Form["JobDateFrom"]); if (Request.Form["SelectionRB"].ToString() == "rbAll") { ViewEmps = emps.ToList(); vm.JCCriteria = "A"; } else { var checkedLoc = form.GetValues("cbLocation"); List <HR_Location> locs = new List <HR_Location>(); locs = db.HR_Location.ToList(); if (checkedLoc != null) { List <HR_Location> tempLocs = new List <HR_Location>(); foreach (var item in checkedLoc) { short id = Convert.ToInt16(item); tempEmps.AddRange(ViewEmps.Where(aa => aa.LocID == id).ToList()); tempLocs.Add(locs.First(aa => aa.LocID == id)); } ViewEmps = tempEmps.ToList(); vm.LocEmployees = tempLocs; vm.JCCriteria = "L"; } else { tempEmps = ViewEmps.ToList(); tempEmps.Clear(); } // var checkedType = form.GetValues("cbType"); List <HR_EmpType> types = new List <HR_EmpType>(); types = db.HR_EmpType.ToList(); if (checkedType != null) { List <HR_EmpType> tempTypes = new List <HR_EmpType>(); foreach (var item in checkedType) { short id = Convert.ToInt16(item); string name = types.First(aa => aa.TypID == id).TypeName; tempEmps.AddRange(ViewEmps.Where(aa => aa.TypeName == name).ToList()); tempTypes.Add(types.First(aa => aa.TypID == id)); } ViewEmps = tempEmps.ToList(); vm.TypeEmployees = tempTypes; vm.JCCriteria = "T"; } else { tempEmps = ViewEmps.ToList(); tempEmps.Clear(); } // var checkedShift = form.GetValues("cbShift"); List <Att_Shift> shifts = new List <Att_Shift>(); shifts = db.Att_Shift.ToList(); if (checkedShift != null) { List <Att_Shift> tempShifts = new List <Att_Shift>(); tempEmps.Clear(); foreach (var item in checkedShift) { short id = Convert.ToInt16(item); //string name = depts.First(aa => aa.DeptID == id).DeptID; tempEmps.AddRange(ViewEmps.Where(aa => aa.ShftID == id).ToList()); tempShifts.Add(shifts.First(aa => aa.ShftID == id)); } ViewEmps = tempEmps.ToList(); vm.ShiftEmployees = tempShifts; vm.JCCriteria = "H"; } else { tempEmps = ViewEmps.ToList(); } } foreach (var emp in tempEmps.ToList()) { Att_JobCardApp jobCardApp = new Att_JobCardApp(); jobCardApp.JCTypeID = Convert.ToInt16(vm.CardType); jobCardApp.DateCreated = DateTime.Now; jobCardApp.UserID = LoggedInUser.UserID; jobCardApp.DateStarted = vm.DateStarted; jobCardApp.DateEnded = vm.DateEnded; jobCardApp.Status = false; jobCardApp.EmpID = emp.EmployeeID; jobCardApp.TimeBased = false; if (vm.JCValue != null) { jobCardApp.TotalMins = (short)vm.JCValue; } jobCardApp.Remarks = "ByApp"; jobCardApp.StatusID = "Approved"; jobCardApp.ApprovedDate = DateTime.Now; db.Att_JobCardApp.Add(jobCardApp); } db.SaveChanges(); if (ErrorMessage == "") { return(View(vm)); } else { VMJCApplication vmDemo = new VMJCApplication(); vmDemo.LocEmployees = db.HR_Location.ToList(); vmDemo.TypeEmployees = db.HR_EmpType.ToList(); vmDemo.DeptEmployees = db.HR_Department.ToList(); vmDemo.SecEmployees = db.HR_Section.ToList(); vmDemo.ShiftEmployees = db.Att_Shift.ToList(); ViewBag.JobCardType = new SelectList(db.Att_JobCard.OrderBy(aa => aa.JCName).ToList(), "JCID", "JCName"); return(View("Index", vmDemo)); } } catch (Exception) { throw; } }