Example #1
0
        /*
         *  Input:   String file name, SolarContext database
         *  Output:  None
         *  Desc:    Reads weather sensor data from file_name into database
         */
        static void ReadInWeatherSensorData(string file_in, SolarContext context)
        {
            try
            {
                using (var reader = new StreamReader("Data/" + file_in))
                {
                    string line;
                    bool   firstRun = true;
                    System.Diagnostics.Debug.WriteLine("Seeding Database with " + file_in);

                    reader.ReadLine(); //First line is human stuff

                    while ((line = reader.ReadLine()) != null)
                    {
                        var values = line.Split(',');

                        if (firstRun)
                        {
                            AddPlantNumber(values[1], context);
                            firstRun = false;
                        }

                        /*
                         * WeatherReading {
                         *  PK int WeatherReadingID, auto increment
                         *  DateTime DateAndTime,
                         *  double AmbientTemp,
                         *  double ModuleTemp,
                         *  double Irradiation }
                         */

                        DateTime dateTime = DateTime.Parse(values[0]);
                        int      plantNum = int.Parse(values[1]);
                        double   aTemp    = double.Parse(values[3]);
                        double   mTemp    = double.Parse(values[4]);
                        double   irrid    = double.Parse(values[5]);

                        WeatherReading r = new WeatherReading()
                        {
                            DateAndTime = dateTime,
                            PlantNumber = plantNum,
                            AmbientTemp = aTemp,
                            ModuleTemp  = mTemp,
                            Irradiation = irrid
                        };

                        context.WeatherReadings.Add(r);
                    }
                    context.SaveChanges();
                    System.Diagnostics.Debug.WriteLine("Finished successfully.");
                }
            }
            catch (Exception e)
            {
                System.Diagnostics.Debug.WriteLine("Error reading from file '" + file_in + "': " + e.Message);
            }
        }
Example #2
0
        /*
         *  Input:   SolarContext database
         *  Output:  None
         *  Desc:    Scans all weather readings in the database looking for missing records based on date
         */
        static void addMissingWeather(SolarContext context)
        {
            int      plant1       = 4135001;
            int      plant2       = 4136001;
            DateTime firstDate    = DateTime.Parse("05-15-2020 00:00");
            DateTime lastDate     = DateTime.Parse("06-17-2020 23:45");
            int      recordsAdded = 0;

            //Search for missing date values in weather table
            List <WeatherReading> readings5001 = context.WeatherReadings.Where(wr => wr.PlantNumber == 4135001).OrderBy(wr => wr.DateAndTime).ToList();
            List <WeatherReading> readings6001 = context.WeatherReadings.Where(wr => wr.PlantNumber == 4136001).OrderBy(wr => wr.DateAndTime).ToList();

            System.Diagnostics.Debug.WriteLine((readings5001.Count + readings6001.Count) + " weather records found. Scanning for missing records.");

            DateTime currDate  = firstDate;
            int      index5001 = 0;
            int      index6001 = 0;



            while (currDate != lastDate)
            {
                if (index5001 > readings5001.Count)  //List doesnt include readings to end of date
                {
                    WeatherReading r = new WeatherReading()
                    {
                        DateAndTime = currDate,
                        PlantNumber = plant1,
                        AmbientTemp = -1,
                        ModuleTemp  = -1,
                        Irradiation = -1
                    };
                    context.WeatherReadings.Add(r);
                    recordsAdded++;
                }
                else if (currDate != readings5001[index5001].DateAndTime) //List missing readings in middle
                {
                    WeatherReading r = new WeatherReading()
                    {
                        DateAndTime = currDate,
                        PlantNumber = plant1,
                        AmbientTemp = -1,
                        ModuleTemp  = -1,
                        Irradiation = -1
                    };
                    context.WeatherReadings.Add(r);
                    recordsAdded++;
                }
                else
                {
                    index5001++;                    //Continue
                }
                if (index6001 > readings6001.Count) //List doesnt include readings to end of date
                {
                    WeatherReading r = new WeatherReading()
                    {
                        DateAndTime = currDate,
                        PlantNumber = plant2,
                        AmbientTemp = -1,
                        ModuleTemp  = -1,
                        Irradiation = -1
                    };
                    context.WeatherReadings.Add(r);
                    recordsAdded++;
                }
                else if (currDate != readings6001[index6001].DateAndTime) //List missing readings in middle
                {
                    WeatherReading r = new WeatherReading()
                    {
                        DateAndTime = currDate,
                        PlantNumber = plant2,
                        AmbientTemp = -1,
                        ModuleTemp  = -1,
                        Irradiation = -1
                    };
                    context.WeatherReadings.Add(r);
                    recordsAdded++;
                }
                else
                {
                    index6001++;                    //Continue
                }
                currDate = currDate.AddMinutes(15); //I don't know why this has to return a DateTime
            }
            //Search for missing date values in weather table
            context.SaveChanges();
            int count = context.WeatherReadings.Count();

            System.Diagnostics.Debug.WriteLine(recordsAdded + " records were added. " + count + " total records");
        }