Beispiel #1
0
        // PUT api/<controller>/5
        public int Put(int id, [FromBody] JObject value)
        {
            int intRetorno = -1;

            try
            {
                string strCartao        = (string)value["nm_cartao"];
                double dblLimite        = (double)value["vl_limite"];
                string strBandeira      = (string)value["nm_bandeira"];
                string str4UltDig       = (string)value["nm_4_ult_dig"];
                int    intVencimentoDia = (int)value["vl_vencimento_dia"];
                //int intMelhorDia = (int)value["vl_melhor_dia"];
                int intMelhorDia = -1;
                int intIdUsuario = TokenManager.GetTokenSID(Request.Headers.Authorization.Parameter);

                CartoesDAL dal = new CartoesDAL(System.Configuration.ConfigurationManager.ConnectionStrings["DB_GranaCurta"].ConnectionString);

                intRetorno = dal.updateCartao(id, strCartao, dblLimite, strBandeira, str4UltDig, intVencimentoDia, intMelhorDia, intIdUsuario);
            }
            catch (Exception)
            {
                intRetorno = -1;
            }

            return(intRetorno);
        }
Beispiel #2
0
        // GET api/<controller>/5
        public DataTable Get(int id)
        {
            DataTable dtbRetorno = null;

            try
            {
                int intIdUsuario = TokenManager.GetTokenSID(Request.Headers.Authorization.Parameter);

                CartoesDAL dal = new CartoesDAL(System.Configuration.ConfigurationManager.ConnectionStrings["DB_GranaCurta"].ConnectionString);

                dtbRetorno = dal.getCartao(id, intIdUsuario);
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(dtbRetorno);
        }
Beispiel #3
0
        // DELETE api/<controller>/5
        public int Delete(int id)
        {
            int intRetorno = -1;

            try
            {
                int intIdUsuario = TokenManager.GetTokenSID(Request.Headers.Authorization.Parameter);

                CartoesDAL dal = new CartoesDAL(System.Configuration.ConfigurationManager.ConnectionStrings["DB_GranaCurta"].ConnectionString);

                int intAffecRows = dal.deleteCartao(intIdUsuario, id);

                if (intAffecRows > 0)
                {
                    intRetorno = id;
                }
            }
            catch (Exception)
            {
                intRetorno = -1;
            }

            return(intRetorno);
        }