private void Select_More_Details() { conn = new MySqlConnection("Server=localhost;Database=szakdoga_db;Uid=root;Pwd=;SslMode=none"); string q_select = String.Format("SELECT f.Name as Food, od.Count, f.Food_ID, f.Price FROM order_details od INNER JOIN food_list f ON f.Food_ID = od.Food WHERE Order_no={0}", Details[0].Order_no); try { conn.Open(); MySqlCommand cmd2 = new MySqlCommand(q_select, conn); MySqlDataReader dataReader2 = cmd2.ExecuteReader(); while (dataReader2.Read()) { Details2.Add(new Model.New_order_details { Food = (dataReader2["Food"].ToString()), Count = Convert.ToInt32(dataReader2["Count"]), Food_ID = Convert.ToInt32(dataReader2["Food_ID"]), Price = Convert.ToInt32(dataReader2["Price"]), }); } dataReader2.Close(); Sum_Prices(); conn.Close(); } catch (MySqlException ex) { MessageBox.Show(ex.ToString()); } }
private void Add_button() { if (New_Order_Details.Count != 0) { List <New_order_details> nod_list = new List <New_order_details>(); for (int i = 0; i < New_Order_Details.Count; i++) { nod_list.Add(New_Order_Details[i]); } int asd = Row_num; nod_list[Row_num].Count += 1; New_Order_Details.Clear(); for (int i = 0; i < nod_list.Count; i++) { New_Order_Details.Add(new Model.New_order_details { Food = nod_list[i].Food, Count = nod_list[i].Count, Food_ID = nod_list[i].Food_ID, Price = nod_list[i].Price }); } } else if (Details2.Count != 0) { Select_State(); if (state_global == "In Progress") { List <New_order_details> list = new List <New_order_details>(); for (int i = 0; i < Details2.Count; i++) { list.Add(Details2[i]); } list[Row_num].Count += 1; Details2.Clear(); for (int i = 0; i < list.Count; i++) { Details2.Add(new Model.New_order_details { Food = list[i].Food, Count = list[i].Count, Food_ID = list[i].Food_ID, Price = list[i].Price }); } Sum_Prices(); } else if (state_global == "Completed") { Display_Message = "Not editable! Order completed!"; } else { Display_Message = "Not editable! Order canceled!"; } } }
private void OD_Add_button() { bool n = true; bool z = true; if (Details[0].State == "In Progress") { for (int i = 0; i < Details2.Count; i++) { int u = Details2[i].Count; if (Details2[i].Food.Equals(Selected_food) && z == true) { Details2.RemoveAt(i); Details2.Add(new Model.New_order_details { Food = Selected_food, Count = Selected_Count + u, Food_ID = Selected_food_index + 1, Price = ListofFood[Selected_food_index + 1].Price }); n = true; z = false; } else { n = false; } } if (n == false && z == true) { Details2.Add(new Model.New_order_details { Food = Selected_food, Count = Selected_Count, Food_ID = Selected_food_index + 1, Price = ListofFood[Selected_food_index + 1].Price }); } } else { Display_Message = "Not editable! Order canceled or completed!"; } }