コード例 #1
0
        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);
        }
コード例 #2
0
 public void OnPost()
 {
     StoreUserModel user = this._userMapper.getUserByUserAndPass(this.Username, this.Password);
 }