Procedure to Search an object in a database, Find a table used in how many Procedures

CREATE PROCEDURE [dbo].[spssearchcode]            

  @text varchar(250),            

  @dbname varchar(64) = 'admin'           

AS BEGIN           

SET NOCOUNT ON;            

            

if @dbname is null           

  Begin           

    --enumerate all databases.            

  DECLARE #db CURSOR FOR Select Name from master..sysdatabases            

  Declare @c_dbname varchar(64)            

            

  OPEN #db FETCH #db INTO @c_dbname            

  While @@FETCH_STATUS <> -1 --and @MyCount < 500            

   Begin           

     execute spssearchcode @text, @c_dbname            

     FETCH #db INTO @c_dbname            

   End              

  CLOSE #db DEALLOCATE #db            

 End --if @dbname is null            

Else           

 begin --@dbname is not null            

  declare @sql varchar(250)            

  --create the find like command            

  select @sql = 'select ''' + @dbname + ''' as db, o.name,m.definition '           

  select @sql = @sql + ' from '+@dbname+'.sys.sql_modules m '           

  select @sql = @sql + ' inner join '+@dbname+'..sysobjects o on m.object_id=o.id'           

  select @sql = @sql + ' where [definition] like ''%'+@text+'%'''           

  execute (@sql)            

 end --@dbname is not null            

END

REDIS Cache with C#, Learning Redis Cache, Capture DataTable into Redis Server

Redis Cache is a key-value cache that stores the information in a hash table format, providing the possibilities to store different types of structured data like strings, hashes, lists, sets, sorted sets, bitmaps and hyperloglogs

1. Install Redis server (redis-server.exe) on your machine

2. Create RedisConnectorHelper class file

    public class RedisConnectorHelper
    {
        static RedisConnectorHelper()
        {
            RedisConnectorHelper.lazyConnection = new Lazy(() =>
            {
                return ConnectionMultiplexer.Connect("localhost");
            });
        }

        private static Lazy lazyConnection;

        public static ConnectionMultiplexer Connection
        {
            get
            {
                return lazyConnection.Value;
            }
        }
    }

3. You will noticed here ConnectionMultiplexer is not found in your application, so add using NuGet Package manager, search "StackExchange.Redis"

4. After installation you are ready to work in Redis application

5. Create the connection object of Redis server like this
    var cache = RedisConnectorHelper.Connection.GetDatabase();

6.  Store your values in this way
     cache.StringSet($"Device_Status:{i}", "value");

7. Retrive Redis/Cached values this way
     var value = cache.StringGet($"Device_Status:{i}");

8.  Some time we need to store DataTable into session/cache object so same we can do in following way.

    Store Values in Redis server:

   
   string TableName = "GetEmpData";

   foreach (DataRow dr in GetEmpData().Rows)
   {
      cache.StringSet($"Device_Status:"+ TableName + "_" +dr["id"].ToString(), string.Format("{0} : {1} : {2} : {3}", dr["Id"].ToString(), dr["Name"].ToString(), dr["Mobile"].ToString(), dr["Date"].ToString()));
   }

    Retrive Values from Redis server:

 
  foreach (DataRow dr in GetEmpData().Rows)
   {
     var value = cache.StringGet($"Device_Status:" + TableName + "_" + dr["id"].ToString());
     Console.WriteLine($"New Valueeeeee={value}");
   }

9. Sample Code Download Here

10. For Details information you can also visit the below link,

https://www.c-sharpcorner.com/UploadFile/2cc834/using-redis-cache-with-C-Sharp/

Find all table names with column name in sql

SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
    JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyCol%';

Check date is valid or not in JavaScript

Find a function to check date is valid or not in Java script

                        /**
                        * Get the number of days in any particular month                       
                        * @param  {integer} m The month (valid: 0-11)
                        * @param  {integer} y The year
                        * @return {integer}   The number of days in the month
                        */
                        var daysInMonth = function (m, y) {
                            switch (m) {
                                case 1:
                                    return (y % 4 == 0 && y % 100) || y % 400 == 0 ? 29 : 28;
                                case 8: case 3: case 5: case 10:
                                    return 30;
                                default:
                                    return 31
                            }
                        };

                        /**
                        * Check if a date is valid                       
                        * @param  {[type]}  d The day
                        * @param  {[type]}  m The month
                        * @param  {[type]}  y The year
                        * @return {Boolean}   Returns true if valid
                        */
                        var isValidDate = function (d, m, y) {                           
                            m = parseInt(m, 10) - 1;
                            return m >= 0 && m < 12 && d > 0 && d <= daysInMonth(m, y);
                        }; 

Calling From Function:-

var bits = tempVal.split('/');
alert(isValidDate(bits[0], bits[1], bits[2]));

Example:-

isValidDate(30, 3, 2013); // March 30, 2013 - true
isValidDate(29, 2, 2013); // February 29, 2013 - false
isValidDate(29, 2, 2012); // February 29, 2012 - true

What in Func in c#

    Func is a generic delegate that encapsulates a method that can accept parameters and return some value

//Annonymous function
Func MyFun1 = delegate(int[] a)
    {
        string tempString = "";
        foreach (int num in a) {
            tempString += num.ToString() + ",";
        }       
        return tempString;
    };



//Generic or Arrow function
    Func MyFun2 = (a) =>
    {
        string tempString = "";
        foreach (float num in a)
        {
            tempString += num.ToString() + ",";
        }
        return tempString;
    };

    private T[] Sort(T[] inputArray)
    {
        //Sort array
        //and return sorted array
        return inputArray;
    }

   int[] numArray = { 10, 15, 26, 98, 68 };
   float[] floatArray = { 10.9F, 15.5F, 26, 98.8F, 68 };
   lblMessage.Text = "Num : " + MyFun1.Invoke(Sort(numArray));
   lblMessage.Text += "Float : " + MyFun2.Invoke(Sort(floatArray));

Compare two dates in javascript

var yearDiff = 100;   
var d = new Date();
    var year = d.getFullYear();
    var month = d.getMonth();
    var day = d.getDate();
    var dtToday = new Date(year - yearDiff , month, day)

    mydate = new Date(DOBDate);
    year = mydate.getFullYear();
    month = mydate.getMonth();
    day = mydate.getDate();
    mydate = new Date(year, month, day);

    if (mydate > dtToday) {
      alert("Age can not be greater than 100 years.");
    }
    else {
        alert("Prev Smaller");
    }

Get Publish page url and title in sitefinity

SELECT sf_page_node.Title_,

  _url_parent =

    CASE WHEN (sf_page_node_2.url_name_ = N'Pages')   THEN '/'

              ELSE sf_page_node_2.url_name_ +'/'

    END,

  sf_page_node.url_name_ AS url_page

FROM

  sf_page_node LEFT OUTER JOIN

  sf_page_node AS sf_page_node_2

  ON sf_page_node.parent_id = sf_page_node_2.id

WHERE (sf_page_node.root_id =

    (

      SELECT id FROM sf_page_node AS sf_page_node_1 WHERE (nme = 'FrontendSiteMap')

     )

   ) AND

  (sf_page_node.show_in_navigation = 1) AND

  (sf_page_node.render_as_link = 1) AND

  (sf_page_node.node_type = 0) AND

  (sf_page_node.approval_workflow_state_ = N'Published')

Query 2:-

SELECT sf_page_node.title_ AS "Page Title", sf_sites.nme AS "Site"

FROM sf_page_node

JOIN sf_sites on sf_page_node.root_id = sf_sites.site_map_root_node_id

WHERE sf_site.nme = 'ProjectName'