public List<CalendarBE> GetAssessmentList(Int64 CourseID)
{
List<CalendarBE> GenericList = new List<CalendarBE>();
try
{
DbCommand objSelectCommand = objDB.GetStoredProcCommand("Get_AssessmentsByCourseID");
objDB.AddInParameter(objSelectCommand, "@CourseID", DbType.Int32, CourseID);
IDataReader drList = objDB.ExecuteReader(objSelectCommand);
while (drList.Read())
{
CalendarBE GenericEntity = new CalendarBE();
if (!drList.IsDBNull(0))
GenericEntity.AssessmentID = drList.GetInt32(0);
if (!drList.IsDBNull(1))
GenericEntity.CourseDetailID = drList.GetInt32(1);
if (!drList.IsDBNull(2))
GenericEntity.AssessmentTypeID = drList.GetInt32(2);
if (!drList.IsDBNull(3))
GenericEntity.Name = drList.GetString(3);
if (!drList.IsDBNull(4))
GenericEntity.Description = drList.GetString(4);
if (!drList.IsDBNull(5))
GenericEntity.DateDue = drList.GetDateTime(5);
if (!drList.IsDBNull(6))
GenericEntity.PointsPossible = drList.GetString(6);
if (!drList.IsDBNull(9))
GenericEntity.DateAdded=drList.GetDateTime(9);
if (!drList.IsDBNull(13))
GenericEntity.AssessmentTypeName = drList.GetString(13);
GenericList.Add(GenericEntity);
}
if (!drList.IsClosed)
drList.Close();
return GenericList;
}
catch (Exception ex)
{
return GenericList;
}
}
public List<CalendarBE> GetMyAssessment(Int64 AccountID)
{
List<CalendarBE> GenericList = new List<CalendarBE>();
try
{
DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_Get_MyAssessment");
objDB.AddInParameter(objSelectCommand, "@AccountID", DbType.Int64, AccountID);
IDataReader drList = objDB.ExecuteReader(objSelectCommand);
while (drList.Read())
{
CalendarBE GenericEntity = new CalendarBE();
if (!drList.IsDBNull(0))
GenericEntity.AssessmentID = drList.GetInt32(0);
if (!drList.IsDBNull(3))
GenericEntity.Name = drList.GetString(3);
if (!drList.IsDBNull(4))
GenericEntity.Description = drList.GetString(4);
if (!drList.IsDBNull(5))
GenericEntity.DateDue = drList.GetDateTime(5);
if (!drList.IsDBNull(6))
GenericEntity.PointsPossible = drList.GetString(6);
else
GenericEntity.PointsPossible = string.Empty;
if (!drList.IsDBNull(7))
GenericEntity.CourseTitle = drList.GetString(7);
else
GenericEntity.CourseTitle = string.Empty;
if (!drList.IsDBNull(11))
GenericEntity.AccountID = drList.GetInt64(11);
if (!drList.IsDBNull(13))
GenericEntity.AssessmentTypeName = drList.GetString(13);
if (!drList.IsDBNull(14))
GenericEntity.color= drList.GetString(14);
GenericList.Add(GenericEntity);
}
if (!drList.IsClosed)
drList.Close();
return GenericList;
}
catch (Exception ex)
{
return GenericList;
}
}
public List<CalendarBE> GetCourseColor(Int64 AccountID)
{
List<CalendarBE> GenericList = new List<CalendarBE>();
try
{
DbCommand objSelectCommand = objDB.GetStoredProcCommand("CL_GetStudentCourses");
objDB.AddInParameter(objSelectCommand, "@AccountID", DbType.Int64, AccountID);
IDataReader drList = objDB.ExecuteReader(objSelectCommand);
while (drList.Read())
{
CalendarBE GenericEntity = new CalendarBE();
if (!drList.IsDBNull(0))
GenericEntity.CourseDetailID = drList.GetInt32(0);
if (!drList.IsDBNull(2))
GenericEntity.CourseTitle = drList.GetString(2);
if (!drList.IsDBNull(4))
GenericEntity.color = drList.GetString(4);
GenericList.Add(GenericEntity);
}
if (!drList.IsClosed)
drList.Close();
return GenericList;
}
catch (Exception ex)
{
return GenericList;
}
}
