public JsonResult DataRequested() { string Fund = Session["Fund"].ToString(); string Org = Session["Org"].ToString(); string Program = Session["Program"].ToString(); var gridModel = new LeasingDatabase.Models.Grid.BillingCoordinatorJqGridModel(); var db = new AuleaseEntities(); SetUpGrid(gridModel.OrdersGrid); var dept = db.Departments.Where(n => n.Fund == Fund && n.Org == Org && n.Program == Program).Single(); var users = dept.Coordinators; var model = users.Select(n => new BillingCoordinatorModel { Id = n.Id.ToString(), GID = n.GID, Fund = Fund, BillingAccess = n.BillingAccess, Org = Org, Program = Program }).AsQueryable(); return(gridModel.OrdersGrid.DataBind(model)); }
public ActionResult FOP(string Fund, string Org, string Program) { Session["Fund"] = Fund; Session["Org"] = Org; Session["Program"] = Program; AuleaseEntities db = new AuleaseEntities(); int count = db.Departments.Where(n => n.Fund == Fund && n.Org == Org && n.Program == Program).Count(); if (count < 1) { ViewBag.error = "No Department Found"; return(RedirectToAction("Index")); } else if (count > 1) { ViewBag.error = "Duplicate Departments found...this is a serious issue that needs to be resolved right away"; return(RedirectToAction("Index")); } var gridModel = new LeasingDatabase.Models.Grid.BillingCoordinatorJqGridModel(); var ordersGrid = gridModel.OrdersGrid; SetUpGrid(ordersGrid); return(View(gridModel)); }
public void EditRows() { string Fund = Session["Fund"].ToString(); string Org = Session["Org"].ToString(); string Program = Session["Program"].ToString(); var gridModel = new LeasingDatabase.Models.Grid.BillingCoordinatorJqGridModel(); var db = new AuleaseEntities(); var e = gridModel.OrdersGrid.GetEditData(); // Edit Row if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { // Not gonna allow editing, just adding and deleting throw new NotImplementedException(); } if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.AddRow) { string GID = e.RowData["GID"]; bool BillingAccess = Convert.ToBoolean(e.RowData["BillingAccess"]); Coordinator user; if (db.Coordinators.Any(n => n.GID == GID)) { user = db.Coordinators.Where(n => n.GID == GID).Single(); } else { user = new Coordinator(); user.BillingAccess = BillingAccess; user.GID = GID; } Department dept; if (!db.Departments.Any(n => n.Fund == Fund && n.Org == Org && n.Program == Program)) { Department newDept = new Department(); newDept.Fund = Fund; newDept.Org = Org; newDept.Program = Program; newDept.Name = "New Department"; db.Departments.Add(newDept); db.SaveChanges(); } dept = db.Departments.Where(n => n.Fund == Fund && n.Org == Org && n.Program == Program).Single(); dept.Coordinators.Add(user); db.SaveChanges(); } if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.DeleteRow) { int Id = Convert.ToInt32(e.RowData["Id"]); var dept = db.Departments.Where(n => n.Fund == Fund && n.Org == Org && n.Program == Program).Single(); Coordinator user = db.Coordinators.Where(n => n.Id == Id).Single(); dept.Coordinators.Remove(user); db.SaveChanges(); } }
/* * Above is JQGrid for BillingCoordinators to a FOP, Below is JQGrid for FOPs to a BillingCoordinator */ public ActionResult GID(string GID) { Session["GID"] = GID; var gridModel = new LeasingDatabase.Models.Grid.BillingCoordinatorJqGridModel(); var ordersGrid = gridModel.OrdersGrid; GIDSetUpGrid(ordersGrid); return(View(gridModel)); }
public JsonResult GIDDataRequested() { string GID = Session["GID"].ToString(); var gridModel = new LeasingDatabase.Models.Grid.BillingCoordinatorJqGridModel(); var db = new AuleaseEntities(); SetUpGrid(gridModel.OrdersGrid); bool BillingAccess = (db.Coordinators.Where(n => n.GID == GID).Count() > 0) ? db.Coordinators.Where(n => n.GID == GID).Single().BillingAccess : false; var dept = db.Coordinators.Where(n => n.GID == GID).SelectMany(n => n.Departments); var model = dept.Select(n => new BillingCoordinatorModel { Id = GID + "-" + n.Fund + "-" + n.Org + "-" + n.Program, GID = GID, Fund = n.Fund, Org = n.Org, Program = n.Program, BillingAccess = BillingAccess }).AsQueryable(); return(gridModel.OrdersGrid.DataBind(model)); }
public void GIDEditRows() { var gridModel = new LeasingDatabase.Models.Grid.BillingCoordinatorJqGridModel(); var db = new AuleaseEntities(); var e = gridModel.OrdersGrid.GetEditData(); // Edit Row if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { // Not gonna allow editing, just adding and deleting throw new NotImplementedException(); } if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.AddRow) { string Fund = e.RowData["Fund"].ToString().Trim(); string Org = e.RowData["Org"].ToString().Trim(); string Program = e.RowData["Program"].ToString().Trim(); string GID = e.RowData["GID"].ToString().Trim(); Session["GID"] = GID; bool BillingAccess = Convert.ToBoolean(e.RowData["BillingAccess"]); if (!db.Departments.Any(n => n.Fund == Fund && n.Org == Org && n.Program == Program)) { Department newDept = new Department(); newDept.Fund = Fund; newDept.Org = Org; newDept.Program = Program; newDept.Name = "New Department"; db.Departments.Add(newDept); db.SaveChanges(); } if (!db.Coordinators.Any(n => n.GID == GID)) { Coordinator newCoordinator = new Coordinator(); newCoordinator.BillingAccess = BillingAccess; newCoordinator.GID = GID; db.Coordinators.Add(newCoordinator); db.SaveChanges(); } Coordinator user = db.Coordinators.Where(n => n.GID == GID).Single(); var dept = db.Departments.Where(n => n.Fund == Fund && n.Org == Org && n.Program == Program).Single(); dept.Coordinators.Add(user); db.SaveChanges(); } if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.DeleteRow) { string[] array = e.RowData["Id"].ToString().Split('-'); string GID = array[0]; Session["GID"] = GID; string Fund = array[1]; string Org = array[2]; string Program = array[3]; var dept = db.Departments.Where(n => n.Fund == Fund && n.Org == Org && n.Program == Program).Single(); Coordinator user = db.Coordinators.Where(n => n.GID == GID).Single(); dept.Coordinators.Remove(user); db.SaveChanges(); } }