Example #1
0
 /// <summary>
 /// Cria um registro na tabela Caixa(tblCaixa).
 /// </summary>
 /// <param name="Obj">Objeto Caixa</param>
 public void DeleteRevendedor(ENRevendedor Obj)
 {
     SqlConnection _con = new SqlConnection(ConfigurationManager.ConnectionStrings["PipiConnection"].ConnectionString);
     SqlCommand _cmd = new SqlCommand("sprRevendedorCRUD", _con);
     _cmd.CommandType = CommandType.StoredProcedure;
     _cmd.Parameters.AddWithValue("@sprstrOperacao", "D");
     _cmd.Parameters.AddWithValue("@sprintEspecificoR", 0);
     _cmd.Parameters.AddWithValue("@sprintIdRevendedor", Obj.IdRevendedor);
     _cmd.Parameters.AddWithValue("@sprstrNome", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrEndereco", string.Empty);
     _cmd.Parameters.AddWithValue("@strintNumero", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrBairro", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrCidade", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrEstado", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrCep", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrTelefone", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrCelular", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrFax", string.Empty);
     _cmd.Parameters.AddWithValue("@sprstrEmail", string.Empty);
     try
     {
         _con.Open();
         _cmd.ExecuteNonQuery();
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         _con.Close();
     }
 }
Example #2
0
 /// <summary>
 /// Atualiza um Revendedor
 /// </summary>
 /// <param name="Obj">ENRevendedor Obj</param>
 public void UpdateRevendedor(ENRevendedor Obj)
 {
     if (Obj.StrTelefone == null)
     {
         Obj.StrTelefone = string.Empty;
     }
     if (Obj.StrCelular == null)
     {
         Obj.StrCelular = string.Empty;
     }
     if (Obj.StrFax == null)
     {
         Obj.StrFax = string.Empty;
     }
     if (Obj.StrEmail == null)
     {
         Obj.StrEmail = string.Empty;
     }
     (new DARevendedor()).UpdateRevendedor(Obj);
 }
Example #3
0
 /// <summary>
 /// Apaga um Revendedor
 /// </summary>
 /// <param name="Obj">ENRevendedor Obj</param>
 public void DeleteRevendedor(ENRevendedor Obj)
 {
     (new DARevendedor()).DeleteRevendedor(Obj);
 }
Example #4
0
        /// <summary>
        /// Seleciona uma lista de Revendedores de acordo com os parĂ¢metros
        /// </summary>
        /// <param name="EspecificoR">int EspecificoR</param>
        /// <returns>ENRevendedor</returns>
        public List<ENRevendedor> ReadAllRevendedor(int EspecificoR, int idRevendedor)
        {
            List<ENRevendedor> _objs = new List<ENRevendedor>();
            SqlConnection _con = new SqlConnection(ConfigurationManager.ConnectionStrings["PipiConnection"].ConnectionString);
            SqlCommand _cmd = new SqlCommand("sprRevendedorCRUD", _con);
            _cmd.CommandType = CommandType.StoredProcedure;
            _cmd.Parameters.AddWithValue("@sprstrOperacao", "R");
            _cmd.Parameters.AddWithValue("@sprintEspecificoR", EspecificoR);
            _cmd.Parameters.AddWithValue("@sprintIdRevendedor", idRevendedor);
            _cmd.Parameters.AddWithValue("@sprstrNome", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrEndereco", string.Empty);
            _cmd.Parameters.AddWithValue("@strintNumero", 0);
            _cmd.Parameters.AddWithValue("@sprstrBairro", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrCidade", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrEstado", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrCep", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrTelefone", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrCelular", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrFax", string.Empty);
            _cmd.Parameters.AddWithValue("@sprstrEmail", string.Empty);
            _con.Open();

            SqlDataReader rd = _cmd.ExecuteReader(CommandBehavior.CloseConnection);

            try
            {
                while (rd.Read())
                {
                    ENRevendedor NewObj = new ENRevendedor();
                    NewObj.IdRevendedor = Convert.ToInt32(rd[0].ToString());
                    NewObj.StrNome = rd[1].ToString();
                    NewObj.StrEndereco = rd[2].ToString();
                    NewObj.IntNumero = Convert.ToInt32(rd[3].ToString());
                    NewObj.StrBairro = rd[4].ToString();
                    NewObj.StrCidade = rd[5].ToString();
                    NewObj.StrEstado = rd[6].ToString();
                    NewObj.StrCep = rd[7].ToString();
                    NewObj.StrTelefone = rd[8].ToString();
                    NewObj.StrCelular = rd[9].ToString();
                    NewObj.StrFax = rd[10].ToString();
                    NewObj.StrEmail = rd[11].ToString();
                    _objs.Add(NewObj);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                rd.Close();
            }
            return _objs;
        }