public string SaveUpdateTenantStorage(TenantFOBModel model) { ShomaRMEntities db = new ShomaRMEntities(); decimal totalStorageAmt = 0; var TenantStorageData = db.tbl_TenantStorage.Where(p => p.TenantID == model.TenantID).ToList(); db.tbl_TenantStorage.RemoveRange(TenantStorageData); db.SaveChanges(); if (model.lstTStorage != null) { foreach (var cd in model.lstTStorage) { var parkingdata = db.tbl_FOB.Where(p => p.StorageID == cd.StorageID).FirstOrDefault(); var cdData = new tbl_TenantStorage { StorageID = cd.StorageID, TenantID = model.TenantID, Charges = parkingdata.Charges, CreatedDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")) }; db.tbl_TenantStorage.Add(cdData); db.SaveChanges(); totalStorageAmt = totalStorageAmt + Convert.ToDecimal(parkingdata.Charges); } } return(totalStorageAmt.ToString()); }
public string SaveUpdateTenantStorage(TenantStorageModel model) { ShomaRMEntities db = new ShomaRMEntities(); decimal totalStorageAmt = 0; string result = ""; if (model.lstTStorage != null) { // check storage available // long storageid = model.lstTStorage[0].StorageID ?? 0; var storagedata = db.tbl_Storage.Where(p => p.StorageID == storageid).FirstOrDefault(); var isStorageAvailable = db.tbl_TenantStorage.Where(p => p.StorageID == storageid && TenantID != model.TenantID).FirstOrDefault(); if (isStorageAvailable != null) { result = "0|" + storagedata.StorageName + " - " + storagedata.Description + " is not available.<br/>Please select other storage unit.|0.00"; } // check storage available // else { var TenantStorageData = db.tbl_TenantStorage.Where(p => p.TenantID == model.TenantID).ToList(); db.tbl_TenantStorage.RemoveRange(TenantStorageData); db.SaveChanges(); foreach (var cd in model.lstTStorage) { var cdData = new tbl_TenantStorage { StorageID = cd.StorageID, TenantID = model.TenantID, Charges = storagedata.Charges, CreatedDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")) }; db.tbl_TenantStorage.Add(cdData); db.SaveChanges(); totalStorageAmt = totalStorageAmt + Convert.ToDecimal(storagedata.Charges); } result = "1|Progress saved|" + totalStorageAmt.ToString(); } } else { var TenantStorageData = db.tbl_TenantStorage.Where(p => p.TenantID == model.TenantID).ToList(); db.tbl_TenantStorage.RemoveRange(TenantStorageData); db.SaveChanges(); result = "1|Progress saved|0.00"; } return(result); }