public ActionResult Add(AddElectroBindingModel BindingModel)
{
if (!this.ModelState.IsValid)
{
LoadModelsAndConnTypesInView();
return(View(BindingModel));
}
try
{
Electrometer newElectro = new Electrometer
{
Name = BindingModel.Name,
Model = BindingModel.Model,
IsStopped = false,
ConnectionType = BindingModel.ConnectionType,
DeviceId = BindingModel.DeviceId,
DeviceIp = BindingModel.DeviceIp,
DevicePort = BindingModel.DevicePort
};
this.Data.Electrometers.Add(newElectro);
this.Data.SaveChanges();
return(RedirectToAction("index", "home", null));
}
catch (Exception ex)
{
ModelState.AddModelError("", "An error occured");
return(View(BindingModel));
}
}
public async Task <IActionResult> Edit(Electrometer input)
{
var entity = await _dbContext.Electrometers.FirstOrDefaultAsync(e => e.Id == input.Id);
if (entity == null)
{
entity = new Electrometer();
await _dbContext.Electrometers.AddAsync(entity);
}
entity.Name = input.Name;
entity.Value = input.Value;
entity.PowerPlantUnitId = input.PowerPlantUnitId;
await _dbContext.SaveChangesAsync();
TempData["Success"] = "1";
return(RedirectToAction("Index"));
}
public JsonResult Delete(string id)
{
Electrometer electro = this.Data.Electrometers.Find(int.Parse(id));
try
{
this.Data.Electrometers.Remove(electro);
this.Data.SaveChanges();
return(Json(new
{
success = true
}));
}
catch (Exception ex)
{
return(Json(new
{
success = false,
message = ex.Message
}));
}
}
public ActionResult Edit(int id, DetailedElectrometerViewModel BindingModel)
{
Electrometer electro = this.Data.Electrometers.Find(id);
try
{
electro.ConnectionType = BindingModel.ConnectionType;
electro.Model = BindingModel.Model;
electro.DeviceId = BindingModel.DeviceId;
electro.DeviceIp = BindingModel.DeviceIp;
electro.DevicePort = BindingModel.DevicePort;
electro.Name = BindingModel.Name;
this.Data.Electrometers.Update(electro);
this.Data.SaveChanges();
return(this.RedirectToAction("manage", "electrometers", null));
}
catch (Exception ex)
{
return(this.View(BindingModel));
}
return(View(BindingModel));
}
protected override void Seed(MyAppDbContext context)
{
if (!context.Roles.Any(r => r.Name == "Admin"))
{
var store = new RoleStore <IdentityRole>(context);
var manager = new RoleManager <IdentityRole>(store);
var adminRole = new IdentityRole {
Name = "UserAdministrator"
};
manager.Create(adminRole);
}
if (!context.Users.Any())
{
User admin = new User()
{
UserName = "******", FirstName = "Admin", LastName = "Admin", Email = "*****@*****.**"
};
var store = new UserStore <User>(context);
var manager = new UserManager <User>(store);
manager.Create(admin, "adminPass123");
}
if (!context.Electrometers.Any())
{
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "КОМП. 4 Test[kWh]", DeviceId = 1, DeviceIp = "192.168.2.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false,
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "КОМП. 5 [kWh]", DeviceId = 2, DeviceIp = "192.168.2.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "КОТ. 1", DeviceId = 3, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "КОТ. 2", DeviceId = 4, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "МАС.", DeviceId = 5, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "FKS4", DeviceId = 7, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "FKS6", DeviceId = 8, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕКИП", DeviceId = 9, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ОСВ. 1", DeviceId = 10, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ОСВ. 2", DeviceId = 11, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ПАЛЕТ.", DeviceId = 12, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "АДМИН.", DeviceId = 13, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "НОВ 1", DeviceId = 14, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "НОВ 2", DeviceId = 15, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Тунелна пещ 1", DeviceId = 27, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Шатъл 1", DeviceId = 28, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Шатъл 2", DeviceId = 29, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 1", DeviceId = 1, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 3", DeviceId = 3, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 5", DeviceId = 5, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 6", DeviceId = 6, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 7", DeviceId = 7, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 8", DeviceId = 8, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 9", DeviceId = 9, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 10", DeviceId = 10, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 11", DeviceId = 11, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 12", DeviceId = 12, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 13", DeviceId = 13, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 14", DeviceId = 14, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 15", DeviceId = 15, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 16", DeviceId = 16, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 17", DeviceId = 17, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 18", DeviceId = 18, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 19", DeviceId = 19, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 20", DeviceId = 20, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 41", DeviceId = 41, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 42", DeviceId = 42, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "ЕЛ. 43", DeviceId = 43, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM500", Name = "ТРАФО-1", DeviceId = 25, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM500", Name = "ТРАФО-2", DeviceId = 24, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM500", Name = "ТРАФО-3", DeviceId = 26, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.ShniderPM3250_PM3255", Name = "Нова адм. +гипсово", DeviceId = 1, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Изпичане ТП2", DeviceId = 2, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Склад ГП", DeviceId = 3, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Машини ВН", DeviceId = 4, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Глазиране", DeviceId = 5, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Сушене-тунелна", DeviceId = 6, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Сортиране", DeviceId = 7, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Ледотопене", DeviceId = 8, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "КТП 2", DeviceId = 1, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Фоертон 1 РТ1", DeviceId = 2, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Фоертон 2 РТ2", DeviceId = 3, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.SchneiderPM9", Name = "Ново бар.", DeviceId = 4, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.Electrometers.Add(new Electrometer {
Model = "Schneider.WAGOSimulator", Name = "WAGO", DeviceId = 1, DeviceIp = "192.1682.13", DevicePort = 50000, ConnectionType = "Modbus_RTU_Over_TCP", IsStopped = false
});
context.SaveChanges();
}
if (context.HourlyRecords.Count() < 2)
{
Electrometer electro = context.Electrometers.FirstOrDefault(el => el.Id == 3);
var testRecord = new HourlyRecord()
{
Electrometer = electro,
I1 = 88.16,
I2 = 117.45,
I3 = 119.65,
U1 = 227.4,
U2 = 228.3,
U3 = 228.4,
DateTime = DateTime.Now,
Frequency = 50,
PowerFactor = 0.88,
KVA = 81.46,
Kvar = 8.99,
KW = 72.07,
ActiveEnergy = 351.12,
ReactiveEnergy = 501.019,
ApparentEnergy = 400.59
};
electro.HourlyRecords.Add(testRecord);
context.SaveChanges();
for (int i = 0; i < 250; i++)
{
HourlyRecord lastRecord = context.HourlyRecords.OrderByDescending(rec => rec.Id).Take(1).Single();
testRecord = new HourlyRecord()
{
Electrometer = electro,
DateTime = DateTime.Now.AddHours(i),
KVA = lastRecord.KVA + (i + 1) / 0.8,
I1 = i % 2 == 0 ? lastRecord.I1 + 1 : lastRecord.I1 - 1,
I2 = i % 2 == 0 ? lastRecord.I2 + 1 : lastRecord.I2 - 1,
I3 = i % 2 == 0 ? lastRecord.I3 + 1 : lastRecord.I3 - 1,
U1 = i % 2 == 0 ? lastRecord.U1 + 1 : lastRecord.I1 - 1,
U2 = i % 2 == 0 ? lastRecord.U2 + 1 : lastRecord.U2 - 1,
U3 = i % 2 == 0 ? lastRecord.U3 + 1 : lastRecord.U3 - 1,
Frequency = i % 2 == 0 ? lastRecord.Frequency + i / 3 : lastRecord.Frequency - i / 2,
Kvar = lastRecord.Kvar + i / 1.2,
PowerFactor = lastRecord.PowerFactor,
KW = lastRecord.KVA + i / 1.1,
ActiveEnergy = lastRecord.ActiveEnergy + i / 1.2,
ReactiveEnergy = lastRecord.ReactiveEnergy + i / 1.2,
ApparentEnergy = lastRecord.ApparentEnergy + i / 1.2
};
electro.HourlyRecords.Add(testRecord);
}
}
}
public JsonResult Daily(string id)
{
Electrometer electro = this.Data.Electrometers.Find(int.Parse(id));
return(Json(Mapper.Map <IEnumerable <ShortHourRecordViewModel> >(electro.HourlyRecords.Take(25)), JsonRequestBehavior.AllowGet));
}