| public GetCSV ( double acKilowatts, double fanKilowatts, double heatBTU, int timeZoneDifference ) : string | ||
| acKilowatts | double | |
| fanKilowatts | double | |
| heatBTU | double | |
| timeZoneDifference | int | |
| return | string | |
protected void Page_Load(object sender, EventArgs e)
{
DeleteOldData();
DataTable thermostats = ThermostatMonitorLib.Thermostats.LoadPublicThermostats();
OutputCSV(ThermostatMonitorLib.Utils.DataTableToCSV(thermostats), "/dump/thermostats.csv");
foreach (DataRow row in thermostats.Rows)
{
int id = Convert.ToInt32(row["Id"]);
int locationId = Convert.ToInt32(row["LocationId"]);
double acKilowatts = Convert.ToDouble(row["ACKilowatts"]);
double fanKilowatts = Convert.ToDouble(row["FanKilowatts"]);
double heatBTU = 0;
try
{
heatBTU = Convert.ToDouble(row["HeatBtuPerHour"]);
}
catch { }
ThermostatMonitorLib.Cycles cycles = ThermostatMonitorLib.Cycles.LoadRange(id, new DateTime(2000, 1, 1), DateTime.Now);
OutputCSV(cycles.GetCSV(acKilowatts, fanKilowatts, heatBTU, 0), "/dump/t" + id.ToString() + "_cycles.csv");
OutputCSV(ThermostatMonitorLib.Temperatures.LoadTemperaturesByThermostatId(id).GetCSV(), "/dump/t" + id.ToString() + "_inside.csv");
OutputCSV(ThermostatMonitorLib.OutsideConditions.LoadOutsideConditionsByLocationId(locationId).GetCSV(), "/dump/l" + locationId.ToString() + "_outside.csv");
}
ZipFiles();
Response.Redirect("/dump/export.zip");
}
private void OutputCycles(ThermostatMonitorLib.Thermostat thermostat, ThermostatMonitorLib.Location location)
{
ThermostatMonitorLib.Cycles cycles = ThermostatMonitorLib.Cycles.LoadRange(thermostat.Id, new DateTime(2000, 1, 1), DateTime.Now);
OutputCSV(cycles.GetCSV(thermostat.ACKilowatts, thermostat.FanKilowatts, thermostat.HeatBtuPerHour, AppUser.TimezoneDifference(location.Timezone, location.DaylightSavings)), "cycles.csv");
}