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