public ActionResult Index(AcquireEmailSearchModel model) { var referenceDate = new DateTime(2017, (DateTime.Today.AddMonths(-4)).Month, 1); IQueryable <AcquireEmail> list; if (User.IsInRole("Administrator") || User.IsInRole("Superadmin") || User.IsInRole("Management")) { list = _db.AcquireEmails.Where(x => x.InsertDate >= referenceDate); } else { //list = _db.AcquireEmails.Where(ae => ae.AcquireEmailStatus != AcquireEmailStatusEnum.Verified && ae.AssignedTo == User.Identity.Name); list = _db.AcquireEmails.Where(x => x.InsertDate >= referenceDate && x.AcquireEmailStatus != AcquireEmailStatusEnum.Verified && x.AssignedTo == User.Identity.Name && (!(x.Organization.OrganizationDetail.TelephoneNumber == String.Empty || x.Organization.OrganizationDetail.TelephoneNumber == null) || !(x.Organization.OrganizationDetail.MobilePhoneNumber == String.Empty || x.Organization.OrganizationDetail.MobilePhoneNumber == null))); } //Search Engine if (!String.IsNullOrEmpty(model.CampaignName)) { list = list.Where(x => x.Campaign.CampaignName.Contains(model.CampaignName)); } if (!String.IsNullOrEmpty(model.OrganizationName)) { list = list.Where(x => x.Organization.SubjectName.Contains(model.OrganizationName)); } if (!String.IsNullOrEmpty(model.TelephoneMobile)) { list = list.Where(x => x.Organization.OrganizationDetail.TelephoneNumber.EndsWith(model.TelephoneMobile) || x.Organization.OrganizationDetail.MobilePhoneNumber.EndsWith(model.TelephoneMobile)); } if (!String.IsNullOrEmpty(model.Mail)) { list = list.Where(x => x.Organization.MerDeliveryDetail.AcquiredReceivingInformation.Contains(model.Mail)); } if (model.EmailStatusEnum != null) { var tempStatus = (AcquireEmailStatusEnum)model.EmailStatusEnum; list = list.Where(x => x.AcquireEmailStatus == tempStatus); } if (model.EntityStatusEnum != null) { var tempStatus = (AcquireEmailEntityStatusEnum)model.EntityStatusEnum; list = list.Where(x => x.AcquireEmailEntityStatus == tempStatus); } return(View(list.OrderByDescending(x => x.Id))); }
public ActionResult IndexTemp(AcquireEmailSearchModel model) { var list = _db.AcquireEmails.Where(x => (x.Organization.OrganizationDetail.TelephoneNumber == String.Empty || x.Organization.OrganizationDetail.TelephoneNumber == null) && (x.Organization.OrganizationDetail.MobilePhoneNumber == String.Empty || x.Organization.OrganizationDetail.MobilePhoneNumber == null) && x.AcquireEmailStatus == AcquireEmailStatusEnum.Created); //Search Engine if (!String.IsNullOrEmpty(model.CampaignName)) { list = list.Where(x => x.Campaign.CampaignName.Contains(model.CampaignName)); } if (!String.IsNullOrEmpty(model.OrganizationName)) { list = list.Where(x => x.Organization.SubjectName.Contains(model.OrganizationName)); } if (!String.IsNullOrEmpty(model.TelephoneMobile)) { //list = list.Where(x => x.Organization.MerDeliveryDetail.Telephone.Contains(model.TelephoneMail) || x.Organization.MerDeliveryDetail.AcquiredReceivingInformation.Contains(model.TelephoneMail)); list = list.Where(x => x.Organization.OrganizationDetail.TelephoneNumber.EndsWith(model.TelephoneMobile) || x.Organization.OrganizationDetail.MobilePhoneNumber.EndsWith(model.TelephoneMobile)); } if (!String.IsNullOrEmpty(model.Mail)) { list = list.Where(x => x.Organization.MerDeliveryDetail.AcquiredReceivingInformation.Contains(model.Mail)); } if (model.EmailStatusEnum != null) { var tempStatus = (AcquireEmailStatusEnum)model.EmailStatusEnum; list = list.Where(x => x.AcquireEmailStatus == tempStatus); } if (model.EntityStatusEnum != null) { var tempStatus = (AcquireEmailEntityStatusEnum)model.EntityStatusEnum; list = list.Where(x => x.AcquireEmailEntityStatus == tempStatus); } return(View(list.OrderByDescending(x => x.Id))); }