public void SetDropDowns(SalesOrder user) { ViewBag.Manager = new SelectList(dbUser.GetAllUsers, "ID", "Fullname", user.Manager.ID); ViewBag.BusinessUnit = new SelectList(dbOrg.Fetch, "ID", "Name", user.Organization.ID); ViewBag.Team = new SelectList(dbTeam.Fetch, "ID", "Name", user.Team.ID); }
public ActionResult Edit(SalesOrder updatedData, int id) { SetDropDowns(updatedData); db.Update(updatedData, id); return RedirectToAction("Index"); }
public ActionResult Create(SalesOrder newData) { CreateDropDowns(); db.Insert(newData); return RedirectToAction("Index"); }
// sets parameters for insert/update private Dictionary<string, object> SetParams(SalesOrder data) { Dictionary<string, object> result = new Dictionary<string, object>(); result.Add("@name", data.Name); result.Add("@managerid", data.Manager.ID); result.Add("@businessunitid", data.Organization.ID); result.Add("@positionID", data.Team.ID); result.Add("@status", data.Status); return result; }
public void Update(SalesOrder data, int id) { ExecuteNonQuery(QueryBuilder.Update(_tableName, TargetFields, id, _pkField), SetParams(data)); }
public void Insert(SalesOrder data) { ExecuteNonQuery(QueryBuilder.Insert(_tableName, TargetFields), SetParams(data)); }