protected void Page_Load(object sender, EventArgs e)
{
if (Request["BillNo"] != null && Request["BillNo"] != "")
{
var BillNo = int.Parse(Request["BillNo"].ToString());
var Client = db.ClientDetails.FirstOrDefault();
ClientName.InnerText = Client.Name;
ClientAddress.InnerText = Client.Address;
ClientPhone.InnerText = Client.ContactNo;
ClientEmail.InnerText = Client.Email;
SaleMain objSaleMain = db.SaleMains.Where(x => x.Id == BillNo).SingleOrDefault();
Customer objCustomer = db.Customers.Where(x => x.Id == objSaleMain.CustomerId).FirstOrDefault();
//if (objCustomer.IsResaler == true)
//{
// changeHide.Visible = false;
//}
//else
//{
// RemainBalHide.Visible = false;
// trPBal.Visible = false;
//}
var RemainBalance = (db.CustomerPayments.Where(x => x.CustomerId == objCustomer.Id).Sum(cp => cp.Debit)) - (db.CustomerPayments.Where(x => x.CustomerId == objCustomer.Id).Sum(cp => cp.Credit));
List <SaleDetail> objSaleDetail = db.SaleDetails.Where(x => x.SMId == objSaleMain.Id).ToList();
var qty = 0;
var str = db.InvoiceDetailForReseller(objSaleMain.Id);
List <InvoiceDetailForReseller_Result> objList = new List <InvoiceDetailForReseller_Result>();
dvCustomer.InnerHtml = "Customer: <b>" + objCustomer.Name + "</b>";
CusAddress.InnerHtml = "Address: " + objCustomer.Address;
CusRef.InnerHtml = "Ref # : " + objSaleMain.Refrence;
CusPhone.InnerHtml = "Phone # : " + objCustomer.Contact;
dvDate.InnerHtml = "Date: <b>" + DateTime.Parse(objSaleMain.CreatedOn.ToString()).Date.ToString("dd MMM yyyy") + "</b>";
//dvTime.InnerHtml = "Time: " + DateTime.Parse(objSaleMain.CreatedOn.ToString()).ToString("hh:mm tt");
dvBillNo.InnerHtml = "Invoice # :<b>" + objSaleMain.InvoiceNo + "</b>";
foreach (InvoiceDetailForReseller_Result item in str)
{
objList.Add(item);
}
rptBillItems.DataSource = objList;
rptBillItems.DataBind();
tPrice.Text = "Total : ";
//lbltotalbill.InnerHtml = Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0");
InvoBal.InnerText = "Invoice Bill # : " + Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0");
decimal BillDisc = 0;
if (objSaleMain.BillDiscountType == 1) // Amount
{
BillDisc = decimal.Parse(Convert.ToDecimal(objSaleMain.BillDiscount).ToString());
}
else // %age
{
BillDisc = (decimal.Parse(objSaleMain.TotalAfterDiscount.ToString()) * decimal.Parse(objSaleMain.BillDiscount.ToString())) / 100;
}
decimal strDisc = Convert.ToDecimal(objSaleMain.ItemDiscount) + Convert.ToDecimal(BillDisc);
//lbldiscount.InnerHtml = Convert.ToDecimal(strDisc).ToString("#,##0");
tDiscount.Text = Convert.ToDecimal(strDisc).ToString("#,##0");
tQty.Text = Convert.ToDecimal(objSaleMain.TotalQty).ToString("#,##0");
tAmountAfterDiscount.Text = Convert.ToDecimal(objSaleMain.NetTotal).ToString("#,##0");
tAmount.Text = Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0");
//if (decimal.Parse(lbldiscount.InnerHtml) <= 0)
//{
// trdisc.Visible = false;
//}
//lblAdjustment.InnerHtml = Convert.ToDecimal(objSaleMain.Adjustment).ToString("#,##0");
//if (decimal.Parse(lblAdjustment.InnerHtml) <= 0)
//{
// tradjustment.Visible = false;
//}
var pBalance = (RemainBalance + objSaleMain.NetTotal) - objSaleMain.Recieved;
//if (pBalance < 0)
//{
// pBal.InnerHtml = '(' + Convert.ToDecimal(-pBalance).ToString("#,##0") + ')';
//}
//else
//{
// pBal.InnerHtml = pBalance.ToString();
//}
//lblnetpayable.InnerHtml = Convert.ToDecimal(objSaleMain.NetTotal).ToString("#,##0");
//lblcashreceived.InnerHtml = Convert.ToDecimal(objSaleMain.Recieved).ToString("#,##0");
//lblreturnback.InnerHtml = Convert.ToDecimal(objSaleMain.Change).ToString("#,##0");
if (RemainBalance < 0)
{
var negB = -1 * RemainBalance;
//rBal.InnerHtml = '(' + Convert.ToDecimal(negB).ToString("#,##0") + ')';
CurBal.InnerText = "(" + Convert.ToDecimal(negB).ToString("#,##0") + ")";
}
else
{
CurBal.InnerText = Convert.ToDecimal(RemainBalance).ToString("#,##0");
//rBal.InnerHtml = Convert.ToDecimal(RemainBalance).ToString("#,##0");
}
if (pBalance < 0)
{
var negB = -1 * pBalance;
//rBal.InnerHtml = '(' + Convert.ToDecimal(negB).ToString("#,##0") + ')';
PreBal.InnerText = "(" + Convert.ToDecimal(negB).ToString("#,##0") + ")";
}
else
{
PreBal.InnerText = Convert.ToDecimal(pBalance).ToString("#,##0");
//rBal.InnerHtml = Convert.ToDecimal(RemainBalance).ToString("#,##0");
}
InvoBal.InnerText = Convert.ToDecimal(objSaleMain.SubTotal).ToString("#,##0");
NetBill.InnerText = Convert.ToDecimal(objSaleMain.NetTotal).ToString("#,##0");
Rec.InnerText = Convert.ToDecimal(objSaleMain.Recieved).ToString("#,##0");
var Digits = n2w.ConvertAmount(Convert.ToDouble(objSaleMain.NetTotal));
DigitToWords.InnerText = Digits.ToString();
}
}
