protected void AddTManual_Click(object sender, EventArgs e) { Security objSecurity = new Security(); string vAcctNum = objSecurity.KillChars(txtAcctNumber.Text); List <clsInstructor> lstInstructors = new List <clsInstructor>(); lstInstructors = InstructorDAL.SelectDynamicInstructor("IsActive = 1", "InstructorId"); if (lstInstructors != null) { if (lstInstructors.Count > 0) { for (int i = 0; i < lstInstructors.Count; i++) { showInstructors(pnlInstructors, lstInstructors[i].Instructor_FName + " " + lstInstructors[i].Instructor_LName, lstInstructors[i].Instructor_Email, lstInstructors[i].AccreditationID.ToString(), Convert.ToDateTime(lstInstructors[i].AccreditationExpirationDate).ToShortDateString(), lstInstructors[i].InstructorId.HasValue ? lstInstructors[i].InstructorId.Value : 0); } } } #region Instructor Info //string vTPID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(dropTPs.SelectedItem.Value), AppConstants.secretKey, AppConstants.initVec).ToString(); //string vCategory = objcryptoJS.AES_decrypt(dropCategory.SelectedItem.Value, AppConstants.secretKey, AppConstants.initVec).ToString(); //string vInstructorFName = objSecurity.KillChars(txtInstructorFName.Text); //string vInstructorLName = objSecurity.KillChars(txtInstructorLName.Text); //string vInsAccId = objSecurity.KillChars(txtInsAccId.Text); //string vInsAccExpire = objSecurity.KillChars(txtAccdExpireDate.Text); //string vEmail = objSecurity.KillChars(txtInstEmail.Text); #endregion // intNewTPID = Convert.ToInt32(vTPID); // ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "script", "CallNotify('Instructor Added successfully!', '', 'success', 'TP_AddInstructor.aspx?desh=active');", true); }
private void BindInstructor() { int instructorId = Request.QueryString["InstructorId"].ToInt(); if (instructorId > 0) { Instructor instructorLookup = InstructorDAL.GetItem(instructorId); if (instructorLookup != null) { lblInstructorId.Text = instructorLookup.InstructorId.ToString(); lblPersonId.Text = instructorLookup.PersonId.ToString(); lblEntityTypeId.Text = instructorLookup.EntityTypeId.ToString(); lblHireDate.Text = instructorLookup.HireDate.ToShortDateString(); lblTermDate.Text = instructorLookup.TermDate.ToShortDateString(); lblCreateDate.Text = instructorLookup.CreateDate.ToShortDateString(); } else { lblMessage.Text = "Instructor could not be found."; } } else { lblMessage.Text = "Invalid Id. Instructor record could not be found."; } }
public static string Deficient(string cgi) { CryptoJS objcryptoJS = new CryptoJS(); string strURL = string.Empty; string ContractorAppId = string.Empty; try { ContractorAppId = cgi.ToString() == null ? string.Empty : cgi.ToString(); if (GlobalMethods.ValueIsNull(ContractorAppId).Length > 0) { ContractorAppId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(cgi), AppConstants.secretKey, AppConstants.initVec).ToString(); } List <clsInstructor> objSPCont = new List <clsInstructor>(); objSPCont = InstructorDAL.SelectDynamicInstructor("InstructorId = " + ContractorAppId + "", "InstructorId"); if (objSPCont != null) { objSPCont[0].IsActive = 3; if (!InstructorDAL.UpdateInstructor(objSPCont[0])) { } } } catch (Exception) { ErrorHandler.ErrorPage(); } return("MDE_InstructorAppView.aspx?InstructApps=active&cgi=" + cgi + ""); }
/// <summary> /// Saves the Instructor object to the database /// </summary> /// <param name="instructorToSave"></param> /// <returns></returns> public static int Save(Instructor instructorToSave) { int personId = SavePerson(instructorToSave); instructorToSave.PersonId = personId; return(InstructorDAL.Save(instructorToSave)); }
private void BindInstructorList() { InstructorCollection instructorList = new InstructorCollection(); instructorList = InstructorDAL.GetCollection(); rptInstructorList.DataSource = instructorList; rptInstructorList.DataBind(); }
public static int Save(Instructor instructorToSave) { int personId = SavePerson(instructorToSave); instructorToSave.PersonId = personId; //notes: call DAL to save return(InstructorDAL.Save(instructorToSave)); }
private void LoginBtn_Click(object sender, EventArgs e) { Instructor loggedInstructor = null; Student loggedStudent = null; Admin loggedAdmin = null; if (insRadBtn.Checked) { loggedInstructor = InstructorDAL.GetByUserNameAndPassword(UserNameTextBox.Text, PasswordTextBox.Text); if (loggedInstructor == null) { MessageBox.Show("Please Insert Correct Data For Instructor"); } else { loggedInstructor = InstructorDAL.GetByUserNameAndPassword(UserNameTextBox.Text, PasswordTextBox.Text); MyInstructor.Instructor = loggedInstructor; Instructor_Profile f = new Instructor_Profile(); f.Show(); this.Hide(); } } else if (studRadBtn.Checked) { loggedStudent = StudentDAL.GetByUserNameAndPassword(UserNameTextBox.Text, PasswordTextBox.Text); if (loggedStudent == null) { MessageBox.Show("Please Insert Correct Data For Student"); } else { MyStudent.Student = loggedStudent; Student_Profile f = new Student_Profile(); f.Show(); this.Hide(); } } else { loggedAdmin = AdminDAL.GetByUserNameAndPassword(UserNameTextBox.Text, PasswordTextBox.Text); if (loggedAdmin == null) { MessageBox.Show("Please Insert Correct Data For Admin"); } else { MyAdmin.Admin = loggedAdmin; AdminProfile adm = new AdminProfile(); adm.Show(); this.Hide(); } } }
public static bool Delete(int instructorId) { // Retrieve personId from so we can delete person record Instructor toDelete = InstructorManager.GetItem(instructorId); if (toDelete != null) { if (toDelete.PersonId > 0 && toDelete.InstructorId > 0) { EmailAddressCollection emailItem = EmailAddressManager.GetCollection(instructorId); if (emailItem != null) { //DElete Email record first if (EmailAddressDAL.DeleteCollection(instructorId)) { // delete instructor first if (InstructorDAL.Delete(toDelete.InstructorId)) { return(PersonDAL.Delete(toDelete.PersonId)); } else { return(false); } } else { return(false); } } else { return(false); } } else { return(false); } } else { return(false); } }
public static string Disapprove(string cgi) { CryptoJS objcryptoJS = new CryptoJS(); string strURL = string.Empty; string ContractorAppId = string.Empty; try { ContractorAppId = cgi.ToString() == null ? string.Empty : cgi.ToString(); if (GlobalMethods.ValueIsNull(ContractorAppId).Length > 0) { ContractorAppId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(cgi), AppConstants.secretKey, AppConstants.initVec).ToString(); } List <clsInstructor> objSPCont = new List <clsInstructor>(); objSPCont = InstructorDAL.SelectDynamicInstructor("InstructorId = " + ContractorAppId + "", "InstructorId"); if (objSPCont != null) { objSPCont[0].IsActive = 0; if (InstructorDAL.UpdateInstructor(objSPCont[0])) { List <clsUserRole> lstURole = new List <clsUserRole>(); lstURole = UserRoleDAL.SelectDynamicUserRole("RoleId = 3 and AuthorizedUserId = " + objSPCont[0].CreatedBy + "", "UserRoleId"); if (lstURole != null) { if (lstURole.Count > 0) { // It should get only one record per ROle. if (!UserRoleDAL.DeleteUserRole(lstURole[0].UserRoleId)) { } } } } } } catch (Exception) { ErrorHandler.ErrorPage(); } return("MDE_InstructorAppView.aspx?InstructApps=active&cgi=" + cgi + ""); }
public static bool Delete(int instructorId) { Instructor toDelete = InstructorManager.GetItem(instructorId); if (toDelete != null) { if (toDelete.PersonId > 0 && toDelete.InstructorId > 0) { EmailAddressCollection emailToDelete = EmailAddressManager.GetCollection(instructorId); if (emailToDelete != null) { if (EmailAddressDAL.DeleteCollection(instructorId)) { if (InstructorDAL.Delete(toDelete.InstructorId)) { return(PersonDAL.Delete(toDelete.PersonId)); } else { return(false); } } else { return(false); } } else { return(false); } } else { return(false); } } else { return(false); } }
public static string Approve(string cgi) { CryptoJS objcryptoJS = new CryptoJS(); string strURL = string.Empty; string ContractorAppId = string.Empty; try { ContractorAppId = cgi.ToString() == null ? string.Empty : cgi.ToString(); if (GlobalMethods.ValueIsNull(ContractorAppId).Length > 0) { ContractorAppId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(cgi), AppConstants.secretKey, AppConstants.initVec).ToString(); } List <clsInstructor> objSPCont = new List <clsInstructor>(); objSPCont = InstructorDAL.SelectDynamicInstructor("InstructorId = " + ContractorAppId + "", "InstructorId"); if (objSPCont != null) { objSPCont[0].IsActive = 1; if (InstructorDAL.UpdateInstructor(objSPCont[0])) { List <clsUserRole> lstURole = new List <clsUserRole>(); lstURole = UserRoleDAL.SelectDynamicUserRole("RoleId = 3 and AuthorizedUserId = " + objSPCont[0].CreatedBy + "", "UserRoleId"); if (lstURole != null) { if (lstURole.Count > 0) { //ROLE HAS BEEN ASSIGNED. THEREFORE, DONT ADD ANOTHER ROLE. } else { clsUserRole objURole = new clsUserRole(); objURole.RoleId = 3; objURole.AuthorizedUserId = Convert.ToInt32(objSPCont[0].CreatedBy); objURole.IsActive = 1; objURole.CreatedDate = DateTime.Now; objURole.CreatedBy = HttpContext.Current.Session["UserAuthId"].ToString(); objURole.UpdatedDate = Convert.ToDateTime("1/1/1900"); objURole.UpdatedBy = ""; objURole.Notes = ""; if (!UserRoleDAL.InsertUserRole(objURole)) { } } } else { clsUserRole objURole = new clsUserRole(); objURole.RoleId = 3; objURole.AuthorizedUserId = Convert.ToInt32(objSPCont[0].CreatedBy); objURole.IsActive = 1; objURole.CreatedDate = DateTime.Now; objURole.CreatedBy = HttpContext.Current.Session["UserAuthId"].ToString(); objURole.UpdatedDate = Convert.ToDateTime("1/1/1900"); objURole.UpdatedBy = ""; objURole.Notes = ""; if (!UserRoleDAL.InsertUserRole(objURole)) { } } } } } catch (Exception) { ErrorHandler.ErrorPage(); } return("MDE_InstructorAppView.aspx?InstructApps=active&cgi=" + cgi + ""); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strTPID = string.Empty; try { strTPID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(strTPID).Length > 0) { strTPID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); } clsInstructor objSPCont = new clsInstructor(); objSPCont = InstructorDAL.SelectInstructorById(Convert.ToInt32(strTPID)); if (objSPCont != null) { List <clsTP_Instructors> lstTPIns = new List <clsTP_Instructors>(); lstTPIns = TP_InstructorsDAL.SelectDynamicTP_Instructors("InstructorId = " + strTPID + " and CreatedBy = '" + HttpContext.Current.Session["UserAuthId"].ToString() + "'", "TP_InstructorsId"); if (lstTPIns != null) { if (lstTPIns.Count > 0) { clsTrainingProvider objIns = new clsTrainingProvider(); objIns = TrainingProviderDAL.SelectTrainingProviderById(lstTPIns[0].TPId); if (objIns != null) { lblTP.Text = objIns.TP_Name; lblInstructorAss.Text = " associated with " + objIns.TP_Name; } else { lblTP.Text = "-"; lblInstructorAss.Text = "-"; } } else { lblTP.Text = "NO TRAINING PROVIDER"; lblInstructorAss.Text = " NOT ASSOCIATED WITH TRAINING PROVIDER"; } } else { lblTP.Text = "NO TRAINING PROVIDER"; lblInstructorAss.Text = " NOT ASSOCIATED WITH TRAINING PROVIDER"; } #region Getting Category Title clsCategory objCat = new clsCategory(); objCat = CategoryDAL.SelectCategoryById(objSPCont.ACRDCatID); if (objCat != null) { lblCategory.Text = objCat.CatTitle; } else { lblCategory.Text = "-"; } #endregion lblFName.Text = objSPCont.Instructor_FName; lblLName.Text = objSPCont.Instructor_LName; lblInstructorApp.Text = objSPCont.Instructor_FName + " " + objSPCont.Instructor_LName; lblTPEmail.Text = objSPCont.Instructor_Email; lblTPPhone.Text = objSPCont.Instructor_Phone; lblTPMobile.Text = ""; lblInsAccId.Text = objSPCont.AccreditationID; lblAccdExpireDate.Text = Convert.ToDateTime(objSPCont.AccreditationExpirationDate).ToShortDateString(); if (objSPCont.IsActive == 1) { pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='Inst_ScheduleClass.aspx?dash=active&cgi=" + Request["cgi"] + "' class='btn btn-primary2'>Schedule A Class</a>" + GlobalMethods.ContractorAppStatus(objSPCont.IsActive.HasValue ? objSPCont.IsActive.Value : -1, "bar", "") + "</div>")); } else { pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'>" + GlobalMethods.ContractorAppStatus(objSPCont.IsActive.HasValue ? objSPCont.IsActive.Value : -1, "bar", "") + "</div>")); } } } catch (Exception) { ErrorHandler.ErrorPage(); } } }
public static Instructor GetItem(int instructorId) { return(InstructorDAL.GetItem(instructorId)); }
public static int AddFitnessClass(int instructorId, int fitnessClassId) { return(InstructorDAL.AddFitnessClass(instructorId, fitnessClassId)); }
public static bool DeleteFitnessClass(int instructorFitnessClassId) { return(InstructorDAL.DeleteFitnessClass(instructorFitnessClassId)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strRoleId = string.Empty; phGeneral.Visible = true; phTrainee.Visible = false; phInstructors.Visible = false; phCertAccedit.Visible = false; try { strRoleId = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(strRoleId).Length > 0) { strRoleId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); clsRole objRole = new clsRole(); objRole = RoleDAL.SelectRoleById(Convert.ToInt32(strRoleId)); if (objRole != null) { RoleText = objRole.Notes; RoleIcon = objRole.RoleIcon; RoleTitle = objRole.RoleDispName; RoleRegisterURL = GlobalMethods.ValueIsNull(objRole.RoleRegisterURL); } } #region Now Getting Pending Applications. if (strRoleId == "7") // Contractor Role { #region Now Getting Pending Contractor Applications. List <clsSP_Contractor> lstSPContractor = new List <clsSP_Contractor>(); lstSPContractor = SP_ContractorDAL.SelectDynamicSP_Contractor("(CreatedBy = " + HttpContext.Current.Session["UserAuthId"].ToString() + ")", "CreatedDate DESC"); if (lstSPContractor != null) { if (lstSPContractor.Count > 0) { for (int i = 0; i < lstSPContractor.Count; i++) { // showTable(lstSPContractor[i].SPName,lstSPContractor[i].IsActive, lstSPContractor[i].SPContractorID.ToString()); } } } #endregion lblLowerTableHead.Text = "Applications"; pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='" + RoleRegisterURL + "' class='btn btn-primary' title='Apply for the " + RoleTitle + "'>Apply for the " + RoleTitle + " </a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else if (strRoleId == "2")// Training Provider { bool IsApprTP = false; string strTPId = string.Empty; #region Checking if User have any TP approved. List <clsTrainingProvider> lstTP = new List <clsTrainingProvider>(); lstTP = TrainingProviderDAL.SelectDynamicTrainingProvider("CreatedBy = " + HttpContext.Current.Session["UserAuthId"].ToString() + " and IsActive = 1 ", "TPId"); if (lstTP != null) { if (lstTP.Count > 0) { IsApprTP = true; strTPId = lstTP[0].TPId.ToString(); } } #endregion #region Now Getting All Training Provider Applications. List <clsTrainingProvider> lstSPContractor = new List <clsTrainingProvider>(); lstSPContractor = TrainingProviderDAL.SelectDynamicTrainingProvider("(CreatedBy = " + HttpContext.Current.Session["UserAuthId"].ToString() + ")", "CreatedDate DESC"); if (lstSPContractor != null) { if (lstSPContractor.Count > 0) { for (int i = 0; i < lstSPContractor.Count; i++) { //showTable(lstSPContractor[i].TP_Name, lstSPContractor[i].IsActive, lstSPContractor[i].TPId.ToString()); } } } #endregion strTPId = objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(strTPId.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); if (IsApprTP) { //<a class='btn btn-primary' href='TP_AddCourses.aspx?dash=active&cgi=" + Request["cgi"] + "' >Add Courses</a> pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a class='btn btn-primary' href='Inst_ScheduleClass.aspx?dash=active&cgi=" + Request["cgi"] + "' >Schedule Courses</a><a class='btn btn-primary' href='TP_AddLocations.aspx?dash=active' >Add Locations</a><a class='btn btn-primary' href='TP_AddInstructor.aspx?dash=active' >Add Instructors</a> <a class='btn btn-primary' href='TP_MgmtTraineeCards.aspx?dash=active&cgi=" + strTPId + "' >Manage Trainee Cards</a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else { pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='" + RoleRegisterURL + "' class='btn btn-primary' title='Apply for the " + RoleTitle + "'>Apply for the " + RoleTitle + " </a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } lblLowerTableHead.Text = "Applications"; } else if (strRoleId == "3")// Instructor { phGeneral.Visible = false; phInstructors.Visible = true; phTrainee.Visible = false; phCertAccedit.Visible = false; string strUserEmail = string.Empty; bool blShowCourseButton = false; string UserId = string.Empty; #region Getting User Email clsUser objUser = new clsUser(); objUser = UserDAL.SelectUserById(Convert.ToInt32(HttpContext.Current.Session["UserAuthId"].ToString())); if (objUser != null) { strUserEmail = objUser.EmailId; UserId = objUser.AuthorisedUserId.ToString(); } #endregion #region Checking if Instructor have any assigned Courses and users that applied to the Course. List <dynamic> lstCourses; string strSQLC = @"SELECT tbl_Instructor.InstructorId, tbl_CourseSchedule.CourseId, tbl_CourseSchedule.TPLocationId, tbl_CourseSchedule.ClassTitle, tbl_CourseSchedule.StartDate, tbl_CourseSchedule.EndDate, tbl_CourseSchedule.InstructionLanguage, tbl_CourseSchedule.CreateDate FROM tbl_Instructor INNER JOIN tbl_CourseSchedule ON tbl_Instructor.InstructorId = tbl_CourseSchedule.InstructorId WHERE (tbl_Instructor.Instructor_Email = @Email)"; var objParC = new DynamicParameters(); objParC.Add("@Email", strUserEmail, DbType.String); try { using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { lstCourses = db.Query <dynamic>(strSQLC, objParC, commandType: CommandType.Text).ToList(); if (lstCourses != null) { if (lstCourses.Count > 0) { blShowCourseButton = true; } } } } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } #endregion #region Now Getting All Instructor Applications. List <clsInstructor> lstSPContractor = new List <clsInstructor>(); lstSPContractor = InstructorDAL.SelectDynamicInstructor("IsActive = 1", "CreatedDate"); if (lstSPContractor != null) { if (lstSPContractor.Count > 0) { for (int i = 0; i < lstSPContractor.Count; i++) { showTableInst(lstSPContractor[i].Instructor_FName, lstSPContractor[i].Instructor_LName, lstSPContractor[i].Instructor_Phone, lstSPContractor[i].Instructor_Email, lstSPContractor[i].InstructorId.ToString()); } } } #endregion if (blShowCourseButton) {//UserId #region Checking if this user has been added to UserRole as Instructor List <clsUserRole> lstUR = new List <clsUserRole>(); lstUR = UserRoleDAL.SelectDynamicUserRole("(AuthorizedUserId = " + UserId + ") and (RoleId = 3)", "UserRoleId"); if (lstUR != null) { if (lstUR.Count <= 0) { // Dont have UserRole as Instructor. clsUserRole objUR = new clsUserRole(); objUR.RoleId = 3; objUR.AuthorizedUserId = Convert.ToInt32(UserId); objUR.IsActive = 1; objUR.CreatedDate = DateTime.Now; objUR.CreatedBy = UserId; objUR.UpdatedDate = Convert.ToDateTime("1/1/1900"); objUR.UpdatedBy = ""; objUR.Notes = ""; if (!UserRoleDAL.InsertUserRole(objUR)) { } } } #endregion pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='Inst_MgmtCourses.aspx?dash=active' class='btn btn-primary'>Manage Scores & Attendence Log</a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else { pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } lblLowerTableHead.Text = "Applications"; } else if (strRoleId == "1") { lblLowerTableHead.Text = "Applications"; pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='" + RoleRegisterURL + "' class='btn btn-primary' title='Apply for the " + RoleTitle + "'>Apply for the " + RoleTitle + " </a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else if (strRoleId == "4") { lblLowerTableHead.Text = "Applications"; pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='" + RoleRegisterURL + "' class='btn btn-primary' title='Apply for the " + RoleTitle + "'>Apply for the " + RoleTitle + " </a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else if (strRoleId == "5") { // Inspector lblLowerTableHead.Text = "Applications"; pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='" + RoleRegisterURL + "' class='btn btn-primary' title='Apply for the " + RoleTitle + "'>Apply for the " + RoleTitle + " </a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else if (strRoleId == "6") { // Trainee phGeneral.Visible = false; phInstructors.Visible = false; phCertAccedit.Visible = false; phTrainee.Visible = true; pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); #region Getting all the current and future courses. List <dynamic> lstCourseTotal; string strTagValue = string.Empty; StringBuilder strContent = new StringBuilder("<tr>"); string strSQL3 = @"SELECT DISTINCT tbl_CourseSchedule.TrainingCourseScheduleId, tbl_MDE_Courses.CourseDescription, tbl_MDE_Courses.InitialOrRenewal, tbl_TrainingProvider.TP_Name, tbl_CourseSchedule.CourseCost, tbl_MDE_Courses.InstructionLanguage, tbl_MDE_Courses.CourseDuration, tbl_MDE_Courses.PassScore, tbl_Category.ACRDCategory, tbl_TP_Location.TP_Address_Line_1, tbl_TP_Location.TP_City, tbl_TP_Location.TP_State, tbl_TP_Location.TP_ZipCode, tbl_TrainingProvider.TP_Telephone, tbl_Instructor.Instructor_FName, tbl_Instructor.Instructor_LName, tbl_MDE_Courses.CourseId, tbl_CourseSchedule.ClassTitle, tbl_CourseSchedule.StartDate, tbl_CourseSchedule.EndDate, tbl_CourseSchedule.Notes FROM tbl_CourseSchedule INNER JOIN tbl_TrainingProvider ON tbl_CourseSchedule.TPId = tbl_TrainingProvider.TPId INNER JOIN tbl_MDE_Courses ON tbl_CourseSchedule.CourseId = tbl_MDE_Courses.CourseId INNER JOIN tbl_Category ON tbl_MDE_Courses.ACRDCatID = tbl_Category.ACRDCatID INNER JOIN tbl_TP_Location ON tbl_CourseSchedule.TPLocationId = tbl_TP_Location.TPLocationId INNER JOIN tbl_Instructor ON tbl_CourseSchedule.InstructorId = tbl_Instructor.InstructorId"; try { var objPar3 = new DynamicParameters(); // objPar3.Add("@DateIn", Convert.ToDateTime(DateTime.Now).ToShortDateString(), dbType: DbType.String); using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { lstCourseTotal = db.Query <dynamic>(strSQL3, objPar3, commandType: CommandType.Text).ToList(); if (lstCourseTotal != null) { if (lstCourseTotal.Count > 0) { for (int i = 0; i < lstCourseTotal.Count; i++) { strTagValue = GlobalMethods.ValueIsNull(lstCourseTotal[i].CourseDescription).ToString().Replace("(", "").Replace(" ", "").Replace(")", ""); strContent.Append("<div class='element-item transition " + strTagValue + "' data-category='" + strTagValue + "'>"); if (GlobalMethods.ValueIsNull(lstCourseTotal[i].Notes).Length > 110) { strContent.Append("<h3 class='name'>" + GlobalMethods.ValueIsNull(lstCourseTotal[i].Notes).Substring(0, 100) + "...</h3>"); } else { strContent.Append("<h3 class='name'>" + GlobalMethods.ValueIsNull(lstCourseTotal[i].Notes) + "</h3>"); } strContent.Append("<p class='symbol'><a href='CourseDetails.aspx?dash=active&cgi=" + objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(GlobalMethods.ValueIsNull(lstCourseTotal[i].TrainingCourseScheduleId)), AppConstants.secretKey, AppConstants.initVec).ToString() + "' title='" + GlobalMethods.ValueIsNull(lstCourseTotal[i].ClassTitle) + "'>" + GlobalMethods.ValueIsNull(lstCourseTotal[i].ClassTitle) + "</a></p>"); strContent.Append("<p class='number'>" + GlobalMethods.ValueIsNull(lstCourseTotal[i].InitialOrRenewal) + "</p>"); strContent.Append("<p class='weight' style='align-content:center'><a href='CourseDetails.aspx?dash=active&cgi=" + objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(GlobalMethods.ValueIsNull(lstCourseTotal[i].TrainingCourseScheduleId)), AppConstants.secretKey, AppConstants.initVec).ToString() + "' class='btn btn-xs btn-primary'>View Details</a></p>"); strContent.Append("</div>"); } } } pnlListofCourses.Controls.Add(new LiteralControl(strContent.ToString())); } } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } #endregion lblLowerTableHead.Text = "Applications"; } else if (strRoleId == "8") { lblLowerTableHead.Text = "Applications"; pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='" + RoleRegisterURL + "' class='btn btn-primary' title='Apply for the " + RoleTitle + "'>Apply for the " + RoleTitle + " </a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else if (strRoleId == "9") { //Oversight lblLowerTableHead.Text = "Applications"; pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a><a href='" + RoleRegisterURL + "' class='btn btn-primary' title='Apply for the " + RoleTitle + "'>Apply for the " + RoleTitle + " </a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); } else if (strRoleId == "10") { //Certificate phGeneral.Visible = false; phTrainee.Visible = false; phInstructors.Visible = false; phCertAccedit.Visible = true; lblLowerTableHead.Text = "Applications"; #region Now building the table with Courses Information. List <dynamic> lstCourses; string strSQLC = @"SELECT tbl_LK_Inst_CourseSchedule.Inst_CourseSchId, tbl_LK_Inst_CourseSchedule.CreatedDate, tbl_LK_Inst_CourseSchedule.ApprovedOn, tbl_Instructor.Instructor_FName, tbl_Instructor.Instructor_LName, tbl_TrainingProvider.TP_Name, tbl_Category.CatTitle, tbl_Course_Result.ClassResultId, tbl_Course_Result.AuthorisedUserId, tbl_Course_Result.IsActive, tbl_CourseSchedule.TPId, tbl_MDE_Courses.ACRDCatID FROM tbl_LK_Inst_CourseSchedule INNER JOIN tbl_Instructor ON tbl_LK_Inst_CourseSchedule.InstructorId = tbl_Instructor.InstructorId INNER JOIN tbl_CourseSchedule ON tbl_LK_Inst_CourseSchedule.TrainingCourseScheduleId = tbl_CourseSchedule.TrainingCourseScheduleId INNER JOIN tbl_Course_Result ON tbl_LK_Inst_CourseSchedule.Inst_CourseSchId = tbl_Course_Result.Inst_CourseSchId INNER JOIN tbl_TrainingProvider ON tbl_CourseSchedule.TPId = tbl_TrainingProvider.TPId INNER JOIN tbl_MDE_Courses ON tbl_CourseSchedule.CourseId = tbl_MDE_Courses.CourseId INNER JOIN tbl_Category ON tbl_MDE_Courses.ACRDCatID = tbl_Category.ACRDCatID WHERE (tbl_LK_Inst_CourseSchedule.AuthorisedUserId = @AuthorisedUserId) AND (tbl_Course_Result.AuthorisedUserId = @AuthorisedUserId) AND (tbl_Course_Result.IsActive = - 1)"; var objParC = new DynamicParameters(); objParC.Add("@AuthorisedUserId", HttpContext.Current.Session["UserAuthId"].ToString(), DbType.String); try { using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { lstCourses = db.Query <dynamic>(strSQLC, objParC, commandType: CommandType.Text).ToList(); if (lstCourses != null) { if (lstCourses.Count > 0) { for (int i = 0; i < lstCourses.Count; i++) { showTableCertAccredit(GlobalMethods.ValueIsNull(lstCourses[i].CourseTitle), GlobalMethods.ValueIsNull(lstCourses[i].Instructor_FName) + " " + GlobalMethods.ValueIsNull(lstCourses[i].Instructor_LName), GlobalMethods.ValueIsNull(lstCourses[i].CatTitle), GlobalMethods.ValueIsNull(lstCourses[i].TP_Name), GlobalMethods.ValueIsNull(lstCourses[i].ClassResultId)); } } } } } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } #endregion //pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='#' onclick='return history.back();' class='btn btn-primary'>Back</a></div><div class='alert alert-success' style='padding:8px !important;'> </div></div>")); pnlLogicalButtons.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a href='dashboard.aspx?Dash=active' class='btn btn-primary'>BACK</a><a href='AppContractor.aspx?Dash=active' class='btn btn-primary' title='CONTRACTOR' >CONTRACTOR</a><a href='AppInspector_RiskAssessor.aspx?Dash=active' class='btn btn-primary' title='INSPECTOR AND RISK ASSESSOR'>INSPECTOR AND RISK ASSESSOR</a><a href='AppSupervisor.aspx?Dash=active' class='btn btn-primary' title='SUPERVISOR'>SUPERVISOR</a><a href='AppTrainingCourse.aspx?Dash=active' class='btn btn-primary' title='TRAINING COURSE'>TRAINING COURSE</a><a href='AppTP.aspx?Dash=active' class='btn btn-primary' title='TRAINING PROVIDER'>TRAINING PROVIDER</a><a href='AppInstructor.aspx?Dash=active' class='btn btn-primary' title='INSTRUCTOR'>INSTRUCTOR</a></div><div class='alert' style='background-color:#354A5F;padding:8px !important;'> </div></div>")); } #endregion } catch (Exception) { ErrorHandler.ErrorPage(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strTPID = string.Empty; bool boolInstVarify = false; try { strTPID = Request["cgi"].ToString() == null ? string.Empty : Request["cgi"].ToString(); if (GlobalMethods.ValueIsNull(strTPID).Length > 0) { strTPID = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(Request["cgi"].ToString()), AppConstants.secretKey, AppConstants.initVec).ToString(); } #region Checking if this is AssignedToMe Action bool IsAssignedToMe = false; List <clsTP_Approval> lstContAppr = new List <clsTP_Approval>(); lstContAppr = TP_ApprovalDAL.SelectDynamicTP_Approval("TPId = " + strTPID + "", "MDETPApprId"); if (lstContAppr != null) { if (lstContAppr.Count > 0) { IsAssignedToMe = true; } } #endregion clsTrainingProvider objSPCont = new clsTrainingProvider(); objSPCont = TrainingProviderDAL.SelectTrainingProviderById(Convert.ToInt32(strTPID)); if (objSPCont != null) { #region Getting Contractor Info. //clsSP_Contractor objSPC = new clsSP_Contractor(); //objSPC = SP_ContractorDAL.SelectSP_ContractorById(objSPCont.SPContractorID); //if (objSPC != null) //{ // lblContractor.Text = objSPC.SPName; // // lblCourseName.Text = "<b>" + objSPC.SPName + "</b>"; // for heading //} //else //{ // lblContractor.Text = ""; // // lblCourseName.Text = ""; //} #endregion lblTPName.Text = objSPCont.TP_Name; lblContractorApp.Text = objSPCont.TP_Name; //lblTPPhone.Text = objSPCont.TP_Phone; //lblTPMobile.Text = objSPCont.TP_Mobile; lblTPWebsite.Text = objSPCont.TP_WebSite; List <clsTP_Instructors> lstTPIns = new List <clsTP_Instructors>(); lstTPIns = TP_InstructorsDAL.SelectDynamicTP_Instructors("TPId = " + objSPCont.TPId + "", "TP_InstructorsId"); if (lstTPIns != null) { if (lstTPIns.Count > 0) { clsInstructor objInstructorIs = new clsInstructor(); objInstructorIs = InstructorDAL.SelectInstructorById(lstTPIns[0].TP_InstructorListId); if (objInstructorIs != null) { //lblApprInsName.Text = objInstructorIs.Instructor_FName + " " + objInstructorIs.Instructor_LName; //lblApprInsAccNum.Text = objInstructorIs.Instructor_AcctId; //lblApprInsExpire.Text = objInstructorIs.Instructor_AcctExpire.ToShortDateString(); lblInstructorName.Text = objInstructorIs.Instructor_FName + " " + objInstructorIs.Instructor_LName; lblInsAccId.Text = objInstructorIs.NewRenewal_InspecTech_AcctNumber; lblAccdExpireDate.Text = objInstructorIs.NewRenewal_InspecTech_AcctExpiration; } } } List <clsTP_Location> lstLocation = new List <clsTP_Location>(); lstLocation = TP_LocationDAL.SelectDynamicTP_Location("TPId = " + objSPCont.TPId + "", "TPLocationId"); if (lstLocation != null) { if (lstLocation.Count > 0) { lblAddress_1.Text = lstLocation[0].TP_Address_Line_1; lblAddress_2.Text = ""; lblCity.Text = lstLocation[0].TP_City; lblCounty.Text = ""; lblState.Text = lstLocation[0].TP_State; lblZipCode.Text = lstLocation[0].TP_ZipCode; lblTPEmail.Text = ""; } } //if(objSPCont.IsActive == 1) //{ // #region Approve Training Provider should Add Courses. // pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'><a class='btn btn-primary2' href='TP_AddCourses.aspx?dash=active&cgi="+ objcryptoJS.AES_encrypt(HttpUtility.UrlEncode(objSPCont.TPId.ToString()), AppConstants.secretKey, AppConstants.initVec).ToString() + "' >Schedule Courses</a>" + GlobalMethods.ContractorAppStatus(objSPCont.IsActive, "bar") + "</div>")); // #endregion //} //else //{ pnlAppStatus.Controls.Add(new LiteralControl("<div class='input-group'><div class='input-group-btn'>" + GlobalMethods.ContractorAppStatus(objSPCont.IsActive.HasValue ? objSPCont.IsActive.Value : 0, "bar", "") + "</div>")); // } } } catch (Exception) { ErrorHandler.ErrorPage(); } } }
public static InstructorCollection GetCollection() { return(InstructorDAL.GetCollection()); }