Coderskey

Could not load file or assembly 'Newtonsoft.Json' or one of its dependencies. Manifest definition does not match the assembly reference

2015-12-09T00:05:00.002-08:00

To solve this, Ensure that all your projects used the same version by running the following command in Package manager console of Visual Studio and checking the results:

update-package Newtonsoft.Json -reinstall

The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required.

2015-09-05T01:56:00.002-07:00

You will find fix, from below options:

case 1: when the password is wrong

case 2: when you try to login from some App

case 3: when you try to login from the domain other than your time zone/domain/computer (This is the case in most of scenarios when sending mail from code)

There is a solution for each

solution for case 1: Enter the correct password.

solution for case 2: go to security settings at the followig linkhttps://www.google.com/settings/security/lesssecureapps and enable less secure apps . So that you will be able to login from all apps.

solution 1 for case 3: (This might be helpful) you need to review the activity. but reviewing the activity will not be helpful due to latest security standards the link will not be useful. So try the below case.

solution 2 for case 3: If you have hosted your code somewhere on production server and if you have access to the production server, than take remote desktop connection to the production server and try to login once from the browser of the production server. This will add excpetioon for login to google and you will be allowed to login from code.

But what if you don't have access to the production server. try the solution 3

solution 3 for case 3: You have to enable login from other timezone / ip for your google account.

to do this follow the link https://g.co/allowaccess and allow access by clicking the continue button.

And that's it. Here you go. Now you will be able to login from any of the computer and by any means of app to your google account.

Difference between == and === in JS

2015-08-26T02:52:00.003-07:00

Example:

== only compares values

=== compares values + type

var test1 = '11',
    test2 = 11;

test1 == test2 // true

test1 === test2 // false

How to login using username only without password in MVC using identity membership

2015-08-10T07:00:00.002-07:00

Example:

public async Task<ActionResult> CustomLogin(string name)
{
name = "student@gmail.com";

var user = await UserManager.FindByNameAsync(name);

if (user != null)
{

await SignInManager.SignInAsync(user, true, true);
}

return RedirectToAction("Index", "Student");
}

How to get datatype and length of column in sql server

2015-06-22T02:38:00.002-07:00

This query will help:

SELECT column_name as 'Column Name', data_type as 'Data Type',
character_maximum_length as 'Max Length'
FROM information_schema.columns
WHERE table_name = 'YourTableName'

How to configure IIS on windows server 2012/ 2012 r2

2015-05-19T18:39:00.000-07:00

To enable IIS and the required IIS components on Windows Server 2012/2012 R2, see the instructions below.

Use short key Windows+R to open control panel
Click on Turn Windows features on or off
Open Server Manager and click Manage > Add Roles and Features. Click Next.
Select Role-based or feature-based installation and click Next.
Select the appropriate server. The local server is selected by default. Click Next.
Enable Web Server (IIS) and click Next.
No additional features are necessary to install the Web Adaptor, so click Next.
On the Web Server Role (IIS) dialog box, click Next.
On the Select role services dialog box, verify that the web server components listed below are enabled. Click Next.
Verify that your settings are correct and click Install.
When the installation completes, click Close to exit the wizard.

It will take some time to get installed, Enjoyyy......

Lock user after number of wrong attempts in MVC 5 using identity 2

2015-05-10T21:59:00.002-07:00

First, create a new ASP.NET MVC 5 project and select the Individual User Accounts authentication. Then, install the ASP.NET Idenetity 2 framework using the package manager console.

Next, add the following default value settings in web.config

<appSettings>

  <add key="UserLockoutEnabledByDefault" value="true" />

  <add key="DefaultAccountLockoutTimeSpan" value="15" />

  <add key="MaxFailedAccessAttemptsBeforeLockout" value="3" />

</appSettings>

By setting UserLockoutEnabledByDefault to true, we are configuring the application to enforce globally that for every user that gets created he/she is subject to lockouts if the user reaches the maximum failed login attempts. Off course, if you do not want to enforce lockouts for particular users such as administrators you can do so when creating their accounts.
The value for DefaultAccountLockoutTimeSpan is in minutes so you can set to what every value you prefer. The example is set to 15 minutes which means if the user reaches the maximum failed login attempts, the user will have to wait for 15 minutes before being allowed to login.
The MaxFailedAccessAttemptsBeforeLockout setting is the number of login attempts you allow the user to retry before a lockout. The example allows 3 attempts after warning the user.
Next, open the IdentityConfig.cs file which is found in the App_Start folder and add the following in the Create method of the ApplicationUserManager class.

