public JsonResult SearchMember(GridSettings gridSettings)
{
MemberSearchFilter filter = new MemberSearchFilter();
if (gridSettings.IsSearch)
{
filter.Email = gridSettings.Where.rules.Any(r => r.field == "Email") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "Email").data : string.Empty;
filter.UserName = gridSettings.Where.rules.Any(r => r.field == "FullName") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "FullName").data : string.Empty;
}
filter.Role = MemberRoles.Contributor;
int totalRecords = 0;
var applicationUsers = _memberService.searchMember(filter, gridSettings.SortColumn, gridSettings.SortOrder, gridSettings.PageSize, gridSettings.PageIndex, out totalRecords);
var jsonData = new
{
total = totalRecords / gridSettings.PageSize + 1,
page = gridSettings.PageIndex,
records = totalRecords,
rows = (
from a in applicationUsers
select new
{
Id = a.Id,
FullName = a.FullName,
Email = a.Email,
PhoneNumber = a.PhoneNumber,
Country = a.Country.CodeName
}
)
};
return(Json(jsonData));
}
public IEnumerable <ApplicationUser> searchMember(MemberSearchFilter filter, string sortColumn, string sortOrder, int pageSize, int pageIndex, out int totalRecords)
{
IEnumerable <ApplicationUser> users = context.Users.ToList();
if (!string.IsNullOrEmpty(filter.Email))
{
users = users.Where(u => u.Email.ToLower().Contains(filter.Email.ToLower()));
}
if (!string.IsNullOrEmpty(filter.UserName))
{
users = users.Where(u => u.FullName.ToLower().Contains(filter.UserName.ToLower()));
}
if (filter.Role != null)
{
var role = context.Roles.SingleOrDefault(m => m.Name == filter.Role.Value.ToString());
users = users.Where(u => u.Roles.Any(r => r.RoleId == role.Id));
}
totalRecords = users.Count();
return(users.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList());
}
public ActionResult AddMembershipSearchFilter(AddSearchFilterViewModel viewModel)
{
var searchCriteria = this.searchService.GetEmptySearchCriteria();
// we have to find one
var searchCriterion = searchCriteria.First(c => c.DisplayName == viewModel.CriteriaName);
var memberSearchFilter = new MemberSearchFilter
{
CampaignId = viewModel.CampaignId,
InternalName = searchCriterion.InternalName,
FilterType = (int)searchCriterion.Type,
DisplayName = viewModel.CriteriaName,
SearchOperator = (int)viewModel.SearchOperator,
Value = viewModel.Value
};
this.memberSearchFilterService.Insert(memberSearchFilter);
return(RedirectToAction("Show", new { id = viewModel.CampaignId }));
}
internal void GenerateMemberSearchFilters(int campaignId)
{
var emptySearchCriteria = searchRepo.GetEmptySearchCriteria().ToList();
for (int i = 0; i < random.NextInt(1, 3); i++)
{
var criteria = random.PickFromList(emptySearchCriteria);
emptySearchCriteria.Remove(criteria);
var criterionInfo = GenerateCriterion(criteria);
var searchFilter = new MemberSearchFilter
{
CampaignId = campaignId,
DisplayName = criteria.DisplayName,
InternalName = criteria.InternalName,
FilterType = criterionInfo.FilterType,
SearchOperator = criterionInfo.Operator,
Value = criterionInfo.Value
};
searchFilters.Insert(searchFilter);
}
}
public void Update(MemberSearchFilter item)
{
db.MemberSearchFilters.UpdateById(item);
}
public MemberSearchFilter Insert(MemberSearchFilter memberSearchFilter)
{
return db.MemberSearchFilters.Insert(memberSearchFilter);
}
public JsonResult SearchMember(GridSettings gridSettings)
{
MemberSearchFilter filter = new MemberSearchFilter();
if (gridSettings.IsSearch)
{
filter.Email = gridSettings.Where.rules.Any(r => r.field == "Email") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "Email").data : string.Empty;
filter.UserName = gridSettings.Where.rules.Any(r => r.field == "FullName") ?
gridSettings.Where.rules.FirstOrDefault(r => r.field == "FullName").data : string.Empty;
}
filter.Role = MemberRoles.Contributor;
int totalRecords = 0;
var applicationUsers = _memberService.searchMember(filter, gridSettings.SortColumn, gridSettings.SortOrder, gridSettings.PageSize, gridSettings.PageIndex, out totalRecords);
var jsonData = new
{
total = totalRecords / gridSettings.PageSize + 1,
page = gridSettings.PageIndex,
records = totalRecords,
rows = (
from a in applicationUsers
select new
{
Id = a.Id,
FullName = a.FullName,
Email = a.Email,
PhoneNumber = a.PhoneNumber,
Country = a.Country.CodeName
}
)
};
return Json(jsonData);
}
public void Insert(MemberSearchFilter memberSearchFilter)
{
_repository.Insert(memberSearchFilter);
}
public MemberSearchFilter Insert(MemberSearchFilter memberSearchFilter)
{
return(db.MemberSearchFilters.Insert(memberSearchFilter));
}
public void Update(MemberSearchFilter item)
{
db.MemberSearchFilters.UpdateById(item);
}
