public bool DeleteHanhkhach(DTO.Hanhkhach hk)
{
string sql = "DELETE HANHKHACH WHERE MAHK = @MAHK";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MAHK", SqlDbType.VarChar).Value = hk.mahk;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool InsertHanhkhach(DTO.Hanhkhach hk)
{
string sql = "INSERT INTO HANHKHACH(MAHK, TENHK, CMND, SDT) VALUES(@MAHK, @TENHK,@CMND,@SDT)";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MAHK", SqlDbType.VarChar).Value = TaoMaKhachHang();
cmd.Parameters.Add("@TENHK", SqlDbType.NVarChar).Value = hk.tenhk;
cmd.Parameters.Add("@CMND", SqlDbType.NVarChar).Value = hk.cmnd;
cmd.Parameters.Add("@SDT", SqlDbType.NVarChar).Value = hk.sdt;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool UpdateHanhkhach(DTO.Hanhkhach hk)
{
string sql = "UPDATE HANHKHACH SET TENHK=@TENHK, CMND=@CMND, SDT=@SDT WHERE MAHK=@MAHK";
SqlConnection con = dc.GetConnect();
try
{
cmd = new SqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("@MAHK", SqlDbType.VarChar).Value = hk.mahk;
cmd.Parameters.Add("@TENHK", SqlDbType.NVarChar).Value = hk.tenhk;
cmd.Parameters.Add("@CMND", SqlDbType.NVarChar).Value = hk.tenhk;
cmd.Parameters.Add("@SDT", SqlDbType.NVarChar).Value = hk.tenhk;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
return(false);
}
return(true);
}
public bool Delete(DTO.Hanhkhach hk)
{
return(dal.DeleteHanhkhach(hk));
}
public bool Update(DTO.Hanhkhach hk)
{
return(dal.UpdateHanhkhach(hk));
}
public bool InsertHanhkhach(DTO.Hanhkhach hk)
{
return(dal.InsertHanhkhach(hk));
}
