public List <CommunityPartnerStudentViews> GetAllCommunityPartnerStudentView() { var reader = dbHelper.GetCommunityPartnerStudentView(Constant.SP_GetCommunityPartnerStudentView); List <CommunityPartnerStudentViews> cpsvList = new List <CommunityPartnerStudentViews>(); CommunityPartnerStudentViews cpsv = null; while (reader.Read()) { cpsv = new CommunityPartnerStudentViews(); cpsv.OpportunityID = Convert.ToInt32(reader["OpportunityID"]); // cpsv.CPPID = Convert.ToInt32(reader["CPPID"]); // cpsv.CPID = Convert.ToInt32(reader["CPID"]); cpsv.Name = reader["Name"].ToString(); cpsv.StudentID = Convert.ToInt32(reader["StudentID"]); cpsv.FirstName = reader["FirstName"].ToString(); cpsv.LastName = reader["LastName"].ToString(); cpsv.SignUpStatus = reader["SignUpStatus"].ToString(); cpsv.SectionID = Convert.ToInt32(reader["SectionID"]); cpsv.SectionName = reader["SectionName"].ToString(); cpsv.ProfessorID = Convert.ToInt32(reader["ProfessorID"]); cpsv.ProfessorFirstName = reader["ProfessorFirstName"].ToString(); cpsv.ProfessorLastName = reader["ProfessorLastName"].ToString(); cpsv.TotalHoursVolunteered = Convert.ToInt32(reader["TotalHoursVolunteered"]); cpsv.PartnerApprovedHours = Convert.ToInt32(reader["PartnerApprovedHours"]); // cpsv.ProfessorEmail = reader["ProfessorEmail"].ToString(); cpsvList.Add(cpsv); } return(cpsvList); }
public void DataBind() { CommunityPartnerStudentViews Cpsv = new CommunityPartnerStudentViews(); List <CommunityPartnerStudentViews> CpsvList = Cpsv.GetAllCommunityPartnerStudentView(); if (CpsvList.Count == 0) { CommunityPartnerStudentViews cpsv = new CommunityPartnerStudentViews(); CpsvList.Add(cpsv); gvCommunityPartnerStudentView.DataSource = CpsvList; gvCommunityPartnerStudentView.DataBind(); gvCommunityPartnerStudentView.Rows[0].Visible = false; } else { gvCommunityPartnerStudentView.DataSource = CpsvList; gvCommunityPartnerStudentView.DataBind(); } }