public HttpResponseMessage Post(Nombre_del_campo_en_MS varNombre_del_campo_en_MS) { if (ModelState.IsValid) { var data = "-1"; try { data = Convert.ToString(this.service.Insert(varNombre_del_campo_en_MS)); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_InsNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), true); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_InsNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), 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_InsNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), false, errors.ToString()); serviceBitacora.Insert(bitacora); return(Request.CreateResponse(HttpStatusCode.BadRequest, errors)); } }
public HttpResponseMessage Delete(int id) { Nombre_del_campo_en_MS varNombre_del_campo_en_MS = this.service.GetByKey(id, false); bool result = false; if (varNombre_del_campo_en_MS == 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_DelNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), result); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, id, BitacoraHelper.TypeSql.DELETE, "sp_DelNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), 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) { Nombre_del_campo_en_MS entity = this.service.ListaSelAll(1, 1, "Nombre_del_campo_en_MS.Clave='" + id.ToString() + "'", "").Nombre_del_campo_en_MSs.First(); Nombre_del_campo_en_MS result = new Nombre_del_campo_en_MS(); result.Clave = entity.Clave; result.Descripcion = entity.Descripcion; result.Nombre_Fisico_del_Campo = entity.Nombre_Fisico_del_Campo; result.Nombre_Fisico_de_la_Tabla = entity.Nombre_Fisico_de_la_Tabla; return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter)); }
public HttpResponseMessage PutTunnel(Nombre_del_campo_en_MS 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(Nombre_del_campo_en_MS varNombre_del_campo_en_MS_Datos_Generales) { var data = "-1"; try { data = Convert.ToString(this.service.Update_Datos_Generales(varNombre_del_campo_en_MS_Datos_Generales)); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varNombre_del_campo_en_MS_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS_Datos_Generales), true); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varNombre_del_campo_en_MS_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdNombre_del_campo_en_MS", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS_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 Nombre_del_campo_en_MSGenerateID() { Nombre_del_campo_en_MS varNombre_del_campo_en_MS = new Nombre_del_campo_en_MS(); var data = "-1"; try { data = Convert.ToString(this.service.Insert(varNombre_del_campo_en_MS)); var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_Nombre_del_campo_en_MSGenerateID", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), true); serviceBitacora.Insert(bitacora); } catch (ServiceException ex) { var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_Nombre_del_campo_en_MSGenerateID", new JavaScriptSerializer().Serialize(varNombre_del_campo_en_MS), true); serviceBitacora.Insert(bitacora); return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter)); }