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