private void BillTaxInfo_TaxOnBill_UpdateGUI() { ClearBillTaxValidationState(); Bill bill = session.GetObjectByKey <Bill>(BillId); radBillTaxInfoOnItems.Checked = false; radBillTaxInfoOnBill.Checked = true; panelBillTaxInfoOnItems.ClientVisible = false; panelBillTaxInfoOnBill.ClientVisible = true; double subtotalAfterPromotion = bill.SumOfItemPrice - bill.SumOfPromotion; if (subtotalAfterPromotion != 0) { lblSubtotalAfterPromotion.Text = String.Format("{0:#,###}", subtotalAfterPromotion); } else { lblSubtotalAfterPromotion.Text = "0"; } BillTax billTax = bill.BillTaxs.FirstOrDefault(); if (billTax == null) { billTax = new BillTax(session) { BillId = bill, TaxInNumber = 0, TaxInPercentage = 0 }; billTax.Save(); } if (billTax.TaxId != null) { comboVAT.Value = billTax.TaxId.TaxId; comboVAT.DataBindItems(); double taxTotal = subtotalAfterPromotion * billTax.TaxId.Percentage / 100; if (taxTotal != 0) { panelBillTaxInfoOnBill_lblVATAmount.Text = String.Format("{0:#,###}", taxTotal); } else { panelBillTaxInfoOnBill_lblVATAmount.Text = "0"; } } else { comboVAT.SelectedIndex = -1; panelBillTaxInfoOnBill_lblVATAmount.Text = "0"; } }
public static void UpdateSumOfTax(Session session, NAS.DAL.Invoice.Bill bill) { #region Update SumOfTax of the bill if (bill.TaxCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_BILL_BY_PERCENTAGE)) { BillTax billTax = bill.BillTaxs.FirstOrDefault(); if (billTax == null) { billTax = new BillTax(session) { BillId = bill, TaxInNumber = 0, TaxInPercentage = 0 }; billTax.Save(); } if (billTax.TaxId == null) { bill.SumOfTax = 0; } else { bill.SumOfTax = (bill.SumOfItemPrice - bill.SumOfPromotion) * billTax.TaxId.Percentage / 100; } } else if (bill.TaxCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_ITEMS)) { if (bill.PromotionCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_ITEMS)) { var billItemTaxs = bill.BillItems.SelectMany(r => r.BillItemTaxs); double taxInNumber = billItemTaxs.Sum(r => (r.BillItemId.TotalPrice - r.BillItemId.PromotionInNumber) * r.TaxInPercentage / 100); bill.SumOfTax = taxInNumber; bill.Save(); } else if (bill.PromotionCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_BILL_BY_AMOUNT) || bill.PromotionCalculationType.Equals(Utility.Constant.CALCULATION_TYPE_ON_BILL_BY_PERCENTAGE)) { var billItemTaxs = bill.BillItems.SelectMany(r => r.BillItemTaxs); double taxInNumber = billItemTaxs.Sum(r => r.BillItemId.TotalPrice * r.TaxInPercentage / 100); bill.SumOfTax = taxInNumber; bill.Save(); } } session.FlushChanges(); #endregion Update SumOfTax of the bill }
private void BillTaxInfo_TaxOnBill_UpdateData() { char taxCalculationType = Utility.Constant.CALCULATION_TYPE_ON_BILL_BY_PERCENTAGE; using (UnitOfWork uow = XpoHelper.GetNewUnitOfWork()) { Bill bill = uow.GetObjectByKey <Bill>(BillId); bill.TaxCalculationType = taxCalculationType; BillTax billTax = bill.BillTaxs.FirstOrDefault(); if (billTax == null) { billTax = new BillTax(uow) { BillId = bill, TaxInNumber = 0, TaxInPercentage = 0 }; } //Get selected VAT var val = comboVAT.Value; if (val != null) { Tax tax = uow.GetObjectByKey <Tax>(val); billTax.TaxId = tax; billTax.TaxInPercentage = tax.Percentage; billTax.TaxInNumber = tax.Amount; double subtotalAfterPromotion = bill.SumOfItemPrice - bill.SumOfPromotion; bill.SumOfTax = subtotalAfterPromotion * tax.Percentage / 100; bill.Total = subtotalAfterPromotion + bill.SumOfTax; } else { bill.SumOfTax = 0; bill.Total = bill.SumOfItemPrice - bill.SumOfPromotion; } uow.CommitChanges(); } }
public void updatePurchaseInvoice(Session session, NAS.DAL.Invoice.PurchaseInvoice purchaseInvoice, BillPromotion billPromotionProduct, BillTax billTaxProduct, BillPromotion billPromotionService, BillTax billTaxServce ) { UnitOfWork uow; using (uow = XpoHelper.GetNewUnitOfWork()) { purchaseInvoice.Save(); billPromotionProduct.Save(); billTaxProduct.Save(); billPromotionService.Save(); billTaxServce.Save(); uow.CommitChanges(); } }
public void updateSaleInvoice(Session session, NAS.DAL.Invoice.SalesInvoice salesInvoice, BillPromotion billPromotionProduct, BillTax billTaxProduct, BillPromotion billPromotionService, BillTax billTaxServce //SaleInvoiceTransaction saleInvoiceTransaction ) { UnitOfWork uow; using (uow = XpoHelper.GetNewUnitOfWork()) { salesInvoice.Save(); billPromotionProduct.Save(); billTaxProduct.Save(); billPromotionService.Save(); billTaxServce.Save(); uow.CommitChanges(); } }
public BillTax BillTaxInit(Session session, Bill BillId, Guid BillTaxId, Tax TaxId, double TaxInNumber, double TaxInPercentage ) { BillTax billTax = session.GetObjectByKey <BillTax>(BillTaxId); if (billTax == null) { billTax = new BillTax(session); billTax.BillTaxId = BillTaxId; } billTax.BillId = BillId; billTax.TaxId = TaxId; billTax.TaxInNumber = TaxInNumber; billTax.TaxInPercentage = TaxInPercentage; return(billTax); }
public BillTax BillTaxInit(Session session, Guid BillTaxId, double TaxInPercentage, double TaxInNumber, Guid TaxTypeId, Guid BillId ) { BillTax billTax = session.GetObjectByKey <BillTax>(BillTaxId); if (billTax == null) { billTax = new BillTax(session); } billTax.BillTaxId = BillTaxId; billTax.TaxInPercentage = TaxInPercentage; billTax.TaxInNumber = TaxInNumber; //billTax.TaxTypeId = session.GetObjectByKey<TaxType>(TaxTypeId); billTax.BillId = session.GetObjectByKey <Bill>(BillId); return(billTax); }
protected void btnSearch_Click(object sender, EventArgs e) { OpBal = 0; BillAmt = 0; BillTax = 0; PaidAmt = 0; PaidTax = 0; DueAmt = 0; TaxDueAmt = 0; TotalBill = 0; TotalPaid = 0; TotalDue = 0; BusinessLayer.Common.SemFeesGeneration ObjSemFees = new BusinessLayer.Common.SemFeesGeneration(); Entity.Common.SemFeesGeneration SemFees = new Entity.Common.SemFeesGeneration(); if (txtFromDate.Text == "") { SemFees.FromDate = null; } else { SemFees.FromDate = Convert.ToDateTime(txtFromDate.Text); } if (txtToDate.Text == "") { SemFees.ToDate = null; } else { SemFees.ToDate = Convert.ToDateTime(txtToDate.Text); } SemFees.MembershipCategoryId = int.Parse(ddlMembershipCategory.SelectedValue.Trim()); SemFees.BlockId = int.Parse(ddlBlock.SelectedValue.Trim()); SemFees.DistrictId = int.Parse(ddlDistrict.SelectedValue.Trim()); SemFees.StateId = int.Parse(ddlState.SelectedValue.Trim()); SemFees.Month = ""; // (ddlSubscriptionMonth.SelectedIndex == 0) ? string.Empty : ddlSubscriptionMonth.SelectedValue.Trim(); SemFees.Year = 0; // (ddlSubscriptionYear.SelectedIndex == 0) ? 0 : int.Parse(ddlSubscriptionYear.SelectedValue.Trim()); SemFees.FeesHeadId = int.Parse(ddlFeesHead.SelectedValue.Trim()); DataTable dt = ObjSemFees.GetConsolidated_StudentOutstandingReport(SemFees); if (dt != null) { dgvBill.DataSource = dt; dgvBill.DataBind(); } if (dt.Rows.Count > 0) { btnDownload.Visible = true; ((Literal)dgvBill.FooterRow.FindControl("ltrTotOpBalAmt")).Text = "<b>" + OpBal.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotBillAmt")).Text = "<b>" + BillAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxBillAmt")).Text = "<b>" + BillTax.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotPaidAmt")).Text = "<b>" + PaidAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxPaidAmt")).Text = "<b>" + PaidTax.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotDueAmt")).Text = "<b>" + DueAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotTaxDueAmt")).Text = "<b>" + TaxDueAmt.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotalBill")).Text = "<b>" + TotalBill.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotalPaid")).Text = "<b>" + TotalPaid.ToString("#0.00") + "</b>"; ((Literal)dgvBill.FooterRow.FindControl("ltrTotalDue")).Text = "<b>" + TotalDue.ToString("#0.00") + "</b>"; } else { btnDownload.Visible = false; } }