private void FillData()
{
ServiceInfoManager _ServiceInfoManager = new ServiceInfoManager();
SSAManager _SSAManager = new SSAManager();
var user = AspNetSecurityHelper.currentAppUser;
if (user != null)
{
var obj = _ServiceInfoManager.GetAllServiceInfo();
if (user.UserTypeId == 2) // Supervisor
{
if (user.UniversityId.HasValue)
{
var ssa = _SSAManager.GetSSAByUniversityId(user.UniversityId.Value);
//var ssa = _SSAManager.GetSSAByAdministratorId(user.Id);
if (ssa != null)
{
obj = _ServiceInfoManager.GetAllBySSAId(ssa.Id);
}
else
{
obj = null;
}
}
}
if (obj != null)
{
var data = from tbl in obj
select new
{
tbl.Id,
tbl.Title,
tbl.Description,
tbl.Section,
tbl.Address,
ServiceCategory = tbl.ServiceCategory.Name,
SSA = (String.IsNullOrEmpty(tbl.SaudiStudentAssociation.Name) ? "" : tbl.SaudiStudentAssociation.Name + " - ") + tbl.SaudiStudentAssociation.University.Name + (tbl.SaudiStudentAssociation.State != null ? " - " + tbl.SaudiStudentAssociation.State.Name : "") + (tbl.SaudiStudentAssociation.City != null ? " - " + tbl.SaudiStudentAssociation.City.Name : ""),
ssaId = tbl.SaudiStudentAssociationId,
ServiceDetailsCount = tbl.ServiceDetails.Where(w => w.DeletedFlag == false).Count()
};
string ssa = ddlSSA.SelectedValue;
int ssaId = 0;
if (int.TryParse(ssa, out ssaId) && ssaId != 0)
{
data = data.Where(w => w.ssaId == ssaId).ToList();
}
GridView1.DataSource = data.ToList();
}
}
GridView1.DataBind();
}
private void FillData()
{
SSAManager _SSAManager = new SSAManager();
var obj = _SSAManager.GetAllSSA();
if (obj != null)
{
var data = from tbl in obj
where tbl.DeletedFlag == false
select new
{
tbl.Id,
tbl.Name,
University = (tbl.University != null ? tbl.University.Name : ""),
State = (tbl.State != null ? tbl.State.Name : ""),
City = (tbl.City != null ? tbl.City.Name : ""),
tbl.ZipCode,
tbl.Phone,
tbl.Fax,
tbl.Email,
tbl.Website,
tbl.SocialInfo,
tbl.Street,
ServiceCount = tbl.ServiceInformations.Where(w => w.DeletedFlag == false).Count()
};
//rptdata.DataSource = data;
AssCount = obj.Count().ToString();
}
else
{
AssCount = "0";
}
//rptdata.DataBind();
ServiceInfoManager _ServiceInfoManager = new ServiceInfoManager();
var svc = _ServiceInfoManager.GetAllServiceInfo().Where(w => w.DeletedFlag == false);
if (svc != null)
{
SvcInfoCount = svc.Count().ToString();
}
else
{
SvcInfoCount = "0";
}
}
