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