public CustomerDetails(string Id) { InitializeComponent(); ClientFile = Path.GetDirectoryName(Variables.CompanyFile) + "\\SurveyToolbox\\Customers.track"; XDocument doc = XDocument.Load(ClientFile); var Customers = doc.Root.Elements("Customer"); var Customer = Customers.FirstOrDefault(RId => RId.Attribute("Id").Value == Id); if (Customer == null) { MessageBox.Show("The indicated customer could not be found. Please contact the admin."); this.Close(); return; } ClientId = Id; PopulateClientInfo(Customer); ResizeForm(this, new EventArgs()); }
private void AcceptRequest_Click(object sender, RoutedEventArgs e) { if (!string.IsNullOrWhiteSpace(RId.Text) && !string.IsNullOrWhiteSpace(RName.Text) && !string.IsNullOrWhiteSpace(RQuantity.Text)) { try { connection.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "update requests set REQUEST_ID=@requestid,REQUEST_NAME=@requestname,REQUEST_QUANTATY=@requestquantity,REQUEST_STATUS=@requeststs where REQUEST_ID=@requestid"; cmd.Parameters.AddWithValue("@requestid", RId.Text); cmd.Parameters.AddWithValue("@requestname", RName.Text); cmd.Parameters.AddWithValue("@requestquantity", int.Parse(RQuantity.Text)); cmd.Parameters.AddWithValue("@requeststs", "checked"); cmd.Connection = connection; cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { string sts = "'notchecked'"; MySqlCommand Com = new MySqlCommand($"Select * from requests where REQUEST_STATUS={sts} ", connection); MySqlDataAdapter adp = new MySqlDataAdapter(Com); DataSet ds = new DataSet(); adp.Fill(ds, "LoadRequests"); RequestsDataGrid.DataContext = ds; connection.Close(); RId.Clear(); RName.Clear(); RQuantity.Clear(); MessageBox.Show("Request Reviewed", "Success"); } } else { MessageBox.Show("please select a request !", "ERROR"); } }