public List <CompletedRenewals> GetCompletedRenewals()
{
List <CompletedRenewals> completedRenewals = new List <CompletedRenewals>();
DataSet data = DBConnection.GetData("GetCompletedRenewals");
foreach (DataRow row in data.Tables[0].Rows)
{
CompletedRenewals completedRenewal = new CompletedRenewals();
completedRenewal.OpeningId = new Guid(row["OpeningId"].ToString());
completedRenewal.Months = !String.IsNullOrEmpty(row["Months"].ToString()) ? row["Months"].ToString() : string.Empty;
completedRenewal.Tenant = !String.IsNullOrEmpty(row["Tenant"].ToString()) ? row["Tenant"].ToString() : string.Empty;
completedRenewal.Sector = !String.IsNullOrEmpty(row["Sector"].ToString()) ? row["Sector"].ToString() : string.Empty;
completedRenewal.UnitNo = !String.IsNullOrEmpty(row["UnitNo"].ToString()) ? row["UnitNo"].ToString() : string.Empty;
completedRenewal.Gla = !String.IsNullOrEmpty(row["Gla"].ToString()) ? row["Gla"].ToString() : string.Empty;
completedRenewal.Term = !String.IsNullOrEmpty(row["Term"].ToString()) ? row["Term"].ToString() : string.Empty;
completedRenewal.NetBudget = !String.IsNullOrEmpty(row["NetBudget"].ToString()) ? row["NetBudget"].ToString() : string.Empty;
completedRenewal.NetRentActual = !String.IsNullOrEmpty(row["NetRentActual"].ToString()) ? row["NetRentActual"].ToString() : string.Empty;
completedRenewal.Ner = !String.IsNullOrEmpty(row["Ner"].ToString()) ? row["Ner"].ToString() : string.Empty;
completedRenewal.TA = !String.IsNullOrEmpty(row["TA"].ToString()) ? row["TA"].ToString() : string.Empty;
completedRenewal.Llw = !String.IsNullOrEmpty(row["Llw"].ToString()) ? row["Llw"].ToString() : string.Empty;
completedRenewal.Commision = !String.IsNullOrEmpty(row["Commision"].ToString()) ? row["Commision"].ToString() : string.Empty;
completedRenewals.Add(completedRenewal);
}
return(completedRenewals);
}
public ActionResult CompletedRenewalsEdit(FormCollection form)
{
if (!string.IsNullOrEmpty(Session["username"] as string))
{
try
{
List <CompletedRenewals> lst = new List <CompletedRenewals>();
for (int i = 1; i <= 5; i++)
{
CompletedRenewals obj = new CompletedRenewals();
obj.Tenant = form["Tenant" + i];
obj.Sector = form["Sector" + i];
obj.UnitNo = form["UnitNo" + i];
obj.Gla = form["Gla" + i];
obj.Term = form["Term" + i];
obj.NetBudget = form["NetBudget" + i];
obj.NetRentActual = form["NetRentActual" + i];
obj.Ner = form["Ner" + i];
obj.Llw = form["Llw" + i];
obj.TA = form["TA" + i];
obj.Commision = form["Commision" + i];
lst.Add(obj);
}
LeasingDataMonthly ld = new LeasingDataMonthly();
ld.UpdateCompletedRenewals(lst);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
