public HttpResponseMessage Post(Suplementos varSuplementos)
        {
            if (ModelState.IsValid)
            {
                var data = "-1";
                try
                {
                    data = Convert.ToString(this.service.Insert(varSuplementos));
                    var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_InsSuplementos", new JavaScriptSerializer().Serialize(varSuplementos), true);
                    serviceBitacora.Insert(bitacora);
                }
                catch (ServiceException ex)
                {
                    var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_InsSuplementos", new JavaScriptSerializer().Serialize(varSuplementos), 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_InsSuplementos", new JavaScriptSerializer().Serialize(varSuplementos), false, errors.ToString());
                serviceBitacora.Insert(bitacora);
                return(Request.CreateResponse(HttpStatusCode.BadRequest, errors));
            }
        }
        public HttpResponseMessage Delete(int id)
        {
            Suplementos varSuplementos = this.service.GetByKey(id, false);
            bool        result         = false;

            if (varSuplementos == 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_DelSuplementos", new JavaScriptSerializer().Serialize(varSuplementos), result);
                serviceBitacora.Insert(bitacora);
            }
            catch (ServiceException ex)
            {
                var bitacora = BitacoraHelper.GetBitacora(Request, object_id, id, BitacoraHelper.TypeSql.DELETE, "sp_DelSuplementos", new JavaScriptSerializer().Serialize(varSuplementos), result, ex.Message);
                serviceBitacora.Insert(bitacora);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
            }

            return(Request.CreateResponse(HttpStatusCode.OK, result));
        }
        public ActionResult Post(bool IsNew, SuplementosModel varSuplementos)
        {
            try
            {
                //if (ModelState.IsValid)
                //{
                if (!_tokenManager.GenerateToken())
                {
                    return(Json(null, JsonRequestBehavior.AllowGet));
                }
                _ISuplementosApiConsumer.SetAuthHeader(_tokenManager.Token);



                var result          = "";
                var SuplementosInfo = new Suplementos
                {
                    Clave         = varSuplementos.Clave
                    , Descripcion = varSuplementos.Descripcion
                };

                result = !IsNew?
                         _ISuplementosApiConsumer.Update(SuplementosInfo, null, null).Resource.ToString() :
                             _ISuplementosApiConsumer.Insert(SuplementosInfo, null, null).Resource.ToString();

                Session["KeyValueInserted"] = result;
                return(Json(result, JsonRequestBehavior.AllowGet));
                //}
                //return Json(false, JsonRequestBehavior.AllowGet);
            }
            catch (ServiceException ex)
            {
                return(Json(false, JsonRequestBehavior.AllowGet));
            }
        }
        public HttpResponseMessage Get_Datos_Generales(int id)
        {
            Suplementos entity = this.service.ListaSelAll(1, 1, "Suplementos.Clave='" + id.ToString() + "'", "").Suplementoss.First();
            Suplementos result = new Suplementos();

            result.Clave       = entity.Clave;
            result.Descripcion = entity.Descripcion;

            return(Request.CreateResponse(HttpStatusCode.OK, result, Configuration.Formatters.JsonFormatter));
        }
        public HttpResponseMessage PutTunnel(Suplementos 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(Suplementos varSuplementos_Datos_Generales)
        {
            var data = "-1";

            try
            {
                data = Convert.ToString(this.service.Update_Datos_Generales(varSuplementos_Datos_Generales));
                var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varSuplementos_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdSuplementos", new JavaScriptSerializer().Serialize(varSuplementos_Datos_Generales), true);
                serviceBitacora.Insert(bitacora);
            }
            catch (ServiceException ex)
            {
                var bitacora = BitacoraHelper.GetBitacora(Request, object_id, varSuplementos_Datos_Generales.Clave, BitacoraHelper.TypeSql.UPDATE, "sp_UpdSuplementos", new JavaScriptSerializer().Serialize(varSuplementos_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 SuplementosGenerateID()
        {
            Suplementos varSuplementos = new Suplementos();
            var         data           = "-1";

            try
            {
                data = Convert.ToString(this.service.Insert(varSuplementos));
                var bitacora = BitacoraHelper.GetBitacora(Request, object_id, Convert.ToInt32(data), BitacoraHelper.TypeSql.INSERT, "sp_SuplementosGenerateID", new JavaScriptSerializer().Serialize(varSuplementos), true);
                serviceBitacora.Insert(bitacora);
            }
            catch (ServiceException ex)
            {
                var bitacora = BitacoraHelper.GetBitacora(Request, object_id, 0, BitacoraHelper.TypeSql.INSERT, "sp_SuplementosGenerateID", new JavaScriptSerializer().Serialize(varSuplementos), true);
                serviceBitacora.Insert(bitacora);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message));
            }

            return(Request.CreateResponse(HttpStatusCode.OK, data, Configuration.Formatters.JsonFormatter));
        }
        public ActionResult Delete(int id)
        {
            try
            {
                if (!_tokenManager.GenerateToken())
                {
                    return(Json(null, JsonRequestBehavior.AllowGet));
                }
                _ISuplementosApiConsumer.SetAuthHeader(_tokenManager.Token);

                Suplementos varSuplementos = null;
                if (id.ToString() != "0")
                {
                    string where = "";
                }
                var result = _ISuplementosApiConsumer.Delete(id, null, null).Resource;
                return(Json(result, JsonRequestBehavior.AllowGet));
            }
            catch (ServiceException ex)
            {
                return(Json(false, JsonRequestBehavior.AllowGet));
            }
        }