/// <summary>
/// Method to export data to excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_Click(object sender, ImageClickEventArgs e)
{
try
{
int rowcount = ucCustomPager1.isCountRecord;
string PIName = "PI Name: ";
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);
}
if (ViewState["PI_Name"] != null)
{
PIName = PIName + ViewState["PI_Name"].ToString();
}
DataTable dt = BLL_TMSA_PI.Get_Vessel_Values(Convert.ToInt32(ddlVessel.SelectedValue), dtWEF, dtWET, PI_ID, null, null, ref rowcount).Tables[0];
string[] HeaderCaptions = { "Vessel", "Effect From", "Effect To", "PI Value", "Created ON" };
string[] DataColumnsName = { "Vessel_Name", "Effective_From", "Effective_To", "Value", "Date_Of_Creation" };
GridViewExportUtil.ExportToExcel(dt, HeaderCaptions, DataColumnsName, PIName, PIName);
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
protected void LoadSearchResults()
{
rgdItems.Visible = false;
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)
{
DataTable dt = BLL_TMSA_PI.Get_Vessel_Values(Convert.ToInt32(ddlVessel.SelectedValue), dtWEF, dtWET, PI_ID, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount).Tables[0];
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
dt.DefaultView.Sort = "Effective_From DESC";
gvPIList.DataSource = dt;
gvPIList.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 (ddlVessel.SelectedValue != "0" && ddlVessel.SelectedValue != "")
{
dt = BLL_TMSA_PI.Get_Vessel_Values(Convert.ToInt32(ddlVessel.SelectedValue), dtWEF, dtWET, PI_ID, ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount).Tables[0];
}
else
{
dt = BLL_TMSA_PI.Get_Vessel_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();
}
gvPIList.DataSource = dt;
gvPIList.DataBind();
}
}
