//Define methods
/// <Main>
/// Constructor
/// </Main>
public Main()
{
InitializeComponent();
//Initialize mChristmasBasketsAccessDatabase
mChristmasBasketsAccessDatabase = null;
//Initialize mQuitClientImport
mQuitClientImport = false;
//Initialize mQuitDelivererImport
mQuitDelivererImport = false;
//Initialize mSelectedYear
mSelectedYear = "NONE";
//Initialize SelectedYearLabel
SelectedYearLabel.Content = mSelectedYear;
//Initialize StampClientsWithSelectedYearButton
string year = mSelectedYear.Replace("Year_", "");
StampClientsWithSelectedYearButton.Content = "Set Client's Year__Last__Delivered__To = " + year;
//Initialize StampDeliverersWithSelectedYearButton
StampDeliverersWithSelectedYearButton.Content = "Set Deliverer's Year__Last__Delivered = " + year;
}
/// <SelectChristmasBasketsDatabase>
/// Open a 2003 (.mdb) or 2007 (.acccb) Access database file
/// </SelectChristmasBasketsDatabase>
private void SelectChristmasBasketsDatabase()
{
//Define local variables
string SelectedChristmasBasketsAccessDatabasePath = "";
string[] SplitSelectedChristmasBasketsAccessDatabasePath;
string DataBaseFileNameExtension = "";
//Open a File Dialog Box to the user
OpenFileDialog openFileDialogBox = new OpenFileDialog();
openFileDialogBox.Title = "Find Christmas Baskets Master Database";
//If the user selects a file and clicks OK...
if (openFileDialogBox.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
//Store the Access 2007 database path
SelectedChristmasBasketsAccessDatabasePath = openFileDialogBox.FileName;
//Determine the selected database's file name extension
SplitSelectedChristmasBasketsAccessDatabasePath = SelectedChristmasBasketsAccessDatabasePath.Split('.');
DataBaseFileNameExtension = SplitSelectedChristmasBasketsAccessDatabasePath.Last().ToString();
//Determine what type of database it is 2003 or 2007
if (DataBaseFileNameExtension == "mdb")
{
//Access 2003 Database
//Change the Indicator Color
OpenDatabaseIndicator.Fill = new SolidColorBrush(Colors.LightGreen);
//Create a new ChristmasBasketsAccess2003Database object and initialize it
mChristmasBasketsAccessDatabase = new ChristmasBasketsAccess2003Database(SelectedChristmasBasketsAccessDatabasePath);
//Open the database
mChristmasBasketsAccessDatabase.OpenChristmasBasketsDatabase();
}
else if (DataBaseFileNameExtension == "accdb")
{
//Access 2007 Database
//Change the Indicator Color
OpenDatabaseIndicator.Fill = new SolidColorBrush(Colors.LightGreen);
//Create a new ChristmasBasketsAccess2007Database object and initialize it
mChristmasBasketsAccessDatabase = new ChristmasBasketsAccess2007Database(SelectedChristmasBasketsAccessDatabasePath);
//Open the database
mChristmasBasketsAccessDatabase.OpenChristmasBasketsDatabase();
}
else
{
//Change the Indicator Color
OpenDatabaseIndicator.Fill = new SolidColorBrush(Colors.Red);
//Database type not supported
System.Windows.MessageBox.Show("Database type ." + DataBaseFileNameExtension + " not supported", "Invalid database type selected");
}
}
}
/// <CloseDatabase_Click>
/// Event handler for CloseDatabase_Click
/// </CloseDatabase_Click>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CloseDatabase_Click(object sender, RoutedEventArgs e)
{
//Close the Access database if it is open
if (mChristmasBasketsAccessDatabase != null)
{
//Close the Access Database
mChristmasBasketsAccessDatabase.CloseChristmasBasketsDatabase();
//Get rid of mChristmasBasketsAccessDatabase object
mChristmasBasketsAccessDatabase = null;
//Change the Indicator Colors
OpenDatabaseIndicator.Fill = new SolidColorBrush(Colors.CornflowerBlue);
Step_1_Year_Created_In_Database_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_2_Clients_Imported_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_2_a_Check_For_Client_Duplicates_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_3_Green_Cards_Generated_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_4_Deliverers_Imported_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_5_Clients_Assigned_To_Deliverers_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_6_Generated_Deliverer_Maps_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_7_Day_Of_Event_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_7_a_Generate_Unassigned_Clients_Map_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_7_b_Generate_Client_Lists_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_7_c_Generate_Food_Signs_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
Step_7_d_Generate_Box_Labels_Indicator.Fill = new SolidColorBrush(Colors.LightGray);
}
//Update Main.mSelectedYearStatus
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_1_Year_Created_In_Database] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_2_Clients_Imported] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_3_Green_Cards_Generated] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_4_Deliverers_Imported] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_5_Clients_Assigned_To_Deliverers] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_6_Generated_Deliverer_Maps] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_7_Day_Of_Event] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_7_a_Generate_Unassigned_Clients_Map] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_7_b_Generate_Client_Lists] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_7_c_Generate_Food_Signs] = false;
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_7_d_Generate_Box_Labels] = false;
//Update mSelected Year
mSelectedYear = "NONE";
//Update SelectedYearLabel
Window_MouseEnter(null, null);
}
