public PetManagementModel GetPetPlaceData(int Id)
{
ShomaRMEntities db = new ShomaRMEntities();
PetManagementModel model = new PetManagementModel();
var GetPetPlaceData = db.tbl_PetPlace.Where(p => p.PetPlaceID == Id).FirstOrDefault();
if (GetPetPlaceData != null)
{
model.PetPlaceID = GetPetPlaceData.PetPlaceID;
model.PropertyID = GetPetPlaceData.PropertyID;
model.PetPlace = GetPetPlaceData.PetPlace;
model.Charges = GetPetPlaceData.Charges;
model.Description = GetPetPlaceData.Description;
}
model.PetPlaceID = Id;
return(model);
}
public List <PetManagementModel> GetPetPlaceList()
{
ShomaRMEntities db = new ShomaRMEntities();
List <PetManagementModel> model = new List <PetManagementModel>();
try
{
DataTable dtTable = new DataTable();
using (var cmd = db.Database.Connection.CreateCommand())
{
db.Database.Connection.Open();
cmd.CommandText = "usp_Get_PetPlace";
cmd.CommandType = CommandType.StoredProcedure;
//DbParameter paramC = cmd.CreateParameter();
//paramC.ParameterName = "Criteria";
//paramC.Value = MarketSourceName;
//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)
{
PetManagementModel usm = new PetManagementModel();
usm.PetPlaceID = int.Parse(dr["PetPlaceID"].ToString());
usm.PropertyID = int.Parse(dr["PropertyID"].ToString());
usm.PetPlace = dr["PetPlace"].ToString();
usm.Charges = Convert.ToDecimal(dr["Charges"].ToString());
usm.Description = dr["Description"].ToString();
usm.Type = int.Parse(dr["Type"].ToString());
model.Add(usm);
}
db.Dispose();
return(model.ToList());
}
catch (Exception ex)
{
db.Database.Connection.Close();
throw ex;
}
}
public PetManagementModel GetPetPlaceInfo(int ID = 0)
{
ShomaRMEntities db = new ShomaRMEntities();
PetManagementModel model = new PetManagementModel();
model.PetPlaceID = 0;
model.PetPlace = "";
var PetPlaceInfo = db.tbl_PetPlace.Where(p => p.PetPlaceID == PetPlaceID).FirstOrDefault();
if (PetPlaceInfo != null)
{
model.PetPlaceID = PetPlaceInfo.PetPlaceID;
model.PropertyID = PetPlaceInfo.PropertyID;
model.PetPlace = PetPlaceInfo.PetPlace;
model.Charges = PetPlaceInfo.Charges;
model.Description = PetPlaceInfo.Description;
}
return(model);
}
public long SaveUpdatePetPlace(PetManagementModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
if (model.PetPlaceID == 0)
{
//var PetPlaceData = new tbl_PetPlace()
//{
// PropertyID = model.PropertyID,
// PetPlace = model.PetPlace,
// Charges = model.Charges,
// Description = model.Description
//};
//db.tbl_PetPlace.Add(PetPlaceData);
//db.SaveChanges();
//model.PetPlaceID = PetPlaceData.PetPlaceID;
throw new Exception("Can not add new pets. Only edit allowed");
}
else
{
var PetPlaceInfo = db.tbl_PetPlace.Where(p => p.PetPlaceID == model.PetPlaceID).FirstOrDefault();
if (PetPlaceInfo != null)
{
PetPlaceInfo.PropertyID = model.PropertyID;
PetPlaceInfo.PetPlace = model.PetPlace;
PetPlaceInfo.Charges = model.Charges;
PetPlaceInfo.Description = model.Description;
db.SaveChanges();
}
else
{
throw new Exception(model.PetPlace + " not exists in the system.");
}
}
return(model.PetPlaceID);
}
