protected void btn_Update_Click(object sender, EventArgs e) { try { _obj_Rec_SkillCategary = new RECRUITMENT_SKILLSCATEGARY(); _obj_Rec_SkillCategary.SKILLCAT_ID = Convert.ToInt32(lbl_id.Text); _obj_Rec_SkillCategary.SKILLCAT_NAME = Recruitment_BLL.ReplaceQuote(Convert.ToString(txt_Skillname.Text)); _obj_Rec_SkillCategary.SKILLCAT_DESCRIPTION = Recruitment_BLL.ReplaceQuote(Convert.ToString(txt_Description.Text)); _obj_Rec_SkillCategary.SKILLCAT_SKILLID = Convert.ToInt32(RCB_Skills.SelectedValue); _obj_Rec_SkillCategary.LASTMDFBY = 1; // ### Need to Get the Session _obj_Rec_SkillCategary.LASTMDFDATE = DateTime.Now; _obj_Rec_SkillCategary.MODE = 4; bool status = Recruitment_BLL.set_skillscategary(_obj_Rec_SkillCategary); if (status == true) { Recruitment_BLL.ShowMessage(this, "Skills Updated Succesfully"); loadgrid(); btn_Update.Visible = true; RM_Skillscategary.SelectedIndex = 0; } else { Recruitment_BLL.ShowMessage(this, "Unable to Update the record,Execption Occured"); return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_skill", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }
protected void btn_Save_Click(object sender, EventArgs e) { _obj_Rec_SkillCategary = new RECRUITMENT_SKILLSCATEGARY(); try { // _obj_Rec_SkillCategary.MODE = 3; _obj_Rec_SkillCategary.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //_obj_Pms_Ratings.RATINGS_NAME = Pms_Bll.ReplaceQuote(Convert.ToString(rtxt_RatingName.Text)) _obj_Rec_SkillCategary.SKILLCAT_DESCRIPTION = Recruitment_BLL.ReplaceQuote(Convert.ToString(RT_SkillDesc.Text)); _obj_Rec_SkillCategary.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); _obj_Rec_SkillCategary.LASTMDFDATE = DateTime.Now; _obj_Rec_SkillCategary.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); _obj_Rec_SkillCategary.CREATEDDATE = DateTime.Now; _obj_Rec_SkillCategary.SKILLCAT_SKILLID = Convert.ToInt32(RCMB_Skills.SelectedItem.Value); _obj_Rec_SkillCategary.SKILLCAT_NAME = Recruitment_BLL.ReplaceQuote(Convert.ToString(RT_Skillname.Text)); _obj_Rec_SkillCategary.MODE = 8; DataTable dt_Skills = Recruitment_BLL.get_skillscategary(_obj_Rec_SkillCategary); if (Convert.ToString(dt_Skills.Rows[0]["Count"]) != "0") { Recruitment_BLL.ShowMessage(this, "This Combination Already Exists"); return; } _obj_Rec_SkillCategary.MODE = 3; _obj_Rec_SkillCategary.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); bool status = Recruitment_BLL.set_skillscategary(_obj_Rec_SkillCategary); if (status == true) { Recruitment_BLL.ShowMessage(this, "Skills Inserted Succesfully"); loadgrid(); //clearfields(); RM_SkillsCategary.SelectedIndex = 0; return; } else { Recruitment_BLL.ShowMessage(this, "Unable to Update the record,Execption Occured"); return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_recruitmentskillscategary", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_update_Click(object sender, EventArgs e) { try { if (Page.IsValid) { if (validateapprovers()) { _obj_Rec_ApprovalProcess = new RECRUITMENT_APPROVALPROCESS(); _obj_Rec_ApprovalProcess.APPRO_ID = Convert.ToInt32(lbl_AP_Id.Text); // _obj_Rec_ApprovalProcess.APPRO_BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_Rec_ApprovalProcess.APPRO_1LEVEL = Convert.ToInt32(rcmb_1Level.SelectedValue); _obj_Rec_ApprovalProcess.APPRO_2LEVEL = Convert.ToInt32(rcmb_2Level.SelectedValue); _obj_Rec_ApprovalProcess.APPRO_3LEVEL = Convert.ToInt32(rcmb_3Level.SelectedValue); // _obj_Rec_ApprovalProcess.APPRO_ISAPPROVER2 = Convert.ToBoolean(chk_Approver2.Checked); _obj_Rec_ApprovalProcess.APPRO_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); _obj_Rec_ApprovalProcess.APPRO_LASTMDFDATE = DateTime.Now; _obj_Rec_ApprovalProcess.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //if (chk_Approver2.Checked == true) //{ // if (rcmb_Approver2.SelectedItem.Value == "0") // { // Recruitment_BLL.ShowMessage(this, "Please select approver2"); // return; // } //} _obj_Rec_ApprovalProcess.Mode = 20; bool status = Recruitment_BLL.set_EmpSetup(_obj_Rec_ApprovalProcess); if (status == true) { Recruitment_BLL.ShowMessage(this, "Record Updated Successfully"); LoadGrid(); btn_Save.Visible = true; Rm_ApproverProcess_PAGE.SelectedIndex = 0; //chk_Approver2.Checked = false; return; } } } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ApprovalProcess", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void LoadApplicantPhase() { try { DataTable DTApplicant = new DataTable(); _obj_Rec_Interview_Phase_Def = new RECRUITMENT_INTERVIEW_PHASE_DEF(); Rcb_PhaseID.Items.Clear(); _obj_Rec_Interview_Phase_Def.Mode = 7; _obj_Rec_Interview_Phase_Def.Phase_JobReqID = Convert.ToInt32(Rcb_JobReq.SelectedItem.Value); _obj_Rec_Interview_Phase_Def.Applicant = Convert.ToInt32(Rcb_ApplicantID.SelectedItem.Value); DTApplicant = Recruitment_BLL.get_InterviewPhaseDefinition(_obj_Rec_Interview_Phase_Def); //Rcb_PhaseID.DataSource = Recruitment_BLL.get_InterviewPhaseDefinition(_obj_SMHR_INTERVIEW_PHASE_DEF); if (DTApplicant.Rows.Count == 0) { Recruitment_BLL.ShowMessage(this, "Selected Applicant is already Rejected."); return; } else { Rcb_PhaseID.DataSource = DTApplicant; Rcb_PhaseID.DataValueField = "PHASE_ID"; Rcb_PhaseID.DataTextField = "PHASE_NAME"; Rcb_PhaseID.DataBind(); } Rcb_PhaseID.Items.Insert(0, new RadComboBoxItem("Select", "0")); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InterviewAssesment", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Submit_Click(object sender, EventArgs e) { try { _obj_Rec_Priority = new RECRUITMENT_INTERVIEW_PRIORITY(); _obj_Rec_Priority.PRIORITY_ORGANIZATIONID = Convert.ToInt32(Session["ORG_ID"].ToString()); switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": _obj_Rec_Priority.PRIORITY_VALUE = Convert.ToInt32(RNTB_PriorityValue.Value); _obj_Rec_Priority.PRIORITY_NAME = Recruitment_BLL.ReplaceQuote(Convert.ToString(txt_Priorityname.Text)); _obj_Rec_Priority.PRIORITY_ID = Convert.ToInt32(lbl_Id.Text); // _obj_Rec_Priority.PRIORITY_ID = Convert.ToInt32(priorityid); _obj_Rec_Priority.MODE = 2; _obj_Rec_Priority.PRIORITY_ORGANIZATIONID = Convert.ToInt32(Session["ORG_ID"].ToString()); if (Convert.ToString(Recruitment_BLL.get_InterviewPriority(_obj_Rec_Priority).Rows[0]["Count"]) != "1") { Recruitment_BLL.ShowMessage(this, "This Combination Already Exists"); return; } _obj_Rec_Priority.MODE = 3; if (Recruitment_BLL.set_InterviewPriority(_obj_Rec_Priority)) { Recruitment_BLL.ShowMessage(this, "Information Updated Successfully"); } else { Recruitment_BLL.ShowMessage(this, "Information Not Updated"); } LoadGrid(); RG_InterviewPriority.DataBind(); RM_InterviewPriority.SelectedIndex = 0; break; case "BTN_SUBMIT": _obj_Rec_Priority.PRIORITY_VALUE = Convert.ToInt32(RNTB_PriorityValue.Value); _obj_Rec_Priority.PRIORITY_NAME = Recruitment_BLL.ReplaceQuote(Convert.ToString(txt_Priorityname.Text)); _obj_Rec_Priority.PRIORITY_ORGANIZATIONID = Convert.ToInt32(Session["ORG_ID"].ToString()); _obj_Rec_Priority.MODE = 2; if (Convert.ToString(Recruitment_BLL.get_InterviewPriority(_obj_Rec_Priority).Rows[0]["Count"]) != "0") { Recruitment_BLL.ShowMessage(this, "This Combination Already Exists"); return; } _obj_Rec_Priority.MODE = 4; if (Recruitment_BLL.set_InterviewPriority(_obj_Rec_Priority)) { Recruitment_BLL.ShowMessage(this, "Information Saved Successfully"); } else { Recruitment_BLL.ShowMessage(this, "Information Not Saved"); } LoadGrid(); RG_InterviewPriority.DataBind(); RM_InterviewPriority.SelectedIndex = 0; break; default: break; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InterviewPriority", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }
protected void btn_Submit_Click(object sender, EventArgs e) { try { _obj_Rec_ApplicantGrade = new RECRUITMENT_APPLICANTGRADE(); // _obj_Rec_ApplicantGrade = new RECRUITMENT_APPLICANTGRADE _obj_Rec_ApplicantGrade.APPLGRADE_DESCRIPTION = txt_Description.Text.Replace("'", "''"); _obj_Rec_ApplicantGrade.APPLGRADE_CREATEDBY = Convert.ToInt32(Session["UserId"]); _obj_Rec_ApplicantGrade.APPLGRADE_CREADTEDATE = DateTime.Now; _obj_Rec_ApplicantGrade.APPLGRADE_LASTMDFBY = Convert.ToInt32(Session["UserId"]); _obj_Rec_ApplicantGrade.APPLGRADE_LASTMDFDATE = DateTime.Now; _obj_Rec_ApplicantGrade.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": _obj_Rec_ApplicantGrade.APPLGRADE_ID = Convert.ToInt32(lbl_GradeId.Text); _obj_Rec_ApplicantGrade.APPGRADE_SETID = Convert.ToInt32(RCMB_Type.SelectedItem.Value); _obj_Rec_ApplicantGrade.APPGRADE_NAME = txt_Name.Text.Replace("'", "''"); _obj_Rec_ApplicantGrade.MODE = 4; if (Convert.ToString(Recruitment_BLL.get_ApplicantGrade(_obj_Rec_ApplicantGrade).Rows[0]["Count"]) != "1") { Recruitment_BLL.ShowMessage(this, "This Combination Already Exists"); return; } _obj_Rec_ApplicantGrade.MODE = 3; if (Recruitment_BLL.set_ApplicantGrade(_obj_Rec_ApplicantGrade)) { Recruitment_BLL.ShowMessage(this, "Information Updated Successfully"); } else { Recruitment_BLL.ShowMessage(this, "Information Not Updated"); } LoadGrid(); RG_ApplicantGrade.DataBind(); RM_ApplicantGrade.SelectedIndex = 0; break; case "BTN_SUBMIT": _obj_Rec_ApplicantGrade.APPGRADE_SETID = Convert.ToInt32(RCMB_Type.SelectedItem.Value); _obj_Rec_ApplicantGrade.APPGRADE_NAME = txt_Name.Text.Replace("'", "''"); _obj_Rec_ApplicantGrade.MODE = 4; if (Convert.ToString(Recruitment_BLL.get_ApplicantGrade(_obj_Rec_ApplicantGrade).Rows[0]["Count"]) != "0") { Recruitment_BLL.ShowMessage(this, "This Combination Already Exists"); return; } _obj_Rec_ApplicantGrade.MODE = 2; if (Recruitment_BLL.set_ApplicantGrade(_obj_Rec_ApplicantGrade)) { Recruitment_BLL.ShowMessage(this, "Information Saved Successfully"); } else { Recruitment_BLL.ShowMessage(this, "Information Not Saved"); } LoadGrid(); RG_ApplicantGrade.DataBind(); RM_ApplicantGrade.SelectedIndex = 0; break; default: break; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_applicantgrade", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); return; } }
protected void btn_Save_Click(object sender, EventArgs e) { try { if (Page.IsValid) { if (validateapprovers()) { //_obj_Rec_ApprovalProcess = new RECRUITMENT_APPROVALPROCESS(); ////_obj_Rec_ApprovalProcess.APPRO_BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); //_obj_Rec_ApprovalProcess.APPRO_1LEVEL = Convert.ToInt32(rcmb_2Level.SelectedValue); //_obj_Rec_ApprovalProcess.APPRO_3LEVEL = Convert.ToInt32(rcmb_3Level.SelectedValue); ////if (rcmb_Approver1.SelectedItem.Value == "0") ////{ //// Recruitment_BLL.ShowMessage(this, "Please Select Approval1"); //// return; ////} //// _obj_Rec_ApprovalProcess.APPRO_APPROVER1_ID = Convert.ToInt32(rcmb_Approver1.SelectedItem.Value); ////if (rcmb_Approver2.SelectedItem.Value != "0") ////{ //// if (chk_Approver2.Checked == false) //// { //// Recruitment_BLL.ShowMessage(this, "Please check an Approval2 "); //// return; //// } ////} ////if (chk_Approver2.Checked == true) ////{ //// if (rcmb_Approver2.SelectedItem.Value == "0") //// { //// Recruitment_BLL.ShowMessage(this, "Please select approver2"); //// return; //// } ////} ////_obj_Rec_ApprovalProcess.APPRO_3LEVEL = Convert.ToInt32(rcmb_3Level.SelectedValue); //// _obj_Rec_ApprovalProcess.APPRO_ISAPPROVER2 = Convert.ToBoolean(chk_Approver2.Checked); //_obj_Rec_ApprovalProcess.Mode = 6; //_obj_Rec_ApprovalProcess.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); //DataTable dtemp = Recruitment_BLL.get_EmpSetup(_obj_Rec_ApprovalProcess); //if (Convert.ToInt32(dtemp.Rows[0]["Count"]) != 0) //{ // Recruitment_BLL.ShowMessage(this, "Business Unit already assigned"); // rcmb_2Level.Enabled = true; //} //else //{ _obj_Rec_ApprovalProcess = new RECRUITMENT_APPROVALPROCESS(); //_obj_Rec_ApprovalProcess.APPRO_BU_ID = Convert.ToInt32(rcmb_BusinessUnitType.SelectedItem.Value); _obj_Rec_ApprovalProcess.APPRO_1LEVEL = Convert.ToInt32(rcmb_1Level.SelectedValue); _obj_Rec_ApprovalProcess.APPRO_2LEVEL = Convert.ToInt32(rcmb_2Level.SelectedValue); _obj_Rec_ApprovalProcess.APPRO_3LEVEL = Convert.ToInt32(rcmb_3Level.SelectedValue); // _obj_Rec_ApprovalProcess.APPRO_ISAPPROVER2 = Convert.ToBoolean(chk_Approver2.Checked); _obj_Rec_ApprovalProcess.APPRO_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); _obj_Rec_ApprovalProcess.APPRO_CREATEDDATE = DateTime.Now; _obj_Rec_ApprovalProcess.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); //_obj_Rec_ApprovalProcess.APPRO_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); //_obj_Rec_ApprovalProcess.APPRO_LASTMDFDATE = DateTime.Now; _obj_Rec_ApprovalProcess.Mode = 3; bool status = Recruitment_BLL.set_EmpSetup(_obj_Rec_ApprovalProcess); if (status == true) { Recruitment_BLL.ShowMessage(this, "Record Inserted Successfully"); btn_Save.Visible = true; LoadGrid(); Rm_ApproverProcess_PAGE.SelectedIndex = 0; //DataTable dt = new DataTable(); ////rcmb_BusinessUnitType.SelectedIndex = 0; ////rcmb_EmployeeType.SelectedIndex = 0; ////rcmb_Approver1.SelectedIndex = 0; ////rcmb_Approver2.SelectedIndex = 0; ////rcmb_Approver2.Enabled = true; ////rcmb_BusinessUnitType.Enabled = true; ////rcmb_EmployeeType.Enabled = true; //// rcmb_Approver1.Enabled = true; //rcmb_1Level.DataSource = dt; //rcmb_1Level.DataBind(); //rcmb_3Level.DataSource = dt; //rcmb_3Level.DataBind(); //rcmb_2Level.DataSource = dt; //rcmb_2Level.DataBind(); ////chk_Approver2.Checked = false; //return; } // } } } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ApprovalProcess", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Submit_Click(object sender, EventArgs e) { try { StrAppend = new StringBuilder(); _obj_Rec_InterviewAssessmentForm = new RECRUITMENT_INTERVIEWASSESSMENTFORM(); _obj_Rec_InterviewAssessmentForm.IAF_APPLID = Convert.ToInt32(Rcb_ApplicantID.SelectedItem.Value); _obj_Rec_InterviewAssessmentForm.IAF_JOBREID = Convert.ToInt32(Rcb_JobReq.SelectedItem.Value); //_obj_Rec_InterviewAssessmentForm.MODE = 7; //if (Recruitment_BLL.get_InterviewAssessment(_obj_Rec_InterviewAssessmentForm).Rows[0]["COUNT"].ToString() != "0") //{ // Recruitment_BLL.ShowMessage(this, "Sorry.Applicant had already attended the Interview"); // return; //} //else //{ _obj_Rec_InterviewAssessmentForm.MODE = 1; _obj_Rec_InterviewAssessmentForm.IAF_ADDLCOMMENTS = Convert.ToString(rtxt_AdditionalComments1.Text); _obj_Rec_InterviewAssessmentForm.IAF_CREATEDBY = Convert.ToInt32(Session["UserId"]); _obj_Rec_InterviewAssessmentForm.IAF_CREATEDDATE = DateTime.Now; _obj_Rec_InterviewAssessmentForm.IAF_LASTMDFBY = Convert.ToInt32(Session["UserId"]); _obj_Rec_InterviewAssessmentForm.IAF_LASTMDFDATE = DateTime.Now; switch (((Button)sender).ID.ToUpper()) { case "BTN_SUBMIT": _obj_Rec_InterviewAssessmentForm.IAF_APPROVE = 1; //_obj_Rec_InterviewAssessmentForm.IAF_APPLID = Convert.ToInt32(Rcb_ApplicantID.SelectedItem.Value); //_obj_Rec_InterviewAssessmentForm.IAF_JOBREID = Convert.ToInt32(Rcb_JobReq.SelectedItem.Value); _obj_Rec_InterviewAssessmentForm.IAF_PHASEDEFID = Convert.ToInt32(Rcb_PhaseID.SelectedItem.Value); _obj_Rec_InterviewAssessmentForm.IAF_DATE = DateTime.Now; //Convert.ToDateTime(rdi_Date.Text);// foreach (GridDataItem Singleitem in RG_Skills1.Items) { _obj_Rec_InterviewAssessmentForm.IAF_SKILLCAT_ID = Convert.ToInt32(Singleitem.Cells[2].Text); RadComboBox chk = (RadComboBox)Singleitem.Cells[4].FindControl("Rcb_Assesment"); StrAppend.Append("Exec USP_SMHR_INTERVIEWASSESSMENTFORM @MODE = 1 , @IAF_APPLID = '" + _obj_Rec_InterviewAssessmentForm.IAF_APPLID + "'"); StrAppend.AppendLine(",@IAF_JOBREID = '" + _obj_Rec_InterviewAssessmentForm.IAF_JOBREID + "', @IAF_SKILLCAT_ID = '" + _obj_Rec_InterviewAssessmentForm.IAF_SKILLCAT_ID + "'"); StrAppend.AppendLine(",@IAF_APPLGRADE_ID = '" + chk.SelectedItem.Value + "',@IAF_ADDLCOMMENTS = '" + _obj_Rec_InterviewAssessmentForm.IAF_ADDLCOMMENTS + "'"); StrAppend.AppendLine(",@IAF_APPROVE = '" + _obj_Rec_InterviewAssessmentForm.IAF_APPROVE + "', @IAF_DATE = '" + _obj_Rec_InterviewAssessmentForm.IAF_DATE + "'"); StrAppend.AppendLine(",@IAF_CREATEDBY = '" + _obj_Rec_InterviewAssessmentForm.IAF_CREATEDBY + "',@IAF_CREATEDDATE = '" + _obj_Rec_InterviewAssessmentForm.IAF_CREATEDDATE + "' "); StrAppend.AppendLine(",@IAF_LASTMDFBY = '" + _obj_Rec_InterviewAssessmentForm.IAF_LASTMDFBY + "' , @IAF_LASTMDFDATE = '" + _obj_Rec_InterviewAssessmentForm.IAF_LASTMDFDATE + "'"); StrAppend.AppendLine(",@IAF_PHASEDEFID ='" + _obj_Rec_InterviewAssessmentForm.IAF_PHASEDEFID + "'"); } if (Recruitment_BLL.set_InterviewAssessment(_obj_Rec_InterviewAssessmentForm, StrAppend.ToString())) { Recruitment_BLL.ShowMessage(this, "Record saved successfully"); } else { Recruitment_BLL.ShowMessage(this, "Record not saved"); } ClearControls(); RMP_InterviewAssesment.SelectedIndex = 0; break; case "BTN_REJECTED": _obj_Rec_InterviewAssessmentForm.IAF_APPROVE = 0; //_obj_Rec_InterviewAssessmentForm.IAF_APPLID = Convert.ToInt32(Rcb_ApplicantID.SelectedItem.Value); //_obj_Rec_InterviewAssessmentForm.IAF_JOBREID = Convert.ToInt32(Rcb_JobReq.SelectedItem.Value); _obj_Rec_InterviewAssessmentForm.IAF_PHASEDEFID = Convert.ToInt32(Rcb_PhaseID.SelectedItem.Value); _obj_Rec_InterviewAssessmentForm.IAF_DATE = DateTime.Now; //Convert.ToDateTime(rdi_Date.Text); foreach (GridDataItem Singleitem in RG_Skills1.Items) { _obj_Rec_InterviewAssessmentForm.IAF_SKILLCAT_ID = Convert.ToInt32(Singleitem.Cells[2].Text); RadComboBox chk = (RadComboBox)Singleitem.Cells[4].FindControl("Rcb_Assesment"); StrAppend.Append("Exec USP_SMHR_INTERVIEWASSESSMENTFORM @MODE = 1 , @IAF_APPLID = '" + _obj_Rec_InterviewAssessmentForm.IAF_APPLID + "'"); StrAppend.AppendLine(",@IAF_JOBREID = '" + _obj_Rec_InterviewAssessmentForm.IAF_JOBREID + "', @IAF_SKILLCAT_ID = '" + _obj_Rec_InterviewAssessmentForm.IAF_SKILLCAT_ID + "'"); StrAppend.AppendLine(",@IAF_APPLGRADE_ID = '" + chk.SelectedItem.Value + "',@IAF_ADDLCOMMENTS = '" + _obj_Rec_InterviewAssessmentForm.IAF_ADDLCOMMENTS + "'"); StrAppend.AppendLine(",@IAF_APPROVE = '" + _obj_Rec_InterviewAssessmentForm.IAF_APPROVE + "', @IAF_DATE = '" + _obj_Rec_InterviewAssessmentForm.IAF_DATE + "'"); StrAppend.AppendLine(",@IAF_CREATEDBY = '" + _obj_Rec_InterviewAssessmentForm.IAF_CREATEDBY + "',@IAF_CREATEDDATE = '" + _obj_Rec_InterviewAssessmentForm.IAF_CREATEDDATE + "' "); StrAppend.AppendLine(",@IAF_LASTMDFBY = '" + _obj_Rec_InterviewAssessmentForm.IAF_LASTMDFBY + "' , @IAF_LASTMDFDATE = '" + _obj_Rec_InterviewAssessmentForm.IAF_LASTMDFDATE + "'"); StrAppend.AppendLine(",@IAF_PHASEDEFID ='" + _obj_Rec_InterviewAssessmentForm.IAF_PHASEDEFID + "'"); } if (Recruitment_BLL.set_InterviewAssessment(_obj_Rec_InterviewAssessmentForm, StrAppend.ToString())) { Recruitment_BLL.ShowMessage(this, "Record saved successfully"); } else { Recruitment_BLL.ShowMessage(this, "Record not saved"); } ClearControls(); RMP_InterviewAssesment.SelectedIndex = 0; break; case "BTN_NEXT": LoadApplicantDetails(); RMP_InterviewAssesment.SelectedIndex = 1; break; default: break; } // } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_InterviewAssesment", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }