Пример #1
0
        /// <summary>
        /// Creates a new ClimateNorm record using async
        /// </summary>
        public static async Task CreateAsync(ClimateNormDO DO)
        {
            SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
            SqlParameter _AveragePrecipitationWinter = new SqlParameter("AveragePrecipitationWinter", SqlDbType.Decimal);
            SqlParameter _AveragePrecipitationSpring = new SqlParameter("AveragePrecipitationSpring", SqlDbType.Decimal);
            SqlParameter _AveragePrecipitationSummer = new SqlParameter("AveragePrecipitationSummer", SqlDbType.Decimal);
            SqlParameter _AveragePrecipitationFall = new SqlParameter("AveragePrecipitationFall", SqlDbType.Decimal);
            SqlParameter _SeasonalTemperatureRangeWinter = new SqlParameter("SeasonalTemperatureRangeWinter", SqlDbType.Decimal);
            SqlParameter _SeasonalTemperatureRangeSpring = new SqlParameter("SeasonalTemperatureRangeSpring", SqlDbType.Decimal);
            SqlParameter _SeasonalTemperatureRangeSummer = new SqlParameter("SeasonalTemperatureRangeSummer", SqlDbType.Decimal);
            SqlParameter _SeasonalTemperatureRangeFall = new SqlParameter("SeasonalTemperatureRangeFall", SqlDbType.Decimal);
            
            _PermitKey.Value = DO.PermitKey;
            _AveragePrecipitationWinter.Value = DO.AveragePrecipitationWinter;
            _AveragePrecipitationSpring.Value = DO.AveragePrecipitationSpring;
            _AveragePrecipitationSummer.Value = DO.AveragePrecipitationSummer;
            _AveragePrecipitationFall.Value = DO.AveragePrecipitationFall;
            _SeasonalTemperatureRangeWinter.Value = DO.SeasonalTemperatureRangeWinter;
            _SeasonalTemperatureRangeSpring.Value = DO.SeasonalTemperatureRangeSpring;
            _SeasonalTemperatureRangeSummer.Value = DO.SeasonalTemperatureRangeSummer;
            _SeasonalTemperatureRangeFall.Value = DO.SeasonalTemperatureRangeFall;
            
            SqlParameter[] _params = new SqlParameter[] {
                _PermitKey,
                _AveragePrecipitationWinter,
                _AveragePrecipitationSpring,
                _AveragePrecipitationSummer,
                _AveragePrecipitationFall,
                _SeasonalTemperatureRangeWinter,
                _SeasonalTemperatureRangeSpring,
                _SeasonalTemperatureRangeSummer,
                _SeasonalTemperatureRangeFall
            };

            string pid = ConfigurationManager.AppSettings["ePermitDAL"];

            await DataCommon.ExecuteNonQueryAsync("[dbo].[ClimateNorm_Insert]", _params, pid);
            
        }
Пример #2
0
        public ClimatologicalDataBO WriteDataToTables(int PermitKey)
        {
            ClimatologicalDataBO data = new ClimatologicalDataBO();

            data.AverageWindDirection = this.AverageWindDirection;
            data.AverageWindVelocity = this.AverageWindVelocity;
            data.PermitKey = PermitKey;

            if (data.ClimateNorm == null)
            {
                ClimateNormDO NewClimateDO = new ClimateNormDO();
                NewClimateDO.PermitKey = PermitKey;
                data.ClimateNorm = NewClimateDO;
            }

                data.ClimateNorm.AveragePrecipitationFall = this.AveragePrecipitationFall;
                data.ClimateNorm.AveragePrecipitationWinter = this.AveragePrecipitationWinter;
                data.ClimateNorm.AveragePrecipitationSpring = this.AveragePrecipitationSpring;
                data.ClimateNorm.AveragePrecipitationSummer = this.AveragePrecipitationSummer;
                data.ClimateNorm.SeasonalTemperatureRangeFall = this.SeasonalTemperatureRangeFall;
                data.ClimateNorm.SeasonalTemperatureRangeWinter = this.SeasonalTemperatureRangeWinter;
                data.ClimateNorm.SeasonalTemperatureRangeSpring = this.SeasonalTemperatureRangeSpring;
                data.ClimateNorm.SeasonalTemperatureRangeSummer = this.SeasonalTemperatureRangeSummer;

            return data;
        }
Пример #3
0
        /// <summary>
        /// Gets all ClimateNorm records
        /// </summary>
        public static ClimateNormDO[] GetAll()
        {

            string pid = ConfigurationManager.AppSettings["ePermitDAL"];

            SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ClimateNorm_GetAll]", new SqlParameter[] { }, pid);
            
            List<ClimateNormDO> objs = new List<ClimateNormDO>();
            
            while(sr.Read()){

                ClimateNormDO obj = new ClimateNormDO();
                
                obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
                obj.AveragePrecipitationWinter = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationWinter"));
                obj.AveragePrecipitationSpring = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationSpring"));
                obj.AveragePrecipitationSummer = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationSummer"));
                obj.AveragePrecipitationFall = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationFall"));
                obj.SeasonalTemperatureRangeWinter = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeWinter"));
                obj.SeasonalTemperatureRangeSpring = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeSpring"));
                obj.SeasonalTemperatureRangeSummer = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeSummer"));
                obj.SeasonalTemperatureRangeFall = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeFall"));
                


                objs.Add(obj);
            }

            return objs.ToArray();
        }
Пример #4
0
        /// <summary>
        /// Selects ClimateNorm records by PK
        /// </summary>
        public static async Task<ClimateNormDO[]> GetByPKAsync(Int32 PermitKey)
        {

            SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
			
            _PermitKey.Value = PermitKey;
			
            SqlParameter[] _params = new SqlParameter[] {
                _PermitKey
            };

            string pid = ConfigurationManager.AppSettings["ePermitDAL"];

            SafeReader sr = await DataCommon.ExecuteSafeReaderAsync("[dbo].[ClimateNorm_GetByPK]", _params, pid);


            List<ClimateNormDO> objs = new List<ClimateNormDO>();
			
            while(sr.Read())
            {
                ClimateNormDO obj = new ClimateNormDO();
				
                obj.PermitKey = sr.GetInt32(sr.GetOrdinal("PermitKey"));
                obj.AveragePrecipitationWinter = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationWinter"));
                obj.AveragePrecipitationSpring = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationSpring"));
                obj.AveragePrecipitationSummer = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationSummer"));
                obj.AveragePrecipitationFall = sr.GetDecimal(sr.GetOrdinal("AveragePrecipitationFall"));
                obj.SeasonalTemperatureRangeWinter = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeWinter"));
                obj.SeasonalTemperatureRangeSpring = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeSpring"));
                obj.SeasonalTemperatureRangeSummer = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeSummer"));
                obj.SeasonalTemperatureRangeFall = sr.GetDecimal(sr.GetOrdinal("SeasonalTemperatureRangeFall"));
                

                objs.Add(obj);
            }

            return objs.ToArray();
        }
Пример #5
0
        /// <summary>
        /// Deletes a ClimateNorm record
        /// </summary>
        public static async Task<int> DeleteAsync(ClimateNormDO DO)
        {
            SqlParameter _PermitKey = new SqlParameter("PermitKey", SqlDbType.Int);
            
            _PermitKey.Value = DO.PermitKey;
            
            SqlParameter[] _params = new SqlParameter[] {
                _PermitKey
            };

            string pid = ConfigurationManager.AppSettings["ePermitDAL"];

            return await DataCommon.ExecuteScalarAsync("[dbo].[ClimateNorm_Delete]", _params, pid);
        }