public void ReadListTable(string table = "Listtable")
{
string tmp = "";
String sqlQuery = "select * from " + table;
SqlCommand command = new SqlCommand(sqlQuery, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
if (reader.Read() == false)
{
break;
}
if (reader.GetString(0) != tmp)
{
parent.Add_Table(reader.GetString(0), reader.GetString(3));
tmp = reader.GetString(0);
}
else
{
parent.SetTableNotEmpty(reader.GetString(0));
}
}
reader.Close();
}
private void btAdd_Click(object sender, EventArgs e)
{
tbName.Text = ChuanHoa(tbName.Text);
if (tbName.Text != "")
{
if (FormQLBan.Add_Table(tbName.Text, ""))
{
FormQLBan.btAddTable.Hide();
FormQLBan.fpTables.Controls.Add(FormQLBan.btAddTable);
FormQLBan.btAddTable.Show();
FormQLBan.InSertTable(tbName.Text, "Bàn trống", "", "", "");
tbName.Text = "";
this.Hide();
}
}
else
{
MessageBox.Show("Chưa nhập tên bàn", "Lỗi thiếu dữ liệu");
}
}