public ActionResult AddLegderGroup(Ledgergroupmodel model) { var Data = obj.SaveLedgerGroup(model); TempData["Error"] = Data; return(RedirectToAction("Index")); }
public List <Ledgergroupmodel> ShowAllLedgerGroupList() { List <Ledgergroupmodel> List = new List <Ledgergroupmodel>(); var data = _entities.tblLedgerGroups.ToList(); foreach (var item in data) { Ledgergroupmodel model = new Ledgergroupmodel(); model.CategoryName = item.tblLedgerCategory.LedgerCategoryName; model.GroupName = item.LedgerGroupName; model.RecordId = item.LedgerGroupId; List.Add(model); } return(List); }
public Ledgergroupmodel EditLedgerGroupModel(int Id) { Ledgergroupmodel model = new Ledgergroupmodel(); if (Id != 0) { var data = _entities.tblLedgerGroups.Where(x => x.LedgerGroupId == Id).SingleOrDefault(); model.GroupName = data.LedgerGroupName; model.CategoryId = data.CategoryId; model.CategoryName = data.tblLedgerCategory.LedgerCategoryName; model.RecordId = data.LedgerGroupId; return(model); } else { return(model); } }
public string SaveLedgerGroup(Ledgergroupmodel model) { tblLedgerGroup tb = new tblLedgerGroup(); var duplicate = _entities.tblLedgerGroups.Where(o => o.LedgerGroupName.Equals(model.GroupName) && o.CategoryId.Equals(model.CategoryId)).SingleOrDefault(); if (duplicate == null) { try { if (model.RecordId != 0) { tb = _entities.tblLedgerGroups.Where(x => x.LedgerGroupId == model.RecordId).SingleOrDefault(); tb.LedgerGroupName = model.GroupName; tb.CategoryId = model.CategoryId; _entities.SaveChanges(); return("Record Updated Successfully..."); } else { tb.LedgerGroupName = model.GroupName; tb.CategoryId = model.CategoryId; _entities.tblLedgerGroups.Add(tb); _entities.SaveChanges(); return("Record Saved Successfully..."); } } catch (Exception ex) { return(ex.Message); } } else { return(model.GroupName + " Already Exits"); } }