public static string check_db_ThongTinMuon(string madg, string masach, string sophieumuon, string ngaymuon, string ngaytra, string xacnhan, string ghichu, string temp)
{
try
{
Class.clsDatabase cls = new QuanLyThuVien.Class.clsDatabase();
string strInsert = "Insert Into tblMuon(MADG,MASACH,SOPHIEUMUON,NGAYMUON,NGAYTRA,XACNHANTRA,GHICHU) values ('" + madg + "','" + masach + "','" + sophieumuon + "','" + ngaymuon + "','" + ngaytra + "','" + xacnhan + "','" + ghichu + "')";
cls.ThucThiSQLTheoPKN(strInsert);
return("0");
}
catch { Exception ex; return("Trùng mã phiếu mượn"); };
}
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"); }
}
}