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[] { }
};
}
}
