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);
}
