public IHttpActionResult SetVariables([FromBody] VariableDto model) { Configuration config = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~"); config.AppSettings.Settings["PlannedValue"].Value = model.Value; config.Save(); ConfigurationManager.RefreshSection("appSettings"); return(Ok()); }
public ActionResult Create(VariableDto variableDto) //public ActionResult Create(FormCollection collection) { try { // TODO: Add insert logic here var logic = new VariableLogic(); logic.Add(variableDto); return(RedirectToAction("Index")); } catch { return(View()); } }
public JsonResult GuardarVariable(VariableDto vm) { var variableEnDb = _context.Variables .SingleOrDefault(v => v.VariableCodigo == vm.VariableCodigo); ViewBag.Title = variableEnDb == null ? "Creando Variable" : "Editando Variable"; try { if (!ModelState.IsValid) { vm.Accion = 0; vm.Mensaje = "los datos enviados no son correctos, verifiquelos e intente de nuevo"; return(Json(vm, JsonRequestBehavior.AllowGet)); } if (variableEnDb == null) { _context.Variables.Add(Mapper.Map <VariableDto, Variable>(vm)); } else { variableEnDb.VariableNombre = vm.VariableNombre; variableEnDb.OrigenId = vm.OrigenId; variableEnDb.DatoDeRetornoId = vm.DatoDeRetornoId; variableEnDb.TipoId = vm.TipoId; variableEnDb.VariableDescripcion = vm.VariableDescripcion; variableEnDb.VariableFormula = vm.VariableFormula; variableEnDb.VariableValor = vm.VariableValor; } if (_context.ChangeTracker.HasChanges()) { _context.SaveChanges(); } vm.Accion = 1; vm.Mensaje = "datos guardados exitosamente!"; return(Json(vm, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { vm.Accion = 0; vm.Mensaje = ex.Message.ToString(); return(Json(vm, JsonRequestBehavior.AllowGet)); } }
static void Main(string[] args) { var variableRepo = new VariableDtoRepository(); var variable = new VariableDto { Name = "dto", Type = "1", DataLoggingEnabled = true, }; var varfromDB = variableRepo.Insert(variable, true); var variaabla = variableRepo.GetById(2); var varfromDb = variableRepo.Context.Variables.Find(8); }
public ActionResult NewVariable() { ViewBag.Origenes = _context.ItemsDeConfiguracion.Where(x => x.ConfigID == "SRC") .ToList().Select(Mapper.Map <ConfigItem, ConfigItemDto>); ViewBag.Tipos = _context.ItemsDeConfiguracion.Where(x => x.ConfigID == "DDR") .ToList().Select(Mapper.Map <ConfigItem, ConfigItemDto>); ViewBag.TiposVariables = _context.ItemsDeConfiguracion.Where(x => x.ConfigID == "TIPO") .ToList().Select(Mapper.Map <ConfigItem, ConfigItemDto>); ViewBag.VariablesList = _context.Variables.ToList().Select(Mapper.Map <Variable, VariableDto>); ViewBag.FuncionesList = _context.Funciones.ToList().Select(Mapper.Map <Funcion, FuncionDto>); ViewBag.Titulo = "Creando Variable"; var viewModel = new VariableDto(); return(PartialView("VariableForm", viewModel)); }
public ActionResult ViewVariableData(string id) { VariableDto objDto = new VariableDto(); if (!ModelState.IsValid) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } try { if (string.IsNullOrEmpty(id)) { return(HttpNotFound()); } else { objDto = Mapper.Map <Variable, VariableDto>(_context.Variables.SingleOrDefault(v => v.VariableCodigo == id)); var origen = _context.ItemsDeConfiguracion.SingleOrDefault(x => x.ConfigItemID == objDto.OrigenId); var datoRetorno = _context.ItemsDeConfiguracion.SingleOrDefault(x => x.ConfigItemID == objDto.DatoDeRetornoId); var tipo = _context.ItemsDeConfiguracion.SingleOrDefault(x => x.ConfigItemID == objDto.TipoId); objDto.OrigenDto = Mapper.Map <ConfigItem, ConfigItemDto>(origen); objDto.DatoDeRetornoDto = Mapper.Map <ConfigItem, ConfigItemDto>(datoRetorno); objDto.TipoDto = Mapper.Map <ConfigItem, ConfigItemDto>(tipo); if (objDto == null) { return(HttpNotFound("No se encontro ninguna variable con este id")); } } } catch (Exception exception) { return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, exception.Message.ToString())); } return(PartialView(objDto)); }
public JsonResult ObtenerVariables() { try { var variables = (from v in _context.Variables select new VariableDto { VariableCodigo = v.VariableCodigo, VariableNombre = v.VariableNombre, OrigenId = v.OrigenId, DatoDeRetornoId = v.DatoDeRetornoId, TipoId = v.TipoId, VariableDescripcion = v.VariableDescripcion, VariableFormula = v.VariableFormula, VariableValor = v.VariableValor, Accion = 1, Mensaje = "se cargaron correctament los datos!" }).ToList(); if (variables.Count == 0) { var tmp = new VariableDto { Accion = 0, Mensaje = "No se encontraron registros!" }; variables.Add(tmp); } return(Json(variables, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { List <VariableDto> list = new List <VariableDto>(); VariableDto obj = new VariableDto() { Accion = 0, Mensaje = ex.Message.ToString() }; list.Add(obj); return(Json(list, JsonRequestBehavior.AllowGet)); } }
public ActionResult Edit(VariableDto model, string action) { try { var logic = new VariableLogic(); if (action == "delete") { logic.Delete(model.VariableId); } else { logic.Update(model); } var response = new { value = model, status = true, message = "Success" }; JObject jResponse = JObject.FromObject(response); return(Content(jResponse.ToString())); } catch (Exception ex) { var response = new { value = model, status = false, message = ex.Message }; JObject jResponse = JObject.FromObject(response); return(Content(jResponse.ToString())); } }
public void UpdateVariableSingle(string name, float currentValue, DateTime timeStamp) { if (_time == null) { _longTimer = DateTime.UtcNow.Second; _time = new Timer(1000); _time.Elapsed += TimeElapsed; _time.AutoReset = true; _time.Start(); } ServiceVariable serviceVariable; //ako postoji variabla pod imenom na servisu updejtaj vrijednost ako ne postoji kreiraj try { serviceVariable = (from v in ServiceVariables where v.VariableDto.VariableName == name select v).First(); serviceVariable.VariableDto.CurrentValue = currentValue.ToString(CultureInfo.InvariantCulture); } catch (Exception) { var variableDto = new VariableDto { CurrentValue = currentValue.ToString(CultureInfo.InvariantCulture), VariableName = name, }; serviceVariable = new ServiceVariable(variableDto); ServiceVariables.Add(serviceVariable); } using (var context = new PowerMonitoringModelContainer()) { //ako ne postoji entity na sevicu pogledaj dali variajbla postoji u bazi ako ne postoji kreiraj // provaj je naći u bazi pod imenom ako ne postoji kreiraj Variable variableEnty; try { variableEnty = (from v in context.VariableSet where v.Name == name select v).First(); } catch (Exception) { variableEnty = Variable.CreateVariable(-1, name, _singleTypeString, true); context.AddToVariableSet(variableEnty); context.SaveChanges(); } if (variableEnty == null) { return; } //logiranje if (variableEnty.DataLoggingEnabled) { if (variableEnty.Type == _singleTypeString) { variableEnty.SingleLogSet.Add(SingleLog.CreateSingleLog(-1, currentValue, timeStamp, -1)); } if (variableEnty.Type == _doubleTypeString) { variableEnty.DoubleLogSet.Add(DoubleLog.CreateDoubleLog(-1, currentValue, timeStamp, -1)); } } context.SaveChanges(); AlarmConfig alarmConfiguration = variableEnty.AlarmConfigSet; if (alarmConfiguration == null) { return; } //High if (AlarmTools.UpdateAlarmAndReturnIsActive(currentValue, alarmConfiguration, "HI", alarmConfiguration.HI_LevelChange, alarmConfiguration.HI_Enable, AlarmTools.UsporediHi, context) == false) { AlarmTools.RemoveLowerAlarmIfHigherLevelExist(context, alarmConfiguration, "HI", "HIHI"); } else { AlarmTools.UpdateAcknowladgeFromHigherLevelIfExist(alarmConfiguration, "HI", "HIHI"); } if (AlarmTools.UpdateAlarmAndReturnIsActive(currentValue, alarmConfiguration, "HIHI", alarmConfiguration.HIHI_LevelChange, alarmConfiguration.HIHI_Enable, AlarmTools.UsporediHi, context)) { AlarmTools.RemoveAlarmIfExist(context, alarmConfiguration, "HI"); } //Low if (AlarmTools.UpdateAlarmAndReturnIsActive(currentValue, alarmConfiguration, "LO", alarmConfiguration.LO_LevelChange, alarmConfiguration.LO_Enable, AlarmTools.UsporediLo, context) == false) { AlarmTools.RemoveLowerAlarmIfHigherLevelExist(context, alarmConfiguration, "LO", "LOLO"); } else { AlarmTools.UpdateAcknowladgeFromHigherLevelIfExist(alarmConfiguration, "LO", "LOLO"); } if (AlarmTools.UpdateAlarmAndReturnIsActive(currentValue, alarmConfiguration, "LOLO", alarmConfiguration.LOLO_LevelChange, alarmConfiguration.LOLO_Enabled, AlarmTools.UsporediLo, context)) { AlarmTools.RemoveAlarmIfExist(context, alarmConfiguration, "LO"); } context.SaveChanges(); } }
public void AddRow(VariableDto var) { this.Rows.Add(var.DatabankCode, var.ProductTypeCode, var.VariableCode, var.VariableName); }
public NetVariableViewModel(VariableDto variableDto) { SingleBuffer = new ObservableCollection <VariableSingle>(); Name = variableDto.VariableName; CurrentValue = variableDto.CurrentValue; }
public ServiceVariable(VariableDto variableDto) { VariableDto = variableDto; }