public HttpResponseMessage Post(Indicadores_Consultas varIndicadores_Consultas) { if (ModelState.IsValid) { var data = "-1"; try { data = Convert.ToString(this.service.Insert(varIndicadores_Consultas)); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_InsIndicadores_Consultas", new JavaScriptSerializer().Serialize(varIndicadores_Consultas), true); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_InsIndicadores_Consultas", new JavaScriptSerializer().Serialize(varIndicadores_Consultas), true); serviceBitacora.Insert(bitacora); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter)); } else { var errors = ModelState.SelectMany(m => m.Value.Errors.Select(err => err.ErrorMessage != string.Empty ? err.ErrorMessage : err.Exception.Message).ToList()).ToList(); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_InsIndicadores_Consultas", new JavaScriptSerializer().Serialize(varIndicadores_Consultas), false, errors.ToString()); serviceBitacora.Insert(bitacora); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } }
public HttpResponseMessage Delete(int id) { Indicadores_Consultas varIndicadores_Consultas = this.service.GetByKey(id, false); bool result = false; if (varIndicadores_Consultas == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } try { result = this.service.Delete(id);//, globalData, dataReference); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, id, BitacoraHelper.TypeSql.DELETE, "sp_DelIndicadores_Consultas", new JavaScriptSerializer().Serialize(varIndicadores_Consultas), result); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, id, BitacoraHelper.TypeSql.DELETE, "sp_DelIndicadores_Consultas", new JavaScriptSerializer().Serialize(varIndicadores_Consultas), result, ex.Message); serviceBitacora.Insert(bitacora); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } return(Request.CreateResponse(HttpStatusCode.OK, result)); }
public HttpResponseMessage Get_Datos_Generales(int id) { Indicadores_Consultas entity = this.service.ListaSelAll(1, 1, "Indicadores_Consultas.Clave='" + id.ToString() + "'", "").Indicadores_Consultass.First(); Indicadores_Consultas result = new Indicadores_Consultas(); result.Clave = entity.Clave; result.Nombre = entity.Nombre; return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter)); }
public HttpResponseMessage PutTunnel(Indicadores_Consultas emp, string user, string password) { var client = new System.Net.WebClient(); client.Headers = TokenManager.GetAuthenticationHeader(user, password); client.Headers["Content-Type"] = "application/json"; var dataString = new JavaScriptSerializer().Serialize(emp); var result = client.UploadString(new Uri(baseApi + ApiControllerUrl + "/Put?Id=" + emp.Clave), "PUT" , dataString); return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter)); }
public HttpResponseMessage Put_Datos_Generales(Indicadores_Consultas varIndicadores_Consultas_Datos_Generales) { var data = "-1"; try { data = Convert.ToString(this.service.Update_Datos_Generales(varIndicadores_Consultas_Datos_Generales)); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varIndicadores_Consultas_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdIndicadores_Consultas", new JavaScriptSerializer().Serialize(varIndicadores_Consultas_Datos_Generales), true); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varIndicadores_Consultas_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdIndicadores_Consultas", new JavaScriptSerializer().Serialize(varIndicadores_Consultas_Datos_Generales), false, ex.Message); serviceBitacora.Insert(bitacora); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter)); }
public HttpResponseMessage Indicadores_ConsultasGenerateID() { Indicadores_Consultas varIndicadores_Consultas = new Indicadores_Consultas(); var data = "-1"; try { data = Convert.ToString(this.service.Insert(varIndicadores_Consultas)); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_Indicadores_ConsultasGenerateID", new JavaScriptSerializer().Serialize(varIndicadores_Consultas), true); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_Indicadores_ConsultasGenerateID", new JavaScriptSerializer().Serialize(varIndicadores_Consultas), true); serviceBitacora.Insert(bitacora); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter)); }