/// <summary>
/// Description: If by voyage is selected , for all vessels voyage ddl wil populate based on search date
/// </summary>
protected void ddlVoyage_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DateTime?Startdate = null;
//Startdate = Convert.ToDateTime(txtStartDate.Text);
Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text));
DateTime?EndDate = null;
//EndDate = Convert.ToDateTime(txtEndDate.Text);
EndDate = Convert.ToDateTime(UDFLib.ConvertToDate(txtEndDate.Text));
DropDownList ddlVoyage = (DropDownList)sender;
GridDataItem item = (GridDataItem)ddlVoyage.NamingContainer;
Label txtSrno = (Label)item.FindControl("Vessel_Average");
HiddenField hdf = (HiddenField)item.FindControl("hdVesselID");
LinkButton lnkVessel = (LinkButton)item.FindControl("Item_Name");
if (ddlVoyage.SelectedIndex != 0)
{
string val = ddlVoyage.SelectedValue.Trim().Split(':')[0] + ":" + ddlVoyage.SelectedValue.Trim().Split(':')[1];
DataTable dtq = BLL_TMSA_PI.GetTelDate(val.Trim(), Convert.ToInt32(hdf.Value)).Tables[0];
if (dtq.Rows[0][0].ToString() != "")
{
Startdate = Convert.ToDateTime(dtq.Rows[0][1].ToString());
hiddenStartDate.Value = Startdate.Value.Date.ToString("dd-MM-yyyy");
}
if (dtq.Rows[dtq.Rows.Count - 1][0].ToString() != "")
{
EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1][1].ToString());
hiddenEndDate.Value = EndDate.Value.Date.ToString("dd-MM-yyyy");
}
}
DataTable dt = BLL_TMSA_PI.GetVoyageDataNOx(ddlVoyage.SelectedValue.Trim(), Convert.ToInt32(hdf.Value)).Tables[0];
if (dt.Rows.Count > 0)
{
txtSrno.Text = Math.Round(Convert.ToDouble(dt.Rows[0]["Value"].ToString()), 2).ToString();
if (Convert.ToDouble(dt.Rows[0]["Value"]) == 0)
{
lnkVessel.Enabled = false;
item["Vessel"].BackColor = System.Drawing.Color.White;
}
else
{
lnkVessel.Enabled = true;
}
}
else
{
txtSrno.Text = "0";
lnkVessel.Enabled = false;
item["Vessel"].BackColor = System.Drawing.Color.White;
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
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_ValuesNOX(Convert.ToInt32(ddlvessel.SelectedValue), Convert.ToDateTime(txtStartDate.Text).ToString("yyyy-MM-dd"), Convert.ToDateTime(txtEndDate.Text).ToString("yyyy-MM-dd")).Tables[0];
string[] HeaderCaptions = { "Record_Date", "Value" };
string[] DataColumnsName = { "Record_Date", "Value" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "NOX Effeciency-" + ddlvessel.SelectedItem.Text, "NOX Effeciency-" + 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.GetVoyageDataNOx(listVoyage.Items[x].Value.Trim(), Convert.ToInt32(ddlvessel.SelectedValue)).Tables[0];
liTable.Merge(dt);
}
string[] HeaderCaptions = { "From Port", "To Port", "Effective From", "Effective To", "Efficiency" };
string[] DataColumnsName = { "FromPort", "ToPort", "EffectiveFrom", "EffectiveTo", "Value" };
GridViewExportUtil.ExportToExcel(liTable, HeaderCaptions, DataColumnsName, "NOX Effeciency-" + ddlvessel.SelectedItem.Text, "NOX Effeciency(Voyage)-" + ddlvessel.SelectedItem.Text);
}
}
}
catch (Exception ex)
{ }
}
protected void BindVoyageData()
{
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);
}
gvVoyage.Visible = true;
gvSearch.Visible = false;
gvVoyage.DataSource = liTable;
gvVoyage.DataBind();
if (liTable.Rows.Count != 0)
{
double AVG = Convert.ToDouble(liTable.Compute("AVG(Value)", "").ToString());
hiddenAVG.Value = Math.Round(AVG, 2).ToString();
gvVoyage.FooterRow.Cells[4].Text = "Average: " + Math.Round(AVG, 2).ToString();
gvVoyage.FooterRow.Cells[4].HorizontalAlign = HorizontalAlign.Center;
gvVoyage.FooterRow.Cells[4].ForeColor = System.Drawing.Color.Black;
gvVoyage.FooterRow.Cells[4].BorderColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
gvVoyage.FooterRow.Cells[3].BorderColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
gvVoyage.FooterRow.Cells[2].BorderColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
gvVoyage.FooterRow.Cells[1].BorderColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
gvVoyage.FooterRow.Cells[0].BorderColor = System.Drawing.ColorTranslator.FromHtml("#EFEFEF");
//txtGoal.Text = ds.Tables[1].Rows[0]["Goal"].ToString();
gvVoyage.FooterRow.BackColor = System.Drawing.ColorTranslator.FromHtml("#abcdef");
hiddengVoyageCount.Value = "1";
}
else
{
hiddengVoyageCount.Value = "0";
}
getGoal();
}
}
protected void btnExport_Click(object sender, ImageClickEventArgs e)
{
if (checkVoyage.Checked == false)
{
if (txtStartDate.Text != "")
{
Startdate = Convert.ToDateTime(txtStartDate.Text);
}
if (txtEndDate.Text != "")
{
EndDate = Convert.ToDateTime(txtEndDate.Text);
}
string Value_Type = rdListValue.SelectedValue;
KPI_ID = Convert.ToInt32(ddlKPIList.SelectedValue);
DataTable dt = objKPI.Get_Vessel_KPI_Values(Convert.ToInt32(ddlvessel.SelectedValue), KPI_ID, ddlInterval.SelectedValue, Value_Type, Startdate, EndDate).Tables[0];
string[] HeaderCaptions = { "Record Duration", "KPI Value" };
string[] DataColumnsName = { "Record_Date_Str", "Value" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, ddlvessel.SelectedItem.Text, 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][0].ToString() != "")
{
Startdate = Convert.ToDateTime(dtq.Rows[0][0].ToString());
}
if (dtq.Rows[dtq.Rows.Count - 1][0].ToString() != "")
{
EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1][0].ToString());
}
DataTable dt = BLL_TMSA_PI.GetVoyageDataNOx(listVoyage.Items[x].Value.Trim(), Convert.ToInt32(ddlvessel.SelectedValue)).Tables[0];
liTable.Merge(dt);
}
string[] HeaderCaptions = { "Deperture Date", "Arrival Date", "From Port", "To Port", "Average" };
string[] DataColumnsName = { "EffectiveFrom", "EffectiveTo", "FromPort", "ToPort", "Value" };
GridViewExportUtil.ExportToExcel(liTable, HeaderCaptions, DataColumnsName, ddlvessel.SelectedItem.Text, ddlvessel.SelectedItem.Text);
}
}
}
protected void ddlVoyage_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DateTime?Startdate = null;
Startdate = Convert.ToDateTime(txtStartDate.Text);
DateTime?EndDate = null;
EndDate = Convert.ToDateTime(txtEndDate.Text);
int KPI_ID = 1;
DropDownList ddlVoyage = (DropDownList)sender;
GridDataItem item = (GridDataItem)ddlVoyage.NamingContainer;
Label txtSrno = (Label)item.FindControl("Vessel_Average");
HiddenField hdf = (HiddenField)item.FindControl("hdVesselID");
if (ddlVoyage.SelectedIndex != 0)
{
string val = ddlVoyage.SelectedValue.Trim().Split(':')[0] + ":" + ddlVoyage.SelectedValue.Trim().Split(':')[1];
DataTable dtq = BLL_TMSA_PI.GetTelDate(val.Trim(), Convert.ToInt32(hdf.Value)).Tables[0];
if (dtq.Rows[0][0].ToString() != "")
{
Startdate = Convert.ToDateTime(dtq.Rows[0][0].ToString());
hiddenStartDate.Value = Startdate.Value.Date.ToString("dd-MM-yyyy");
}
if (dtq.Rows[dtq.Rows.Count - 1][0].ToString() != "")
{
EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1][0].ToString());
hiddenEndDate.Value = EndDate.Value.Date.ToString("dd-MM-yyyy");
}
}
DataTable dt = BLL_TMSA_PI.GetVoyageData(ddlVoyage.SelectedValue.Trim(), Convert.ToInt32(hdf.Value), KPI_ID).Tables[0];
txtSrno.Text = Math.Round(Convert.ToDouble(dt.Rows[0]["Value"].ToString()), 2).ToString();
Button1.Visible = true;
btnChart.Visible = false;
}
catch
{
}
}
public void item_click(object sender, EventArgs e)
{
try
{
GridDataItem item = (GridDataItem)((LinkButton)sender).NamingContainer;
DropDownList ddlVoyage = (DropDownList)item.FindControl("ddlVoyage");
foreach (GridDataItem gvr in rgdItems.Items)
{
gvr["Vessel"].BackColor = System.Drawing.Color.White;
}
if (CheckBox1.Checked)
{
if (ddlVoyage.SelectedIndex <= 0)
{
string stralert = "alert('Please select a voyage ');";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Alert", stralert, true);
}
else
{
item["Vessel"].BackColor = System.Drawing.Color.Yellow;
}
}
else
{
item["Vessel"].BackColor = System.Drawing.Color.Yellow;
}
LinkButton itemName = (LinkButton)item.FindControl("Item_Name");
HiddenField hdf = (HiddenField)item.FindControl("hdVesselID");
Label hiddenStartDate = (Label)item.FindControl("hdnVesselStartDate");
Label hiddenEndDate = (Label)item.FindControl("hdnVesselEndDate");
int index2 = item.ItemIndex;
hiddenVesselStartDate.Value = UDFLib.ConvertToDefaultDt(txtStartDate.Text);
hiddenVesselEndDate.Value = UDFLib.ConvertToDefaultDt(txtEndDate.Text);
getGoal();
string vesselname = itemName.Text;
bool voyage = false;
string jsMethodName = null;
string val = "";
string val1 = "";
string val2 = "";
if (CheckBox1.Checked)
{
if (ddlVoyage.SelectedIndex > 0)
{
val = ddlVoyage.SelectedValue.Trim().Split(':')[0] + ":" + ddlVoyage.SelectedValue.Trim().Split(':')[1];
val1 = ddlVoyage.SelectedValue.Trim().Split(':')[0];
val2 = ddlVoyage.SelectedValue.Trim().Split(':')[1];
DataTable dtq = BLL_TMSA_PI.GetTelDate(val.Trim(), Convert.ToInt32(hdf.Value)).Tables[0];
if (dtq.Rows[0][1].ToString() != "")
{
hiddenStartDate.Text = dtq.Rows[0][1].ToString();
}
if (dtq.Rows[dtq.Rows.Count - 1][1].ToString() != "")
{
hiddenEndDate.Text = dtq.Rows[dtq.Rows.Count - 1][1].ToString();
}
voyage = true;
jsMethodName = "showChart2('" + val1 + "','" + val2 + "','" + hiddenStartDate.Text + "','" + hiddenEndDate.Text + "','" + vesselname + "','" + hdf.Value + "','" + voyage + "','" + ddlVoyage.SelectedValue.Trim() + "')";
}
}
else
{
jsMethodName = "showChart2('" + val1 + "','" + val2 + "','" + Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)).ToString("yyyy-MM-dd") + "','" + Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text)).ToString("yyyy-MM-dd") + "','" + vesselname + "','" + hdf.Value + "','" + voyage + "','" + ddlVoyage.SelectedValue.Trim() + "')";
}
ScriptManager.RegisterClientScriptBlock(this, typeof(string), "uniqueKey", jsMethodName, true);
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
/// <summary>
/// Description: If by voyage is selected , for all vessels voyage ddl wil populate based on search date
/// </summary>
protected void ddlVoyage_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DateTime Startdate;
Startdate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text));
//Startdate= Convert.ToDateTime(txtStartDate.Text);
DateTime EndDate;
EndDate = Convert.ToDateTime(UDFLib.ConvertToDate(txtEndDate.Text));
//EndDate = Convert.ToDateTime(txtEndDate.Text);
int KPI_ID = 1;
DropDownList ddlVoyage = (DropDownList)sender;
GridDataItem item = (GridDataItem)ddlVoyage.NamingContainer;
Label avg = (Label)item.FindControl("Vessel_Average");
HiddenField hdf = (HiddenField)item.FindControl("hdVesselID");
LinkButton lnkVessel = (LinkButton)item.FindControl("Item_Name");
item["Average"].BackColor = System.Drawing.Color.White;
avg.Text = "0";
if (ddlVoyage.SelectedIndex != 0)
{
string val = ddlVoyage.SelectedValue.Trim().Split(':')[0] + ":" + ddlVoyage.SelectedValue.Trim().Split(':')[1];
DataTable dtq = BLL_TMSA_PI.GetTelDate(val.Trim(), Convert.ToInt32(hdf.Value)).Tables[0];
if (dtq.Rows[0][0].ToString() != "")
{
Startdate = Convert.ToDateTime(dtq.Rows[0][1].ToString());
// hiddenVesselStartDate.Value = dtq.Rows[0][0].ToString();
// hiddenStartDate.Text = dtq.Rows[0][0].ToString();
hiddenStartDate.Value = Startdate.ToString("dd-MM-yyyy");
}
if (dtq.Rows[dtq.Rows.Count - 1][0].ToString() != "")
{
EndDate = Convert.ToDateTime(dtq.Rows[dtq.Rows.Count - 1][1].ToString());
//hiddenVesselEndDate.Value = dtq.Rows[dtq.Rows.Count - 1][0].ToString();
//hiddenEndDate.Text = dtq.Rows[dtq.Rows.Count - 1][0].ToString();
hiddenEndDate.Value = EndDate.ToString("dd-MM-yyyy");
}
}
DataTable dt = BLL_TMSA_PI.GetVoyageData(ddlVoyage.SelectedValue.Trim(), Convert.ToInt32(hdf.Value), KPI_ID).Tables[0];
if (dt.Rows.Count > 0)
{
avg.Text = Math.Round(Convert.ToDouble(dt.Rows[0]["Value"].ToString()), 2).ToString();
if (Convert.ToDouble(avg.Text) == 0)
{
lnkVessel.Enabled = false;
item["Vessel"].BackColor = System.Drawing.Color.White;
}
else
{
lnkVessel.Enabled = true;
}
}
else
{
lnkVessel.Enabled = false;
item["Vessel"].BackColor = System.Drawing.Color.White;
}
Label Vessel_Goal = (Label)item.FindControl("Vessel_Goal");
Label eedi = (Label)item.FindControl("eedi");
if (Convert.ToDouble(avg.Text) > 0 && Convert.ToDouble(eedi.Text) > 0)
{
if ((Convert.ToDouble(avg.Text) < Convert.ToDouble(Vessel_Goal.Text)))
{
item["Average"].BackColor = System.Drawing.Color.White;
}
if (Convert.ToDouble(avg.Text) > Convert.ToDouble(eedi.Text))
{
item["Average"].BackColor = System.Drawing.ColorTranslator.FromHtml("#FFC7CE");
}
else if ((Convert.ToDouble(avg.Text) > Convert.ToDouble(Vessel_Goal.Text)) && (Convert.ToDouble(avg.Text) < Convert.ToDouble(eedi.Text)))
{
item["Average"].BackColor = System.Drawing.ColorTranslator.FromHtml("#FABF8F");
}
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
