protected void LoadGrid()
{
try
{
SMHR_TRAINING_ONLINEASSESSMENT oSMHR_TRAINING_ONLINEASSESSMENT = new SMHR_TRAINING_ONLINEASSESSMENT();
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Select;
oSMHR_TRAINING_ONLINEASSESSMENT.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT);
if (dt.Rows.Count != 0)
{
Rg_TrgFeedback.DataSource = dt;
}
else
{
DataTable dt1 = new DataTable();
Rg_TrgFeedback.DataSource = dt1;
Rg_TrgFeedback.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingFeedBack", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
private void loadGrid()
{
try
{
if (string.Compare(rdExamType.SelectedValue, "Online", true) == 0)
{
SMHR_TRAINING_ONLINEASSESSMENT oSMHR_TRAINING_ONLINEASSESSMENT = new SMHR_TRAINING_ONLINEASSESSMENT();
oSMHR_TRAINING_ONLINEASSESSMENT.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_COURSE_ID = Convert.ToInt32(rc_Course.SelectedValue);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_COURSESCHEDULE_ID = Convert.ToInt32(rc_CourseSchedule.SelectedValue);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_ID = Convert.ToInt32(Session["EMP_ID"]);
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Select2;
DataTable dt = BLL.get_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT);
if (dt.Columns.Count > 1)
{
RG_Assessments.DataSource = dt;
RG_Assessments.DataBind();
}
else
{
RG_Assessments.DataSource = null;
RG_Assessments.DataBind();
}
RG_Assessments.Visible = true;
RadGrid1.Visible = false;
}
else
{
RadGrid1.Visible = true;
RG_Assessments.Visible = false;
SMHR_TRAINING_OFFLINEASSESSMENTS _obj_SMHR_Offlineassesments = new SMHR_TRAINING_OFFLINEASSESSMENTS();
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_COURSEID = Convert.ToInt32(rc_Course.SelectedValue);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_COURSESCHEDULEID = Convert.ToInt32(rc_CourseSchedule.SelectedValue);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ID = Convert.ToInt32(Session["EMP_ID"]);
_obj_SMHR_Offlineassesments.OPERATION = operation.Select2;
DataTable DT = BLL.get_OfflineAssessment(_obj_SMHR_Offlineassesments);
if (DT.Columns.Count > 1)
{
RadGrid1.DataSource = DT;
RadGrid1.DataBind();
}
else
{
RadGrid1.DataSource = null;
RadGrid1.DataBind();
}
RG_Assessments.Visible = false;
RadGrid1.Visible = true;
}
}
catch (Exception ex)
{
//Utils.HandleWebException(ex, this);
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Frm_Assessment", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_Edit_Command(object sender, CommandEventArgs e)
{
try
{
SMHR_TRAINING_ONLINEASSESSMENT oSMHR_TRAINING_ONLINEASSESSMENT = new SMHR_TRAINING_ONLINEASSESSMENT();
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Get_ID;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_ID = Convert.ToInt32(e.CommandArgument);
DataTable dt = BLL.get_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT);
lblCurrentDate.Text = DateTime.Now.ToString();
lblExamID.Text = dt.Rows[0]["TRAINING_ASSESSMENT_ID"].ToString();
lblCourseName.Text = dt.Rows[0]["COURSE_NAME"].ToString();
lblAssessment.Text = dt.Rows[0]["TRAINING_ASSESSMENT_NAME"].ToString();
lblMarks.Text = dt.Rows[0]["TRAINING_ASSESSMENT_NOOFQUESTIONS"].ToString();
lblNoOfQuestions.Text = dt.Rows[0]["TRAINING_ASSESSMENT_NOOFQUESTIONS"].ToString();
LoadQuestionPaper(dt.Rows[0]["TRAINING_ASSESSMENT_QUESTIONS"].ToString());
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 1;
dl_QuestionPaper.Visible = true;
tmExam.Enabled = true;
hdnTime.Value = dt.Rows[0]["TRAINING_ASSESSMENT_TIME"].ToString();
if (Session["time"] == null)
{
TimerStart();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Frm_Assessment", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btnEndExam_Click(object sender, EventArgs e)
{
try
{
dt_QuestionPaper = Session["Questions"] as DataTable;
DataRow[] dr = dt_QuestionPaper.Select("Selected = 0");
if (dr.Length != 0)
{
if (Session["time"] != null)
{
BLL.ShowMessage(this, "Please answer all questions");
return;
}
}
SMHR_ASSESSMENT_RESULT oSMHR_ASSESSMENT_RESULT = new SMHR_ASSESSMENT_RESULT();
dr = dt_QuestionPaper.Select("QUESTIONBANK_ANSWER=Selected");
double result = (Convert.ToDouble(dr.Length) / Convert.ToDouble(dt_QuestionPaper.Rows.Count)) * 100;
lblPercentage.Text = (result).ToString() + "%";
lblGainedMarks.Text = dr.Length.ToString();
SMHR_TRAINING_ONLINEASSESSMENT oSMHR_TRAINING_ONLINEASSESSMENT = new SMHR_TRAINING_ONLINEASSESSMENT();
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Select_New;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_ID = Convert.ToInt32(lblExamID.Text);
oSMHR_TRAINING_ONLINEASSESSMENT.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dt = BLL.get_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT);
if (result >= Convert.ToInt32(dt.Rows[0]["TRAINING_ASSESSMENT_MINMARKS"]))
{
lblResult.Text = "Pass";
oSMHR_ASSESSMENT_RESULT.ASSESSMENTRESULT_RESULT = true;
}
else
{
lblResult.Text = "Fail";
oSMHR_ASSESSMENT_RESULT.ASSESSMENTRESULT_RESULT = false;
}
oSMHR_ASSESSMENT_RESULT.ASSESSMENTRESULT_ASSESSMENTID = Convert.ToInt32(lblExamID.Text);
oSMHR_ASSESSMENT_RESULT.ASSESSMENTRESULT_EMP_ID = Convert.ToInt32(Session["EMP_ID"]);
oSMHR_ASSESSMENT_RESULT.ASSESSMENTRESULT_DATE = DateTime.Now;
oSMHR_ASSESSMENT_RESULT.ASSESSMENTRESULT_MARKS = dr.Length;
oSMHR_ASSESSMENT_RESULT.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
oSMHR_ASSESSMENT_RESULT.CREATEDDATE = DateTime.Now;
oSMHR_ASSESSMENT_RESULT.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
oSMHR_ASSESSMENT_RESULT.OPERATION = operation.Insert;
BLL.set_AssessmentResult(oSMHR_ASSESSMENT_RESULT);
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 2;
Session["time"] = null;
tmExam.Enabled = false;
}
catch (Exception ex)
{
//Utils.HandleWebException(ex, this);
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "Frm_Assessment", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void lnk_FEEDBACK_ID_Command(object sender, CommandEventArgs e)
{
try
{
ClearControls();
SMHR_TRAINING_ONLINEASSESSMENT oSMHR_TRAINING_ONLINEASSESSMENT = new SMHR_TRAINING_ONLINEASSESSMENT();
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Get;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument));
lbl_id.Text = Convert.ToString(e.CommandArgument);
DataTable DT = BLL.get_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT);
if (DT.Rows.Count != 0)
{
LoadCombos();
rcmb_CC.SelectedIndex = rcmb_CC.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_COURSECATEGORY_ID"]));
rcmb_CC_SelectedIndexChanged(null, null);
rcmb_CourseName.SelectedIndex = rcmb_CourseName.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_COURSE_ID"]));
rcmb_CourseName_SelectedIndexChanged(null, null);
rcmb_CourseSchedule.SelectedIndex = rcmb_CourseSchedule.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_COURSESCHEDULE_ID"]));
radChapters.SelectedIndex = radChapters.Items.FindItemIndexByValue(Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_CHAPTER_ID"]));
radChapters_SelectedIndexChanged(null, null);
BindSelectedQuestions(Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_QUESTIONS"]));
rtxt_AssessmentName.Text = Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_NAME"]);
rtxt_FeedbackDescription.Text = Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_DESC"]);
radNoOfQuestions.Text = Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_NOOFQUESTIONS"]);
radMarks.Text = Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_MINMARKS"]);
radAssessmentTime.Text = Convert.ToString(DT.Rows[0]["TRAINING_ASSESSMENT_TIME"]);
radStartdate.SelectedDate = Convert.ToDateTime(DT.Rows[0]["TRAINING_ASSESSMENT_STARTDATE"]);
radEndDate.SelectedDate = Convert.ToDateTime(DT.Rows[0]["TRAINING_ASSESSMENT_ENDDATE"]);
radStartTime.SelectedDate = Convert.ToDateTime(DT.Rows[0]["TRAINING_ASSESSMENT_STARTTIME"]);
radEndTime.SelectedDate = Convert.ToDateTime(DT.Rows[0]["TRAINING_ASSESSMENT_ENDTIME"]);
rcmb_CC.Enabled = false;
rcmb_CourseName.Enabled = false;
rcmb_CourseSchedule.Enabled = false;
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 1;
btn_Update.Visible = true;
btn_Save.Visible = false;
btn_Cancel.Visible = true;
rtxt_AssessmentName.Enabled = false;
//rtxt_FeedbackDescription.Enabled = false;
Rp_TRGFEEDABCK_VIEWMAIN.Visible = false;
RP_trgfeedback_VIEWDETAILS.Visible = true;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingFeedBack", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
/// <summary>
/// save click methods
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
SMHR_CHAPTERS _obj_Smhr_Chapter = new SMHR_CHAPTERS();
_obj_Smhr_Chapter.CHAPTER_NAME = rtxt_ChapterName.Text;
_obj_Smhr_Chapter.CHAPTER_DESCRIPTION = rtxt_ChapterDesc.Text;
_obj_Smhr_Chapter.CHAPTER_COURSE_ID = Convert.ToInt32(rcmb_CN.SelectedValue);
_obj_Smhr_Chapter.CHARPTER_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Chapter.CHAPTER_STATUS = rad_IsActive.Checked;
_obj_Smhr_Chapter.CHAPTER_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Chapter.CHAPTER_CREATEDDATE = DateTime.Now;
_obj_Smhr_Chapter.CHARPTER_ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Chapter.CHAPTER_LASTMDFDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Chapter.CHAPTER_LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_Smhr_Chapter.CHAPTER_ID = Convert.ToInt32(lbl_ChapterId.Text);
_obj_Smhr_Chapter.OPERATION = operation.Update;
if (Convert.ToBoolean(rad_IsActive.Checked) == false)
{
//SMHR_COURSESCHEDULE _obj_CourseSchedule = new SMHR_COURSESCHEDULE();
//_obj_CourseSchedule.OPERATION = operation.Check2;
//_obj_CourseSchedule.COURSESCHEDULEID = Convert.ToInt32(lblCourseScheduleID.Text);
SMHR_TRAINING_ONLINEASSESSMENT _obj_Online = new SMHR_TRAINING_ONLINEASSESSMENT();
_obj_Online.OPERATION = operation.Check2;
_obj_Online.TRAINING_ASSESSMENT_CHAPTER_ID = Convert.ToInt32(lbl_ChapterId.Text);
DataTable dt = BLL.get_OnlineAssessment(_obj_Online);
if (Convert.ToString(dt.Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Cannot make inactive");
rad_IsActive.Checked = true;
return;
}
}
if (BLL.set_Chapter(_obj_Smhr_Chapter))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_Smhr_Chapter.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Chapter(_obj_Smhr_Chapter).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Chapter with this Name Already Exists");
return;
}
_obj_Smhr_Chapter.OPERATION = operation.Insert;
if (BLL.set_Chapter(_obj_Smhr_Chapter))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_Course_page.SelectedIndex = 0;
LoadGrid();
Rg_Course.DataBind();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Chapters", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (radQuestions.CheckedItems.Count == 0)
{
BLL.ShowMessage(this, "Please select Questions");
return;
}
if (Convert.ToInt32(radNoOfQuestions.Text) != radQuestions.CheckedItems.Count)
{
BLL.ShowMessage(this, "No Of Questions and Selected Questions Not matched");
return;
}
SMHR_TRAINING_ONLINEASSESSMENT oSMHR_TRAINING_ONLINEASSESSMENT = new SMHR_TRAINING_ONLINEASSESSMENT();
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_COURSECATEGORY_ID = Convert.ToInt32(rcmb_CC.SelectedValue);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_COURSE_ID = Convert.ToInt32(rcmb_CourseName.SelectedValue);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_COURSESCHEDULE_ID = Convert.ToInt32(rcmb_CourseSchedule.SelectedValue);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_NAME = rtxt_AssessmentName.Text;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_DESC = rtxt_FeedbackDescription.Text;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_CHAPTER_ID = Convert.ToInt32(radChapters.SelectedValue);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_NOOFQUESTIONS = Convert.ToInt32(radNoOfQuestions.Text);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_MINMARKS = Convert.ToInt32(radMarks.Text);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_TIME = Convert.ToInt32(radAssessmentTime.Text);
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_STARTDATE = (DateTime)radStartdate.SelectedDate;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_STARTTIME = (DateTime)radStartTime.SelectedDate;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_ENDDATE = (DateTime)radEndDate.SelectedDate;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_ENDTIME = (DateTime)radEndTime.SelectedDate;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_QUESTIONS = GetSelectedQuestions();
oSMHR_TRAINING_ONLINEASSESSMENT.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
oSMHR_TRAINING_ONLINEASSESSMENT.CREATEDDATE = DateTime.Now;
oSMHR_TRAINING_ONLINEASSESSMENT.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
oSMHR_TRAINING_ONLINEASSESSMENT.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
oSMHR_TRAINING_ONLINEASSESSMENT.LASTMDFDATE = DateTime.Now;
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Update;
oSMHR_TRAINING_ONLINEASSESSMENT.TRAINING_ASSESSMENT_ID = Convert.ToInt32(lbl_id.Text);
if (BLL.set_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Assessment Name with this Name Already Exists");
return;
}
oSMHR_TRAINING_ONLINEASSESSMENT.OPERATION = operation.Insert;
if (BLL.set_OnlineAssessment(oSMHR_TRAINING_ONLINEASSESSMENT))
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
default:
break;
}
Rm_TRGFEEDABCK_PAGE.SelectedIndex = 0;
LoadGrid();
Rg_TrgFeedback.DataBind();
Rg_TrgFeedback.Visible = true;
Rp_TRGFEEDABCK_VIEWMAIN.Visible = true;
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingFeedBack", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}