private void simpleButton1_Click(object sender, EventArgs e)
{
int CID = Convert.ToInt32(lueSUP.EditValue);
wrPurchases.Server2Client sc = new wrPurchases.Server2Client();
wrPurchases.wsPurchases pp = new wrPurchases.wsPurchases();
rptSupplierPurchase rpt = new rptSupplierPurchase();
if (checkEdit1.Checked)
{
sc = pp.PurchaseFromSupplierByID(CID);
rpt.DataSource = sc.dataTable;
rpt.lbTTL.Text = "Product(s) purchased from Supplier";
}
else
{
sc = pp.PurchaseFromSupplierByDates(CID, dtFrm.DateTime, dtTos.DateTime);
rpt.DataSource = sc.dataTable;
rpt.lbTTL.Text = "Product(s) purchased from Supplier between " + dtFrm.DateTime.ToShortDateString() + " and " + dtTos.DateTime.ToShortDateString();
}
GroupField grp = new GroupField("PurchaseDate");
rpt.GroupHeader1.GroupFields.Add(grp);
wrSuppliers.wsSuppliers sup = new wrSuppliers.wsSuppliers();
wrSuppliers.Supplier s = new wrSuppliers.Supplier();
s = sup.getSupplier(CID);
rpt.lbSNM.Text = s.SupplierName;
rpt.lbADR.Text = s.Address;
rpt.lbPHN.Text = s.Phone;
rpt.lbSDT.DataBindings.Add("Text", null, "PurchaseDate", "{0:dd-MM-yyyy}");
rpt.lbPNM.DataBindings.Add("Text", null, "ProductName");
rpt.lbSNO.DataBindings.Add("Text", null, "BarCode");
rpt.lbSVL.DataBindings.Add("Text", null, "BuyingValue", "{0:C2}");
rpt.lbQTY.DataBindings.Add("Text", null, "TotalQuantity");
rpt.lbAMT.DataBindings.Add("Text", null, "Amount", "{0:C2}");
dv.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
popSupplier.HidePopup();
}
private void bPurchasedProducts_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
frmSelect frm = new frmSelect();
if (frm.ShowDialog() == DialogResult.OK)
{
wrPurchases.Server2Client sc;
wrPurchases.wsPurchases p = new wrPurchases.wsPurchases();
rptPurchasedProducts rpt = new rptPurchasedProducts();
if (frm.RetVal == 0)
{
sc = new wrPurchases.Server2Client();
p = new wrPurchases.wsPurchases();
sc = p.getPurchasedProductsByDate(frm.DateOn);
rpt.DataSource = sc.dataTable;
rpt.lbTTL.Text = "Products purchased On " + frm.DateOn.ToShortDateString();
}
else if (frm.RetVal == 1)
{
sc = new wrPurchases.Server2Client();
p = new wrPurchases.wsPurchases();
sc = p.getPurchasedProductsByDates(frm.DateFrom, frm.DateTo);
rpt.DataSource = sc.dataTable;
rpt.lbTTL.Text = "Products purchased Between " + frm.DateFrom.ToShortDateString() + " and " + frm.DateTo.ToShortDateString();
}
else
{
sc = new wrPurchases.Server2Client();
p = new wrPurchases.wsPurchases();
sc = p.getPurchasedProductsByInvoice(frm.InvoiceNo);
rpt.DataSource = sc.dataTable;
rpt.lbTTL.Text = "Purchase detail of Invoice No " + frm.InvoiceNo;
}
XRSummary stt = new XRSummary();
XRSummary gtt = new XRSummary();
GroupField grp = new GroupField("PurchaseDate");
rpt.GroupHeader1.GroupFields.Add(grp);
rpt.lbPDT.DataBindings.Add("Text", null, "PurchaseDate", "{0:dd-MM-yyyy}");
rpt.lbPNM.DataBindings.Add("Text", null, "ProductName");
rpt.lbBCD.DataBindings.Add("Text", null, "BarCode");
rpt.lbSVL.DataBindings.Add("Text", null, "BuyingValue", "{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);
}
}
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;
}
