private void btnOK_Click(object sender, EventArgs e) { if (!dxVP.Validate()) { return; } wrProducts.Product p = new wrProducts.Product(); p.ProductID = Convert.ToInt32(luePRD.EditValue); p.CategoryID = Convert.ToInt32(lueCAT2.EditValue); p.ProductName = txtPNM.EditValue.ToString(); p.BuyingValue = Convert.ToDouble(txtBVL.EditValue); p.SellingValue = Convert.ToDouble(txtSVL.EditValue); p.Quantity = Convert.ToInt32(txtQTY.EditValue); p.BarCode = txtBCD.Text; sc = new wrProducts.Server2Client(); prd = new wrProducts.wsProducts(); sc = prd.updateProduct(p); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); } else { DialogResult = DialogResult.OK; } }
private void grv_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { int qty = 0; double prc = 0; switch (e.Column.Caption) { case "Particulars": int PID = Convert.ToInt32(grv.GetFocusedRowCellValue(colPID)); wrProducts.Server2Client spc = new wrProducts.Server2Client(); wrProducts.wsProducts prd = new wrProducts.wsProducts(); wrProducts.Product p = new wrProducts.Product(); p = prd.GetProductByID(PID); grv.SetFocusedRowCellValue(colBVL, p.BuyingValue); grv.SetFocusedRowCellValue(colSVL, p.SellingValue); grv.UpdateCurrentRow(); break; case "Quantity": qty = Convert.ToInt32(grv.GetFocusedRowCellValue(colQTY)); prc = Convert.ToDouble(grv.GetFocusedRowCellValue(colSVL)); grv.SetFocusedRowCellValue(colAMT, qty * prc); grv.UpdateCurrentRow(); break; case "Rate": qty = Convert.ToInt32(grv.GetFocusedRowCellValue(colQTY)); prc = Convert.ToDouble(grv.GetFocusedRowCellValue(colSVL)); grv.SetFocusedRowCellValue(colAMT, qty * prc); grv.UpdateCurrentRow(); break; } }
private void luePNM1_EditValueChanged(object sender, EventArgs e) { if (luePNM1.EditValue != null) { int pid = Convert.ToInt32(luePNM1.EditValue); wrProducts.Server2Client s2c = new wrProducts.Server2Client(); wrProducts.wsProducts prd = new wrProducts.wsProducts(); wrProducts.Product p = new wrProducts.Product(); p = prd.GetProductByID(pid); txtBVL1.EditValue = p.BuyingValue; txtSVL1.EditValue = p.SellingValue; txtQTY1.EditValue = 1; } }
private void txtBCD_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { wrProducts.Server2Client spc = new wrProducts.Server2Client(); wrProducts.wsProducts prd = new wrProducts.wsProducts(); wrProducts.Product p = new wrProducts.Product(); p = prd.GetProductByBarCode(txtBCD.Text); if (p.Quantity < 1) { lblInfo.Text = "Product not available!"; txtBCD.Text = ""; txtBCD.Focus(); return; } if (p.Message == null) { DataRow r = dt.NewRow(); r["ProductID"] = p.ProductID; r["ProductName"] = p.ProductName; r["BarCode"] = p.BarCode; r["BuyingValue"] = p.BuyingValue; r["SellingValue"] = p.SellingValue; r["Quantity"] = 1; r["Amount"] = 1 * p.SellingValue; dt.Rows.Add(r); grd.DataSource = dt; grd.Refresh(); double TotalAmount = Convert.ToDouble(colAMT.SummaryText); txtAMT.Text = TotalAmount.ToString(); txtPAM.Text = TotalAmount.ToString(); txtBCD.Text = ""; txtBCD.Focus(); } else { lblInfo.Text = p.Message; } } }
private void luePNM_EditValueChanged(object sender, EventArgs e) { if (luePNM.EditValue == null) { Clear(); } else { int PID = Convert.ToInt32(luePNM.EditValue); wrProducts.Server2Client spc = new wrProducts.Server2Client(); wrProducts.wsProducts prd = new wrProducts.wsProducts(); wrProducts.Product p = new wrProducts.Product(); p = prd.GetProductByID(PID); BuyingValue = p.BuyingValue; txtSVL.EditValue = p.SellingValue; txtQTY.Properties.MaxValue = p.Quantity; BarCode = p.BarCode; } }
private void btnSave_Click(object sender, EventArgs e) { if (grv.RowCount <= 0) { XtraMessageBox.Show("Please add some product first!"); return; } sc = new wrProducts.Server2Client(); prd = new wrProducts.wsProducts(); for (int i = 0; i <= grv.RowCount - 1; i++) { wrProducts.Product p = new wrProducts.Product(); p.CategoryID = Convert.ToInt32(grv.GetRowCellValue(i, colCAT)); p.ProductName = grv.GetRowCellValue(i, colPNM).ToString(); p.BuyingValue = Convert.ToDouble(grv.GetRowCellValue(i, colBVL)); p.SellingValue = Convert.ToDouble(grv.GetRowCellValue(i, colSVL)); p.Quantity = Convert.ToInt32(grv.GetRowCellValue(i, colQTY)); p.BarCode = grv.GetRowCellValue(i, colBCD).ToString(); sc = prd.AddProduct(p); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); return; } } XtraMessageBox.Show("Product(s) added successfully!"); grd.DataSource = null; grd.Refresh(); lueCAT.EditValue = null; txtPNM.EditValue = null; txtBVL.EditValue = 0; txtSVL.EditValue = 0; txtQTY.EditValue = 1; txtBCD.EditValue = null; lueCAT.Focus(); }
private void luePRD_EditValueChanged(object sender, EventArgs e) { if (luePRD.EditValue != null) { int pid = Convert.ToInt32(luePRD.EditValue); wrProducts.Product p = new wrProducts.Product(); prd = new wrProducts.wsProducts(); p = prd.GetProductByID(pid); lueCAT2.EditValue = lueCAT.EditValue; txtPNM.Text = p.ProductName; txtBVL.EditValue = p.BuyingValue; txtSVL.EditValue = p.SellingValue; txtQTY.EditValue = p.Quantity; txtBCD.EditValue = p.BarCode; } }
private void btnOK_Click(object sender, EventArgs e) { sc = new wrPurchases.Server2Client(); pur = new wrPurchases.wsPurchases(); wrPurchases.Purchase prc = new wrPurchases.Purchase(); //Products prd = new Products(); prc.InvoiceNo = txtINV.Text; prc.PurchaseDate = dtpPDT.DateTime; prc.SupplierID = Convert.ToInt32(lueSUP.EditValue); prc.Amount = Convert.ToDouble(txtAMT.EditValue); prc.Payment = Convert.ToDouble(txtPAM.EditValue); prc.Balance = Convert.ToDouble(txtBAL.EditValue); sc = pur.addPurchase(prc); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); return; } sup = new wrSuppliers.wsSuppliers(); wrSuppliers.Server2Client s2c = new wrSuppliers.Server2Client(); wrSuppliers.SupplierAccount s = new wrSuppliers.SupplierAccount(); s.SupplierID = Convert.ToInt32(lueSUP.EditValue); s.TransDate = dtpPDT.DateTime; s.Description = txtINV.Text; s.Debit = Convert.ToDouble(txtAMT.EditValue); s.Credit = Convert.ToDouble(txtPAM.EditValue); s.Balance = SupplierBalance + Convert.ToDouble(txtBAL.Text); s2c = sup.addTrans(s); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); return; } Guid g; for (int i = 0; i <= grv.RowCount - 1; i++) { int cid = Convert.ToInt32(grv.GetRowCellValue(i, colCID)); string pnm = grv.GetRowCellValue(i, colPNM).ToString(); double bvl = Convert.ToDouble(grv.GetRowCellValue(i, colBVL)); double svl = Convert.ToDouble(grv.GetRowCellValue(i, colSVL)); int qty = Convert.ToInt32(grv.GetRowCellValue(i, colQTY)); double amt = Convert.ToDouble(grv.GetRowCellValue(i, colAMT)); string bcd = grv.GetRowCellValue(i, colBCD).ToString(); wrPurchases.PurchaseDetail pdt = new wrPurchases.PurchaseDetail(); pdt.InvoiceNo = txtINV.Text; g = Guid.NewGuid(); pdt.ProductCode = g.ToString(); pdt.BuyingValue = bvl; pdt.SellingValue = svl; pdt.Quantity = qty; pdt.Amount = amt; sc = pur.addPurchaseDetails(pdt); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); return; } wrProducts.wsProducts prd = new wrProducts.wsProducts(); wrProducts.Product p = new wrProducts.Product(); wrProducts.Server2Client spc = new wrProducts.Server2Client(); p.CategoryID = cid; p.SupplierID = Convert.ToInt32(lueSUP.EditValue); p.ProductCode = g.ToString(); p.ProductName = pnm; p.BuyingValue = bvl; p.SellingValue = svl; p.SupplierID = Convert.ToInt32(lueSUP.EditValue); p.Quantity = qty; p.BarCode = bcd; spc = prd.AddProduct(p); if (sc.Message != null) { XtraMessageBox.Show(sc.Message); return; } } XtraMessageBox.Show("Product(s) purchased successfully!"); InitInvoice(); dtpPDT.DateTime = DateTime.Now.Date; dt = new DataTable(); InitDataTable(); InitSuppliers(); InitCategories(); grd.DataSource = null; }