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