public AreasList PutAreasUpdate(int areaNumero, AreasList value) { ///<param name="value"> El objeto con los campos necesarios para actualizar </param> ///<param name="areaNumero">El Id del area que será actualizada </param> /// <summary> /// Este metodo se encarga de actualizar un area /// </summary> AreasList areasList = new AreasList(); using (var context = new Octal_GIUContext()) { try { areasList = context.AreasList .FromSql($"exec Areas_List_Update { areaNumero },{ value.SitioNumero },{ value.AreaClienteId },{ value.AreaNombre },{ value.AreaObjetivo },{ value.AreaUnidades },{ value.AreaLatitud },{ value.AreaLongitud },{ value.SeguridadQuien },{value.SeguridadEstado},{ value.SeguridadIp } ") .FirstOrDefault(); return(areasList); } catch (Exception ex) { throw ex; } } }
private async void setupAreas() { AreasList al = await AreasDataProc.LoadAreas(); //Assigning request results and showing them on the listbox foreach (AreasModel am in al.meals) { listBox2.Items.Add(am.strArea); } }
public async Task Init() { var request = await _service.Get <List <EToolService.Model.Models.Area> >(null); foreach (var area in request) { AreasList.Add(area); if (area.AreaName == APIService.Client.AreaName) { SelectedArea = area; } } }
public int?GetLocationIdByRegion(string areaName, string regionName) { var mappedLocation = string.Empty; mappedLocation = GetTargoValue("Location", areaName).ToLower(); if (mappedLocation == "exception") { mappedLocation = GetTargoValue("Location", regionName).ToLower(); } int?idLocation; idLocation = AreasList.Any(x => x.Name.ToLower() == mappedLocation) ? AreasList.FirstOrDefault(x => x.Name.ToLower() == mappedLocation)?.Id : 0; return(idLocation == 0 ? null : idLocation); }
private int?AddPort(string location, int kind, int?idParent) { if (location == "UNKNOWN") { return(null); } var port = new Port() { Name = location, Kind = kind, IdParent = idParent }; string sqlLocation = $"IF (SELECT top 1 Id from [Location] where Name = @name) IS NULL BEGIN INSERT INTO [Location] (Name, Source) VALUES (@name,@_sourceClipper); SELECT CAST(SCOPE_IDENTITY() as int) END ELSE (SELECT top 1 Id from [Location] where Name = @name AND Source = @_sourceClipper)"; string sqlPort = $"INSERT INTO Port (Id, Kind, IdParent) VALUES (@Id,@Kind,@portParent);"; using (var connection = ConnectionFactory.GetOpenConnection()) { if (AreasList.Any(a => a.Name == port.Name)) { return(null); } else { port.Id = connection.Query <int>(sqlLocation, new { port.Name, _sourceClipper }).Single(); } var portParent = (port.IdParent == null ? _portUnallocated.ToString() : port.IdParent.ToString()); if (PortsList.Select(s => s.Id == port.Id).Count() == 0) { connection.Execute(sqlPort, new { port.Id, port.Kind, portParent }); PortsList.Add(port); } } return(port.Id); }
public IActionResult PostArea([FromBody] AreasList values) { ///<param name="value"> El objeto con los campos necesarios para guardar </param> /// <summary> /// Este metodo se encarga de insertar un area /// </summary> ///<returns> Retorna el objeto que se insertó </returns> #region Insertar Area AreasList area = new AreasList(); try { area = _da.PostAreasInsert(values); } catch (Exception e) { return(BadRequest(e.Message)); } return(Ok(area)); #endregion }
public IActionResult PutArea(int id, [FromBody] AreasList values) { ///<param name="value"> El objeto con los campos necesarios para actualizar </param> ///<param name="areaNumero">El Id del area que será actualizada </param> /// <summary> /// Este metodo se encarga de actualizar un area /// </summary> /// <returns> Retorna el objeto actualizado </returns> #region Actualizar un area AreasList area = new AreasList(); try { area = _da.PutAreasUpdate(id, values); } catch (Exception e) { return(BadRequest(e.Message)); } return(Ok(area)); #endregion }
public AreasList PostAreasInsert(AreasList value) { ///<param name="value"> El objeto con los campos necesarios para guardar </param> /// <summary> /// Este metodo se encarga de insertar un area /// </summary> AreasList area = new AreasList(); using (var context = new Octal_GIUContext()) { try { area = context.AreasList .FromSql($"exec Areas_List_Insert { value.AreaNumero },{ value.SitioNumero }, { value.AreaClienteId },{ value.AreaNombre },{ value.AreaObjetivo },{ value.AreaUnidades },{ value.AreaLatitud },{ value.AreaLongitud },{ value.SeguridadQuien },{ value.SeguridadIp }") .FirstOrDefault(); return(area); } catch (Exception ex) { throw ex; } } }