Esempio n. 1
0
        public void AddPowerGridView(Building building, DateTime timeStamp)
        {
            rnd = new Random();

            int[] modbusBaseAddress = new int[] { 2, 5, 6, 4, 3, 8, 7 };


            int number = rnd.Next(0, building.powerScout.Count - 1);
            AzurePowerGridModel azurePowerGridModel = new AzurePowerGridModel();

            using (SqlConnection sqlConnection = new SqlConnection(ConfigurationSetting.ConnectionString))
            {
                sqlConnection.Open();
                using (SqlTransaction sqlTransaction = sqlConnection.BeginTransaction())
                {
                    for (int i = 0; i < building.powerScout.Count; i++)
                    {
                        azurePowerGridModel                           = new AzurePowerGridModel();
                        azurePowerGridModel.PowerScout                = building.powerScout.ElementAt(i);
                        azurePowerGridModel.Timestamp                 = timeStamp;
                        azurePowerGridModel.AMPS_L1                   = Program.RandomNumberBetween(0, building.ampsl1);
                        azurePowerGridModel.AMPS_L2                   = Program.RandomNumberBetween(0, building.ampsl2);
                        azurePowerGridModel.AMPS_L3                   = Program.RandomNumberBetween(0, building.ampsl3);
                        azurePowerGridModel.AMPS_SYSTEM_AVG           = Program.RandomNumberBetween(0, building.ampsSystemAvg);
                        azurePowerGridModel.Breaker_details           = building.breakerDetail.ElementAt(i);
                        azurePowerGridModel.Breaker_label             = building.breakerLabel.ElementAt(i);
                        azurePowerGridModel.Building                  = building.building;
                        azurePowerGridModel.Daily_electric_cost       = Program.RandomNumberBetween(0, building.dailyElectricCost);
                        azurePowerGridModel.Daily_KWH_System          = Program.RandomNumberBetween(0, building.dailykWhSystem);
                        azurePowerGridModel.ModbusBaseAddress         = modbusBaseAddress[i];
                        azurePowerGridModel.Monthly_electric_cost     = Program.RandomNumberBetween(0, building.monthlyElectricCost);
                        azurePowerGridModel.Monthly_KWH_System        = Program.RandomNumberBetween(0, building.monthlykWhSystem);
                        azurePowerGridModel.Rated_Amperage            = Program.RandomNumberBetween(125, building.ratedAmperage);
                        azurePowerGridModel.ReadingTime               = building.readingTime;
                        azurePowerGridModel.Rolling_hourly_kwh_system = Program.RandomNumberBetween(0, building.rollingHourlykWh);
                        azurePowerGridModel.Serial_number             = building.powerScout.ElementAt(i);
                        azurePowerGridModel.Type                      = building.type;
                        azurePowerGridModel.Volts_L1_to_neutral       = Program.RandomNumberBetween(building.voltsL1toNeutral_min, building.voltsL1toNeutral_max);
                        azurePowerGridModel.Volts_L2_to_neutral       = Program.RandomNumberBetween(building.voltsL2toNeutral_min, building.voltsL2toNeutral_max);
                        azurePowerGridModel.Volts_L3_to_neutral       = Program.RandomNumberBetween(building.voltsL3toNeutral_min, building.voltsL3toNeutral_max);
                        azurePowerGridModel.KW_L1                     = Program.RandomNumberBetween(0, building.kWL1);
                        azurePowerGridModel.KW_L2                     = Program.RandomNumberBetween(0, building.kWL2);
                        azurePowerGridModel.KW_L3                     = Program.RandomNumberBetween(0, building.kWL3);
                        azurePowerGridModel.kW_System                 = Program.RandomNumberBetween(0, building.kWSystem);
                        azurePowerGridModel.PIIntTSTicks              = Program.RandomNumberBetween(building.pIIntTSTicks_min, building.pIIntTSTicks_max);
                        azurePowerGridModel.PIIntShapeID              = rnd.Next(1, 7);
                        UpdateDatabaseUsingCommand(building.powerGridInsertQuery, azurePowerGridModel, sqlConnection, sqlTransaction);
                    }

                    sqlTransaction.Commit();
                }

                sqlConnection.Close();
            }
        }
