how to check username availability while typing in textbox in C# mvc

Question

1.00/5 (1 vote)

See more:

Here is my code and what i have to do

C#

C#

public bool IsInvoiceExists(string invoicenumber)
{
    try
    {   
        string connstring = "Data Source=.;Initial Catalog=Accounts;Integrated Security=True";
        string query = "select * from AccountSummary where InvoiceNo=@InvoiceNo";
        SqlConnection conn = new SqlConnection(connstring);
        SqlCommand cmd = new SqlCommand(query, conn);
        cmd.Parameters.AddWithValue("@InvoiceNo", invoicenumber);
        
        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        if (dt == null || dt.Rows.Count == 0)
        {
            bool isExist;
            isExist = db.Users.Any(u => u.Name == userName);
            return Json(isExist);
        }        
        else
        {
            return false;
        } 
    }
    catch (Exception)
    {  
        throw;
    }
}

jquery

JavaScript

$("#InvoiceNo").keyup(function () {
       $.ajax({
           url: "@Url.Action("IsInvoiceExists", "Home")",
           data: $(this).val(),
           type: "GET",
           cache: false,
           success: function (data) {
               if (data) {
                   $("#errorMessage").text("Invoice Exist");
               }
               else {
                   $("#errorMessage").empty();
               }
           },
           error: function (xhr) {
           }
       });
   });

Posted 16-Nov-15 1:03am

Member 10403555

Updated 16-Nov-15 15:35pm

George Jonsson

v3

Add a Solution

Comments

Amit Jadli 16-Nov-15 7:14am

Your question is not clear... what issue you are facing?? any error in this code??

and Jquery has inbuilt autocomplete function you could use that...for more information refer below link..

http://www.codeproject.com/Articles/78704/Different-Approaches-for-Implementing-the-JQuery

Member 10403555 16-Nov-15 8:09am

when i typing name in textbox the availability name of should be displayed beside the textbox

Member 10403555 16-Nov-15 7:56am

when i typing name in textbox the availability name of should be displayed beside the textbox

Amit Jadli 16-Nov-15 8:20am

Then use jquery autocomplete and check the response if your response is null or undefined then the name is available otherwise your name is not available...

Krunal Rohit 16-Nov-15 23:49pm

show the View part. Only the textbox and the error message.

-KR

Member 10403555 1-Dec-15 9:11am

hii rohit

<script>
function myFunction() {
$("#InvoiceNo").keypress(function () {
//remove all the class add the messagebox classes and start fading
//check the username exists or not from ajax
$.ajax({
url: "@Url.Action("IsInvoiceExists", "Home")",
data: $(this).val(),
type: "POST",
cache: false,
success: function (data) {
if (data == 0) {
//$("#errorMessage").text("Invoice Exist");
$("#msgbox").fadeTo(200, 0.1, function () { //start fading the messagebox

//add message and change the class of the box and start fading
$(this).html('This Invoice Already exists').addClass('messageboxerror').fadeTo(900, 1);
});
}
else if (data == 1) {
//$("#errorMessage").empty();
$("#msgbox").fadeTo(200, 0.1, function () { //start fading the messagebox

//add message and change the class of the box and start fading
$(this).html('Invoice available').addClass('messageboxok').fadeTo(900, 1);
});
}
else {
alert("Some error occured! Check Console");
}
},
error: function (xhr) {
}
});
});
}

</script>

<input type="text" class="form-control required" maxlength="11" id="InvoiceNo"
name="InvoiceNo" placeholder="Invoice No"
value="@(ViewBag.InvoiceNo ?? String.Empty)" required >
<span id="msgbox"></span>

Member 10403555 1-Dec-15 9:12am

public bool IsInvoiceExists(string invoicenumber)
{
try
{
string connstring = "Data Source=.;Initial Catalog=Accounts;Integrated Security=True";
string query = "select * from AccountSummary where InvoiceNo=@InvoiceNo";
SqlConnection conn = new SqlConnection(connstring);
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@InvoiceNo", invoicenumber);

DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt == null || dt.Rows.Count == 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception)
{

throw;
}

}

Member 10403555 1-Dec-15 9:13am

how can get the invoicenumber availability while leaving cursor from textbox

2 solutions

Add a Solution

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

George Jonsson · Answer 1 · 2015-11-16T16:01:00

In your current code, you make a call to the database for each and every keystroke.
This is not very efficient or user friendly due to many reasons.

You would be better off splitting up the code into two parts.

Part 1
This part should be executed when the page is loaded or something similar.
In any case, you want to do this operation as few times as possible.

Declare a new member variable

C#

private DataTable dtInvoices = null;

Then add a method that is called every time you want to update the invoices

C#

public void GetInvoices()
{
    string connstring = "Data Source=.;Initial Catalog=Accounts;Integrated Security=True";
    string query = "select InvoiceNo from AccountSummary";
    using (SqlConnection conn = new SqlConnection(connstring))
    {
        SqlCommand cmd = new SqlCommand(query, conn);
    
        dtInvoices = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dtInvoices);
    }
}

Instead of a DataTable you could of course use a

C#

List<string> invoiceNumbers

.

Then modify your existing method

C#

public bool IsInvoiceExists(string invoicenumber)
{
    if (dtInvoices == null)
        return false;  // Or throw an error depending on your logic

    bool exists = (dtInvoices.Select(string.Format("InvoiceNo = '{0}'", invoicenumber)).FirstOrDefault() != null);
    return exists;
}

No idea how this code is connected to anything else in your code snippet.

C#

bool isExist;
isExist = db.Users.Any(u => u.Name == userName);
return Json(isExist);

[UPDATE]
Due to comment
Maybe you should try to make it a public property in the controller.

C#

private DataTable dtInvoices = null;
public DataTable Invoices
{
    get
    {
        return dtInvoices;
    }
    set
    {
        dtInvoices = value;
    }
}

Mangal Deep Gupta · Answer 2 · 2015-11-16T20:27:00

You can use

C#

[Remote("doesUserNameExist", "Account", HttpMethod = "POST", ErrorMessage = "User name already exists. Please enter a different user name.")]

function declaration is ::

C#

[HttpPost]
public JsonResult doesUserNameExist(string UserName) {

    var user = Membership.GetUser(UserName);

    return Json(user == null);
}

how to check username availability while typing in textbox in C# mvc

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to check username availability while typing in textbox in C# mvc

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us