/// <summary>
/// Method to search retention PI Values by Rank
/// </summary>
protected void LoadSearchResults()
{
int rowcount = ucCustomPager1.isCountRecord;
PI_ID = Convert.ToInt32(Request.QueryString["PI_ID"]);
DateTime?dtWEF = null;
DateTime?dtWET = null;
if (txtSearchFrom.Text != "")
{
dtWEF = Convert.ToDateTime(txtSearchFrom.Text);
}
if (txtSearchTo.Text != "")
{
dtWET = Convert.ToDateTime(txtSearchTo.Text);
}
//DataTable dt = BLL_TMSA_PI.Get_Vessel_Values(Convert.ToInt32(ddlVessel.SelectedValue), dtWEF, dtWET).Tables[0];
if (txtSearchFrom.Text != "" && txtSearchTo.Text != "")
{
if (dtWEF <= dtWET)
{
DataSet ds = BLL_TMSA_PI.Get_RankWise_Values(Convert.ToInt32(ddlRank.SelectedValue), dtWEF, dtWET, PI_ID, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount);
DataTable dt = ds.Tables[0];
string PI_Code = ds.Tables[1].Rows[0]["code"].ToString();
if (ltPageHeader.Text.Contains(PI_Code))
{
ltPageHeader.Text = ltPageHeader.Text;
}
else
{
ltPageHeader.Text = ltPageHeader.Text + "[" + PI_Code + "]";
}
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
dt.DefaultView.Sort = "Effective_From DESC";
gvPIDetails.DataSource = dt;
gvPIDetails.DataBind();
}
else
{
string msg2 = String.Format("alert('From Date should not be greater than to date')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg2, true);
}
}
else
{
DataTable dt = new DataTable();
if (ddlRank.SelectedValue != "0" && ddlRank.SelectedValue != "")
{
dt = BLL_TMSA_PI.Get_RankWise_Values(Convert.ToInt32(ddlRank.SelectedValue), dtWEF, dtWET, PI_ID, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount).Tables[0];
}
else
{
dt = BLL_TMSA_PI.Get_RankWise_Values(null, dtWEF, dtWET, PI_ID, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount).Tables[0];
}
if (ucCustomPager1.isCountRecord == 1)
{
dt.DefaultView.Sort = "Effective_From DESC";
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
gvPIDetails.DataSource = dt;
gvPIDetails.DataBind();
}
}