Thursday, 10 December 2015

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...

Wednesday, 2 December 2015

Localization in DNN

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


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

Wednesday, 11 November 2015

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

Sunday, 1 November 2015

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

Wednesday, 21 October 2015

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

Wednesday, 14 October 2015

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;
                    }
                }
            }

        }