Пример #1
0
        public bool ExecProc_InsertStandardAccount(SP_InsertStandardAccount_Params standardAccount)
        {
            string procName = "SP_InsertStandardAccount";
            SP_InsertStandardAccount_Params sa = standardAccount;
            DynamicParameters parameters       = new DynamicParameters();

            parameters.Add("@UserID", sa.UserID, DbType.String, ParameterDirection.Input);
            parameters.Add("@DisplayName", sa.DisplayName, DbType.String, ParameterDirection.Input);
            parameters.Add("@LastLoginTime", sa.LastLoginTime, DbType.DateTime, ParameterDirection.Input);
            parameters.Add("@LastLoginIP", sa.LastLoginIP, DbType.String, ParameterDirection.Input);
            parameters.Add("@PasswordHash", sa.PasswordHash, DbType.String, ParameterDirection.Input);
            parameters.Add("@RoleID", sa.RoleID, DbType.Int32, ParameterDirection.Input);
            parameters.Add("@ExpiryTime", sa.ExpiryTime, DbType.DateTime, ParameterDirection.Input);
            parameters.Add("@ReturnValue", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);
            _ = base.ExecProcedure <int>(procName, parameters);
            int returnValue = parameters.Get <int>("@ReturnValue");

            return(returnValue == 1);
        }
Пример #2
0
 public bool InsertStandardAccount(SP_InsertStandardAccount_Params standardAccount)
 {
     return(Repository.ExecProc_InsertStandardAccount(standardAccount));
 }