public void LoadGrid()
{
try
{
SMHR_TRAINING_OFFLINEASSESSMENTS _obj_SMHR_Offlineassesments = new SMHR_TRAINING_OFFLINEASSESSMENTS();
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ORGID = Convert.ToInt32(Session["ORG_ID"]);
DataTable DT = BLL.get_OfflineAssessment(_obj_SMHR_Offlineassesments);
if (DT.Rows.Count != 0)
{
Rg_Course.DataSource = DT;
}
else
{
DataTable dt1 = new DataTable();
Rg_Course.DataSource = dt1;
}
clearControls();
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_offline Assessments", 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
{
// lbl_CourseHeader.Visible = false;
rcmb_CC.Enabled = false;
btn_Save.Visible = false;
rfc_rcmb_CS.Enabled = false;
rtxt_AssessmentName.Enabled = false;
clearControls();
LoadCombos();
//LoadComboSchedule();
//lbl_CourseName.Enabled = false;
//DataTable dt = BLL.get_OfflineAssessment(new SMHR_TRAINING_OFFLINEASSESSMENTS(Convert.ToInt32(Convert.ToString(e.CommandArgument))));
if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2)
{
btn_Update.Visible = false;
}
else
{
btn_Update.Visible = true;
}
lbl_OfflineassementId.Text = Convert.ToString(e.CommandArgument);
SMHR_TRAINING_OFFLINEASSESSMENTS _obj_SMHR_Offlineassesments = new SMHR_TRAINING_OFFLINEASSESSMENTS();
_obj_SMHR_Offlineassesments.OPERATION = operation.Get;
_obj_SMHR_Offlineassesments.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ID = Convert.ToInt32(lbl_OfflineassementId.Text);
DataTable dt = BLL.get_OfflineAssessment(_obj_SMHR_Offlineassesments);
if (dt.Rows.Count != 0)
{
rcmb_CC.SelectedIndex = rcmb_CC.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["OFFLINEASSESSMENT_COURSEID"]));
radCourse_SelectedIndexChanged(null, null);
rfc_rcmb_CS.SelectedIndex = rfc_rcmb_CS.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["OFFLINEASSESSMENT_COURSESCHEDULEID"]));
rtxt_AssessmentName.Text = Convert.ToString(dt.Rows[0]["OFFLINEASSESSMENT_NAME"]);
rad_IsActive.Checked = Convert.ToBoolean(dt.Rows[0]["OFFLINEASSESSMENT_STATUS"]);
Rm_Course_page.SelectedIndex = 1;
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_offline Assessments", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (((Button)sender).ID.ToUpper() == "BTN_UPDATE")
{
if (Convert.ToString(rad_IsActive.Checked) == "True")
{
if (fileupload_upload.FileName == "")
{
BLL.ShowMessage(this, "Please Select a File to Upload");
return;
}
}
}
SMHR_TRAINING_OFFLINEASSESSMENTS _obj_SMHR_Offlineassesments = new SMHR_TRAINING_OFFLINEASSESSMENTS();
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_COURSEID = Convert.ToInt32(rcmb_CC.SelectedValue);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_COURSESCHEDULEID = Convert.ToInt32(rfc_rcmb_CS.SelectedValue);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_NAME = rtxt_AssessmentName.Text;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_UPLOADEDDOC = fileupload_upload.FileName;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_CREATEDDATE = DateTime.Now;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ORGID = Convert.ToInt32(Session["ORG_ID"]);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_MODYFIEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_MODYFIEDDATE = DateTime.Now;
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_STATUS = rad_IsActive.Checked;
if (fileupload_upload.HasFile)
{
string pdfName = rtxt_AssessmentName.Text + "_" + Guid.NewGuid().ToString() + "_FBIO" + fileupload_upload.FileName;
string strPath = "~/EmpUploads/" + pdfName;
fileupload_upload.PostedFile.SaveAs(Server.MapPath("~/EmpUploads/") + pdfName);
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_UPLOADEDDOC = strPath;
}
switch (((Button)sender).ID.ToUpper())
{
case "BTN_UPDATE":
_obj_SMHR_Offlineassesments.OFFLINEASSESSMENT_ID = Convert.ToInt32(lbl_OfflineassementId.Text);
_obj_SMHR_Offlineassesments.OPERATION = operation.Check;
_obj_SMHR_Offlineassesments.OPERATION = operation.Update;
if (BLL.set_OfflineAssessment(_obj_SMHR_Offlineassesments))
{
BLL.ShowMessage(this, "Information Updated Successfully");
}
else
{
BLL.ShowMessage(this, "Information Not Saved");
}
break;
case "BTN_SAVE":
_obj_SMHR_Offlineassesments.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_OfflineAssessment(_obj_SMHR_Offlineassesments).Rows[0]["Count"]) != "0")
{
BLL.ShowMessage(this, "Assessment Name with this Name Already Exists");
return;
}
_obj_SMHR_Offlineassesments.OPERATION = operation.Insert;
if (BLL.set_OfflineAssessment(_obj_SMHR_Offlineassesments))
{
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_offline Assessments", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
