Web Software Factory

Using New Relic insights to analyse alert incidents

2019-02-07T08:52:00.002-08:00

It's possible to analyse your alert you have been configured to know is that configuration had done correctly or not.

Usually, the top management interest about the application performance and how is New Relic raise the flag to the developer's army and how much it takes to solve the issue and how many issues happened in a certain time.

Here I will show you how to integrate your alerts have created with insights to create a nice dashboard give you the ability to analyse each alert policy and alert conditions.

Channel name ==> use the naming convention to name your channel "as you can generally use it for all your alert policies".

Base Url ==> https://insights-collector.newrelic.com/v1/accounts/{account number}/events

Custom Headers

Name ==> X-Insert-Key

Value ==> "how to get the key ==> account settings ==> api keys ==> insights api keys"

The first question mark is the account number you can find it in account setting.
the second question mark is the value of insights API key, you will find the direction in the image below.

Use Custom Payload

Payload ==>

{

"eventType":"alert",

"account_id": "$ACCOUNT_ID",

"account_name": "$ACCOUNT_NAME",

"closed_violations_count_critical": "$CLOSED_VIOLATIONS_COUNT_CRITICAL",

"closed_violations_count_warning": "$CLOSED_VIOLATIONS_COUNT_WARNING",

"condition_id": "$CONDITION_ID",

"condition_name": "$CONDITION_NAME",

"current_state": "$EVENT_STATE",

"details": "$EVENT_DETAILS",

"duration": "$DURATION",

"event_type": "$EVENT_TYPE",

"incident_acknowledge_url": "$INCIDENT_ACKNOWLEDGE_URL",

"incident_id": "$INCIDENT_ID",

"incident_url": "$INCIDENT_URL",

"open_violations_count_critical": "$OPEN_VIOLATIONS_COUNT_CRITICAL",

"open_violations_count_warning": "$OPEN_VIOLATIONS_COUNT_WARNING",

"owner": "$EVENT_OWNER",

"policy_name": "$POLICY_NAME",

"policy_url": "$POLICY_URL",

"runbook_url": "$RUNBOOK_URL",

"severity": "$SEVERITY",

"targets": "$TARGETS",

"timestamp": "$TIMESTAMP",

"violation_callback_url": "$VIOLATION_CALLBACK_URL",

"violation_chart_url": "$VIOLATION_CHART_URL"

}

Payload Type==> json

then you hit the save button.

now you have your webhook channel you can add it to any alert policy to the notification channels.

if any question or inquiry, please contact me anytime.

analytics mobile applications with new relic

2019-02-04T02:23:00.000-08:00

KPI or key performance indicator. help to understand the application behavior.

Also, the marketing team looking for analysing the user behaviour spacially with pages related to payment or order product process.

After research for attaching business information to the mobile application, I found very interesting things:

I believe the namespace has been added and the SDK installed.

For Android:

import com.newrelic.agent.android.instrumentation.Trace;

For IOS:

Objective-C

+[NewRelic startWithApplicationToken:@"<appToken>"] to the top of -application:didFinishLaunchingWithOptions: in your AppDelegate.m

Swift

#import "NewRelicAgent/NewRelic.h"

More information

https://docs.newrelic.com/docs/mobile-monitoring/new-relic-mobile-ios/installation/ios-manual-installation

If we want to track the user for all session we should use Custom Attribute

For Android

NewRelic.setAttribute(string $name, string or float $value)

Examples:

boolean attributeSet = NewRelic.setAttribute("storeId", "NY0531");

boolean userIdWasSet = NewRelic.setUserId("jsmith"); // ç set user already in the new relic framework we can use “advantage”.

Also one more advantage is this method is corresponding with the session Id, that's mean you can track users have got the mobile crash system.

For IOS:

Objective-C

+ (BOOL) setAttribute:(NSString*)name value:(id) value;

Examples:

BOOL attributeSet = [NewRelic setAttribute:@"buildConfiguration" value:@"AppStore-release"];

BOOL attributeSet = [NewRelic setAttribute:@"rate" value:@9999.99];

Swift

NewRelic.setAttribute(name: String!, value: AnyObject!>) -> Bool

Examples:

var attributeSet = NewRelic.setAttribute("buildConfiguration", value: "AppStore-release")

attributeSet = NewRelic.setAttribute("rate", value: 9999.99)

If we want to track variables changes by user, like “price, which action called, and product user has been selected”. We should use Custom Event

For Android

NewRelic.recordCustomEvent(string $eventType, [string $eventName,] map<string, object> $eventAttributes)

Examples:

Map attributes = new HashMap();

attributes.put("make", "Ford");

attributes.put("model", "ModelT");

NewRelic.recordCustomEvent("Car", "Ford Model T", attributes);

NOTE: "Ford Model T" is extra parameter è regardless that additional information if you like.

Second IOS

Objective-C

+ (BOOL) recordCustomEvent:(NSString*)eventType attributes:(NSDictionary*)attributes;

+ (BOOL) recordCustomEvent:(NSString*)eventType name:(NSString*)name attributes:(NSDictionary*)attributes;

Examples:

BOOL eventRecorded = [NewRelic recordCustomEvent:@"eventType"

attributes:@{@"attributeName1": @"value1", @"attributeName2": @2}];

