public (bool ok, string usrAd, int aaID, string usrSkl, bool usrRrOK, string aaAd) Login(int usrID, string pwd)
{
string ok = "F";
string usrAd = "";
string usrSkl = "";
bool usrRrOK = false;
int aaID = 0;
string aaAd = "";
string sql = "select * from LOGIN(@UsrID, @Pwd)";
LoginResultModel res = new LoginResultModel();
using (IDbConnection connection = new FbConnection(connectionString))
{
res = connection.QueryFirst <LoginResultModel>(sql, new { UsrID = usrID, Pwd = pwd });
//res = connection.QueryFirst<LoginResultModel>(sql, (UsrID: usrID, Pwd: pwd));
}
ok = res.OK;
usrAd = res.UsrAd;
aaID = res.AaID;
usrSkl = res.UsrSkl;
usrRrOK = res.UsrRrOK == 1 ? true : false;
aaAd = res.AaAd;
//ad = $"{res.UsrAd} #{usrID} @{res.AaAd}";
return(ok == "T", usrAd, aaID, usrSkl, usrRrOK, aaAd);
}
public (bool ok, string ad) Login(MyAppStateModel appState)
{
string ok = "F", ad = "";
string sql = "select OK, UsrAd from LOGIN(@UsrID, @Pwd)";
LoginResultModel res = new LoginResultModel();
using (IDbConnection connection = new FbConnection(connectionString))
{
res = connection.QueryFirst <LoginResultModel>(sql, new { UsrID = appState.UsrID, UsrPwd = appState.UsrPwd });
}
ok = res.OK;
ad = res.USRAD;
return(ok == "T", ad);
}
public (bool ok, string ad) Login(int usrID, string pwd)
{
string ok = "F", ad = "";
string sql = "select OK, UsrAd from LOGIN(@UsrID, @Pwd)";
LoginResultModel res = new LoginResultModel();
using (IDbConnection connection = new FbConnection(connectionString))
{
res = connection.QueryFirst <LoginResultModel>(sql, new { UsrID = usrID, Pwd = pwd });
//res = connection.QueryFirst<LoginResultModel>(sql, (UsrID: usrID, Pwd: pwd));
}
ok = res.OK;
ad = res.USRAD;
return(ok == "T", ad);
}
