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