private void AddDelivererToSelectedYearTableButton_Click(object sender, RoutedEventArgs e) { if (mMode == DelivererMode.DatabaseDeliverersTableDuplicates || mMode == DelivererMode.DatabaseDeliverersTableUpdateDeliverer || mMode == DelivererMode.DatabaseDeliverersTableAddDeliverer) { int rowToInsert = -1; int selectedRowCount = 0; string DelivererID = ""; string firstName = ""; string lastName = ""; //See see if only 1 row is selected and get that row number for (int i = 0; i < mDatabaseDeliverersTable.Rows.Count; i++) { if (DelivererBottomTable.IsSelected(i)) { rowToInsert = i; selectedRowCount++; } } //See see if only 1 row is selected if (selectedRowCount > 1) { System.Windows.MessageBox.Show("Only Select 1 Deliverer"); return; } //See if we should insert the Deliverer into the mSelectedYear table if (rowToInsert != -1) { //Get information to display to the user for confirmation DelivererID = mDatabaseDeliverersTable.Rows[rowToInsert]["Deliverer_ID"].ToString(); lastName = mDatabaseDeliverersTable.Rows[rowToInsert]["Last_Name"].ToString(); firstName = mDatabaseDeliverersTable.Rows[rowToInsert]["First_Name"].ToString(); //Update Access Database string insertCommand = "INSERT INTO " + Main.mSelectedYear + "_Deliverers" + " (Deliverer_ID) VALUES (" + mDatabaseDeliverersTable.Rows[rowToInsert]["Deliverer_ID"] + ")"; Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(insertCommand); } //Update data grid display DelivererTopTable.Refresh(); DelivererBottomTable.Refresh(); if (rowToInsert != -1) { //Show status message box System.Windows.MessageBox.Show("Deliverer: " + DelivererID + " - " + lastName + ", " + firstName + " ADDED in " + Main.mSelectedYear + "_Deliverers" + " Table"); //Close the Import Helper this.Close(); } } }
private void DeleteSelectedDelivererButton_Click(object sender, RoutedEventArgs e) { if (mMode == DelivererMode.DatabaseDeliverersTableDuplicates || mMode == DelivererMode.DatabaseDeliverersTableUpdateDeliverer || mMode == DelivererMode.DatabaseDeliverersTableAddDeliverer || mMode == DelivererMode.DatabaseDeliverersTableAddDeliverer) { int rowToDelete = -1; int selectedRowCount = 0; string DelivererID = ""; string firstName = ""; string lastName = ""; //See see if only 1 row is selected and get that row number for (int i = 0; i < mDatabaseDeliverersTable.Rows.Count; i++) { if (DelivererBottomTable.IsSelected(i)) { rowToDelete = i; selectedRowCount++; } } //See see if only 1 row is selected if (selectedRowCount > 1) { System.Windows.MessageBox.Show("Only Select 1 Deliverer"); return; } //See if we should delete the Deliverer into the Deliverers table if (rowToDelete != -1) { //Get information to display to the user for confirmation DelivererID = mDatabaseDeliverersTable.Rows[rowToDelete]["Deliverer_ID"].ToString(); lastName = mDatabaseDeliverersTable.Rows[rowToDelete]["Last_Name"].ToString(); firstName = mDatabaseDeliverersTable.Rows[rowToDelete]["First_Name"].ToString(); //Update Access Database string deleteCommand = "DELETE FROM Deliverers WHERE Deliverer_ID = " + mDatabaseDeliverersTable.Rows[rowToDelete]["Deliverer_ID"]; Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(deleteCommand); //Update data grid source mDatabaseDeliverersTable.Rows.RemoveAt(rowToDelete); } //Update data grid display DelivererTopTable.Refresh(); DelivererBottomTable.Refresh(); if (rowToDelete != -1) { //Show status message box System.Windows.MessageBox.Show("Deliverer: " + DelivererID + " - " + lastName + ", " + firstName + " DELETED from Deliverers Table"); } } }
private void AddSelectedDelivererToDeliverersAndSelectedYearTableButton_Click(object sender, RoutedEventArgs e) { int rowToAdd = -1; int selectedRowCount = 0; string DelivererID = ""; string firstName = ""; string lastName = ""; if (mMode == DelivererMode.DatabaseDeliverersTableAddDeliverer) { //Check for null values for (int i = 0; i < mExcelDeliverersTable.Rows.Count; i++) { if (DelivererTopTable.IsSelected(i)) { rowToAdd = i; selectedRowCount++; } } //Add the record into the Deliverers Table //See see if only 1 row is selected if (selectedRowCount > 1) { System.Windows.MessageBox.Show("Only Select 1 Deliverer"); return; } //See if we should add the Deliverer to the Deliverers table if (rowToAdd != -1) { //Check for null values foreach (DataColumn column in mExcelDeliverersTable.Columns) { if (mExcelDeliverersTable.Rows[rowToAdd][column.ColumnName].ToString() == "") { if (column.ColumnName == "Capacity_" + Main.mSelectedYear || column.ColumnName == "Assigned_" + Main.mSelectedYear) { mExcelDeliverersTable.Rows[rowToAdd][column.ColumnName] = "0"; } else { mExcelDeliverersTable.Rows[rowToAdd][column.ColumnName] = "null"; } } } //Update Access Database string insertCommand = "INSERT INTO Deliverers (Last_Name,First_Name,Home_Phone,Work_Phone,Capacity,Assigned,Occupation_Status,Comments)" + " VALUES (" + "'" + mExcelDeliverersTable.Rows[rowToAdd]["Last_Name"].ToString() + "'," + "'" + mExcelDeliverersTable.Rows[rowToAdd]["First_Name"].ToString() + "'," + "'" + mExcelDeliverersTable.Rows[rowToAdd]["Home_Phone"].ToString() + "'," + "'" + mExcelDeliverersTable.Rows[rowToAdd]["Work_Phone"].ToString() + "'," + "" + mExcelDeliverersTable.Rows[rowToAdd]["Capacity"] + "," + "" + mExcelDeliverersTable.Rows[rowToAdd]["Assigned"] + "," + "'" + mExcelDeliverersTable.Rows[rowToAdd]["Occupation_Status"].ToString() + "'," + "'" + mExcelDeliverersTable.Rows[rowToAdd]["Comments"].ToString() + "')"; Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(insertCommand); //Figure out what the Deliverer_ID was assigned string selectCommand = "SELECT * FROM Deliverers WHERE " + "Last_Name = '" + mExcelDeliverersTable.Rows[rowToAdd]["Last_Name"].ToString() + "' AND " + "First_Name = '" + mExcelDeliverersTable.Rows[rowToAdd]["First_Name"].ToString() + "'"; DataSet Deliverer = Main.mChristmasBasketsAccessDatabase.PerformSelectQuery(selectCommand, "Deliverers"); if (Deliverer != null) { //Get the record information to display to the user DelivererID = Deliverer.Tables[0].Rows[0]["Deliverer_ID"].ToString(); lastName = mExcelDeliverersTable.Rows[rowToAdd]["Last_Name"].ToString(); firstName = mExcelDeliverersTable.Rows[rowToAdd]["First_Name"].ToString(); System.Windows.MessageBox.Show("Deliverer: " + DelivererID + " - " + lastName + ", " + firstName + " ADDED in Deliverers Table"); //Copy Record over into mDatabaseDeliverersTable mDatabaseDeliverersTable.Rows.Add(); foreach (DataColumn column in mExcelDeliverersTable.Columns) { mDatabaseDeliverersTable.Rows[0][column.ColumnName] = mExcelDeliverersTable.Rows[0][column.ColumnName]; } mDatabaseDeliverersTable.Rows[0]["Deliverer_ID"] = DelivererID; //Insert the record to the Table string insertCommandTwo = "INSERT INTO " + Main.mSelectedYear + "_Deliverers" + " (Deliverer_ID) VALUES (" + DelivererID + ")"; Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(insertCommandTwo); //Show status message box System.Windows.MessageBox.Show("Deliverer: " + DelivererID + " - " + lastName + ", " + firstName + " ADDED in " + Main.mSelectedYear + "_Deliverers" + " Table"); //Close the Import Helper this.Close(); } DelivererTopTable.Refresh(); DelivererBottomTable.Refresh(); } } }
private void UpdateDelivererInformationButton_Click(object sender, RoutedEventArgs e) { if (mMode == DelivererMode.DatabaseDeliverersTableDuplicates || mMode == DelivererMode.DatabaseDeliverersTableUpdateDeliverer || mMode == DelivererMode.DatabaseDeliverersTableAddDeliverer) { int rowToUpdate = -1; int selectedRowCount = 0; string DelivererID = ""; string firstName = ""; string lastName = ""; //See see if only 1 row is selected and get that row number for (int i = 0; i < mDatabaseDeliverersTable.Rows.Count; i++) { if (DelivererBottomTable.IsSelected(i)) { rowToUpdate = i; selectedRowCount++; } } //See see if only 1 row is selected if (selectedRowCount > 1) { System.Windows.MessageBox.Show("Only Select 1 Deliverer"); return; } //See if we should update the Deliverer in the Deliverers table if (rowToUpdate != -1) { //Get information to display to the user for confirmation DelivererID = mDatabaseDeliverersTable.Rows[rowToUpdate]["Deliverer_ID"].ToString(); lastName = mDatabaseDeliverersTable.Rows[rowToUpdate]["Last_Name"].ToString(); firstName = mDatabaseDeliverersTable.Rows[rowToUpdate]["First_Name"].ToString(); //Check for null values foreach (DataColumn column in mDatabaseDeliverersTable.Columns) { if (mDatabaseDeliverersTable.Rows[rowToUpdate][column.ColumnName].ToString() == "") { mDatabaseDeliverersTable.Rows[rowToUpdate][column.ColumnName] = "null"; } } string updateCommand = "UPDATE Deliverers SET Last_Name = '" + mDatabaseDeliverersTable.Rows[rowToUpdate]["Last_Name"].ToString() + "', " + "First_Name = '" + mDatabaseDeliverersTable.Rows[rowToUpdate]["First_Name"].ToString() + "', " + "Home_Phone = '" + mDatabaseDeliverersTable.Rows[rowToUpdate]["Home_Phone"].ToString() + "', " + "Work_Phone = '" + mDatabaseDeliverersTable.Rows[rowToUpdate]["Work_Phone"].ToString() + "', " + "Capacity = " + mDatabaseDeliverersTable.Rows[rowToUpdate]["Capacity"] + ", " + "Assigned = " + mDatabaseDeliverersTable.Rows[rowToUpdate]["Assigned_" + Main.mSelectedYear.ToString()].ToString() + ", " + "Occupation_Status = '" + mDatabaseDeliverersTable.Rows[rowToUpdate]["Occupation_Status"].ToString() + "', " + "Comments = '" + mDatabaseDeliverersTable.Rows[rowToUpdate]["Comments"].ToString() + "'" + " WHERE Deliverer_ID = " + mDatabaseDeliverersTable.Rows[rowToUpdate]["Deliverer_ID"].ToString(); Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(updateCommand); } //Update data grid display DelivererTopTable.Refresh(); DelivererBottomTable.Refresh(); if (rowToUpdate != -1) { //Show Status message box System.Windows.MessageBox.Show("Deliverer: " + DelivererID + " - " + lastName + ", " + firstName + " UPDATED in Deliverers Table"); } } }