public ActionResult Create(Appliance appliance, FormCollection form)
{
ViewData["ValidationErrorMessage"] = String.Empty;
if (this.FormCollectionIsValid(form))
{
appliance.Area = dbA.GetById(Convert.ToInt32(form["AreaId"]));
db.Save(this.RemoveExtraSpaces(appliance));
List<Object> logList = new List<Object>();
logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["CreateText"] +
ControllerContext.RouteData.Values["controller"] +
"(Id=" + appliance.Id.ToString().Replace("-", "").ToUpper() +
" - Description=" + appliance.Description +
" - ApplianceName=" + appliance.NameAppliance +
" - AreaName=" + appliance.Area.Name + ")",
(int)EventTypes.Create,
(int)Session["UserId"]));
log.Write(logList);
return RedirectToAction("Index");
}
ViewBag.AreaId = !String.IsNullOrEmpty(form["AreaId"]) ? new SelectList(dbA.GetAll(), "Id", "Name", form["AreaId"]) : new SelectList(dbA.GetAll(), "Id", "Name");
return View(appliance);
}
public void TestMethod1()
{
IRepository<Monitoring> repoM = new MonitoringRepository();
var res = repoM.GetByProperty("CommentsOnAlarm", null);
IRepository<Signal> repo1 = new SignalRepository();
Signal signal = new Signal();
signal = repo1.GetById(1);
IRepository<Appliance> repo2 = new ApplianceRepository();
Appliance appliance = new Appliance();
appliance = repo2.GetById(1);
IRepository<AlarmType> repo3 = new AlarmTypeRepository();
AlarmType alarmType = new AlarmType();
alarmType = repo3.GetById(1);
IRepository<User> repo4 = new UserRepository();
User user = new User();
user = repo4.GetById(2);
IRepository<MappingTag> repoMT = new MappingTagRepository();
MappingTag tag = new MappingTag();
tag.Tag = "PruebaTag";
tag.Description = "Prueba descriptiva mapping tag";
tag.Signal = signal;
tag.Appliance = appliance;
tag.AlarmType = alarmType;
Monitoring monitor = new Monitoring();
monitor.Value = float.Parse("2.400");
monitor.DateTime = DateTime.Now;
monitor.CommentsOnAlarm = "Prueba de comentarios sobre alarma, monitoreo";
monitor.MappingTag = tag;
monitor.User = user;
tag.Monitorings.Add(monitor);
repoMT.Save(tag);
/*INSERT 4000 RECORDS for TEST*/
//IRepository<Monitoring> repoM = new MonitoringRepository();
//IRepository<User> repo4 = new UserRepository();
//User user = new User();
//user = repo4.GetById(6);
//IRepository<MappingTag> repoMT = new MappingTagRepository();
//MappingTag tag = new MappingTag();
//tag = repoMT.GetById(103);
//for (int i = 0; i < 4000; i++)
//{
// Monitoring monitor = new Monitoring();
// monitor.Value = (1000 + i);
// monitor.DateTime = DateTime.Now;
// monitor.CommentsOnAlarm = null;
// monitor.MappingTag = tag;
// monitor.User = user;
// repoM.Save(monitor);
//}
}
public void CanCreateAreaAndAppliance()
{
IRepository<Area> repoA = new AreaRepository();
Area area = new Area();
area.Name = "PruebaArea";
area.Description = "Prueba descriptiva area";
IRepository<Appliance> repoB = new ApplianceRepository();
Appliance appliance = new Appliance();
appliance.NameAppliance = "PruebaAppliance";
appliance.Description = "Prueba descriptiva appliance";
appliance.Area = area;
area.Appliances.Add(appliance);
repoA.Save(area);
}
public void CanCreateSignalWithTolerance()
{
IRepository<Area> repoT = new AreaRepository();
Area area = new Area();
area = repoT.GetById(1);
IRepository<Signal> repoA = new SignalRepository();
Signal signal = new Signal();
signal.Name = "PruebaSenal";
signal.Description = "Prueba descriptiva senal";
repoA.Save(signal);
IRepository<Appliance> repoB = new ApplianceRepository();
Appliance appliance = new Appliance();
appliance.NameAppliance = "PruebaAppliance";
appliance.Description = "Prueba descriptiva appliance";
appliance.Area = area;
IRepository<SignalAppliance> repoC = new SignalApplianceRepository();
SignalAppliance signalAppliance = new SignalAppliance();
signalAppliance.Signal = signal;
signalAppliance.Appliance = appliance;
signalAppliance.Tolerance = SIGNAL_APPLIANCE_TOLERANCE;
appliance.Signals.Add(signalAppliance);
repoB.Save(appliance);
SignalAppliance createdSignalAppliance = repoC.GetById(signalAppliance.Id);
Assert.IsNotNull(createdSignalAppliance);
Assert.AreEqual(signalAppliance, createdSignalAppliance);
repoC.Delete(signalAppliance.Id);
repoB.Delete(appliance.Id);
repoA.Delete(signal.Id);
}
public void CanCreateSignalApplianceAndValues()
{
IRepository<Area> repoT = new AreaRepository();
Area area = new Area();
area = repoT.GetById(1);
IRepository<AlarmType> repoAT = new AlarmTypeRepository();
AlarmType alarm = new AlarmType();
alarm = repoAT.GetById(1);
IRepository<Signal> repoA = new SignalRepository();
Signal signal = new Signal();
signal.Name = "PruebaSenal";
signal.Description = "Prueba descriptiva senal";
repoA.Save(signal);
IRepository<Appliance> repoB = new ApplianceRepository();
Appliance appliance = new Appliance();
appliance.NameAppliance = "PruebaAppliance";
appliance.Description = "Prueba descriptiva appliance";
appliance.Area = area;
SignalAppliance signalAppliance = new SignalAppliance();
signalAppliance.Signal = signal;
signalAppliance.Appliance = appliance;
appliance.Signals.Add(signalAppliance);
repoB.Save(appliance);
IRepository<SignalApplianceValue> repoSAV = new SignalApplianceValueRepository();
SignalApplianceValue signalApplianceValue = new SignalApplianceValue();
signalApplianceValue.Value = 40;
signalApplianceValue.SignalAppliance = signalAppliance;
signalApplianceValue.AlarmType = alarm;
repoSAV.Save(signalApplianceValue);
}
private Appliance RemoveExtraSpaces(Appliance appliance)
{
appliance.NameAppliance = !String.IsNullOrWhiteSpace(appliance.NameAppliance) ? appliance.NameAppliance.Trim() : null;
appliance.Description = !String.IsNullOrWhiteSpace(appliance.Description) ? appliance.Description.Trim() : null;
return appliance;
}
public void CanCreateSignalWithToleranceAndAssociatedSignalApplianceValues()
{
IRepository<Area> repoT = new AreaRepository();
Area area = new Area();
area = repoT.GetById(1);
IRepository<AlarmType> repoAT = new AlarmTypeRepository();
AlarmType normalAlarm = new AlarmType();
normalAlarm = repoAT.GetById(1);
AlarmType highAlarm = new AlarmType();
highAlarm = repoAT.GetById(2);
AlarmType lowAlarm = new AlarmType();
lowAlarm = repoAT.GetById(3);
IRepository<Signal> repoA = new SignalRepository();
Signal signal = new Signal();
signal.Name = "PruebaSenal";
signal.Description = "Prueba descriptiva senal";
repoA.Save(signal);
IRepository<Appliance> repoB = new ApplianceRepository();
Appliance appliance = new Appliance();
appliance.NameAppliance = "PruebaAppliance";
appliance.Description = "Prueba descriptiva appliance";
appliance.Area = area;
IRepository<SignalAppliance> repoSAppl = new SignalApplianceRepository();
SignalAppliance signalAppliance = new SignalAppliance();
signalAppliance.Signal = signal;
signalAppliance.Appliance = appliance;
signalAppliance.Tolerance = SIGNAL_APPLIANCE_TOLERANCE;
appliance.Signals.Add(signalAppliance);
IRepository<SignalApplianceValue> repoSApplV = new SignalApplianceValueRepository();
SignalApplianceValue normalValue = new SignalApplianceValue();
normalValue.AlarmType = normalAlarm;
normalValue.SignalAppliance = signalAppliance;
normalValue.Value = SIGNAL_APPLIANCE_SET_POINT;
SignalApplianceValue highValue = new SignalApplianceValue();
highValue.AlarmType = highAlarm;
highValue.SignalAppliance = signalAppliance;
highValue.Value = SIGNAL_APPLIANCE_SET_POINT + SIGNAL_APPLIANCE_TOLERANCE;
SignalApplianceValue lowValue = new SignalApplianceValue();
lowValue.AlarmType = lowAlarm;
lowValue.SignalAppliance = signalAppliance;
lowValue.Value = SIGNAL_APPLIANCE_SET_POINT - SIGNAL_APPLIANCE_TOLERANCE;
signalAppliance.SignalApplianceValues.Add(normalValue);
signalAppliance.SignalApplianceValues.Add(highValue);
signalAppliance.SignalApplianceValues.Add(lowValue);
repoB.Save(appliance);
SignalApplianceValue createdNormalValue = repoSApplV.GetById(normalValue.Id);
Assert.AreEqual(normalValue.Value, createdNormalValue.Value);
SignalApplianceValue createdHighValue = repoSApplV.GetById(highValue.Id);
Assert.AreEqual(highValue.Value, createdHighValue.Value);
SignalApplianceValue createdLowValue = repoSApplV.GetById(lowValue.Id);
Assert.AreEqual(lowValue.Value, createdLowValue.Value);
repoSApplV.Delete(normalValue.Id);
repoSApplV.Delete(highValue.Id);
repoSApplV.Delete(lowValue.Id);
repoSAppl.Delete(signalAppliance.Id);
repoB.Delete(appliance.Id);
repoA.Delete(signal.Id);
}
public void ListSignalAppliancesWithAlarmTypesAndValuesInOneRecord()
{
IRepository<SignalAppliance> dbSA = new SignalApplianceRepository();
IRepository<Signal> dbS = new SignalRepository();
IRepository<Appliance> dbApp = new ApplianceRepository();
IRepository<SignalApplianceValue> dbSAppV = new SignalApplianceValueRepository();
IRepository<AlarmType> dbAT = new AlarmTypeRepository();
IRepository<Area> dbA = new AreaRepository();
Area area = new Area();
area = dbA.GetById(1);
AlarmType normalAlarm = new AlarmType();
normalAlarm = dbAT.GetById(1);
AlarmType highAlarm = new AlarmType();
highAlarm = dbAT.GetById(2);
AlarmType lowAlarm = new AlarmType();
lowAlarm = dbAT.GetById(3);
Signal signal = new Signal();
signal.Name = "PruebaSenal";
signal.Description = "Prueba descriptiva senal";
dbS.Save(signal);
Appliance appliance = new Appliance();
appliance.NameAppliance = "PruebaAppliance";
appliance.Description = "Prueba descriptiva appliance";
appliance.Area = area;
SignalAppliance signalAppliance = new SignalAppliance();
signalAppliance.Signal = signal;
signalAppliance.Appliance = appliance;
signalAppliance.Tolerance = SIGNAL_APPLIANCE_TOLERANCE;
appliance.Signals.Add(signalAppliance);
SignalApplianceValue normalValue = new SignalApplianceValue();
normalValue.AlarmType = normalAlarm;
normalValue.SignalAppliance = signalAppliance;
normalValue.Value = SIGNAL_APPLIANCE_SET_POINT;
SignalApplianceValue highValue = new SignalApplianceValue();
highValue.AlarmType = highAlarm;
highValue.SignalAppliance = signalAppliance;
highValue.Value = SIGNAL_APPLIANCE_SET_POINT + SIGNAL_APPLIANCE_TOLERANCE;
SignalApplianceValue lowValue = new SignalApplianceValue();
lowValue.AlarmType = lowAlarm;
lowValue.SignalAppliance = signalAppliance;
lowValue.Value = SIGNAL_APPLIANCE_SET_POINT - SIGNAL_APPLIANCE_TOLERANCE;
signalAppliance.SignalApplianceValues.Add(normalValue);
signalAppliance.SignalApplianceValues.Add(highValue);
signalAppliance.SignalApplianceValues.Add(lowValue);
dbApp.Save(appliance);
var result = from sa in dbSA.GetAll()
join s in dbS.GetAll() on sa.Signal.Id equals s.Id
join app in dbApp.GetAll() on sa.Appliance.Id equals app.Id
join sapv in dbSAppV.GetAll() on sa.Id equals sapv.SignalAppliance.Id
join a in dbAT.GetAll() on sapv.AlarmType.Id equals a.Id
where sa.Id.Equals(signalAppliance.Id)
group new {a.Id, a.NameAlarmType, sapv.Value } by new {sa.Id, app.NameAppliance, s.Name, sa.Tolerance} into g
select new { signalAppliance = g.Key, setPoint = from v in g where v.Id == 1 select v.Value, highValue = from v in g where v.Id == 2 select v.Value, lowValue = from v in g where v.Id == 3 select v.Value };
foreach (var sa in result)
{
Assert.AreEqual(sa.signalAppliance.Id, signalAppliance.Id);
ObjectDumper.Write(sa.setPoint);
Assert.AreEqual(normalValue.Value, sa.setPoint.ElementAtOrDefault(0));
ObjectDumper.Write(sa.highValue);
Assert.AreEqual(highValue.Value, sa.highValue.ElementAtOrDefault(0));
ObjectDumper.Write(sa.lowValue);
Assert.AreEqual(lowValue.Value, sa.lowValue.ElementAtOrDefault(0));
}
dbSAppV.Delete(normalValue.Id);
dbSAppV.Delete(highValue.Id);
dbSAppV.Delete(lowValue.Id);
dbSA.Delete(signalAppliance.Id);
dbApp.Delete(appliance.Id);
dbS.Delete(signal.Id);
}
