示例#1
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            sc  = new wrSales.Server2Client();
            sls = new wrSales.wsSales();
            wrSales.Sale       ss = new wrSales.Sale();
            wrSales.SaleDetail sd = new wrSales.SaleDetail();

            ss.SaleDate  = dtpSDT.DateTime;
            ss.InvoiceNo = lueINV.EditValue.ToString();
            ss.Amount    = Convert.ToDouble(txtAMT.EditValue);
            ss.Discount  = Convert.ToDouble(txtDSC.EditValue);
            ss.Payment   = Convert.ToDouble(txtPAM.EditValue);
            ss.Balance   = Convert.ToDouble(txtBAL.EditValue);

            sc = sls.UpdateSales(ss);
            if (sc.Message != null)
            {
                XtraMessageBox.Show(sc.Message);
                return;
            }

            for (int i = 0; i <= grv.RowCount - 1; i++)
            {
                sd.SaleDetailID = Convert.ToInt32(grv.GetRowCellValue(i, colSID));
                sd.SellingValue = Convert.ToDouble(grv.GetRowCellValue(i, colSVL));
                sd.Amount       = Convert.ToDouble(grv.GetRowCellValue(i, colAMT));

                sc = sls.UpdateSaleDetail(sd);
                if (sc.Message != null)
                {
                    XtraMessageBox.Show(sc.Message);
                    return;
                }
            }

            XtraMessageBox.Show("Done!");
            sc = sls.getSoldProductsByInvoiceNo(lueINV.EditValue.ToString());
            XRSummary total = new XRSummary();

            rptCashMemo rpc = new rptCashMemo()
            {
                DataSource = sc.dataTable
            };

            rpc.lblCNM.DataBindings.Add("Text", null, "CustomerName");
            rpc.lblADR.DataBindings.Add("Text", null, "Address");
            rpc.lblPHN.DataBindings.Add("Text", null, "Phone");

            rpc.lblINV.DataBindings.Add("Text", null, "InvoiceNo");
            rpc.lblSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}");

            rpc.lblPNM.DataBindings.Add("Text", null, "ProductName");
            rpc.lbSNO.DataBindings.Add("Text", null, "BarCode");
            rpc.lblQTY.DataBindings.Add("Text", null, "Quantity");
            rpc.lblPRC.DataBindings.Add("Text", null, "SellingValue", "{0:c}");
            rpc.lblDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
            rpc.lblAMT.DataBindings.Add("Text", null, "Amount", "{0:c}");
            rpc.lblTTL.DataBindings.Add("Text", null, "Amount", "{0:c}");

            total.FormatString = "{0:C2}";
            total.Running      = SummaryRunning.Report;
            rpc.lblTTL.Summary = total;
            //rpt.lblTTL.Text = s.Amount.ToString("c2");
            double dsc = 0;
            int    amt = 0;

            for (int i = 0; i <= sc.dataTable.Rows.Count - 1; i++)
            {
                dsc += Convert.ToDouble(sc.dataTable.Rows[i].ItemArray[10]);
                amt += Convert.ToInt32(sc.dataTable.Rows[i].ItemArray[9]);
            }
            if (dsc <= 0)
            {
                rpc.xrLabel8.Visible = false;
                rpc.lblDSC.Visible   = false;
            }
            rpc.lblAMW.Text = "Rupees " + Utils.NumbersToWords(Convert.ToInt32(amt)) + " only";
            rpc.ShowPreviewDialog();
        }
