private void approveButton_Click(object sender, RoutedEventArgs e)
{
if (purchaseID != "")
{
string query = "UPDATE sparepart_purchase SET om_approved='1',date_purchased='" + DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss") + "' WHERE id='" + purchaseID + "'";
if (DBManager.UpdateDatabaseQuery(query))
{
valuesC.Rows.Add(values.Rows[myGridSelectedIndex].ItemArray);
myMessageBox mm = new myMessageBox("Approved Successfully", "Success", "OK", 0);
mm.ShowDialog();
// MessageBox.Show("Approved Succefully", "Success", MessageBoxButton.OK, MessageBoxImage.Information);
values = DBManager.selectForPurchaseApproval();
approve_sparepart_purchase.ItemsSource = values.AsDataView();
purchaseID = "";
}
else
{
myMessageBox mm = new myMessageBox("Error Occured", "Error", "OK", 1);
mm.ShowDialog();
// MessageBox.Show("Error Occured", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
public ApproveSparepartPurchase()
{
InitializeComponent();
try
{
values = DBManager.selectForPurchaseApproval();
approve_sparepart_purchase.ItemsSource = values.AsDataView();
valuesC = values.Clone();
approved_Items.ItemsSource = valuesC.AsDataView();
}
catch
{
}
}
