private bool IsUserExits(User anUser) { User user = userGateway.GetUserByEmail(anUser.Email); if (user != null) { return true; } return false; }
protected void registerButton_Click(object sender, EventArgs e) { string userId = Guid.NewGuid().ToString().Replace("-","").ToUpper(); string userName = userNameTextBox.Text; string email = emailTextBox.Text; string password = passwordTextBox.Text; User anUser=new User(userId,userName,email,password); string messsage = userManager.Save(anUser); messageLabel.Text = messsage; ClearAllTextBox(); //Response.Redirect("LogIn.aspx"); }
public int Insert(User anUser) { string query = "INSERT INTO t_Users VALUES(@userId,@userName,@email,@password)"; CommandObj.CommandText = query; CommandObj.Parameters.Clear(); CommandObj.Parameters.AddWithValue("@userId", anUser.UserId); CommandObj.Parameters.AddWithValue("@userName", anUser.UserName); CommandObj.Parameters.AddWithValue("@email", anUser.Email); CommandObj.Parameters.AddWithValue("@password", anUser.Password); ConnectionObj.Open(); int rowAffected = CommandObj.ExecuteNonQuery(); return rowAffected; }
public string Save(User anUser) { bool isUserExits = IsUserExits(anUser); if (isUserExits) { return "This email is already used by someone"; } if (userGateway.Insert(anUser) > 0) { return "Registration sucessful"; } return "Registration failed"; }
public User GetUserByEmail(string email) { string query = "SELECT * FROM t_Users WHERE Email=@email"; CommandObj.CommandText = query; CommandObj.Parameters.Clear(); CommandObj.Parameters.AddWithValue("@email", email); User anUser = null; ConnectionObj.Open(); SqlDataReader reader = CommandObj.ExecuteReader(); if (reader.Read()) { anUser=new User(); anUser.UserId = reader["UserId"].ToString(); anUser.UserName = reader["UserName"].ToString(); anUser.Email = reader["Email"].ToString(); anUser.Password = reader["Password"].ToString(); } reader.Close(); CommandObj.Dispose(); ConnectionObj.Close(); return anUser; }