How Do I Checked If Employee Exist Or Not

Question

0.00/5 (No votes)

See more:

i have a web application,in which a user information form.i want to check if employee exist or not when user a user roll no which is also PK.
THAT may be by using on text change or using button click event

ASP.NET

asp:TextBox CssClass="form-control" runat="server" MaxLength="7" ID="txtRollNo"    />
                    <asp:RegularExpressionValidator Display="Dynamic" ValidationGroup="vgEmployee" runat="server" ID="revRollNo" ControlToValidate="txtRollNo" Requried="required" ValidationExpression="^[A-Za-z0-9,/\,-]+$" ErrorMessage="Number,Alpha,- and / only" ></asp:RegularExpressionValidator>
                     <asp:Button CssClass="btn btn-green btn-block " ID="btn_Click"  Width="150" runat="server" OnClick="btn_Click_Click" CausesValidation="True" Text="Check Employee"/>

and codebehind is

C#

protected void btn_Click_Click(object sender, EventArgs e)
       {
           if (!string.IsNullOrEmpty(txtRollNo.Text))
           {
               Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Cnic).LastOrDefault();

               if (emp != null)
               {
                   MsgLitteral.ShowNotificationInline("Record Found", false);

               }
               else
               {
                   MsgLitteral.ShowNotificationInline("Record Not Found", false);
               }

           }
       }

Problem is that when i press the button is always return Record found,although there is no record against that employee Id.

Posted 26-Oct-14 23:53pm

Sajid227

Add a Solution

Comments

[no name] 27-Oct-14 5:59am

Arent you gonna use txtRollNo.Text in the filter criteria ?

Sajid227 27-Oct-14 6:01am

on any way that might be good

Sergey Alexandrovich Kryukov 27-Oct-14 6:01am

What is Employee.Cnic, how is it calculate?
This is related to the question by Praneet Nadkar above.
Did you use the debugger to find the problem?
—SA

Sajid227 27-Oct-14 6:13am

there is no error display by debugger

Sergey Alexandrovich Kryukov 27-Oct-14 6:16am

Who told you that the debugger should display any "error"? (You probably meant "exception"...)
Do I have to explain what the debugger does? Use the debugger. As you are really confused about the use of the debugger, please learn the basics of what it can do. Basically, you can execute step by step and examine some variables and members, and even expressions, as you go.
—SA

Sajid227 27-Oct-14 6:54am

i also checked it using debugger

Sergey Alexandrovich Kryukov 27-Oct-14 6:56am

Good. (But, checked what? :-) Now please pay attention for my other question... :-)
—SA

Laiju k 27-Oct-14 6:01am

what value did you get in emp

Sajid227 27-Oct-14 6:09am

null

Laiju k 27-Oct-14 7:01am

if emp is null
how will it go through
if (emp != null)
{
MsgLitteral.ShowNotificationInline("Record Found", false);

}
And give as Record Found

Sajid227 28-Oct-14 1:17am

THEN HOW CAN I MANAGE IT

Shweta N Mishra 27-Oct-14 6:01am

how does your service checks for a record, It may be possible you are getting a record with no Value, where is the SQL query used to check the record.

Also did you tried to Print the response where there is no record, What did you found ?

Sajid227 27-Oct-14 6:02am

Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Id).LastOrDefault();
that is new code.

Sajid227 27-Oct-14 6:05am

if i check it by entering any record that is in database or not in both case it return Record found

5 solutions

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)

Prakriti Goyal · Answer 1 · 2014-10-27T00:14:00

Solution 1

Hello,

Instead of this,

Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Id).LastOrDefault();

try,

Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Id).Last();

What is happening is that, it is returning default record in case if no record is found.

Hope this helps you.

Regards,
Prakriti Goyal

Posted 27-Oct-14 0:14am

Prakriti Goyal

Comments

Sajid227 27-Oct-14 6:28am

same result,return record found in both cases.

Prakriti Goyal 27-Oct-14 6:30am

Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Id).Last();

Debug and check what value emp is returning in this code.

Sajid227 27-Oct-14 6:36am

Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id==Employee.Id).Last();
that return all field value null except for dates for both cases,if record is database or not

Sajid227 27-Oct-14 6:37am

is there another solution to check the record using linq

Prakriti Goyal 27-Oct-14 7:23am

Employee emp = new Employee();
emp = _service.GetAllEmployee().Where(x => x.Employee_Id==txtRollNo.Text).Last();

Try this

basudev pradhan · Answer 2 · 2014-10-27T02:44:00

Solution 2

to check in ur code in break point mode to check in emp is null or not then check record is null or not in ur object

Posted 27-Oct-14 2:44am

basudev pradhan

Neetin_1809 · Answer 3 · 2014-10-27T02:54:00

Solution 3

Hello,
seeing your code No Camparsion is being Made with the Id that has been entered into the textbox.so make use of that Id for Camparsion.

C#

Employee emp = _service.GetAllEmployee().Where(x =>x.Employee_Id==txtRollNo.Text).Last();

then check whether it is null or not.
Hope It Helps you.
Try To Surround your code with try Catch .

Posted 27-Oct-14 2:54am

Neetin_1809

Comments

Sajid227 27-Oct-14 16:51pm

protected void btn_Click_Click(object sender, EventArgs e)
{
try
{

if (!string.IsNullOrEmpty(txtRollNo.Text))
{
Employee emp = _service.GetAllEmployee().Where(x => x.Employee_Id == txtRollNo.Text).Last();

if (emp != null)
{
Console.WriteLine("Record Found");
}
else
{
Console.WriteLine("Record Not Found");
}

}
}
catch (Exception ex) { HandException(ex); }
after trying this code an excetion is occur that state Sequence contain no element

Er. Dinesh Sharma · Answer 4 · 2014-10-27T03:00:00

Solution 4

Hello

Employee emp = _service.GetAllEmployee().Where(x=>x.Employee_Id==txtRollNo.Text).LastOrDefault();

if(emp!=null)
{
Console.WriteLine("Record Found");
}
else
{
Console.WriteLine("Record Not Found");
}

Posted 27-Oct-14 3:00am

Er. Dinesh Sharma

Comments

Sajid227 27-Oct-14 16:42pm

there is no display of given result,in both cases.after debugging it return null in both condition

Sajid227 · Answer 5 · 2014-10-27T20:02:00

C#

protected void btn_Click_Click(object sender, EventArgs e)
        {
            if (!string.IsNullOrEmpty(txtRollNo.Text))
            {
                var employee = _service.GetEmployee(txtRollNo.Text);
                if (employee != null)
                
                {
                    MsgLitteral.ShowNotificationInline("Record Found",true);
                }
                else
                {
                    MsgLitteral.ShowNotificationInline("Record not Found", false);
                }
            }

i just change the above code and that fine,thanx to all

How Do I Checked If Employee Exist Or Not

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us