public ActionResult Create(Area area, FormCollection form) { ViewData["ValidationErrorMessage"] = String.Empty; if (this.FormCollectionIsValid(form)) { db.Save(this.RemoveExtraSpaces(area)); List<Object> logList = new List<Object>(); logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["CreateText"] + ControllerContext.RouteData.Values["controller"] + "(Id=" + area.Id.ToString().Replace("-", "").ToUpper() + " - Description=" + area.Description + " - Name=" + area.Name + ")", (int)EventTypes.Create, (int)Session["UserId"])); log.Write(logList); return RedirectToAction("Index"); } return View(area); }
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); }
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); }
private Area RemoveExtraSpaces(Area area) { area.Name = !String.IsNullOrWhiteSpace(area.Name) ? area.Name.Trim() : null; area.Description = !String.IsNullOrWhiteSpace(area.Description) ? area.Description.Trim() : null; return area; }