protected void GridView_Criteria_RowDeleting(object sender, GridViewDeleteEventArgs e) { int ID = UDFLib.ConvertToInteger(GridView_Criteria.DataKeys[e.RowIndex].Value.ToString()); BLL_Crew_Interview.DELETE_Criteria(ID, GetSessionUserID()); Bind_QuestionBank(); }
protected void Load_CategoryList() { DataTable dt = BLL_Crew_Interview.Get_CategoryList(txtfilter.Text); GridView_Category.DataSource = dt; GridView_Category.DataBind(); }
protected void GridView_Criteria_RowUpdating(object sender, GridViewUpdateEventArgs e) { int ID = UDFLib.ConvertToInteger(GridView_Criteria.DataKeys[e.RowIndex].Value.ToString()); string Criteria = e.NewValues["Question"].ToString(); string Answer = ""; if (e.NewValues["Answer"] != null) { Answer = e.NewValues["Answer"].ToString(); } int Cat_ID = 0; int Grading_Type = UDFLib.ConvertToInteger(e.NewValues["Grading_Type"].ToString()); DropDownList ddlCategory = (DropDownList)GridView_Criteria.Rows[e.RowIndex].FindControl("ddlCategory"); if (ddlCategory != null) { Cat_ID = UDFLib.ConvertToInteger(ddlCategory.SelectedValue); } BLL_Crew_Interview.UPDATE_Criteria(ID, Criteria, Answer, Cat_ID, Grading_Type, GetSessionUserID()); GridView_Criteria.EditIndex = -1; Bind_QuestionBank(); }
protected void GridView_UnAssignedCriteria_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { int iQuestionID = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "ID").ToString()); int Grading_Type = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "Grading_Type").ToString()); RadioButtonList rdo = (RadioButtonList)e.Row.FindControl("rdoOptions"); TextBox txtAnswer = (TextBox)e.Row.FindControl("txtAnswer"); TextBox txtRemarks = (TextBox)e.Row.FindControl("txtRemarks"); if (rdo != null) { DataTable dt = BLL_Crew_Interview.Get_GradingOptions(Grading_Type); rdo.DataSource = dt; rdo.DataBind(); } } } catch { } }
protected void ddlRank_SelectedIndexChanged(object sender, EventArgs e) { int InterviewID = int.Parse(getQueryString("ID")); DataTable dt = BLL_Crew_Interview.getInterviewDetails(InterviewID); if (dt.Rows.Count > 0) { int IQID = UDFLib.ConvertToInteger(dt.Rows[0]["IQID"]); int RankID = UDFLib.ConvertToInteger(ddlRank.SelectedValue); if (dt.Rows[0]["RankID"].ToString() != ddlRank.SelectedValue) { //BLL_Crew_Interview.UPDATE_CrewInterviewPlanning(InterviewID, dt.Rows[0]["InterviewPlanDate"].ToString(), UDFLib.ConvertToInteger(dt.Rows[0]["PlannedInterviewerID"].ToString()), RankID, GetSessionUserID()); } lblMaxMarks.Text = ""; lblUserMarks_P.Text = ""; lblUserMarks.Text = ""; lblOutOf5.Text = ""; DataSet dsQA = BLL_Crew_Interview.Get_InterviewQuestionAnswers(InterviewID, RankID); GridView_AssignedCriteria.DataSource = dsQA.Tables[0]; GridView_AssignedCriteria.DataBind(); } }
protected void Load_GradingList() { DataTable dt = BLL_Crew_Interview.Get_GradingList(); GridView_Grading.DataSource = dt; GridView_Grading.DataBind(); }
protected void GridView_Category_RowDeleting(object sender, GridViewDeleteEventArgs e) { int ID = UDFLib.ConvertToInteger(GridView_Category.DataKeys[e.RowIndex].Value.ToString()); BLL_Crew_Interview.DELETE_Category(ID, GetSessionUserID()); Load_CategoryList(); }
protected void btnsave_Click(object sender, EventArgs e) { int ID = BLL_Crew_Interview.INSERT_Category(txtCatName.Text.Trim(), GetSessionUserID()); txtCatName.Text = ""; txtfilter.Text = ""; Load_CategoryList(); }
protected void Load_Gradings() { DataTable dt = BLL_Crew_Interview.Get_GradingList(); ddlGradingType.DataSource = dt; ddlGradingType.DataBind(); ddlGradingType.Items.Insert(0, new ListItem("-Select-", "0")); }
protected void ddlGradingType_SelectedIndexChanged(object sender, EventArgs e) { int Grade_ID = UDFLib.ConvertToInteger(ddlGradingType.SelectedValue); DataTable dt = BLL_Crew_Interview.Get_GradingOptions(Grade_ID); rdoGradings.DataSource = dt; rdoGradings.DataBind(); }
protected void Load_CategoryList(DropDownList ddlCategory) { DataTable dt = BLL_Crew_Interview.Get_CategoryList(""); ddlCategory.DataSource = dt; ddlCategory.DataBind(); ddlCategory.Items.Insert(0, new ListItem("-Select All-", "0")); }
protected void GridView_Interview_RowDeleting(object sender, GridViewDeleteEventArgs e) { int IQID = UDFLib.ConvertToInteger(GridView_Interview.DataKeys[e.RowIndex].Values[0].ToString()); int RankID = UDFLib.ConvertToInteger(GridView_Interview.DataKeys[e.RowIndex].Values[1].ToString()); BLL_Crew_Interview.Delete_Interview(IQID, RankID, GetSessionUserID()); Bind_Interviews(); }
protected void GridView_Category_RowUpdating(object sender, GridViewUpdateEventArgs e) { int ID = UDFLib.ConvertToInteger(GridView_Category.DataKeys[e.RowIndex].Value.ToString()); string Category_Name = e.NewValues["Category_Name"].ToString(); BLL_Crew_Interview.UPDATE_Category(ID, Category_Name, GetSessionUserID()); GridView_Category.EditIndex = -1; Load_CategoryList(); }
protected void Load_BriefResults(int CrewID, string InterviewType) { DataSet ds = BLL_Crew_Interview.Get_Crew_Interview_Results(CrewID, GetSessionUserID(), InterviewType); if (ds.Tables.Count > 0) { gvBriefResult.DataSource = ds.Tables[0]; gvBriefResult.DataBind(); } }
protected void btnSavePlanning_Click(object sender, EventArgs e) { try { int iCrewID = GetCrewID(); string PlanDateTime = txtPlanDate.Text + " " + ddlPlanH.Text + ":" + ddlPlanM.Text; if (int.Parse(ddlPlanH.Text) < 12) { PlanDateTime += " AM"; } else { PlanDateTime += " PM"; } int iInterviewID = BLL_Crew_Interview.INS_CrewInterviewPlanning(iCrewID, int.Parse(ddlPlanRank.SelectedValue), txtPlanCrewName.Text, PlanDateTime, int.Parse(ddlPlanInterviewer.SelectedValue), txtPlanInterviewerPosition.Text, GetSessionUserID()); hdnInterviewID.Value = iInterviewID.ToString(); lblMessage.Text = "Interview planned for " + txtPlanCrewName.Text; txtInterviewDate.Text = DateTime.Today.ToString("dd/MM/yyyy"); ddlRank.SelectedValue = ddlPlanRank.SelectedValue; string InterviewPlannedDate = ""; string InterviewID = ""; int iUserID = GetSessionUserID(); string CrewName = objCrewBLL.Get_CrewPersonalDetailsByID(iCrewID, "staff_name"); DataTable dt = BLL_Crew_Interview.Get_PlannedInterviewDetails(iUserID, iCrewID); if (dt.Rows.Count > 0) { InterviewID = dt.Rows[0]["ID"].ToString(); InterviewPlannedDate = dt.Rows[0]["InterviewPlanDate"].ToString(); hdnInterviewID.Value = InterviewID; ddlRank.SelectedValue = dt.Rows[0]["Rank"].ToString(); ddlRank.Enabled = false; txtPersonInterviewed.Text = CrewName; //getQueryString("Name"); txtPersonInterviewed.Enabled = false; txtInterviewDate.Text = DateTime.Today.ToString(Convert.ToString(Session["User_DateFormat"])); txtInterviewDate.Enabled = false; lblPlannedDate.Text = UDFLib.ConvertUserDateFormatTime(Convert.ToString(dt.Rows[0]["InterviewPlanDate"])); lblPlannedBy.Text = dt.Rows[0]["PlannedBy"].ToString(); pnlInterviewPlanning.Visible = false; pnlEdit_InterviewResult.Visible = true; } } catch (Exception ex) { lblMessage.Text = ex.Message; } }
protected void GridView_AssignedCriteria_RowCommand(object sender, GridViewCommandEventArgs e) { int SelectedRowIndex = 0; int IQID = 0; int QID = 0; int RankID = 0; if (e.CommandName == "MoveUp") { GridViewRow r = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent; SelectedRowIndex = r.RowIndex; IQID = UDFLib.ConvertToInteger(Request.QueryString["IQID"].ToString()); QID = UDFLib.ConvertToInteger(GridView_AssignedCriteria.DataKeys[SelectedRowIndex].Values[0].ToString()); RankID = UDFLib.ConvertToInteger(GridView_AssignedCriteria.DataKeys[SelectedRowIndex].Values[1].ToString()); BLL_Crew_Interview.Swap_InterviewQuestion_Sort_Order(IQID, RankID, QID, 1, GetSessionUserID()); if (SelectedRowIndex >= 1) { SelectedRowIndex -= 1; } Bind_AssignedCriteria(); GridView_AssignedCriteria.SelectedIndex = SelectedRowIndex; } else if (e.CommandName == "MoveDown") { GridViewRow r = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent; SelectedRowIndex = r.RowIndex; IQID = UDFLib.ConvertToInteger(Request.QueryString["IQID"].ToString()); QID = UDFLib.ConvertToInteger(GridView_AssignedCriteria.DataKeys[SelectedRowIndex].Values[0].ToString()); RankID = UDFLib.ConvertToInteger(GridView_AssignedCriteria.DataKeys[SelectedRowIndex].Values[1].ToString()); BLL_Crew_Interview.Swap_InterviewQuestion_Sort_Order(IQID, RankID, QID, -1, GetSessionUserID()); if (SelectedRowIndex < GridView_AssignedCriteria.Rows.Count - 1) { SelectedRowIndex += 1; } Bind_AssignedCriteria(); GridView_AssignedCriteria.SelectedIndex = SelectedRowIndex; } else if (e.CommandName == "RemoveCriteria") { GridViewRow r = (GridViewRow)((ImageButton)e.CommandSource).Parent.Parent; SelectedRowIndex = r.RowIndex; IQID = UDFLib.ConvertToInteger(Request.QueryString["IQID"].ToString()); QID = UDFLib.ConvertToInteger(GridView_AssignedCriteria.DataKeys[SelectedRowIndex].Values[0].ToString()); RankID = UDFLib.ConvertToInteger(GridView_AssignedCriteria.DataKeys[SelectedRowIndex].Values[1].ToString()); BLL_Crew_Interview.Remove_QuestionFromInterview(QID, IQID, RankID, GetSessionUserID()); Bind_UnAssignedCriteria(); Bind_AssignedCriteria(); GridView_AssignedCriteria.SelectedIndex = SelectedRowIndex; } }
protected void GridView_Interview_RowUpdating(object sender, GridViewUpdateEventArgs e) { int IQID = UDFLib.ConvertToInteger(GridView_Interview.DataKeys[e.RowIndex].Values[0].ToString()); int RankID = UDFLib.ConvertToInteger(GridView_Interview.DataKeys[e.RowIndex].Values[1].ToString()); string Interview_Name = e.NewValues["Interview_Name"].ToString(); BLL_Crew_Interview.UPDATE_Interview(IQID, Interview_Name, RankID, GetSessionUserID()); GridView_Interview.EditIndex = -1; Bind_Interviews(); }
protected void btnSaveAndClose_Click(object sender, EventArgs e) { int ID = BLL_Crew_Interview.INSERT_Category(txtCatName.Text.Trim(), GetSessionUserID()); txtCatName.Text = ""; txtfilter.Text = ""; Load_CategoryList(); string js = "closeDiv('dvAddNewCategory');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); }
protected void GridView_Grading_RowUpdating(object sender, GridViewUpdateEventArgs e) { int ID = UDFLib.ConvertToInteger(GridView_Grading.DataKeys[e.RowIndex].Value.ToString()); string Grade_Name = e.NewValues["Grade_Name"].ToString(); int Grade_Type = UDFLib.ConvertToInteger(e.NewValues["Grade_Type"].ToString()); int Min = UDFLib.ConvertToInteger(e.NewValues["Min"].ToString()); int Max = UDFLib.ConvertToInteger(e.NewValues["Max"].ToString()); int Divisions = UDFLib.ConvertToInteger(e.NewValues["Divisions"].ToString()); BLL_Crew_Interview.UPDATE_Grading(ID, Grade_Name, Grade_Type, Min, Max, Divisions, GetSessionUserID()); GridView_Grading.EditIndex = -1; Load_GradingList(); }
protected void Bind_QuestionBank() { DataTable dt = BLL_Crew_Interview.Get_CriteriaList(txtfilter.Text, UDFLib.ConvertToInteger(ddlCategoryFilter.SelectedValue)); DataView dataView = new DataView(dt); if (ViewState["sortExpression"] != null) { dataView.Sort = ViewState["sortExpression"].ToString(); } GridView_Criteria.DataSource = dataView; GridView_Criteria.DataBind(); }
protected int Create_Interview() { int Ret = 1; string js = ""; int RankID = UDFLib.ConvertToInteger(ddlRank.SelectedValue); string InterviewType = ddlInterviewType.SelectedValue; if (txtInterview_Name.Text == "") { Ret = 0; js = "alert('Enter Interview Questionnaire Name.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); } else if (RankID == 0) { Ret = 0; js = "alert('Select Rank Name.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); } else if (InterviewType.Equals("0")) { Ret = 0; js = "alert('Select Interview Type.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); } else { Ret = 1; int CopyFrom = UDFLib.ConvertToInteger(ddlInterviewNames.SelectedValue); int IQID = BLL_Crew_Interview.INS_Interview(txtInterview_Name.Text.Trim(), RankID, CopyFrom, GetSessionUserID(), InterviewType); if (IQID > 0) { if (InterviewType == "Interview") { js = "alert('Interview Created.');"; } else { js = "alert('Briefing Created.');"; } ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); Bind_Interviews(); } } return(Ret); }
protected void Bind_AssignedCriteria() { try { int IQID = UDFLib.ConvertToInteger(Request.QueryString["IQID"].ToString()); int RankID = UDFLib.ConvertToInteger(Request.QueryString["RankID"].ToString()); DataTable dt = BLL_Crew_Interview.Get_InterviewQuestions(IQID, RankID); GridView_AssignedCriteria.DataSource = dt; GridView_AssignedCriteria.DataBind(); } catch { } }
protected void btnSaveGrade_Click(object sender, EventArgs e) { int ID = BLL_Crew_Interview.INSERT_Grading(txtGrade.Text.Trim(), UDFLib.ConvertToInteger(rdoGradeType.SelectedValue), UDFLib.ConvertToInteger(ddlMin.SelectedValue), UDFLib.ConvertToInteger(ddlMax.SelectedValue), UDFLib.ConvertToInteger(ddlDivisions.SelectedValue), GetSessionUserID()); txtGrade.Text = ""; for (int i = 0; i < rptOptions.Items.Count; i++) { TextBox txtValue = (TextBox)rptOptions.Items[i].FindControl("txtValue"); TextBox txtText = (TextBox)rptOptions.Items[i].FindControl("txtText"); if (txtText != null && txtValue != null) { BLL_Crew_Interview.INSERT_GradingOption(ID, txtText.Text.Trim(), UDFLib.ConvertToDecimal(txtValue.Text), GetSessionUserID()); } } Load_GradingList(); }
protected void Bind_Interviews() { DataTable dt = BLL_Crew_Interview.Get_Interviews(int.Parse(ddlRank1.SelectedValue), GetSessionUserID()); DataView dataView = new DataView(dt); if (ViewState["sortExpression"] != null) { dataView.Sort = ViewState["sortExpression"].ToString(); } GridView_Interview.DataSource = dataView; GridView_Interview.DataBind(); ddlInterviewNames.DataSource = dataView; ddlInterviewNames.DataBind(); }
protected void CalculateMarks(int InterviewID) { decimal UserMarks = 0; decimal FullMark = 0; decimal Avg = 0; string js = ""; DataSet dsQA = BLL_Crew_Interview.Get_InterviewQuestionAnswers(InterviewID, GetSessionUserID()); foreach (DataRow dr in dsQA.Tables[0].Rows) { if (UDFLib.ConvertToDecimal(dr["NotApplicable"].ToString()) == 0) { FullMark += UDFLib.ConvertToDecimal(dr["Max"].ToString()); UserMarks += UDFLib.ConvertToDecimal(dr["UserAnswer"].ToString()); if (FullMark > 0) { Avg = UserMarks / FullMark * 100; } } } lblMaxMarks.Text = FullMark.ToString(); lblUserMarks_P.Text = Avg.ToString("0.0"); lblUserMarks.Text = UserMarks.ToString("0.0"); if (FullMark > 0) { lblOutOf5.Text = (UserMarks / FullMark * 5).ToString("0.0"); if ((UserMarks / FullMark * 5) > 2) { js = "setDotColor('green');"; } else { js = "setDotColor('red');"; } } else { lblOutOf5.Text = "0.0"; js = "setDotColor('red');"; } ScriptManager.RegisterStartupScript(this, this.GetType(), "setDotColor_", js, true); }
protected void GridView_Grading_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { int ID = UDFLib.ConvertToInteger(GridView_Grading.DataKeys[e.Row.RowIndex].Value.ToString()); RadioButtonList rdo = (RadioButtonList)e.Row.FindControl("rdoOptions"); DataTable dt = BLL_Crew_Interview.Get_GradingOptions(ID); rdo.DataSource = dt; rdo.DataBind(); } } catch { } }
protected void Load_InterviewToEdit(int InterviewID) { DataTable dt = BLL_Crew_Interview.getInterviewDetails(InterviewID); try { frmInterviewDetails.DefaultMode = FormViewMode.Edit; frmInterviewDetails.DataSource = dt; frmInterviewDetails.DataBind(); if (dt.Rows.Count > 0) { (frmInterviewDetails.FindControl("ddlPlanM") as DropDownList).SelectedValue = UDFLib.ConvertToInteger(dt.Rows[0]["InterviewPlanM"]).ToString(); (frmInterviewDetails.FindControl("ddlPlanInterviewer") as DropDownList).SelectedValue = UDFLib.ConvertToInteger(dt.Rows[0]["PlannedInterviewerID"]).ToString(); LoadInterviewSheet(int.Parse((dt.Rows[0]["RankID"]).ToString())); (frmInterviewDetails.FindControl("ddlInterviewSheet") as DropDownList).SelectedValue = UDFLib.ConvertToInteger(dt.Rows[0]["IQID"]).ToString(); BLL_Infra_TimeZones objTimeZone = new BLL_Infra_TimeZones(); DataTable dt2 = objTimeZone.Get_TimeZoneList(); (frmInterviewDetails.FindControl("ddlTimeZone") as DropDownList).DataSource = dt2; (frmInterviewDetails.FindControl("ddlTimeZone") as DropDownList).DataTextField = "DisplayName"; (frmInterviewDetails.FindControl("ddlTimeZone") as DropDownList).DataValueField = "TimeZone"; (frmInterviewDetails.FindControl("ddlTimeZone") as DropDownList).DataBind(); if (Convert.ToString(dt.Rows[0]["TimeZone"]) != "") { (frmInterviewDetails.FindControl("ddlTimeZone") as DropDownList).SelectedValue = Convert.ToString(dt.Rows[0]["TimeZone"]); } else { DataRow[] dr = dt2.Select("DefaultTimeZone=1"); if (dr.Length > 0) { (frmInterviewDetails.FindControl("ddlTimeZone") as DropDownList).SelectedValue = dr[0]["TimeZone"].ToString(); } } } } catch { } }
protected void lnkAddToInterview_Click(object sender, EventArgs e) { int IQID = UDFLib.ConvertToInteger(Request.QueryString["IQID"].ToString()); int RankID = UDFLib.ConvertToInteger(Request.QueryString["RankID"].ToString()); foreach (GridViewRow row in GridView_UnAssignedCriteria.Rows) { CheckBox chkSelect = (CheckBox)row.FindControl("chkSelect"); int QID = UDFLib.ConvertToInteger(GridView_UnAssignedCriteria.DataKeys[row.RowIndex].Value.ToString()); if (chkSelect != null) { if (chkSelect.Checked == true) { BLL_Crew_Interview.Add_QuestionToInterview(QID, RankID, IQID, GetSessionUserID()); } } } Bind_AssignedCriteria(); Bind_UnAssignedCriteria(); }
protected int Create_Interview_Criteria() { int Ret = 1; string js = ""; if (txtCriteria.Text == "") { js = "alert('Enter Question');"; } else if (ddlCategory.SelectedValue == "0") { js = "alert('Select Category');"; } else if (ddlType.SelectedValue == "0") { js = "alert('Select question type');"; } else if (ddlGradingType.SelectedValue == "0") { js = "alert('Select grading type');"; } if (js == "") { Ret = BLL_Crew_Interview.INSERT_Criteria(txtCriteria.Text.Trim(), txtAnswer.Text.Trim(), UDFLib.ConvertToInteger(ddlType.SelectedValue), UDFLib.ConvertToInteger(ddlCategory.SelectedValue), UDFLib.ConvertToInteger(ddlGradingType.SelectedValue), GetSessionUserID()); if (Ret > 0) { txtCriteria.Text = ""; txtAnswer.Text = ""; js = "alert('Interview criteria added');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); } } else { Ret = 0; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", js, true); } return(Ret); }
protected void GridView_AssignedCriteria_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { int iQuestionID = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "QID").ToString()); int Grading_Type = UDFLib.ConvertToInteger(DataBinder.Eval(e.Row.DataItem, "Grading_Type").ToString()); // int iRankID = UDFLib.ConvertToInteger(ddlRank.SelectedValue); int iInterviewID = int.Parse(hdnInterviewID.Value); int iCrewID = GetCrewID(); int iUserID = GetSessionUserID(); string SelectedOptionID; RadioButtonList rdo = (RadioButtonList)e.Row.FindControl("rdoOptions"); if (rdo != null) { DataTable dt = BLL_Crew_Interview.Get_GradingOptions(Grading_Type); rdo.DataSource = dt; rdo.DataBind(); if (DataBinder.Eval(e.Row.DataItem, "SelectedOptionID") != null) { SelectedOptionID = DataBinder.Eval(e.Row.DataItem, "SelectedOptionID").ToString(); if (SelectedOptionID != "") { e.Row.CssClass = "crew-interview-grid-selected-row"; Select_Option(rdo, SelectedOptionID); } } } } } catch { } }