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