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;
VendorRefundMain objvRm = db.VendorRefundMains.Where(x => x.Id == BillNo).FirstOrDefault();
Vendor objVendor = db.Vendors.Where(x => x.Id == objvRm.VendorId).FirstOrDefault();
var RemainBalance = (db.VendorPayments.Where(x => x.VendorId == objVendor.Id).Sum(cp => cp.Debit)) - (db.VendorPayments.Where(x => x.VendorId == objVendor.Id).Sum(cp => cp.Credit));
List <VendorRefundDetail> objRd = db.VendorRefundDetails.Where(x => x.VRMId == objvRm.Id).ToList();
var str = db.InvoiceDetailForVendorRefund(objvRm.Id);
List <InvoiceDetailForVendorRefund_Result> objList = new List <InvoiceDetailForVendorRefund_Result>();
CustomerBalance.InnerHtml = "Remaining Balance: <b>" + Convert.ToDecimal(RemainBalance).ToString("#,##0") + "</b>";
dvCustomer.InnerHtml = "Vendor: <b>" + objVendor.Name + "</b>";
CusRef.InnerHtml = "Ref # :<b>" + objvRm.Reference + "</b>";
dvDate.InnerHtml = "Date: <b>" + DateTime.Parse(objvRm.CreatedOn.ToString()).Date.ToString("dd MMM yyyy") + "</b>";
dvBillNo.InnerHtml = "Reversal # :<b>" + objvRm.ReversalNo + "</b>";
foreach (InvoiceDetailForVendorRefund_Result item in str)
{
objList.Add(item);
}
rptBillItems.DataSource = objList;
rptBillItems.DataBind();
tPrice.Text = "Total : ";
tQty.Text = Convert.ToDecimal(objvRm.RQty).ToString("#,##0");
tAmount.Text = Convert.ToDecimal(objvRm.RSubTotal).ToString("#,##0");
NetBill.InnerHtml = Convert.ToDecimal(objvRm.RSubTotal).ToString("#,##0");
var Digits = n2w.ConvertAmount(Convert.ToDouble(objvRm.RSubTotal));
DigitToWords.InnerText = Digits.ToString();
}
}