public StoreUserModel getUserByUserAndPass(string user, string pass) { var conn = this._database.getConnection(); try { Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("user", user); parameters.Add("pass", pass); var reader = this._database.Execute("select id, username, pass from store_user where username = :user and pass = :pass", parameters, conn); if (reader != null && reader.Read()) { StoreUserModel userInstance = new StoreUserModel(reader.GetInt32(0), reader.GetString(1), reader.GetString(2)); reader.Dispose(); return(userInstance); } } catch (Exception e) { } finally { this._database.closeConnection(conn); } return(null); }
public void OnPost() { StoreUserModel user = this._userMapper.getUserByUserAndPass(this.Username, this.Password); }