public bool Xoa(Businessobject.CQuantri obje)
{
try
{
SqlCommand cmd = new SqlCommand("delete from TaiKhoan where TAIKHOAN='" + obje.taikhoan + "'");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{
return(false);
}
}
public bool sua(Businessobject.CQuantri objec)
{
try
{
SqlCommand cmd = new SqlCommand("update TaiKhoan set QUYEN=N'" +
objec.quyen + "' where TAIKHOAN=N'" +
objec.taikhoan + "' and MATKHAU=N'" +
objec.matkhau + "')");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{ }
return(false);
}
//byte[] pass;
//public DataTable insertuser(string tk, string mk,string quyen)
//{
// MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider();
// UTF8Encoding encode = new UTF8Encoding();
// pass = md5.ComputeHash(encode.GetBytes(mk));
// SqlCommand cmd = new SqlCommand("insert into TaiKhoan(TAIKHOAN,MATKHAU,QUYEN)values(N'" + tk + "','" + BitConverter.ToString(pass) + "',N'" + quyen + "')");
// m_ds.ExecuteNoneQuery(cmd);
// return m_ds;
//}
public bool insertuser(Businessobject.CQuantri objec)
{
try
{
SqlCommand cmd = new SqlCommand("insert into TaiKhoan values(N'" +
objec.taikhoan + "',N'" +
objec.matkhau + "',N'" +
objec.quyen + "')");
m_ds.ExecuteNoneQuery(cmd);
return(true);
}
catch
{ }
return(false);
}