public user_desktop() { InitializeComponent(); SqlConnection sqlConnection = new SqlConnection(connection_string); sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand("select * from Food_Menu", sqlConnection); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { var item = new Search_item(); item.Name_Food = sqlDataReader.GetValue(0).ToString(); item.Cost_Food = sqlDataReader.GetValue(1).ToString(); item.Information_Food = sqlDataReader.GetValue(2).ToString(); item.Date_Food = sqlDataReader.GetValue(3).ToString(); item.Uri_Food = sqlDataReader.GetValue(4).ToString(); item.Kind_Food = sqlDataReader.GetValue(5).ToString(); item.Number_Food = sqlDataReader.GetValue(6).ToString(); search_Table.Add(item); } sqlCommand.Dispose(); sqlConnection.Close(); User_List.counter = 2; DateTime startDate = DateTime.Today; DateTime endDate = startDate.AddMonths(1); calendar.DisplayDateEnd = endDate; user_name.Text = Current_user.FullName; sqlConnection = new SqlConnection(connection_string); sqlConnection.Open(); sqlCommand = new SqlCommand("select * from Food_Menu", sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { if (User_List.counter == 2) { if (sqlDataReader.GetValue(6).ToString() != "0") { Main_stack.Children.Add(User_List.construct_food(sqlDataReader.GetValue(0).ToString(), sqlDataReader.GetValue(1).ToString(), sqlDataReader.GetValue(2).ToString(), sqlDataReader.GetValue(3).ToString(), sqlDataReader.GetValue(4).ToString(), sqlDataReader.GetValue(5).ToString(), sqlDataReader.GetValue(6).ToString())); } } else { if (sqlDataReader.GetValue(6).ToString() != "0") { User_List.construct_food(sqlDataReader.GetValue(0).ToString(), sqlDataReader.GetValue(1).ToString(), sqlDataReader.GetValue(2).ToString(), sqlDataReader.GetValue(3).ToString(), sqlDataReader.GetValue(4).ToString(), sqlDataReader.GetValue(5).ToString(), sqlDataReader.GetValue(6).ToString()); } } } sqlCommand.Dispose(); sqlConnection.Close(); }
private void Name_search_Click(object sender, RoutedEventArgs e) { Main_stack.Children.Clear(); User_List.counter = 2; var list = search_Table.Where(x => x.Name_Food == Food_search_txt.Text).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } }
private void week_search_Click(object sender, RoutedEventArgs e) { DateTime date = new DateTime(); Main_stack.Children.Clear(); User_List.counter = 2; List <Search_item> list = new List <Search_item>(); if (saturday.IsChecked == true) { list = search_Table.Where(x => (int)DateTime.Parse(x.Date_Food, CultureInfo.InvariantCulture).DayOfWeek == 6).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } else if (sunday.IsChecked == true) { list = search_Table.Where(x => (int)DateTime.Parse(x.Date_Food, CultureInfo.InvariantCulture).DayOfWeek == 0).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } else if (monday.IsChecked == true) { list = search_Table.Where(x => (int)DateTime.Parse(x.Date_Food, CultureInfo.InvariantCulture).DayOfWeek == 1).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } else if (tuesday.IsChecked == true) { list = search_Table.Where(x => (int)DateTime.Parse(x.Date_Food, CultureInfo.InvariantCulture).DayOfWeek == 2).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } else if (wednesday.IsChecked == true) { list = search_Table.Where(x => (int)DateTime.Parse(x.Date_Food, CultureInfo.InvariantCulture).DayOfWeek == 3).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } else if (thursday.IsChecked == true) { list = search_Table.Where(x => (int)DateTime.Parse(x.Date_Food, CultureInfo.InvariantCulture).DayOfWeek == 4).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } else if (friday.IsChecked == true) { list = search_Table.Where(x => (int)DateTime.Parse(x.Date_Food, CultureInfo.InvariantCulture).DayOfWeek == 5).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } }
private void Date_search_Click(object sender, RoutedEventArgs e) { Main_stack.Children.Clear(); User_List.counter = 2; var list = new List <Search_item>(); //1 if ((ingridient_txt.Text.Equals("") == true || ingridient_txt.Text.Equals("Ingridient") == true) && (price_txt.Text.Equals("") == true || price_txt.Text.Equals("Price") == true) && calendar.Text != "") { list = search_Table.Where(x => x.Date_Food == calendar.Text).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } calendar.Text = ""; } //2 else if ((ingridient_txt.Text.Equals("") == true || ingridient_txt.Text.Equals("Ingridient") == true) && (price_txt.Text.Equals("") == true || price_txt.Text.Equals("Price") == true) && calendar.Text == "") { calendar.Text = ""; return; } //3 else if ((ingridient_txt.Text.Equals("") == true || ingridient_txt.Text.Equals("Ingridient") == true) && (price_txt.Text.Equals("") == false || price_txt.Text.Equals("Price") == false) && calendar.Text != "") { list = search_Table.Where(x => x.Date_Food == calendar.Text && double.Parse(x.Cost_Food) <= double.Parse(price_txt.Text)).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } calendar.Text = ""; } //4 else if ((ingridient_txt.Text.Equals("") == true || ingridient_txt.Text.Equals("Ingridient") == true) && (price_txt.Text.Equals("") == false || price_txt.Text.Equals("Price") == false) && calendar.Text == "") { list = search_Table.Where(x => double.Parse(x.Cost_Food) <= double.Parse(price_txt.Text)).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } calendar.Text = ""; } //5 else if ((ingridient_txt.Text.Equals("") == false || ingridient_txt.Text.Equals("Ingridient") == false) && (price_txt.Text.Equals("") == true || price_txt.Text.Equals("Price") == true) && calendar.Text != "") { list = search_Table.Where(x => x.Date_Food == calendar.Text && x.Information_Food.Split(',').Any(y => y == ingridient_txt.Text)).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } calendar.Text = ""; } //6 else if ((ingridient_txt.Text.Equals("") == false || ingridient_txt.Text.Equals("Ingridient") == false) && (price_txt.Text.Equals("") == true || price_txt.Text.Equals("Price") == true) && calendar.Text == "") { list = search_Table.Where(x => x.Information_Food.Split(',').Any(y => y == ingridient_txt.Text)).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } calendar.Text = ""; } //7 else if ((ingridient_txt.Text.Equals("") == false || ingridient_txt.Text.Equals("Ingridient") == false) && (price_txt.Text.Equals("") == false || price_txt.Text.Equals("Price") == false) && calendar.Text != "") { list = search_Table.Where(x => x.Date_Food == calendar.Text && double.Parse(x.Cost_Food) <= double.Parse(price_txt.Text) && x.Information_Food.Split(',').Any(y => y == ingridient_txt.Text)).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } calendar.Text = ""; } //8 else if ((ingridient_txt.Text.Equals("") == false || ingridient_txt.Text.Equals("Ingridient") == false) && (price_txt.Text.Equals("") == false || price_txt.Text.Equals("Price") == false) && calendar.Text == "") { list = search_Table.Where(x => x.Information_Food.Split(',').Any(y => y == ingridient_txt.Text) && double.Parse(x.Cost_Food) <= double.Parse(price_txt.Text)).ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } calendar.Text = ""; }
private void Kind_search_Click(object sender, RoutedEventArgs e) { Main_stack.Children.Clear(); User_List.counter = 2; var list = new List <Search_item>(); //1 if (traditional.IsChecked == false && pizza.IsChecked == false && hamburger.IsChecked == false && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food == "").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //2 else if (traditional.IsChecked == true && pizza.IsChecked == true && hamburger.IsChecked == true && sandwitch.IsChecked == true) { list = search_Table; foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //3 else if (traditional.IsChecked == true && pizza.IsChecked == true && hamburger.IsChecked == true && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food != "sandwitch").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //4 else if (traditional.IsChecked == true && pizza.IsChecked == true && hamburger.IsChecked == false && sandwitch.IsChecked == true) { list = search_Table.Where(x => x.Kind_Food != "hamburger").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //5 else if (traditional.IsChecked == true && pizza.IsChecked == true && hamburger.IsChecked == false && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food == "traditional" || x.Kind_Food == "pizza").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //6 else if (traditional.IsChecked == true && pizza.IsChecked == false && hamburger.IsChecked == true && sandwitch.IsChecked == true) { list = search_Table.Where(x => x.Kind_Food != "pizza").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //7 else if (traditional.IsChecked == true && pizza.IsChecked == false && hamburger.IsChecked == true && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food == "traditional" || x.Kind_Food == "hamburger").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //8 else if (traditional.IsChecked == true && pizza.IsChecked == false && hamburger.IsChecked == false && sandwitch.IsChecked == true) { list = search_Table.Where(x => x.Kind_Food == "traditional" || x.Kind_Food == "sandwitch").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //9 else if (traditional.IsChecked == true && pizza.IsChecked == false && hamburger.IsChecked == false && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food == "traditional").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //10 else if (traditional.IsChecked == false && pizza.IsChecked == true && hamburger.IsChecked == true && sandwitch.IsChecked == true) { list = search_Table.Where(x => x.Kind_Food != "traditional").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //11 else if (traditional.IsChecked == false && pizza.IsChecked == true && hamburger.IsChecked == true && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food == "pizza" || x.Kind_Food == "hamburger").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //12 else if (traditional.IsChecked == false && pizza.IsChecked == true && hamburger.IsChecked == false && sandwitch.IsChecked == true) { list = search_Table.Where(x => x.Kind_Food == "sandwitch" || x.Kind_Food == "pizza").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //13 else if (traditional.IsChecked == false && pizza.IsChecked == true && hamburger.IsChecked == false && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food == "pizza").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //14 else if (traditional.IsChecked == false && pizza.IsChecked == false && hamburger.IsChecked == true && sandwitch.IsChecked == true) { list = search_Table.Where(x => x.Kind_Food == "hamburger" || x.Kind_Food == "sandwitch").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //15 else if (traditional.IsChecked == false && pizza.IsChecked == false && hamburger.IsChecked == true && sandwitch.IsChecked == false) { list = search_Table.Where(x => x.Kind_Food == "hamburger").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } //16 else if (traditional.IsChecked == false && pizza.IsChecked == false && hamburger.IsChecked == false && sandwitch.IsChecked == true) { list = search_Table.Where(x => x.Kind_Food == "sandwitch").ToList(); foreach (var item in list) { if (User_List.counter == 2) { Main_stack.Children.Add(User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food)); } else { User_List.construct_food(item.Name_Food, item.Cost_Food, item.Information_Food, item.Date_Food, item.Uri_Food, item.Kind_Food, item.Number_Food); } } } }