public SourceofApplicationViewModel SetRecordinEdit(Mst_SourceofApplication tblsource) { SourceofApplicationViewModel source = new SourceofApplicationViewModel(); source.ID = tblsource.Soa_Id; source.EditID = tblsource.Soa_Id; source.SourceName = tblsource.Soa_Name; source.SourceCategory = tblsource.Soa_Category; source.SourceStatus = tblsource.Soa_Status; return(source); }
public ActionResult GetSourceApplicationById(int ID) { string operation = Session["Operation"].ToString(); ButtonVisiblity(operation); Mst_SourceofApplication tblsource = dd._context.Mst_SourceofApplication.Where(x => x.Soa_Id == ID).FirstOrDefault(); SourceofApplicationViewModel source = new SourceofApplicationViewModel(); source.ID = tblsource.Soa_Id; source.EditID = tblsource.Soa_Id; source.SourceName = tblsource.Soa_Name; source.SourceCategory = (short)tblsource.Soa_Category; source.SourceStatus = (short)tblsource.Soa_Status; source.operation = operation; return(View("SourceApplication", source)); }
//[ValidateAntiForgeryToken] public JsonResult CreateEdit(SourceofApplicationViewModel source) { source.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); source.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); Mst_SourceofApplication tblSource = new Mst_SourceofApplication(); try { source.ID = dd._context.Mst_SourceofApplication.Any() ? dd._context.Mst_SourceofApplication.Max(m => m.Soa_Id) + 1 : 1; if (source.EditID <= 0) { var data = dd._context.Mst_SourceofApplication.Where(u => u.Soa_Name == source.SourceName && u.Soa_Status == 1).Select(x => x.Soa_Name).FirstOrDefault(); if (data != null) { ModelState.AddModelError("SourceName", "Source Name Already Exists"); return(Json(source)); } tblSource.Soa_Id = source.ID; tblSource.Soa_RecordCreated = DateTime.Now; tblSource.Soa_RecordCreatedBy = source.CreatedBy; dd._context.Mst_SourceofApplication.Add(tblSource); } else { tblSource = dd._context.Mst_SourceofApplication.Where(x => x.Soa_Id == source.ID).FirstOrDefault(); } tblSource.Soa_Name = source.SourceName; tblSource.Soa_Category = source.SourceCategory; tblSource.Soa_Status = source.SourceStatus; tblSource.Soa_RecordUpdated = DateTime.Now; tblSource.Soa_RecordUpdatedBy = source.UpdatedBy; dd._context.SaveChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } return(Json(source)); }
public void SaveUpdateRecord(SourceofApplicationViewModel source) { Mst_SourceofApplication tblSource = new Mst_SourceofApplication(); if (source.EditID <= 0) { source.ID = _context.Mst_SourceofApplication.Any() ? _context.Mst_SourceofApplication.Max(m => m.Soa_Id) + 1 : 1; tblSource.Soa_Id = source.ID; tblSource.Soa_RecordCreated = DateTime.Now; tblSource.Soa_RecordCreatedBy = source.CreatedBy; _context.Mst_SourceofApplication.Add(tblSource); } else { tblSource = _context.Mst_SourceofApplication.Where(x => x.Soa_Id == source.ID).FirstOrDefault(); } tblSource.Soa_Name = source.SourceName; tblSource.Soa_Category = source.SourceCategory; tblSource.Soa_Status = source.SourceStatus; tblSource.Soa_RecordUpdated = DateTime.Now; tblSource.Soa_RecordUpdatedBy = source.UpdatedBy; _context.SaveChanges(); }
public SourceofApplicationViewModel SetDataOnEdit(Mst_SourceofApplication tblsource) { var item = _sourceRepository.SetRecordinEdit(tblsource); return(item); }