public static ApplicationUserManager Create(IdentityFactoryOptions<ApplicationUserManager> options, IOwinContext context) 

{

    // other code removed for brevity       

    manager.UserLockoutEnabledByDefault = Convert.ToBoolean(ConfigurationManager.AppSettings["UserLockoutEnabledByDefault"].ToString());

    manager.DefaultAccountLockoutTimeSpan = TimeSpan.FromMinutes(Double.Parse(ConfigurationManager.AppSettings["DefaultAccountLockoutTimeSpan"].ToString()));

    manager.MaxFailedAccessAttemptsBeforeLockout = Convert.ToInt32(ConfigurationManager.AppSettings["MaxFailedAccessAttemptsBeforeLockout"].ToString());

}

It is in the Create method that you configure the lockout settings by refering to the default values set in web.config above.
The final step is to perform the lockout checks and you do that in the POST login action method. So open Account controller and replace it with the following code

[HttpPost]

[AllowAnonymous]

[ValidateAntiForgeryToken]

public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)

{

    if (ModelState.IsValid)

    {

        // find user by username first

        var user = await UserManager.FindByNameAsync(model.Email);

        if (user != null)

        {

            var validCredentials = await UserManager.FindAsync(model.Email, model.Password);

            // When a user is lockedout, this check is done to ensure that even if the credentials are valid

            // the user can not login until the lockout duration has passed

            if (await UserManager.IsLockedOutAsync(user.Id))

            {

                ModelState.AddModelError("", string.Format("Your account has been locked out for {0} minutes due to multiple failed login attempts.", ConfigurationManager.AppSettings["DefaultAccountLockoutTimeSpan"].ToString()));

            }

            // if user is subject to lockouts and the credentials are invalid

            // record the failure and check if user is lockedout and display message, otherwise, 

            // display the number of attempts remaining before lockout

            else if (await UserManager.GetLockoutEnabledAsync(user.Id) && validCredentials == null)

            {

                // Record the failure which also may cause the user to be locked out

                await UserManager.AccessFailedAsync(user.Id);

                string message;

                if (await UserManager.IsLockedOutAsync(user.Id))

                {

                    message = string.Format("Your account has been locked out for {0} minutes due to multiple failed login attempts.", ConfigurationManager.AppSettings["DefaultAccountLockoutTimeSpan"].ToString());

                }

                else

                {

                    int accessFailedCount = await UserManager.GetAccessFailedCountAsync(user.Id);

                    int attemptsLeft =

                        Convert.ToInt32(

                            ConfigurationManager.AppSettings["MaxFailedAccessAttemptsBeforeLockout"].ToString()) -

                        accessFailedCount;

                    message = string.Format(

                        "Invalid credentials. You have {0} more attempt(s) before your account gets locked out.", attemptsLeft);

                }

                ModelState.AddModelError("", message);

            }

            else if (validCredentials == null)

            {

                ModelState.AddModelError("", "Invalid credentials. Please try again.");

            }

            else

            {

                await SignInAsync(user, model.RememberMe);

                // When token is verified correctly, clear the access failed count used for lockout

                await UserManager.ResetAccessFailedCountAsync(user.Id);

                return RedirectToLocal(returnUrl);

            }

        }

    }

    // If we got this far, something failed, redisplay form

    return View(model);

}

When a user attempts to login, the first check is to find out if the account is locked out and inform the user accordingly. Then it checks if the user is subject to lockouts and if it does and the credentials are invalid, record the failure(increment the access failed count) and inform the user that he/she has how many more login attempts before account gets locked out. If the account is not locked out and the credentials are valid, then sign the user in and reset the access failed count to zero.
The following shows the message a valid user gets when he/she fails to login the first time

The following shows the message a valid user gets when the account gets locked out

How to get lat long from address in C#