示例#2
0
        private void btnSell_Click(object sender, EventArgs e)
        {
            if (grv.RowCount <= 0)
            {
                XtraMessageBox.Show("Please add some product to sell");
                return;
            }

            Sale s = new Sale();

            s.InvoiceNo  = txtINV.Text;
            s.SaleDate   = dtpSDT.DateTime;
            s.CustomerID = Convert.ToInt32(lueCNM.EditValue);
            s.Amount     = Convert.ToDouble(txtAMT.EditValue);
            s.Discount   = Convert.ToDouble(txtDSC.EditValue);
            s.Payment    = Convert.ToDouble(txtPAM.EditValue);
            s.Balance    = Convert.ToDouble(txtBAL.EditValue);

            Server2Client sc  = new Server2Client();
            Sales         sls = new Sales();

            sc = sls.AddSale(s);
            if (sc.Message != null)
            {
                XtraMessageBox.Show(sc.Message);
                return;
            }

            CustomerAccounts cas = new CustomerAccounts();
            CustomerAccount  ca  = new CustomerAccount();
            Customer         c   = new Customer();

            cas            = new CustomerAccounts();
            ca.CustomerID  = Convert.ToInt32(lueCNM.EditValue);
            ca.TransDate   = s.SaleDate;
            ca.Description = s.InvoiceNo;
            if (s.Balance == 0)
            {
                ca.Debit  = s.Payment;
                ca.Credit = s.Payment;
            }
            else
            {
                ca.Debit  = s.Amount - s.Discount;
                ca.Credit = s.Payment;
            }
            ca.Balance = CustomerBalance + s.Balance;
            sc         = cas.addTrans(ca);


            if (sc.Message != null)
            {
                XtraMessageBox.Show(sc.Message);
                return;
            }

            for (int i = 0; i <= grv.RowCount - 1; i++)
            {
                Products   prd = new Products();
                SaleDetail sd  = new SaleDetail();
                sd.InvoiceNo    = txtINV.Text;
                sd.ProductID    = Convert.ToInt32(grv.GetRowCellValue(i, colPID));
                sd.Quantity     = Convert.ToInt32(grv.GetRowCellValue(i, colQTY));
                sd.BuyingValue  = Convert.ToDouble(grv.GetRowCellValue(i, colBVL));
                sd.SellingValue = Convert.ToDouble(grv.GetRowCellValue(i, colSVL));
                sd.Amount       = sd.Quantity * sd.SellingValue;

                sc = new Server2Client();
                sc = sls.AddSaleDetails(sd);
                sc = prd.updateQuantity(sd.ProductID, sd.Quantity, "-");
            }

            if (XtraMessageBox.Show("Do you want to print receipt?", "Print Receipt", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                rptCashMemo rpt = new rptCashMemo()
                {
                    DataSource = dt
                };
                rpt.lblCNM.Text = cc.CustomerName;
                rpt.lblADR.Text = cc.Address;
                rpt.lblPHN.Text = cc.Phone;

                rpt.lblINV.Text = txtINV.Text;
                rpt.lblSDT.Text = dtpSDT.DateTime.ToShortDateString();

                rpt.lblPNM.DataBindings.Add("Text", null, "ProductName");
                rpt.lbSNO.DataBindings.Add("Text", null, "BarCode");
                rpt.lblQTY.DataBindings.Add("Text", null, "Quantity");
                rpt.lblPRC.DataBindings.Add("Text", null, "SellingValue", "{0:c}");
                rpt.lblAMT.DataBindings.Add("Text", null, "Amount", "{0:c}");
                rpt.lblDSC.Text = "(-) " + s.Discount.ToString("c2");
                rpt.lblTTL.Text = s.Payment.ToString("c2");
                rpt.lblAMW.Text = "Rupees " + Utils.NumbersToWords(Convert.ToInt32(s.Payment)) + " only";

                rpt.ShowPreviewDialog();
            }
            grd.DataSource = null;
            InitInvoiceNo();
            lueCAT.EditValue             = null;
            luePNM.EditValue             = null;
            lueCAT.Properties.DataSource = null;
            luePNM.Properties.DataSource = null;
            InitCategories();
            InitProducts();
            Reset();
        }
示例#3
0
        private void bSoldProducts_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            frmSelect frm = new frmSelect();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                wrSales.Server2Client sc;
                wrSales.wsSales       s;

                rptSoldProducts       rpt = new rptSoldProducts();
                wrSettings.wrSettings stg = new wrSettings.wrSettings();
                double SVC = 0;

                if (frm.RetVal == 0)
                {
                    sc  = new wrSales.Server2Client();
                    s   = new wrSales.wsSales();
                    sc  = s.getSoldProductsByDate(frm.DateOn);
                    SVC = stg.GetServicingByDate(frm.DateOn);
                    rptProductSold r = new rptProductSold()
                    {
                        DataSource = sc.dataTable
                    };
                    //rpt.DataSource = sc.dataTable;
                    //SELECT Sale.InvoiceNo, Product.ProductName, GROUP_CONCAT(Product.BarCode) BarCode, SaleDetail.SellingValue, Sum(SaleDetail.Quantity) AS SumOfQuantity, Sale.Amount, Sale.Discount, Sale.Payment, Sale.Balance
                    r.lbTTL.Text = "Products sold On " + frm.DateOn.ToShortDateString();
                    XRSummary tam = new XRSummary();
                    XRSummary tdc = new XRSummary();
                    XRSummary tpm = new XRSummary();
                    XRSummary tbl = new XRSummary();
                    XRSummary gam = new XRSummary();
                    XRSummary gdc = new XRSummary();
                    XRSummary gpm = new XRSummary();
                    XRSummary gbl = new XRSummary();

                    //GroupField grp = new GroupField("SaleDate");
                    //GroupField cnm = new GroupField("CustomerName");

                    GroupField sdt = new GroupField("SaleDate");
                    GroupField inv = new GroupField("InvoiceNo");

                    //rpt.GroupHeader1.GroupFields.Add(grp);
                    //rpt.GroupHeader2.GroupFields.Add(cnm);

                    r.grpSDT.GroupFields.Add(sdt);
                    r.grpSDT.GroupFields.Add(inv);
                    //r.sbnINV.Band.

                    r.lbINV.DataBindings.Add("Text", null, "InvoiceNo");
                    r.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}");
                    r.lbPNM.DataBindings.Add("Text", null, "ProductName");
                    r.lbBCD.DataBindings.Add("Text", null, "BarCode");
                    r.lbSVL.DataBindings.Add("Text", null, "SellingValue", "{0:C2}");
                    r.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity");
                    r.lbAMT.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    r.lbDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    r.lbPAM.DataBindings.Add("Text", null, "Payment", "{0:C2}");
                    r.lbBAL.DataBindings.Add("Text", null, "Balance", "{0:C2}");
                    r.lbTAM.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    r.lbTDC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    r.lbTPM.DataBindings.Add("Text", null, "Payment", "{0:C2}");
                    r.lbTBL.DataBindings.Add("Text", null, "Balance", "{0:C2}");
                    r.lbGAM.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    r.lbGDC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    r.lbGPM.DataBindings.Add("Text", null, "Payment", "{0:C2}");
                    r.lbGBL.DataBindings.Add("Text", null, "Balance", "{0:C2}");

                    tam.FormatString = "{0:C2}";
                    tdc.FormatString = "{0:C2}";
                    tpm.FormatString = "{0:C2}";
                    tbl.FormatString = "{0:C2}";
                    gam.FormatString = "{0:C2}";
                    gdc.FormatString = "{0:C2}";
                    gpm.FormatString = "{0:C2}";
                    gbl.FormatString = "{0:C2}";

                    tam.Running = SummaryRunning.Group;
                    tdc.Running = SummaryRunning.Group;
                    tpm.Running = SummaryRunning.Group;
                    tbl.Running = SummaryRunning.Group;
                    gam.Running = SummaryRunning.Report;
                    gdc.Running = SummaryRunning.Report;
                    gpm.Running = SummaryRunning.Report;
                    gbl.Running = SummaryRunning.Report;

                    r.lbTAM.Summary = tam;
                    r.lbTDC.Summary = tdc;
                    r.lbTPM.Summary = tpm;
                    r.lbTBL.Summary = tbl;
                    r.lbGAM.Summary = gam;
                    r.lbGDC.Summary = gdc;
                    r.lbGPM.Summary = gpm;
                    r.lbGBL.Summary = gbl;

                    r.lbSVC.Text = SVC.ToString("C2");

                    dv.PrintingSystem = r.PrintingSystem;
                    r.CreateDocument(true);
                }
                else if (frm.RetVal == 1)
                {
                    sc  = new wrSales.Server2Client();
                    s   = new wrSales.wsSales();
                    sc  = s.getSoldProductsByDates(frm.DateFrom, frm.DateTo);
                    SVC = stg.GetServicingByDates(frm.DateFrom, frm.DateTo);
                    //rpt.DataSource = sc.dataTable;

                    //rpt.lbTTL.Text = "Products sold Between " + frm.DateFrom.ToShortDateString() + " and " + frm.DateTo.ToShortDateString();
                    //XRSummary stt = new XRSummary();
                    //XRSummary gtt = new XRSummary();

                    //GroupField grp = new GroupField("SaleDate");
                    //rpt.GroupHeader1.GroupFields.Add(grp);

                    //rpt.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}");
                    //rpt.lbPNM.DataBindings.Add("Text", null, "ProductName");
                    //rpt.lbPID.DataBindings.Add("Text", null, "BarCode");
                    //rpt.lbSVL.DataBindings.Add("Text", null, "SellingValue", "{0:C2}");
                    //rpt.lbQTY.DataBindings.Add("Text", null, "Quantity");
                    //rpt.lbAMT.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    //rpt.lbSTT.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    //rpt.lbGTT.DataBindings.Add("Text", null, "Amount", "{0:C2}");

                    //stt.FormatString = "{0:C2}";
                    //gtt.FormatString = "{0:C2}";

                    //stt.Running = SummaryRunning.Group;
                    //gtt.Running = SummaryRunning.Report;

                    //rpt.lbSTT.Summary = stt;
                    //rpt.lbGTT.Summary = gtt;

                    //dv.PrintingSystem = rpt.PrintingSystem;
                    //rpt.CreateDocument(true);
                    rptProductSold r = new rptProductSold()
                    {
                        DataSource = sc.dataTable
                    };
                    //rpt.DataSource = sc.dataTable;
                    //SELECT Sale.InvoiceNo, Product.ProductName, GROUP_CONCAT(Product.BarCode) BarCode, SaleDetail.SellingValue, Sum(SaleDetail.Quantity) AS SumOfQuantity, Sale.Amount, Sale.Discount, Sale.Payment, Sale.Balance
                    r.lbTTL.Text = "Products sold On " + frm.DateOn.ToShortDateString();
                    XRSummary tam = new XRSummary();
                    XRSummary tdc = new XRSummary();
                    XRSummary tpm = new XRSummary();
                    XRSummary tbl = new XRSummary();
                    XRSummary gam = new XRSummary();
                    XRSummary gdc = new XRSummary();
                    XRSummary gpm = new XRSummary();
                    XRSummary gbl = new XRSummary();

                    //GroupField grp = new GroupField("SaleDate");
                    //GroupField cnm = new GroupField("CustomerName");

                    GroupField sdt = new GroupField("SaleDate");
                    GroupField inv = new GroupField("InvoiceNo");

                    //rpt.GroupHeader1.GroupFields.Add(grp);
                    //rpt.GroupHeader2.GroupFields.Add(cnm);

                    r.grpSDT.GroupFields.Add(sdt);
                    r.grpSDT.GroupFields.Add(inv);
                    //r.sbnINV.Band.

                    r.lbINV.DataBindings.Add("Text", null, "InvoiceNo");
                    r.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}");
                    r.lbPNM.DataBindings.Add("Text", null, "ProductName");
                    r.lbBCD.DataBindings.Add("Text", null, "BarCode");
                    r.lbSVL.DataBindings.Add("Text", null, "SellingValue", "{0:C2}");
                    r.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity");
                    r.lbAMT.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    r.lbDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    r.lbPAM.DataBindings.Add("Text", null, "Payment", "{0:C2}");
                    r.lbBAL.DataBindings.Add("Text", null, "Balance", "{0:C2}");
                    r.lbTAM.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    r.lbTDC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    r.lbTPM.DataBindings.Add("Text", null, "Payment", "{0:C2}");
                    r.lbTBL.DataBindings.Add("Text", null, "Balance", "{0:C2}");
                    r.lbGAM.DataBindings.Add("Text", null, "Amount", "{0:C2}");
                    r.lbGDC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    r.lbGPM.DataBindings.Add("Text", null, "Payment", "{0:C2}");
                    r.lbGBL.DataBindings.Add("Text", null, "Balance", "{0:C2}");

                    tam.FormatString = "{0:C2}";
                    tdc.FormatString = "{0:C2}";
                    tpm.FormatString = "{0:C2}";
                    tbl.FormatString = "{0:C2}";
                    gam.FormatString = "{0:C2}";
                    gdc.FormatString = "{0:C2}";
                    gpm.FormatString = "{0:C2}";
                    gbl.FormatString = "{0:C2}";

                    tam.Running = SummaryRunning.Group;
                    tdc.Running = SummaryRunning.Group;
                    tpm.Running = SummaryRunning.Group;
                    tbl.Running = SummaryRunning.Group;
                    gam.Running = SummaryRunning.Report;
                    gdc.Running = SummaryRunning.Report;
                    gpm.Running = SummaryRunning.Report;
                    gbl.Running = SummaryRunning.Report;

                    r.lbTAM.Summary   = tam;
                    r.lbTDC.Summary   = tdc;
                    r.lbTPM.Summary   = tpm;
                    r.lbTBL.Summary   = tbl;
                    r.lbGAM.Summary   = gam;
                    r.lbGDC.Summary   = gdc;
                    r.lbGPM.Summary   = gpm;
                    r.lbGBL.Summary   = gbl;
                    r.lbSVC.Text      = SVC.ToString("C2");
                    dv.PrintingSystem = r.PrintingSystem;
                    r.CreateDocument(true);
                }
                else
                {
                    sc = new wrSales.Server2Client();
                    s  = new wrSales.wsSales();
                    //sc = s.getSoldByInvoice(frm.InvoiceNo);
                    sc = s.getSoldProductsByInvoiceNo(frm.InvoiceNo);
                    XRSummary total = new XRSummary();

                    rptCashMemo rpc = new rptCashMemo()
                    {
                        DataSource = sc.dataTable
                    };
                    rpc.lblCNM.DataBindings.Add("Text", null, "CustomerName");
                    rpc.lblADR.DataBindings.Add("Text", null, "Address");
                    rpc.lblPHN.DataBindings.Add("Text", null, "Phone");

                    rpc.lblINV.DataBindings.Add("Text", null, "InvoiceNo");
                    rpc.lblSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}");

                    rpc.lblPNM.DataBindings.Add("Text", null, "ProductName");
                    rpc.lbSNO.DataBindings.Add("Text", null, "BarCode");
                    rpc.lblQTY.DataBindings.Add("Text", null, "Quantity");
                    rpc.lblPRC.DataBindings.Add("Text", null, "SellingValue", "{0:c}");
                    rpc.lblDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    rpc.lblAMT.DataBindings.Add("Text", null, "Amount", "{0:c}");
                    rpc.lblTTL.DataBindings.Add("Text", null, "Amount", "{0:c}");

                    total.FormatString = "{0:C2}";
                    total.Running      = SummaryRunning.Report;
                    rpc.lblTTL.Summary = total;
                    //rpt.lblTTL.Text = s.Amount.ToString("c2");
                    double dsc = 0;
                    int    amt = 0;
                    for (int i = 0; i <= sc.dataTable.Rows.Count - 1; i++)
                    {
                        dsc += Convert.ToDouble(sc.dataTable.Rows[i].ItemArray[10]);
                        amt += Convert.ToInt32(sc.dataTable.Rows[i].ItemArray[9]);
                    }
                    if (dsc <= 0)
                    {
                        rpc.xrLabel8.Visible = false;
                        rpc.lblDSC.Visible   = false;
                    }
                    rpc.lblAMW.Text   = "Rupees " + Utils.NumbersToWords(Convert.ToInt32(amt)) + " only";
                    dv.PrintingSystem = rpc.PrintingSystem;
                    rpc.CreateDocument(true);
                }
            }
        }
