private void FillData() { using (HajjCrawdsMngEntities cntx = new HajjCrawdsMngEntities()) { var obj = (from m in cntx.SaudiStudentAssociations join d in cntx.ServiceInformations on m.Id equals d.SaudiStudentAssociationId into joined from d in joined.DefaultIfEmpty() select new { Id = m.Id, m.StateId, m.CityId, d.ServiceCategoryId }).ToList(); string stateValue = ddlState.SelectedItem.Value; int stateId = 0; if (int.TryParse(stateValue, out stateId) && stateId != 0) { obj = obj.Where(w => w.StateId == stateId).ToList(); } string city = ddlCity.SelectedItem.Value; int cityid = 0; if (int.TryParse(city, out cityid) && cityid != 0) { obj = obj.Where(w => w.CityId == cityid).ToList(); } string svcCat = ddlServiceCategory.SelectedItem.Value; int svcCatId = 0; if (int.TryParse(svcCat, out svcCatId) && svcCatId != 0) { obj = obj.Where(w => w.ServiceCategoryId == svcCatId).ToList(); } if (obj != null) { List <int> ids = obj.Select(ss => ss.Id).Distinct().ToList(); var data = (from m in cntx.SaudiStudentAssociations where ids.Contains(m.Id) select new { Id = m.Id, Name = m.Name, m.StateId, m.CityId, University = (m.University != null ? m.University.Name : ""), State = (m.State != null ? m.State.Name : ""), City = (m.City != null ? m.City.Name : ""), m.ZipCode, ServiceCount = m.ServiceInformations.Where(w => w.DeletedFlag == false).Count() }).Distinct().ToList(); rptdata.DataSource = data; } } rptdata.DataBind(); }
private void FillData() { SSAManager _SSAManager = new SSAManager(); ServiceInfoManager _ServiceInfoManager = new ServiceInfoManager(); string str = txtSearch.Text; if (!String.IsNullOrEmpty(str)) { using (HajjCrawdsMngEntities cntx = new HajjCrawdsMngEntities()) { var obj = (from m in cntx.SaudiStudentAssociations join d in cntx.ServiceInformations on m.Id equals d.SaudiStudentAssociationId where (m.Name.Contains(str)) || (m.Email.Contains(str)) || (m.SocialInfo.Contains(str)) || (m.State != null && m.State.Name.Contains(str)) || (m.City != null && m.City.Name.Contains(str)) || (m.University != null && m.University.Name.Contains(str)) || (d != null && d.ServiceCategory != null && d.ServiceCategory.Name.Contains(str)) || (d != null && d.Title.Contains(str)) select new { Id = m.Id, Name = m.Name, University = m.University.Name, State = m.State.Name, City = m.City.Name, m.ZipCode, ServiceCount = m.ServiceInformations.Where(w => w.DeletedFlag == false).Count() }).Distinct().ToList(); if (obj != null) { rptdata.DataSource = obj; } } } rptdata.DataBind(); }
public ServiceCategoryRepository() { _context = new HajjCrawdsMngEntities(); }
public UniversityRepository() { _context = new HajjCrawdsMngEntities(); }
public UserRepository() { _context = new HajjCrawdsMngEntities(); }
public MessageRepository() { _context = new HajjCrawdsMngEntities(); }
public NotificationRepository() { _context = new HajjCrawdsMngEntities(); }
public ServiceInfoRepository() { _context = new HajjCrawdsMngEntities(); }
public ServiceDetailsRepository() { _context = new HajjCrawdsMngEntities(); }