2015-03-18T00:14:00.000-07:00

We need to install GoogleMaps.LocationServices from the NuGet package. It uses Google's REST API to get lat/long for a given address. Using these you can get latitude and longitude without any need of any API Key.

To install GoogleMaps.LocationServices, either, run the following command in the Package Manger Console.

PM> Install-Package GoogleMaps.LocationServices

Or, search it on Nuget and install it directly

After Install the above package you can use it like this:

Firstly, Add the NameSpace.

using GoogleMaps.LocationServices;

Then use GoogleLocationService() class to get the latitude and longitude of any given address.

Example:

/// <summary>
/// This is to get the lat long from address
/// </summary>
public void GetLatLongFromAddress()
{
var address = "920 N. Parish Place, Burbank, CA 91506";
var locationService = new GoogleLocationService();
var point = locationService.GetLatLongFromAddress(address);
var latitude = point.Latitude;
var longitude = point.Longitude;

}

Enjoyyy.... :)

Create database script with data in Sql Server

2015-03-10T23:54:00.000-07:00

Right Click on db => Tasks => Generate Scripts => In "Set Scripting Options: Click Advanced, find Types of data to script. You can choose between Data only, Script and data and Schema only. The default is Schema only.

Convert httppostedfilebase to image in C# and image re-sizing in c#

2015-02-11T03:06:00.001-08:00

private string UploadFile(HttpPostedFileBase postedFile)
{
if (postedFile.ContentLength > 0)
{
var filename = Path.GetFileName(postedFile.FileName);

System.Drawing.Image sourceimage =
System.Drawing.Image.FromStream(postedFile.InputStream);

Bitmap newImage = new Bitmap(5, 5);
using (Graphics gr = Graphics.FromImage(newImage))
{
gr.SmoothingMode = SmoothingMode.HighQuality;
gr.InterpolationMode = InterpolationMode.HighQualityBicubic;
gr.PixelOffsetMode = PixelOffsetMode.HighQuality;
gr.DrawImage(sourceimage, new Rectangle(0, 0, 5, 5));
}
}

}

How To Change Password Validation strength in ASP.Net MVC Identity ?

2015-02-04T22:54:00.002-08:00

In the MVC project template in VS2013 Update 2, there should be a file called App_Start/IdentityConfig.cs.

In it you should find the class ApplicationUserManager and a static factory method called Create().

That's where the user manager class is configured, including the server-side validation rules for passwords are defined. For example:

manager.PasswordValidator = new PasswordValidator
{
RequiredLength = 6,
RequireNonLetterOrDigit = true,
RequireDigit = true,
RequireLowercase = true,
RequireUppercase = true,
};

Note: you can change/customize above configuration for password strength, like this:

// Configure validation logic for passwords
manager.PasswordValidator = new PasswordValidator
{
RequiredLength = 6,
RequireNonLetterOrDigit = false,
RequireDigit = false,
RequireLowercase = false,
RequireUppercase = false,
};

Enjoyyyy...

Query to rename column name in Sql Server 2008

2015-01-27T22:14:00.002-08:00

Syntax:

EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'

Query Example:

EXEC sp_RENAME 'ExceptionLog.exceptionLog', 'LogMessage', 'COLUMN'

Enjoyyy....

Reading App settings from app.config or web.config in .net C#

2015-01-21T23:05:00.003-08:00

For Sample App.config like below:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <add key="countoffiles" value="7" />
    <add key="logfilelocation" value="abc.txt" />
  </appSettings>
</configuration>


You read the above app settings using code shown below:
using System.Configuration;

You may also need to also add a reference to System.Configuration in your project if there isn't one already. You can then access the values like so:
string configvalue1 = ConfigurationManager.AppSettings["countoffiles"];
string configvalue2 = ConfigurationManager.AppSettings["logfilelocation"];
Enjoyyyy.... :)

How to calculate difference between two dates in C#

2015-01-14T01:17:00.005-08:00

Assuming StartDate and EndDate are of type DateTime:

int dateDifference = (StartDate - EndDate).Days;

How to Check if folder exists, if not create it in C#

2014-12-24T22:50:00.001-08:00

