public static bool update_database(string ten, string diachi, string sdt, string email, string chucvu, int tuoi)
{
try
{
Class.clsDatabase cls = new QuanLyThuVien.Class.clsDatabase();
cls.KetNoi();
string strUpdate = "update tblNhanVien set TENNV='" + ten + "',DIACHI='" + diachi + "',DIENTHOAI='" + sdt + "',EMAIL='" + email + "',ChucVu='" + chucvu + "',Tuoi='" + tuoi + "' where TAIKHOAN='an'";
cls.ThucThiSQLTheoKetNoi(strUpdate);
//cls.ThucThiSQLTheoPKN("delete tblNhanVien where id = '" + id+"'");
return(true);
}
catch { Exception ex;
return(false); };
}
public static string check_TaoTaiKhoan(string id, string pass, string confpass)
{
if (id.Length - 1 < 5)
{
return("Id too short");
}
else
if (id.Length - 1 > 30)
{
return("Id too long");
}
else
if (pass.Length - 1 < 5)
{
return("Pass too short");
}
else
if (pass.Length - 1 > 30)
{
return("Pass too long");
}
else
if (pass != confpass)
{
return("Pass not same");
}
else
{
try
{
Class.clsDatabase cls = new QuanLyThuVien.Class.clsDatabase();
cls.KetNoi();
cls.ThucThiSQLTheoPKN("insert into tblNhanVien(TAIKHOAN,MATKHAU,QUYENHAN)values('" + id + "','" + pass + "','user')");
//cls.ThucThiSQLTheoPKN("delete tblNhanVien where id = '" + id+"'");
return("0");
}
catch { return("Existed account"); }
}
}