public bool deleteTable(TableFoodDTO dto) { bool check = false; SqlConnection con = DBUtils.MakeConnection(); try { string sql = "Update TableFood Set status = @Status Where name = @Name"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@Status", dto.Status); cmd.Parameters.AddWithValue("@Name", dto.Name); if (con.State == ConnectionState.Closed) { con.Open(); } check = cmd.ExecuteNonQuery() > 0; } catch (Exception e) { throw new Exception(e.Message); } finally { con.Close(); } return(check); }
public string addTable(String nameTable) { string message = ""; if (nameTable.Equals("")) { message = "Bạn cần điền thông tin bàn ăn"; } else { string status = "Trống"; TableFoodDTO dto = new TableFoodDTO(nameTable, status); try { bool check = dao.addTable(dto); if (check) { message = "Thêm bàn ăn thành công"; } else { message = "Thêm bàn ăn lỗi"; } } catch (Exception ex) { if (ex.Message.Contains("duplicate")) { message = "Tên bàn đã tồn tại"; } } } return(message); }
public bool addTable(TableFoodDTO dto) { bool check = false; SqlConnection con = DBUtils.MakeConnection(); try { if (con != null) { string sql = "Insert TableFood(name, status) " + "Values(@Name, @Status)"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@Name", dto.Name); cmd.Parameters.AddWithValue("@Status", dto.Status); if (con.State == ConnectionState.Closed) { con.Open(); } check = cmd.ExecuteNonQuery() > 0; } } catch (Exception e) { if (e.Message.Contains("duplicate")) { throw new Exception(e.Message); } } finally { con.Close(); } return(check); }
private void btnCheckOut_Click(object sender, EventArgs e) { bool check = false; TableFoodDTO table = lsvBill.Tag as TableFoodDTO; if (table == null) { MessageBox.Show("Bạn chưa chọn bàn"); } else { if (MessageBox.Show("Xác nhận thanh toán " + table.Name, "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { string staff = accountLogin.Username; int total = Convert.ToInt32(txtTotalBill.Text); check = busBill.checkoutBill(table, staff, total); if (check) { MessageBox.Show("Thanh toán thành công"); flpTable.Controls.Clear(); LoadTable(); lsvBill.Items.Clear(); } else { MessageBox.Show("Lỗi"); } } } }
private void btnAddFood_Click(object sender, EventArgs e) { TableFoodDTO table = lsvBill.Tag as TableFoodDTO; string food = cbxFood.Text; int quantity = Convert.ToInt32(nudQuantity.Value); if (table == null) { MessageBox.Show("Bạn chưa chọn bàn"); } else { int idBill = busBillInfo.insertBillInfo(table, food, quantity); if (idBill == -1) { MessageBox.Show("Lỗi"); } else { flpTable.Controls.Clear(); LoadTable(); ShowBillInfo(table.Name, idBill); } } }
public int insertBillInfo(TableFoodDTO table, string food, int quantity) { bool check = false; BillBUS busBill = new BillBUS(); int idBill = busBill.getBillUnCheckoutByNameTable(table.Name); if (idBill == 0) { idBill = busBill.getMaxIDBill() + 1; DateTime currentDate = DateTime.Now; string nameTable = table.Name; string status = "Chưa thanh toán"; string staff = null; BillDTO dtoBill = new BillDTO(idBill, currentDate, nameTable, status, staff); check = busBill.insertBill(dtoBill); if (check) { int idBillInfo = dao.getMaxIDBillInfo() + 1; BillInfoDTO dtoBillInfo = new BillInfoDTO(idBillInfo, idBill, food, quantity); check = dao.insertBillInfo(dtoBillInfo); if (check) { string statusTable = "Có người"; TableFoodBUS busTable = new TableFoodBUS(); check = busTable.updateStatusTable(nameTable, statusTable); } } } else { BillInfoDTO dtoBillInfo = dao.checkExistFoodInBill(idBill, food); if (dtoBillInfo != null) { check = dao.updateQuantityBillInfo(dtoBillInfo.Id, quantity + dtoBillInfo.Quantity); } else { int idBillInfo = dao.getMaxIDBillInfo() + 1; dtoBillInfo = new BillInfoDTO(idBillInfo, idBill, food, quantity); check = dao.insertBillInfo(dtoBillInfo); } } if (!check) { idBill = -1; } return(idBill); }
public bool checkoutBill(TableFoodDTO table, string staff, int total) { BillBUS busBill = new BillBUS(); int idBill = busBill.getBillUnCheckoutByNameTable(table.Name); DateTime checkOutDate = DateTime.Now; string status = "Đã thanh toán"; bool check = dao.checkoutBill(idBill, staff, total, status, checkOutDate); if (check) { TableFoodBUS busTable = new TableFoodBUS(); check = busTable.updateStatusTable(table.Name, "Trống"); } return(check); }
public List <TableFoodDTO> LoadAllTable() { List <TableFoodDTO> listTable = new List <TableFoodDTO>(); SqlConnection con = DBUtils.MakeConnection(); try { if (con != null) { String sql = "Select name, status From TableFood where status != 'Inactive'"; SqlCommand cmd = new SqlCommand(sql, con); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { string name = (string)dr["name"]; string status = (string)dr["status"]; TableFoodDTO dto = new TableFoodDTO(name, status); listTable.Add(dto); } } } } catch (Exception e) { throw new Exception(e.Message); } finally { con.Close(); } return(listTable); }
public string deleteTable(String nameTable) { string message = ""; if (nameTable.Equals("")) { message = "Bạn cần điền thông tin bàn ăn"; } else { string status = "Inactive"; TableFoodDTO dto = new TableFoodDTO(nameTable, status); bool check = dao.deleteTable(dto); if (check) { message = "Xóa bàn ăn thành công"; } else { message = "Xóa bàn ăn lỗi"; } } return(message); }