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