protected void btnSearch_Click(object sender, EventArgs e)
{
ActivityTracker.Track("Searched For User", (int)UserActionEnum.Clicked);
db = new HPSDB();
// Get the creation dates
DateTime startDate = (txtSearchStartDate.Text != String.Empty) ? Convert.ToDateTime(txtSearchStartDate.Text) : DateTime.MinValue;
DateTime endDate = (txtSearchStartDate.Text != String.Empty) ? Convert.ToDateTime(txtSearchEndDate.Text) : DateTime.MaxValue;
// Get the normal textboxes
string firstName = (txtSearchFirstName.Text != String.Empty) ? txtSearchFirstName.Text : String.Empty;
string lastName = (txtSearchLastName.Text != String.Empty) ? txtSearchLastName.Text : String.Empty;
string email = (txtSearchEmail.Text != String.Empty) ? txtSearchEmail.Text : String.Empty;
string username = (txtSearchUserName.Text != String.Empty) ? txtSearchUserName.Text : String.Empty;
string role = (ddlSearchUserRole.SelectedValue != "-1") ? ddlSearchUserRole.SelectedValue : String.Empty;
// Search based on criteria
var users = db.HPSUsers
.Where(f => f.FirstName.Contains(firstName))
.Where(l => l.LastName.Contains(lastName))
.Where(em => em.AspNetUser.Email.Contains(email))
.Where(u => u.AspNetUser.UserName.Contains(username))
.Where(s => s.CreatedOn >= startDate && s.CreatedOn <= endDate)
.Where(a => a.RoleName.Contains(role))
.ToList();
if (users.Any())
{
// Build the results table
TableBuilder.BuildUsersTable(tblUsers, users, false);
}
else
{
lblNoResults.Visible = true;
lblNoResults.Text = "No results found.";
}
// Show the panel
pnlSearchResults.Visible = true;
}