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); }