public async Task <int> AddBillCollectionAsync(BillCollection billCollection) { var context = this._billSplitterContext; var actualBillCollection = new BillCollection { Date = billCollection.Date.Date, Bills = new List <Bill>(billCollection.Bills.Select(bill => new Bill { PersonId = bill.PersonId, SupplierId = bill.SupplierId, TotalAmount = bill.TotalAmount, BillDate = bill.BillDate, Comment = bill.Comment, Splits = new List <Split>(bill.Splits.Select(split => new Split { PersonId = split.PersonId, SplitAmount = split.SplitAmount, SplitPercent = split.SplitPercent, })) })) }; await context.BillCollections.AddAsync(actualBillCollection); return(await context.SaveChangesAsync()); }
public async Task <ActionResult> SaveAsync(int id, [FromBody] BillCollection billCollection) { try { if (id == billCollection.BillCollectionId) { var result = await this._billService.UpdateBillCollectionAsync(billCollection); if (result > 0) { return(this.Ok()); } else { return(this.BadRequest("No change was made")); } } else { return(this.BadRequest("Bad id")); } } catch (Exception ex) { return(this.BadRequest(ex.Message)); } }
private void LoadSelectedBill() { lblHiddenBillId.Text = ""; loadSelectedBill = new BillCollection(); loadSelectedBill.LoadBillWithStdIdFromDb(selectedId); foreach (var popBill in loadSelectedBill.pubBillCollect) { lblHiddenBillId.Text = popBill.Bill_Id.ToString(); lblTotalAmount.Text = popBill.Bill_TotalAmount.ToString(); lblDiscount.Text = popBill.Bill_Discount.ToString(); lblFinalAmount.Text = popBill.Bill_FinalAmount.ToString(); lblPaymentMade.Text = popBill.Bill_PaymentMade.ToString(); lblSemester.Text = popBill.Bill_Semester; lblBalance.Text = popBill.Bill_Balance.ToString(); lblSchoolYr.Text = popBill.Bill_SchoolYear; } }
public async Task <ActionResult> SaveAsync([FromBody] BillCollection billCollection) { try { var result = await this._billService.AddBillCollectionAsync(billCollection); if (result > 0) { return(this.Ok()); } else { return(this.BadRequest("No change was made")); } } catch (Exception ex) { return(this.BadRequest(ex.Message)); } }
private void LoadSelectedBill() { billId = 0; loadSelectedBill = new BillCollection(); loadSelectedBill.LoadBillWithStdIdFromDb(selectedId); foreach (var popBill in loadSelectedBill.pubBillCollect) { billId = popBill.Bill_Id; txtAmount.Text = popBill.Bill_TotalAmount.ToString(); txtDiscount.Text = popBill.Bill_Discount.ToString(); txtFinal.Text = popBill.Bill_FinalAmount.ToString(); txtPayMade.Text = popBill.Bill_PaymentMade.ToString(); txtSemester.Text = popBill.Bill_Semester; txtBalance.Text = popBill.Bill_Balance.ToString(); txtSchoolYear.Text = popBill.Bill_SchoolYear; billStatus = popBill.Bill_Status; billDueDate = popBill.Bill_DueDate; billDatePaid = popBill.Bill_DatePaid; } }
public async Task <int> UpdateBillCollectionAsync(BillCollection billCollection) { var context = this._billSplitterContext; var actualBillCollection = await this.GetBillCollectionAsync(billCollection.BillCollectionId); actualBillCollection.Date = billCollection.Date.Date; actualBillCollection.Bills.Update( billCollection.Bills, b => new { b.BillCollectionId, b.BillId }, b => new { b.BillCollectionId, b.BillId }, (b, k) => b, (src, dest) => { dest.PersonId = src.PersonId; dest.SupplierId = src.SupplierId; dest.TotalAmount = src.TotalAmount; dest.BillDate = src.BillDate; dest.Comment = src.Comment; dest.Splits.Update( src.Splits, s => new { s.BillId, s.BillCollectionId, s.PersonId }, s => new { s.BillId, s.BillCollectionId, s.PersonId }, (s, k) => s, (src1, dest1) => { dest1.SplitAmount = src1.SplitAmount; dest1.SplitPercent = src1.SplitPercent; }); }); context.BillCollections.Update(actualBillCollection); return(await context.SaveChangesAsync()); }
private void LoadStdBill() { loadBillData = new BillCollection(); loadBillData.LoadBillWithStdIdFromDb(Int32.Parse(LoginUser.stdLogStudentId)); foreach (var popBill in loadBillData.pubBillCollect) { if (DateTime.Parse(popBill.Bill_DueDate) < DateTime.Today) { var setOldManage = new BillManager(); setOldManage.SetTuitionToOld(popBill.Bill_Id); SetOldPart(); stop = true; return; } lblTotalTuitionContainer.Text = popBill.Bill_FinalAmount.ToString(); lblDiscountContainer.Text = $"{popBill.Bill_Discount.ToString()}%"; lblTotalBalanceContainer.Text = popBill.Bill_Balance.ToString(); lblTotalPaymentMadeContainer.Text = popBill.Bill_PaymentMade.ToString(); lblFullPaidDateContainer.Text = popBill.Bill_DatePaid.ToString(); lblTuitionDueDateContainer.Text = popBill.Bill_DueDate.ToString(); billId = popBill.Bill_Id; } }