public bool Xoakhachhang(DTO.Khachhang kh)
{
string sql = "UPDATE KHACHHANG SET XOA = 1 WHERE MAKH = @MAKH";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MAKH", SqlDbType.Int).Value = kh.MAKH1;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Themkhachhang(DTO.Khachhang kh)
{
string sql = "INSERT INTO KHACHHANG (TENKH,DIACHI,SDT,TICHDIEM) VALUES (@TENKH,@DIACHI,@SDT,@TICHDIEM)";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@TENKH", SqlDbType.NVarChar).Value = kh.TENKH1;
cmd.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = kh.DIACHI1;
cmd.Parameters.Add("@SDT", SqlDbType.VarChar).Value = kh.SDT1;
cmd.Parameters.Add("@TICHDIEM", SqlDbType.Int).Value = kh.TICHDIEM1;
cmd.ExecuteNonQuery();
con.Close();
}catch (Exception e)
{
return(false);
}
return(true);
}
public bool Suakhachhang(DTO.Khachhang kh)
{
string sql = "UPDATE KHACHHANG SET TENKH=@TENKH, DIACHI=@DIACHI, SDT=@SDT, TICHDIEM=@TICHDIEM WHERE MAKH=@MAKH";
SqlConnection con = dc.getConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MAKH", SqlDbType.Int).Value = kh.MAKH1;
cmd.Parameters.Add("@TENKH", SqlDbType.NVarChar).Value = kh.TENKH1;
cmd.Parameters.Add("@DIACHI", SqlDbType.NVarChar).Value = kh.DIACHI1;
cmd.Parameters.Add("@SDT", SqlDbType.VarChar).Value = kh.SDT1;
cmd.Parameters.Add("@TICHDIEM", SqlDbType.Int).Value = kh.TICHDIEM1;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Xoakhachhang(DTO.Khachhang kh)
{
return(khd.Xoakhachhang(kh));
}
public bool Suakhachhang(DTO.Khachhang kh)
{
return(khd.Suakhachhang(kh));
}
public bool Themkhachhang(DTO.Khachhang kh)
{
return(khd.Themkhachhang(kh));
}
