protected void GetStudentEnrollments(RadGrid rdExams, string strCouseId, string providerId)
{
BEAdmin objBEAdmin = new BEAdmin();
objBEAdmin.IntCourseID = Convert.ToInt32(strCouseId);
objBEAdmin.IntProviderID = Convert.ToInt32(providerId);
new BAdmin().BGetCourseStudents(objBEAdmin);
rdExams.DataSource = objBEAdmin.DtResult;
rdExams.Rebind();
//if (Status == "Inactive")
// rdExams.Columns[3].Visible = false;
// rdExams.Rebind();
foreach (GridColumn column in rdExams.MasterTableView.OwnerGrid.Columns)
{
column.CurrentFilterFunction = GridKnownFunction.NoFilter;
column.CurrentFilterValue = string.Empty;
}
rdExams.MasterTableView.FilterExpression = string.Empty;
objBEAdmin = null;
if (!IsPostBack)
{
this.Page.Title = EnumPageTitles.APPNAME + EnumPageTitles.HOME;
((LinkButton)this.Page.Master.FindControl("lnkHome")).CssClass = "main_menu_active";
}
}
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
{
}
}
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;
}
}
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 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);
}
}
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();
}
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 GetInstructors()
{
BEAdmin objBEAdmin = new BEAdmin();
new BAdmin().BGetInstructors(objBEAdmin);
gvInstructor.DataSource = objBEAdmin.DtResult;
objBEAdmin = null;
}
protected void GetStudents()
{
BEAdmin objBEAdmin = new BEAdmin();
new BAdmin().BGetStudents(objBEAdmin);
gvStudents.DataSource = objBEAdmin.DtResult;
objBEAdmin = null;
}
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);
}
}
//to populate exam summary grid
public void BGetExamSummaryReportDetails(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetExamSummaryDetails(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetExistingExamDetails(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetExistingExamDetails(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BUpdateCourseDetails(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DUpdateCourseDetails(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BProviderGetCoursesBySplIns(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetProviderCoursesBySplIns(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
//10feb2017
public void BGetExamDetailsByCourseAndSplIns(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetExamDetailsByCourseAndSplIns(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetInstructors(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetInstructors(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetCourseDetailsbyProvider(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetCourseDetailsbyProvider(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetCourseDetails_CourseStudents(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetCourseDetails_CourseStudents(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetClientContactDetails(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetClientContactDetails(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BAddInstructor(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DAddInstructor(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BViewStudentDetails(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DViewStudentDetails(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// ProviderSecurityLevel
/// </summary>
public void BBindProviderSecurityLevel(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DBindProviderSecurityLevel(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetTestResultReportDetails(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetTestResultReportDetails(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// Delete Exam
/// </summary>
public void BDeleteExam(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DDeleteExam(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetAppointmentScheduleReportDetails(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetAppointmentScheduleReportDetails(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
public void BGetPaymentMode(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DGetPaymentMode(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
/// <summary>
/// BDeleteUploadFiles
/// </summary>
/// <param name="objBEProvider"></param>
public void BDeleteUploadFiles(BEAdmin objBEAdmin)
{
try
{
new DAdmin().DDeleteUploadFiles(objBEAdmin);
}
catch (Exception Ex)
{
throw Ex;
}
}
