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