public bool ThaoTacVoiDoiTuongTheKhachHang(clsTheKhachHang TKH, string command)
{
SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi();
string query = "";
if (command == "Add")
{
query = "INSERT INTO TheKhachHang(ma_the, ma_khach_hang, ma_loai_the, ngay_dang_ky, trang_thai) VALUES(@ma_the, @ma_khach_hang, @ma_loai_the, @ngay_dang_ky, @trang_thai)";
}
else if (command == "Update")
{
query = "UPDATE TheKhachHang SET ma_khach_hang = @ma_khach_hang, ma_loai_the = @ma_loai_the, ngay_dang_ky = @ngay_dang_ky, trang_thai = @trang_thai WHERE ma_the = @ma_the";
}
SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con);
if (command == "Add" || command == "Update")
{
cmd.Parameters.AddWithValue("@ma_the", TKH.MaThe);
cmd.Parameters.AddWithValue("@ma_khach_hang", TKH.MaKhachHang);
cmd.Parameters.AddWithValue("@ma_loai_the", TKH.MaLoaiThe);
cmd.Parameters.AddWithValue("@ngay_dang_ky", TKH.NgayDangKy);
cmd.Parameters.AddWithValue("@trang_thai", TKH.TrangThai);
}
return(cmd.ExecuteNonQuery() > 0);
}
public clsTheKhachHang TaoDoiThuongTheKhachHang(string maThe, string maKH, string maLoaiThe, DateTime ngayDK, bool trangThai)
{
clsTheKhachHang theKH = new clsTheKhachHang();
theKH.MaThe = maThe;
theKH.MaKhachHang = maKH;
theKH.MaLoaiThe = maLoaiThe;
theKH.NgayDangKy = ngayDK;
theKH.TrangThai = trangThai;
return(theKH);
}
private clsTheKhachHang TaoDoiTuongTheKhachHang(bool trangThai)
{
clsTheKhachHang theKH = new clsTheKhachHang();
DataGridViewRow r = dgvDSTheKH.SelectedRows[0];
theKH.MaThe = r.Cells[0].Value.ToString();
theKH.MaKhachHang = r.Cells[1].Value.ToString();
theKH.MaLoaiThe = r.Cells[2].Value.ToString();
theKH.NgayDangKy = DateTime.Parse(r.Cells[3].Value.ToString());
theKH.TrangThai = trangThai;
return(theKH);
}
private void btnMoThe_Click(object sender, EventArgs e)
{
if (DialogResult.Yes == MessageBox.Show("Mở thẻ khách hàng", "Xác nhận mở thẻ", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
clsTheKhachHang TheKH = TaoDoiTuongTheKhachHang(true);
TheKhachHang_BUS bus = new TheKhachHang_BUS();
if (bus.ThaoTacVoiDoiTuongTheKhachHang(TheKH, "Update"))
{
HienThiDSTheKhachHang("", "");
TrangThaiBanDau();
}
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (KiemTraDuLieuHopLe())
{
string strThongBao = "Thêm khách hàng " + txtHoTen.Text;
MessageBoxButtons MBButton = MessageBoxButtons.OK;
MessageBoxIcon MBIcon = MessageBoxIcon.Question;
if (strWarning != "")
{
strThongBao = strWarning += "\n Vẫn muốn tiếp tục";
MBButton = MessageBoxButtons.YesNo;
MBIcon = MessageBoxIcon.Warning;
}
if (DialogResult.Yes == MessageBox.Show(strThongBao, "Xác nhận thêm", MBButton, MBIcon))
{
TheKhachHang_BUS theKH_bus = new TheKhachHang_BUS();
clsTheKhachHang theKH = TaoDoiTuongTheKhachHang();
KhachHang_BUS KH_bus = new KhachHang_BUS();
clsKhachHang_DTO KH = TaoDoiTuongKhachHang();
try
{
if (KH_bus.ThaoTacVoiKhachHang(KH, "Add") && theKH_bus.ThaoTacVoiDoiTuongTheKhachHang(theKH, "Add"))
{
//MessageBox.Show("Đã thêm khách hàng " + KH.TenKhachHang);
TrangThaiBanDau();
TuPhatSinhMaKhachHang();
}
}
catch (Exception) {}
}
//else
//{
// //MessageBox.Show("Hủy thao tác");
//}
}
else
{
MessageBox.Show(strError, "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
strError = "";
strWarning = "";
}
public List <clsTheKhachHang> LayDanhSachTheKHH(string maThe, string tenKH)
{
List <clsTheKhachHang> lstTheKH = new List <clsTheKhachHang>();
SqlConnection con = ThaoTacDuLieu_DAO.TaoKetNoi();
string query = string.Format("SELECT ma_the, TheKhachHang.ma_khach_hang, TheKhachHang.ma_loai_the, ngay_dang_ky, TheKhachHang.trang_thai FROM TheKhachHang, KhachHang WHERE TheKhachHang.ma_khach_hang = KhachHang.ma_khach_hang AND KhachHang.trang_thai != 'false' AND (ma_the LIKE '%{0}%' OR ten_khach_hang LIKE N'%{1}%')", maThe, tenKH);
//if(tenKH != "-1")
// query += string.Format(" OR ten_khach_hang LIKE N'%{0}%'", tenKH);
//AND KhachHang.trang_thai != 'false'
//string query = "SELECT * FROM TheKhachHang";
SqlCommand cmd = ThaoTacDuLieu_DAO.TruyVan(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
clsTheKhachHang theKH = new clsTheKhachHang();
if (!reader.IsDBNull(0))
{
theKH.MaThe = (string)reader[0];
}
if (!reader.IsDBNull(1))
{
theKH.MaKhachHang = (string)reader[1];
}
if (!reader.IsDBNull(2))
{
theKH.MaLoaiThe = (string)reader[2];
}
if (!reader.IsDBNull(3))
{
theKH.NgayDangKy = (DateTime)reader[3];
}
if (!reader.IsDBNull(4))
{
theKH.TrangThai = (bool)reader[4];
}
lstTheKH.Add(theKH);
}
return(lstTheKH);
}
public bool ThaoTacVoiDoiTuongTheKhachHang(clsTheKhachHang TKH, string command)
{
TheKhachHang_DAO dao = new TheKhachHang_DAO();
return(dao.ThaoTacVoiDoiTuongTheKhachHang(TKH, command));
}
