public bool update_khachhang(khachhang kh)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn.cnt;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = @"update_khachhang";
cmd.Parameters.AddWithValue("@id", kh.id);
cmd.Parameters.AddWithValue("@ten", kh.name_kh);
cmd.Parameters.AddWithValue("@gioitinh", kh.gioitinh);
cmd.Parameters.AddWithValue("@ngaysinh", kh.ngaysinh);
cmd.Parameters.AddWithValue("@diachi", kh.quequan);
cmd.Parameters.AddWithValue("@phone", kh.sdt);
cmd.Parameters.AddWithValue("@card", kh.sothe);
cn.cnt.Open();
int kp = cmd.ExecuteNonQuery();
if (kp > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable seach_khachhang_diachi(khachhang kh)
{
DataTable dttb = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn.cnt;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = @"seach_khachhang_diachi";
cmd.Parameters.AddWithValue("@diachi", kh.quequan);
SqlDataAdapter adt = new SqlDataAdapter(cmd);
adt.Fill(dttb);
return(dttb);
}
public bool delete_khachhang(khachhang kh)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn.cnt;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = @"delete_khachhang";
cmd.Parameters.AddWithValue("@id", kh.id);
cn.cnt.Open();
int kp = cmd.ExecuteNonQuery();
if (kp > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable seach_khachhang(khachhang kh)
{
DataTable dttb = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn.cnt;
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", kh.name_kh);
cmd.CommandText = @"seach_khachhang";
SqlDataAdapter adt = new SqlDataAdapter(cmd);
adt.Fill(dttb);
}
catch (Exception)
{
}
return(dttb);
}