How to check the Login in Ajax

Question

0.00/5 (No votes)

See more:

I have table Called Mst_User for Login Checkup. The Column are Us_No, Us_Name, Us_Password and Us_Admin.

I have created OData Services. Now i want to check the login User name & password.

OData Services work perfectly. I checked through explore.

Below is the code, Please tell me how to check this in ajax.

JavaScript

var _url = "http://localhost:58890/DataService.svc/Mst_User?$filter=Us_Name eq '" + LoginPage.currentUser.UserName() + "' and Us_Password eq'" + LoginPage.currentUser.Password() + "'&$format=json";
    $.ajax({
        type: "GET",
        url: _url,
        timeout: 10000,
        async: true,
        dataType: "json",
        contentType: "application/jsonp; charset=utf-8",
        success: function (data) {
//How to check here if Us_Admin=1 then Navigate
//Else
//Show error
        }
    });

Thanks
Basit

Posted 11-Jul-15 18:27pm

basitsar

Updated 11-Jul-15 19:27pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2015-07-11T19:30:00

Solution 1

May be like...

JavaScript

if(data.Us_Admin == 1)
{
    window.location.href = "home.html";
}
else
{
    alert("Error");
}

Posted 11-Jul-15 19:30pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

basitsar 12-Jul-15 1:58am

showing login failed!

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Jul-15 2:04am

Hey, you need to check the server side code and check what exactly you are returning for Us_Admin. Debug and see.

basitsar 12-Jul-15 2:44am

The Us_Admin is a numeric field, if Us_admin=1 then redirect to another page. I checked in the database its showing also 1, But the code what you suggested is not working with that code showing login failed.

Thanks
Basit

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Jul-15 2:50am

As I said, you need to check the service method Mst_User, what exactly you are returning and how. Debug that. Also debug in the success method.

basitsar 12-Jul-15 3:04am

Below is the o/p of webservices

{"d":[{"__metadata":{"id":"http://localhost:58890/DataService.svc/Mst_User(1)","uri":"http://localhost:58890/DataService.svc/Mst_User(1)","type":"CMModel.Mst_User"},"Trn_CallLog":{"__deferred":{"uri":"http://localhost:58890/DataService.svc/Mst_User(1)/Trn_CallLog"}},"Us_No":1,"Us_Name":"Basit","Us_Password":"s","Us_Admin":1,"Us_Customer":1,"Us_CallAssign":1,"Us_CreateCall":1}]}

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Jul-15 3:20am

Okay. So, Us_Admin is not a direct property of the returned object. That's why I told you to debug inside the success method, so that you can know how exactly you can get the value from data. Seems like the below should work...

data.d.__deferred.Us_Admin

If this does not work, then debug and check how you can get the value.

basitsar 12-Jul-15 3:38am

Many Thanks,
I debug & try three things
data.d.Us_Admin undefined
data.Us_Admin undefined
data.d.__deferred.Us_Admin undefined

all are showing undefined.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Jul-15 3:53am

You need to check the data in console while you are debugging. If you see how the properties are organized, you will know how to access it. This is very easy. Don't try different things, just debug inside success and get the actual formation.

basitsar 12-Jul-15 4:12am

Dear i add a quick watch when i type data.Us_Admin=1 then its shows 1 it goes to success loop but i type wrong user & password.

another when i type data.Us_Admin==1 then it goes to else loop.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Jul-15 4:57am

Dude, I said to debug, not to try different thing. By the way, you should use == operator while comparing, not = operator (which is always true).

basitsar 12-Jul-15 5:17am

Dear you said check in console. how to do that?
Thanks
Basit.

basitsar 12-Jul-15 5:21am

Below is the code.
var _url = "http://localhost:58890/DataService.svc/Mst_User?$filter=Us_Name eq 'Basit' and Us_Password eq 's' &$format=json";
$.ajax({
type: "GET",
url: _url,
timeout: 10000,
async: true,
dataType: "json",
contentType: "application/jsonp; charset=utf-8",
success: function (data) {

if (data.d.Us_Admin == 1) {
//Navigate
} else {
//shows error
}
},
error: function (xhr, status, error) {
// Shows error.
}
});

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Jul-15 5:26am

Set a debugger inside success like...

success: function (data) {
debugger;
////.....other codes...

Then, open F12, and refresh the page.

basitsar 12-Jul-15 5:40am

Thanks Alot dear,

Dear, with the debugger with valid user name & password result is below

data = Object {d: Array[1]
Us_Admin: 1
Us_Name: "Basit"
Us_No: 1
Us_Password: "s"

with wrong user & password result is below

data = Object {d: Array[0]
No Data is shwoing

But even with the valid result its not moving in
if (data.d.Us_Admin == 1) {
//redirect
}
else
{
error
}

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 12-Jul-15 6:06am

Then it should look like...

If (data.d.length >0 && data.d[0].Us_Admin == 1)

basitsar 13-Jul-15 0:46am

Thanks A lot the problem has been solved. But why before not accepting above code?

Thanks
basit.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 13-Jul-15 1:48am

Because d is an array, so you need to read the property of the array.

basitsar 15-Jul-15 4:12am

Dear,
How to add the security in ajax? I already give the user and password to OData Services how to put in Ajax?

Thanks
Basit.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 16-Jul-15 10:57am

Did you add another question? Please give me the link here.

basitsar 16-Jul-15 13:36pm

Dear,
Many Many Thanks, Below is the link.
http://www.codeproject.com/Questions/1010323/How-to-Pass-UserName-Password-in-Ajax