private static DataTable GetDataAsync(DataFetchArguments arguments) { try { DataTable returns = new DataTable(); using (SqlCommand cmd = new SqlCommand(arguments.Command, arguments.Connection)) { if (arguments.SqlCommandArgumentNames != null && arguments.SqlCommandArguments != null) { int index = 0; foreach (string arg in arguments.SqlCommandArgumentNames) { cmd.Parameters.Add(new SqlParameter(arg, arguments.SqlCommandArguments[index])); index++; } } cmd.CommandType = arguments.Type; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(returns); } return(returns); } catch (Exception er) { waitPage.Invoke(new Action(() => { waitPage.Close(); })); MessageBox.Show("There was an error processing this request; the string may be in an incorrect format."); return(null); } }
public static void CreateDataServiceMethod(DataFetchArguments Fetch, RunWorkerCompletedEventHandler OnComplete) { try { //error checks if (Fetch.SqlCommandArguments != null) { foreach (object obj in Fetch.SqlCommandArguments) { if ((string)obj == "") { MessageBox.Show("Blank message sent"); return; } } } if (Fetch.SqlCommandArgumentNames != null) { foreach (string obj in Fetch.SqlCommandArgumentNames) { if ((string)obj == "") { MessageBox.Show("Blank message name sent"); return; } } } BackgroundWorker AsyncWorker = new BackgroundWorker(); AsyncWorker.WorkerSupportsCancellation = true; waitPage = new Waiting(); waitPage.Show(); AsyncWorker.DoWork += Services.DataServices.Worker_DoWork; AsyncWorker.RunWorkerCompleted += OnComplete; AsyncWorker.RunWorkerCompleted += UIWorker_RunWorkerCompleted; AsyncWorker.RunWorkerAsync(Fetch); } catch(Exception er) { MessageBox.Show("There was an error processing this request; the string may be in the incorrect format."); return; } }
public static void CreateDataServiceMethod(DataFetchArguments Fetch, RunWorkerCompletedEventHandler OnComplete) { try { //error checks if (Fetch.SqlCommandArguments != null) { foreach (object obj in Fetch.SqlCommandArguments) { if ((string)obj == "") { MessageBox.Show("Blank message sent"); return; } } } if (Fetch.SqlCommandArgumentNames != null) { foreach (string obj in Fetch.SqlCommandArgumentNames) { if ((string)obj == "") { MessageBox.Show("Blank message name sent"); return; } } } BackgroundWorker AsyncWorker = new BackgroundWorker(); AsyncWorker.WorkerSupportsCancellation = true; waitPage = new Waiting(); waitPage.Show(); AsyncWorker.DoWork += Services.DataServices.Worker_DoWork; AsyncWorker.RunWorkerCompleted += OnComplete; AsyncWorker.RunWorkerCompleted += UIWorker_RunWorkerCompleted; AsyncWorker.RunWorkerAsync(Fetch); } catch (Exception er) { MessageBox.Show("There was an error processing this request; the string may be in the incorrect format."); return; } }
private static DataTable GetDataAsync(DataFetchArguments arguments) { try { DataTable returns = new DataTable(); using (SqlCommand cmd = new SqlCommand(arguments.Command, arguments.Connection)) { if (arguments.SqlCommandArgumentNames != null && arguments.SqlCommandArguments != null) { int index = 0; foreach (string arg in arguments.SqlCommandArgumentNames) { cmd.Parameters.Add(new SqlParameter(arg, arguments.SqlCommandArguments[index])); index++; } } cmd.CommandType = arguments.Type; SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(returns); } return returns; } catch (Exception er) { waitPage.Invoke(new Action(() => { waitPage.Close(); })); MessageBox.Show("There was an error processing this request; the string may be in an incorrect format."); return null; } }