// GET: AITS_SaleEntry public ActionResult AITS_SaleEntry() { ViewBag.employees = LoadComboBox.LoadAllAITS_Employees(); ViewBag.codes = LoadComboBox.LoadAllAITS_Codes(3); var items = context.AITS_SaleEntry.ToList(); if (items.Count() != 0) { items.ForEach(x => { x.CodeName = context.AITS_Codes.FirstOrDefault(p => p.CodeID == x.CodeID).CodeName; x.EmployeeName = context.AITS_Employee.FirstOrDefault(p => p.EmpID == x.EmployeeID).EmployeeName; }); } ViewBag.SalesEntry = items; var id = context.AITS_SaleEntry.ToList().OrderBy(x => x.ID).LastOrDefault(); if (id != null) { ViewBag.EmpID = id.ID + 1; } else { ViewBag.EmpID = 1; } return(View()); }
// GET: EmployeeDesignation public ActionResult EmployeeDesignation() { ViewBag.FirstCode = LoadComboBox.LoadAllAITS_Codes(1); ViewBag.SecondCode = LoadComboBox.LoadAllAITS_Codes(2); ViewBag.Designation = LoadComboBox.LoadAllAITS_Designation(); var allEmployeeDesg = context.AITS_EmployeeDesignation.ToList(); if (allEmployeeDesg != null) { allEmployeeDesg.ForEach(x => { x.DesignationName = context.AITS_Designations.FirstOrDefault(p => p.ID == x.DesignationID).DesignationName; x.EmployeeName = context.AITS_Employee.FirstOrDefault(p => p.EmpID == x.EmpID).EmployeeName; x.FirstCodeName = context.AITS_Codes.FirstOrDefault(p => p.CodeID == x.FirstCode).CodeName; x.SecondCodeName = context.AITS_Codes.FirstOrDefault(p => p.CodeID == x.SecondCode).CodeName; }); } ViewBag.EmployeeDesignation = allEmployeeDesg; ViewBag.employees = LoadComboBox.LoadAllAITS_Employees(); var id = context.AITS_EmployeeDesignation.ToList().OrderBy(x => x.ID).LastOrDefault(); if (id != null) { ViewBag.ID = id.ID + 1; } else { ViewBag.ID = 1; } return(View()); }