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