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 ActionResult DeleteConfirmed(Guid id) { List<Object> logList = new List<Object>(); ViewData["ValidationErrorMessage"] = String.Empty; try { SignalAppliance signalAppliance = dbSA.GetById(id); IRepository<MappingTag> dbMT = new MappingTagRepository(); IRepository<Monitoring> dbM = new MonitoringRepository(); IRepository<Appliance> dbA = new ApplianceRepository(); IRepository<Signal> dbS = new SignalRepository(); int associatedRecords = (from mapp in dbMT.GetAll() join mon in dbM.GetAll() on mapp.Id equals mon.MappingTag.Id where mapp.Signal.Id.Equals(signalAppliance.Signal.Id) && mapp.Appliance.Id.Equals(signalAppliance.Appliance.Id) select mon.Id).Count(); if (associatedRecords == 0) { var signalAppliancesValues = dbSAppV.GetByProperty("SignalAppliance.Id", id); foreach (var signalApplianceValue in signalAppliancesValues) { dbSAppV.Delete(signalApplianceValue.Id); } dbSA.Delete(id); logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["DeleteText"] + ControllerContext.RouteData.Values["controller"] + "(Id=" + DotNetToOracle(signalAppliance.Id.ToString()).Replace("-", "").ToUpper() + " - SignalName=" + dbS.GetById(signalAppliance.Signal.Id).Name + " - ApplianceName=" + dbA.GetById(signalAppliance.Appliance.Id).NameAppliance + " - Tolerance=" + signalAppliance.Tolerance + ")", (int)EventTypes.Delete, (int)Session["UserId"])); log.Write(logList); } else { ViewData["ValidationErrorMessage"] = ConfigurationManager.AppSettings["CannotDeleteHasAssociatedRecords"]; logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["DeleteText"] + ConfigurationManager.AppSettings["CannotDeleteHasAssociatedRecords"] + " " + ControllerContext.RouteData.Values["controller"] + "(Id=" + DotNetToOracle(signalAppliance.Id.ToString()).Replace("-", "").ToUpper() + " - SignalName=" + dbS.GetById(signalAppliance.Signal.Id).Name + " - ApplianceName=" + dbA.GetById(signalAppliance.Appliance.Id).NameAppliance + " - Tolerance=" + signalAppliance.Tolerance + ")", (int)EventTypes.Delete, (int)Session["UserId"])); log.Write(logList); int differentialPressure = int.Parse(ConfigurationManager.AppSettings["DifferentialPressure"]); int temperature = int.Parse(ConfigurationManager.AppSettings["Temperature"]); int rh = int.Parse(ConfigurationManager.AppSettings["RH"]); string measureUnit = "N/A"; if (signalAppliance.Signal.Id == differentialPressure) { measureUnit = ConfigurationManager.AppSettings["Percentage"].ToString(); } else if (signalAppliance.Signal.Id == temperature) { measureUnit = ConfigurationManager.AppSettings["DegreeCelsius"].ToString(); } else if (signalAppliance.Signal.Id == rh) { measureUnit = ConfigurationManager.AppSettings["InchesOfWater"].ToString(); } Dictionary<string, object> properties = new Dictionary<string, object>(); properties.Add("SignalAppliance.Id", signalAppliance.Id); float setPoint = 0, highValue = 0, lowValue = 0; foreach (SignalApplianceValue signalApplianceValue in dbSAppV.GetByProperties(properties)) { if (signalApplianceValue.AlarmType.Id == int.Parse(ConfigurationManager.AppSettings["NormalAlarmId"])) { setPoint = signalApplianceValue.Value; } else if (signalApplianceValue.AlarmType.Id == int.Parse(ConfigurationManager.AppSettings["HighAlarmId"])) { highValue = signalApplianceValue.Value; } else if (signalApplianceValue.AlarmType.Id == int.Parse(ConfigurationManager.AppSettings["LowAlarmId"])) { lowValue = signalApplianceValue.Value; } } ViewBag.ApplianceName = dbA.GetById(dbSA.GetById(id).Appliance.Id).NameAppliance; ViewBag.HighValue = highValue; ViewBag.LowValue = lowValue; ViewBag.MeasureUnit = measureUnit; ViewBag.SetPoint = setPoint; ViewBag.SignalName = dbS.GetById(dbSA.GetById(id).Signal.Id).Name; return View(signalAppliance); } } catch (GenericADOException ex) { ViewData["ValidationErrorMessage"] = ConfigurationManager.AppSettings["CannotDeleteHasAssociatedRecords"]; logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["DeleteText"] + ex.InnerException.Message, (int)EventTypes.Delete, (int)Session["UserId"])); log.Write(logList); SignalAppliance signalAppliance = dbSA.GetById(id); int differentialPressure = int.Parse(ConfigurationManager.AppSettings["DifferentialPressure"]); int temperature = int.Parse(ConfigurationManager.AppSettings["Temperature"]); int rh = int.Parse(ConfigurationManager.AppSettings["RH"]); string measureUnit = "N/A"; if (signalAppliance.Signal.Id == differentialPressure) { measureUnit = ConfigurationManager.AppSettings["Percentage"].ToString(); } else if (signalAppliance.Signal.Id == temperature) { measureUnit = ConfigurationManager.AppSettings["DegreeCelsius"].ToString(); } else if (signalAppliance.Signal.Id == rh) { measureUnit = ConfigurationManager.AppSettings["InchesOfWater"].ToString(); } Dictionary<string, object> properties = new Dictionary<string, object>(); properties.Add("SignalAppliance.Id", signalAppliance.Id); float setPoint = 0, highValue = 0, lowValue = 0; foreach (SignalApplianceValue signalApplianceValue in dbSAppV.GetByProperties(properties)) { if (signalApplianceValue.AlarmType.Id == int.Parse(ConfigurationManager.AppSettings["NormalAlarmId"])) { setPoint = signalApplianceValue.Value; } else if (signalApplianceValue.AlarmType.Id == int.Parse(ConfigurationManager.AppSettings["HighAlarmId"])) { highValue = signalApplianceValue.Value; } else if (signalApplianceValue.AlarmType.Id == int.Parse(ConfigurationManager.AppSettings["LowAlarmId"])) { lowValue = signalApplianceValue.Value; } } ViewBag.ApplianceName = dbA.GetById(dbSA.GetById(id).Appliance.Id).NameAppliance; ViewBag.HighValue = highValue; ViewBag.LowValue = lowValue; ViewBag.MeasureUnit = measureUnit; ViewBag.SetPoint = setPoint; ViewBag.SignalName = dbS.GetById(dbSA.GetById(id).Signal.Id).Name; return View(signalAppliance); } catch (Exception ex) { ViewData["ValidationErrorMessage"] = ConfigurationManager.AppSettings["UnknownError"]; logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["DeleteText"] + ex.InnerException.Message, (int)EventTypes.Delete, (int)Session["UserId"])); log.Write(logList); return View(); } return RedirectToAction("Index"); }
public ActionResult DeleteConfirmed(int id) { List<Object> logList = new List<Object>(); ViewData["ValidationErrorMessage"] = String.Empty; MappingTag mappingtag = db.GetById(id); try { IRepository<Signal> dbS = new SignalRepository(); IRepository<Appliance> dbA = new ApplianceRepository(); IRepository<AlarmType> dbAT = new AlarmTypeRepository(); if (mappingtag != null) { db.Delete(id); logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["DeleteText"] + ControllerContext.RouteData.Values["controller"] + "(Id=" + mappingtag.Id.ToString().Replace("-", "").ToUpper() + " - Description=" + mappingtag.Description + " - Tag=" + mappingtag.Tag + " - AlarmTypeName=" + dbAT.GetById(mappingtag.AlarmType.Id).NameAlarmType + " - ApplianceName=" + dbA.GetById(mappingtag.Appliance.Id).NameAppliance + " - SignalName=" + dbS.GetById(mappingtag.Signal.Id).Name + ")", (int)EventTypes.Delete, (int)Session["UserId"])); log.Write(logList); } } catch (GenericADOException) { ViewData["ValidationErrorMessage"] = ConfigurationManager.AppSettings["CannotDeleteHasAssociatedRecords"]; logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["DeleteText"] + ConfigurationManager.AppSettings["CannotDeleteHasAssociatedRecords"] + " " + ControllerContext.RouteData.Values["controller"] + "(Id=" + mappingtag.Id.ToString().Replace("-", "").ToUpper() + " - Description=" + mappingtag.Description + " - Tag=" + mappingtag.Tag + " - AlarmTypeName=" + dbAT.GetById(mappingtag.AlarmType.Id).NameAlarmType + " - ApplianceName=" + dbA.GetById(mappingtag.Appliance.Id).NameAppliance + " - SignalName=" + dbS.GetById(mappingtag.Signal.Id).Name + ")", (int)EventTypes.Delete, (int)Session["UserId"])); log.Write(logList); MappingTag entity = db.GetById(id); entity.AlarmType = dbAT.GetById(entity.AlarmType.Id); entity.Appliance = dbA.GetById(entity.Appliance.Id); entity.Signal = dbS.GetById(entity.Signal.Id); return View(entity); } catch (Exception ex) { ViewData["ValidationErrorMessage"] = ConfigurationManager.AppSettings["UnknownError"]; logList.Add(log.GetNewLog(ConfigurationManager.AppSettings["DeleteText"] + ex.InnerException.Message, (int)EventTypes.Delete, (int)Session["UserId"])); log.Write(logList); return View(); } return RedirectToAction("Index"); }