//updates selected appartment data
public void UpdateAppartment(int id, int number, int floor, double living, double general, decimal electricitybill, decimal electricitypayment, decimal waterbill, decimal waterpayment,
decimal gasbill, decimal gaspayment, decimal spdtbill, decimal spdtpayment, decimal totalbill, decimal totalpayment,
int electricityprevcounter, int electricityactualcounter, int waterprevcounter, int wateractualcounter, int gasprevcounter, int gasactualcounter)
{
Appartment appartment = context.Appartments.Where(x => x.AppartmentId == id).FirstOrDefault <Appartment>();
appartment.AppartmentId = id;
appartment.Floor = floor;
appartment.GeneralArea = general; appartment.LivingArea = living; appartment.Number = number;
appartment.SpdtBill = spdtbill; appartment.SpdtPayment = spdtpayment; appartment.ElectricityBill = electricitybill;
appartment.ElectricityPayment = electricitypayment; appartment.WaterBill = waterbill; appartment.WaterPayment = waterpayment;
appartment.GasBill = gasbill; appartment.GasPayment = gaspayment; appartment.SpdtBill = spdtbill; appartment.SpdtPayment = spdtpayment;
appartment.TotalBill = appartment.GasBill + appartment.WaterBill + appartment.SpdtBill + appartment.ElectricityBill;
appartment.TotalPayment = appartment.GasPayment + appartment.SpdtPayment + appartment.WaterPayment + appartment.ElectricityPayment;
appartment.ElectricityPrevCounter = electricityprevcounter; appartment.ElectricityActualCounter = electricityactualcounter;
appartment.WaterPrevCounter = waterprevcounter; appartment.WaterActualCounter = wateractualcounter;
appartment.GasPrevCounter = gasprevcounter; appartment.GasActualCounter = gasactualcounter;
AppartmentCheck.Require(appartment.LivingArea);
AppartmentCheck.Require(appartment.GeneralArea);
AppartmentCheck.Require(appartment.Number);
AppartmentCheck.Require(appartment.Floor);
AppartmentCheck.CheckArea(appartment.LivingArea, appartment.GeneralArea);
context.Entry(appartment).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
//add newly created appartment to repository
public int AddNewAppartment(int number, int floor, double living, double general, decimal electricitybill, decimal electricitypayment, decimal waterbill, decimal waterpayment,
decimal gasbill, decimal gaspayment, decimal spdtbill, decimal spdtpayment, decimal totalbill, decimal totalpayment,
int electricityprevcounter, int electricityactualcounter, int waterprevcounter, int wateractualcounter, int gasprevcounter, int gasactualcounter)
{
Appartment appartment = new Appartment();
appartment.Floor = floor;
appartment.GeneralArea = general; appartment.LivingArea = living; appartment.Number = number;
appartment.SpdtBill = spdtbill; appartment.SpdtPayment = spdtpayment; appartment.ElectricityBill = electricitybill;
appartment.ElectricityPayment = electricitypayment; appartment.WaterBill = waterbill; appartment.WaterPayment = waterpayment;
appartment.GasBill = gasbill; appartment.GasPayment = gaspayment; appartment.SpdtBill = spdtbill; appartment.SpdtPayment = spdtpayment;
appartment.TotalBill = totalbill; appartment.TotalPayment = totalpayment;
appartment.ElectricityPrevCounter = electricityprevcounter; appartment.ElectricityActualCounter = electricityactualcounter;
appartment.WaterPrevCounter = waterprevcounter; appartment.WaterActualCounter = wateractualcounter;
appartment.GasPrevCounter = gasprevcounter; appartment.GasActualCounter = gasactualcounter;
AppartmentCheck.Require(appartment.LivingArea);
AppartmentCheck.Require(appartment.GeneralArea);
AppartmentCheck.Require(appartment.Number);
AppartmentCheck.Require(appartment.Floor);
AppartmentCheck.CheckArea(appartment.LivingArea, appartment.GeneralArea);
context.Appartments.Add(appartment);
context.SaveChanges();
return(appartment.AppartmentId);
}
