public void EditRows()
{
var gridModel = new LeasingDatabase.Models.Grid.DepartmentJqGridModel();
var db = new AuleaseEntities();
var e = gridModel.OrdersGrid.GetEditData(); // Edit Row
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow)
{
int _Id = Convert.ToInt32(e.RowData["Id"]);
Department dept = db.Departments.Where(n => n.Id == _Id).Single();
string _Fund = e.RowData["Fund"].ToString();
string _Org = e.RowData["Org"].ToString();
string _Program = e.RowData["Program"].ToString();
string _Name = e.RowData["Name"].ToString();
dept.Name = _Name;
dept.Fund = _Fund;
dept.Org = _Org;
dept.Program = _Program;
db.SaveChanges();
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.AddRow)
{
// Add
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.DeleteRow)
{
// Not gonna allow deleting of rates
throw new NotImplementedException();
}
}
//
// GET: /Department/
public ActionResult Index()
{
var gridModel = new LeasingDatabase.Models.Grid.DepartmentJqGridModel();
var ordersGrid = gridModel.OrdersGrid;
SetUpGrid(ordersGrid);
return(View(gridModel));
}
public JsonResult DataRequested()
{
var gridModel = new LeasingDatabase.Models.Grid.DepartmentJqGridModel();
var db = new AuleaseEntities();
SetUpGrid(gridModel.OrdersGrid);
DateTime date = DateTime.Now.AddMonths(-3);
var depts = db.Departments.Where(n => (n.Leases.Where(o => o.EndDate > date).Count() > 0));
var model = depts.Select(n => new DepartmentModel
{
Id = n.Id,
Name = n.Name,
Fund = n.Fund,
Org = n.Org,
Program = n.Program
});
return(gridModel.OrdersGrid.DataBind(model));
}
