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);
        }
示例#2
0
        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;
                            }
                        }
                    }
                }
            }
        }