private void btnSubmit_Click(object sender, EventArgs e)
{
if (Checker())
{
string password = EncodePassword(txtPassword.Text, "smthingSpecial");
if (txtUserID.Text != "")
{
UsersModelEdit user = new UsersModelEdit(
Convert.ToInt32(txtUserID.Text),
password,
txtUsername.Text,
txtFirstName.Text,
txtLastName.Text,
Convert.ToInt32(cmbUserGroup.SelectedValue)
);
SqliteDataAccess.EditUser(user);
}
else
{
UsersModelEdit user = new UsersModelEdit(
password,
txtUsername.Text,
txtFirstName.Text,
txtLastName.Text,
Convert.ToInt32(cmbUserGroup.SelectedValue)
);
SqliteDataAccess.CreateUser(user);
}
form.Refresh();
this.Close();
}
}
public static void CreateUser(UsersModelEdit user)
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
cnn.Execute("INSERT INTO users (Username, Password, FirstName, LastName, GroupID) " +
"VALUES (@Username, @Password, @FirstName, @LastName, @GroupID)", user);
}
}
public static void EditUser(UsersModelEdit user)
{
using (IDbConnection cnn = new MySqlConnection(LoadConnectionString()))
{
cnn.Execute("UPDATE users SET Username = @Username, " +
"Password = @Password, " +
"FirstName = @FirstName, " +
"LastName = @LastName, " +
"GroupID = @GroupID " +
"WHERE UserID = @UserID ", user);
}
}
