private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)//save
{
// Commen_Form.Functions.DateConverter dc = new Commen_Form.Functions.DateConverter();
gridView1.RefreshData();
DataTable source = gridControl1.DataSource as DataTable;
//source = dc.gridvalidation(source);
DataTable dt = new DataTable();
dt.Clear();
dt.Columns.Add("deliveryno");
dt.Columns.Add("date");
dt.Columns.Add("salesPerson");
dt.Columns.Add("customerId");
dt.Columns.Add("customerName");
dt.Columns.Add("address");
dt.Columns.Add("contact");
dt.Columns.Add("status");
dt.Rows.Add(new object[] { txtdeliveryNo.Text, dtpdate.Text, txtsalesPerson.Text, CustomerId, txtCustomerName.Text, txtaddress.Text, txtemail.Text, "No Invoice" });
Test.Sale.Database.SalesDeliveryData quatationData = new Sale.Database.SalesDeliveryData(source, dt);
quatationData.FnConn();
quatationData.fnTransactionData();
string res = quatationData.FnTrans();
MessageBox.Show(res, "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);
barButtonItem1.Enabled = false;
barButtonItem5.Enabled = true;
}
void loadData()
{
Sale.Database.SalesDeliveryData salesDeliveryData = new Sale.Database.SalesDeliveryData();
salesDeliveryData.FnConn();
DataTable dt = salesDeliveryData.FillData("S", "", "spsalesDelivery");
if (dt.Rows.Count > 0)
{
gridControl1.DataSource = dt;
}
salesDeliveryData.FnTrans();
}
public Delivery_Note()
{
InitializeComponent();
salesDeliveryData = new Sale.Database.SalesDeliveryData();
}