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); } }