/// <summary>
/// Method to export KPI values to Excel file
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnExport_Click(object sender, ImageClickEventArgs e)
{
try
{
if (checkVoyage.Checked == false)
{
if (txtStartDate.Text != "")
{
Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text));
}
if (txtEndDate.Text != "")
{
EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text));
}
DataTable dt = BLL_TMSA_PI.Search_PI_Values(Convert.ToInt32(ddlvessel.SelectedValue), KPI_ID, Convert.ToDateTime(txtStartDate.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(txtEndDate.Text).ToString("yyyy-MM-dd")).Tables[0];
string[] HeaderCaptions = { "Record Date", "EEOI Value" };
string[] DataColumnsName = { "Record_Date_Str", "Value" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "CO2 Efficiency-" + ddlvessel.SelectedItem.Text, "CO2 Efficiency-" + ddlvessel.SelectedItem.Text);
}
else
{
DataTable liTable = new DataTable();
if (listVoyage.Items.Count > 0)
{
for (int x = 0; x < listVoyage.Items.Count; x++)
{
//string v1 = listVoyage.Items[0].Value.Split(':')[1].Trim();
//string v2 = listVoyage.Items[listVoyage.Items.Count - 1].Value.Split(':')[0].Trim();
string val = listVoyage.Items[x].Value.Split(':')[0] + ":" + listVoyage.Items[x].Value.Split(':')[1];
DataTable dtq = BLL_TMSA_PI.GetTelDate(val.Trim(), Convert.ToInt32(ddlvessel.SelectedValue)).Tables[0];
if (dtq.Rows[0]["Telegram_Date_DDMM"].ToString() != "")
{
Startdate = Convert.ToDateTime(dtq.Rows[0]["Telegram_Date_DDMM"].ToString());
}
if (dtq.Rows[dtq.Rows.Count - 1]["Telegram_Date_DDMM"].ToString() != "")
{
EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1]["Telegram_Date_DDMM"].ToString());
}
DataTable dt = BLL_TMSA_PI.GetVoyageData(listVoyage.Items[x].Value.Trim(), Convert.ToInt32(ddlvessel.SelectedValue), KPI_ID).Tables[0];
liTable.Merge(dt);
}
string[] HeaderCaptions = { "From Port", "To Port", "Departure Date", "Arrival Date", "Average" };
string[] DataColumnsName = { "FromPort", "ToPort", "EffectiveFrom", "EffectiveTo", "Value" };
GridViewExportUtil.ExportToExcel(liTable, HeaderCaptions, DataColumnsName, "CO2 Efficiency-" + ddlvessel.SelectedItem.Text, "CO2 Efficiency(Voyage)-" + ddlvessel.SelectedItem.Text);
}
}
}
catch (Exception ex)
{ }
}
protected void bindgvSearch()
{
try
{
if (txtStartDate.Text != "")
{
Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text));
}
if (txtEndDate.Text != "")
{
EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text));
}
DataTable dtt = objEEDIBLL.Get_EEDI(Convert.ToInt32(ddlvessel.SelectedValue));
if (dtt.Rows.Count != 0)
{
txtEEDI.Text = Math.Round(Convert.ToDecimal(dtt.Rows[0]["EEDI_Value"].ToString()), 2).ToString();
}
else
{
txtEEDI.Text = "0";
}
DataTable dt = objKPI.GetGoal(Convert.ToInt32(ddlvessel.SelectedValue), "KPI005", 0);
if (dt.Rows.Count > 0)
{
txtGoal.Text = Math.Round(Convert.ToDecimal(dt.Rows[0]["Goal"].ToString()), 2).ToString();
}
else
{
txtGoal.Text = "0.00";
}
DataTable dt2 = BLL_TMSA_PI.Search_PI_Values(Convert.ToInt32(ddlvessel.SelectedValue), KPI_ID, Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)).ToString("yyyy-MM-dd"), Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)).ToString("yyyy-MM-dd")).Tables[0];
if (dt2 == null || dt2.Rows.Count == 0)
{
btnChart.Visible = false;
btnExport.Visible = false;
}
gvSearch.DataSource = dt2;
gvSearch.DataBind();
if (dt2.Rows.Count != 0)
{
double AVG = Convert.ToDouble(dt2.Compute("AVG(Value)", "").ToString());
hiddenAVG.Value = Math.Round(AVG, 2).ToString();
gvSearch.FooterRow.Cells[1].Text = "Average: " + Math.Round(AVG, 2).ToString();
gvSearch.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Center;
gvSearch.FooterRow.Cells[1].ForeColor = System.Drawing.Color.Black;
gvSearch.FooterRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#abcdef");
gvSearch.FooterRow.Cells[1].BorderColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
gvSearch.FooterRow.Cells[0].BorderColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
// txtGoal.Text = ds.Tables[1].Rows[0]["Goal"].ToString();
//btnChart.Visible = true;
hiddengdCount.Value = "1";
btnExport.Visible = true;
divChart.Visible = true;
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", "showChart();", true);
}
else
{
hiddengdCount.Value = "0";
btnChart.Visible = false;
}
}
catch (Exception ex) {
UDFLib.WriteExceptionLog(ex);
}
}