BOOL eventRecorded = [NewRelic recordCustomEvent:@"Vehicle" name:@"1908 Ford ModelT"

attributes:@{@"make":@"Ford", @"model":@"ModelT", @"year": @1908, @"color": @"black", @"mileage": @250000}];

Swift

NewRelic.recordCustomEvent(eventType: String!, attributes:[NSObject : AnyObject]!) -> Bool

NewRelic.recordCustomEvent(eventType: String!, name: String!, attributes:[NSObject : AnyObject]!) -> Bool

Examples:

let eventRecorded = NewRelic.recordCustomEvent("eventType", attributes: ["attributeName1" : "value1", "attributeName2": 2])

let eventRecorded = NewRelic.recordCustomEvent("Vehicle", name:"1908 Ford ModelT", attributes:["make":"Ford", "model":"ModelT", "year": 1908, "color": "black", "mileage": 250000]);

For more information about the difference between Custom Attribute and Custom Event

https://discuss.newrelic.com/t/relic-solution-custom-attributes-vs-custom-events/52656

How to use NRConfig tool to generate custom instrument for new relic

2018-11-15T03:19:00.000-08:00

How to use NRConfig tool to generate custom instrument for new relic

NRConfig is an open source program created to generate to you the customer instrumentation XML file, find the documentation and the source in the link below:
http://pablissimo.github.io/nrconfig/

You can use the attribute decoration [Instrument] in any specific “public, private” method, property and constructor.

If you don’t like to modify the code then you just apply the instrument to the code type, for instance, all public methods, all private methods, and all public and private methods.

How to use the command:

• Point to the EXE NRConfig.

• Define the methods, properties, and constructors.

• Point to the DLL, its include the code you want to track.

• Define the output XML file. Here is an example to how to use it as below:

C:\Directory>nrconfig.exe /f all /i c:\directory\bin\WebApplication1.dll /o c:\test.NewRelic.xml

You can replace “all” by:

all
methods
properties
constructors

Also, you can define public, private by + and –

Example if I need all public methods it will be like:

C:\Directory>nrconfig.exe /f methods+ /i c:\directory\bin\WebApplication1.dll /o c:\test.NewRelic.xml

Example if I need all private methods it will be like:

C:\Directory>nrconfig.exe /f methods- /i c:\directory\bin\WebApplication1.dll /o c:\test.NewRelic.xml

Example if I need all public and private methods it will be like:

C:\Directory>nrconfig.exe /f methods+- /i c:\directory\bin\WebApplication1.dll /o c:\test.NewRelic.xml

I wish that will help.
Feel free for any comment, suggestion or inquiry.

New Relic useful queries

2018-09-19T00:07:00.000-07:00

Mobile

% User impacted by slow requests

SELECT filter(uniqueCount(MobileRequest.uuid) , WHERE responseTime > 3) / uniqueCount(MobileSession.uuid) * 100 as '% Users Impacted' FROM MobileRequest, MobileSession since 1 day ago compare with 7 days ago

·      using the filter function to the subquery to get the users who got an impact

Where are requests being sent?

SELECT count(*) FROM MobileRequest FACET requestDomain since 1 month ago

·      using the facet for grouping now it will show every domain has got request by mobile application with the number of requests.

Avg Response Time by Domain

SELECT average(responseTime) FROM MobileRequest FACET requestDomain since 1 month ago

Percentile Response Time

SELECT percentile(responseTime, 98) as '98 percentile (sec)', percentile(responseTime, 90) as '90 percentile (sec)',  percentile(responseTime, 50) as '50 percentile (sec)' from MobileRequest since 1 month ago

·      using percentile to the percentage the response time related to 98% of the users "take in mind like 12% have a problem with internet connections".

Distribution of Response Time

SELECT histogram(responseTime) from MobileRequest since 3 days ago

·      using histogram for giving a percentage of the duration you want to measure, you can overwrite with histogram(attribute, ceiling [, buckets])

60 Second Histogram

SELECT histogram(responseTime, 60, 60) from MobileRequest since 3 days ago

Request per Session by App

SELECT uniqueCount(sessionId) from MobileRequest, MobileSession facet appName timeseries

Daily Active Users

SELECT uniqueCount(uuid) AS 'Users' from Mobile since 1 month ago COMPARE WITH 1 day ago

Daily Sessions

SELECT uniqueCount(sessionId) AS 'Sessions' from Mobile since 1 month ago COMPARE WITH 1 day ago

Session Duration

SELECT average(sessionDuration)/60 AS 'Minutes' FROM Mobile SINCE 1 month ago COMPARE WITH 1 day ago

Top Devices

SELECT uniqueCount(uuid) from Mobile since 1 week ago FACET device

Browser Information

How many sessions?

SELECT uniqueCount(session) from PageView since 1 day ago where appName = 'you applicaton' COMPARE WITH 1 week ago

Trend of sessions

SELECT uniqueCount(session) from PageView since 1 day ago where appName = 'your application' COMPARE WITH 1 week ago TIMESERIES

Page load

SELECT average(duration) from PageView

devices

SELECT uniqueCount(session) from PageView since 1 day ago where appName = 'applicatioin name' facet deviceType where deviceType != 'Unknown'

Frontend by Device Type

SELECT average(duration - backendDuration) as 'Frontend' FROM PageView FACET deviceType WHERE deviceType != 'Unknown' SINCE 1 day AGO TIMESERIES

