private void CreateYear_Click(object sender, RoutedEventArgs e)
{
//Define local variables
string yearToCreate = "Year_" + YearToCreateTextBox.Text;
//Create the createYearCommandText - Creates a Year_selectedYear table in the database
string createClientYearCommandText = "CREATE TABLE " + yearToCreate + " (Box_Number INTEGER, Client_ID INTEGER, Assigned_Status TEXT)";
//Create the Year_yearToCreate table in the database
Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(createClientYearCommandText);
//Create the createDelivererYearCommandText - Creates a Year_yearToCreate_Deliverers table in the database
string createDelivererYearCommandText = "CREATE TABLE " + yearToCreate + "_Deliverers" + " (Deliverer_ID INTEGER, Clients TEXT)";
//Create the Year_yearToCreate_Deliverers table in the database
Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(createDelivererYearCommandText);
//Create the createFoodYearCommandText - Creates a Year_selectedYear_Food table in the database
string createFoodYearCommandText = "CREATE TABLE " + yearToCreate + "_Food" + " (Food_Name TEXT, Food_Number_To_Put_In_Box INTEGER)";
//Create the Year_yearToCreate_Food table in the database
Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(createFoodYearCommandText);
//Update the YearsListBox
YearsListBox.Items.Add(yearToCreate);
YearsListBox.SelectedItem = yearToCreate;
YearsListBox.ScrollIntoView(yearToCreate);
//Create insertStatusYearCommand to insert and initialize yearToCreate_Status's yearToCreate Record database item
string insertStatusYearCommand = "INSERT INTO Status (Year_ID, " +
"Step_1_Year_Created_In_Database, " +
"Step_2_Clients_Imported, " +
"Step_2_a_Check_For_Client_Duplicates, " +
"Step_3_Green_Cards_Generated, " +
"Step_4_Deliverers_Imported, " +
"Step_5_Clients_Assigned_To_Deliverers, " +
"Step_6_Generated_Deliverer_Maps, " +
"Step_7_Day_Of_Event, " +
"Step_7_a_Generate_Unassigned_Clients_Map, " +
"Step_7_b_Generate_Client_Lists, " +
"Step_7_c_Generate_Food_Signs, " +
"Step_7_d_Generate_Box_Labels) " +
"VALUES ('" + yearToCreate + "', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')";
//insert and initialize yearToCreate_Status's yearToCreate Record database item
Main.mChristmasBasketsAccessDatabase.ExecuteNonQuery(insertStatusYearCommand);
//Update Main.mSelectedYearStatus
Main.mSelectedYearStatus[(int)Main.mSelectedYearStatusEnum.Step_1_Year_Created_In_Database] = true;
}
public WindowSelectYear()
{
InitializeComponent();
//Define local variables
DataTable userTables = null;
// We only want user tables, not system tables
string[] restrictions = new string[4];
restrictions[3] = "Table";
//See if we have an Access database
if (Main.mChristmasBasketsAccessDatabase != null)
{
// Get list of user tables
userTables = Main.mChristmasBasketsAccessDatabase.GetSchema("Tables", restrictions);
}
// Add list of table names to listBox
for (int i = 0; i < userTables.Rows.Count; i++)
{
//Only add the Tables formatted as Year_
if (userTables.Rows[i][2].ToString().Contains("Year_") && (!userTables.Rows[i][2].ToString().Contains("Deliverers") && !userTables.Rows[i][2].ToString().Contains("Food")))
{
YearsListBox.Items.Add(userTables.Rows[i][2].ToString());
}
}
//Highlight the selected item if it exists already
if (Main.mSelectedYear != "NONE")
{
// Find the string in ListBox2.
int index = YearsListBox.Items.IndexOf(Main.mSelectedYear);
// If the item was found in ListBoxOfYears select it in ListBoxOfYears.
if (index != -1)
{
YearsListBox.SelectedIndex = index;
YearsListBox.ScrollIntoView(Main.mSelectedYear);
}
}
}
