public List <RegistrationSearch_Result> GetRegistrationList(int maximumRows, int startRowIndex, out int totalRowCount, string sortByExpression) { RegistrationDatabaseEntities entities = new RegistrationDatabaseEntities(); string sortDirectionSQL; if (sortDirection == SortDirection.Ascending) { sortDirectionSQL = "ASC"; } else { sortDirectionSQL = "DESC"; } var results = entities.RegistrationSearch(SearchTextBox.Text, sortDirectionSQL, startRowIndex, maximumRows).ToList(); totalRowCount = results[0].Total.Value; return(results); }
public void RegistrationInsert(RegistrationInsert_Result item) { try { var lastNameTextbox = this.registrationFormView.FindControl("LastNameTextBox") as TextBox; var name = $"{item.Name} {lastNameTextbox.Text}"; RegistrationDatabaseEntities entities = new RegistrationDatabaseEntities(); entities.RegistrationInsert(item.Username, name, item.Email, item.DateOfBirth, item.Phone); } catch (EntityCommandExecutionException ex) { if (ex.InnerException.Message.Contains("Violation of PRIMARY KEY constraint 'PK_Registration'")) { // Display user name already taken error } } catch (Exception ex) { // Handle general exceptions - would have separate exception handler for username already exists exception } }
public void RegistrationGridView_DeleteItem(string username) { RegistrationDatabaseEntities entities = new RegistrationDatabaseEntities(); entities.RegistrationDelete(username); }
public void RegistrationGridView_UpdateItem(RegistrationSearch_Result item) { RegistrationDatabaseEntities entities = new RegistrationDatabaseEntities(); entities.RegistrationUpdate(item.Username, item.Name, item.Email, item.Phone, item.Username); }