string realPath;
realPath = Server.MapPath("~/ReportHtmlFiles/" + TestFolder + "/");
// Check if folder exists, if not create it
if (!Directory.Exists(realPath))
{
Directory.CreateDirectory(realPath);
}

How to create new folder in mvc 4

2014-12-24T22:11:00.003-08:00

var path = Server.MapPath("~/Content/users/" + "NewFolderToAdd/");
Directory.CreateDirectory(path);

File upload using jquery Asp.Net MVC

2014-12-18T07:35:00.000-08:00

File Upload in ASP.NET MVC via ajax

Problem

While looking for fileupload options via ajax and without posting the whole form, we often come across code in the internet using FormData API, which works perfectly fine on chrome and mozilla but on on IE. so a code snippet using a FormData API would like this below

//View Code

function save() {

$("#test").submit();

}

function submitForm() {

var formData = new FormData($('#test')[0]);

$.ajax({

url: '@Url.Action("Upload","FileUpload")',

type: 'POST',

data: formData,

async: false,

success: function (data) {

alert('posted')

cache: false,

contentType: false,

processData: false

});

return false;

}

</script>

<h2>Index</h2>

<div>

<label for="fileUpload">File upload</label>

</div>

</form>

//Controller Code

public ActionResult Upload()

{

HttpPostedFileBase postedFile = Request.Files[0];

return View();

}

The above snipped works fine on chrome and mozilla and you will be able to see the postedFile in the controller but it does not work on IE because most versions of IE does not support FormData.

Solution

So the solution I came up with after going some recommendations over internet about HTML controls on different browsers is that its better to use iframes. So Idea is to point the target of the form to an iframe and even bind a load event to the iframe so that you know when the upload is finished and write additional jquery functions. Also you can even hide the iframe and not show the user. But this solution works on IE as well. The code is as below

The code also shows how to post additional data along with the file post.

ViewBag.Title = "Index";

}

function successFunction() {

alert($('#my_iframe').contents().find('p').html());

}

function redirect() {

//debugger;

document.getElementById('my_form').target = 'my_iframe'; //'my_iframe' is the name of the iframe

//document.getElementById('my_form').submit();

var callback = function () {

if (successFunction)

successFunction();

$('#frame').unbind('load', callback);

};

$('#my_iframe').bind('load', callback);

$('#hfParam').val('id:1');

$('#my_form').submit();

//$("#my_form").trigger("submit");

}

</script>

<h2>Index</h2>

</iframe>

</div>

</form>

[HttpPost]

public ActionResult UploadFile()

{

ContentResult result = new ContentResult() { Content = "<p></p>", ContentType = "text/html"};

HttpPostedFileBase postedFile = Request.Files[0];

try

{

result.Content = "<p>" + postedFile.FileName + "</p>";

}

catch (System.Exception ex)

{

result.Content = ex.Message;

}

return result;

}

Sql query to add new column in table

2014-12-17T22:41:00.001-08:00

Syntax:

ALTER TABLE TableName
ADD ColumnName Datatype

Example:

ALTER TABLE AspNetUsers
ADD SubscripionDate datetime null

Format number or add comma separation using Jquery

2014-10-28T03:57:00.002-07:00

<script src="//cdnjs.cloudflare.com/ajax/libs/numeral.js/1.4.5/numeral.min.js"></script>

Format

Numbers can be formatted to look like currency, percentages, times, or even plain old numbers with decimal places, thousands, and abbreviations.

var string = numeral(1000).format('0,0.00');
// '1,000.00'

Reference link: http://numeraljs.com/

How to apply Special character validation using Jquery

2014-10-17T09:44:00.001-07:00

<input type="text" name="txtKeywords" id="txtKeywords" />
<input type="submit" value="Search" title="Search" id="btnSearch" />

<script>
$(document).ready(function () {
$("#btnSearch").click(function () {

var titleValue = $("#txtKeywords").val();

// Apply check for special characters
if ((/^[a-zA-Z0-9- ]*$/.test(titleValue) == false) ) {
alert('Your String Contains illegal Characters.');
return false;
}

});
});
</script>

Difference between loose coupling and tight coupling in object oriented paradigm

2014-10-16T04:42:00.000-07:00

