private void gridView1_ShownEditor(object sender, EventArgs e) { Test.Purchase.database.PurchaseRequest po = new Purchase.database.PurchaseRequest(); if (gridView1.FocusedColumn.FieldName.Equals("itemNo"))//Don't work only for this column { TextEdit currentEditor = (sender as GridView).ActiveEditor as TextEdit; if (currentEditor != null) { AutoCompleteStringCollection customSource = new AutoCompleteStringCollection(); po.FnConn(); DataTable dt = po.FillData("itemcode", ""); string res = po.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(); po.FnConn(); DataTable dt = po.FillData("itemname", ""); string res = po.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; } } }
private void btnNew_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { DataTable source = gridControl1.DataSource as DataTable; source.Clear(); gridControl1.DataSource = source; txtLocation.Text = ""; txtRequester.Text = ""; datePOdate.EditValue = DateTime.Now; Test.Purchase.database.PurchaseRequest pr = new Purchase.database.PurchaseRequest(); pr.FnConn(); DataTable dt1 = pr.FillData("M", ""); if (dt1.Rows.Count > 0) { number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1; string invoiceno = number + ""; txtPRNo.Text = "PR-NO:" + invoiceno.PadLeft(5, '0'); } btnSave.Enabled = true; } catch (Exception) { } }
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { btnSave.Enabled = false; gridControl1.RefreshDataSource(); DataTable source = gridControl1.DataSource as DataTable; var emptyrows = source.AsEnumerable() .All(r => r.ItemArray.All(x => x == DBNull.Value)); if (!emptyrows && txtLocation.Text.Length != 0 && txtPRNo.Text.Length != 0 && txtRequester.Text.Length != 0) { DataTable dt = new DataTable(); dt.Clear(); dt.Columns.Add("prNo"); dt.Columns.Add("requester"); dt.Columns.Add("location"); dt.Columns.Add("date"); dt.Rows.Add(new object[] { txtPRNo.Text, txtRequester.Text, txtLocation.Text, datePOdate.Text }); Test.Purchase.database.PurchaseRequest purchase = new Purchase.database.PurchaseRequest(source, dt); purchase.FnConn(); if (btnSave.Caption == "Save") { purchase.fnTransactionData("I", txtPRNo.Text); purchase.updatStatus("updateStatus", txtPRNo.Text, "PR Created"); } else { purchase.fnTransactionData("U", txtPRNo.Text); } purchase.FnTrans(); MessageBox.Show("PR CREATED.", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void gridView1_HiddenEditor(object sender, EventArgs e) { try { int slno = gridView1.GetFocusedDataSourceRowIndex(); Test.Purchase.database.PurchaseRequest pr = new Purchase.database.PurchaseRequest(); System.Data.DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle); row["slno"] = (slno + 1) + ""; if (gridView1.FocusedColumn.FieldName.Equals("itemNo")) { String itemcode = row["itemNo"].ToString(); if (itemcode != "") { pr.FnConn(); DataTable dt = pr.FillData("itemdetails", itemcode); if (dt.Rows.Count > 0) { row["description"] = dt.Rows[0]["itemName"].ToString(); row["brand"] = dt.Rows[0]["brandName"].ToString(); row["quantity"] = "1"; } } } else if (gridView1.FocusedColumn.FieldName.Equals("description")) { String description = row["description"].ToString(); if (description != "") { pr.FnConn(); DataTable dt = pr.FillData("desdetails", description); if (dt.Rows.Count > 0) { row["itemNo"] = dt.Rows[0]["productCode"].ToString(); row["brand"] = dt.Rows[0]["brandName"].ToString(); row["quantity"] = "1"; } } } } catch (Exception) { } }
private void Purchase_Requst_List_Load(object sender, EventArgs e) { Purchase.database.PurchaseRequest purchaseRequest = new Purchase.database.PurchaseRequest(); purchaseRequest.FnConn(); DataTable dt = purchaseRequest.FillData("rqdetails", ""); if (dt.Rows.Count > 0) { gridControl1.DataSource = dt; } }
public void loadData() { Purchase.database.PurchaseRequest purchaseRequest = new Purchase.database.PurchaseRequest(); purchaseRequest.FnConn(); DataTable dt = purchaseRequest.FillData("rqdetails", ""); if (dt.Rows.Count > 0) { gridControl1.DataSource = dt; } purchaseRequest.FnTrans(); }
private void New_RFQ_Load(object sender, EventArgs e) { Test.Purchase.database.Rfq pr = new Purchase.database.Rfq(); pr.FnConn(); DataTable dt1 = pr.FillData("M", ""); DataTable dt = new DataTable(); if (dt1.Rows.Count > 0) { int number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1; string invoiceno = number + ""; txtRFQNO.Text = "RFQ-NO:" + invoiceno.PadLeft(5, '0'); } dt.Columns.Add("slno", Type.GetType("System.Int32")); dt.Columns.Add("description", Type.GetType("System.String")); dt.Columns.Add("brand", Type.GetType("System.String")); dt.Columns.Add("quantity", Type.GetType("System.Int32")); DataRow dr = dt.NewRow(); dt.Rows.Add(dr); gridControl1.DataSource = dt; cmbVendor1.Properties.Items.Clear(); cmbVendor2.Properties.Items.Clear(); cmbVendor3.Properties.Items.Clear(); DataTable dtc1 = pr.FillData("SC", ""); foreach (DataRow dr1 in dtc1.Rows) { cmbVendor1.Properties.Items.Add(dr1["name"] + ""); cmbVendor2.Properties.Items.Add(dr1["name"] + ""); cmbVendor3.Properties.Items.Add(dr1["name"] + ""); } String res = pr.FnTrans(); Test.Purchase.database.PurchaseRequest pr1 = new Purchase.database.PurchaseRequest(); pr1.FnConn(); DataTable dtd = pr1.FillData("updatedata", no); DataTable dtg = pr1.FillData("updategrd", no); gridControl1.DataSource = dtg; txtPO.Text = dtd.Rows[0]["prNo"].ToString(); Test.Commen_Form.Functions.DateConverter c = new Commen_Form.Functions.DateConverter(); dateRFQdate.EditValue = c.dateconverter(dtd.Rows[0]["date"] + ""); txtLocation.Text = dtd.Rows[0]["location"] + ""; }
private void Purchase_Requst_Load(object sender, EventArgs e) { Test.Purchase.database.PurchaseRequest pr = new Purchase.database.PurchaseRequest(); pr.FnConn(); if (flag == true) { btnSave.Caption = "Update"; DataTable dt = pr.FillData("updatedata", no); DataTable dt1 = pr.FillData("updategrd", no); gridControl1.DataSource = dt1; txtLocation.Text = dt.Rows[0]["location"] + ""; txtPRNo.Text = dt.Rows[0]["prNo"] + ""; txtRequester.Text = dt.Rows[0]["requester"] + ""; Test.Commen_Form.Functions.DateConverter c = new Commen_Form.Functions.DateConverter(); datePOdate.EditValue = c.dateconverter(dt.Rows[0]["date"] + ""); } else { btnSave.Caption = "Save"; DataTable dt1 = pr.FillData("M", ""); String res = pr.FnTrans(); DataTable dt = new DataTable(); if (dt1.Rows.Count > 0) { number = Convert.ToInt32(dt1.Rows[0]["number"].ToString()) + 1; string invoiceno = number + ""; txtPRNo.Text = "PR/" + invoiceno.PadLeft(5, '0'); } dt.Columns.Add("slno", Type.GetType("System.Int32")); dt.Columns.Add("itemNo", Type.GetType("System.String")); dt.Columns.Add("description", Type.GetType("System.String")); dt.Columns.Add("brand", Type.GetType("System.String")); dt.Columns.Add("quantity", Type.GetType("System.Int32")); DataRow dr = dt.NewRow(); dt.Rows.Add(dr); gridControl1.DataSource = dt; datePOdate.EditValue = DateTime.Now; } }
private void btnSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { btnSave.Enabled = false; gridControl1.RefreshDataSource(); DataTable source = gridControl1.DataSource as DataTable; DataTable dt = new DataTable(); dt.Clear(); dt.Columns.Add("RFQNo"); dt.Columns.Add("ourchaseOrderNo"); dt.Columns.Add("date"); dt.Columns.Add("requester"); dt.Columns.Add("vendor1"); dt.Columns.Add("address1"); dt.Columns.Add("ph1"); dt.Columns.Add("vendor2"); dt.Columns.Add("address2"); dt.Columns.Add("ph2"); dt.Columns.Add("vendor3"); dt.Columns.Add("address3"); dt.Columns.Add("ph3"); dt.Columns.Add("vendoeId1"); dt.Columns.Add("vendoeId2"); dt.Columns.Add("vendoeId3"); dt.Columns.Add("location"); dt.Columns.Add("ststus"); dt.Rows.Add(new object[] { txtRFQNO.Text, txtPO.Text, dateRFQdate.Text, txtRequster.Text, cmbVendor1.Text, txtAddress1.Text, txtPh1.Text, cmbVendor2.Text, txtAddress2.Text, txtPh2.Text, cmbVendor3.Text, txtAddress3.Text, txtPh3.Text, vendorId1, vendorId2, vendorId3, txtLocation.Text, "RFQ Created" }); Test.Purchase.database.Rfq rfq = new Purchase.database.Rfq(source, dt); rfq.FnConn(); rfq.fnTransactionData(); rfq.FnTrans(); MessageBox.Show("Request for Quotation Created.", "ALERT", MessageBoxButtons.OK, MessageBoxIcon.Information); Test.Purchase.database.PurchaseRequest purchase = new Purchase.database.PurchaseRequest(source, dt); purchase.FnConn(); purchase.updatStatus("updateStatus", txtPO.Text, "RFQ ISSUED"); purchase.FnTrans(); }