public FaultModel GetSingleStrictFaultDataModel(int faultId) { var fault = new FaultModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Usterki.Find(faultId); fault = ModelMapper.Mapper.Map <FaultModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(fault); }
public void RemoveRepair(int repairId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Naprawy.Find(repairId); if (result != null) { ctx.Naprawy.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("Cannot delete provided repair - remove connected bills first."); } }
public void RemoveBuilding(int buildingId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Budynki.Find(buildingId); if (result != null) { ctx.Budynki.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("Cannot remove building - remove all residences assigned to it first."); } }
public void RemoveCompany(int companyId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Firmy.Find(companyId); if (result != null) { ctx.Firmy.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("An error occured while processing your request."); } }
public BuildingModel GetSingleBuilding(int buildingId) { var building = new BuildingModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Budynki.Find(buildingId); building = ModelMapper.Mapper.Map <BuildingModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(building); }
public PaymentModel GetSinglePaymentModel(int paymentId) { var payment = new PaymentModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Platnosci.Find(paymentId); payment = ModelMapper.Mapper.Map <PaymentModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(payment); }
public void RemoveFault(int faultId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Usterki.Find(faultId); if (result != null) { ctx.Usterki.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("Cannot remove the fault - remove connected repairs first."); } }
public FaultDataModel GetSingleFaultDataModel(int faultId) { var rental = new FaultDataModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.FaultsDataView.FirstOrDefault(x => x.id_usterki == faultId); rental = ModelMapper.Mapper.Map <FaultDataModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(rental); }
public StrictRentalDataModel GetSingleStrictRentalDataModel(int rentalId) { var rental = new StrictRentalDataModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Wynajmy.Find(rentalId); rental = ModelMapper.Mapper.Map <StrictRentalDataModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(rental); }
public void RemovePayment(int paymentId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Platnosci.Find(paymentId); if (result != null) { ctx.Platnosci.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public RentalDataModel GetSingleRentalDataModel(int rentalId) { var rental = new RentalDataModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.RentalDataView.FirstOrDefault(x => x.id_wynajmu == rentalId); rental = ModelMapper.Mapper.Map <RentalDataModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(rental); }
public void RemovePaymentBill(int paymentBillId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.FakturyWynajem.Find(paymentBillId); if (result != null) { ctx.FakturyWynajem.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("An error occured while processing request."); } }
public PaymentBillModel GetSinglePaymentBillModel(int paymentBillId) { var paymentBill = new PaymentBillModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.FakturyWynajem.Find(paymentBillId); paymentBill = ModelMapper.Mapper.Map <PaymentBillModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(paymentBill); }
public void RemoveRepairBill(int repairBillId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.FakturyNapraw.Find(repairBillId); if (result != null) { ctx.FakturyNapraw.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("Could not fulfill the request."); } }
public void RemoveResident(int residentId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Najemcy.Find(residentId); if (result != null) { ctx.Najemcy.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public RepairBillModel GetSingleRepairBillModel(int repairBillId) { var repairBill = new RepairBillModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.FakturyNapraw.Find(repairBillId); repairBill = ModelMapper.Mapper.Map <RepairBillModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(repairBill); }
public BuildingModel GetSingleBuilding(string buildingAddress) { var building = new BuildingModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Budynki.FirstOrDefault(x => x.adres_budynku == buildingAddress); building = ModelMapper.Mapper.Map <BuildingModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(building); }
public RepairModel GetSingleRepairModel(int repairId) { var payment = new RepairModel(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Naprawy.Find(repairId); payment = ModelMapper.Mapper.Map <RepairModel>(queryResult); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(payment); }
public void RemovePaymentBill(int paymentBillId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.FakturyWynajem.Find(paymentBillId); if (result != null) { ctx.FakturyWynajem.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("Error - could not fulfill the request."); } }
public void RemoveResidence(int buildingId, int residenceId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Mieszkania.FirstOrDefault(x => x.id_budynku == buildingId && x.id_mieszkania == residenceId); if (result != null) { ctx.Mieszkania.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("Cannot remove residence - remove all faults and rentals connected with it first."); } }
public void RemoveRental(int rentalId) { try { using (var ctx = new DBProjectEntities()) { var result = ctx.Wynajmy.Find(rentalId); if (result != null) { ctx.Wynajmy.Remove(result); } ctx.SaveChanges(); } } catch (Exception ex) { throw new Exception("Could not remove selected rental. Make sure there are no " + "payments and payment bills present for this rental."); } }
public CompanyModel GetSingleCompany(int?companyId) { CompanyModel queryResult = null; try { using (var ctx = new DBProjectEntities()) { var company = ctx.Firmy.Find(companyId); if (company != null) { queryResult = ModelMapper.Mapper.Map <CompanyModel>(company); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(queryResult); }
public List <ICurrentRepairModel> GetAll() { List <ICurrentRepairModel> result = new List <ICurrentRepairModel>(); try { using (var ctx = new DBProjectEntities()) { foreach (var obiekt in GetRepairs()) { result.Add(Mapper.ModelMapper.Mapper.Map <ICurrentRepairModel>(obiekt)); } return(result); } } catch (Exception ex) { Logger.Log(ex.Message); return(null); } }
public List <ISupervisorModel> GetAll() { List <ISupervisorModel> result = new List <ISupervisorModel>(); try { using (var ctx = new DBProjectEntities()) { foreach (var obiekt in ctx.Dozorcy.ToList()) { result.Add(Mapper.ModelMapper.Mapper.Map <ISupervisorModel>(obiekt)); } return(result); } } catch (Exception ex) { Logger.Log(ex.Message); return(null); } }
public List <CompanyModel> GetAllCompanies() { var queryResult = new List <CompanyModel>(); try { using (var ctx = new DBProjectEntities()) { var companies = ctx.Firmy.Select(x => x).AsQueryable(); foreach (var company in companies) { queryResult.Add(ModelMapper.Mapper.Map <CompanyModel>(company)); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(queryResult); }
public List <ResidenceModel> GetResidencesById(int buildingId) { var residences = new List <ResidenceModel>(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Mieszkania.Where(x => x.id_budynku == buildingId).AsQueryable(); foreach (var building in queryResult) { residences.Add(ModelMapper.Mapper.Map <ResidenceModel>(building)); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(residences); }
public List <ResidentModel> GetAllResidents() { var queryResult = new List <ResidentModel>(); try { using (var ctx = new DBProjectEntities()) { var residents = ctx.Najemcy.Select(x => x).AsQueryable(); foreach (var resident in residents) { queryResult.Add(ModelMapper.Mapper.Map <ResidentModel>(resident)); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(queryResult); }
public List <PaymentBillModel> GetAllPaymentBills(int rentalId) { var queryResult = new List <PaymentBillModel>(); try { using (var ctx = new DBProjectEntities()) { var residents = ctx.FakturyWynajem.Where(x => x.id_wynajem == rentalId); foreach (var resident in residents) { queryResult.Add(ModelMapper.Mapper.Map <PaymentBillModel>(resident)); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(queryResult); }
public List <BuildingModel> GetAllBuildings() { var buildings = new List <BuildingModel>(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Budynki.Select(x => x).AsQueryable(); foreach (var building in queryResult) { buildings.Add(ModelMapper.Mapper.Map <BuildingModel>(building)); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(buildings); }
public List <RepairModel> GetAllRepairsById(int faultId) { var repairs = new List <RepairModel>(); try { using (var ctx = new DBProjectEntities()) { var queryResult = ctx.Naprawy.Where(x => x.id_usterki == faultId); foreach (var repair in queryResult) { repairs.Add(ModelMapper.Mapper.Map <RepairModel>(repair)); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(repairs); }