public void SaveUpdateRecord(PenaltySlabViewModel penalty) { Mst_PenaltySlab tblPenaltySlab = new Mst_PenaltySlab(); try { if (penalty.EditID <= 0) { penalty.ID = _context.Mst_PenaltySlab.Any() ? _context.Mst_PenaltySlab.Max(m => m.Ps_Id) + 1 : 1; tblPenaltySlab.Ps_Id = penalty.ID; tblPenaltySlab.Ps_RecordCreated = DateTime.Now; tblPenaltySlab.Ps_RecordCreatedBy = penalty.CreatedBy; _context.Mst_PenaltySlab.Add(tblPenaltySlab); } else { tblPenaltySlab = _context.Mst_PenaltySlab.Where(x => x.Ps_Id == penalty.ID).FirstOrDefault(); } tblPenaltySlab.Ps_Datewef = Convert.ToDateTime(penalty.Datewef); tblPenaltySlab.Ps_Penalty = penalty.PenaltyAmount; tblPenaltySlab.Ps_Accounthead = penalty.AccountHead; tblPenaltySlab.Ps_RecordUpdated = DateTime.Now; tblPenaltySlab.Ps_RecordUpdatedBy = penalty.UpdatedBy; _context.SaveChanges(); } catch (Exception ex) { throw ex; } }
public ActionResult PenaltySlab() { ButtonVisiblity("Index"); var model = new PenaltySlabViewModel(); model.ID = _penaltySlabService.GetMaxPkNo(); ViewBag.AccountHeadList = new SelectList(_penaltySlabService.GetAccountHeadList(), "AccountID", "Name"); return(View(model)); }
public ActionResult PenaltySlab() { ButtonVisiblity("Index"); var model = new PenaltySlabViewModel(); model.ID = dd._context.Mst_PenaltySlab.Any() ? dd._context.Mst_PenaltySlab.Max(m => m.Ps_Id) + 1 : 1; ViewBag.AccountHeadList = new SelectList(dd._context.tblaccountmasters.ToList(), "AccountID", "Name"); return(View(model)); }
public PenaltySlabViewModel SetRecordinEdit(Mst_PenaltySlab tblPenalty) { PenaltySlabViewModel penalty = new PenaltySlabViewModel(); penalty.ID = tblPenalty.Ps_Id; penalty.EditID = tblPenalty.Ps_Id; penalty.Datewef = tblPenalty.Ps_Datewef.ToString("dd/MM/yyyy"); penalty.PenaltyAmount = tblPenalty.Ps_Penalty; penalty.AccountHead = tblPenalty.Ps_Accounthead; return(penalty); }
public JsonResult CreateEdit(PenaltySlabViewModel penalty) { penalty.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); penalty.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); try { _penaltySlabService.SaveUpdateRecord(penalty); } catch (Exception ex) { throw new Exception(ex.Message); } return(Json(penalty)); }
public ActionResult GetPenaltySlabById(int ID) { string operation = Session["Operation"].ToString(); ButtonVisiblity(operation); ViewBag.AccountHeadList = new SelectList(_penaltySlabService.GetAccountHeadList(), "AccountID", "Name"); var penalty = new PenaltySlabViewModel(); var tblPenalaty = _penaltySlabService.GetPenaltySlabById(ID); if (tblPenalaty != null) { penalty = _penaltySlabService.SetDataOnEdit(tblPenalaty); } return(View("PenaltySlab", penalty)); }
public ActionResult GetPenaltySlabById(int ID) { string operation = Session["Operation"].ToString(); ButtonVisiblity(operation); ViewBag.AccountHeadList = new SelectList(dd._context.tblaccountmasters.ToList(), "AccountID", "Name"); Mst_PenaltySlab tblPenalty = dd._context.Mst_PenaltySlab.Where(x => x.Ps_Id == ID).FirstOrDefault(); PenaltySlabViewModel penalty = new PenaltySlabViewModel(); penalty.ID = tblPenalty.Ps_Id; penalty.EditID = tblPenalty.Ps_Id; penalty.Datewef = tblPenalty.Ps_Datewef.ToString("dd/MM/yyyy"); penalty.PenaltyAmount = tblPenalty.Ps_Penalty; penalty.AccountHead = tblPenalty.Ps_Accounthead; penalty.operation = operation; return(View("PenaltySlab", penalty)); }
public List <PenaltySlabViewModel> SetDataofModalList() { List <PenaltySlabViewModel> list = new List <PenaltySlabViewModel>(); var model = new PenaltySlabViewModel(); var tablelist = _context.Mst_PenaltySlab.ToList(); foreach (var item in tablelist) { model = new PenaltySlabViewModel(); model.Datewef = item.Ps_Datewef.ToString("dd/MM/yyyy"); model.EditID = item.Ps_Id; model.ID = item.Ps_Id; model.PenaltyAmount = item.Ps_Penalty; model.AccountHeadStr = _context.tblaccountmasters.Where(x => x.AccountID == item.Ps_Accounthead).Select(x => x.Name).FirstOrDefault(); list.Add(model); } return(list); }
public ActionResult GetPenaltySlabTable(string Operation) { Session["Operation"] = Operation; List <PenaltySlabViewModel> list = new List <PenaltySlabViewModel>(); var model = new PenaltySlabViewModel(); var tablelist = dd._context.Mst_PenaltySlab.ToList(); foreach (var item in tablelist) { model = new PenaltySlabViewModel(); model.Datewef = item.Ps_Datewef.ToString("dd/MM/yyyy"); model.EditID = item.Ps_Id; model.ID = item.Ps_Id; model.PenaltyAmount = item.Ps_Penalty; model.AccountHeadStr = dd._context.tblaccountmasters.Where(x => x.AccountID == item.Ps_Accounthead).Select(x => x.Name).FirstOrDefault(); list.Add(model); } return(PartialView("_PenaltySlablist", list)); }
public ActionResult Insert(PenaltySlabViewModel objViewModel) { ModelState.Remove("Id"); if (objViewModel.ID == 0) { 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 bool InsertData(PenaltySlabViewModel penalty) { bool retVal = false; penalty.CreatedBy = Convert.ToInt32(Session["UserLoginId"]); penalty.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]); Mst_PenaltySlab tblPenaltySlab = new Mst_PenaltySlab(); try { if (penalty.EditID <= 0) { penalty.ID = dd._context.Mst_PenaltySlab.Any() ? dd._context.Mst_PenaltySlab.Max(m => m.Ps_Id) + 1 : 1; tblPenaltySlab.Ps_Id = penalty.ID; tblPenaltySlab.Ps_RecordCreated = DateTime.Now; tblPenaltySlab.Ps_RecordCreatedBy = penalty.CreatedBy; dd._context.Mst_PenaltySlab.Add(tblPenaltySlab); } else { tblPenaltySlab = dd._context.Mst_PenaltySlab.Where(x => x.Ps_Id == penalty.ID).FirstOrDefault(); } tblPenaltySlab.Ps_Datewef = Convert.ToDateTime(penalty.Datewef); tblPenaltySlab.Ps_Penalty = penalty.PenaltyAmount; tblPenaltySlab.Ps_Accounthead = penalty.AccountHead; tblPenaltySlab.Ps_RecordUpdated = DateTime.Now; tblPenaltySlab.Ps_RecordUpdatedBy = penalty.UpdatedBy; dd._context.SaveChanges(); retVal = true; } catch (Exception ex) { throw ex; } return(retVal); }
public void SaveUpdateRecord(PenaltySlabViewModel model) { _penaltyslabRepository.SaveUpdateRecord(model); }