private void txtCusNumber_TextChanged(object sender, EventArgs e)
{
BUS_Customer busCus = new BUS_Customer();
try
{
cus = busCus.searchPhone(txtCusPhone1.Text);
if (cus != null)
{
txtCusName.Text = cus.cusName;
txtCusAdress.Text = cus.cusAddress;
}
else
{
txtCusName.Text = "";
txtCusAdress.Text = "";
}
}
catch
{
txtCusName.Text = "";
txtCusAdress.Text = "";
txtCusPhone1.Clear();
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
int count = 0;
BUS_Order bus = new BUS_Order();
BUS_Orderdetail busOderDetail = new BUS_Orderdetail();
BUS_Customer busCus = new BUS_Customer();
string valid = checkConfirm();
if (valid.Equals(""))
{
if (cus != null)
{
string cusphone = cus.cusPhonenumber;
string idEmp = employee.Username;
long totalPrice = int.Parse(lblTotalPrice.Text);
int totalQuantity = int.Parse(lblQuantity.Text);
DTO_Order order = new DTO_Order(cusphone, idEmp, totalPrice, totalQuantity);
int IDOrder = bus.createOrder(order);
foreach (DTO_Product pro in listCart)
{
DTO_OrderDetail detail = new DTO_OrderDetail(IDOrder, pro.proID, pro.proPrice, pro.discount, pro.proQuantity);
int counts = busOderDetail.createOrderDetail(detail);
count += counts;
}
showBill();
MessageBox.Show(count.ToString());
}
else
{
string newCus = txtCusName.Text;
string newPhone = txtCusPhone1.Text;
string newAdd = txtCusAdress.Text;
cus = new DTO_Customer(newPhone, newCus, newAdd);
busCus.creatCustomer(cus);
string idEmp = employee.Username;
int totalQuantity = int.Parse(lblQuantity.Text);
long totalPrice = int.Parse(lblTotalPrice.Text);
DTO_Order order = new DTO_Order(cus.cusPhonenumber, idEmp, totalPrice, totalQuantity);
int IDOrder = bus.createOrder(order);
foreach (DTO_Product pro in listCart)
{
DTO_OrderDetail detail = new DTO_OrderDetail(IDOrder, pro.proID, pro.proPrice, pro.discount, pro.proQuantity);
int counts = busOderDetail.createOrderDetail(detail);
count += counts;
}
MessageBox.Show(count.ToString());
showBill();
}
clear1();
loadProduct();
}
else
{
MessageBox.Show(valid);
}
}
private void btndelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có muốn xoá thật không?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
BUS_Customer DL = new BUS_Customer();
DTO_Customer DT = new DTO_Customer(Convert.ToInt32(txtmakh.Text));
DL.DeleteCustomer(DT);
dgvkh.DataSource = GetCustomer();
MessageBox.Show(" BẠN ĐÃ XÓA KHÁCH HÀNG THÀNH CÔNG", " Xác nhận");
}
}
private void btnTimKiemKH_Click(object sender, EventArgs e)
{
switch (typeCheck)
{
case 1:
{
DTO_Customer emp = new DTO_Customer(Convert.ToInt32(txtbtimkiemkh.Text));
DataTable dt = new DataTable();
BUS_Customer em = new BUS_Customer();
dt = em.SearchByMaKH(emp);
dgvtimkiem.DataSource = dt;
break;
}
}
}
private void btnedit_Click(object sender, EventArgs e)
{
{
int makh;
string hokh, tenkh, sdt, gioitinh, diachithuongtru, email;
DateTime ngaysinh;
makh = int.Parse(txtmakh.Text.Trim());
hokh = txthokh.Text.Trim();
tenkh = txttenkh.Text.Trim();
gioitinh = txtgioittinhkh.Text.Trim();
sdt = txtsdtkh.Text.Trim();
ngaysinh = Convert.ToDateTime(dtpngaysinhkh.Text.ToString());
diachithuongtru = txtdiachickh.Text.Trim();
email = txtemailkh.Text.Trim();
DTO_Customer emp = new DTO_Customer(makh, hokh, tenkh, gioitinh, sdt, ngaysinh, diachithuongtru, email);
try
{
int i = new BUS_Customer().UpdateCustomer(emp);
if (i == -2)
{
throw new Exception();
}
MessageBox.Show("ĐÃ SỬA THÀNH CÔNG", "Xác nhận");
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dgvkh.DataSource = GetCustomer();
}
}
private void btnadd_Click(object sender, EventArgs e)
{
int pMaKH;
string pHoKH, pTenKH, pGioiTinh, pSDT, pDiaChiThuongTru, pEmail;
DateTime pNgaySinh;
pMaKH = Convert.ToInt32(txtmakh.Text);
pHoKH = txthokh.Text.Trim();
pTenKH = txttenkh.Text.Trim();
pGioiTinh = txtgioittinhkh.Text.Trim();
pSDT = txtsdtkh.Text.Trim();
pNgaySinh = Convert.ToDateTime(dtpngaysinhkh.Text.ToString());
pDiaChiThuongTru = txtdiachickh.Text.Trim();
pEmail = txtemailkh.Text.Trim();
DTO_Customer emp = new DTO_Customer(pMaKH, pHoKH, pTenKH, pGioiTinh, pSDT, pNgaySinh, pDiaChiThuongTru, pEmail);
try
{
int i = new BUS_Customer().AddCustomer(emp);
if (i == -2)
{
throw new Exception();
}
MessageBox.Show(" Bạn đã thêm thành công", " Xác nhận");
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
dgvkh.DataSource = GetCustomer();
}
