public void XoaKhachHang(KhachHangEntity Kh)
{
KetNoiCSDL.MoKetNoi();
string sql = @"DELETE KHACHHANG WHERE Makh=@MaKH";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.Parameters.AddWithValue("@MaKH", Kh.MaKH);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void ThemKhachHang(KhachHangEntity kh)
{
KetNoiCSDL.MoKetNoi();
string sql = @"INSERT INTO KHACHHANG(MaKH, GT, TenKH, DiaChi, SDT, LoaiKH, GhiChu) VALUES(@MaKH,@GT,@TenKH,@DiaChi,@SDT,@LoaiKH,@GhiChu)";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaKH", kh.MaKH);
cmd.Parameters.AddWithValue("@GT", kh.GT);
cmd.Parameters.AddWithValue("@TenKH", kh.TenKH);
cmd.Parameters.AddWithValue("@DiaChi", kh.DiaChi);
cmd.Parameters.AddWithValue("@SDT", kh.SDT);
cmd.Parameters.AddWithValue("@LoaiKH", kh.LoaiKH);
cmd.Parameters.AddWithValue("@GhiChu", kh.GhiChu);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
public void SuaKhachHang(KhachHangEntity kh)
{
KetNoiCSDL.MoKetNoi();
string sql = "UPDATE KHACHHANG SET TenKH =@TenKH, GT =@GT, DiaChi =@DiaChi, SDT =@SDT, LoaiKH =@LoaiKH, GhiChu =@GhiChu";
SqlCommand cmd = new SqlCommand(sql, KetNoiCSDL.connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaKH", kh.MaKH);
cmd.Parameters.AddWithValue("@GT", kh.GT);
cmd.Parameters.AddWithValue("@TenKH", kh.TenKH);
cmd.Parameters.AddWithValue("@DiaChi", kh.DiaChi);
cmd.Parameters.AddWithValue("@SDT", kh.SDT);
cmd.Parameters.AddWithValue("@LoaiKH", kh.LoaiKH);
cmd.Parameters.AddWithValue("@GhiChu", kh.GhiChu);
cmd.ExecuteNonQuery();
KetNoiCSDL.DongKetNoi();
}
