Ejemplo n.º 1
0
        public static void DimDateInitializer(int startDate)
        {
            //010115

            DateTime date = DateTimeHelper.ConvertToDateTime(startDate);
            List<DateTime> datesToInsert = new List<DateTime>();

            while (date.Year <= DateTime.Now.Year) {
                Console.WriteLine(date.ToString());
                datesToInsert.Add(date);
                date = date.AddDays(1);
            }

            //220101
            //22 01 2001
            DBController dbc = new DBController();
            foreach (DateTime dateToInsert in datesToInsert) {
                dbc.AddDimDate(dateToInsert);
            }
            dbc.Close();
        }