Esempio n. 2
0
        public HttpResponseMessage PostDatatoServer(string RequestURI, AzurePowerGridModel model)
        {
            HttpClient client = new HttpClient();

            client.BaseAddress = new Uri("");
            client.DefaultRequestHeaders.Accept.Clear();
            client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
            string              json       = JsonConvert.SerializeObject(model);
            StringContent       strContent = new StringContent(json);
            HttpResponseMessage response   = client.PostAsync(RequestURI, strContent).Result;

            return(response);
        }
Esempio n. 3
0
        void UpdateDatabaseUsingCommand(string powerGridInsertQuery, AzurePowerGridModel model, SqlConnection sqlConnection, SqlTransaction sqlTransaction)
        {
            using (SqlCommand cmd = new SqlCommand(powerGridInsertQuery, sqlConnection, sqlTransaction))
            {
                cmd.Parameters.AddWithValue("@Id", model.Id);
                cmd.Parameters.AddWithValue("@PowerScout", model.PowerScout);
                cmd.Parameters.AddWithValue("@TimeStamp", model.Timestamp);
                cmd.Parameters.AddWithValue("@AmpsL1", model.AMPS_L1);
                cmd.Parameters.AddWithValue("@AmpsL2", model.AMPS_L2);
                cmd.Parameters.AddWithValue("@AmpsL3", model.AMPS_L3);
                cmd.Parameters.AddWithValue("@AmpsSystemAvg", model.AMPS_SYSTEM_AVG);
                cmd.Parameters.AddWithValue("@BreakerDetails", model.Breaker_details);
                cmd.Parameters.AddWithValue("@BreakerLabel", model.Breaker_label);
                cmd.Parameters.AddWithValue("@Building", model.Building);
                cmd.Parameters.AddWithValue("@DailyElectricCost", model.Daily_electric_cost);
                cmd.Parameters.AddWithValue("@DailykWhSystem", model.Daily_KWH_System);
                cmd.Parameters.AddWithValue("@ModbusBaseAddress", model.ModbusBaseAddress);
                cmd.Parameters.AddWithValue("@MonthlyElectricCost", model.Monthly_electric_cost);
                cmd.Parameters.AddWithValue("@MonthlykWhSystem", model.Monthly_KWH_System);
                cmd.Parameters.AddWithValue("@RatedAmperage", model.Rated_Amperage);
                cmd.Parameters.AddWithValue("@ReadingTime", model.ReadingTime);
                cmd.Parameters.AddWithValue("@RollingHourlykWhSystem", model.Rolling_hourly_kwh_system);
                cmd.Parameters.AddWithValue("@SerialNumber", model.Serial_number);
                cmd.Parameters.AddWithValue("@Type", model.Type);
                cmd.Parameters.AddWithValue("@VoltsL1toNeutral", model.Volts_L1_to_neutral);
                cmd.Parameters.AddWithValue("@VoltsL2toNeutral", model.Volts_L2_to_neutral);
                cmd.Parameters.AddWithValue("@VoltsL3toNeutral", model.Volts_L3_to_neutral);
                cmd.Parameters.AddWithValue("@kWL1", model.KW_L1);
                cmd.Parameters.AddWithValue("@kWL2", model.KW_L2);
                cmd.Parameters.AddWithValue("@kWL3", model.KW_L3);
                cmd.Parameters.AddWithValue("@kWSystem", model.kW_System);
                cmd.Parameters.AddWithValue("@PIIntTSTicks", model.PIIntTSTicks);
                cmd.Parameters.AddWithValue("@PIIntShapeID", model.PIIntShapeID);

                cmd.ExecuteNonQuery();
            }
        }
