public HttpResponseMessage Get([FromUri] int Id, [FromUri] string[] include, [FromUri] bool indent = false)
{
try {
var formatter = new MaxDepthJsonMediaTypeFormatter()
{
Indent = indent
};
if (include.Length > 0)
{
formatter.SerializerSettings.MaxDepth = 100; //include.Max<string>(s => s.Split('.').Length * 5);
formatter.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.Objects;
}
else
{
formatter.SerializerSettings.MaxDepth = 1;
}
Usuario usuario = usuarioRepository.GetById(include, (p => p.Id == Id));
if (usuario == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
return(Request.CreateResponse <Usuario>(HttpStatusCode.OK, usuario, formatter));
} catch (Exception _excepcion) {
log.Error(_excepcion);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, _excepcion));
}
}
public HttpResponseMessage GetQuery([FromUri] string query, [FromUri] object[] parameter, [FromUri] bool indent = false, [FromUri] TiposRetorno tipoRetorno = TiposRetorno.Json)
{
try {
var formatter = new MaxDepthJsonMediaTypeFormatter()
{
Indent = indent
};
formatter.SerializerSettings.MaxDepth = 1;
List <dynamic> _listaResultados = CollectorsClubEntities.ExecuteCommand(query, Enumerable.Select(parameter, p => new SqlParameter("@" + p.ToString().Split('|')[0], (SqlDbType)Enum.Parse(typeof(SqlDbType), p.ToString().Split('|')[1], true))
{
Size = (p.ToString().Split('|').Length > 3 && !string.IsNullOrEmpty(p.ToString().Split('|')[3]) ? int.Parse(p.ToString().Split('|')[3]) : 0), Value = ((p.ToString().Split('|')[2] != string.Empty ? p.ToString().Split('|')[2] : null) ?? (object)DBNull.Value)
}).ToArray <SqlParameter>(), CommandType.StoredProcedure, ((UsuarioRepository)usuarioRepository).DataContext.Database.Connection.ConnectionString);
if (_listaResultados == null)
{
_listaResultados = new List <dynamic>();
}
switch (tipoRetorno)
{
case TiposRetorno.Json: return(Request.CreateResponse(HttpStatusCode.OK, _listaResultados));
case TiposRetorno.Excel: return(Request.CreateResponse(HttpStatusCode.OK, Utilidades.GenerarExcel((IEnumerable <object>)_listaResultados)));
}
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "No se ha podido efectuar acción"));
} catch (Exception _excepcion) {
log.Error(_excepcion);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, _excepcion));
}
}
public HttpResponseMessage Get([FromUri] int Id, [FromUri] string cultura, [FromUri] string[] include, [FromUri] bool indent = false)
{
try {
var formatter = new MaxDepthJsonMediaTypeFormatter()
{
Indent = indent
};
if (include.Length > 0)
{
formatter.SerializerSettings.MaxDepth = 100; //include.Max<string>(s => s.Split('.').Length * 5);
formatter.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.Objects;
}
else
{
formatter.SerializerSettings.MaxDepth = 1;
}
Video _video = videoRepository.GetById(include, (p => p.Id == Id));
if (cultura != Localizacion.CulturaPorDefecto)
{
Video_Idioma _videoIdioma = video_IdiomaRepository.GetMany(p => p.IdRegistro == Id && p.Cultura == cultura).FirstOrDefault();
// Campos multiidioma
if (_videoIdioma != null)
{
_video.Nombre = _videoIdioma.Nombre;
_video.Descripcion = _videoIdioma.Descripcion;
_video.Url = _videoIdioma.Url;
}
}
if (_video == null)
{
throw new HttpResponseException(HttpStatusCode.NotFound);
}
return(Request.CreateResponse <Video>(HttpStatusCode.OK, _video, formatter));
} catch (Exception _excepcion) {
log.Error(_excepcion);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, _excepcion));
}
}
public HttpResponseMessage Get([FromUri] string[] include, [FromUri] bool indent = false)
{
try {
var formatter = new MaxDepthJsonMediaTypeFormatter()
{
Indent = indent
};
if (include.Length > 0)
{
formatter.SerializerSettings.MaxDepth = 100; //include.Max<string>(s => s.Split('.').Length * 5);
formatter.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.Objects;
}
else
{
formatter.SerializerSettings.MaxDepth = 1;
}
return(Request.CreateResponse <IQueryable <Usuario> >(HttpStatusCode.OK, usuarioRepository.GetAll(include).AsQueryable(), formatter));
} catch (Exception _excepcion) {
log.Error(_excepcion);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, _excepcion));
}
}
public HttpResponseMessage GetPorFiltros(string idMarca, string nombre, [FromUri] string[] include, [FromUri] bool indent = false)
{
try {
var formatter = new MaxDepthJsonMediaTypeFormatter()
{
Indent = indent
};
if (include.Length > 0)
{
formatter.SerializerSettings.MaxDepth = 100; //include.Max<string>(s => s.Split('.').Length * 5);
formatter.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.Objects;
}
else
{
formatter.SerializerSettings.MaxDepth = 1;
}
return(Request.CreateResponse <IQueryable <CategoriaCalendario> >(HttpStatusCode.OK, categoriacalendarioRepository.GetMany(r => r.IdMarca == idMarca && (nombre == null || r.Nombre.Contains(nombre))).AsQueryable(), formatter));
} catch (Exception _excepcion) {
log.Error(_excepcion);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, _excepcion));
}
}
public HttpResponseMessage GetList([FromUri] short[] id, [FromUri] string[] include, [FromUri] bool indent = false)
{
try {
var formatter = new MaxDepthJsonMediaTypeFormatter()
{
Indent = indent
};
if (include.Length > 0)
{
formatter.SerializerSettings.MaxDepth = 100; //include.Max<string>(s => s.Split('.').Length * 5);
formatter.SerializerSettings.PreserveReferencesHandling = Newtonsoft.Json.PreserveReferencesHandling.Objects;
}
else
{
formatter.SerializerSettings.MaxDepth = 1;
}
return(Request.CreateResponse <IEnumerable <CategoriaCalendario> >(HttpStatusCode.OK, categoriacalendarioRepository.GetMany(include, (p => id.Contains(p.Id))), formatter));
} catch (Exception _excepcion) {
log.Error(_excepcion);
return(Request.CreateResponse(HttpStatusCode.InternalServerError, _excepcion));
}
}