public List <DeliveredSpaces> GetDelieverdSpaces() { List <DeliveredSpaces> deliveredSpaces = new List <DeliveredSpaces>(); DataSet data = DBConnection.GetData("GETDeliveredSpaces"); foreach (DataRow row in data.Tables[0].Rows) { DeliveredSpaces deliveredSpace = new DeliveredSpaces(); deliveredSpace.OpeningId = new Guid(row["OpeningId"].ToString()); deliveredSpace.Months = !String.IsNullOrEmpty(row["Months"].ToString()) ? row["Months"].ToString() : string.Empty; deliveredSpace.Tenant = !String.IsNullOrEmpty(row["Tenant"].ToString()) ? row["Tenant"].ToString() : string.Empty; deliveredSpace.Sector = !String.IsNullOrEmpty(row["Sector"].ToString()) ? row["Sector"].ToString() : string.Empty; deliveredSpace.UnitNo = !String.IsNullOrEmpty(row["UnitNo"].ToString()) ? row["UnitNo"].ToString() : string.Empty; deliveredSpace.Gla = !String.IsNullOrEmpty(row["Gla"].ToString()) ? row["Gla"].ToString() : string.Empty; deliveredSpace.DeliveryDate = !String.IsNullOrEmpty(row["DeliveryDate"].ToString()) ? row["DeliveryDate"].ToString() : string.Empty; deliveredSpace.FixturingPeriod = !String.IsNullOrEmpty(row["FixturingPeriod"].ToString()) ? row["FixturingPeriod"].ToString() : string.Empty; deliveredSpace.ExpectedOpening = !String.IsNullOrEmpty(row["ExpectedOpening"].ToString()) ? row["ExpectedOpening"].ToString() : string.Empty; deliveredSpace.Ner = !String.IsNullOrEmpty(row["Ner"].ToString()) ? row["Ner"].ToString() : string.Empty; deliveredSpace.TA = !String.IsNullOrEmpty(row["TA"].ToString()) ? row["TA"].ToString() : string.Empty; deliveredSpace.Llw = !String.IsNullOrEmpty(row["Llw"].ToString()) ? row["Llw"].ToString() : string.Empty; deliveredSpace.Commision = !String.IsNullOrEmpty(row["Commision"].ToString()) ? row["Commision"].ToString() : string.Empty; deliveredSpaces.Add(deliveredSpace); } return(deliveredSpaces); }
public ActionResult DeliveredSpacesEdit(FormCollection form) { if (!string.IsNullOrEmpty(Session["username"] as string)) { try { List <DeliveredSpaces> lst = new List <DeliveredSpaces>(); for (int i = 1; i <= 5; i++) { DeliveredSpaces obj = new DeliveredSpaces(); obj.Tenant = form["Tenant" + i]; obj.Months = form["month"]; obj.Sector = form["Sector" + i]; obj.UnitNo = form["UnitNo" + i]; obj.Gla = form["Gla" + i]; obj.DeliveryDate = form["DeliveryDate" + i]; obj.FixturingPeriod = form["FixturingPeriod" + i]; obj.ExpectedOpening = form["ExpectedOpening" + 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.UpdateDeliveredSpaces(lst); return(RedirectToAction("Index")); } catch (Exception ex) { return(View("Error", ex)); } } else { return(RedirectToAction("Index", "Login")); } }