protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strTCSID = string.Empty;
string strTCid = string.Empty;
try
{
strTCSID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString();
if (GlobalMethods.ValueIsNull(strTCSID).Length > 0)
{
strTCSID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
}
#region Getting Class Details
clsLK_Inst_CourseSchedule objCS = new clsLK_Inst_CourseSchedule();
objCS = LK_Inst_CourseScheduleDAL.SelectLK_Inst_CourseScheduleById(Convert.ToInt32(strTCSID));
if (objCS != null)
{
clsUser objUser = new clsUser();
objUser = UserDAL.SelectUserById(objCS.AuthorisedUserId);
if (objUser != null)
{
lblCrouseName.Text = objUser.FName + " " + objUser.LName;
}
}
#endregion
#region Checking if this records is already saved.
List <clsCourse_Result> objCRsave = new List <clsCourse_Result>();
objCRsave = Course_ResultDAL.SelectDynamicCourse_Result("Inst_CourseSchId = " + strTCSID + "", "ClassResultId");
if (objCRsave != null)
{
if (objCRsave.Count > 0)
{
// this records already exsistes
btnAddTManual.Enabled = false;
dropAttendence.Enabled = false;
dropPassFail.Enabled = false;
dropScore.Enabled = false;
}
else
{
btnAddTManual.Enabled = true;
dropAttendence.Enabled = true;
dropPassFail.Enabled = true;
dropScore.Enabled = true;
}
}
#endregion
//strTCid = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTCid.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString();
pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'>" + GlobalMethods.ContractorAppStatus(9, "bar", "Inst_MgmtCourses.aspx?dash=active") + "</div>"));
}
catch (Exception)
{
ErrorHandler.ErrorPage();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region User and Company Info
clsUser objEmp = new clsUser();
objEmp = UserDAL.SelectUserById(Convert.ToInt32(Session["UserAuthId"].ToString()));
#endregion
#region Getting User Info
// for side menu. if 3 hide. else show.
if (objEmp != null)
{
if (GlobalMethods.ValueIsNull(objEmp.ImageURL).Length > 0)
{
// phProfileImg.Controls.Add(new LiteralControl("<img src='" + objEmp.ImageURL.ToEncryptUrl() + "' width='35%' class='img-circle m-b m-t-md, img-responsive' alt='" + GlobalMethods.stringToMixedCase(objEmp.FName + " " + objEmp.LName) + "'>"));
//lblUserName.Text = "<span>" + GlobalMethods.stringToMixedCase(objEmp.FName + " " + objEmp.LName).ToUpper() + "</span>";
// lblUserIs.Text = "<span>" + GlobalMethods.stringToMixedCase(objEmp.FName + " " + objEmp.LName) + "</span>";
//lblDateJoin.Text = Convert.ToDateTime(objEmp.CreatedDate).ToLongDateString();
}
else
{
// phProfileImg.Controls.Add(new LiteralControl("<img src='CSSBackEnd/img/imagemissing.png' width='35%' class='img-circle m-b m-t-md, img-responsive' alt='" + GlobalMethods.stringToMixedCase(objEmp.FName + " " + objEmp.LName) + "'>"));
// lblUserName.Text = "<span>" + GlobalMethods.stringToMixedCase(objEmp.FName + " " + objEmp.LName).ToUpper() + "</span>";
// lblUserIs.Text = "<span>" + GlobalMethods.stringToMixedCase(objEmp.FName + " " + objEmp.LName) + "</span>";
// lblDateJoin.Text = Convert.ToDateTime(objEmp.CreatedDate).ToLongDateString();
}
//pnlMDEAccess
#region Now getting all the UserRole and making sure buttons are displayed accordingly.
List <clsUserRole> lstURole = new List <clsUserRole>();
lstURole = UserRoleDAL.SelectDynamicUserRole("AuthorizedUserId = " + objEmp.AuthorisedUserId + "", "UserRoleId");
if (lstURole != null)
{
if (lstURole.Count > 0)
{
for (int i = 0; i < lstURole.Count; i++)
{
// This is MDE Role
}
}
}
#endregion
#region Getting all the totals for dashboard
List <clsCategory> lstMDECourse = new List <clsCategory>();
lstMDECourse = CategoryDAL.SelectAllCategory();
if (lstMDECourse != null)
{
if (lstMDECourse.Count > 0)
{
TotalMDECourses = lstMDECourse.Count.ToString();
}
}
#endregion
#region Getting all the Pending Contractor Acc Applications
TotalContractorPendingApps = "0";
List <dynamic> lstValues;
string strSQL = @"SELECT tbl_SP_Contractor.SPContractorID, tbl_SP_Contractor.ACRDCatID, tbl_SP_Contractor.SPName, tbl_SP_Contractor.AccreditationID, tbl_SP_Contractor.AccreditationExpirationDate,
tbl_SP_Contractor.IsActive, tbl_Category.CatTitle, tbl_SP_Contractor.CreatedDate
FROM tbl_SP_Contractor INNER JOIN
tbl_Category ON tbl_SP_Contractor.ACRDCatID = tbl_Category.ACRDCatID
WHERE (tbl_SP_Contractor.SPContractorID NOT IN
(SELECT SPContractorID
FROM tbl_Contractor_Approval))";
var objPar = new DynamicParameters();
try
{
//objPar.Add("@CompanyId", CompanyId, dbType: DbType.Int32);
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
lstValues = db.Query <dynamic>(strSQL, objPar, commandType: CommandType.Text).ToList();
if (lstValues != null)
{
if (lstValues.Count > 0)
{
TotalContractorPendingApps = lstValues.Count.ToString();
}
}
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
#endregion
#region Getting all New Training Provider Application
TotalTP_Apps = "0";
List <dynamic> lstTPTotal;
string strSQL3 = @"SELECT tbl_TrainingProvider.TP_Name, tbl_TrainingProvider.TPId, tbl_TrainingProvider.CreatedDate, tbl_Instructor.AccreditationID, tbl_Instructor.AccreditationExpirationDate, tbl_Instructor.Instructor_FName,
tbl_Instructor.Instructor_LName
FROM tbl_TrainingProvider INNER JOIN
tbl_TP_Instructors ON tbl_TrainingProvider.TPId = tbl_TP_Instructors.TPId INNER JOIN
tbl_Instructor ON tbl_TP_Instructors.TP_InstructorListId = tbl_Instructor.InstructorId
WHERE (tbl_TrainingProvider.TPId NOT IN
(SELECT TPId
FROM tbl_TP_Approval))";
var objPar3 = new DynamicParameters();
try
{
//objPar.Add("@CompanyId", CompanyId, dbType: DbType.Int32);
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
lstTPTotal = db.Query <dynamic>(strSQL3, objPar3, commandType: CommandType.Text).ToList();
if (lstTPTotal != null)
{
if (lstTPTotal.Count > 0)
{
TotalTP_Apps = lstTPTotal.Count.ToString();
}
}
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
#endregion
#region Getting all the New Instructor Applications
List <dynamic> lstInstructorApps;
string strSQL4 = @"SELECT Instructor_FName, Instructor_LName, InstructorId, AccreditationID, AccreditationExpirationDate
FROM tbl_Instructor
WHERE (InstructorId NOT IN
(SELECT InstructorId
FROM tbl_Instructor_Approval))";
var objPar4 = new DynamicParameters();
try
{
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
lstInstructorApps = db.Query <dynamic>(strSQL4, objPar4, commandType: CommandType.Text).ToList();
if (lstInstructorApps != null)
{
if (lstInstructorApps.Count > 0)
{
TotalInstructor_Apps = lstInstructorApps.Count.ToString();
}
}
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
#endregion
#region Getting all the New Certifications.
List <clsCourse_Result> lstCR = new List <clsCourse_Result>();
lstCR = Course_ResultDAL.SelectDynamicCourse_Result("(IsActive = -1) and (Cast(Acct_Term as int) > 0)", "ClassResultId");
if (lstCR != null)
{
if (lstCR.Count > 0)
{
TotalMDECertifications = lstCR.Count.ToString();
}
}
#endregion
#region Getting New Inspector and Risk Assessor
TotalRisk_Apps = "0";
List <dynamic> lstRiskAssesorApps;
string strSQL6 = @"SELECT InspectorRiskAssId
FROM tbl_Inspector_RiskAssessor
WHERE (InspectorRiskAssId NOT IN
(SELECT InspectorRiskAssId
FROM tbl_RiskAssessor_Approval))";
var objPar6 = new DynamicParameters();
try
{
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
lstRiskAssesorApps = db.Query <dynamic>(strSQL6, objPar6, commandType: CommandType.Text).ToList();
if (lstRiskAssesorApps != null)
{
if (lstRiskAssesorApps.Count > 0)
{
TotalRisk_Apps = lstRiskAssesorApps.Count.ToString();
}
}
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
#endregion
#region Getting New Supervisor
TotalSuper_Apps = "0";
List <dynamic> lstSuper_Apps;
string strSQL7 = @"SELECT SupervisorId
FROM tbl_Supervisor
WHERE (SupervisorId NOT IN
(SELECT SupervisorId
FROM tbl_Supervisor_Approval))";
var objPar7 = new DynamicParameters();
try
{
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
lstSuper_Apps = db.Query <dynamic>(strSQL7, objPar7, commandType: CommandType.Text).ToList();
if (lstSuper_Apps != null)
{
if (lstSuper_Apps.Count > 0)
{
TotalSuper_Apps = lstSuper_Apps.Count.ToString();
}
}
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
#endregion
#region Getting New Training Courses
TotalTrainingCourses = "0";
List <dynamic> lstTCourses;
string strSQL8 = @"SELECT TrainingCourseAppId
FROM tbl_TrainingCourse
WHERE (TrainingCourseAppId NOT IN
(SELECT TrainingCourseAppId
FROM tbl_TrainingCourse_Approval))";
var objPar8 = new DynamicParameters();
try
{
using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"]))
{
lstTCourses = db.Query <dynamic>(strSQL8, objPar8, commandType: CommandType.Text).ToList();
if (lstTCourses != null)
{
if (lstTCourses.Count > 0)
{
TotalTrainingCourses = lstTCourses.Count.ToString();
}
}
}
}
catch (Exception ex)
{
ErrorHandler.ErrorLogging(ex, false);
ErrorHandler.ReadError();
}
#endregion
}
#endregion
}
}