average DOM processing

SELECT average(domProcessingDuration) from PageView since 1 day ago where appName = 'application name' COMPARE WITH 1 week ago

How many users get registered

SELECT funnel(session, where pageUrl = 'home page' as 'Homepage', where pageUrl like 'registeration page' as 'Register') from PageView where appName = 'application name'

Avg Page Load

SELECT average(duration) from PageView since 1 day ago where appName = 'application name' COMPARE WITH 1 week ago

Cities

SELECT uniqueCount(session) from PageView since 1 day ago where appName = 'application name' facet city

Pages

SELECT pageUrl, domProcessingDuration, duration from PageView since 1 day ago where appName = 'application name' limit 1000

User Agent

SELECT uniqueCount(session) from PageView since 1 day ago where appName = 'application name' facet userAgentName

Sharepoint or Dynamics 365 or create your own application

2018-04-30T02:53:00.000-07:00

For a long time, I’ve been having discussions with “Project manager” about a suitable technology they meet their needs.

Well, the conversation started when he said: “I would like to use SharePoint because it looks very cool”.

At that moment, I felt sorry because the question was guided the wrong way.
I thought he would discuss with me about the business problems and which technology they must follow to overcome these.

I know some consultants take advantage of people who don't know about technology and try to convince them to use the technologies they (the consultants) are good at.

Anyways, I remember that situation when I was reading a nice article and I recommend you to read it also:
https://stevemordue.com/dynamics-365-vs-sharepoint/

I am mainly interested in Microsoft technologies, I will try to not be skewed to any technologies and provide my abstract opinion.

Again, it’s my opinion.

Well, the first SharePoint for me is a great platform for versioning repository and managing the firm documents. If you want to use it as a portal for CRM it’s fine but if you have no license for it, then it will be a costly option. Instead of it, “there is a lot of option and free”. You can create a very nice responsive website using classic asp.net or asp.net MVC or the monster Angular2+ or even any other CMS open source.

I don’t think SharePoint was created to manage processes. Yes, it has workflow and you can extend whatever by development, but it’s not the purpose SharePoint has been created for.

Also, CRM is for collecting the leads and convert them to customers, manage marketing and sales process and customer service, so it’s an internal system. Therefore do not play around to make it as a public website “yes, I heard that sentence before”.

The most important thing is when a consultant suggests using one of their products, must remember doing less development means more efficiency; otherwise, create the system from scratch.
I know there are a lot of considerations (like let the client buy a license to gain more money). But getting respect from your client is more important.

Feel free to write your opinion.

Dynamics 365 overview

2018-02-05T05:54:00.001-08:00

The main difference between Microsoft and any other company is the renovation.

From CRM 4 passing through CRM 2011, 2013, 2016 few changes happened. But nowadays the revolution of dynamics “The cloud base application using SaaS (Software as a service) concept”. Rebuild from scratch and take in mind all the challenges they had forced before.

Until Dynamics 365 innovative

It’s a business management suite based on the cloud also related to the common data model to defragment the Dynamics 365 to modules.

I will give you a quick look at the architecture and the marketing planning of the new Microsoft product dynamics 365.

Dynamics 365
CRM	Dynamics AX “Operation” & Financial	Office 365	Power Applications & Workflow	Power BI	Cortana intelligence
Sales. Customer Service Field Service. Marketing. Project Service Automation.	General Ledger. Accounts Payable. Accounts receivable. Cost Accounting. Fixed Assets. Cash and Bank Management. Travel and Expense. Compliance and Internal control. Procurement and sourcing. Budgeting. Human Resources. Product Information management. Master planning. Project management and accounting. Sales and Marketing. Production control. Service management.	Outlook. OneDrive. Word. Excel. PowerPoint. OneNote. SharePoint. Microsoft Team.	Custom no code applications and workflow.	Custom no code reports.	Manage business intelligence, big data and analytics services from Azure.

In addition, for marketing purpose, Microsoft provided Dynamics 365 for two different editions for two business sizes.

1- Enterprise edition

· It’s for companies with the capacity of +250 employees.

· And because its market plans so Microsoft provides to the user ability to add module by module “use what you need”.

· Or the company can choose one of two plans in the enterprise edition.

Dynamics 365 enterprise edition
Plan 1	Plan 2
Sales. Customer Service. Field Service. Project Service Automation.	Sales. Customer Service. Field Service. Project Service Automation.
	Operations.
Office 365.	Office 365.
Power Apps and Flow.	Power Apps and Flow.
Power BI.	Power BI.
Cortana Intelligence.	Cortana Intelligence.

2- Business edition

· It’s made for small to middle sized.

· Microsoft split it into different modules.

Dynamics 365 business edition

For Financials.

For Sales.

For Marketing.

For Customer Services.

Office 365.

Power Apps and Flow.

Power BI.

Cortana Intelligence.

You can check the roadmap from here to see the progress of enhancement

https://roadmap.dynamics.com/

Finally, Microsoft builds a new umbrella “container” to interoperable between other modules, now we can say consultants can do most of the tasks instead to do it by coding like previous versions.

A new phase of customizations with superuser. Do you agree?

Server firewall blocks IIS Web site

2015-08-23T01:17:00.000-07:00

