private void btnSell_Click(object sender, EventArgs e) { if (grv.RowCount <= 0) { XtraMessageBox.Show("Please add some product to sell"); return; } wrCustomers.Server2Client scc = new wrCustomers.Server2Client(); wrCustomers.wsCustomers cus = new wrCustomers.wsCustomers(); scc = cus.CreateDefaultCustomer(); int CusID = scc.Count; wrSales.Sale s = new wrSales.Sale(); s.InvoiceNo = txtINV.Text; s.SaleDate = dtpSDT.DateTime; s.CustomerID = CusID; s.Amount = Convert.ToDouble(txtAMT.EditValue); s.Discount = Convert.ToDouble(txtDSC.EditValue); s.Payment = Convert.ToDouble(txtPAM.EditValue); s.Balance = Convert.ToDouble(txtBAL.EditValue); sls = new wrSales.wsSales(); sc = sls.AddSale(s); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); return; } for (int i = 0; i <= grv.RowCount - 1; i++) { wrProducts.Server2Client spc = new wrProducts.Server2Client(); wrProducts.wsProducts prd = new wrProducts.wsProducts(); wrSales.Server2Client ssc = new wrSales.Server2Client(); wrSales.SaleDetail sd = new wrSales.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; ssc = sls.AddSaleDetails(sd); spc = prd.updateQuantity(sd.ProductID, sd.Quantity, "-"); } XtraMessageBox.Show("Product(s) Sold!"); grd.DataSource = null; InitInvoiceNo(); lueCAT.EditValue = null; luePNM.EditValue = null; lueCAT.Properties.DataSource = null; luePNM.Properties.DataSource = null; InitCategories(); InitProducts(); Reset(); }
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(); }
private void btnSell_Click(object sender, EventArgs e) { if (lueCNM.EditValue == null) { XtraMessageBox.Show("Please select Customer!"); return; } if (grv.RowCount <= 0) { XtraMessageBox.Show("Please add some product to sell"); return; } wrSales.Sale s = new wrSales.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); sc = new wrSales.Server2Client(); sls = new wrSales.wsSales(); sc = sls.AddSale(s); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); return; } wrCustomers.Server2Client scc = new wrCustomers.Server2Client(); wrCustomers.wsCustomers cus = new wrCustomers.wsCustomers(); wrCustomers.CustomerAccount ca = new wrCustomers.CustomerAccount(); 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; scc = cus.addTrans(ca); if (scc.Message != null) { XtraMessageBox.Show(scc.Message); return; } for (int i = 0; i <= grv.RowCount - 1; i++) { wrProducts.Server2Client spc = new wrProducts.Server2Client(); wrProducts.wsProducts prd = new wrProducts.wsProducts(); wrSales.SaleDetail sd = new wrSales.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 wrSales.Server2Client(); sc = sls.AddSaleDetails(sd); spc = prd.updateQuantity(sd.ProductID, sd.Quantity, "-"); } if (XtraMessageBox.Show("Do you want to print receipt?", "Print Receipt", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { sc = new wrSales.Server2Client(); sls = new wrSales.wsSales(); sc = sls.getSoldProductsByInvoiceNo(txtINV.Text); rptCashMemo rpt = new rptCashMemo() { DataSource = sc.dataTable }; 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}"); if (s.Discount > 0) { rpt.xrLabel8.Visible = true; rpt.lblDSC.Text = "(-) " + s.Discount.ToString("c2"); } else { rpt.xrLabel8.Visible = false; rpt.lblDSC.Text = ""; } rpt.lblTTL.Text = (s.Amount - s.Discount).ToString("c2"); rpt.lblAMW.Text = "Rupees " + Utils.NumbersToWords(Convert.ToInt32(s.Amount - s.Discount)) + " only"; rpt.ShowPreviewDialog(); } grd.DataSource = null; dt = new DataTable(); InitDataTable(); InitInvoiceNo(); lueCAT.EditValue = null; luePNM.EditValue = null; lueCAT.Properties.DataSource = null; luePNM.Properties.DataSource = null; InitCategories(); InitProducts(); Reset(); }