private void button1_Click(object sender, EventArgs e)
{
KhachHangXL x = new KhachHangXL();
dt1 = x.TraCuuKhachHang(tb_tenKH.Text, tb_diachi.Text);
dgvKH.DataSource = dt1;
dgvKH.Columns[0].ReadOnly = true;
dgvKH.Columns[0].Visible = false;
}
private void button4_Click(object sender, EventArgs e)
{
KhachHangXL x = new KhachHangXL();
SqlDataAdapter da = new SqlDataAdapter();
da = x.TraCuuKhachHang_DA(tb_tenKH.Text, tb_diachi.Text);
SqlCommandBuilder b = new SqlCommandBuilder(da);
da.Update(dt1);
}
private void bt_Luu_Click(object sender, EventArgs e)
{
string maKH = ConnectToDB.SinhMaKhachHang();
if (txt_TenKH.Text.CompareTo("") == 0)
{
MessageBox.Show("Xin nhập thông tin khách hàng!");
bt_Luu.Enabled = true;
bt_huy.Enabled = true;
}
else
{
KhachHangXL KhHang = new KhachHangXL(maKH, txt_TenKH.Text, txt_DC.Text, txt_SDT.Text);
bool kq = KhHang.ThemKhachHang();
if (kq == true)
{
txt_TenKH.Enabled = false;
txt_DC.Enabled = false;
txt_SDT.Enabled = false;
bt_Luu.Enabled = false;
bt_huy.Enabled = false;
}
}
for (int i = 0; i < Grid_DatMon.Rows.Count - 1; i++)
{
if (Grid_DatMon.Rows[i].Cells[0] == null || Grid_DatMon.Rows[i].Cells[1].Value == null)
{
MessageBox.Show("Thiếu thông tin đặt hàng");
bt_Luu.Enabled = true;
bt_huy.Enabled = true;
}
else
{
string mMA = Grid_DatMon.Rows[i].Cells[0].Value.ToString();
MonAnXL GMA = new MonAnXL();
int GiaMA = Convert.ToInt32(GMA.GiaMonAn(mMA));
float giaMA = Convert.ToInt32(Grid_DatMon.Rows[i].Cells[1].Value) * GiaMA;
Grid_DatMon.Rows[i].Cells[2].Value = giaMA;
//MessageBox.Show(Convert.ToString(giaMA));
DatComXL DatCom = new DatComXL(maKH, dtime_NgayDat.Text, dtime_NgayNhan.Text, mMA, Convert.ToInt32(Grid_DatMon.Rows[i].Cells[1].Value), giaMA);
bool kq = DatCom.ThemVaoDonDH();
if (kq == true)
{
MessageBox.Show("Đặt Món Ăn Thành Công!");
dtime_NgayDat.Enabled = false;
dtime_NgayNhan.Enabled = false;
Grid_DatMon.Enabled = false;
}
}
}
}
private void DatCom_Load(object sender, EventArgs e)
{
//Lay danh sach mon an
MonAnXL MA = new MonAnXL();
DataTable DT_MA = MA.DanhSachMonAn();
//them vao combobox
cb_MonAn.DataSource = DT_MA;
cb_MonAn.ValueMember = "MaMonAn";
cb_MonAn.DisplayMember = "TenMonAn";
//lay danh sach khach hang
KhachHangXL KhHang = new KhachHangXL();
DataTable DT_KhHang = KhHang.DanhSachKH();
}
