private void AddClientToSelectedYearTableButton_Click(object sender, RoutedEventArgs e)
{
if (mMode == ClientMode.DatabaseClientsTableDuplicates || mMode == ClientMode.DatabaseClientsTableUpdateClient || mMode == ClientMode.DatabaseClientsTableAddClient)
{
int rowToInsert = -1;
int selectedRowCount = 0;
string clientID = "";
string firstName = "";
string lastName = "";
//See see if only 1 row is selected and get that row number
for (int i = 0; i < mDatabaseClientsTable.Rows.Count; i++)
{
if (BottomTable.IsSelected(i))
{
rowToInsert = i;
selectedRowCount++;
}
}
//See see if only 1 row is selected
if (selectedRowCount > 1)
{
System.Windows.MessageBox.Show("Only Select 1 client");
return;
}
//See if we should insert the client into the mSelectedYear table
if (rowToInsert != -1)
{
//Get information to display to the user for confirmation
clientID = mDatabaseClientsTable.Rows[rowToInsert]["Client_ID"].ToString();
lastName = mDatabaseClientsTable.Rows[rowToInsert]["Last_Name"].ToString();
firstName = mDatabaseClientsTable.Rows[rowToInsert]["First_Name"].ToString();
//Update Access Database
string insertCommand = "INSERT INTO " + Main.mSelectedYear + " (Box_Number,Client_ID) VALUES (-1," + mDatabaseClientsTable.Rows[rowToInsert]["Client_ID"] + ")";
Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(insertCommand);
}
//Update data grid display
TopTable.Refresh();
BottomTable.Refresh();
if (rowToInsert != -1)
{
//Show status message box
System.Windows.MessageBox.Show("Client: " + clientID + " - " + lastName + ", " + firstName + " ADDED in " + Main.mSelectedYear + " Table");
//Close the Import Helper
this.Close();
}
}
}
private void DeleteSelectedClientButton_Click(object sender, RoutedEventArgs e)
{
if (mMode == ClientMode.DatabaseClientsTableDuplicates || mMode == ClientMode.DatabaseClientsTableUpdateClient || mMode == ClientMode.DatabaseClientsTableAddClient || mMode == ClientMode.DatabaseClientsTableAddClient)
{
int rowToDelete = -1;
int selectedRowCount = 0;
string clientID = "";
string firstName = "";
string lastName = "";
//See see if only 1 row is selected and get that row number
for (int i = 0; i < mDatabaseClientsTable.Rows.Count; i++)
{
if (BottomTable.IsSelected(i))
{
rowToDelete = i;
selectedRowCount++;
}
}
//See see if only 1 row is selected
if (selectedRowCount > 1)
{
System.Windows.MessageBox.Show("Only Select 1 client");
return;
}
//See if we should delete the client into the Clients table
if (rowToDelete != -1)
{
//Get information to display to the user for confirmation
clientID = mDatabaseClientsTable.Rows[rowToDelete]["Client_ID"].ToString();
lastName = mDatabaseClientsTable.Rows[rowToDelete]["Last_Name"].ToString();
firstName = mDatabaseClientsTable.Rows[rowToDelete]["First_Name"].ToString();
//Update Access Database
string deleteCommand = "DELETE FROM Clients WHERE Client_ID = " + mDatabaseClientsTable.Rows[rowToDelete]["Client_ID"];
Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(deleteCommand);
//Update data grid source
mDatabaseClientsTable.Rows.RemoveAt(rowToDelete);
}
//Update data grid display
TopTable.Refresh();
BottomTable.Refresh();
if (rowToDelete != -1)
{
//Show status message box
System.Windows.MessageBox.Show("Client: " + clientID + " - " + lastName + ", " + firstName + " DELETED from Clients Table");
}
}
}
private void UpdateClientInformationButton_Click(object sender, RoutedEventArgs e)
{
if (mMode == ClientMode.DatabaseClientsTableDuplicates || mMode == ClientMode.DatabaseClientsTableUpdateClient || mMode == ClientMode.DatabaseClientsTableAddClient)
{
int rowToUpdate = -1;
int selectedRowCount = 0;
string clientID = "";
string firstName = "";
string lastName = "";
//See see if only 1 row is selected and get that row number
for (int i = 0; i < mDatabaseClientsTable.Rows.Count; i++)
{
if (BottomTable.IsSelected(i))
{
rowToUpdate = i;
selectedRowCount++;
}
}
//See see if only 1 row is selected
if (selectedRowCount > 1)
{
System.Windows.MessageBox.Show("Only Select 1 client");
return;
}
//See if we should update the client in the Clients table
if (rowToUpdate != -1)
{
//Get information to display to the user for confirmation
clientID = mDatabaseClientsTable.Rows[rowToUpdate]["Client_ID"].ToString();
lastName = mDatabaseClientsTable.Rows[rowToUpdate]["Last_Name"].ToString();
firstName = mDatabaseClientsTable.Rows[rowToUpdate]["First_Name"].ToString();
//Check for null values
foreach (DataColumn column in mDatabaseClientsTable.Columns)
{
if (mDatabaseClientsTable.Rows[rowToUpdate][column.ColumnName].ToString() == "")
{
mDatabaseClientsTable.Rows[rowToUpdate][column.ColumnName] = "null";
}
}
string updateCommand = "UPDATE Clients SET Last_Name = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Last_Name"].ToString() + "', " +
"First_Name = '" + mDatabaseClientsTable.Rows[rowToUpdate]["First_Name"].ToString() + "', " +
"Middle_Name = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Middle_Name"].ToString() + "', " +
"Title = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Title"].ToString() + "', " +
"Address_Number = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Address_Number"].ToString() + "', " +
"Street_Address = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Street_Address"].ToString() + "', " +
"City = '" + mDatabaseClientsTable.Rows[rowToUpdate]["City"].ToString() + "', " +
"Zipcode = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Zipcode"].ToString() + "', " +
"Phone = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Phone"].ToString() + "', " +
"Organization = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Organization"].ToString() + "', " +
"Directions = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Directions"].ToString() + "', " +
"Instructions = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Instructions"].ToString() + "', " +
"Year_Last_Delivered_To = '" + mDatabaseClientsTable.Rows[rowToUpdate]["Year_Last_Delivered_To"].ToString() + "'" +
" WHERE Client_ID = " + mDatabaseClientsTable.Rows[rowToUpdate]["Client_ID"].ToString();
Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(updateCommand);
}
//Update data grid display
TopTable.Refresh();
BottomTable.Refresh();
if (rowToUpdate != -1)
{
//Show Status message box
System.Windows.MessageBox.Show("Client: " + clientID + " - " + lastName + ", " + firstName + " UPDATED in Clients Table");
}
}
}