private void gdg_handler1(object sender, EventArgs e) { for (int i = 0; i < f.Controls.Count; i++){ if (f.Controls[i].Tag == "dish") { f.Controls[i].Visible = false; } } sender_parser sp = new sender_parser(); db_adapter db = new db_adapter(); DataTable dt = new DataTable(); dt = db.get_dishtype(); string name_sender = sp.parse(sender.ToString()); int sender_id = -1; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i].Field<string>("name") == name_sender) { sender_id = dt.Rows[i].Field<int>("id"); } } if (sender_id != -1) generate_dishes(sender_id); }
private void gd_handler1(object sender, EventArgs e) { sender_parser sp = new sender_parser(); db_adapter db = new db_adapter(); DataTable dt = new DataTable(); int order_id = 0; string name_sender = sp.parse(sender.ToString()); dt = db.get_dish(); int sender_id = -1; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i].Field<string>("name") == name_sender) { sender_id = dt.Rows[i].Field<int>("id"); } } dt = db.get_dish_by_id(sender_id); os.orders.Last().check.quantity++; os.orders.Last().check.total_cost += dt.Rows[0].Field<int>("cost"); os.orders.Last().check.add_dish(sender_id); os.orders.Last().id = order_id; order_id++; this.f.Controls[3].Text += "\n"; this.f.Controls[3].Text += dt.Rows[0].Field<string>("name"); this.f.Controls[0].Text = os.orders.Last().check.total_cost.ToString(); this.f.Controls[2].Text += "\n"; this.f.Controls[2].Text += dt.Rows[0].Field<int>("cost"); this.f.Controls[0].Text = os.orders.Last().check.total_cost.ToString(); }
private void ov_handler1(object sender, EventArgs e) { sender_parser sp = new sender_parser(); string ss = sp.parse(sender.ToString()); ss = sp.get_digit(ss); int order_number = Convert.ToInt32(ss); int waiter = this.os.orders[order_number].waiter_id; int table = this.os.orders[order_number].table.number; int client = 0; //if (this.os.orders[order_number].client.id != 0) client = this.os.orders[order_number].client.id; int total_price = this.os.orders[order_number].check.total_cost; this.os.orders[order_number] = null; db_adapter db = new db_adapter(); db.send_order(waiter, table, client, total_price); orders_view(); }
private void ov_handler2(object sender, EventArgs e) { Form f2 = new Form(); db_adapter db = new db_adapter(); DataTable dt = new DataTable(); dt = db.get_orders(); DataGridView dgv = new DataGridView(); Size s = new Size(900, 300); dgv.Size = s; dgv.Size = s; f2.Size = s; dgv.DataSource = dt; f2.Controls.Add(dgv); f2.Show(); }
public void set_data() { db_adapter db = new db_adapter(); if (!db.send_tables(this)) { MessageBox.Show("Не могу обновить таблицу столов. Ваш мускул."); } }
// Запросы на замену public bool send_tables(table_set ts) { DataTable dt = new DataTable(); MySqlConnectionStringBuilder mysqlCSB; mysqlCSB = new MySqlConnectionStringBuilder(); mysqlCSB.Server = server; mysqlCSB.Database = db; mysqlCSB.UserID = user; mysqlCSB.Password = pass; db_adapter db2 = new db_adapter(); DataTable dt2 = new DataTable(); dt2 = db2.get_tables(); for (int i = 0; i < dt2.Rows.Count; i++) { int id = ts.table[i].number; bool bu = ts.table[i].busy; bool re = ts.table[i].reserved; DateTime rt = ts.table[i].res_time; string queryString = @"UPDATE table SET busy = "; queryString += bu.ToString(); queryString = @", reserved = "; queryString += re.ToString(); queryString = @", res_time = "; queryString += rt.ToString(); queryString = @" WHERE id = "; queryString += id.ToString(); queryString = @" LIMIT 1 ;"; using (MySqlConnection con = new MySqlConnection()) { con.ConnectionString = mysqlCSB.ConnectionString; MySqlCommand com = new MySqlCommand(queryString, con); try { con.Open(); using (MySqlDataReader dr = com.ExecuteReader()) { if (dr.HasRows) { dt.Load(dr); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } return true; }
public client(int arg_id) { db_adapter db = new db_adapter(); DataTable dt = new DataTable(); dt = db.get_client_by_id(arg_id); id = dt.Rows[0].Field<int>("id"); name = dt.Rows[0].Field<string>("name"); count = dt.Rows[0].Field<int>("count_order"); discount = dt.Rows[0].Field<int>("discount"); }
private void get_data() { db_adapter db = new db_adapter(); DataTable dt = new DataTable(); dt = db.get_tables(); for (int i = 0; i < dt.Rows.Count; i++) { table[i].number = i; table[i].busy = dt.Rows[i].Field<bool>("busy"); table[i].reserved = dt.Rows[i].Field<bool>("reserved"); if (table[i].reserved == true) table[i].res_time = dt.Rows[i].Field<DateTime>("res_time"); else { DateTime nullTime = new DateTime(); table[i].res_time = nullTime; } } }
public dish_group(int arg_id) { db_adapter db = new db_adapter(); DataTable dt = new DataTable(); dt = db.get_dishtype_by_id(arg_id); id = dt.Rows[0].Field<int>("id"); name = dt.Rows[0].Field<string>("name"); }
public dish_group_set() { DataTable dt = new DataTable(); db_adapter db = new db_adapter(); dt = db.get_all_ids_dish_type(); int count = dt.Rows.Count; dish_group = new dish_group[count]; for (int i = 0; i < count; i++) { dish_group[i] = new dish_group( dt.Rows[i].Field<int>("id") ); } }
public dish(int arg_id) { db_adapter db = new db_adapter(); DataTable dt = db.get_dish_by_id(arg_id); name = dt.Rows[0].Field<string>("name"); id = dt.Rows[0].Field<int>("id"); cost = dt.Rows[0].Field<int>("cost"); }
public void generate_dishes(int arg_id) { db_adapter db = new db_adapter(); DataTable dt = new DataTable(); dt = db.get_all_dishes_from_group(arg_id); Point point = new Point(220,100); for (int i = 0; i < dt.Rows.Count; i++) { Button btn = new Button(); btn.Text = dt.Rows[i].Field<string>("name"); btn.Click += new System.EventHandler(this.gd_handler1); btn.Location = point; point.X = 220; point.Y += 40; btn.Height = 30; btn.Width = 145; btn.Tag = "dish"; f.Controls.Add(btn); } }
// BUTTONS GENERTORS public void generate_dishes_groups(){ db_adapter db = new db_adapter(); DataTable dt = new DataTable(); dt = db.get_dishtype(); int x = 60; int y = 85; Point point = new Point(x, y); for (int i = 0; i < dt.Rows.Count; i++) { Button btn = new Button(); btn.Text = dt.Rows[i].Field<string>("name"); btn.Click += new System.EventHandler(this.gdg_handler1); btn.Location = point; point.X = 60; point.Y += 40; btn.Height = 30; btn.Width = 145; f.Controls.Add(btn); } }