public void SuaTaiKhoan(DangKy1 dk)
{
dal.SuaTaiKhoan(dk);
}
public void SuaTaiKhoan(DangKy1 dk)
{
string sql = "update DANGKY set QUYEN=N'" + dk.Quyen + "', TENDANGNHAP='" + dk.TenDN + "', PASSWORD='******', REPASSWORD='******', EMAIL='" + dk.Email + "', GIOITINH=N'" + dk.GioiTinh + "', NGAYSINH='" + dk.NgaySinh + "', DIACHI=N'" + dk.DiaChi + "', SODIENTHOAI=" + dk.SDT + " where IDTAIKHOAN=" + dk.IDTaiKhoan + "";
dah.ThucThi(sql);
}
//public int TongSoTaiKhoan()
//{
// int tongsotk = 0;
// DataTable dt = new DataTable();
// dt = dal.LoadDuLieu();
// tongsotk = dt.Rows.Count;
// return tongsotk;
//}
public void ThemTaiKhoan(DangKy1 dk)
{
dal.ThemTaiKhoan(dk);
}
public void ThemTaiKhoan(DangKy1 dk)
{
string sql = "insert into DANGKY values (N'" + dk.Quyen + "','" + dk.TenDN + "','" + dk.Pass + "','" + dk.Repass + "','" + dk.Email + "',N'" + dk.GioiTinh + "','" + dk.NgaySinh + "',N'" + dk.DiaChi + "'," + dk.SDT + ")";
dah.ThucThi(sql);
}
