public IHttpActionResult ProjectGeneral(int user)
{
FiltroUser us = new FiltroUser(user);
//convertir precio a float o double y cantidad a int!!
var queryProduct =
"select p.\"PrjCode\" as \"codigo_proyecto\"," +
"\r\np.\"PrjName\" as \"nombre_proyecto\"," +
"\r\np.\"U_Sucursal\" as \"regional\"," +
"\r\np.\"U_PEI_PO\" as \"pei_po\"," +
"\r\np.\"U_UORGANIZA\" as \"unidad_organizacional\"," +
"\r\np.\"ValidTo\" as \"valido_hasta\", p.\"ValidFrom\" " +
"\r\nas \"valido_desde\" from ucatolica.oprj p " +
"\r\nwhere p.\"Active\" = 'Y' " +
"\r\nand p.\"ValidTo\" >= current_date " +
"\r\ngroup by p.\"PrjCode\"," +
"\r\np.\"PrjName\", p.\"U_Sucursal\", p.\"U_PEI_PO\", " +
"\r\np.\"U_UORGANIZA\", p.\"ValidTo\", p.\"ValidFrom\" order by " +
"\r\np.\"PrjCode\", p.\"PrjName\"";
var rawresult = _context.Database.SqlQuery <Project>(queryProduct).ToList();
var AD = new ADClass();
var data = AD.FiltrarRegional(new FiltroUser(user), rawresult.AsQueryable()).ToList();
var formatedData = data.Select(x => new
{
nombre = x.codigo_proyecto + " - " + x.nombre_proyecto,
x.codigo_proyecto,
x.nombre_proyecto,
x.regional,
valido_hasta = x.valido_hasta.ToString("dd/MM/yyyy"),
valido_desde = x.valido_desde.ToString("dd/MM/yyyy"),
});
return(Ok(formatedData));
}
