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;
}
