Media Screens

  /*Large Screens*/
    @media only screen and (min-width : 1824px) {
    }
    /*Laptop and Desktop*/
    @media only screen and (min-width : 1224px) {
    }  
    /* iPad*/
    @media only screen and (min-device-width : 768px) and (max-device-width : 1024px) {
    }
    /*iPad landscape*/
    @media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : landscape) {
    }
    /*iPad Portrate*/
    @media only screen and (min-device-width : 768px) and (max-device-width : 1024px) and (orientation : portrait) {
    }  
    /*Smartphones Screens*/
    @media only screen and (min-device-width : 320px) and (max-device-width : 568px) {
    }
    /*Smartphones landscape*/
    @media only screen and (min-device-width : 320px) and (max-device-width : 568px) and (orientation : landscape) {
    }
     /*Smartphones Portrate*/
    @media only screen and (min-device-width : 320px) and (max-device-width : 568px) and (orientation : portrait) {
    }


....To be continue...

Localization in DNN

string CultureCode = Thread.CurrentThread.CurrentCulture.ToString();


  <%= Localization.GetString("Actions", Localization.GetResourceFile(this, "SearchResults.ascx")) %>

get Reourse File as JSON

string getReourseFileAsJSON(String resourceFileName)

        {

            try

            {

                string mapResString = "localizedString={'userLang':'" + m_UserInfo.UserLanguge + "',";

                ResXResourceReader rsxr = new ResXResourceReader(

                String.Format("{0}{1}\\{2}", System.AppDomain.CurrentDomain.BaseDirectory.ToString(), "App_GlobalResources", resourceFileName));

                foreach (DictionaryEntry d in rsxr)

                {

                    mapResString += "'" + d.Key.ToString() + "':'" + d.Value.ToString() + "',";

                }

                mapResString += "};";

                return mapResString;

            }

            catch

            {

                return "File Not Found";

            }

        }

Pass String Array to stored procedure

Split function to split array of integers values

if object_id('Split') is not null

    drop function split

go

create function dbo.Split

(

    @String varchar(max)

)

returns @SplittedValues table

(

    Id int primary key

)

as

begin

    declare @SplitLength int, @Delimiter varchar(5)

    set @Delimiter = ','

    while len(@String) > 0

    begin

        select @SplitLength = (case charindex(@Delimiter,@String) when 0 then

            len(@String) else charindex(@Delimiter,@String) -1 end)

        insert into @SplittedValues

        select convert(int, substring(@String,1,@SplitLength) )

        select @String = (case (len(@String) - @SplitLength) when 0 then  ''

            else right(@String, len(@String) - @SplitLength - 1) end)

    end

return 

end

Then create the  stored procedure 

CREATE PROCEDURE getLastInsertedRecods

       -- Add the parameters for the stored procedure here

       @currentDate as datetime,

       @carServiceIds as varchar

AS

BEGIN

       -- SET NOCOUNT ON added to prevent extra result sets from

       -- interfering with SELECT statements.

       SET NOCOUNT ON;

    -- Insert statements for procedure here

      

       SELECT TOP 10 carServiceId, position_x, position_y, speed, EngineOn

       FROM Vechile_track

       where dTime>=convert(date,@currentDate) and carServiceId in (select ID from dbo.Split(@carServiceIds))

       ORDER BY dTime ASC

END

mssql search in all tables in

-- To search in all tables content and return a list of tables where the value

-- has been founded

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER   PROCEDURE [dbo].[SearchAllTables]

    @SearchStr NVARCHAR(100)

AS