Tight coupling is when a group of classes are highly dependent on one another.

This scenario arises when a class assumes too many responsibilities, or when one concern is spread over many classes rather than having its own class.

Loose coupling is achieved by means of a design that promotes single-responsibility and separation of concerns.

A loosely-coupled class can be consumed and tested independently of other (concrete) classes.
Interfaces are a powerful tool to use for decoupling.

Classes can communicate through interfaces rather than other concrete classes, and any class can be on the other end of that communication simply by implementing the interface.

Example of tight coupling:

class CustomerRepository
{
    private readonly Database database;

    public CustomerRepository(Database database)
    {
        this.database = database;
    }

    public void Add(string CustomerName)
    {
        database.AddRow("Customer", CustomerName);
    }
}

class Database
{
    public void AddRow(string Table, string Value)
    {
    }
}

Example of loose coupling:

class CustomerRepository
{
    private readonly IDatabase database;

    public CustomerRepository(IDatabase database)
    {
        this.database = database;
    }

    public void Add(string CustomerName)
    {
        database.AddRow("Customer", CustomerName);
    }
}

interface IDatabase
{
    void AddRow(string Table, string Value);
}

class Database : IDatabase
{
    public void AddRow(string Table, string Value)
    {
    }
}

Enjoyyy.... !!!!

Example to create Facebook App to show list of friends using FQL(Facebook Query Language) and send Invite in C# (MVC)

2014-10-15T05:26:00.002-07:00

To create such App firstly we need to create Facebook Developer account to get the Facebook Application Id.

Refer this link to create developer account and get FB App Id :

https://help.yahoo.com/kb/yahoo-merchant-solutions/facebook-application-sln18861.html

Here we have used MVC to develop this :

1. Create a controller of name PeopleController

2. Create an action

public ActionResult InviteFBPeople()

{

return View();

}

3. Create view for above action

ViewBag.Title = "Invite Facebook People";

}

<h2>Invite Facebook Friends</h2>

//Facebook SDK initialize portion

window.fbAsyncInit = function () {

FB.init({

appId: 'YourFBAppID',

status: true, cookie: false, xfbml: true

});

};

// All FB resources

$(document).ready(function () {

if (document.getElementById('fb-root') != undefined) {

var e = document.createElement('script');

e.type = 'text/javascript';

e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js';

e.async = true;

document.getElementById('fb-root').appendChild(e);

}

});

</script>

// This is to get the Access Token of FB

$(document).ready(function () {

setTimeout(function () {

//something you want delayed

FB.getLoginStatus(function (response) {

if (response.status === 'connected') {

var fbAccessToken = response.authResponse.accessToken;

window.location = '@Url.Action("ListFacebookFriends", "People")' + "?id=" + fbAccessToken;

}

});

}, 2000);

});

</script>

4. In above script we have made to fetch the access token of logged in FB user and passed it to an action of name "ListFacebookFriends" in same People Controller,

public ActionResult ListFacebookFriends(string id)

{

//get current access token

var accessToken = id;

List<FacebookFriends> Friends = new List<FacebookFriends>();

if (accessToken != "")

{

Friends = GetFriends(accessToken, false,"").ToList();

}

ViewBag.FbFriends = Friends;

return View();

}

5. Create Function of name GetFriends

public IEnumerable<FacebookFriends> GetFriends(string accessToken, bool isUsing)

{

string strQuery = string.Empty;

if (isUsing)

{

strQuery = "SELECT uid, name, pic_square, email FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1=me()) AND is_app_user";

}

else

{

strQuery = "SELECT uid, name, pic_square, email FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1=me()) AND NOT is_app_user";

}

FacebookClient objFQL = new FacebookClient(accessToken);

dynamic parameters = new ExpandoObject();

parameters.q = strQuery;

dynamic objFNU = objFQL.Get("fql", parameters);

List<FacebookFriends> friendsToReturn = new List<FacebookFriends>();

if (objFQL != null)

{

foreach (dynamic row in objFNU.data)

{

friendsToReturn.Add(new FacebookFriends()

{

FriendID = Convert.ToString(row.uid),

FriendName = row.name,

PicURLSquare = row.pic_square,

Email = row.email

}

);

}

return friendsToReturn;

} //Get FB Friends not already using this app

6. Create class of name FacebookFriends.

public class FacebookFriends

{

public string FriendID { get; set; }

public string FriendName { get; set; }

public string PicURLSquare { get; set; }

public string ProfileLink { get; set; }

public bool Follower { get; set; }

public string Email { get; set; }

public string UserName { get; set; }

}

7. Create view for action "ListFacebookFriends".

ViewBag.Title = "ListFacebookFriends";

}

