/// <summary> /// load grid methods /// </summary> public void LoadGrid() { try { _obj_Smhr_Course = new SMHR_COURSE(); _obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable DT = BLL.get_Course(_obj_Smhr_Course); 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_Course", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadCombos() { btn_submit.Visible = false; Btn_cancel.Visible = false; RG_TrainingApproval.Visible = false; try { SMHR_COURSE _obj_Course = new SMHR_COURSE(); _obj_Course.OPERATION = operation.Select2; _obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); rc_Course.DataSource = BLL.get_Course(_obj_Course); rc_Course.DataTextField = "COURSE_NAME"; rc_Course.DataValueField = "COURSE_ID"; rc_Course.DataBind(); rc_Course.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); rc_CourseSchedule.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); rc_Days.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_AttendanceDetails", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
/// <summary> /// To Load BusinessUnit Details the Dropdown /// </summary> #endregion #region edit command methods /// <summary> /// to edit particular course based on command argument /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnk_Edit_Command(object sender, CommandEventArgs e) { try { //lbl_CourseHeader.Visible = false; rcmb_CC.Enabled = false; rtxt_CourseName.Enabled = false; clearControls(); LoadCombos(); //lbl_CourseName.Enabled = false; //lbl_labl.Text = Convert.ToString(e.CommandArgument); SMHR_COURSE oSMHR_COURSE = new SMHR_COURSE(); oSMHR_COURSE.OPERATION = operation.Select; oSMHR_COURSE.COURSE_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); DataTable dt = BLL.get_Course(oSMHR_COURSE); if (dt.Rows.Count != 0) { lbl_CourseId.Text = Convert.ToString(dt.Rows[0]["COURSE_ID"]); rtxt_CourseName.Text = Convert.ToString(dt.Rows[0]["COURSE_NAME"]); rtxt_CourseDesc.Text = Convert.ToString(dt.Rows[0]["COURSE_DESC"]); rtxt_CDS.Text = Convert.ToString(dt.Rows[0]["COURSE_DESIGNEDFOR"]); radCourseDuration.Text = Convert.ToString(dt.Rows[0]["COURSE_DURATION"]); rcmb_CC.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem(Convert.ToString(dt.Rows[0]["HR_MASTER_CODE"]), Convert.ToString(dt.Rows[0]["COURSE_CATEGORYID"]))); //rcmb_CC.SelectedIndex = rcmb_CC.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["COURSE_CATEGORYID"])); rad_IsActive.Checked = Convert.ToBoolean(dt.Rows[0]["COURSE_STATUS"]); hdnStatus.Value = Convert.ToString(dt.Rows[0]["COURSE_STATUS"]); if (rad_IsActive.Checked) { rtxt_CourseDesc.Enabled = true; rtxt_CDS.Enabled = true; radCourseDuration.Enabled = true; } else { rtxt_CourseDesc.Enabled = false; rtxt_CDS.Enabled = false; radCourseDuration.Enabled = false; } if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_Update.Visible = false; } else { btn_Update.Visible = true; } Rm_Course_page.SelectedIndex = 1; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Course", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadCourseName() { try { SMHR_COURSE _obj_Course = new SMHR_COURSE(); _obj_Course.OPERATION = operation.Select2; _obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); //Convert.ToInt32(Session["ORG_ID"]); rcmb_CourseName.DataSource = BLL.get_Course(_obj_Course); rcmb_CourseName.DataTextField = "COURSE_NAME"; rcmb_CourseName.DataValueField = "COURSE_ID"; rcmb_CourseName.DataBind(); rcmb_CourseName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_TrainingCosts", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadCombos() { try { obj_smhr_Period = new SMHR_PERIOD(); obj_smhr_Period.OPERATION = operation.Select; obj_smhr_Period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt_Details = BLL.get_PeriodHeaderDetails(obj_smhr_Period); //DataTable dt_Details = BLL.get_PeriodHeaderDetails_Calendar(obj_smhr_Period); rcmb_Period.DataSource = dt_Details; rcmb_Period.DataValueField = "PERIOD_ID"; rcmb_Period.DataTextField = "PERIOD_NAME"; rcmb_Period.DataBind(); rcmb_Period.Items.Insert(0, new RadComboBoxItem("Select")); _obj_Smhr_Location = new SMHR_TRAINING_LOCATION(); _obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Location.OPERATION = operation.Select1; rcmb_Location.DataSource = BLL.get_TrainingLocation(_obj_Smhr_Location); rcmb_Location.DataTextField = "Location_Name"; rcmb_Location.DataValueField = "Location_ID"; rcmb_Location.DataBind(); rcmb_Location.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); if (string.Compare(Control, "EmployeeAttendance", true) == 0) { SMHR_COURSE _obj_Course = new SMHR_COURSE(); _obj_Course.OPERATION = operation.Select2; _obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); //Convert.ToInt32(Session["ORG_ID"]); rcmb_Course.DataSource = BLL.get_Course(_obj_Course); rcmb_Course.DataTextField = "COURSE_NAME"; rcmb_Course.DataValueField = "COURSE_ID"; rcmb_Course.DataBind(); rcmb_Course.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "LocationWiseTrainingProgram", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void BindCourseCategory() { try { SMHR_COURSE _obj_Course = new SMHR_COURSE(); _obj_Course.OPERATION = operation.Select; _obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); rc_Course.DataSource = BLL.get_Course(_obj_Course); rc_Course.DataTextField = "COURSE_NAME"; rc_Course.DataValueField = "COURSE_ID"; rc_Course.DataBind(); rc_Course.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } 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"); } }
private void LoadCombos() { try { SMHR_COURSE _obj_Course = new SMHR_COURSE(); _obj_Course.OPERATION = operation.Select2; _obj_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); //Convert.ToInt32(Session["ORG_ID"]); radCourse.DataSource = BLL.get_Course(_obj_Course); radCourse.DataTextField = "COURSE_NAME"; radCourse.DataValueField = "COURSE_ID"; radCourse.DataBind(); radCourse.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); _obj_Smhr_Masters = new SMHR_MASTERS(); _obj_Smhr_Masters.MASTER_TYPE = "COURSETYPE"; _obj_Smhr_Masters.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); radCourseType.DataSource = BLL.get_MasterRecords(_obj_Smhr_Masters); radCourseType.DataTextField = "HR_MASTER_CODE"; radCourseType.DataValueField = "HR_MASTER_ID"; radCourseType.DataBind(); radCourseType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); _obj_Smhr_Location = new SMHR_TRAINING_LOCATION(); _obj_Smhr_Location.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Location.OPERATION = operation.Select1; radLocation.DataSource = BLL.get_TrainingLocation(_obj_Smhr_Location); radLocation.DataTextField = "Location_Name"; radLocation.DataValueField = "Location_ID"; radLocation.DataBind(); radLocation.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_CourseSchedule", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void rcmb_CC_SelectedIndexChanged(object o, RadComboBoxSelectedIndexChangedEventArgs e) { try { if (rcmb_CC.SelectedIndex > 0) { SMHR_COURSE _obj_Smhr_Course = new SMHR_COURSE(); _obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Course.COURSE_CATEGORYID = rcmb_CC.SelectedValue; _obj_Smhr_Course.OPERATION = operation.Get; DataTable DT = BLL.get_Course(_obj_Smhr_Course); rcmb_CourseName.DataSource = DT; rcmb_CourseName.DataValueField = "COURSE_ID"; rcmb_CourseName.DataTextField = "COURSE_NAME"; rcmb_CourseName.DataBind(); rcmb_CourseName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "0")); } } 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 { _obj_Smhr_Course = new SMHR_COURSE(); _obj_Smhr_Course.COURSE_NAME = BLL.ReplaceQuote(rtxt_CourseName.Text); _obj_Smhr_Course.COURSE_DESC = BLL.ReplaceQuote(rtxt_CourseDesc.Text); _obj_Smhr_Course.COURSE_CATEGORYID = rcmb_CC.SelectedItem.Value; _obj_Smhr_Course.COURSE_DURATION = Convert.ToInt32(radCourseDuration.Text); _obj_Smhr_Course.COURSE_STATUS = rad_IsActive.Checked; _obj_Smhr_Course.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session _obj_Smhr_Course.CREATEDDATE = DateTime.Now; _obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Course.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session _obj_Smhr_Course.LASTMDFDATE = DateTime.Now; _obj_Smhr_Course.COURSE_DESIGNEDFOR = rtxt_CDS.Text; switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": if (rad_IsActive.Checked == false && rad_IsActive.Checked == Convert.ToBoolean(hdnStatus.Value)) { BLL.ShowMessage(this, "There is no data to update"); Rm_Course_page.SelectedIndex = 0; LoadGrid(); return; } if (rad_IsActive.Checked) { _obj_Smhr_Course.OPERATION = operation.Select1; if (!Convert.ToBoolean(BLL.get_Course(_obj_Smhr_Course).Rows[0]["HR_MASTER_STATUS"])) { BLL.ShowMessage(this, "Please Change Course Category Status to Active for this Course"); Rm_Course_page.SelectedIndex = 0; LoadGrid(); return; } } else { SMHR_COURSESCHEDULE _obj_CS = new SMHR_COURSESCHEDULE(); _obj_CS.OPERATION = operation.Online; _obj_CS.COURSESCHEDULE_COURSEID = Convert.ToInt32(lbl_CourseId.Text); _obj_CS.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); // _obj_CS.COURSESCHEDULE_STATUS=rad_IsActive.Checked; DataTable dtc = BLL.get_CourseSchedule(_obj_CS); if (!Convert.ToBoolean(dtc.Rows[0]["Status"])) { BLL.ShowMessage(this, Convert.ToString(dtc.Rows[0]["ErrorMessage"])); rad_IsActive.Checked = true; Rm_Course_page.SelectedIndex = 0; LoadGrid(); return; } } //if (Convert.ToBoolean(rad_IsActive.Checked) == false) //{ // SMHR_TRAINERPROFILE _obj_Trainer = new SMHR_TRAINERPROFILE(); // _obj_Trainer.TRAINER_ORGID = Convert.ToInt32(Session["ORG_ID"]); // _obj_Trainer.Trainer_CourseCategory = Convert.ToInt32(lbl_CourseId.Text); // _obj_Trainer.OPERATION = operation.Scale; // DataTable dt = BLL.get_TrainingProfile(_obj_Trainer); // if (!Convert.ToBoolean(dt.Rows[0]["Status"])) // { // BLL.ShowMessage(this, "Cannot make inactive"); // rad_IsActive.Checked = true; // return; // } //} _obj_Smhr_Course.COURSE_ID = Convert.ToInt32(lbl_CourseId.Text); _obj_Smhr_Course.OPERATION = operation.Update; if (BLL.set_Course(_obj_Smhr_Course)) { BLL.ShowMessage(this, "Information Updated Successfully"); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; case "BTN_SAVE": _obj_Smhr_Course.OPERATION = operation.Check; if (Convert.ToString(BLL.get_Course(_obj_Smhr_Course).Rows[0]["Count"]) != "0") { BLL.ShowMessage(this, "Course with this Name Already Exists"); return; } _obj_Smhr_Course.OPERATION = operation.Insert; if (BLL.set_Course(_obj_Smhr_Course)) { 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_Course", 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 { if ((rlb_skills.Items.Count != 0)) { Label Label1 = new Label(); StringBuilder sb = new StringBuilder(); IList <RadListBoxItem> collection = rlb_skills.CheckedItems; foreach (RadListBoxItem item in collection) { if (sb.Length == 0) { sb.Append(item.Value); } else { sb.Append("," + item.Value); } } Label1.Text = sb.ToString(); _obj_Smhr_Course = new SMHR_COURSE(); if (Label1.Text == "") { _obj_Smhr_Course.COURSE_SKILL_WID = Convert.ToString(0); } else { _obj_Smhr_Course.COURSE_SKILL_WID = Convert.ToString(Label1.Text); } _obj_Smhr_Course.COURSE_BUSINESSUNIT_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_Smhr_Course.COURSE_NAME = BLL.ReplaceQuote(rtxt_CourseName.Text.ToUpper()); _obj_Smhr_Course.COURSE_DESC = BLL.ReplaceQuote(rtxt_CourseDesc.Text); _obj_Smhr_Course.COURSE_CATEGORYID = rcmb_CC.SelectedItem.Value; _obj_Smhr_Course.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session _obj_Smhr_Course.CREATEDDATE = DateTime.Now; _obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Course.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session _obj_Smhr_Course.LASTMDFDATE = DateTime.Now; switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": _obj_Smhr_Course.COURSE_ID = Convert.ToInt32(lbl_CourseId.Text); _obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Course.OPERATION = operation.Check; if (Convert.ToString(BLL.get_Course(_obj_Smhr_Course).Rows[0]["Count"]) != "1") { BLL.ShowMessage(this, "Course with this Name Already Exists"); return; } _obj_Smhr_Course.OPERATION = operation.Update; if (BLL.set_Course(_obj_Smhr_Course)) { BLL.ShowMessage(this, "Information Updated Successfully"); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; case "BTN_SAVE": _obj_Smhr_Course.OPERATION = operation.Check; _obj_Smhr_Course.COURSE_ORG_ID = Convert.ToInt32(Session["ORG_ID"]); if (Convert.ToString(BLL.get_Course(_obj_Smhr_Course).Rows[0]["Count"]) != "0") { BLL.ShowMessage(this, "Course with this Name Already Exists"); return; } _obj_Smhr_Course.OPERATION = operation.Insert; if (BLL.set_Course(_obj_Smhr_Course)) { 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(); } else { BLL.ShowMessage(this, "Select Skills"); return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Course", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }