username should be unique

Guest User

6y969Learn iOS Programming

when user register its profile then username should be unique for every user using entity framework in asp.net c#

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jenith Thakkar6y ago
Accepted answer
Hi
before this line
var usersadd = context.Set();
just check like below
var Data = context.Users.where(u=>u.username==newusermodel.username).firstordefault()

if(Data==null)
{
then do code for save user
}
else
{
print message
}
Jenith Thakkar6y ago
Okay please mark as a answer if it's helpful for you so it would helpful for me also
Guest User6y ago
Its working now..i just simply take a label and print message on it..Thanks Everyone For Ur Help...
Guest User6y ago
its doesnot add new user but the problem is it doesnt show any message of User exists or not.

var usersadd = context.Set();
var response = context.Users.Where(u => u.UserName == newusermodel.UserName).FirstOrDefault();
if(response == null)
{
usersadd.Add(user);
context.SaveChanges();
}
else
{
string messagebox = response != null ? "New User" : "Existing Username";
}
Jay Krishna Reddy6y ago
1. user.Name = newusermodel.Name;
Check here with the existing username
replace the code
var response = user.Where(c=>c.Username.Equals(newusermodel.username)).firstordefault();
string result = response != null ? "New User" : "Existing Username"

Guest User6y ago

i am bit confused.can u please tell me..where should i use this senerio....

here is my register page..

Aspx code..

Registration

Style="top:182px; left: 774px; position: absolute; height: 26px; width: 162px"

ControlToValidate="TxtName" ErrorMessage="Name required**" font-size="Small"

ForeColor ="Red">

Style="top: 224px; left: 774px; position: absolute; height: 26px; width: 162px"

ControlToValidate="TxtUserName" ErrorMessage="Username required** " font-size="Small"

ForeColor="Red">

Style="top:271px; left: 774px; position: absolute; height: 26px; width: 162px"

ControlToValidate="TxtEmailID" ErrorMessage="Valid EmailID required" font-size="Small"

ForeColor="Red">

Style="top:321px; left: 774px; position: absolute; height: 26px; width: 162px"

ControlToValidate="TxtPassword" ErrorMessage="It contains 1-special character and 0-9 numbers required" font-size="Small"

ForeColor="Red">

Image:
Name:
UserName:
EmailID:
Password:
Confirm Password:

onclick="Button1_Click" />

Aspx.cs..

using System;

using System.Configuration;

using System.Data;

using System.Data.Entity;

using System.Data.SqlClient;

using System.IO;

using System.Security.Cryptography;

using System.Text;

using WalPaper.Model;

namespace WalPaper

{

public partial class WebForm2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

Model.User newusermodel = new Model.User();

newusermodel.Image = TxtImg.ToString();

newusermodel.Name = TxtName.Text;

newusermodel.UserName = TxtUserName.Text;

newusermodel.EmailID = TxtEmailID.Text;

newusermodel.Created_Date = DateTime.Now;

newusermodel.User_Type_Id = 3;

newusermodel.Password = TxtPassword.Text;

using (WallpaperEntities3 context = new WallpaperEntities3())

{

User user = new User();

{

string str = TxtImg.FileName;

TxtImg.PostedFile.SaveAs(Server.MapPath("~/Upload/" + str));

string Image = "~/Upload/" + str.ToString();

string name = TxtImg.ToString();

user.Image = newusermodel.Image;

user.Name = newusermodel.Name;

user.UserName = newusermodel.UserName;

user.EmailID = newusermodel.EmailID;

user.Created_Date = newusermodel.Created_Date;

user.User_Type_Id = newusermodel.User_Type_Id;

user.Password = newusermodel.Password;

};

var usersadd = context.Set();

usersadd.Add(user);

context.SaveChanges();

string message = "Your details have been saved successfully.";

string script = "window.onload = function(){ alert('";

script += message;

script += "')};";

ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true);

Response.Redirect("/Login.aspx");

}

Jay Krishna Reddy6y ago

Pass the Current post value to check with the Database users table and if a user exists with the same name we won't allow saving

Public string ValidateUserName(string username)
{
string finalresult = string.Empty;
var result = db.context.table.Where(c=>c.username.Equals(username)).firstordefault();
return finalresult = result!= null ? "username Saved" : "Already Exists ,Try Another one";
}

else saved.

Jenith Thakkar6y ago

If you checked my code properly then you notice that what I do their

I have matched entered username with the database username if both are same then return 1 else 0 so if it retuns a 0 then you just show you message

Guest User6y ago

Dear Experts !! am working on Asp.net,c# using entity framework

In my project, i have a Registration Form. and also i have User Table in database.

So i need to create a Usernames as Unique.

Suppose if the User Registered with one name and the other users should not create with this name.

So , i need a Message like Already Exists with this Name, Try another name.

Please Suggest me, and help me, How to do this ?

Jenith Thakkar6y ago

FOr that you can check passed username parameter like

public int DoOperation (UserDetails user)
{
int userexist = 0;
var data =db.context.users.where(u=>u.username==user.username).firstordefault();
if(data!=null)
{
userexist =1;
}
else
{
userexist = 0;
}
return userexist;
}

Thank you