Search This Blog

2009-05-06

class HowTo - revised



    using System.Text;
    using System.Diagnostics;
    
    namespace GenApp.Utils.Theory
    {
        /// <summary>
        /// This is fake class for quick copy paste. Usage: 
        /// type HowTo. - the intellisense will display the names you have figured out for each fake method 
        /// select the name from the     , click in it , right button , G , will get you there , 
        /// copy paste the text , Alt + F, C to close and remember to delete the fake call. 
        /// </summary>
        public class HowTo
        {
    
            public static void UseRegexesWithWhiteSpace ()
            {
                //how-to use regexes with white space 
                //                Regex re = new Regex( 
                //                    @"           # This pattern matches Foo
                //                        (?i)     # turn on insensitivity
                //                                 # The Foo bit
                //                        \b(Foo)\b "
                //                , RegexOptions.IgnorePatternWhitespace ) ;
                //                for ( Match m = re.Match( "foo bar Foo" ) ; m.Success ; m = m.NextMatch() ;
    
            } //eof method 
    
    
            public static void DisplayJavaScriptConfirmationDialog ()
            {
                //Active_chkbox.Attributes.Add("OnClick" , "return (confirm('Do you want do disable this user'));");
            } //eof method 
    
            public static void RegisterPageStartUpScript ()
            {
    
                //how-to Page.RegisterStartupScript(@"startup",@"<script>alert('Thank you!');</script>");
                //string JaScript = "<script language=’javascript’> alert('User Details saved successfully') </script> " ;
                //Response.Write( JaScript );
    
            } //eof method RegionsterPageStartUpScript
    
    
            public static void AddCallingMethodNameToDebug ()
            {
                string code = @"
        System.Diagnostics.StackTrace st = new System.Diagnostics.StackTrace();
        string mName = st.GetFrame(1).GetMethod().Name; 
        ";
    
            } //eof method AddCallingMethodNameToDebug
    
    
            public static void SettersAndGetters ()
            {
                string help = @"
    how-to generate those in textpad F8 
    how-to Generate member accessors , properties for C# asp.net with textpad 
    how-to setters and getters
    find:^(.*)$
    replace:private string _\1 ; \n public string \1 { \n \t\t get { return _\1 ; } \n \t\t set { _\1 = value ; } \n } //comm -- eof \1 property \n\n 
    find:^(.*) (.*)$
    private string s\1 ; \n public string \1 { \n \t\t get { return s\1 ; } \n \t\t set { s\1 = value ; } \n } //comm -- eof \1 property \n\n
    
    FIND:first remove all the [] from the copy paste of the table create screipt 
    ^\t\[([a-zA-Z_]*)\](.*)$
    FIND type and var
    ^(.*) (.*)$
    REPLACE Properties
    #region \2 \n private \1 _\2 ; \npublic \1 \2 { \n \t\t get { return _\2 ; } \n \t\t set { _\2 = value ; } \n } //eof property \2 \n\n\n #endregion \2 \n\
    
    //for the constructor 
    _\2= this.\2 ;
    
    //for the passing to the constuctor 
    \1 _\2 , 
    
    /* 
    ^(.*) (.*)$
    #region \2 \nprivate List<\1> _\2;\npublic List<\1> \2 { get { return _\2; } set { _\2 = value; } }\n#endregion \2\n\n
    
    ";
    
    
            } //eof method SettersAndGetters
    
    
    
            public static void ListAllDbObjects ()
            {
                /*
                --HOW-TO LIST ALL PROCEDURE IN A DATABASE
                select s.name from sys.objects s where type = 'P' or type='UP'
                -- GET THE GENERATED ONES ONLY 
                 select s.name from sysobjects s where type = 'P' and s.name like '%gsp%'
                --HOW-TO LIST ALL TRIGGERS BY NAME IN A DATABASE
                select s.name from sysobjects s where type = 'TR'
                --HOW-TO LIST TABLES IN A DATABASE 
                select s.name from sysobjects s where type = 'U'
                --how-to list all system tables in a database
                select s.name from sysobjects s where type = 's'
                --how-to list all the views in a database
                select s.name from sysobjects s where type = 'v'
    
    
                Similarly you can find out other objects created by user, simple change type = 
    
                C = CHECK constraint 
    
                D = Default or DEFAULT constraint 
    
                F = FOREIGN KEY constraint 
    
                L = Log 
    
                FN = Scalar function 
    
                IF = In-lined table-function 
    
                P = Stored procedure 
    
                PK = PRIMARY KEY constraint (type is K) 
    
                RF = Replication filter stored procedure
    
                S = System table 
    
                TF = Table function 
    
                TR = Trigger 
    
                U = User table ( this is the one I discussed above in the example)
    
                UQ = UNIQUE constraint (type is K) 
    
                V = View 
    
                X = Extended stored procedure
                */
            } //eof method 
    
            public static void GetProcedureMetaData ()
            {
                string answer = @"
        select PARAMETER_NAME as 'COLUMN_NAME', DATA_TYPE ,  CHARACTER_MAXIMUM_LENGTH AS 'MAX_LENGTH', IS_RESULT , PARAMETER_MODE  from INFORMATION_SCHEMA.PARAMETERS where SPECIFIC_NAME='Login_Check'
        Select * from INFORMATION_SCHEMA.Routines --returns stored procedures and functions
    
        exec sp_HelpText 'Login_Check'
    
        ";
                answer = string.Empty;
    
            } //eof method 
    
    
            public static void GetRowColumnValuesFromDs ()
            {
                //(ds.Tables["TableName"].Rows[0]["ColumnName"] == DBNull.Value) ? false : (bool)ds.Tables["TableName"].Rows[0]["ColumnName"]; 
    
            } //eof method 
    
            public static void CopyMeAsTemplateMethod ()
            { } //eof method 
    
            public static void ReflectionExample ()
            {
    
                //Type objectType = testObject.GetType();
    
                //ConstructorInfo[] info = objectType.GetConstructors();
                //MethodInfo[] methods = objectType.GetMethods();
    
                //// get all the constructors
                //Console.WriteLine("Constructors:");
                //foreach (ConstructorInfo cf in info)
                //{
                //  Console.WriteLine(cf);
                //}
    
                //Console.WriteLine();
                //// get all the methods
                //Console.WriteLine("Methods:");
                //foreach (MethodInfo mf in methods)
                //{
                //  Console.WriteLine(mf);
                //}
    
    
    
    
            }
    
    
    
    
            public static void shortcuts ()
            {
                string _shortcuts =
    
                @"
        //how-to shortcuts 
    
    
        Ctrl + Shift + F -- recursive find 
        F3 -- find next occurence
        Ctrl + H -- find and replace
        Ctrl + M + M -- collapse method 
        Ctrl + B --- set a break point 
        CTRL + “-” and CTRL + SHIFT + “-” -- web browser like backward and forward in code
        Ctrl + Tab --- shift tabs
        Shift + F5 --- stop debugging 
        Ctrl + I --- fast search 
        F5 -- start debugging
        Tryf = try and finally block
        Prop = property with get and set accessor
        Switch = switch statement with default
        Alt + W , L -- close all windows 
        Alt + W , 1 -- open the first window
        Alt + F , F , 1 -- open the latest file I closed 
        Ctrl + F2 , Tab -- go to the methods dropdown , type a letter to get to the name of the method 
        Alt + L --- select the Solution Explorer
        Ctrl + Shift + Z --  press 2 (needs arsclip (google download arsclip)) -- get the second latest entry from my clipboard
    
    
        ";
    
            } //eof shortcuts
    
    
            public static void redirectToCurrentUrl ()
            {
                string _redirectToCurrentUrl =
                @"
    
        Response.Redirect ( System.IO.Path.GetFileName ( System.Web.HttpContext.Current.Request.Url.AbsolutePath ) , false );
    
        ";
            } //eof method 
    
    
            public static void formTypes ()
            {
                string _formTypes =
                @" 
        //how-to forms 1 - Empty Search Form , 2 - Filled Form , 3 - Empty New form ( new Margin Data , new Project )
        //how-to formTypes 
        //, 4 - filled search form from get by id procedure 
        // 5 - FilledSearchForm (coming from params)
    
        ";
            } //eof formTypes 
    
            public static void GetTheFileNameWithoutTheExtension ()
            {
                /*                    
                System.IO.Path.GetFileNameWithoutExtension ( System.Web.HttpContext.Current.Request.Url.AbsolutePath ) );
                 */
    
    
            } //eof methoed 
    
    
            public static void GetThePhysicalRootPathNoExtension ()
            {
                //how-to get the physical root path on the file system of the application 
                //Utils.Dbg.Debugger.WriteIf ( "My rootPath is " + rootPath );
            } //eof method 
    
            public static void AccessConfVariables ()
            {
                //how-to access conf variables BL.Conf.Instance.Vars [ "varName" ] would give you "theVarName ;
            } //eof method 
    
            public static void GetRowColumnValue ()
            {
                //how-to get row column value 
                //(ds.Tables["TableName"].Rows[0]["ColumnName"] == DBNull.Value ) ? false : (bool)ds.Tables["TableName"].Rows[0]["ColumnName"] ; 
    
            } //eof method 
    
    
            public static void GenerateExtendedPropertiesForATable ()
            {
    
                //table column
                //find:^(.*) (.*)$
                //Replace:
                //EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'title="\2",visible="1",fs="Basic Details",readonly="1"' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'\1', @level2type=N'COLUMN',@level2name=N'\2'
            } //eof method 
    
    
    
            public static void RedirectToTheCurrentURL ()
            {
                //how-to redirect to current url = users.aspx or projects.aspx 
                /*
    
                Response.Redirect( System.IO.Path.GetFileName ( System.Web.HttpContext.Current.Request.Url.AbsolutePath ) , false );
    
                 */
            } //eof method 
    
            public static void THEORY ()
            {
                //EVENTS AND DELEGATES IN ASP.NET -- http://msdn.microsoft.com/en-us/library/17sde2xt.aspx
    
            } //eof method 
    
    
            public static void ReplaceDebugging ()
            {
                /* find : replace 
            ^(.*)([^\/\/])(Utils\.Debugger)
            \t\t\t\t\t//Utils.Dbg.Debugger
                 */
            }
    
            public static void UseStringBuilderInsteadOfString ()
            {
                //Bad
                string s = "This ";
                s += "is ";
                s += "not ";
                s += "the ";
                s += "best ";
                s += "way.";
    
                //Good:
                StringBuilder sb = new StringBuilder ();
                sb.Append ( "This " );
                sb.Append ( "is " );
                sb.Append ( "much " );
                sb.Append ( "better. " );
    
            } //eof method 
    
    
            public static void AssignValueIfNotNull ( string SomeValue )
            {
                //Long
                SomeObject SomeObject = new SomeObject ();
                if (SomeValue == null)
                    SomeObject.Value = null;
                else
                    SomeObject.Value = SomeValue;
    
                //Instead of this:
                SomeObject.Value = SomeValue ?? null;
            }
    
    
            public static void MeasureMethodPerformance ()
            {//source:http://stackoverflow.com/questions/28637/is-datetime-now-the-best-way-to-measure-a-functions-performance
                Stopwatch sw = new Stopwatch ();
                sw.Start ();
                // Do Work
                sw.Stop ();
                string StrDebug = string.Format ( "Elapsed time: {0}", sw.Elapsed.TotalMilliseconds );
                //Utils.Dbg.Debugger.WriteIf ( StrDebug );
            } //eof method 
    
    
            public static void GenerateResxFileOutOfListing ()
            {
    /*
    FIND:
    ^(.*)$
    REPLACE:
    <data name="\1" xml:space="preserve"> \n <value>value</value>\n <comment>comment</comment> \n</data>\n
    
    
    */
            
            } //eof method 

        public static void InsertCodeSnippet ()
        {

          /*CopyPasteTheFollowingCode into this folder (your milleage may vary ; )
           * C:\Users\%userName%\Documents\Visual Studio 2008\Code Snippets\Visual C#\My Code Snippets
           * Save it as a file with the same title and type *.snippet
           <CodeSnippets
              xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
              <CodeSnippet Format="1.0.0">
                  <Header>
                      <Title>
                         ThisIsTheTitleVisibleForIntellisense
                      </Title>
                  </Header>
                  <Snippet>
                      <Code Language="CSharp">
                          <![CDATA[
                
                          Put the code here 
                
                          ]]>
                      </Code>
                  </Snippet>
              </CodeSnippet>
          </CodeSnippets>
          Use by : Type CTRL+K, CTRL+X, arrows to navigate , 
                     */

        }
        } //eof class 
            public class SomeObject
        {
            public string Value { get; set; }
        } //eof class 
    } //eof namespace

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) git cheat sheet (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scala ScalaFmt (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smtp (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List

VideoBar

This content is not yet available over encrypted connections.