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