<div >

<h2>List of Facebook Friends</h2>

//Initialize facebook SDK

window.fbAsyncInit = function () {

FB.init({

appId: '470021713099348',

status: true, cookie: false, xfbml: true, frictionlessRequests: true

});

};

// All FB resources

$(document).ready(function () {

if (document.getElementById('fb-root') != undefined) {

var e = document.createElement('script');

e.type = 'text/javascript';

e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js';

e.async = true;

document.getElementById('fb-root').appendChild(e);

}

});

// Send Invite to friends

function sendRequestToRecipients(targetid) {

FB.ui({

method: 'apprequests',

message: 'Try Talentcubed.com',

description: 'Play Games Get Hired',

to: targetid

}, requestCallback);

// method: 'feed',

}

function requestCallback(response) {

// Handle callback here

var uid = response['to'];

var link = $('#inv_' + uid);

link.removeAttr('href');

$("#img_" + uid).fadeOut();

}

$(document).ready(function () {

$("#btnSearch").click(function () {

window.location = '@Url.Action("Search", "Wall")' + "?id=people";

});

</script>

</div>

<ul>

@foreach (var Friend in ViewBag.FbFriends)

{

<li>

<div ><p >@Friend.FriendName</p></div>

<div >

<a href="javascript:sendRequestToRecipients('@Friend.FriendID');" id="inv_@Friend.FriendID">Invite</a>

</div>

</li>

}

</ul>

</div>

</div>

Enjoyyyyy...... !!!!!!

Convert HTML content values to Object in C# using Html Agility Pack (HAP)

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

In below code sample we are passing HTML in variable of name dataStream, In HTML we have a table of which we made to convert <th> and <td> in objects directly, using HAP(Html Agility Pack) need to be added using Nuget Package in our Native Application.

Sample Code:

using HtmlAgilityPack;

// Import Html table to datatable, Using “Html Agility Pack(Nuget)”
HtmlDocument doc = new HtmlDocument();
doc.LoadHtml(dataStream);
var headers = doc.DocumentNode.SelectNodes(“//tr/th”);

List<string> headingList = new List<string>();
List<string> valueList = new List<string>();

// Add th values in h
foreach (HtmlNode header in headers)
{
var headText = header.InnerText; //Get head columns from th
headText = headText.Replace(“:”, “”); // Remove colon(:) sign from head text
headingList.Add(headText);

}

// Select rows with td elements
foreach (var row in doc.DocumentNode.SelectNodes(“//tr[td]“))
{
var valueText = row.SelectNodes(“td”).Select(td => td.InnerText).ToArray();
var strValue = valueText[0].ToString();
valueList.Add(strValue);
}

Reference Link:

http://htmlagilitypack.codeplex.com/

Error Logging using ELMAH in Asp.Net Web Application completely pluggable

2014-08-25T02:05:00.002-07:00

Error Logging Modules And Handlers (ELMAH) offers another approach to logging runtime errors in a production environment.

It can be dynamically added to a running Asp.Net web application, or even all ASP.NET web applications on a machine, without any need for re-compilation or re-deployment.

Reference Links:

1. https://code.google.com/p/elmah/

2. http://www.asp.net/web-forms/tutorials/deployment/deploying-web-site-projects/logging-error-details-with-elmah-cs

The type 'System.Data.Entity.DbContext' is defined in an assembly that is not referenced.

2014-08-20T23:20:00.001-07:00

I've got one solution - The one project is class library with .edmx data model The other is asp.net MVC Web API project.

when i start (Build) the solution I get the following exception:

Now, to resolve this issue :

I suggest you to check

Allow NuGet to download missing packages during build

In this way I got resolved the issue.