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"; } }