public void AddOrEditPaymentBill(PaymentBillModel newPaymentBill)
{
try
{
using (var ctx = new DBProjectEntities())
{
var paymentBill = ctx.FakturyWynajem.Find(newPaymentBill.id_faktury);
if (paymentBill == null)
{
paymentBill = ModelMapper.Mapper.Map <FakturyWynajem>(newPaymentBill);
ctx.FakturyWynajem.Add(paymentBill);
}
else
{
paymentBill.id_wynajem = newPaymentBill.id_wynajem;
paymentBill.id_faktury = newPaymentBill.id_faktury;
paymentBill.cena = newPaymentBill.cena;
paymentBill.data_platnosci = newPaymentBill.data_platnosci;
paymentBill.numer_faktury = newPaymentBill.numer_faktury;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
//PAYMENTS BILLS
public bool AddOrEditPaymentBill(PaymentBillModel newPaymentBill)
{
if (newPaymentBill.id_wynajem == null)
{
return(false); //This payment is not connected to any rental - kinda useless.
}
try
{
using (var ctx = new DBProjectEntities())
{
var payment = ctx.FakturyWynajem.Find(newPaymentBill.id_wynajem);
if (payment == null) //DB did not find any record like provided one. Add it.
{
payment = ModelMapper.Mapper.Map <FakturyWynajem>(newPaymentBill);
ctx.FakturyWynajem.Add(payment);
}
else//There's a record that contains the residence already - modify it.
{
payment.cena = newPaymentBill.cena;
payment.data_platnosci = newPaymentBill.data_platnosci;
payment.id_wynajem = newPaymentBill.id_wynajem;
payment.numer_faktury = newPaymentBill.numer_faktury;
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
return(true);
}
public PaymentBillModel GetSinglePaymentBillById(int paymentBillId)
{
PaymentBillModel queryResult = null;
try
{
using (var ctx = new DBProjectEntities())
{
var resident = ctx.FakturyWynajem.Find(paymentBillId);
queryResult = ModelMapper.Mapper.Map <PaymentBillModel>(resident);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(queryResult);
}
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);
}
// PUT: api/Company/5
public void Put(int id, [FromBody] PaymentBillModel value)
{
var service = new RentalService();
service.AddOrEditPaymentBill(value);
}
// POST: api/Company
public void Post([FromBody] PaymentBillModel value)
{
return;
}
