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