public ActionResult BudgetOrganizationTemplate() { try { using (var db = new StoreContext()) { this.ViewBugs(db); var item = new BudgetOrganization(); return(View("BudgetOrganizationTemplate", item)); } } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "Budget", "BudgetOrganizationTemplate"))); } }
public ActionResult UpdateBudgetOrganization([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <BudgetOrganization> item) { var entities = new List <BudgetOrganization>(); if (ModelState.IsValid) { using (var db = new StoreContext()) { foreach (var itm in item) { Organization organization = db.Organizations.Find(itm.OrganizationId); OrganizationType organizationType = db.OrganizationTypes.Find(organization.OrganizationTypeId); var entity = new BudgetOrganization { BudgetOrganizationId = itm.BudgetOrganizationId, BudgetId = itm.BudgetId, OrganizationId = itm.OrganizationId, BudgetCost = itm.BudgetCost, Budget1 = itm.BudgetCost * organizationType.Budget1, Budget2 = itm.BudgetCost * organizationType.Budget2, Budget3 = itm.BudgetCost * organizationType.Budget3, Id = userId, BudgetLineId = itm.BudgetLineId, ChangeDate = itm.ChangeDate, ChangeBaseId = itm.ChangeBaseId }; entities.Add(entity); db.BudgetOrganizations.Attach(entity); db.Entry(entity).State = EntityState.Modified; } db.SaveChanges(); } } return(Json(entities.ToDataSourceResult(request, ModelState, itm => new BudgetOrganization { BudgetOrganizationId = itm.BudgetOrganizationId, BudgetId = itm.BudgetId, OrganizationId = itm.OrganizationId, BudgetCost = itm.BudgetCost, Budget1 = itm.Budget1, Budget2 = itm.Budget2, Budget3 = itm.Budget3, BudgetLineId = itm.BudgetLineId, ChangeDate = itm.ChangeDate, ChangeBaseId = itm.ChangeBaseId }))); }