public void EditRows()
{
var gridModel = new LeasingDatabase.Models.Grid.OrdersJqGridModel();
var db = new AuleaseEntities();
var e = gridModel.OrdersGrid.GetEditData(); // Edit Row
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow)
{
int Term = Convert.ToInt32(e.RowData["Term"]);
string Type = e.RowData["Type"].ToString();
string RateLevel = e.RowData["RateLevel"].ToString();
decimal Rate = Convert.ToDecimal(e.RowData["Rate"]);
Overhead overhead = new Overhead();
overhead.Term = Term;
overhead.Type = db.Types.Where(n => n.Name == Type).Single();
overhead.RateLevel = RateLevel;
overhead.Rate = Rate;
overhead.BeginDate = DateTime.Now;
db.Overheads.Add(overhead);
db.SaveChanges();
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.AddRow)
{
// Not implemented
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.DeleteRow)
{
// Not gonna allow deleting of rates
throw new NotImplementedException();
}
}
public void EditRows()
{
var gridModel = new LeasingDatabase.Models.Grid.OrdersJqGridModel();
var db = new AuleaseEntities();
var e = gridModel.OrdersGrid.GetEditData(); // Edit Row
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow)
{
int Term = Convert.ToInt32(e.RowData["Term"]);
string Type = e.RowData["RateType"].ToString();
decimal Rate = Convert.ToDecimal(e.RowData["Rate"]);
VendorRate lastRate = db.VendorRates.Where(n => n.Term == Term && n.Type.Name == Type).OrderByDescending(n => n.BeginDate).First();
VendorRate newRate = new VendorRate();
newRate.Type = lastRate.Type;
newRate.Term = lastRate.Term;
newRate.BeginDate = DateTime.Now;
newRate.Rate = Rate;
db.VendorRates.Add(newRate);
db.SaveChanges();
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.AddRow)
{
int Term = Convert.ToInt32(e.RowData["Term"]);
string Type = e.RowData["RateType"].ToString();
decimal Rate = Convert.ToDecimal(e.RowData["Rate"]);
VendorRate newRate = new VendorRate();
newRate.Type = db.Types.Where(n => n.Name == Type).Single();
newRate.Term = Term;
newRate.BeginDate = DateTime.Now;
newRate.Rate = Rate;
db.VendorRates.Add(newRate);
db.SaveChanges();
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.DeleteRow)
{
// Not gonna allow deleting of rates
throw new NotImplementedException();
}
}
public ActionResult EditRows()
{
var gridModel = new LeasingDatabase.Models.Grid.OrdersJqGridModel();
var db = new AuleaseEntities();
var e = gridModel.OrdersGrid.GetEditData(); // Edit Row
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow)
{
int id = Convert.ToInt32(e.RowData["Id"].ToString());
Lease lease = db.Leases.Where(n => n.Id == id).Single();
string validationMessage = ValidationEditRow(e);
if (!String.IsNullOrWhiteSpace(validationMessage))
{
return(gridModel.OrdersGrid.ShowEditValidationMessage(validationMessage));
}
string _Fund = e.RowData["Fund"].ToString().Trim();
string _Org = e.RowData["Org"].ToString().Trim();
string _Program = e.RowData["Program"].ToString().Trim();
string _ContractNumber = e.RowData["ContractNumber"].ToString().Trim();
DateTime _BeginDate = Convert.ToDateTime(e.RowData["BeginDate"].ToString());
DateTime _EndDate = Convert.ToDateTime(e.RowData["EndDate"].ToString());
string _StatementName = e.RowData["StatementName"].ToString();
decimal _MonthlyCharge = Convert.ToDecimal(e.RowData["MonthlyCharge"].ToString());
Department dept = db.Departments.Where(n => n.Fund == _Fund && n.Org == _Org && n.Program == _Program).Single();
lease.Department = dept;
lease.BeginDate = _BeginDate;
lease.EndDate = _EndDate;
lease.StatementName = _StatementName;
lease.ContractNumber = _ContractNumber;
lease.MonthlyCharge = _MonthlyCharge;
db.SaveChanges();
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.AddRow)
{
// Add Row
}
if (gridModel.OrdersGrid.AjaxCallBackMode == AjaxCallBackMode.DeleteRow)
{
int id = Convert.ToInt32(e.RowData["Id"].ToString());
Lease lease = db.Leases.Where(n => n.Id == id).Single();
Session["SN"] = lease.Component.SerialNumber;
foreach (var charge in lease.Charges)
{
charge.Leases.Remove(lease);
}
Component comp = lease.Component;
comp.Leases.Remove(lease);
SystemGroup group = lease.SystemGroup;
group.Leases.Remove(lease);
Department dept = lease.Department;
dept.Leases.Remove(lease);
db.Entry(lease).State = EntityState.Deleted;
db.SaveChanges();
}
return(new RedirectResult(Url.Action("DataRequested", "Billing")));
}
