public List <TenantPetPlaceModel> GetTenantPetPlaceList(long TenantId)
{
ShomaRMEntities db = new ShomaRMEntities();
List <TenantPetPlaceModel> model = new List <TenantPetPlaceModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_Get_TenantPetPlace";
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)
{
TenantPetPlaceModel usm = new TenantPetPlaceModel();
usm.TPetID = Convert.ToInt64(dr["TPetID"].ToString());
usm.PetPlaceID = Convert.ToInt64(dr["PetPlaceID"].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;
}
}
public string SaveUpdateTenantPetPlace(TenantPetPlaceModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
decimal totalPetPlaceAmt = 0;
int numOfPet = 0;
decimal petDNA = 0;
var TenantStorageData = db.tbl_TenantPetPlace.Where(p => p.TenantID == model.TenantID).ToList();
db.tbl_TenantPetPlace.RemoveRange(TenantStorageData);
db.SaveChanges();
if (model.lstTPetPlace != null)
{
foreach (var cd in model.lstTPetPlace)
{
var petdata = db.tbl_PetPlace.Where(p => p.PetPlaceID == cd.PetPlaceID).FirstOrDefault();
var propertydata = db.tbl_Properties.Where(p => p.PID == model.PropertyID).FirstOrDefault();
var cdData = new tbl_TenantPetPlace
{
PetPlaceID = cd.PetPlaceID,
TenantID = model.TenantID,
Charges = petdata.Charges,
CreatedDate = Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy"))
};
db.tbl_TenantPetPlace.Add(cdData);
db.SaveChanges();
if (petdata != null)
{
totalPetPlaceAmt = totalPetPlaceAmt + Convert.ToDecimal(petdata.Charges ?? 0);
numOfPet = Convert.ToInt32(petdata.Type ?? 0);
}
if (propertydata != null)
{
petDNA = petDNA + Convert.ToDecimal(propertydata.PetDNAAmt ?? 0);
}
}
}
return(numOfPet.ToString() + "|" + totalPetPlaceAmt.ToString() + "|" + petDNA.ToString());
}
