public void BindHandOver()
{
int PAGE_SIZE = ucCustomPager.PageSize;
int PAGE_INDEX = ucCustomPager.CurrentPageIndex;
int SelectRecordCount = ucCustomPager.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataSet ds = BLL_Crew_CrewList.Get_HandOverDetail_Search(int.Parse(Request.QueryString["ID"].ToString()), int.Parse(Request.QueryString["VESSELID"].ToString()), txtSearchText.Text, sortbycoloumn, sortdirection, PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
txtVesselName.Text = dr["Vessel_Name"].ToString();
txtStaffCode.Text = dr["STAFF_CODE"].ToString();
txtStaffName.Text = dr["FULL_NAME"].ToString();
txtStaffRank.Text = dr["Rank_Name"].ToString();
txtRelievingMasterRemark.Text = dr["Sing_off_Remarks"].ToString();
txtRelievedMasterRemark.Text = dr["Relieved_Master_Remark"].ToString();
if (dr["Joining_Rank"].ToString() != "1")
{
CheckList.Visible = false;
}
if (dr["HANDOVER_DATE"] != null)
{
txtHandOverDate.Text = UDFLib.ConvertUserDateFormat(Convert.ToString(dr["HANDOVER_DATE"]));
}
lbltxtRelievingMasterRemark.Text = "Relieving " + txtStaffRank.Text + "'s Remarks :";
lbltxtRelievedMasterRemark.Text = "Relieved " + txtStaffRank.Text + "'s Remarks :";
}
gvHandOver.DataSource = ds.Tables[1];
gvHandOver.DataBind();
if (ucCustomPager.isCountRecord == 1)
{
ucCustomPager.CountTotalRec = SelectRecordCount.ToString();
ucCustomPager.BuildPager();
}
}
