//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); }