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 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 Page_Load(object sender, EventArgs e) { calFrom.Format = Convert.ToString(Session["User_DateFormat"]); if (!IsPostBack) { UserAccessValidation(); string InterviewPlannedDate = ""; int InterviewID = 0; int iUserID = GetSessionUserID(); Load_RankList(); if (getQueryString("ID") != "") { InterviewID = int.Parse(getQueryString("ID")); DataTable dt = BLL_Crew_Interview.getInterviewDetails(InterviewID); if (dt.Rows.Count > 0) { pnlEdit_InterviewResult.Visible = true; hdnInterviewID.Value = InterviewID.ToString(); hdnCrewID.Value = dt.Rows[0]["CrewID"].ToString(); int iCrewID = int.Parse(dt.Rows[0]["CrewID"].ToString()); InterviewPlannedDate = dt.Rows[0]["InterviewPlanDate"].ToString(); lnkOpenProfile.NavigateUrl = "CrewDetails.aspx?ID=" + iCrewID; lblPlannedInterviewer.Text = dt.Rows[0]["PlannedInterviewer"].ToString(); lblPlannedDate.Text = UDFLib.ConvertUserDateFormatTime(Convert.ToString(dt.Rows[0]["InterviewPlanDate"])); lblPlannedBy.Text = dt.Rows[0]["PlannedBy"].ToString(); lblPlannedTimeZone.Text = dt.Rows[0]["DisplayName"].ToString(); txtPersonInterviewed.Text = dt.Rows[0]["CandidateName"].ToString(); txtPersonInterviewed.Enabled = false; if (dt.Rows[0]["InterviewDate"].ToString().Trim() != "") { txtInterviewDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[0]["InterviewDate"])); } else { txtInterviewDate.Text = DateTime.Today.ToString(Convert.ToString(Session["User_DateFormat"])); } txtInterviewDate.Enabled = false; if (dt.Rows[0]["RANKID"].ToString() != "") { ddlRank.SelectedValue = dt.Rows[0]["RANKID"].ToString(); ddlRank.Enabled = false; } txtStaffCode.Text = dt.Rows[0]["staff_code"].ToString(); if (dt.Rows[0]["Interviewer"].ToString().Trim() != "") { ddlUserList.Items.Clear(); ddlUserList.Items.Add(new ListItem(dt.Rows[0]["Interviewer"].ToString(), dt.Rows[0]["InterviewerID"].ToString())); ddlUserList.SelectedIndex = 0; btnSaveInterviewResult.Enabled = false; } else { ddlUserList.DataBind(); ddlUserList.SelectedValue = GetSessionUserID().ToString(); btnSaveInterviewResult.Enabled = true; } ddlUserList.Enabled = false; lblPlannedDate.Text = UDFLib.ConvertUserDateFormatTime(Convert.ToString(dt.Rows[0]["InterviewPlanDate"])); lblPlannedBy.Text = dt.Rows[0]["PlannedBy"].ToString(); // int IQID = UDFLib.ConvertToInteger(dt.Rows[0]["IQID"]); DataSet dsQA = BLL_Crew_Interview.Get_InterviewQuestionAnswers(InterviewID, GetSessionUserID()); GridView_AssignedCriteria.DataSource = dsQA.Tables[0]; GridView_AssignedCriteria.DataBind(); } } else { int CrewID = GetCrewID(); DataTable dtCD = objCrewBLL.Get_CrewPersonalDetailsByID(CrewID); if (dtCD.Rows.Count > 0) { txtInterviewDate.Text = DateTime.Today.ToString(Convert.ToString(Session["User_DateFormat"])); txtInterviewDate.Enabled = false; //ddlRank.Text = dtCD.Rows[0]["Rank_Applied"].ToString(); pnlEdit_InterviewResult.Visible = false; lblMessage.Text = "Interview is not yet planned for the crew. Please fill the interview plan"; } else { Response.Redirect("Crewlist.aspx"); } } } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser1", "initScript();", true); }
protected void Page_Load(object sender, EventArgs e) { calFrom.Format = Convert.ToString(Session["User_DateFormat"]); if (!IsPostBack) { UserAccessValidation(); string InterviewPlannedDate = ""; int InterviewID = 0; int iUserID = GetSessionUserID(); Load_RankList(); Load_VesselList(); if (getQueryString("ID") != "") { InterviewID = int.Parse(getQueryString("ID")); DataTable dt = BLL_Crew_Interview.getInterviewDetails(InterviewID); if (dt.Rows.Count > 0) { pnlInterviewPlanning.Visible = false; pnlEdit_InterviewResult.Visible = true; hdnInterviewID.Value = InterviewID.ToString(); hdnCrewID.Value = dt.Rows[0]["CrewID"].ToString(); int iCrewID = int.Parse(dt.Rows[0]["CrewID"].ToString()); InterviewPlannedDate = dt.Rows[0]["InterviewPlanDate"].ToString(); lnkOpenProfile.NavigateUrl = "CrewDetails.aspx?ID=" + iCrewID; lblPlannedInterviewer.Text = dt.Rows[0]["PlannedInterviewer"].ToString(); lblPlannedDate.Text = UDFLib.ConvertUserDateFormatTime(Convert.ToString(dt.Rows[0]["InterviewPlanDate"])); lblPlannedBy.Text = dt.Rows[0]["PlannedBy"].ToString(); lblPlannedTimeZone.Text = dt.Rows[0]["DisplayName"].ToString(); txtPersonInterviewed.Text = dt.Rows[0]["CandidateName"].ToString(); txtPersonInterviewed.Enabled = false; if (dt.Rows[0]["InterviewDate"].ToString().Trim() != "") { txtInterviewDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[0]["InterviewDate"])); lblInterviewDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(dt.Rows[0]["InterviewDate"])); } else { txtInterviewDate.Text = DateTime.Today.ToString(Convert.ToString(Session["User_DateFormat"])); } txtInterviewDate.Enabled = false; if (dt.Rows[0]["RANKID"].ToString() != "") { txtInterviewRank.Text = dt.Rows[0]["Rank_Short_Name"].ToString(); ddlRank.SelectedValue = dt.Rows[0]["RANKID"].ToString(); ddlRank.Enabled = false; } txtStaffCode.Text = dt.Rows[0]["staff_code"].ToString(); if (dt.Rows[0]["Interviewer"].ToString().Trim() != "") { ddlUserList.Items.Clear(); ddlUserList.Items.Add(new ListItem(dt.Rows[0]["Interviewer"].ToString(), dt.Rows[0]["InterviewerID"].ToString())); ddlUserList.SelectedIndex = 0; btnSaveInterviewResult.Enabled = false; lnkEditSchedule.Visible = false; } else { ddlUserList.DataBind(); ddlUserList.SelectedValue = GetSessionUserID().ToString(); btnSaveInterviewResult.Enabled = true; lnkEditSchedule.Visible = true; lnkEditSchedule.Attributes.Add("onclick", "EditInterviewSchedule('CrewInterview.aspx'," + InterviewID.ToString() + "); return false;"); } ddlUserList.Enabled = false; lblInterviewSheet_Name.Text = dt.Rows[0]["Interview_Name"].ToString(); txtPlanInterviewerPosition.Text = dt.Rows[0]["Designation"].ToString(); lblPlannedDate.Text = UDFLib.ConvertUserDateFormatTime(Convert.ToString(dt.Rows[0]["InterviewPlanDate"])); lblPlannedBy.Text = dt.Rows[0]["PlannedBy"].ToString(); rdoSelected.SelectedValue = dt.Rows[0]["Result"].ToString(); txtResultText.Text = dt.Rows[0]["ResultText"].ToString(); int IQID = UDFLib.ConvertToInteger(dt.Rows[0]["IQID"]); int RankID = UDFLib.ConvertToInteger(dt.Rows[0]["RankID"]); DataSet dsQA = BLL_Crew_Interview.Get_InterviewQuestionAnswers(InterviewID, GetSessionUserID()); GridView_AssignedCriteria.DataSource = dsQA.Tables[0]; GridView_AssignedCriteria.DataBind(); if (dsQA.Tables[1].Rows.Count > 0) { foreach (DataRow dr in dsQA.Tables[1].Rows) { for (var i = 1; i < lstVessels.Items.Count; i++) { if (lstVessels.Items[i].Value == dr["vesselid"].ToString()) { lstVessels.Items[i].Selected = true; } } } } if (dsQA.Tables[1].Rows.Count > 0) { foreach (DataRow dr in dsQA.Tables[2].Rows) { for (var i = 0; i < chkTradingArea.Items.Count; i++) { if (chkTradingArea.Items[i].Value == dr["zoneid"].ToString()) { chkTradingArea.Items[i].Selected = true; } } } } CalculateMarks(InterviewID); } else { pnlInterviewPlanning.Visible = true; pnlEdit_InterviewResult.Visible = false; int CrewID = GetCrewID(); DataTable dtCrew = objCrewBLL.Get_CrewPersonalDetailsByID(CrewID); if (dtCrew.Rows.Count > 0) { txtPlanCrewName.Text = dtCrew.Rows[0]["staff_fullname"].ToString(); txtPlanCrewName.Enabled = false; txtInterviewDate.Text = DateTime.Today.ToString("dd/MM/yyyy"); txtInterviewDate.Enabled = false; ddlPlanRank.Text = dtCrew.Rows[0]["Rank_Applied"].ToString(); ddlRank.Text = dtCrew.Rows[0]["Rank_Applied"].ToString(); pnlInterviewPlanning.Visible = true; pnlEdit_InterviewResult.Visible = false; lblMessage.Text = "Interview is not yet planned for the crew. Please fill the interview plan"; } } } else { int CrewID = GetCrewID(); DataTable dtCD = objCrewBLL.Get_CrewPersonalDetailsByID(CrewID); if (dtCD.Rows.Count > 0) { txtPlanCrewName.Text = dtCD.Rows[0]["staff_fullname"].ToString(); txtPlanCrewName.Enabled = false; txtInterviewDate.Text = DateTime.Today.ToString("dd/MM/yyyy"); txtInterviewDate.Enabled = false; ddlPlanRank.Text = dtCD.Rows[0]["Rank_Applied"].ToString(); ddlRank.Text = dtCD.Rows[0]["Rank_Applied"].ToString(); pnlInterviewPlanning.Visible = true; pnlEdit_InterviewResult.Visible = false; lblMessage.Text = "Interview is not yet planned for the crew. Please fill the interview plan"; } else { Response.Redirect("Crewlist.aspx"); } } } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser1", "initScript();", true); }