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);
}
public List <TenantStorageModel> GetTenantStorageList(long TenantId)
{
ShomaRMEntities db = new ShomaRMEntities();
List <TenantStorageModel> model = new List <TenantStorageModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_Get_TenantStorage";
cmd.CommandType = CommandType.StoredProcedure;
DbParameter paramC = cmd.CreateParameter();
paramC.ParameterName = "TenantId";
paramC.Value = TenantId;
cmd.Parameters.Add(paramC);
DbDataAdapter da = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateDataAdapter();
da.SelectCommand = cmd;
da.Fill(dtTable);
db.Database.Connection.Close();
}
foreach (DataRow dr in dtTable.Rows)
{
TenantStorageModel usm = new TenantStorageModel();
usm.TSID = Convert.ToInt64(dr["TSID"].ToString());
usm.StorageID = Convert.ToInt64(dr["StorageID"].ToString());
usm.TenantID = Convert.ToInt64(dr["TenantID"].ToString());
usm.Charges = Convert.ToDecimal(dr["Charges"].ToString());
usm.CreatedDate = Convert.ToDateTime(dr["CreatedDate"].ToString());
model.Add(usm);
}
db.Dispose();
return(model.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}