示例#4
0
        private void bSoldProducts_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            frmSelect frm = new frmSelect();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                Server2Client sc;
                Sales         s;

                rptSoldProducts rpt = new rptSoldProducts();

                if (frm.RetVal == 0)
                {
                    sc             = new Server2Client();
                    s              = new Sales();
                    sc             = s.getSoldProducts(frm.DateOn);
                    rpt.DataSource = sc.dataTable;

                    rpt.lbTTL.Text = "Products sold On " + frm.DateOn.ToShortDateString();
                    XRSummary stt = new XRSummary();
                    XRSummary gtt = new XRSummary();

                    GroupField grp = new GroupField("SaleDate");
                    rpt.GroupHeader1.GroupFields.Add(grp);

                    rpt.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}");
                    rpt.lbPNM.DataBindings.Add("Text", null, "ProductName");
                    rpt.lbPID.DataBindings.Add("Text", null, "BarCode");
                    rpt.lbSVL.DataBindings.Add("Text", null, "SumOfSellingValue", "{0:C2}");
                    rpt.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity");
                    rpt.lbAMT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}");
                    rpt.lbSTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}");
                    rpt.lbGTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}");

                    stt.FormatString = "{0:C2}";
                    gtt.FormatString = "{0:C2}";

                    stt.Running = SummaryRunning.Group;
                    gtt.Running = SummaryRunning.Report;

                    rpt.lbSTT.Summary = stt;
                    rpt.lbGTT.Summary = gtt;

                    dv.PrintingSystem = rpt.PrintingSystem;
                    rpt.CreateDocument(true);
                }
                else if (frm.RetVal == 1)
                {
                    sc             = new Server2Client();
                    s              = new Sales();
                    sc             = s.getSoldProducts(frm.DateFrom, frm.DateTo);
                    rpt.DataSource = sc.dataTable;

                    rpt.lbTTL.Text = "Products sold Between " + frm.DateFrom.ToShortDateString() + " and " + frm.DateTo.ToShortDateString();
                    XRSummary stt = new XRSummary();
                    XRSummary gtt = new XRSummary();

                    GroupField grp = new GroupField("SaleDate");
                    rpt.GroupHeader1.GroupFields.Add(grp);

                    rpt.lbSDT.DataBindings.Add("Text", null, "SaleDate", "{0:dd-MM-yyyy}");
                    rpt.lbPNM.DataBindings.Add("Text", null, "ProductName");
                    rpt.lbPID.DataBindings.Add("Text", null, "BarCode");
                    rpt.lbSVL.DataBindings.Add("Text", null, "SumOfSellingValue", "{0:C2}");
                    rpt.lbQTY.DataBindings.Add("Text", null, "SumOfQuantity");
                    rpt.lbAMT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}");
                    rpt.lbSTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}");
                    rpt.lbGTT.DataBindings.Add("Text", null, "SumOfAmount", "{0:C2}");

                    stt.FormatString = "{0:C2}";
                    gtt.FormatString = "{0:C2}";

                    stt.Running = SummaryRunning.Group;
                    gtt.Running = SummaryRunning.Report;

                    rpt.lbSTT.Summary = stt;
                    rpt.lbGTT.Summary = gtt;

                    dv.PrintingSystem = rpt.PrintingSystem;
                    rpt.CreateDocument(true);
                }
                else
                {
                    sc = new Server2Client();
                    s  = new Sales();

                    sc = s.getSoldProducts(frm.InvoiceNo);
                    XRSummary total = new XRSummary();

                    rptCashMemo rpc = new rptCashMemo()
                    {
                        DataSource = sc.dataTable
                    };
                    rpc.lblCNM.DataBindings.Add("Text", null, "CustomerName");
                    rpc.lblADR.DataBindings.Add("Text", null, "Address");
                    rpc.lblPHN.DataBindings.Add("Text", null, "Phone");

                    rpc.lblINV.DataBindings.Add("Text", null, "InvoiceNo");
                    rpc.lblSDT.DataBindings.Add("Text", null, "SaleDate");

                    rpc.lblPNM.DataBindings.Add("Text", null, "ProductName");
                    rpc.lbSNO.DataBindings.Add("Text", null, "BarCode");
                    rpc.lblQTY.DataBindings.Add("Text", null, "Quantity");
                    rpc.lblPRC.DataBindings.Add("Text", null, "SellingValue", "{0:c}");
                    rpc.lblDSC.DataBindings.Add("Text", null, "Discount", "{0:C2}");
                    rpc.lblAMT.DataBindings.Add("Text", null, "Amount", "{0:c}");
                    rpc.lblTTL.DataBindings.Add("Text", null, "Payment", "{0:c}");

                    total.FormatString = "{0:C2}";
                    total.Running      = SummaryRunning.Report;
                    rpc.lblTTL.Summary = total;
                    //rpt.lblTTL.Text = s.Amount.ToString("c2");
                    int amt = 0;
                    for (int i = 0; i <= sc.dataTable.Rows.Count - 1; i++)
                    {
                        amt += Convert.ToInt32(sc.dataTable.Rows[i].ItemArray[9]);
                    }
                    rpc.lblAMW.Text   = "Rupees " + Utils.NumbersToWords(Convert.ToInt32(amt)) + " only";
                    dv.PrintingSystem = rpc.PrintingSystem;
                    rpc.CreateDocument(true);
                }
            }
        }