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