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;
}
