public bool DeleteLoaiKH(LoaiKH ttLoaiKh) { SqlConnection con = new SqlConnection(strQuery); con.Open(); SqlCommand cmd = new SqlCommand("delete from LoaiKhachHang where MaLoaiKH=@idLoaiKH", con); cmd.Parameters.AddWithValue("@idLoaiKH", ttLoaiKh.maLoaiKH); cmd.ExecuteNonQuery(); con.Close(); return(true); }
public void UpdateLoaiKH(LoaiKH ttLoaiKh) { SqlConnection con = new SqlConnection(strQuery); con.Open(); SqlCommand cmd = new SqlCommand("update LoaiKhachHang set SoLuong=@soLuong where MaLoaiKH=@idLoaiKH", con); cmd.Parameters.AddWithValue("@idLoaiKH", ttLoaiKh.maLoaiKH); cmd.Parameters.AddWithValue("@tenLoaiKH", ttLoaiKh.tenLoaiKH); cmd.Parameters.AddWithValue("@soLuong", ttLoaiKh.soLuong); cmd.ExecuteNonQuery(); con.Close(); }
// 7. bang loai khach hang public string InsertLoaiKH(LoaiKH ttLoaiKh) { string Message; SqlConnection con = new SqlConnection(strQuery); con.Open(); SqlCommand cmd = new SqlCommand("insert into LoaiKhachHang(TenLoaiKH,SoLuong) values(@tenLoaiKH,@soLuong)", con); cmd.Parameters.AddWithValue("@tenLoaiKH", ttLoaiKh.tenLoaiKH); cmd.Parameters.AddWithValue("@soLuong", ttLoaiKh.soLuong); int result = cmd.ExecuteNonQuery(); if (result == 1) { Message = ttLoaiKh.tenLoaiKH + " duoc them thanh cong"; } else { Message = ttLoaiKh.tenLoaiKH + " them khong thanh cong"; } con.Close(); return(Message); }