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