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 List <TenantFOBModel> GetTenantStorageList(long TenantId)
{
ShomaRMEntities db = new ShomaRMEntities();
List <TenantFOBModel> model = new List <TenantFOBModel>();
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)
{
TenantFOBModel usm = new TenantFOBModel();
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;
}
}
