protected void btnRegister_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DataSetTableAdapters.UsersTableAdapter taUser
= new DataSetTableAdapters.UsersTableAdapter();
taUser.Fill(ds.Users);//Get the latest and put into ds.Users table
DataRow[] dr = ds.Users.Select("Username = '******'");
if (dr.Length == 1)
{
lblCreateStatus.Visible = true;
lblCreateStatus.Text = "Account is already existed. Please choose another username!";
}
else
{
DataSet.UsersRow fRow = ds.Users.NewUsersRow();
fRow.Username = tbUsername.Text;
fRow.Password = tbPass.Text;
fRow.Full_Name = tbName.Text;
fRow.Email = tbEmail.Text;
fRow.Country = drdCountry.SelectedItem.ToString();
fRow.IsAdmin = false;
//In the offline database
ds.Users.Rows.Add(fRow);
//Get it back to the real database
taUser.Update(ds.Users);
Response.Write("<script LANGUAGE='JavaScript' >alert('Successfully Registrated!!!')</script>");
Server.Transfer("Login.aspx");
}
}
private void RegistarButton_Click(object sender, RoutedEventArgs e)
{
DataSet.UsersRow row = (DataSet.UsersRow)dataSet.Users.NewRow();
row.Name = txtName.Text;
row.Password = txtPassword.Text;
dataSet.Users.AddUsersRow(row);
usersTableAdapter.Update(dataSet);
MessageBox.Show("User Was Added", "Registar", MessageBoxButton.OK, MessageBoxImage.Information);
txtName.Clear();
txtPassword.Clear();
}
protected void btnAddUser_Click(object sender, EventArgs e)
{
DataSetTableAdapters.UsersTableAdapter taUser
= new DataSetTableAdapters.UsersTableAdapter();
taUser.Fill(ds.Users);//Get the latest and put into ds.Users table
DataRow[] dr = ds.Users.Select("Username = '******'");
if (dr.Length == 1)
{
lblStatusUser.Visible = true;
lblStatusUser.Text = "Account is already existed. Please choose another username!";
lblStatusUser.ForeColor = System.Drawing.Color.Red;
lblStatusUser.Visible = true;
}
else
{
DataSet.UsersRow fRow = ds.Users.NewUsersRow();
fRow.Username = tbUsername.Text;
fRow.Password = tbPass.Text;
fRow.Full_Name = tbName.Text;
fRow.Email = tbEmail.Text;
fRow.Country = drdCountry.SelectedItem.ToString();
if (rbtnAdmin.Checked)
{
fRow.IsAdmin = true;
}
else
{
fRow.IsAdmin = false;
}
//In the offline database
ds.Users.Rows.Add(fRow);
//Get it back to the real database
taUser.Update(ds.Users);
//Get the latest database
taUser.Fill(ds.Users);
gvUsers.DataSourceID = "SqlDataSource1";//Update Grid View
lblStatusUser.Text = "Successfully Added New Account";
lblStatusUser.ForeColor = System.Drawing.Color.Green;
lblStatusUser.Visible = true;
}
}
/// <summary>
/// Verifies if a username and password are valid users
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns>boolean result</returns>
public static Boolean VerifyUsernamePassword(string username, string password)
{
DataSetTableAdapters.UsersTableAdapter usertableadapter = new DataSetTableAdapters.UsersTableAdapter();
DataSet.UsersDataTable data = usertableadapter.GetUserByUsername(username, true); //Get user with matching username
if (data != null && data.Count != 0) //check if user exists
{
DataSet.UsersRow user = data[0]; //get the userrow from the dataset
string input_hash = HashSaltPassword(password, user.PasswordSalt.ToString()); //input password gets hashed using the known salt
if (input_hash == user.PasswordHash.ToString().Trim())
{
return(true); //if existing hash and generated hash match, user is verified!
}
}
return(false); //for all other cases verification fails
}
private void RegisterButton_Click(object sender, RoutedEventArgs e)
{
DataSet.UsersRow row = (DataSet.UsersRow)dataSet.Users.NewRow();
// set row Name to name textbox Text
row.Name = txtName.Text;
// set row Password to password textbox Text
row.Password = txtPassword.Password;
dataSet.Users.AddUsersRow(row);
usersTableAdapter.Update(dataSet);
// show message box that states the user was registered
// on the message box show an information icon and “Register” caption
// look at resources section below for message box information
MessageBox.Show("The user has been registered.", "Register", MessageBoxButton.OK, MessageBoxImage.Information);
// clear text boxes
txtName.Clear();
txtPassword.Clear();
}
private void btnRegister_Click(object sender, RoutedEventArgs e)
{
DataSet.UsersRow row = (DataSet.UsersRow)dataSet.Users.NewRow();
row.Name = txtName.Text;
row.Password = txtPassword.Text;
dataSet.Users.AddUsersRow(row);
adapter.Update(dataSet);
MessageBoxResult message = MessageBox.Show("User was registered", "Register", MessageBoxButton.OK, MessageBoxImage.Information);
// show message box that states the user was registered
// on the message box show an information icon and “Register” caption
// look at resources section below for message box information
txtName.Text = "";
txtPassword.Text = "";
// clear text boxes
}
protected void Page_Load(object sender, EventArgs e)
{
USER = (DataSet.UsersRow)Session["UserInfo"];
}
