/// <summary>
/// Check for invalid file extension, returns auto generated file name
/// </summary>
/// <param name="pFileName">Original file name</param>
/// <returns>auto generated file name</returns>
public string ValidateFile(string pFileName)
{
string strFileName = String.Empty;
if (!String.IsNullOrEmpty(pFileName) &&
!pFileName.ToLower().EndsWith(".exe") &&
!pFileName.ToLower().EndsWith(".dll"))
{
strFileName += IDGenerator.GetStringGUID();
if (pFileName.LastIndexOf(".") > 0)
{
strFileName += pFileName.Substring(pFileName.LastIndexOf(".") - 1);
}
}
return(strFileName);
}
/// <summary>
/// Bulk Update
/// </summary>
/// <param name="pEntListTracking"></param>
/// <param name="pIsBulkMarkCompleted"></param>
/// <returns></returns>
public List <ContentModuleTracking> BulkUpdate(List <ContentModuleTracking> pEntListTracking, bool pIsBulkMarkCompleted)
{
_sqlObject = new SQLObject();
List <ContentModuleTracking> entListTracking = new List <ContentModuleTracking>();
int iBatchSize = 0;
SqlCommand _sqlcmd = null;
SqlConnection _sqlcon = null;
SqlDataAdapter _sqladapter = null;
try
{
if (pEntListTracking.Count > 0)
{
_dtable = new DataTable();
_dtable.Columns.Add(Schema.ContentModuleTracking.COL_ATTEMPT_ID);
_dtable.Columns.Add(Schema.ContentModule.COL_CONTENT_MODULE_ID);
_dtable.Columns.Add(Schema.Learner.COL_USER_ID);
_dtable.Columns.Add(Schema.ContentModuleTracking.COL_DATE_OF_COMPLETION);
_dtable.Columns.Add(Schema.ContentModuleTracking.COL_MARKED_COMPLETED_BY_ID);
_dtable.Columns.Add(Schema.ContentModuleTracking.COL_COMPLETION_STATUS);
_dtable.Columns.Add(Schema.ContentModuleTracking.COL_REVIEWER_COMMENTS);
_dtable.Columns.Add(Schema.ContentModuleTracking.COL_SCANNED_CERTIFICATION_FILE_NAME);
_dtable.Columns.Add(Schema.Common.COL_IS_BULK_MARK_COMPLETED);
foreach (ContentModuleTracking entAttempt in pEntListTracking)
{
DataRow drow = _dtable.NewRow();
if (String.IsNullOrEmpty(_strConnString))
{
_strConnString = _sqlObject.GetClientDBConnString(entAttempt.ClientId);
}
if (string.IsNullOrEmpty(entAttempt.ID))
{
entAttempt.ID = IDGenerator.GetStringGUID();
}
drow[Schema.ContentModuleTracking.COL_ATTEMPT_ID] = entAttempt.ID;
drow[Schema.ContentModule.COL_CONTENT_MODULE_ID] = entAttempt.ContentModuleId;
drow[Schema.Learner.COL_USER_ID] = entAttempt.UserID;
drow[Schema.ContentModuleTracking.COL_DATE_OF_COMPLETION] = entAttempt.DateOfCompletion;
drow[Schema.ContentModuleTracking.COL_MARKED_COMPLETED_BY_ID] = entAttempt.MarkedCompletedById;
drow[Schema.ContentModuleTracking.COL_COMPLETION_STATUS] = entAttempt.CompletionStatus.ToString();
drow[Schema.ContentModuleTracking.COL_REVIEWER_COMMENTS] = entAttempt.ReviewComments;
drow[Schema.ContentModuleTracking.COL_SCANNED_CERTIFICATION_FILE_NAME] = entAttempt.ScannedCertificationFileName;
drow[Schema.Common.COL_IS_BULK_MARK_COMPLETED] = entAttempt.IsBulkMarkCompleted;
iBatchSize = iBatchSize + 1;
_dtable.Rows.Add(drow);
entListTracking.Add(entAttempt);
}
if (_dtable.Rows.Count > 0)
{
_sqlcmd = new SqlCommand();
_sqlcmd.CommandText = Schema.ContentModuleTracking.PROC_UPDATE_MARK_COMPLETED;
_sqlcmd.CommandType = CommandType.StoredProcedure;
_sqlcon = new SqlConnection(_strConnString);
_sqlcmd.Connection = _sqlcon;
_sqlcmd.Parameters.Add(Schema.ContentModuleTracking.PARA_ATTEMPT_ID, SqlDbType.VarChar, 100, Schema.ContentModuleTracking.COL_ATTEMPT_ID);
_sqlcmd.Parameters.Add(Schema.ContentModule.PARA_CONTENT_MODULE_ID, SqlDbType.VarChar, 100, Schema.ContentModule.COL_CONTENT_MODULE_ID);
_sqlcmd.Parameters.Add(Schema.Learner.PARA_USER_ID, SqlDbType.VarChar, 100, Schema.Learner.COL_USER_ID);
_sqlcmd.Parameters.Add(Schema.ContentModuleTracking.PARA_COMPLETED_DATE, SqlDbType.DateTime, 20, Schema.ContentModuleTracking.COL_DATE_OF_COMPLETION);
_sqlcmd.Parameters.Add(Schema.ContentModuleTracking.PARA_MARKED_COMPLETED_BY_ID, SqlDbType.VarChar, 100, Schema.ContentModuleTracking.COL_MARKED_COMPLETED_BY_ID);
_sqlcmd.Parameters.Add(Schema.ContentModuleTracking.PARA_COMPLETION_STATUS, SqlDbType.NVarChar, 100, Schema.ContentModuleTracking.COL_COMPLETION_STATUS);
_sqlcmd.Parameters.Add(Schema.ContentModuleTracking.PARA_REVIEWER_COMMENTS, SqlDbType.NVarChar, 2000, Schema.ContentModuleTracking.COL_REVIEWER_COMMENTS);
_sqlcmd.Parameters.Add(Schema.ContentModuleTracking.PARA_SCANNED_CERTIFICATION_FILE_NAME, SqlDbType.VarChar, 500, Schema.ContentModuleTracking.COL_SCANNED_CERTIFICATION_FILE_NAME);
_sqlcmd.Parameters.Add(Schema.Common.PARA_IS_BULK_MARK_COMPLETED, SqlDbType.Bit, 1, Schema.Common.COL_IS_BULK_MARK_COMPLETED);
_sqladapter = new SqlDataAdapter();
_sqladapter.InsertCommand = _sqlcmd;
_sqladapter.InsertCommand.CommandTimeout = 0;
_sqladapter.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
_sqladapter.UpdateBatchSize = iBatchSize;
_sqladapter.Update(_dtable);
_sqladapter.Dispose();
}
}
}
catch (Exception expCommon)
{
//_expCustom = new CustomException(_strMessageId, CustomException.WhoCallsMe(), ExceptionSeverityLevel.Critical, expCommon, true);
//throw _expCustom;
}
return(entListTracking);
}
/// <summary>
/// Update
/// </summary>
/// <param name="pEntCourseConfiguration"></param>
/// <param name="pUpdateMode"></param>
/// <returns></returns>
private CourseConfiguration Update(CourseConfiguration pEntCourseConfiguration, string pUpdateMode)
{
int iRows = 0;
_sqlObject = new SQLObject();
_sqlcmd = new SqlCommand();
_sqlcmd.CommandText = Schema.CourseConfiguration.PROC_UPDATE_COURSE_CONFIGURATION;
try
{
_strConnString = _sqlObject.GetClientDBConnString(pEntCourseConfiguration.ClientId);
if (pUpdateMode == Schema.Common.VAL_INSERT_MODE)
{
_sqlpara = new SqlParameter(Schema.Common.PARA_UPDATE_MODE, Schema.Common.VAL_INSERT_MODE);
pEntCourseConfiguration.ID = IDGenerator.GetStringGUID();
}
else
{
_sqlpara = new SqlParameter(Schema.Common.PARA_UPDATE_MODE, Schema.Common.VAL_UPDATE_MODE);
}
_sqlcmd.Parameters.Add(_sqlpara);
// Allowresize Parameter
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_ALLOW_RESIZE, pEntCourseConfiguration.AllowResize);
_sqlcmd.Parameters.Add(_sqlpara);
// AllowResize paramater
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_ALLOW_SCROLL, pEntCourseConfiguration.AllowScroll);
_sqlcmd.Parameters.Add(_sqlpara);
// Avpath paramater
if (!string.IsNullOrEmpty(pEntCourseConfiguration.AVPath))
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_AV_PATH, pEntCourseConfiguration.AVPath);
}
else
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_AV_PATH, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
// ClientID paramater
if (!string.IsNullOrEmpty(pEntCourseConfiguration.ClientId))
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_CLIENT_ID, pEntCourseConfiguration.ClientId);
}
else
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_CLIENT_ID, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
// Course launch New Window paramater
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_LAUNCH_NEW_WINDOW, pEntCourseConfiguration.CourseLaunchNewWindow);
_sqlcmd.Parameters.Add(_sqlpara);
// Course Launch Same Window paramater
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_LAUNCH_SAME_WINDOW, pEntCourseConfiguration.CourseLaunchSameWindow);
_sqlcmd.Parameters.Add(_sqlpara);
// Course Window Height paramater
if (pEntCourseConfiguration.CourseWindowHeight != 0)
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_WINDOW_HEIGHT, pEntCourseConfiguration.CourseWindowHeight);
}
else
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_WINDOW_HEIGHT, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
// Course Window Width paramater
if (pEntCourseConfiguration.CourseWindowWidth != 0)
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_WINDOW_WIDTH, pEntCourseConfiguration.CourseWindowWidth);
}
else
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_WINDOW_WIDTH, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
// Is Course Session No Expiry paramater
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_IS_COURSE_SESSION_NO_EXPIRY, pEntCourseConfiguration.IsCourseSessionNoExpiry);
_sqlcmd.Parameters.Add(_sqlpara);
// Mastery Score paramater
if (pEntCourseConfiguration.MasteryScore != 0)
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_MASTERY_SCORE, pEntCourseConfiguration.MasteryScore);
}
else
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_MASTERY_SCORE, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
// Max File upload Size paramater
if (pEntCourseConfiguration.MaxFileUploadSizeMB != 0)
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_MAX_FILE_UPLOAD_SIZE_MB, pEntCourseConfiguration.MaxFileUploadSizeMB);
}
else
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_MAX_FILE_UPLOAD_SIZE_MB, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
// Course Question Response Tracking paramater
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_QUESTION_RESPONSE_TRACKING, pEntCourseConfiguration.QuestionResponseTracking);
_sqlcmd.Parameters.Add(_sqlpara);
// Course Launch Same Window paramater
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_SCORE_TRACKING, pEntCourseConfiguration.ScoreTracking);
_sqlcmd.Parameters.Add(_sqlpara);
// Last Modified by ID paramater
if (!string.IsNullOrEmpty(pEntCourseConfiguration.LastModifiedById))
{
_sqlpara = new SqlParameter(Schema.Common.PARA_MODIFIED_BY, pEntCourseConfiguration.LastModifiedById);
}
else
{
_sqlpara = new SqlParameter(Schema.Common.PARA_MODIFIED_BY, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
// Course Configuration ID paramater
if (!string.IsNullOrEmpty(pEntCourseConfiguration.ID))
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_CONFIGURATION_ID, pEntCourseConfiguration.ID);
}
else
{
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_COURSE_CONFIGURATION_ID, System.DBNull.Value);
}
_sqlcmd.Parameters.Add(_sqlpara);
//-aw 6/15/2011 Added course protocol
_sqlpara = new SqlParameter(Schema.CourseConfiguration.PARA_PROTOCOL, pEntCourseConfiguration.Protocol);
_sqlcmd.Parameters.Add(_sqlpara);
iRows = _sqlObject.ExecuteNonQuery(_sqlcmd, _strConnString);
}
catch (Exception expCommon)
{
//expCommon = new CustomException(_strMessageId, CustomException.WhoCallsMe(), ExceptionSeverityLevel.Critical, expCommon, true);
throw expCommon;
}
return(pEntCourseConfiguration);
}