protected void btnUpdate_Click(object sender, EventArgs e) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.ddlStatus = ddlStatus.SelectedValue.ToString(); objBEAdmin.IntEnrollID = Convert.ToInt32(Request.QueryString["EnrollmentID"].ToString()); objBAdmin.BUpdateEnrollStatus(objBEAdmin); trMessage.Visible = true; if (objBEAdmin.IntResult == 1) { ddlStatus.Visible = false; lblStatus.Text = ddlStatus.SelectedItem.Text; lblInfo.Text = Resources.AppMessages.Admin_EditEnrollment_Success_EditEnrollmentStatus; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success); btnUpdate.Visible = false; btnCancel.Visible = false; } else { btnUpdate.Visible = true; btnCancel.Visible = true; ddlStatus.Visible = true; lblInfo.Text = Resources.AppMessages.Admin_EditEnrollment_Error_EditEnrollmentStatus; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Error; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error); } }
protected void LoadCourseDetails() { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBAdmin.BGetAllCourseDetails(objBEAdmin); if (objBEAdmin.DtResult.Rows.Count > 0) { rcbCourses.DataSource = objBEAdmin.DtResult; rcbCourses.DataTextField = "CourseName"; rcbCourses.DataValueField = "CourseID"; rcbCourses.DataBind(); } gvReports.DataSource = new object[] { }; gvReports.DataBind(); } catch (Exception Ex) { ErrorHandlers.ErrorLog.WriteError(Ex); } }
private void GetCourseEditDetails() { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntUserID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID].ToString()); objBEAdmin.IntCourseID = Convert.ToInt32(AppSecurity.Decrypt(Request.QueryString["CourseID"])); objBAdmin.BGetCourseDetails(objBEAdmin); if (objBEAdmin.DtResult != null && objBEAdmin.DtResult.Rows.Count > 0) { TxtCourseID.Text = objBEAdmin.DtResult.Rows[0]["Course_ID"].ToString(); txtCourseName.Text = objBEAdmin.DtResult.Rows[0]["CourseName"].ToString(); //lblProviderName.Text = objBEAdmin.DtResult.Rows[0]["ProviderName"].ToString(); lblProviderName.Text = objBEAdmin.DtResult.Rows[0]["ProviderFirstName"].ToString() + ' ' + objBEAdmin.DtResult.Rows[0]["ProviderLastName"].ToString(); } else { TxtCourseID.Text = string.Empty; txtCourseName.Text = string.Empty; lblProviderName.Text = string.Empty; } } catch (Exception ex) { throw ex; } }
protected void ddlProviderName_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntProviderID = Convert.ToInt32(ddlprovider.SelectedValue); objBAdmin.BBindCourse(objBEAdmin); if (objBEAdmin.DtResult != null && objBEAdmin.DtResult.Rows.Count > 0) { ddlCourse.Items.Clear(); ddlCourse.AppendDataBoundItems = true; ddlCourse.Items.Add(new RadComboBoxItem("--Select Course--", "-1")); ddlCourse.DataSource = objBEAdmin.DtResult.DefaultView; ddlCourse.DataValueField = "CourseID"; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataBind(); } else { ddlCourse.Items.Clear(); ddlCourse.AppendDataBoundItems = true; ddlCourse.Items.Add(new RadComboBoxItem("--Select Course--", "-1")); ddlCourse.DataSource = null; ddlCourse.DataBind(); } } catch { } }
protected void BtnSaveCourse_Click(object sender, EventArgs e) { if (Page.IsValid) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntUserID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID].ToString()); //objBEExamProvider.IntCourseID = Convert.ToInt32(AppSecurity.Decrypt(Request.QueryString["CourseID"])); objBEAdmin.strCourseID = txtCourseID.Text; objBEAdmin.strCourseName = txtCourseName.Text; objBEAdmin.IntProviderID = Convert.ToInt32(ddlprovider.SelectedValue); objBAdmin.BSaveCourseDetails(objBEAdmin); if (objBEAdmin.DsResult.Tables[0].Rows.Count > 0) { if (Convert.ToInt32(objBEAdmin.DsResult.Tables[0].Rows[0][0]) == 1) { lblSuccess.Text = Resources.ResMessages.Provider_CourseSuccess; lblSuccess.Visible = true; lblSuccess.ForeColor = System.Drawing.Color.Green; txtCourseID.Text = string.Empty; txtCourseName.Text = string.Empty; ddlprovider.SelectedIndex = 0; gvCourseStatus.Rebind(); } else { lblSuccess.Text = Resources.ResMessages.Provider_CourseExists; lblSuccess.ForeColor = System.Drawing.Color.Red; lblSuccess.Visible = true; } //LoadDataTable(); } } }
protected void rcbCourses_ItemChecked(object sender, RadComboBoxItemEventArgs e) { string ids = GetCourseIds(); BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = ids; if (ids != "'0'") { objBAdmin.BGetAllExamDetails(objBEAdmin); if (objBEAdmin.DtResult.Rows.Count > 0) { rcbExams.DataSource = objBEAdmin.DtResult; rcbExams.DataTextField = "ExamName"; rcbExams.DataValueField = "ExamID"; rcbExams.DataBind(); } else { rcbExams.DataSource = new object[] { }; rcbExams.DataBind(); } } else { rcbExams.DataSource = new object[] { }; rcbExams.DataBind(); } gvReports.DataSource = new object[] { }; gvReports.DataBind(); }
public void GenerateReport(int courseId, int examId, string type, int Mail) { BAdmin objBAdmin = new BAdmin(); BEAdmin objBEAdmin = new BEAdmin(); objBEAdmin.IntCourseID = courseId; objBEAdmin.IntExamID = examId; if (type == "true") { objBEAdmin.IntType = 1; //for scheduled appointments } else if (type == "false") { objBEAdmin.IntType = 0; //for unscheduled appointments } objBAdmin.BGetAdminAppointmentDetails(objBEAdmin); //Scheduled Appoinments if (type == "true") { ScheduledReport(objBEAdmin.DtResult, Mail); }//UnScheduled Appointments else { UnScheduledReport(objBEAdmin.DtResult, Mail); } }
protected void btnAdd_Click(object sender, EventArgs e) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strFirstName = txtFirstName.Text; lblFirstName.Text = txtFirstName.Text; objBEAdmin.strLastName = txtLastName.Text; lblLastName.Text = txtLastName.Text; objBEAdmin.strEmailAddress = txtEmailAddress.Text; lblEmailAddress.Text = txtEmailAddress.Text; objBEAdmin.StrComments = txtcomments.Value; lblComments.Text = txtcomments.Value; objBEAdmin.strUserName = txtUserID.Text; lblUserName.Text = txtUserID.Text; //objBEAdmin.strPassword = GetRandomPassword(Length); if (chkConfirmEmail.Checked == true) { objBEAdmin.strPassword = "******"; } else { objBEAdmin.strPassword = "******"; } trMessage.Visible = true; if (ChkSpecialNeeds.Checked == true) { objBEAdmin.strSpecialNeeds = true; lblSpecialNeeds.Text = "Yes"; } else { objBEAdmin.strSpecialNeeds = false; lblSpecialNeeds.Text = "No"; } objBAdmin.BAddStudent(objBEAdmin); if (objBEAdmin.IntResult == 0) { lblInfo.Text = Resources.AppMessages.Admin_AddStudent_Error_AddStudent; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Error; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error); trAddStudent.Visible = true; trAddStudentConfirm.Visible = false; } if (objBEAdmin.IntResult == 1) { lblInfo.Text = Resources.AppMessages.Admin_AddStudent_Success_AddStudent; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success); trAddStudent.Visible = false; trAddStudentConfirm.Visible = true; } }
protected void rcbCourses_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { string ids = GetCourseIds(); BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = ids; if (ids != "'0'") { rcbExams.Enabled = true; if (rcbCourses.CheckedItems.Count > 0) { objBAdmin.BGetAllExamDetails(objBEAdmin); if (objBEAdmin.DtResult.Rows.Count > 0) { rcbExams.DataSource = objBEAdmin.DtResult; rcbExams.DataTextField = "ExamName"; rcbExams.DataValueField = "ExamID"; rcbExams.DataBind(); } else { rcbExams.DataSource = new object[] { }; rcbExams.DataBind(); } if (rcbCourses.CheckedItems.Count == 1) { rcbExams.Enabled = true; } else { foreach (RadComboBoxItem itm in rcbExams.Items) { itm.Checked = true; } rcbExams.Enabled = false; } } else { rcbExams.DataSource = new object[] { }; rcbExams.DataBind(); rcbExams.Enabled = false; } } else { rcbExams.DataSource = new object[] { }; rcbExams.DataBind(); rcbExams.Enabled = false; } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntCourseID = Convert.ToInt32(Request.QueryString["CourseID"]); objBEAdmin.strCourseID = TxtCourseID.Text; lblCourseID.Text = TxtCourseID.Text; objBEAdmin.strCourseName = txtCourseName.Text; lblCourse.Text = txtCourseName.Text; objBEAdmin.IntstatusFlag = Convert.ToInt32(ddlStatus.SelectedValue.ToString()); if (ddlStatus.SelectedValue.ToString() == "1") { lblStatus.Text = "Active"; } else { lblStatus.Text = "Inactive"; } objBAdmin.BUpdateCourseDetails(objBEAdmin); trMessage.Visible = true; if (objBEAdmin.IntResult == 1) { lblInfo.Text = Resources.AppMessages.Admin_EditCourse_Success_CourseUpdated; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success); lblModifiedDate1.Text = DateTime.Now.ToShortDateString(); lblCourseID.Text = TxtCourseID.Text.ToString(); lblCourse.Text = txtCourseName.Text.ToString(); lblStatus.Text = ddlStatus.SelectedItem.Text.ToString(); trCourseEdit.Visible = false; trCourseView.Visible = true; } else if (objBEAdmin.IntResult == 0) { lblInfo.Text = Resources.AppMessages.Admin_EditCourse_Error_CourseExists; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Error; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error); } else if (objBEAdmin.IntResult == 2) { lblInfo.Text = Resources.AppMessages.Admin_EditCourse_Error_PendingExams; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Error; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error); } } catch (Exception Ex) { ErrorHandlers.ErrorLog.WriteError(Ex); } }
protected void getPassword() { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntStudentID = Convert.ToInt32(Request.QueryString["StudentID"].ToString()); objBAdmin.BGetPassword(objBEAdmin); if (objBEAdmin.DtResult.Rows.Count != 0) { lblEmailAddress.Text = objBEAdmin.DtResult.Rows[0]["EmailAddress"].ToString(); } }
protected void ddlProviderName_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntProviderID = Convert.ToInt32(ddlprovider.SelectedValue); objBAdmin.BBindCourse(objBEAdmin); ddlCourse.DataSource = objBEAdmin.DtResult.DefaultView; ddlCourse.DataValueField = "CourseID"; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataBind(); }
protected void gvTransDetails_NeedDataSource(object source, GridNeedDataSourceEventArgs e) { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntStudentID = Convert.ToInt32(AppSecurity.Decrypt(Request.QueryString["StudentID"].ToString())); // objBEAdmin.IntUserID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID]); objBAdmin.BGetStudentTransactionsForAllProviders(objBEAdmin); gvTransDetails.DataSource = objBEAdmin.DtResult; } catch (Exception) { } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); //objBEAdmin.IntCourseID = Convert.ToInt32(Request.QueryString["CourseID"]); //objBEAdmin.IntProviderID = Convert.ToInt32(Request.QueryString["ProviderID"]); if (chkPrimary.Checked == true) { BEProvider objBEExamProvider = new BEProvider(); BProvider objBExamProvider = new BProvider(); chkPrimary.Checked = true; objBEExamProvider.IntProviderID = Convert.ToInt32(Request.QueryString["ProviderID"].ToString()); //objBEExamProvider.IntProviderID = Convert.ToInt32(Request.QueryString["ProviderID"].ToString()); objBEExamProvider.intPrimaryIns = true; objBExamProvider.BUpdatePrimaryIns(objBEExamProvider); //trMessage.Visible = true; lblInfo.Text = "Details updated successfully"; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success); chkPrimary.Visible = false; lblPrimary.Visible = false; btnUpdate.Visible = false; } else { BEProvider objBEExamProvider = new BEProvider(); BProvider objBExamProvider = new BProvider(); chkPrimary.Checked = false; objBEExamProvider.IntProviderID = Convert.ToInt32(Request.QueryString["ProviderID"].ToString()); //objBEExamProvider.IntProviderID = Convert.ToInt32(Request.QueryString["ProviderID"].ToString()); objBEExamProvider.intPrimaryIns = false; objBExamProvider.BUpdatePrimaryIns(objBEExamProvider); //trMessage.Visible = true; lblInfo.Text = "Details updated successfully"; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success); chkPrimary.Visible = false; lblPrimary.Visible = false; btnUpdate.Visible = false; } } catch (Exception Ex) { ErrorHandlers.ErrorLog.WriteError(Ex); } }
protected void BindExistingExamDetails() { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBAdmin.BGetExistingExamDetails(objBEAdmin); gvExamDetails.DataSource = objBEAdmin.DtResult; } catch (Exception) { } }
public void GenerateReport() { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = GetCourseIds(); objBEAdmin.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]); objBAdmin.BGetExamSummaryReportDetails(objBEAdmin); DataTable objDt = objBEAdmin.DtResult; objDt.AcceptChanges(); objDt.Columns.Remove("CourseID"); objDt.Columns.Remove("ExamID"); objDt.Columns["CourseName"].ColumnName = "Course Name"; objDt.Columns["Instructor Name"].ColumnName = "Instructor Name"; objDt.Columns["ExamName"].ColumnName = "Exam Name"; objDt.Columns["ExamStartDate"].ColumnName = "Exam Start Date"; objDt.Columns["ExamEndDate"].ColumnName = "Exam End Date"; objDt.Columns["StudentsEnrolled"].ColumnName = "Total Students"; objDt.Columns["ScheduledAppointments"].ColumnName = "Scheduled Appointments"; objDt.Columns["Unscheduledappointments"].ColumnName = "Unscheduled Appointments"; string Examsummary = Server.MapPath(ConfigurationManager.AppSettings["Reports"].ToString()) + '\\' + "Schedule status" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-").Replace(":", "-") + ".xls"; if (File.Exists(Examsummary)) { File.Delete(Examsummary); } FileInfo rptFileName = new FileInfo(Examsummary); // this.DeleteHistoricFiles(); ExcelSheetGenerator objExcel = new ExcelSheetGenerator(); objExcel.GenerateReport(objDt, rptFileName, " Schedule status ", "UserName"); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + "Schedule status" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-") + ".xlsx"); Response.TransmitFile(rptFileName.ToString()); Response.End(); }
public void GenerateReport() { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = GetExamIds(); objBEAdmin.IntUserID = 0; //for admin objBAdmin.BGetAppointmentScheduleReportDetails(objBEAdmin); DataTable objDt = objBEAdmin.DtResult; objDt.Columns["ExamID"].ColumnName = "Exam ID"; objDt.Columns["StudentFirstName"].ColumnName = "Student First Name"; objDt.Columns["StudentLastName"].ColumnName = "Student Last Name"; objDt.Columns["EmailAddress"].ColumnName = "Email Address"; objDt.Columns["CourseName"].ColumnName = "Course Name"; objDt.Columns["ExamName"].ColumnName = "Exam Name"; objDt.Columns["InstructorName"].ColumnName = "Instructor Name"; objDt.Columns["AppointmentCreationDate"].ColumnName = "Appointment Creation Date [EST]"; objDt.Columns["AppointmentDate"].ColumnName = "Appointment Date [EST]"; objDt.Columns["ExamDuration"].ColumnName = "Exam Duration"; objDt.Columns["FairExamLevel"].ColumnName = "Fair ExamLevel"; objDt.Columns["StatusName"].ColumnName = "Status"; objDt.Columns.Remove("CourseID"); string Examsummary = Server.MapPath(ConfigurationManager.AppSettings["Reports"].ToString()) + '\\' + "Schedule details" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-").Replace(":", "-") + ".xls"; if (File.Exists(Examsummary)) { File.Delete(Examsummary); } FileInfo rptFileName = new FileInfo(Examsummary); // this.DeleteHistoricFiles(); ExcelSheetGenerator objExcel = new ExcelSheetGenerator(); objExcel.GenerateReport(objDt, rptFileName, " Schedule details ", "UserName"); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + "Schedule details" + DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss").Replace("/", "-") + ".xlsx"); Response.TransmitFile(rptFileName.ToString()); Response.End(); }
private void GetSelectedDetails() { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntCourseID = Convert.ToInt32(Request.QueryString["CourseID"].ToString()); objBAdmin.BGetSelectedCourseDetails(objBEAdmin); if (objBEAdmin.DtResult != null && objBEAdmin.DtResult.Rows.Count > 0) { TxtCourseID.Text = objBEAdmin.DtResult.Rows[0]["Course_ID"].ToString(); txtCourseName.Text = objBEAdmin.DtResult.Rows[0]["CourseName"].ToString(); ddlStatus.Items.FindItemByText(objBEAdmin.DtResult.Rows[0]["Status"].ToString()).Selected = true; lblCreatedDate.Text = objBEAdmin.DtResult.Rows[0]["CreatedDate"].ToString(); lblCreatedDate1.Text = objBEAdmin.DtResult.Rows[0]["CreatedDate"].ToString(); lblModifiedDate.Text = objBEAdmin.DtResult.Rows[0]["ModifiedDate"].ToString(); } BECommon objBECommon = new BECommon(); BCommon objBCommon = new BCommon(); objBECommon.iID = Convert.ToInt32(Request.QueryString["CourseID"].ToString()); //to get course lms settings objBECommon.iTypeID = 2; objBCommon.BGetLMSSettings(objBECommon); if (objBECommon.DtResult != null && objBECommon.DtResult.Rows.Count > 0) { if (!Convert.ToBoolean(objBECommon.DtResult.Rows[0]["admin"])) { TxtCourseID.ReadOnly = Convert.ToBoolean(objBECommon.DtResult.Rows[0]["Courseid"]); if (Convert.ToBoolean(objBECommon.DtResult.Rows[0]["Courseid"])) { TxtCourseID.CssClass = "readonly"; } txtCourseName.ReadOnly = Convert.ToBoolean(objBECommon.DtResult.Rows[0]["CourseName"]); if (Convert.ToBoolean(objBECommon.DtResult.Rows[0]["CourseName"])) { txtCourseName.CssClass = "readonly"; } } } } catch (Exception Ex) { ErrorHandlers.ErrorLog.WriteError(Ex); } }
protected void GetCourseDetails() { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBAdmin.BGetCourseDetails_CourseStudents(objBEAdmin); gvStudents.DataSource = objBEAdmin.DtResult; objBEAdmin = null; objBAdmin = null; } catch (Exception Ex) { ErrorHandlers.ErrorLog.WriteError(Ex); } }
protected void GetStudentDeetails() { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntStudentID = Convert.ToInt32(AppSecurity.Decrypt(Request.QueryString["UserID"].ToString())); objBAdmin.BViewStudentDetails(objBEAdmin); if (objBEAdmin.DtResult != null) { if (objBEAdmin.DtResult.Rows.Count > 0) { this.BindTimeZone(objBEAdmin.IntStudentID); lblFirstName.Text = objBEAdmin.DtResult.Rows[0]["FirstName"].ToString(); txtFirstName.Text = objBEAdmin.DtResult.Rows[0]["FirstName"].ToString(); lblLastName.Text = objBEAdmin.DtResult.Rows[0]["LastName"].ToString(); txtStudentLastName.Text = objBEAdmin.DtResult.Rows[0]["LastName"].ToString(); lblEmailAddress.Text = objBEAdmin.DtResult.Rows[0]["EmailAddress"].ToString(); txtEmailAddress.Text = objBEAdmin.DtResult.Rows[0]["EmailAddress"].ToString(); lblPhoneNumber.Text = objBEAdmin.DtResult.Rows[0]["PhoneNumber"].ToString(); txtPhoneNumber.Text = objBEAdmin.DtResult.Rows[0]["PhoneNumber"].ToString(); lblTimeZone.Text = objBEAdmin.DtResult.Rows[0]["TimeZone"].ToString(); lblSpecialNeeds.Text = objBEAdmin.DtResult.Rows[0]["SpecialNeeds"].ToString(); // lblComments.Text = objBEAdmin.DtResult.Rows[0]["Comments"].ToString(); // txtcomments.Value = objBEAdmin.DtResult.Rows[0]["Comments"].ToString(); string SpecialNeeds = objBEAdmin.DtResult.Rows[0]["SpecialNeeds"].ToString(); if (SpecialNeeds == "Yes") { trcomments.Visible = true; if (objBEAdmin.DtResult.Rows[0]["Comments"] != DBNull.Value) { lblComments.Text = objBEAdmin.DtResult.Rows[0]["Comments"].ToString(); txtcomments.Value = objBEAdmin.DtResult.Rows[0]["Comments"].ToString(); } ddlSpecialNeeds.SelectedValue = "1"; } else if (SpecialNeeds == "No") { trcomments.Visible = false; ddlSpecialNeeds.SelectedValue = "0"; } } } }
protected void BindStudents() { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntCourseID = Convert.ToInt32(Request.QueryString["Courseid"].ToString()); objBAdmin.BGetStudentsNotInCourse(objBEAdmin); if (objBEAdmin.DtResult.Rows.Count > 0) { rcbStudent.AppendDataBoundItems = true; // rcbStudent.Items.Add(new RadComboBoxItem("--Select Student--", "-1")); rcbStudent.DataSource = objBEAdmin.DtResult; rcbStudent.DataTextField = "StudentName"; rcbStudent.DataValueField = "StudentID"; rcbStudent.DataBind(); } }
protected void LoadDataTable() { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntCourseID = 0; objBAdmin.BGetCourseDetails(objBEAdmin); if (objBEAdmin.DtResult != null && objBEAdmin.DtResult.Rows.Count > 0) { gvCourseStatus.DataSource = objBEAdmin.DtResult; } else { gvCourseStatus.DataSource = new string[] { }; } }
protected void btnUpdate_Click(object sender, EventArgs e) { if (Page.IsValid) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); //objBEAdmin.IntUserID = Convert.ToInt32(Session[BaseClass.EnumPageSessions.USERID].ToString()); objBEAdmin.IntProviderID = Convert.ToInt32(AppSecurity.Decrypt(Request.QueryString["ExamProviderID"])); objBEAdmin.IntCourseID = Convert.ToInt32(AppSecurity.Decrypt(Request.QueryString["CourseID"])); objBEAdmin.strCourseID = TxtCourseID.Text; objBEAdmin.strCourseName = txtCourseName.Text; objBAdmin.BUpdateCourseDetails(objBEAdmin); if (objBEAdmin.DsResult.Tables[0].Rows.Count > 0) { if (Convert.ToInt32(objBEAdmin.DsResult.Tables[0].Rows[0][0]) == 1) { lblSuccess.Text = Resources.ResMessages.Provider_CourseEditSuccess; lblCourseID.Visible = true; lblCourseID.Text = TxtCourseID.Text; lblCourseName.Visible = true; lblCourseName.Text = txtCourseName.Text; btnUpdate.Visible = false; TxtCourseID.Visible = false; txtCourseName.Visible = false; btnBack.Visible = true; // lblModifiedDate.Text = DateTime.Now.ToShortDateString(); lblSuccess.Visible = true; lblSuccess.ForeColor = System.Drawing.Color.Green; imgSuccess.Visible = true; } else { TxtCourseID.Visible = true; txtCourseName.Visible = true; lblSuccess.Text = Resources.ResMessages.Provider_CourseEditFailed; lblSuccess.ForeColor = System.Drawing.Color.Red; btnUpdate.Visible = true; btnBack.Visible = true; lblSuccess.Visible = true; imgSuccess.Visible = false; } } } }
protected void GetExamDetails(RadGrid rdExams, string strCourseID) { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntCourseID = Convert.ToInt32(strCourseID); objBEAdmin.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]); objBAdmin.BGetExamDetails(objBEAdmin); rdExams.DataSource = objBEAdmin.DtResult; rdExams.Rebind(); } catch (Exception Ex) { ErrorHandlers.ErrorLog.WriteError(Ex); } }
protected void Button1_Click(object sender, EventArgs e) { if (this.DropDownList1.SelectedValue == "学生") { BStudent bll = new BStudent(); bool affacted = bll.CheckUser(TextBox1.Text, TextBox2.Text); if (affacted) { Session["sname"] = TextBox1.Text.ToString(); Response.Write("<script>alert('登陆成功!');location='Student/Studentlogin.aspx'</script>"); } else { Response.Write("<script>alert('用户名或密码错误!请重试!');location='Login.aspx'</script>"); } } if (this.DropDownList1.SelectedValue == "教师") { BTeacher bll = new BTeacher(); bool affacted = bll.CheckUser(TextBox1.Text, TextBox2.Text); if (affacted) { Session["tname"] = TextBox1.Text.ToString(); Response.Write("<script>alert('登陆成功!');location='Teacher/Tusercenter.aspx'</script>"); } else { Response.Write("<script>alert('用户名或密码错误!请重试!');location='Login.aspx'</script>"); } } if (this.DropDownList1.SelectedValue == "管理员") { BAdmin bll = new BAdmin(); bool affacted = bll.CheckUser(TextBox1.Text, TextBox2.Text); if (affacted) { Session["aname"] = TextBox1.Text.ToString(); Response.Write("<script>alert('登陆成功!');location='Admin/UserCentre.aspx'</script>"); } else { Response.Write("<script>alert('用户名或密码错误!请重试!');location='Login.aspx'</script>"); } } }
protected void LoadTestResultReport(string ids) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.strCourseID = ids; objBEAdmin.strExamStartDate = txtFromDate.SelectedDate.Value; objBEAdmin.strExamEndDate = txtToDate.SelectedDate.Value; objBEAdmin.IntUserID = Convert.ToInt32(Session[EnumPageSessions.USERID]); objBAdmin.BGetTestResultReportDetails(objBEAdmin); gvReports.DataSource = objBEAdmin.DtResult; gvReports.DataBind(); ViewState["gvReports"] = objBEAdmin.DtResult; }
protected void btnAdd_Click(object sender, EventArgs e) { try { if (Page.IsValid) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntStudentID = Convert.ToInt32(Request.QueryString["StudentID"].ToString()); objBEAdmin.IntUserID = Convert.ToInt32(ddlprovider.SelectedValue.ToString()); objBEAdmin.IntCourseID = Convert.ToInt32(ddlCourse.SelectedValue.ToString()); objBAdmin.BAdminEnrollStudentCourse(objBEAdmin); trMessage.Visible = true; if (objBEAdmin.IntResult.ToString() == "1") { lblInfo.Text = Resources.AppMessages.Admin_Enrollment_Success_AddEnrollment; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success); lblStudentnameConfirmation.Text = lblStudentName.Text; ddlCourse.Visible = false; trUpdate.Visible = false; lblInstructor.Visible = true; ddlprovider.Visible = false; lblInstuctorNameConfirm.Text = ddlprovider.SelectedItem.Text; lblCourseNameConfirm.Text = ddlCourse.SelectedItem.Text; trAddEnrollment.Visible = false; trAddEnrollmentConfirmation.Visible = true; } else { lblInfo.Text = Resources.AppMessages.Admin_Enrollment_Error_AddEnrollment; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Error; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error); trAddEnrollment.Visible = true; trAddEnrollmentConfirmation.Visible = false; } } } catch { } }
protected void GetStudentName() { try { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntStudentID = Convert.ToInt32(Request.QueryString["StudentID"].ToString()); objBAdmin.BGetStudentName(objBEAdmin); if (objBEAdmin.DtResult != null && objBEAdmin.DtResult.Rows.Count > 0) { lblStudentName.Text = objBEAdmin.DtResult.Rows[0]["StudentName"].ToString(); } } catch (Exception Ex) { ErrorHandlers.ErrorLog.WriteError(Ex); } }
protected void btnUpdate_Click(object sender, EventArgs e) { if (Page.IsValid) { BEAdmin objBEAdmin = new BEAdmin(); BAdmin objBAdmin = new BAdmin(); objBEAdmin.IntStudentID = Convert.ToInt32(Session["studentid"]); objBEAdmin.strFirstName = lblstudentfirstname.Text; objBEAdmin.strLastName = lblStudentLastName.Text; objBEAdmin.strEmailAddress = lblEmailID.Text; // objBEAdmin.strPhoneNumber = txtPhoneNumber.Text; //objBEAdmin.strTimeZone = ddlTimeZone.SelectedValue; objBEAdmin.strSpecialNeeds1 = ddlSpecialNeeds.SelectedValue; objBEAdmin.StrComments = txtcomments.Value; objBEAdmin.IntstatusFlag = Convert.ToInt32(ddlStatus.SelectedValue.ToString()); objBAdmin.BUpdateStudentDetails(objBEAdmin); if (objBEAdmin.IntResult == 1) { //Session["TimeZoneID"] = ddlTimeZone.SelectedValue.ToString(); //Session["TimeZone"] = ddlTimeZone.SelectedItem.Text.ToString(); trUpdate.Visible = false; EnableDetails(); trMessage.Visible = true; lblInfo.Text = Resources.AppMessages.Admin_EditStudent_Success_StudentDetailsUpdated; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Success); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Success; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Success); } else { trMessage.Visible = true; lblInfo.Text = Resources.AppMessages.Admin_EditStudent_Error_StudentDetails; lblInfo.ForeColor = System.Drawing.Color.FromName(Resources.AppConfigurations.Color_Error); ImgInfo.ImageUrl = Resources.AppConfigurations.Image_Error; tdInfo.Attributes.Add("style", Resources.AppConfigurations.Color_Table_Error); } } }
protected void LoadAppointments(int courseId, int examId, string type) { BAdmin objBAdmin = new BAdmin(); BEAdmin objBEAdmin = new BEAdmin(); objBEAdmin.IntCourseID = courseId; objBEAdmin.IntExamID = examId; if (type == "true") { objBEAdmin.IntType = 1; //for scheduled appointments } else if (type == "false") { objBEAdmin.IntType = 0; //for unscheduled appointments } objBAdmin.BGetAdminAppointmentDetails(objBEAdmin); //Scheduled Appoinments if (type == "true") { if (objBEAdmin.DtResult.Rows.Count > 0) { gvExamStatus.DataSource = objBEAdmin.DtResult; } else { gvExamStatus.DataSource = new string[] { } }; }//UnScheduled Appointments else { if (objBEAdmin.DtResult.Rows.Count > 0) { rgvUnScheduledAppointments.DataSource = objBEAdmin.DtResult; } else { rgvUnScheduledAppointments.DataSource = new string[] { } }; } }