public bool InsertData(AuditCheckListViewModel audit) { bool retVal = false; audit.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); audit.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); Mst_AuditCheckList tblAudit = new Mst_AuditCheckList(); try { if (audit.ID <= 0) { tblAudit.Acl_RecordCreated = DateTime.Now; tblAudit.Acl_RecordCreatedBy = audit.CreatedBy; dd._context.Mst_AuditCheckList.Add(tblAudit); } else { tblAudit = dd._context.Mst_AuditCheckList.Where(x => x.Acl_Id == audit.ID).FirstOrDefault(); } tblAudit.Acl_EffectiveDate = audit.EffectiveDate; tblAudit.Acl_Categoryofaudit = audit.CategoryAudit; tblAudit.Acl_CheckPoint = audit.AuditCheckPoint; tblAudit.Acl_Status = audit.Status; tblAudit.Acl_RecordUpdated = DateTime.Now; tblAudit.Acl_RecordUpdatedBy = audit.UpdatedBy; dd._context.SaveChanges(); retVal = true; } catch (Exception ex) { throw ex; } return(retVal); }
//[ValidateAntiForgeryToken] public JsonResult CreateEdit(AuditCheckListViewModel audit) { audit.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); audit.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); Mst_AuditCheckList tblAudit = new Mst_AuditCheckList(); try { if (audit.ID <= 0) { tblAudit.Acl_RecordCreated = DateTime.Now; tblAudit.Acl_RecordCreatedBy = audit.CreatedBy; dd._context.Mst_AuditCheckList.Add(tblAudit); } else { tblAudit = dd._context.Mst_AuditCheckList.Where(x => x.Acl_Id == audit.ID).FirstOrDefault(); } tblAudit.Acl_EffectiveDate = audit.EffectiveDate; tblAudit.Acl_Categoryofaudit = audit.CategoryAudit; tblAudit.Acl_CheckPoint = audit.AuditCheckPoint; tblAudit.Acl_Status = audit.Status; tblAudit.Acl_RecordUpdated = DateTime.Now; tblAudit.Acl_RecordUpdatedBy = audit.UpdatedBy; dd._context.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } return(Json(audit)); }
public ActionResult Insert(AuditCheckListViewModel objViewModel) { ModelState.Remove("Id"); if (objViewModel.ID == 0) { //_employeeService.AddEmployee(objViewModel); if (InsertData(objViewModel)) { return(Json(1, JsonRequestBehavior.AllowGet)); } else { return(Json(3, JsonRequestBehavior.AllowGet)); } } else { if (InsertData(objViewModel)) { return(Json(2, JsonRequestBehavior.AllowGet)); } } return(View("Index", objViewModel)); }
public AuditCheckListViewModel SetRecordinEdit(Mst_AuditCheckList tblAudit) { var audit = new AuditCheckListViewModel(); audit.ID = tblAudit.Acl_Id; audit.EffectiveDate = tblAudit.Acl_EffectiveDate.ToShortDateString(); audit.CategoryAudit = tblAudit.Acl_Categoryofaudit; audit.AuditCheckPoint = tblAudit.Acl_CheckPoint; audit.Status = tblAudit.Acl_Status; return(audit); }
public ActionResult CreateEdit(AuditCheckListViewModel audit) { audit.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); audit.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); try { _auditService.SaveUpdateRecord(audit); } catch (Exception ex) { throw ex; } return(Json(audit)); }
public ActionResult GetAuditCheckListById(int ID) { string operation = Session["Operation"].ToString(); ButtonVisiblity(operation); Mst_AuditCheckList tblAudit = dd._context.Mst_AuditCheckList.Where(x => x.Acl_Id == ID).FirstOrDefault(); var audit = new AuditCheckListViewModel(); audit.ID = tblAudit.Acl_Id; audit.EffectiveDate = tblAudit.Acl_EffectiveDate; audit.CategoryAudit = tblAudit.Acl_Categoryofaudit; audit.AuditCheckPoint = tblAudit.Acl_CheckPoint; audit.Status = tblAudit.Acl_Status; audit.operation = operation; return(View("AuditCheckList", audit)); }
public ActionResult GetAuditCheckListById(int ID) { string operation = Session["Operation"].ToString(); ButtonVisiblity(operation); var audit = new AuditCheckListViewModel(); var tblAudit = _auditService.GetAuditCheckListById(ID); if (tblAudit != null) { audit = _auditService.SetDataOnEdit(tblAudit); } audit.operation = operation; ViewBag.AuditCategoryList = new SelectList(_auditService.GetAuditCategoryList(), "Id", "Name"); return(View("AuditCheckList", audit)); }
public List <AuditCheckListViewModel> SetDataofModalList() { List <AuditCheckListViewModel> list = new List <AuditCheckListViewModel>(); var model = new AuditCheckListViewModel(); var tablelist = _context.Mst_AuditCheckList.ToList(); foreach (var item in tablelist) { model = new AuditCheckListViewModel(); model.ID = item.Acl_Id; model.EffectiveDate = item.Acl_EffectiveDate.ToShortDateString(); model.CategoryAuditStr = _context.Mst_AuditCategory.Where(x => x.Id == item.Acl_Categoryofaudit).Select(x => x.Name).FirstOrDefault(); model.AuditCheckPoint = item.Acl_CheckPoint; model.Status = item.Acl_Status; list.Add(model); } return(list); }
public ActionResult GetAuditCheckListTable(string Operation) { Session["Operation"] = Operation; List <AuditCheckListViewModel> list = new List <AuditCheckListViewModel>(); var model = new AuditCheckListViewModel(); var tablelist = dd._context.Mst_AuditCheckList.ToList(); foreach (var item in tablelist) { model = new AuditCheckListViewModel(); model.ID = item.Acl_Id; model.EffectiveDate = item.Acl_EffectiveDate; model.CategoryAuditStr = GetCategoryAudit(item.Acl_Categoryofaudit); model.AuditCheckPoint = item.Acl_CheckPoint; model.StatusStr = item.Acl_Status == 1 ? "Active" : "Inacitve"; list.Add(model); } return(PartialView("_AuditCheckList", list)); }
public void SaveUpdateRecord(AuditCheckListViewModel audit) { Mst_AuditCheckList tblAudit = new Mst_AuditCheckList(); if (audit.ID <= 0) { tblAudit.Acl_RecordCreated = DateTime.Now; tblAudit.Acl_RecordCreatedBy = audit.CreatedBy; _context.Mst_AuditCheckList.Add(tblAudit); } else { tblAudit = _context.Mst_AuditCheckList.Where(x => x.Acl_Id == audit.ID).FirstOrDefault(); } tblAudit.Acl_EffectiveDate = Convert.ToDateTime(audit.EffectiveDate); tblAudit.Acl_Categoryofaudit = audit.CategoryAudit; tblAudit.Acl_CheckPoint = audit.AuditCheckPoint; tblAudit.Acl_Status = audit.Status; tblAudit.Acl_RecordUpdated = DateTime.Now; tblAudit.Acl_RecordUpdatedBy = audit.UpdatedBy; _context.SaveChanges(); }
public void SaveUpdateRecord(AuditCheckListViewModel model) { _auditRepository.SaveUpdateRecord(model); }