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