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