private static int DoRegisterNewNewConnectionInDb(NewConnectionInfo newConnectionDetails) { int returnVal = 0; MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); //define the connection used by the command object msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "INSERT INTO application_register(apps_no,payment_id,customerId,received_date) " + "VALUES(@apps_no,@payment_id,@customerId,@received_date)"; msqlCommand.Parameters.AddWithValue("@apps_no", newConnectionDetails.appsNo); msqlCommand.Parameters.AddWithValue("@payment_id", newConnectionDetails.paymentId); msqlCommand.Parameters.AddWithValue("@customerId", newConnectionDetails.customerId); msqlCommand.Parameters.AddWithValue("@received_date", newConnectionDetails.receivedDate); msqlCommand.ExecuteNonQuery(); returnVal = 1; } catch (Exception er) { returnVal = 0; } finally { //always close the connection msqlConnection.Close(); } return returnVal; }
public static void EditNewConnection(NewConnectionInfo newConnectionToEdit) { MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "UPDATE application_register SET payment_id=@payment_id,received_date=@received_date WHERE apps_no=@apps_no"; msqlCommand.Parameters.AddWithValue("@payment_id", newConnectionToEdit.paymentId); msqlCommand.Parameters.AddWithValue("@received_date", newConnectionToEdit.receivedDate); msqlCommand.Parameters.AddWithValue("@apps_no", newConnectionToEdit.appsNo); msqlCommand.ExecuteNonQuery(); } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } }
private static List<NewConnectionInfo> QueryAllNewConnectionList() { List<NewConnectionInfo> NewConnectionList = new List<NewConnectionInfo>(); MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection(); try { //define the command reference MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand(); msqlCommand.Connection = msqlConnection; msqlCommand.CommandText = "Select * From application_register;"; MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader(); while (msqlReader.Read()) { NewConnectionInfo NewConnection = new NewConnectionInfo(); NewConnection.appsNo = msqlReader.GetString("apps_no"); NewConnection.customerId = msqlReader.GetString("customerId"); NewConnection.paymentId = msqlReader.GetString("payment_id"); NewConnection.receivedDate = msqlReader.GetDateTime("received_date"); NewConnectionList.Add(NewConnection); } } catch (Exception er) { } finally { //always close the connection msqlConnection.Close(); } return NewConnectionList; }
public static int DoRegisterNewNewConnection(NewConnectionInfo newConnectionDetails) { return DoRegisterNewNewConnectionInDb(newConnectionDetails); }
private void submitBtn_Click(object sender, RoutedEventArgs e) { NewConnectionInfo newConnection = new ESCMSData.NewConnectionInfo(); newConnection.paymentId = paymentIDTxtbox.Text; newConnection.customerId = customerIdlabel.Content.ToString(); newConnection.receivedDate = applicationReceivedDateDatePicker.SelectedDate.Value; if (isEdit == false) { newConnection.appsNo = GenerateId(); ESCMSStorage.DbInteraction.DoRegisterNewNewConnection(newConnection); estimateInfo esInfo = new estimateInfo(); esInfo.appsNo = newConnection.appsNo; ESCMSStorage.DbInteraction.DoRegisterNewEstimate(esInfo); } else { newConnection.appsNo = newConnectionId; ESCMSStorage.DbInteraction.EditNewConnection(newConnection); } this.Close(); }