// PUT api/persona/
/// <summary>
/// Servicio para actualizar los datos de una persona
/// </summary>
/// <param name="id"></param>
/// <param name="persona"></param>
/// <returns></returns>
public IHttpActionResult PutActualizaPersona(string id, [FromBody] Persona persona)
{
try
{
var memoryCacher = new MemoryCacher <bool>();
var personas = memoryCacher.GetValue <List <Persona> >("Personas", false);
bool _success = false;
if (personas == null)
{
personas = (new Personas()).listaPersonas;
}
var registro = personas.Where(p => p._id == id).FirstOrDefault();
if (registro != null)
{
MergeObject.Merge <Persona>(registro, persona);
_success = true;
}
memoryCacher.Add("Personas", personas, false);
return(Ok(new { success = _success }));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
public IHttpActionResult PerformMergeQuery([FromBody] MergeObject @object)
{
if (@object == null)
{
throw new ArgumentNullException(nameof(@object));
}
List <string>[] loopkup = new List <string> [3];
string query = $"SELECT DISTINCT t1.{@object.ColumnShow}, t2.{@object.ColumnMf} FROM [dbo].[{@object.FileJoin}] t1 " +
$" RIGHT JOIN [dbo].[{@object.FileInit}] t2 ON t2.{@object.ColumnMf} = t1.{@object.ColumnJoin} " +
$" WHERE t1.{@object.ColumnShow} IS NOT NULL ORDER BY 1 ASC";
var lookup_values = default(List <string>);
var temp2 = default(List <string>);
try
{
using (var con = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["UtOptModel"].ConnectionString))
{
lookup_values = new List <string>();
temp2 = new List <string>();
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
using (var rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (rdr.Read())
{
lookup_values.Add(rdr.GetValue(0).ToString());
temp2.Add(rdr.GetValue(1).ToString());
}
}
}
}
catch (Exception)
{
// lookup_values.Add(string.Empty);
// temp2.Add(string.Empty);
}
// loopkup[0] = lookup_values;
// loopkup[1] = lookup_values;
// loopkup[2] = temp2;
// var _retVal = await db.Database.SqlQuery<DataBaseTableColumnValues>($"SELECT DISTINCT TOP 1000 CONVERT(VARCHAR(max),{fieldValue.FieldName }) AS ColumnValue FROM [dbo].[{fieldValue.TableName}] WITH (NOLOCK);").ToListAsync();
//var query2 = $"SELECT * FROM dbo.reports WHERE generic IS NULL AND source_file= '{@object.FileJoin}' AND mf_column='{@object.ColumnMf}' " +
// $" AND report='{@object.ReportJoin}' AND r_row='{@object.ReportRowJoin}' AND r_column='{@object.ReportColumnJoin}'";
return(Json(new { data = new LookupValues {
Values = lookup_values
} }));
}
static public Polygon2D Merge(Polygon2D polyA, Polygon2D polyB)
{
if (Math2D.PolyCollidePoly(polyA, polyB))
{
MergeObject mergeObject = new MergeObject(polyA, polyB);
return(mergeObject.resultPolygon);
}
return(null);
}
