//-----------------------------Add Edit----------------------------
public ActionResult AddEdit(int Id)
{
LaunSysDBEntities db = new LaunSysDBEntities();
List <tb_Branch> BranchList = db.tb_Branch.ToList();
ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname");
List <tb_Status> StatusList = db.tb_Status.ToList();
ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status");
//initialize the View model responsible for the Editing
//To get the record that is to be edited
IncomesViewModel Model = new IncomesViewModel();
if (Id > 0)
{
tb_Income Income = db.tb_Income.SingleOrDefault(x => x.Id == Id && x.tb_Status.Status == true);
Model.Id = Income.Id;
Model.Date = Income.Date;
Model.Inc_SN = Income.Inc_SN;
Model.Description = Income.Description;
Model.Inv_No = Income.Inv_No;
Model.Amount = Income.Amount;
Model.BranchId = Income.BranchId;
Model.StatusId = Income.StatusId;
}
return(PartialView("AddEditViewPartialView", Model));
}
public ActionResult Index(IncomesViewModel Model)
{
try
{
//LaunSysDBEntities db = new LaunSysDBEntities();
//if (ModelState.IsValid == true)
//{
//------------------------To populate the drop down lists---------------------------
//List<tb_Branch> BranchList = db.tb_Branch.ToList();
//ViewBag.VBranchLists = new SelectList(BranchList, "BranchId", "Branchname");
//List<tb_Status> StatusList = db.tb_Status.ToList();
//ViewBag.VStatusLists = new SelectList(StatusList, "StatusId", "Status");
AllDropDown();
////----------------------------------------------------------------------------------
if (Model.Id > 0)
{
//UPDATE EXISTING RECORD
tb_Income IncomeData = db.tb_Income.SingleOrDefault(x => x.Id == Model.Id && x.tb_Status.Status == true);
IncomeData.Id = Model.Id;
IncomeData.Date = Model.Date;
IncomeData.Inc_SN = Model.Inc_SN;
IncomeData.Description = Model.Description;
IncomeData.Inv_No = Model.Inv_No;
IncomeData.Amount = Model.Amount;
IncomeData.BranchId = Model.BranchId;
IncomeData.StatusId = Model.StatusId;
db.SaveChanges();
}
else
{
//INSERT NEW RECORD
tb_Income IncomeData = new tb_Income();
IncomeData.Id = Model.Id;
IncomeData.Date = Model.Date;
IncomeData.Inc_SN = Model.Inc_SN;
IncomeData.Description = Model.Description;
IncomeData.Inv_No = Model.Inv_No;
IncomeData.Amount = Model.Amount;
IncomeData.BranchId = Model.BranchId;
IncomeData.StatusId = Model.StatusId;
db.tb_Income.Add(IncomeData);
db.SaveChanges();
}
return(View(Model));
//}
}
catch (Exception ex)
{
throw ex;
}
}
public static void Save(IncomesViewModel model)
{
using (var db = new ShlekenEntities3())
{
if (model.Id > 0)
{
var item = db.Incomes.Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == model.Id);
item = model.Map <IncomesViewModel, Incomes>(item);
db.SaveChanges();
}
else
{
var item = model.Map <IncomesViewModel, Incomes>();
db.Incomes.Add(item);
db.SaveChanges();
}
}
}