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);
}
