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