I am using windows server 2008 R2 with Internet Information Service 7, I've got an issue after I configure the web application in IIS. that's not access from the network and got browser message as the following:

after some search I found that I have to create inbound rule for port I'm using in website hosting.

Rule type: Port.
Protocol and ports: leave the selection TCP of "Dose this rule apply to TCP or UDP?".
type the port you have hosted your website in "specific local ports".
leave the other default values and give name of the rule and if you like some description to not forget the purpose of the rule.
then click finish.

I hope that help.

Troubleshooting: SQL Connection with IIS

2015-07-09T03:23:00.000-07:00

The problem is failing to connect from web application to sql server via IIS.

To solve this problem must add in security section in SQL server by using SQL Management Studio.

IIS APPPOOL\XXX ==> XXX is the name of the application in application pool as the following:

Troubleshooting: iis managedpipelinehandler 500.21

2015-07-09T03:17:00.001-07:00

To solve this error must repair the .Net Framework 4.0.30319 as the following:

From the start menu,choose all programs, then type in the search bar cmd "command prompt".
Right-click on command prompt, then choose run as administrator.
copy this line

cd\Windows\Microsoft.NET\Framework64\v4.0.30319\

then run aspnet_regiis.exe -i
then restart the iis iisreset

Insert Country from database to another

2015-05-22T07:54:00.001-07:00

Insert Country from database to another as the following:

insert into ExternalDBInTheSameServer.dbo.Country (ArName,EnName) select DifferentDBInTheSameServer.dbo.Country.NameArabic,DifferentDBInTheSameServer.dbo.Country.NameEnglish from DifferentDBInTheSameServer.dbo.Country

