/*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...
Thursday, 10 December 2015
Wednesday, 2 December 2015
Localization in DNN
string CultureCode = Thread.CurrentThread.CurrentCulture.ToString();
<%= Localization.GetString("Actions", Localization.GetResourceFile(this, "SearchResults.ascx")) %>
<%= 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
Then create the stored procedure
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
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
- Installing the USER_SDO_EDIT_SESSIONS View
- Making a MapViewer Data Source Editable
- Launching the MapViewer Editor and Logging In
- Selecting a Data Source and Creating a New Session
- 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); } } }
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;
}
}
}
}
Subscribe to:
Comments (Atom)