private void cmbcustomer_SelectedIndexChanged(object sender, EventArgs e) { try { if (cmbcustomer.Text != "") { Test.Sale.Database.SalesData quatation = new Sale.Database.SalesData(); quatation.FnConn(); DataTable dt = quatation.FillData("search", cmbcustomer.Text, "spCustomer"); if (dt.Rows.Count > 0) { txtaddress.Text = dt.Rows[0]["address"].ToString(); txtphone.Text = dt.Rows[0]["phone"].ToString(); CustomerId = dt.Rows[0]["customerID"].ToString(); } else { CustomerId = ""; txtaddress.Text = ""; txtphone.Text = ""; } quatation.FnTrans(); } } catch (Exception ex) { } }
void loadData() { Sale.Database.SalesData salesData = new Sale.Database.SalesData(); salesData.FnConn(); DataTable dt = salesData.FillData("invlist", "", "spsalesReturn"); if (dt.Rows.Count > 0) { gridControl1.DataSource = dt; } salesData.FnTrans(); }
private void Item_Filter_Load(object sender, EventArgs e) { Sale.Database.SalesData salesdata = new Sale.Database.SalesData(); salesdata.FnConn(); DataTable dt = salesdata.FillData("stockqr", qrcode, "spsales"); salesdata.FnTrans(); if (dt.Rows.Count > 0) { gridControl1.DataSource = dt; } }
private void Sales_Quotation_Load(object sender, EventArgs e) { txtnetamount.Text = "0"; Test.Sale.Database.QuatationData quatation = new Sale.Database.QuatationData(); quatation.FnConn(); DataTable dt1 = quatation.FillData("M", ""); String res = quatation.FnTrans(); if (dt1.Rows.Count > 0) { int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1; string quonum = number + ""; txtquatationnno.Text = "QU/" + quonum.PadLeft(5, '0'); } DataTable dt = new DataTable(); dt.Columns.Add("slno", Type.GetType("System.Int32")); dt.Columns.Add("quotationNo", Type.GetType("System.String")); dt.Columns.Add("barcode", Type.GetType("System.String")); dt.Columns.Add("itemcode", Type.GetType("System.String")); dt.Columns.Add("description", Type.GetType("System.String")); dt.Columns.Add("brandName", Type.GetType("System.String")); dt.Columns.Add("quantity", Type.GetType("System.Double")); dt.Columns.Add("unitPrice", Type.GetType("System.Double")); dt.Columns.Add("totalAmount", Type.GetType("System.Double")); DataRow dr = dt.NewRow(); dt.Rows.Add(dr); gridControl1.DataSource = dt; dtpdate.EditValue = DateTime.Now; Test.Sale.Database.SalesData sales = new Sale.Database.SalesData(); sales.FnConn(); DataTable dt2 = sales.FillData("S", "", "spCustomer"); if (dt2.Rows.Count > 0) { for (int i = 0; i < dt2.Rows.Count; i++) { try { cmbcustomer.Properties.Items.Add(dt2.Rows[i]["name"].ToString()); } catch (Exception ex) { } } } sales.FnTrans(); }
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { cmbpaymentmode.SelectedIndex = 0; DataTable source = gridControl1.DataSource as DataTable; source.Clear(); gridControl1.DataSource = source; cmbcustomer.Text = ""; txtaddress.Text = ""; CustomerId = ""; txtphone.Text = ""; txtsalesperson.Text = ""; txtgrosstotal.Text = "0"; txtdiscount.Text = "0"; txtnettotal.Text = "0"; txtpayamount.Text = "0"; txtbalance.Text = "0"; Test.Sale.Database.SalesData sales = new Sale.Database.SalesData(); sales.FnConn(); DataTable dt1 = sales.FillData("M", "", "spsales"); if (dt1.Rows.Count > 0) { int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1; string invoiceno = number + ""; txtinvoice.Text = "INV/" + invoiceno.PadLeft(5, '0'); } sales.FnTrans(); //cmbpaymentmode.Text = ""; txtbalancedue.Text = "0"; dtppaymentdue.Text = ""; barButtonItem1.Enabled = true; deliveryno = ""; } catch (Exception) { } }
private void Sales_Invoice_Load(object sender, EventArgs e) { typecash.IsOn = true; cmbpaymentmode.SelectedIndex = 0; Test.Sale.Database.SalesData sales = new Sale.Database.SalesData(); sales.FnConn(); DataTable dt1 = sales.FillData("M", "", "spsales"); if (dt1.Rows.Count > 0) { int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1; string invoiceno = number + ""; txtinvoice.Text = "INV/" + invoiceno.PadLeft(5, '0'); } DataTable dt2 = sales.FillData("S", "", "spCustomer"); if (dt2.Rows.Count > 0) { for (int i = 0; i < dt2.Rows.Count; i++) { try { cmbcustomer.Properties.Items.Add(dt2.Rows[i]["name"].ToString()); } catch (Exception ex) { } } } dtpdate.EditValue = DateTime.Now; String res = sales.FnTrans(); DataTable dt = new DataTable(); dt.Columns.Add("slno", Type.GetType("System.Int32")); dt.Columns.Add("invoice_no", Type.GetType("System.String")); dt.Columns.Add("barcode", Type.GetType("System.String")); dt.Columns.Add("itemcode", Type.GetType("System.String")); dt.Columns.Add("description", Type.GetType("System.String")); dt.Columns.Add("brandName", Type.GetType("System.String")); dt.Columns.Add("quantity", Type.GetType("System.Double")); dt.Columns.Add("offer", Type.GetType("System.Double")); dt.Columns.Add("unitPrice", Type.GetType("System.Double")); dt.Columns.Add("amount", Type.GetType("System.Double")); dt.Columns.Add("discountPercent", Type.GetType("System.Double")); dt.Columns.Add("discountAmount", Type.GetType("System.Double")); dt.Columns.Add("taxPercent", Type.GetType("System.Double")); dt.Columns.Add("taxAmount", Type.GetType("System.Double")); dt.Columns.Add("totalAmount", Type.GetType("System.Double")); DataRow dr = dt.NewRow(); dt.Rows.Add(dr); gridControl1.DataSource = dt; if (deliveryno != null) { sales.FnConn(); DataSet ds = sales.FillDataSet("searchgrid", deliveryno, "spsalesDelivery"); sales.FnTrans(); DataTable delivery = ds.Tables[0]; DataTable deliverygrid = ds.Tables[1]; if (delivery.Rows.Count > 0) { CustomerId = delivery.Rows[0]["customerid"] + ""; cmbcustomer.Text = delivery.Rows[0]["customerName"] + ""; txtaddress.Text = delivery.Rows[0]["address"] + ""; // txtphone.Text = delivery.Rows[0]["contact"] + ""; txtsalesperson.Text = delivery.Rows[0]["salesPerson"] + ""; dt.Clear(); sales.FnConn(); for (int i = 0; i < deliverygrid.Rows.Count; i++) { string barcode = deliverygrid.Rows[i]["barcode"] + ""; double qty = Convert.ToDouble(deliverygrid.Rows[i]["quantity"] + ""); if (barcode != null) { DataTable dts = sales.FillData("barcodedatails", barcode, "spQuatation"); if (dts.Rows.Count > 0) { string itemCode = dts.Rows[0]["productCode"] + ""; string description = dts.Rows[0]["itemName"] + ""; string brandName = dts.Rows[0]["brandName"] + ""; double unitprice = Convert.ToDouble(dts.Rows[0]["salesRate1"] + ""); double totalprice = unitprice * qty; dt.Rows.Add(i + 1, "", barcode, itemCode, description, brandName, qty, "1", unitprice, totalprice, 0, 0, 0, 0, totalprice); } } } sales.FnTrans(); calculateTotal(); } } }
private void gridView1_ShownEditor(object sender, EventArgs e) { Test.Sale.Database.SalesData sales = new Sale.Database.SalesData(); if (gridView1.FocusedColumn.FieldName.Equals("barcode"))//Don't work only for this column { TextEdit currentEditor = (sender as GridView).ActiveEditor as TextEdit; if (currentEditor != null) { AutoCompleteStringCollection customSource = new AutoCompleteStringCollection(); sales.FnConn(); DataTable dt = sales.FillData("barcode", "", "spQuatation"); string res = sales.FnTrans(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { customSource.Add(dt.Rows[i][0].ToString()); } } // customSource.Add("Programa 1"); // customSource.Add("Paaaaaaa 3"); //customSource.Add("Pabbbbbb 2"); currentEditor.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; currentEditor.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource; currentEditor.MaskBox.AutoCompleteCustomSource = customSource; } } else if (gridView1.FocusedColumn.FieldName.Equals("itemcode"))//Don't work only for this column { TextEdit currentEditor = (sender as GridView).ActiveEditor as TextEdit; if (currentEditor != null) { AutoCompleteStringCollection customSource = new AutoCompleteStringCollection(); sales.FnConn(); DataTable dt = sales.FillData("itemcode", "", "spQuatation"); string res = sales.FnTrans(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { customSource.Add(dt.Rows[i][0].ToString()); } } currentEditor.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; currentEditor.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource; currentEditor.MaskBox.AutoCompleteCustomSource = customSource; } } else if (gridView1.FocusedColumn.FieldName.Equals("description"))//Don't work only for this column { TextEdit currentEditor = (sender as GridView).ActiveEditor as TextEdit; if (currentEditor != null) { AutoCompleteStringCollection customSource = new AutoCompleteStringCollection(); sales.FnConn(); DataTable dt = sales.FillData("name", "", "spQuatation"); string res = sales.FnTrans(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { customSource.Add(dt.Rows[i][0].ToString()); } } currentEditor.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; currentEditor.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource; currentEditor.MaskBox.AutoCompleteCustomSource = customSource; } } else if (gridView1.FocusedColumn.FieldName.Equals("quantity"))//Don't work only for this column { TextEdit currentEditor = (sender as GridView).ActiveEditor as TextEdit; if (currentEditor != null) { AutoCompleteStringCollection customSource = new AutoCompleteStringCollection(); sales.FnConn(); customSource = null; currentEditor.MaskBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend; currentEditor.MaskBox.AutoCompleteSource = AutoCompleteSource.CustomSource; currentEditor.MaskBox.AutoCompleteCustomSource = customSource; } } }