Esempio n. 4
0
        public void AddPowerGridView()
        {
            rnd = new Random();

            string[] powerScout        = new string[] { "P371602068", "P371602070", "P371602072", "P371602073", "P371602075", "P371602077", "P371602079" };
            string[] breakerDetails    = new string[] { "New (2013) 3rd floor panel - almost empty", "800A duct bank for panels B,C,D - 277v lighting", "D-Wing Addition MDP", "A-Wing Lecture halls", "208v Panel in room C2, Xfmr on roof above.", "Basement MCC", "2nd Floor Xfmr supplying panels L,M,N,U,U1,U2" };
            string[] breakerLabel      = new string[] { "PP31 - 3rd Fl Electrical Rm", "Main Lighting", "MCC", "F", "LCA", "MCC", "T-1" };
            int[]    modbusBaseAddress = new int[] { 2, 5, 6, 4, 3, 8, 7 };


            int number = rnd.Next(0, powerScout.Length - 1);
            AzurePowerGridModel azurePowerGridModel = new AzurePowerGridModel();

            using (SqlConnection sqlConnection = new SqlConnection(ConfigurationSetting.ConnectionString))
            {
                sqlConnection.Open();
                using (SqlTransaction sqlTransaction = sqlConnection.BeginTransaction())
                {
                    DateTime currentTime = DateTime.UtcNow.AddMonths(-3);
                    for (int j = 0; j <= 126000; j++)
                    {
                        DateTime timeStamp = currentTime.AddMinutes(j);
                        for (int i = 0; i < powerScout.Length; i++)
                        {
                            azurePowerGridModel                           = new AzurePowerGridModel();
                            azurePowerGridModel.PowerScout                = powerScout[i];
                            azurePowerGridModel.Timestamp                 = timeStamp;
                            azurePowerGridModel.AMPS_L1                   = Program.RandomNumberBetween(0, ampsl1);
                            azurePowerGridModel.AMPS_L2                   = Program.RandomNumberBetween(0, ampsl2);
                            azurePowerGridModel.AMPS_L3                   = Program.RandomNumberBetween(0, ampsl3);
                            azurePowerGridModel.AMPS_SYSTEM_AVG           = Program.RandomNumberBetween(0, ampsSystemAvg);
                            azurePowerGridModel.Breaker_details           = breakerDetails[i];
                            azurePowerGridModel.Breaker_label             = breakerLabel[i];
                            azurePowerGridModel.Building                  = building;
                            azurePowerGridModel.Daily_electric_cost       = Program.RandomNumberBetween(0, dailyElectricCost);
                            azurePowerGridModel.Daily_KWH_System          = Program.RandomNumberBetween(0, dailykWhSystem);
                            azurePowerGridModel.ModbusBaseAddress         = modbusBaseAddress[i];
                            azurePowerGridModel.Monthly_electric_cost     = Program.RandomNumberBetween(0, monthlyElectricCost);
                            azurePowerGridModel.Monthly_KWH_System        = Program.RandomNumberBetween(0, monthlykWhSystem);
                            azurePowerGridModel.Rated_Amperage            = Program.RandomNumberBetween(125, ratedAmperage);
                            azurePowerGridModel.ReadingTime               = readingTime;
                            azurePowerGridModel.Rolling_hourly_kwh_system = Program.RandomNumberBetween(0, rollingHourlykWh);
                            azurePowerGridModel.Serial_number             = powerScout[i];
                            azurePowerGridModel.Type                      = type;
                            azurePowerGridModel.Volts_L1_to_neutral       = Program.RandomNumberBetween(voltsL1toNeutral_min, voltsL1toNeutral_max);
                            azurePowerGridModel.Volts_L2_to_neutral       = Program.RandomNumberBetween(voltsL2toNeutral_min, voltsL2toNeutral_max);
                            azurePowerGridModel.Volts_L3_to_neutral       = Program.RandomNumberBetween(voltsL3toNeutral_min, voltsL3toNeutral_max);
                            azurePowerGridModel.KW_L1                     = Program.RandomNumberBetween(0, kWL1);
                            azurePowerGridModel.KW_L2                     = Program.RandomNumberBetween(0, kWL2);
                            azurePowerGridModel.KW_L3                     = Program.RandomNumberBetween(0, kWL3);
                            azurePowerGridModel.kW_System                 = Program.RandomNumberBetween(0, kWSystem);
                            azurePowerGridModel.PIIntTSTicks              = Program.RandomNumberBetween(pIIntTSTicks_min, pIIntTSTicks_max);
                            azurePowerGridModel.PIIntShapeID              = rnd.Next(1, 7);
                            UpdateDatabaseUsingCommand(azurePowerGridModel, sqlConnection, sqlTransaction);
                        }
                    }
                    sqlTransaction.Commit();
                }

                sqlConnection.Close();
            }
        }