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);
}
