private void savedatabase()
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
BAN = db.TBL_BANs.Single(p => p.MASOBAN.Equals(maban));
BAN.MASOBAN = tbxmanban.Text;
BAN.SOBAN = int.Parse(tbxsoban.Text);
BAN.SONGUOI = (int)numericUpDownsonguoi.Value;
if (radioButtondadat.Checked == true)
{
BAN.TRANGTHAI = radioButtondadat.Text;
}
else
if (radioButtontrong.Checked == true)
{
BAN.TRANGTHAI = radioButtontrong.Text;
}
db.SubmitChanges();
MessageBox.Show("Lưu thành công");
loadagainlistban(0);
}
catch (Exception ex)
{
throw ex;
}
}
private void button5_Click(object sender, EventArgs e)
{
luu = 1;
DataClasses1DataContext db = new DataClasses1DataContext();
tbban = db.GetTable <TBL_BAN>();
for (int i = 0; i < listViewbanan.Items.Count; i++)
{
if (listViewbanan.Items[i].Selected)
{
maban = listViewbanan.Items[i].SubItems[4].Text;
BAN = db.TBL_BANs.Single(p => p.MASOBAN.Equals(listViewbanan.Items[i].SubItems[4].Text));
tbxmanban.Text = listViewbanan.Items[i].SubItems[4].Text;
tbxsoban.Text = listViewbanan.Items[i].SubItems[0].Text.Substring(4, 1);
numericUpDownsonguoi.Value = int.Parse(listViewbanan.Items[i].SubItems[2].Text);
if (listViewbanan.Items[i].SubItems[3].Text.Equals("Trống"))
{
radioButtontrong.Checked = true;
}
else
{
radioButtondadat.Checked = true;
}
break;
}
}
}
private void button7_Click(object sender, EventArgs e)
{
int c = 0;
DataClasses1DataContext db = new DataClasses1DataContext();
tbban = db.GetTable <TBL_BAN>();
TBL_BAN BAN = new TBL_BAN();
for (int i = 0; i < listViewbanan.Items.Count; i++)
{
if (listViewbanan.Items[i].Selected)
{
c = 1;
BAN = db.TBL_BANs.Single(p => p.MASOBAN.Equals(listViewbanan.Items[i].SubItems[4].Text));
listViewbanan.Items[i].Remove();
db.TBL_BANs.DeleteOnSubmit(BAN);
db.SubmitChanges();
i--;
}
}
if (c == 1)
{
MessageBox.Show("Xóa thành công");
loadagainlistban(0);
}
else
if (c == 0)
{
MessageBox.Show("Không tìm thấy để xóa");
}
}
private void savedatabaseadd()
{
try
{
DataClasses1DataContext db = new DataClasses1DataContext();
TBL_BAN ban = new TBL_BAN();
tbban = db.GetTable <TBL_BAN>();
ban.MASOBAN = tbxmanban.Text;
ban.SOBAN = int.Parse(tbxsoban.Text);
ban.SONGUOI = (int)numericUpDownsonguoi.Value;
if (radioButtondadat.Checked == true)
{
ban.TRANGTHAI = radioButtondadat.Text;
}
else
if (radioButtontrong.Checked == true)
{
ban.TRANGTHAI = radioButtontrong.Text;
}
tbban.InsertOnSubmit(ban);
db.SubmitChanges();
MessageBox.Show("Lưu thành công");
}
catch (Exception ex)
{
throw ex;
}
}
private void button14_Click(object sender, EventArgs e)
{
int bancanchuyen = int.Parse(cbxbancanchuyen.SelectedItem.ToString());
int banchuyen = int.Parse(cbxbanchuyen.SelectedItem.ToString());
DataClasses1DataContext db = new DataClasses1DataContext();
tbban = db.GetTable <TBL_BAN>();
TBL_BAN bcc = new TBL_BAN();
TBL_BAN bc = new TBL_BAN();
bcc = db.TBL_BANs.Single(p => p.SOBAN.Equals(bancanchuyen));
bcc.TRANGTHAI = "Trống";
db.SubmitChanges();
bc = db.TBL_BANs.Single(p => p.SOBAN.Equals(banchuyen));
bc.TRANGTHAI = "Đã đặt";
db.SubmitChanges();
}
private void button4_Click(object sender, EventArgs e)
{
if (tbxmabandat.Text == "" || tbxtenkhachhang.Text == "")
{
MessageBox.Show("Hãy điền mã bàn và tên khách hàng để hủy đặt bàn");
}
else
{
DataClasses1DataContext db = new DataClasses1DataContext();
tbban = db.GetTable <TBL_BAN>();
TBL_BAN a = new TBL_BAN();
foreach (TBL_BAN r in tbban)
{
if (r.MASOBAN == tbxmabandat.Text && r.TENKHACHHANG == tbxtenkhachhang.Text && r.TRANGTHAI.Equals("Đã đặt"))
{
a = db.TBL_BANs.Single(p => p.MASOBAN.Equals(tbxmabandat.Text));
a.TRANGTHAI = "Trống";
a.TENKHACHHANG = "";
db.SubmitChanges();
}
}
loadcomboxban();
}
}
private void button6_Click(object sender, EventArgs e)
{
if (cbxsoban.SelectedIndex < 0 || tbxtenkhachhang.Text == "")
{
MessageBox.Show("Thông tin chưa đầy đủ");
}
else
{
DataClasses1DataContext db = new DataClasses1DataContext();
tbban = db.GetTable <TBL_BAN>();
TBL_BAN a = new TBL_BAN();
foreach (TBL_BAN r in tbban)
{
if (r.MASOBAN == tbxmabandat.Text)
{
a = db.TBL_BANs.Single(p => p.MASOBAN.Equals(tbxmabandat.Text));
a.TRANGTHAI = "Đã đặt";
a.TENKHACHHANG = tbxtenkhachhang.Text;
db.SubmitChanges();
}
}
loadcomboxban();
}
}
partial void DeleteTBL_BAN(TBL_BAN instance);
partial void UpdateTBL_BAN(TBL_BAN instance);
partial void InsertTBL_BAN(TBL_BAN instance);
private void button2_Click(object sender, EventArgs e)
{
int t = 0;
if ((tbxsoban.Text == null || tbxsoban.Text == "") && numericUpDownsonguoi.Value == 0)
{
MessageBox.Show("Bạn chưa nhập số bàn!!!");
}
else
{
DataClasses1DataContext db = new DataClasses1DataContext();
tbban = db.GetTable <TBL_BAN>();
TBL_BAN exampleban = new TBL_BAN();
if (radioButtondadat.Checked == true)
{
trangthai = radioButtondadat.Text;
}
else
if (radioButtontrong.Checked == true)
{
trangthai = radioButtontrong.Text;
}
if (tbxsoban.Text != null && numericUpDownsonguoi.Value == 0)
{
t = 0;
exampleban = db.TBL_BANs.Single(p => (p.SOBAN.Equals(tbxsoban.Text)) && p.TRANGTHAI.Equals(trangthai));
listViewbanan.Items.Clear();
listViewbanan.View = View.Details;
foreach (TBL_BAN r in tbban)
{
if (r == exampleban)
{
listViewbanan.Items.Add("Bàn " + r.SOBAN.ToString(), 0);
listViewbanan.Items[t].SubItems.Add((t + 1).ToString());
listViewbanan.Items[t].SubItems.Add(r.SONGUOI.ToString());
listViewbanan.Items[t].SubItems.Add(r.TRANGTHAI.ToString());
listViewbanan.Items[t].SubItems.Add(r.MASOBAN.ToString());
t++;
}
}
}
else
if (tbxsoban.Text != "" && numericUpDownsonguoi.Value > 0)
{
listViewbanan.Items.Clear();
t = 0;
songuoi = (int)numericUpDownsonguoi.Value;
foreach (TBL_BAN r in tbban)
{
if (r.SOBAN == int.Parse(tbxsoban.Text) && r.TRANGTHAI == trangthai && r.SONGUOI == songuoi)
{
listViewbanan.Items.Add("Bàn " + r.SOBAN.ToString(), 0);
listViewbanan.Items[t].SubItems.Add((t + 1).ToString());
listViewbanan.Items[t].SubItems.Add(r.SONGUOI.ToString());
listViewbanan.Items[t].SubItems.Add(r.TRANGTHAI.ToString());
listViewbanan.Items[t].SubItems.Add(r.MASOBAN.ToString());
t++;
}
}
}
else
if (tbxsoban.Text == "" && numericUpDownsonguoi.Value > 0)
{
songuoi = (int)numericUpDownsonguoi.Value;
listViewbanan.Items.Clear();
t = 0;
foreach (TBL_BAN r in tbban)
{
if (r.TRANGTHAI == trangthai && r.SONGUOI == songuoi)
{
listViewbanan.Items.Add("Bàn " + r.SOBAN.ToString(), 0);
listViewbanan.Items[t].SubItems.Add((t + 1).ToString());
listViewbanan.Items[t].SubItems.Add(r.SONGUOI.ToString());
listViewbanan.Items[t].SubItems.Add(r.TRANGTHAI.ToString());
listViewbanan.Items[t].SubItems.Add(r.MASOBAN.ToString());
t++;
}
}
}
else
{
MessageBox.Show("không tìm thấy");
}
}
}