public static List <Course> GetUserContentModule(CurriculumGeneral Curriculum)
{
try
{
Course objContentModule;
List <Course> lstContentModule = new List <Course>();
DbProviderFactory fact = DbProviderFactories.GetFactory("System.Data.SqlClient");
//string LearnerID = "";
using (DbConnection conn = Config.GetConnection())
{
DbCommand cmd = fact.CreateCommand();
cmd.CommandTimeout = 0;
cmd.Connection = conn;
cmd.CommandText = "GetUserContentModule";
cmd.Parameters.Add(Config.GetParameter(fact, "@LearnerId", Curriculum.LearnerId));
cmd.Parameters.Add(Config.GetParameter(fact, "@CurriculumId", Curriculum.CurriculumId));
cmd.CommandType = CommandType.StoredProcedure;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
objContentModule = new Course();
objContentModule.ActivityId = reader["ActivityId"].ToString();
objContentModule.CurriculumId = Curriculum.CurriculumId;
objContentModule.ContentModuleName = reader["ContentModuleName"].ToString();
objContentModule.ContentModuleDescription = reader["ContentModuleDescription"].ToString();
objContentModule.ContentTrackId = reader["ContentTrackId"].ToString();
objContentModule.CompletionStatus = reader["CompletionStatus"].ToString();
objContentModule.DateOfCompletion = reader["DateOfCompletion"].ToString();
objContentModule.DateOfStart = reader["DateOfStart"].ToString();
objContentModule.NoOfPagesCompleted = reader["NoOfPagesCompleted"].ToString();
objContentModule.percentCompleted = reader["percentCompleted"].ToString();
objContentModule.TotalNoOfPages = reader["TotalNoOfPages"].ToString();
objContentModule.Score = reader["Score"].ToString();
objContentModule.PassFailStatus = reader["PassFailStatus"].ToString();
objContentModule.IsHTML5 = reader["IsHTML5"].ToString();
objContentModule.DisplayOrder = reader["DisplayOrder"].ToString();
lstContentModule.Add(objContentModule);
}
}
}
return(lstContentModule);
}
catch (Exception ex)
{
clsErrorhandling objerror = new clsErrorhandling();
objerror.LogException(ex, "ContentModule", "GetUserContentModule");
return(null);
}
}
public static List <CurriculumGeneral> GetUserCurriculum(Learner objLeaner)
{
try
{
CurriculumGeneral objCurriculumGeneral;
List <CurriculumGeneral> lstCurriculumGeneral = new List <CurriculumGeneral>();
DbProviderFactory fact = DbProviderFactories.GetFactory(Config.DbType);
//string LearnerID = "";
using (DbConnection conn = Config.GetConnection())
{
DbCommand cmd = fact.CreateCommand();
cmd.CommandTimeout = 0;
cmd.Connection = conn;
cmd.CommandText = "GetUserCurriculum";
cmd.Parameters.Add(Config.GetParameter(fact, "@LearnerId", objLeaner.LearnerId));
cmd.CommandType = CommandType.StoredProcedure;
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
objCurriculumGeneral = new CurriculumGeneral();
objCurriculumGeneral.CurriculumId = reader["CurriculumId"].ToString();
objCurriculumGeneral.CurriculumName = reader["CurriculumName"].ToString();
objCurriculumGeneral.CurriculumDescription = reader["CurriculumDescription"].ToString();
//objCurriculumGeneral.CreateDate = reader["CreateDate"].ToString();
//objCurriculumGeneral.LastmodifiedDate = reader["LastmodifiedDate"].ToString();
objCurriculumGeneral.CurriculumTrackId = reader["CurriculumTrackId"].ToString();
objCurriculumGeneral.CompletionStatus = reader["CompletionStatus"].ToString();
objCurriculumGeneral.DateOfStart = reader["DateOfStart"].ToString();
objCurriculumGeneral.DateOfCompletion = reader["DateOfCompletion"].ToString();
objCurriculumGeneral.EnableSequencing = Convert.ToString(reader["enableSequencing"]);
objCurriculumGeneral.LearnerId = objLeaner.LearnerId;
lstCurriculumGeneral.Add(objCurriculumGeneral);
}
}
}
return(lstCurriculumGeneral);
}
catch (Exception ex)
{
clsErrorhandling objerror = new clsErrorhandling();
objerror.LogException(ex, "CurriculumGeneral", "GetUserCurriculum");
return(null);
}
}
public static List <Course> GetUserContentModule(CurriculumGeneral Curriculum)
{
return(CourseDAL.GetUserContentModule(Curriculum));
}