Exemplo n.º 1
0
        /*/// <summary>
         * /// The process tariffs async.
         * /// </summary>
         * /// <param name="tariffs">
         * /// The tariffs.
         * /// </param>
         * /// <param name="fileName">
         * /// The file name.
         * /// </param>
         * /// <param name="tariffAction">
         * /// The tariff Action.
         * /// </param>
         * private static async Task ProcessTariffsAsync(
         *  IQueryable<Tariff> tariffs,
         *  string fileName,
         *  TariffAction tariffAction)
         * {
         *  Process(tariffs, fileName, tariffAction)
         * // await Task.Run(() => Process(tariffs, fileName, tariffAction));
         * }*/

        /// <summary>
        /// Processes the specified tariffs.
        /// </summary>
        /// <param name="tariffs">
        /// The tariffs.
        /// </param>
        /// <param name="fileName">
        /// Name of the file.
        /// </param>
        /// <param name="tariffAction">
        /// The tariff action.
        /// </param>
        /// <param name="dataAccessHelper">
        /// The data access helper.
        /// </param>
        /// <param name="startYearAndMonth">
        /// The start year and month.
        /// </param>
        private static void Process(
            IQueryable <Tariff> tariffs,
            string fileName,
            TariffAction tariffAction,
            TariffsDataAccessHelper dataAccessHelper,
            string startYearAndMonth)
        {
            if (!tariffs.Any())
            {
                return;
            }

            if (string.IsNullOrEmpty(fileName))
            {
                return;
            }

            switch (tariffAction)
            {
            case TariffAction.Compare:
                CompareTariffs(fileName, tariffs, dataAccessHelper, startYearAndMonth);
                break;

            case TariffAction.GenerateScript:
                CreateTariffScript(fileName, tariffs, startYearAndMonth);
                break;
            }
        }
 /// <summary>
 /// The get tariffs.
 /// </summary>
 /// <param name="startYearAndMonth">
 /// The start Year And Month.
 /// </param>
 /// <param name="fileName">
 /// The file Name.
 /// </param>
 /// <param name="tariffAction">
 /// The tariff Action.
 /// </param>
 public static void ProcessTariffs(string startYearAndMonth, string fileName, TariffAction tariffAction)
 {
     using (var dataAccessHelper = new TariffsDataAccessHelper())
     {
         var tariffs = dataAccessHelper.GetTariff(startYearAndMonth, fileName, tariffAction);
         Process(tariffs, fileName, tariffAction, dataAccessHelper, startYearAndMonth);
     }
 }
Exemplo n.º 3
0
 /// <summary>
 /// The get tariffs.
 /// </summary>
 /// <param name="startYearAndMonth">
 /// The start Year And Month.
 /// </param>
 /// <param name="fileName">
 /// The file Name.
 /// </param>
 /// <param name="tariffAction">
 /// The tariff Action.
 /// </param>
 public static void ProcessTariffs(string startYearAndMonth, string fileName, TariffAction tariffAction)
 {
     using (var dataAccessHelper = new TariffsDataAccessHelper())
     {
         var tariffs = dataAccessHelper.GetTariff(startYearAndMonth, fileName, tariffAction);
         Process(tariffs, fileName, tariffAction, dataAccessHelper, startYearAndMonth);
     }
 }
        /// <summary>
        /// Gets the tariff.
        /// </summary>
        /// <param name="startYearAndMonth">The start year and month.</param>
        /// <param name="fileName">Name of the file.</param>
        /// <param name="tariffAction">The tariff action.</param>
        /// <returns></returns>
        public IQueryable<Tariff> GetTariff(string startYearAndMonth, string fileName, TariffAction tariffAction)
        {
            this.entities = new UmehlukoEntities1();

            var startDate = DateTime.ParseExact(startYearAndMonth, Constant.DateFormat, null);

            return from tariff in this.entities.Tariffs
                   where tariff.ValidFrom == startDate && tariff.TariffTypeID == Constant.CoidTariffTypeId
                   select tariff;
        }
        /*/// <summary>
        /// The process tariffs async.
        /// </summary>
        /// <param name="tariffs">
        /// The tariffs.
        /// </param>
        /// <param name="fileName">
        /// The file name.
        /// </param>
        /// <param name="tariffAction">
        /// The tariff Action.
        /// </param>
        private static async Task ProcessTariffsAsync(
            IQueryable<Tariff> tariffs, 
            string fileName, 
            TariffAction tariffAction)
        {
            Process(tariffs, fileName, tariffAction)
          // await Task.Run(() => Process(tariffs, fileName, tariffAction));
        }*/

        /// <summary>
        /// Processes the specified tariffs.
        /// </summary>
        /// <param name="tariffs">
        /// The tariffs.
        /// </param>
        /// <param name="fileName">
        /// Name of the file.
        /// </param>
        /// <param name="tariffAction">
        /// The tariff action.
        /// </param>
        /// <param name="dataAccessHelper">
        /// The data access helper.
        /// </param>
        /// <param name="startYearAndMonth">
        /// The start year and month.
        /// </param>
        private static void Process(
            IQueryable<Tariff> tariffs, 
            string fileName, 
            TariffAction tariffAction, 
            TariffsDataAccessHelper dataAccessHelper, 
            string startYearAndMonth)
        {
            if (!tariffs.Any())
            {
                return;
            }

            if (string.IsNullOrEmpty(fileName))
            {
                return;
            }

            switch (tariffAction)
            {
                case TariffAction.Compare:
                    CompareTariffs(fileName, tariffs, dataAccessHelper, startYearAndMonth);
                    break;
                case TariffAction.GenerateScript:
                    CreateTariffScript(fileName, tariffs, startYearAndMonth);
                    break;
            }
        }
Exemplo n.º 6
0
        /// <summary>
        /// Gets the tariff.
        /// </summary>
        /// <param name="startYearAndMonth">The start year and month.</param>
        /// <param name="fileName">Name of the file.</param>
        /// <param name="tariffAction">The tariff action.</param>
        /// <returns></returns>
        public IQueryable <Tariff> GetTariff(string startYearAndMonth, string fileName, TariffAction tariffAction)
        {
            this.entities = new UmehlukoEntities1();

            var startDate = DateTime.ParseExact(startYearAndMonth, Constant.DateFormat, null);

            return(from tariff in this.entities.Tariffs
                   where tariff.ValidFrom == startDate && tariff.TariffTypeID == Constant.CoidTariffTypeId
                   select tariff);
        }