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();
}
}
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);
}
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();
}
}
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();
}
}
