示例#1
0
        public IHttpActionResult ClientesNoMayores(ClientesNoMayores usr)
        {
            try
            {
                var resp = new _01_Dal.Dal.Metodos().BuscarUsuarioNoMayores(usr);

                return(Ok(resp));
            }

            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
示例#2
0
        public IEnumerable <ClientesNoMayores> BuscarUsuarioNoMayores(ClientesNoMayores ObjUser)
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConCC"].ToString());

            try
            {
                using (IDbConnection db = conn)
                {
                    var p = new DynamicParameters();

                    p.Add("@fchInicioVenta", ObjUser.fchInicioVenta, dbType: DbType.Date, direction: ParameterDirection.Input);
                    p.Add("@fchFinVenta", ObjUser.fchFinVenta, dbType: DbType.Date, direction: ParameterDirection.Input);


                    return(db.Query <ClientesNoMayores>("spConsultaClientesNoMayores", p, commandType: CommandType.StoredProcedure).AsList());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }