protected void Bind_EvaluationResult() { int CrewID = UDFLib.ConvertToInteger(Request.QueryString["CrewID"].ToString()); int Evaluation_ID = UDFLib.ConvertToInteger(Request.QueryString["EID"].ToString()); int Month = UDFLib.ConvertToInteger(Request.QueryString["M"].ToString()); int Dtl_Evaluation_ID = UDFLib.ConvertToInteger(Request.QueryString["DtlID"].ToString()); DataTable dt = BLL_Crew_Evaluation.Get_CrewEvaluation_Details(CrewID, Dtl_Evaluation_ID);; DataView dataView = new DataView(dt); if (ViewState["sortExpression"] != null) { dataView.Sort = ViewState["sortExpression"].ToString(); } GridView_AssignedCriteria.DataSource = dataView; GridView_AssignedCriteria.DataBind(); if (dt.Rows.Count > 0) { hdnOffice_ID.Value = dt.Rows[0]["Office_ID"].ToString(); hdnVessel_ID.Value = dt.Rows[0]["Vessel_ID"].ToString(); string rank = dt.Rows[0]["Rank_Short_Name"].ToString() == "" ? "" : dt.Rows[0]["Rank_Short_Name"].ToString() + "-"; string staffCode = dt.Rows[0]["Staff_Code"].ToString() == "" ? "" : dt.Rows[0]["Staff_Code"].ToString() + "-"; lnkEvaluator.Text = rank + staffCode + dt.Rows[0]["Evaluator"].ToString(); lnkEvaluator.NavigateUrl = "~/Crew/CrewDetails.aspx?ID=" + dt.Rows[0]["Evaluator_CrewDtlID"].ToString(); txtEvaDate.Text = Convert.ToDateTime(dt.Rows[0]["Evaluation_Date"].ToString()).ToString(Convert.ToString(Session["User_DateFormat"])); txtEvaDate.Enabled = false; EvalLibRank = rank; Evaluator_CrewDtlID = dt.Rows[0]["Evaluator_CrewDtlID"].ToString(); } }
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 Bind_AssignedCriteria() { int Evaluation_ID = UDFLib.ConvertToInteger(Request.QueryString["EID"].ToString()); DataTable dt = BLL_Crew_Evaluation.Get_Assigned_CriteriaList(Evaluation_ID, "", 0); DataView dataView = new DataView(dt); if (ViewState["sortExpression"] != null) { dataView.Sort = ViewState["sortExpression"].ToString(); } GridView_AssignedCriteria.DataSource = dataView; GridView_AssignedCriteria.DataBind(); }
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 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); }