BEGIN

    -- Create results table with NVARCHAR to support Arabic characters

    CREATE TABLE #Results (

        TableName NVARCHAR(370),

        ColumnName NVARCHAR(128),

        ColumnValue NVARCHAR(MAX),

        PrimaryKeyColumn NVARCHAR(128),

        PrimaryKeyValue NVARCHAR(500)

    )

   

    SET NOCOUNT ON

   

    DECLARE @TableName NVARCHAR(256),

            @ColumnName NVARCHAR(128),

            @SearchStr2 NVARCHAR(110),

            @PKColumn NVARCHAR(128),

            @SQL NVARCHAR(MAX)

   

    SET @TableName = ''

    SET @SearchStr2 = QUOTENAME('%' + @SearchStr + '%', '''')

   

    WHILE @TableName IS NOT NULL

    BEGIN

        SET @ColumnName = ''

        SET @TableName = (

            SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))

            FROM INFORMATION_SCHEMA.TABLES

            WHERE TABLE_TYPE = 'BASE TABLE'

                AND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName

                AND OBJECTPROPERTY(

                    OBJECT_ID(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)),

                    'IsMSShipped'

                ) = 0

        )

       

        -- Get primary key column for current table

        IF @TableName IS NOT NULL

        BEGIN

            SET @PKColumn = (

                SELECT TOP 1 QUOTENAME(cu.COLUMN_NAME)

                FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc

                INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE cu

                    ON tc.CONSTRAINT_NAME = cu.CONSTRAINT_NAME

                    AND tc.TABLE_SCHEMA = cu.TABLE_SCHEMA

                    AND tc.TABLE_NAME = cu.TABLE_NAME

                WHERE tc.CONSTRAINT_TYPE = 'PRIMARY KEY'

                    AND tc.TABLE_SCHEMA = PARSENAME(@TableName, 2)

                    AND tc.TABLE_NAME = PARSENAME(@TableName, 1)

                ORDER BY cu.ORDINAL_POSITION

            )

        END

       

        WHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)

        BEGIN

            SET @ColumnName = (

                SELECT MIN(QUOTENAME(COLUMN_NAME))

                FROM INFORMATION_SCHEMA.COLUMNS

                WHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)

                    AND TABLE_NAME = PARSENAME(@TableName, 1)

                    AND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar', 'text', 'ntext')

                    AND QUOTENAME(COLUMN_NAME) > @ColumnName

            )

           

            IF @ColumnName IS NOT NULL

            BEGIN

                -- Build dynamic SQL with NVARCHAR casting to preserve Arabic characters

                SET @SQL = N'

                    INSERT INTO #Results (TableName, ColumnName, ColumnValue, PrimaryKeyColumn, PrimaryKeyValue)

                    SELECT

                        ''' + @TableName + ''',

                        ''' + @ColumnName + ''',

                        LEFT(CAST(' + @ColumnName + ' AS NVARCHAR(MAX)), 3630),

                        ' + CASE WHEN @PKColumn IS NOT NULL

                                THEN '''' + @PKColumn + ''''

                                ELSE 'NULL'

                           END + ',

                        ' + CASE WHEN @PKColumn IS NOT NULL

                                THEN 'CAST(' + @PKColumn + ' AS NVARCHAR(500))'

                                ELSE 'NULL'

                           END + '

                    FROM ' + @TableName + ' WITH (NOLOCK)

                    WHERE CAST(' + @ColumnName + ' AS NVARCHAR(MAX)) LIKE N' + @SearchStr2

               

                EXEC sp_executesql @SQL

            END

        END

    END

   

    SELECT

        TableName,

        ColumnName,

        ColumnValue,

        PrimaryKeyColumn,

        PrimaryKeyValue

    FROM #Results

    ORDER BY TableName, ColumnName

   

    DROP TABLE #Results

END

GO

Edit map using Oracle Map Editor

1. Installing the USER_SDO_EDIT_SESSIONS View
2. Making a MapViewer Data Source Editable
3. Launching the MapViewer Editor and Logging In
4. Selecting a Data Source and Creating a New Session
5. Adding Data Layers to a Session

RadGrid Reduce the Filter Menu Options

protected void RadGrid1_Init(object sender, System.EventArgs e) { GridFilterMenu menu = RadGrid1.FilterMenu; int i = 0; while (i < menu.Items.Count) { if (menu.Items[i].Text == "NoFilter" ||
menu.Items[i].Text == "Contains" || menu.Items[i].Text == "EqualTo"
|| menu.Items[i].Text == "GreaterThan" ||
menu.Items[i].Text == "LessThan") { i++; } else { menu.Items.RemoveAt(i); } } }

Localizing GridFilterMenu to Arabic

protected void Page_Load(object sender, EventArgs e)

        {

            if (!Page.IsPostBack)

            {

                Telerik.Web.UI.GridFilterMenu menu = RadGrid1.FilterMenu;

                foreach (Telerik.Web.UI.RadMenuItem item in menu.Items)

                {

                    switch (item.Text)

                    {

                        case "NoFilter":

                            item.Text = "بدون فلترة"; break;

                        case "Contains":

                            item.Text = "يحتوي على"; break;

                        case "DoesNotContain":

                            item.Text = "لا يحتوي على"; break;

                        case "StartsWith":

                            item.Text = "يبدأ بـ"; break;

                        case "EndsWith":

                            item.Text = "ينتهي بـ"; break;

                        case "EqualTo":

                            item.Text = "يساوي"; break;

                        case "NotEqualTo":

                            item.Text = "لا يساوي"; break;

                        case "GreaterThan":

                            item.Text = "أكبر من"; break;

                        case "LessThan":

                            item.Text = "أقل من"; break;

                        case "GreaterThanOrEqualTo":

                            item.Text = "أكبر من أو يساوي"; break;

                        case "LessThanOrEqualTo":

                            item.Text = "أقل من أو يساوي"; break;

                        case "Between":

                            item.Text = "بين"; break;

                        case "NotBetween":

                            item.Text = "ليس من بين"; break;

                        case "IsEmpty":

                            item.Text = "فارغ"; break;

                        case "NotIsEmpty":

                            item.Text = "غير فارغ"; break;

                        case "IsNull":

                            item.Text = "لا شيء"; break;

                        case "NotIsNull":

                            item.Text = "بلا لا شيء"; break;

                        case "Custom":

                            item.Text = "مخصص"; break;

                    }

                }

            }

        }