//[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 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);
}
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 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 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 AuditCheckListViewModel SetDataOnEdit(Mst_AuditCheckList tblAudit)
{
var item = _auditRepository.SetRecordinEdit(tblAudit);
return(item);
}