if you like countries data "Arabic and English" please find script below:
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (1, N'Afghanistan', N'أفغانستان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (2, N'Albania', N'ألبانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (3, N'Algeria', N'الجزائر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (4, N'American Samoa', N'ساموا-الأمريكي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (5, N'Andorra', N'أندورا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (6, N'Angola', N'أنغولا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (7, N'Anguilla', N'أنغويلا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (8, N'Antarctica', N'أنتاركتيكا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (9, N'Antigua and Barbuda', N'أنتيغوا وبربودا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (10, N'Argentina', N'الأرجنتين')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (11, N'Armenia', N'أرمينيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (12, N'Aruba', N'أروبه')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (13, N'Australia', N'أستراليا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (14, N'Austria', N'النمسا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (15, N'Azerbaijan', N'أذربيجان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (16, N'Bahamas', N'الباهاماس')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (17, N'Bahrain', N'البحرين')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (18, N'Bangladesh', N'بنغلاديش')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (19, N'Barbados', N'بربادوس')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (20, N'Belarus', N'روسيا البيضاء')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (21, N'Belgium', N'بلجيكا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (22, N'Belize', N'بيليز')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (23, N'Benin', N'بنين')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (24, N'Bermuda', N'جزر برمودا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (25, N'Bhutan', N'بوتان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (26, N'Bolivia', N'بوليفيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (27, N'Bosnia and Herzegovina', N'البوسنة و الهرسك')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (28, N'Botswana', N'بوتسوانا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (29, N'Brazil', N'البرازيل')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (30, N'Brunei Darussalam', N'بروني')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (31, N'Bulgaria', N'بلغاريا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (32, N'Burkina Faso', N'بوركينا فاسو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (33, N'Burundi', N'بوروندي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (34, N'Cambodia', N'كمبوديا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (35, N'Cameroon', N'كاميرون')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (36, N'Canada', N'كندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (37, N'Cape Verde', N'الرأس الأخضر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (38, N'Central African Republic', N'جمهورية أفريقيا الوسطى')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (39, N'Chad', N'تشاد')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (40, N'Chile', N'شيلي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (41, N'China', N'جمهورية الصين الشعبية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (42, N'Colombia', N'كولومبيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (43, N'Comoros', N'جزر القمر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (44, N'Democratic Republic', N'جمهورية الكونغو الديمقراطية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (45, N'Congo, Republic of (Brazzaville)', N'جمهورية الكونغو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (46, N'Cook Islands', N'جزر كوك')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (47, N'Costa Rica', N'كوستاريكا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (48, N'Cote d”Ivoire', N'ساحل العاج')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (49, N'Croatia', N'كرواتيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (50, N'Cuba', N'كوبا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (51, N'Cyprus', N'قبرص')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (52, N'Czech Republic', N'الجمهورية التشيكية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (53, N'Denmark', N'الدانمارك')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (54, N'Djibouti', N'جيبوتي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (55, N'Dominica', N'دومينيكا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (56, N'Dominican Republic', N'الجمهورية الدومينيكية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (57, N'East Timor Timor-Leste', N'تيمور الشرقية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (58, N'Ecuador', N'إكوادور')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (59, N'Egypt', N'مصر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (60, N'El Salvador', N'إلسلفادور')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (61, N'Equatorial Guinea', N'غينيا الاستوائي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (62, N'Eritrea', N'إريتريا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (63, N'Estonia', N'استونيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (64, N'Ethiopia', N'أثيوبيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (65, N'Faroe Islands', N'جزر فارو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (66, N'Fiji', N'فيجي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (67, N'Finland', N'فنلندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (68, N'France', N'فرنسا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (69, N'French Guiana', N'غويانا الفرنسية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (70, N'French Polynesia', N'بولينيزيا الفرنسية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (71, N'Gabon', N'الغابون')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (72, N'Gambia', N'غامبيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (73, N'Georgia', N'جيورجيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (74, N'Germany', N'ألمانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (75, N'Ghana', N'غانا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (76, N'Gibraltar', N'جبل طارق')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (77, N'Greece', N'اليونان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (78, N'Greenland', N'جرينلاند')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (79, N'Grenada', N'غرينادا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (80, N'Guadeloupe', N'جزر جوادلوب')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (81, N'Guam', N'جوام')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (82, N'Guatemala', N'غواتيمال')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (83, N'Guinea', N'غينيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (84, N'Guinea-Bissau', N'غينيا-بيساو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (85, N'Guyana', N'غيانا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (86, N'Haiti', N'هايتي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (87, N'Honduras', N'هندوراس')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (88, N'Hong Kong', N'هونغ كونغ')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (89, N'Hungary', N'المجر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (90, N'Iceland', N'آيسلندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (91, N'India', N'الهند')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (92, N'Indonesia', N'أندونيسيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (93, N'Iran', N'إيران')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (94, N'Iraq', N'العراق')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (95, N'Ireland', N'إيرلندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (96, N'Italy', N'إيطاليا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (97, N'Jamaica', N'جمايكا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (98, N'Japan', N'اليابان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (99, N'Jordan', N'الأردن')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (100, N'Kazakhstan', N'كازاخستان')
GO
print 'Processed 100 total records'
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (101, N'Kenya', N'كينيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (102, N'Kiribati', N'كيريباتي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (103, N'Korea, (North Korea)', N'كوريا الشمالية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (104, N'Korea, (South Korea)', N'كوريا الجنوبية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (105, N'Kuwait', N'الكويت')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (106, N'Kyrgyzstan', N'قيرغيزستان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (107, N'Lao, PDR', N'لاوس')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (108, N'Latvia', N'لاتفيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (109, N'Lebanon', N'لبنان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (110, N'Lesotho', N'ليسوتو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (111, N'Liberia', N'ليبيريا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (112, N'Libya', N'ليبيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (113, N'Liechtenstein', N'ليختنشتين')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (114, N'Lithuania', N'لتوانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (115, N'Luxembourg', N'لوكسمبورغ')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (116, N'Macao', N'ماكاو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (117, N'Macedonia, Rep. of', N'مقدونيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (118, N'Madagascar', N'مدغشقر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (119, N'Malawi', N'مالاوي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (120, N'Malaysia', N'ماليزيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (121, N'Maldives', N'المالديف')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (122, N'Mali', N'مالي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (123, N'Malta', N'مالطا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (124, N'Marshall Islands', N'جزر مارشال')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (125, N'Martinique', N'مارتينيك')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (126, N'Mauritania', N'موريتانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (127, N'Mauritius', N'موريشيوس')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (128, N'Mexico', N'المكسيك')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (129, N'Micronesia', N'مايكرونيزيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (130, N'Moldova', N'مولدافيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (131, N'Monaco', N'موناكو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (132, N'Mongolia', N'منغوليا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (133, N'Montenegro', N'الجبل الأسو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (134, N'Montserrat', N'مونتسيرات')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (135, N'Morocco', N'المغرب')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (136, N'Mozambique', N'موزمبيق')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (137, N'Myanmar, Burma', N'ميانمار')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (138, N'Namibia', N'ناميبيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (139, N'Nauru', N'نورو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (140, N'Nepal', N'نيبال')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (141, N'Netherlands', N'هولندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (142, N'Netherlands Antilles', N'جزر الأنتيل الهولندي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (143, N'New Caledonia', N'كاليدونيا الجديدة')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (144, N'New Zealand', N'نيوزيلندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (145, N'Nicaragua', N'نيكاراجوا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (146, N'Niger', N'النيجر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (147, N'Nigeria', N'نيجيريا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (148, N'Niue', N'ني')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (149, N'Northern Mariana Islands', N'جزر ماريانا الشمالية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (150, N'Norway', N'النرويج')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (151, N'Oman', N'عُمان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (152, N'Pakistan', N'باكستان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (153, N'Palau', N'بالاو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (154, N'Palestine', N'فلسطين')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (155, N'Panama', N'بنما')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (156, N'Papua New Guinea', N'بابوا غينيا الجديدة')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (157, N'Paraguay', N'باراغواي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (158, N'Peru', N'بيرو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (159, N'Philippines', N'الفليبين')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (160, N'Poland', N'بولونيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (161, N'Portugal', N'البرتغال')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (162, N'Puerto Rico', N'بورتو ريكو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (163, N'Qatar', N'قطر')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (164, N'Reunion Island', N'ريونيون')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (165, N'Romania', N'رومانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (166, N'Russia', N'روسيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (167, N'Rwanda', N'رواندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (168, N'Saint Kitts and Nevis', N'سانت كيتس ونيفس')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (169, N'Saint Lucia', N'سانت لوسيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (170, N'Saint Vincent and the', N'سانت فنسنت وجزر غرينادين')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (171, N'Samoa', N'المناطق')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (172, N'San Marino', N'سان مارينو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (173, N'Sao Tome and Pr?ncipe', N'ساو تومي وبرينسيبي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (174, N'Saudi Arabia', N'المملكة العربية السعودية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (175, N'Senegal', N'السنغال')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (176, N'Serbia', N'جمهورية صربيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (177, N'Seychelles', N'سيشيل')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (178, N'Sierra Leone', N'سيراليون')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (179, N'Singapore', N'سنغافورة')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (180, N'Slovakia', N'سلوفاكيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (181, N'Slovenia', N'سلوفينيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (182, N'Solomon Islands', N'جزر سليمان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (183, N'Somalia', N'الصومال')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (184, N'South Africa', N'جنوب أفريقيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (185, N'Spain', N'إسبانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (186, N'Sri Lanka', N'سريلانكا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (187, N'Sudan', N'السودان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (188, N'Suriname', N'سورينام')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (189, N'Swaziland', N'سوازيلند')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (190, N'Sweden', N'السويد')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (191, N'Switzerland', N'سويسرا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (192, N'Syria', N'سوريا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (193, N'Taiwan', N'تايوان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (194, N'Tajikistan', N'طاجيكستان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (195, N'Tanzania', N'تنزانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (196, N'Thailand', N'تايلندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (197, N'Tibet', N'تبت')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (198, N'Timor-Leste (East Timor)', N'تيمور الشرقية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (199, N'Togo', N'توغو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (200, N'Tonga', N'تونغا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (201, N'Trinidad and Tobago', N'ترينيداد وتوباغو')
GO
print 'Processed 200 total records'
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (202, N'Tunisia', N'تونس')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (203, N'Turkey', N'تركيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (204, N'Turkmenistan', N'تركمانستان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (205, N'Tuvalu', N'توفالو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (206, N'Uganda', N'أوغندا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (207, N'Ukraine', N'أوكرانيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (208, N'United Arab Emirates', N'الإمارات العرب')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (209, N'United Kingdom', N'المملكة المتحدة')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (210, N'United States', N'الولايات المتحدة')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (211, N'Uruguay', N'أورغواي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (212, N'Uzbekistan', N'أوزباكستان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (213, N'Vanuatu', N'فانواتو')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (214, N'Vatican City State', N'الفاتيكان')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (215, N'Venezuela', N'فنزويلا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (216, N'Vietnam', N'فيتنام')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (217, N'Virgin Islands (British)', N'الجزر العذراء البريطانية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (218, N'Virgin Islands (U.S.)', N'الجزر العذراء الأمريكي')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (219, N'Wallis and ', N'والس وفوتونا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (220, N'Western Sahara', N'الصحراء الغربية')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (221, N'Yemen', N'اليمن')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (222, N'Zambia', N'زامبيا')
INSERT [dbo].[Country] ([Id], [EnName], [ArName]) VALUES (223, N'Zimbabwe', N'زمبابوي')

Problem with installing Farm Sharepoint 2010 in local machine "Test environment"

2015-03-02T00:12:00.000-08:00

After I installed SQL Server 2008 R2 and SharePoint 2010 using Farm Setup.
I start the last step "Configuration wizard".

The solution is using PowerShell to configure the database

Insert the following command as the following:

New-SPConfigurationDatabase
Press enter
Database Name: SharePoint_Db
Press enter

Insert the database name you will desire to connect

Database Server: MachineName
Press enter

I assume that you are using localhost database.

Now, run the SharePoint 2010 Configuration Wizard

Junction Table Many to Many relationship

2014-11-25T04:32:00.001-08:00

CREATE TABLE [dbo].[Brand_Posts](
[BrandId] [bigint] NOT NULL,
[PostId] [bigint] NOT NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Brand_Posts] WITH CHECK ADD CONSTRAINT [PK_Brand_Post_Brand] PRIMARY KEY([BrandId],[PostId])
GO

ALTER TABLE [dbo].[Brand_Posts] WITH CHECK ADD CONSTRAINT [FK_Brand_Posts_Brand] FOREIGN KEY([BrandId])
REFERENCES [dbo].[Brand] ([Id])
GO

ALTER TABLE [dbo].[Brand_Posts] CHECK CONSTRAINT [FK_Brand_Posts_Brand]
GO

ALTER TABLE [dbo].[Brand_Posts] WITH CHECK ADD CONSTRAINT [FK_Brand_Posts_Post] FOREIGN KEY([PostId])
REFERENCES [dbo].[Post] ([Id])
GO

ALTER TABLE [dbo].[Brand_Posts] CHECK CONSTRAINT [FK_Brand_Posts_Post]
GO

get by jquery

2014-10-27T22:16:00.001-07:00

ajax function can use in get or post

$.ajax({
url: "TestAjax.aspx",
type:"get", //send it through get method
data:{Id:1,Email: Email}
success: function(response) {
//Do Something
},
error: function(xhr) {
//Do Something to handle error
}
});

and you can get the the datas by

$_GET['ajaxid'] //gives 1
$_GET['Email'] //gives you the sent email

OR

function GetURLParameterValue(value)
{

var parameterValue = "";
var sPageURL = window.location.search.substring(1);
var sURLVariables = sPageURL.split('&');
for (var i = 0; i < sURLVariables.length; i++) {
var sParameterName = sURLVariables[i].split('=');
if (sParameterName[0] == value) {
parameterValue = sParameterName[1];
if (parameterValue)
{
return parameterValue;
}
}
}

}

ASP.NET Paging using ORM "Object Relation Maping" Entity Framework

2014-08-01T02:13:00.001-07:00

If you start a new asp.net project must keep in mind you will necessarily use paging in your form list.
There is different ways to handle paging, the following illustration show you how to deal with in server side "entity framework" in visual basic and c#.

Visual basic functions

    Private pageSize As Integer = 4

'Get current page by checking query string, if not include value or null trun default current page is first page.

Protected ReadOnly Property CurrentPage As Integer
        Get
            Dim page As Integer
            Return If(Integer.TryParse(Request.QueryString("Page"), page), page, 1)
        End Get
    End Property

    Protected Function GetProducts() As List(Of Product)
        Return rep.Products.OrderBy(Function(o) o.ProductID).Skip((CurrentPage - 1) * pageSize).Take(pageSize)
    End Function

C# functions

        public int CurrentPage
        {
            get
            {
                int page = 1;
                int.TryParse(Request.QueryString["Page"], out page);
                return page;
            }
        }



        public int PageSize = 4; // We will change this later
 
 
 
        public List<Product> GetProducts()
        {
            return rep.Products
            .OrderBy(p => p.ProductID)
            .Skip((CurrentPage - 1) * PageSize)
            .Take(PageSize).ToList();
        }

RadAjaxManagerProxy and RadAjaxManager Not working with ClientScript.RegisterStartupScript

2014-07-27T05:38:00.001-07:00

 RadAjaxManager gives you ability to execute javascript code in response of server side by using response script of RadAjaxManager.

When I start to use it I versus a problem, the javascript method I've called not executed when I use method below:

 Page.ClientScript.RegisterStartupScript(this.GetType(), "key", "Sys.Application.add_load(showWindowMessage);", true);

Because I am using telerik controls so I have to use RadAjaxManager

RadAjaxManager1.ResponseScripts.Add("alert('Hello world');"))
                                
In case if you use telerik:RadAjaxManagerProxy  you can try this code snippet below:

string script = "alert('Hello world');";
ScriptManager.RegisterStartupScript(Page, typeof(Page), "myscript", script, true);

String Contains (function) in Javascript

2014-05-19T05:26:00.003-07:00

check if string contain sub string using c# programming language.

    string s1 = "Hello world";
    string s2 = "Hello";
    bool b;
    b = s1.Contains(s2);

//return true



Or using VB.Net programming language.
      Dim s1 As String = "Hello world" 
      Dim s2 As String = "Hello" 
      Dim b As Boolean
      b = s1.Contains(s2)

//return true

So now we want to do the same but in javascript

function StringContains(stringValue,compareValue)
{
    var result = false;
    if (stringValue.indexOf(compareValue) > -1) {
        result = true;
    }
    return result;
}

function SendUserActivationCode(userId)
{

  //for example the url like that :http://localhost:9258/En/hello/world/
    var languageValue = '';
    var sPageURL = window.location.search.substring(1);
    var result  = StringContains(sPageURL, "/En/");

     //return true

Enable to alter table in sql server 2008

2014-04-26T04:49:00.002-07:00

Saving changes is not permitted. The changes you have made repuire the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

to enable update changes you made in sql server 2008 follow the following steps.

* in the menu click tools ==> options.
* Find this dialog box:

I hope it will help.

Checked and Unchecked radio buttons by Jquery

2014-04-16T01:31:00.003-07:00

To make group for radio buttons must use name attribute as the following:

                <input type="radio" id="aa" name="IsAnyoneCanFollowMe"  value="true" />
                <label  for="aa"><span></span>Any One can follow me</label>
                  <br />
                <input type="radio" id="xx" name="IsAnyoneCanFollowMe" value="false" />
                <label  for="xx"><span></span>Request Only</label>

It will be render like:

Now in page load check the radio button depend the data came from server side.

function getData() {
    $.getJSON("/xx/xx/xxx",
function (data) {
 
    if (data)
        $('input:radio[name=IsAnyoneCanFollowMe]:nth(0)').attr('checked', true);
    else
        $('input:radio[name=IsAnyoneCanFollowMe]:nth(1)').attr('checked', true);
    
});
}


or

function getData() {
    $.getJSON("/xx/xx/xxx",
function (data) {
 
    if (data)
        $('input:radio[name=IsAnyoneCanFollowMe]')[0].checked = true;
    else
        $('input:radio[name=IsAnyoneCanFollowMe]')[1].checked = true;
});
}

Remove duplicate rows from SQL table

2014-04-04T12:55:00.000-07:00

Deleting duplicated data in your table is more sophisticated to prevent users from registering more than once. The following code demonstrates how to delete all duplicated rows "records" or remove records and leave only one record.

create table Person(id int,name varchar(20))
 
insert into Person values(1,'Karim')
insert into Person values (2,'Karim')
insert into Person values(3,'Nader')
insert into Person values(4,'Nader')
insert into Person values (5,'Nader')
insert into Person values (6,'Sherif')
insert into Person values (7,'Sherif')
insert into Person values (8,'Sherif')
insert into Person values (9,'Shady')
go

 This is query to delete all duplicated rows

delete from Person where                
name in(select name from Person group by name having count(*) >1)
go

This is query to remove records duplicated and leave only one record

 DELETE FROM Person WHERE id NOT IN (SELECT MIN(id)
 FROM Person GROUP BY name)

go
select * from Person

here I was using id as indicator because id is different now have case more tricky is how to delete all record duplicated accept one with id not increment.

I know it's not real world case, but maybe somebody ask you about it.

using the same table structure above but with duplicated id and name.

create table Person(id int,name varchar(20))
 
insert into Person values(1,'Karim')
insert into Person values (1,'Karim')
insert into Person values(3,'Nader')
insert into Person values(3,'Nader')
insert into Person values (3,'Nader')
insert into Person values (6,'Sherif')
insert into Person values (6,'Sherif')
insert into Person values (6,'Sherif')
insert into Person values (9,'Shady')



So we have to find something to indicate the row counts I think good solution to use ROW_NUMBER()

so we will ad a new column called rowNumber as the following:

go
WITH DeleteDuplicatedRows AS(
   SELECT id, name,
       RowNumber = ROW_NUMBER()OVER(PARTITION BY id,name ORDER BY id)
   FROM dbo.Person
)
 
 
DELETE FROM DeleteDuplicatedRows WHERE RowNumber > 1

Hyperlink - link tag - a tag enable disable jquery

2014-03-31T07:06:00.001-07:00

Little tricky when you try to enable or disable something like that

<a Id="btn_Id" href="/link" > bla bla</a>


I found solution and I want to share with you.

function disableHyperlink(e) {
    // cancels the event
    e.preventDefault();
 
    return false;
}


When you want to disable the like

$('#btn_Id').bind('click', disableHyperlink);


When you want to enable the like
$('#btn_Id').unbind('click', disableHyperlink);

{"There is already an open DataReader associated with this Command which must be closed first."}

2014-03-31T04:07:00.004-07:00

You can found this kind of error if you use Entity Framework code first and to solve this simply to convert return function to ToList<>() if you return multiple items or firstOrDefault() if you return single item.

It's something like:

    public class EFSPRepository : ISPRepository
    {
        EFDBContext _context = new EFDBContext();

        public sp_anything_Result ReturnOneItemOfAnything(long? accountId)
        {
            return _context.sp_ReturnOneItemOfAnything(accountId).AsEnumerable<sp_anything_Result >().FirstOrDefault();
        }

        public IEnumerable<long?> ReturnListOfAnythings(long? accountId)
        {
            return _context.sp_ReturnListOfAnythings(accountId).AsEnumerable<long?>().ToList();
        }

Get query string value by javascript

2014-03-17T06:54:00.001-07:00

Some times we need to get query string passed in client side "javascript"

so this is way to find your query string called queryStringValue from page index.html.

The url of the page looks like:

https://www.domain.com/index.html?queryStringValue=value

<script type="text/javascript">

$(function () {

            var queryStringValue= '';
            var sPageURL = window.location.search.substring(1);
            var sURLVariables = sPageURL.split('&');
            for (var i = 0; i < sURLVariables.length; i++) {
                var sParameterName = sURLVariables[i].split('=');
                if (sParameterName[0] == 'queryStringValue') {
                    queryStringValue= sParameterName[1];
                }
            }

    now variable queryStringValue include query string value :) enjoy

});
</script>

EF 4.1 code first Invalid column name “ColumnName_Id”

2014-02-05T00:54:00.004-08:00

The issue is how to figure out relation in code first Entity Framework, you must tell EF which is foreign key and which one is list of relation entity.

there is simple example:

    public class Account
    {

        public long Id { get; set; }

        [ForeignKey("MyScore")]        <== very important
        public Nullable<long> MyScoreId { get; set; }

        [InverseProperty("Accounts")]  <== very important
        public virtual MyScore MyScore { get; set; }

    }



    public class MyScore
    {
        public long Id { get; set; }


        public virtual ICollection<Account> Accounts { get; set; }

    }

Filezilla Error Failed to retrieve directory listing

2014-02-04T07:23:00.000-08:00

..............
..............
..............
Response: 200 PORT command successful. Consider using PASV.
Command: LIST
Error: Connection timed out
Error: Failed to retrieve directory listing

To solve this problem follow this instructions below:

Open Filezilla, go to Edit -> Settings

Click on Connection -> FTP: Choose Active

Click on Connection -> FTP -> Active Mode: Select "Ask your operating system for the external IP address"

Click on Connection -> FTP -> Passive Mode: Choose Fall Back to Active Mode

Press OK.

No mapping exists from object type System.RuntimeType to a known managed provider native type.

2014-02-02T01:08:00.001-08:00

If you found this kind of error be sure there is something wrong on you sql stored procedure parameters, however you call it "From entity framework,Code first or ExecuteNonQuery".
In my case I was using default parameters value (NULL).

            var nameParameter = name != null ?
                new SqlParameter("@Name", name) :
                new SqlParameter("@Name", typeof(string));

    // add the blue code to check it the value passed equal null 

            if (string.IsNullOrEmpty(name))
                nameParameter.Value = DBNull.Value;

            var locationParameter = location != null ?
                new SqlParameter("@Location", location) :
                new SqlParameter("@Location", typeof(string));
                // add the blue code to check it the value passed equal null 

            if (string.IsNullOrEmpty(location))
                locationParameter.Value = DBNull.Value;

Also take care if you use output parameters you have to fix the direction like this
  nameParameter.Direction = System.Data.ParameterDirection.Output;