protected void Search_UnAssigned() { lblStaffHistory.Text = ""; int PAGE_SIZE = ucCustomPager_OnSigners.PageSize; int PAGE_INDEX = ucCustomPager_OnSigners.CurrentPageIndex; int SelectRecordCount = ucCustomPager_OnSigners.isCountRecord; DataTable dt = BLL_Crew_CrewList.Get_UnAssigned_CrewList(int.Parse(ddlManningOffice.SelectedValue), int.Parse(ddlNationality.SelectedValue), int.Parse(ddlRank_UA.SelectedValue), UDFLib.ConvertToDefaultDt(Convert.ToString(txtFromDt_UA.Text)), UDFLib.ConvertToDefaultDt(Convert.ToString(txtToDt_UA.Text)), txtFreeText_UA.Text, int.Parse(ddlVessel_UA.SelectedValue), int.Parse(UA_AvailableOptions.SelectedValue), GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount); if (ucCustomPager_OnSigners.isCountRecord == 1) { ucCustomPager_OnSigners.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_OnSigners.BuildPager(); } gvUnAssignedCrew.DataSource = dt; gvUnAssignedCrew.DataBind(); if (Session["UTYPE"].ToString() == "ADMIN") { if (dt.Rows.Count == 0) { dt = BLL_Crew_CrewList.Get_UnAssigned_CrewList_History(txtFreeText_UA.Text, UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString())); if (dt.Rows.Count > 0) { lblStaffHistory.Text = "<br><br>Please find the below information which can help finding the staff.<br>"; foreach (DataRow dr in dt.Rows) { lblStaffHistory.Text += "<br>" + dr[0]; } } } } }
/// <summary> /// Fill the grid with Unassigned Crews according to filter /// </summary> protected void Search_UnAssigned() { try { int PAGE_SIZE = ucCustomPager_UnAssignedCrew.PageSize; int PAGE_INDEX = ucCustomPager_UnAssignedCrew.CurrentPageIndex; int SelectRecordCount = ucCustomPager_UnAssignedCrew.isCountRecord; int VesselId_OffSignner = int.Parse(ddlVessel_UA.SelectedValue.ToString()); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } //selected Vessel Type int i = 1; DataTable dtVesselTypes = new DataTable(); dtVesselTypes.Columns.Add("PID"); dtVesselTypes.Columns.Add("VALUE"); foreach (DataRow dr in ddlVesselType.SelectedValues.Rows) { DataRow dr1 = dtVesselTypes.NewRow(); dr1["PID"] = i; dr1["VALUE"] = dr[0]; dtVesselTypes.Rows.Add(dr1); i++; } DataTable dt = BLL_Crew_CrewList.Get_UnAssigned_CrewList(int.Parse(ddlManningOffice.SelectedValue), int.Parse(ddlNationality.SelectedValue), int.Parse(ddlRank_UA.SelectedValue), txtFromDt_UA.Text.Trim() == "" ? "" : UDFLib.ConvertToDate(txtFromDt_UA.Text).ToShortDateString(), txtToDt_UA.Text.Trim() == "" ? "" : UDFLib.ConvertToDate(txtToDt_UA.Text).ToShortDateString(), txtFreeText_UA.Text, int.Parse(ddlVessel_UA.SelectedValue), VesselId_OffSignner, int.Parse(UA_AvailableOptions.SelectedValue), GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection, int.Parse(ddlMinYearOperator.SelectedValue), int.Parse(ddlMinYearsRank.SelectedValue), int.Parse(ddlMinYearsAllTankers.SelectedValue), dtVesselTypes); if (ucCustomPager_UnAssignedCrew.isCountRecord == 1) { ucCustomPager_UnAssignedCrew.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_UnAssignedCrew.BuildPager(); } gvUnAssignedCrew.DataSource = dt; gvUnAssignedCrew.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "SaveAddError", "BindHeight();", true); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void Search_UnAssigned() { try { lblStaffHistory.Text = ""; int PAGE_SIZE = ucCustomPager_OnSigners.PageSize; int PAGE_INDEX = ucCustomPager_OnSigners.CurrentPageIndex; int SelectRecordCount = ucCustomPager_OnSigners.isCountRecord; int VesselId_OffSignner = int.Parse(lblVesselIdOffsigner.Text); string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } //selected Vessel Type int i = 1; DataTable dtVesselTypes = new DataTable(); dtVesselTypes.Columns.Add("PID"); dtVesselTypes.Columns.Add("VALUE"); foreach (DataRow dr in ddlVesselType.SelectedValues.Rows) { DataRow dr1 = dtVesselTypes.NewRow(); dr1["PID"] = i; dr1["VALUE"] = dr[0]; dtVesselTypes.Rows.Add(dr1); i++; } DataTable dt = BLL_Crew_CrewList.Get_UnAssigned_CrewList(int.Parse(ddlManningOffice.SelectedValue), int.Parse(ddlNationality.SelectedValue), int.Parse(ddlRank_UA.SelectedValue), UDFLib.ConvertToDefaultDt(txtFromDt_UA.Text), UDFLib.ConvertToDefaultDt(txtToDt_UA.Text), txtFreeText_UA.Text, int.Parse(ddlVessel_UA.SelectedValue), VesselId_OffSignner, int.Parse(UA_AvailableOptions.SelectedValue), GetSessionUserID(), dtVesselTypes, PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection); if (ucCustomPager_OnSigners.isCountRecord == 1) { ucCustomPager_OnSigners.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_OnSigners.BuildPager(); } gvUnAssignedCrew.DataSource = dt; gvUnAssignedCrew.DataBind(); if (Session["UTYPE"].ToString() == "ADMIN") { if (dt.Rows.Count == 0) { dt = BLL_Crew_CrewList.Get_UnAssigned_CrewList_History(txtFreeText_UA.Text, UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString())); if (dt.Rows.Count > 0) { lblStaffHistory.Text = "<br><br>Please find the below information which can help finding the staff.<br>"; foreach (DataRow dr in dt.Rows) { lblStaffHistory.Text += "<br>" + dr[0]; } } } } } catch (Exception ex) { string js3 = "alert('" + ex.Message.Replace("'", "") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "SaveAddError", js3, true); } }