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