public List<ReplacementViewModel> ReplacementIndex() { EmployeeRepository empRepo = new EmployeeRepository(); var replacementList = entity.tblReplacements.ToList(); var replacementListfromtabletwo = entity.tblListofDbforReplacements.ToList(); List<ReplacementViewModel> ReplacementList = new List<ReplacementViewModel>(); foreach(var replacementItem in replacementList) { ReplacementViewModel replacementModel = new ReplacementViewModel() { regularId = replacementItem.regularId, replacementReason=replacementItem.Reason, approver=replacementItem.tblApprover.approverName, replaceId = replacementItem.replacingId, todate=replacementItem.ToDate, fromdate=replacementItem.FromDate, approverId=replacementItem.approverId }; replacementModel.ReplacingEmployee = empRepo.ListOfEmployees().Where( x => x.employeeId == replacementItem.replacingId).FirstOrDefault().EmployeeName; replacementModel.RegularEmployee = empRepo.ListOfEmployees().Where(x => x.employeeId == replacementItem.regularId).FirstOrDefault().EmployeeName; ReplacementList.Add(replacementModel); } return ReplacementList; }
// // GET: /Replacement/Create public ActionResult Create() { ReplacementViewModel replaceModel = new ReplacementViewModel(); replaceModel.Regular_Employee = dropRepo.EmployeesDrop(); replaceModel.Replacing_Employee = dropRepo.EmployeesDrop(); replaceModel.ApproverList = dropRepo.ApproverDropDown(); return View(replaceModel); }
public ActionResult Create(ReplacementViewModel replacementModel) { try { // TODO: Add insert logic here replacementRepo.AddReplacementRecord(replacementModel); return RedirectToAction("ReplacementRecords","Replacement"); } catch { return View(); } }
public void AddReplacementRecord(ReplacementViewModel modelObj) { tblReplacement newReplacement = new tblReplacement() { replacementId= modelObj.replacementId, regularId=modelObj.regularId, replacingId=modelObj.replaceId, Reason=modelObj.replacementReason, approverId=modelObj.approverId, FromDate=modelObj.fromdate, ToDate=modelObj.todate, }; entity.tblReplacements.Add(newReplacement); entity.SaveChanges(); }