public void PreviewInvoice() { List <Bill> lstBillD = new List <Bill>(); List <BillItem> lstBillItem = new List <BillItem>(); int id = Convert.ToInt32(Request.QueryString["CG_Id"]); if (id == 0) { id = Convert.ToInt32(Session["ConsignmentId"]); } int billId = Convert.ToInt32(Session["billId"]); int LocId = 0; if (basePage.LoggedInUser.UserLocation != null) { LocId = basePage.LoggedInUser.UserLocation.LocationId; } int userId = basePage.LoggedInUser.UserTypeId; if (userId == Convert.ToInt32(UserType.Admin) || userId == Convert.ToInt32(UserType.SuperAdmin)) { int Locid = 62; lstBillD = generateInvoiceBal.ReadPreviewEmailShow(Locid); } else { lstBillD = generateInvoiceBal.ReadPreviewEmailShow(LocId); } int flagg = Convert.ToInt32(Session["flag"]); // lblAddressInvoice.Text = lstBillD[0].AgentDetails.AgentAddress; // lblemailAddress.Text = lstBillD[0].AgentDetails.AgentEmail; lblfaxNumber.Text = lstBillD[0].AgentDetails.AgentFax; lblPhoneNumber.Text = lstBillD[0].AgentDetails.AgentPhone; string AgentName = Convert.ToString(Session["AgentName"]); string AgentAddress = Convert.ToString(Session["AgentAddress"]); string AgentPhone = Convert.ToString(Session["AgentPhone"]); Bill billDOM = (Bill)Session["billDOM"]; string visatype = billDOM.BillType; lstBillD = generateInvoiceBal.ReadBillIdByConsignmentId(id, visatype); if (billDOM.BillId != 0 && flagg == 2) { lblCopy.Text = "Duplicate Copy"; lblInvoiceNo.Text = "DEL" + Convert.ToString(billDOM.BillId); } else if (lstBillD.Count == 0) { GenerateInvoiceBAL generateBal = new GenerateInvoiceBAL(); List <Bill> lstBill = new List <Bill>(); lstBill = generateBal.ReadMaxBillIdForPrint(); lblInvoiceNo.Text = "DEL" + Convert.ToString(lstBill[0].BillId + 1); ImgbtnPrint.Visible = false; } else if (flagg == 1) { ImgbtnPrint.Visible = true; } else { lblInvoiceNo.Text = "DEL" + Convert.ToString(lstBillD[0].BillId); } if (userId == Convert.ToInt32(UserType.Admin) || userId == Convert.ToInt32(UserType.SuperAdmin)) { lstCon = consignmentBal.ReadDataByPaxConsignmentId(id, 0); lstConn = consignmentBal.ReadDataByConsignmentId(id, 0); } else { lstCon = consignmentBal.ReadDataByPaxConsignmentId(id, LocId); lstConn = consignmentBal.ReadDataByConsignmentId(id, LocId); } var lst = lstCon.Select(a => new { a.pax.PaxName }).Distinct().ToList(); if (lst.Count != 0) { string str = ""; for (int i = 0; i < lstCon.Count; i++) { if (str == "") { str = lstCon[i].pax.PaxName; } else { str += "," + lstCon[i].pax.PaxName; } } //lblCorporatepax.Text = str.ToString(); lblpax.Text = str; lblCorpName.Text = lstConn[0].CgCorporate; } lblRef.Text = "DEL" + Convert.ToString(id); lblserviceCharge.Text = Convert.ToString(billDOM.ServiceCharge); int servicecharge = Convert.ToInt32(billDOM.ServiceCharge); lblserviceTax.Text = Convert.ToString(Math.Round(billDOM.ServiceTax, 2)); decimal totalAmounts = decimal.Zero; foreach (BillItem billItem in billDOM.BillItemDetails) { billItem.BillItemDescription = billItem.BillItemDescription; billItem.ItemCharge = billItem.ItemCharge; billItem.ItemQuantity = billItem.ItemQuantity; billItem.ItemAmount = billItem.ItemAmount; totalAmounts = totalAmounts + billItem.ItemAmount; lstBillItem.Add(billItem); } double taxAmount = 00.00; if (servicecharge == 0) { // lblServicetaxCharge.Text = "12.36" + "%"; //double tax = 12.36; //double amount = Convert.ToDouble(totalAmounts); //lblServicetaxCharge.Text = "(" + Convert.ToString(Math.Round((amount * tax) / 100, 2)) + "%" + ")"; // lblServicetaxCharge.Text = "0"; } else { double tax = 12.36; //double amount =Convert.ToDouble(totalAmounts); // lblServicetaxCharge.Text = "(" + Convert.ToString(Math.Round((billDOM.ServiceTax * 100) / servicecharge, 2)) + "%" + ")"; var taxs = Convert.ToString(Math.Round((servicecharge * tax) / 100)); //lblServicetaxCharge.Text = taxs; taxAmount = taxAmount + Convert.ToDouble(taxs); lblserviceTax.Text = Convert.ToString(taxAmount); } lblCorpName.Text = lstConn[0].CgCorporate; //lbltotalAmt.Text = Convert.ToString(Math.Round(billDOM.TotalAmount, 2)); lbltotalAmt.Text = Convert.ToString(totalAmounts); lblNetAmt.Text = Convert.ToString(Math.Round((totalAmounts + billDOM.ServiceCharge + Convert.ToDecimal(taxAmount)))) + ".00"; lblpax.Text = Convert.ToString(billDOM.Paxs); lblDate.Text = Convert.ToString(billDOM.BillDate); lblName.Text = Convert.ToString(AgentName); lblAddress.Text = Convert.ToString(AgentAddress); lblPhone.Text = Convert.ToString(AgentPhone); billDOM.BillConsignment = new Consignment(); gvPreviewInvoice.DataSource = lstBillItem; gvPreviewInvoice.DataBind(); Decimal Total = Convert.ToDecimal(lblNetAmt.Text); Int64 NumVal = (Int64)Total; lblAmountNet.Text = Rupees(NumVal); }
protected void gridviewInvoiceList_RowCommand(object sender, GridViewCommandEventArgs e) { int flag = 0; string commndString = e.CommandArgument.ToString(); string[] str = commndString.Split(','); if (e.CommandName == "Print") { if (rbtnInvoiceLst.SelectedValue == "1") { Bill billDOM = new Bill(); GenerateInvoiceBAL generateBAL = new GenerateInvoiceBAL(); List <Bill> lstBill = (List <Bill>)Session["lstBill"]; List <BillItem> lstBillItem = new List <BillItem>(); billDOM.BillItemDetails = new List <BillItem>(); billDOM.BillConsignment = new Consignment(); if (basePage.LoggedInUser.UserLocation != null) { int LocId = basePage.LoggedInUser.UserLocation.LocationId; } int userId = basePage.LoggedInUser.UserTypeId; string strg = e.CommandArgument.ToString(); string[] str1 = strg.Split(','); int Billid = Convert.ToInt32(str1[0]); int versionNo = Convert.ToInt32(str1[1]); Session["version"] = versionNo; if (versionNo == 0) { for (int i = 0; i < lstBill.Count; i++) { if (Billid == lstBill[i].BillId) { Session["flag"] = 1; int billId = lstBill[i].BillId; int CG_Id = lstBill[i].ConsignmentId; if (userId == Convert.ToInt32(UserType.Admin) || userId == Convert.ToInt32(UserType.SuperAdmin)) { LocId = 0; lstBillItem = generateBAL.ReadBillItemRePrintInvoice(billId, null, null); } else { lstBillItem = generateBAL.ReadBillItemRePrintInvoice(billId, null, null); } for (int j = 0; j < lstBillItem.Count; j++) { billDOM.BillItemDetail = new BillItem(); billDOM.BillItemDetail.BillItemDescription = lstBillItem[j].BillItemDescription; billDOM.BillItemDetail.ItemCharge = lstBillItem[j].ItemCharge; billDOM.BillItemDetail.ItemQuantity = lstBillItem[j].ItemQuantity; billDOM.BillItemDetail.ItemAmount = lstBillItem[j].ItemCharge * lstBillItem[j].ItemQuantity; billDOM.BillItemDetails.Add(billDOM.BillItemDetail); } billDOM.BillDate = lstBill[i].BillDate; billDOM.BillId = lstBill[i].BillId; billDOM.ServiceCharge = lstBill[i].ServiceCharge; billDOM.ServiceTax = lstBill[i].ServiceTax; billDOM.TotalAmount = lstBill[i].TotalAmount; billDOM.Paxs = lstBill[i].Paxs; billDOM.BillId = lstBill[i].BillId; Session["billDOM"] = billDOM; Session["AgentName"] = lstBill[i].AgentDetails.AgentName; Session["AgentAddress"] = lstBill[i].AgentDetails.AgentAddress; Session["AgentPhone"] = lstBill[i].AgentDetails.AgentPhone; Session["ConsignmentId"] = CG_Id; } } } //else //{ // Response.Write("<script LANGUAGE='JavaScript' >alert('Please Select Version For Print Invoice. ')</script>"); //} if (Billid > 0) { //Response.Redirect("PreviewPrintInvoice.aspx?CG_Id=" + ConsignmentId); string url = "PreviewPrintInvoice.aspx?Bill_Id=" + Billid; string fullURL = "window.open('" + url + "', '_blank', 'height=500,width=800,status=yes,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=no,titlebar=no' );"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); } } } if (rbtnInvoiceLst.SelectedValue == "2") { if (rbtnInvoiceLst.SelectedValue == "2") { int rcptId = Convert.ToInt32(str[0]); ReceiptGenerationBusinessAccess rcptGenerationBal = new ReceiptGenerationBusinessAccess(); List <Receipt> lstRcpt = new List <Receipt>(); // lstRcpt = rcptGenerationBal.ReadRcptAll(rcptId); if (basePage.LoggedInUser.UserLocation != null) { int LocId = basePage.LoggedInUser.UserLocation.LocationId; } int userId = basePage.LoggedInUser.UserTypeId; if (userId == Convert.ToInt32(UserType.Admin)) { LocId = 0; lstRcpt = rcptGenerationBal.ReadRcptAll(rcptId, LocId); } else { lstRcpt = rcptGenerationBal.ReadRcptAll(rcptId, LocId); } List <ReceiptDetails> lstRcptDetails = new List <ReceiptDetails>(); lstRcptDetails = rcptGenerationBal.ReadRcptDetailsByRcptNo(rcptId); if (lstRcpt.Count == 0) { ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "MyScript", "alert('No Receipt Found With This Receipt No !!');", true); txtFromDate.Focus(); } else { Session["RcptId"] = rcptId; Session["lstRcpt"] = lstRcpt; if (lstRcpt[0].RcptType == " Advance") { Session["NewlstReceipt"] = lstRcpt; Session["agentName"] = lstRcpt[0].agent.AgentName; if (rcptId > 0) { flag = 1; Session["Flag"] = flag; string url = "ReceiptPrint.aspx?receiptAdvance=" + rcptId; string fullUrl = "window.open('" + url + "','_blank','height=500,width=800,status=yes,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=no,titlebar=no,addressbars=0,directories=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullUrl, true); } else { Session["Flag"] = flag; } } else { Session["NewlstRcptDetails"] = lstRcptDetails; if (rcptId > 0) { flag = 1; Session["Flag"] = flag; string url = "ReceiptPrint.aspx?RcptId=" + rcptId; string fullUrl = "window.open('" + url + "','_blank','height=500,width=800,status=yes,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=no,titlebar=no,addressbars=0,directories=no');"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullUrl, true); } else { Session["Flag"] = flag; } } } } } }