public ActionResult TenantsAtRiskEdit(FormCollection form)
{
if (!string.IsNullOrEmpty(Session["username"] as string))
{
try
{
List <TenantsAtRisk> lst = new List <TenantsAtRisk>();
for (int i = 1; i <= 7; i++)
{
TenantsAtRisk obj = new TenantsAtRisk();
obj.Tenant = form["Tenant" + i];
obj.Sales = form["Sales" + i];
obj.UnitNo = form["UnitNo" + i];
obj.Gla = form["Gla" + i];
obj.Groc = form["Groc" + i];
obj.RollingSales = form["RollingSales" + i];
obj.ArYtd = form["ArYtd" + i];
obj.Comments = form["comment" + i];
lst.Add(obj);
}
LeasingDataMonthly ld = new LeasingDataMonthly();
ld.UpdateTenantsAtrisk(lst);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View("Error", ex));
}
}
else
{
return(RedirectToAction("Index", "Login"));
}
}
public List <TenantsAtRisk> GetTenantAtRisk()
{
List <TenantsAtRisk> tenantsAtRisks = new List <TenantsAtRisk>();
DataSet data = DBConnection.GetData("GetTenantAtRisk");
foreach (DataRow row in data.Tables[0].Rows)
{
TenantsAtRisk tenant = new TenantsAtRisk();
tenant.OpeningId = new Guid(row["OpeningId"].ToString());
tenant.Groc = !String.IsNullOrEmpty(row["Groc"].ToString()) ? row["Groc"].ToString() : string.Empty;
tenant.Tenant = !String.IsNullOrEmpty(row["Tenant"].ToString()) ? row["Tenant"].ToString() : string.Empty;
tenant.Sales = !String.IsNullOrEmpty(row["Sales"].ToString()) ? row["Sales"].ToString() : string.Empty;
tenant.UnitNo = !String.IsNullOrEmpty(row["UnitNo"].ToString()) ? row["UnitNo"].ToString() : string.Empty;
tenant.Gla = !String.IsNullOrEmpty(row["Gla"].ToString()) ? row["Gla"].ToString() : string.Empty;
tenant.RollingSales = !String.IsNullOrEmpty(row["RollingSales"].ToString()) ? row["RollingSales"].ToString() : string.Empty;
tenant.ArYtd = !String.IsNullOrEmpty(row["ArYtd"].ToString()) ? row["ArYtd"].ToString() : string.Empty;
tenant.Comments = !String.IsNullOrEmpty(row["Comments"].ToString()) ? row["Comments"].ToString() : string.Empty;
tenantsAtRisks.Add(tenant);
}
return(tenantsAtRisks);
}
