Ejemplo n.º 1
0
        private async Task PostTracking <T>(TrackingPostParameter <T> parameter) where T : new()
        {
            var procAttr = SqlMapperEx.GetStoredProcedureAttribute <T>();
            var mapping  = SqlMapperEx.GetMapping <T>();

            var sqlParameters = new DynamicParameters();

            foreach (var pair in mapping)
            {
                var propName = pair.Key;
                var sqlName  = pair.Value;

                var value = typeof(T).GetProperty(propName).GetValue(parameter.Data, null);
                // parameters.Add("@newId", DbType.Int32, direction: ParameterDirection.Output);
                if (sqlName == procAttr.KeyColumnName)
                {
                    sqlParameters.Add(sqlName, value, direction: ParameterDirection.InputOutput);
                }
                else
                {
                    sqlParameters.Add(sqlName, value);
                }
            }

            sqlParameters.Add("Action", 16);
            sqlParameters.Add("LanguageID", parameter.Language);

            using (var connection = new SqlConnection(ConnectionString))
            {
                await connection.ExecuteScalarAsync(procAttr.PostProcedureName, sqlParameters, commandType : CommandType.StoredProcedure);
            }
        }
Ejemplo n.º 2
0
        private async Task <IEnumerable <T> > GetGridItems <T>(GridParameter parameter, Dictionary <string, object> extraParameters = null)
        {
            var procAttr = SqlMapperEx.GetStoredProcedureAttribute <T>();

            var sqlParameters = new DynamicParameters();

            sqlParameters.Add(procAttr.KeyColumnName, parameter.Id);
            sqlParameters.Add("LanguageID", parameter.Language);

            if (extraParameters != null)
            {
                foreach (var pair in extraParameters)
                {
                    sqlParameters.Add(pair.Key, pair.Value);
                }
            }

            using (var connection = new SqlConnection(ConnectionString))
            {
                var result = await connection.QueryAsync <T>(procAttr.GetProcedureName,
                                                             sqlParameters,
                                                             commandType : CommandType.StoredProcedure);

                return(result);
            }
        }
Ejemplo n.º 3
0
        private async Task <T> GetTracking <T>(TrackingParameter parameter)
        {
            var procAttr = SqlMapperEx.GetStoredProcedureAttribute <T>();

            var sqlParameters = new DynamicParameters();

            sqlParameters.Add(procAttr.KeyColumnName, parameter.Id);
            sqlParameters.Add("LanguageID", parameter.Language);

            using (var connection = new SqlConnection(ConnectionString))
            {
                var result = await connection.QueryMultipleAsync(procAttr.GetProcedureName,
                                                                 sqlParameters,
                                                                 commandType : CommandType.StoredProcedure);

                var tracking = result.ReadSingleOrDefault <T>();
                //todo: implement reading of custom fields
                //var customFields = result.Read();
                return(tracking);
            }
        }