public void Load_VesselList() { try { DataTable dtVessel = objKPI.Get_Fleet_Vessel_List((DataTable)Session["sFleet"], Convert.ToInt32(Session["USERCOMPANYID"].ToString()), Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID()); foreach (DataRow dr in dtVessel.Rows) { if (dr["Vessel_Id"] == "11" || dr["Vessel_Id"] == "13") { dtVessel.Rows.Remove(dr); } } DDLVessel.DataSource = dtVessel; DDLVessel.DataTextField = "Vessel_name"; DDLVessel.DataValueField = "Vessel_id"; DDLVessel.DataBind(); if (dtVessel.Rows.Count > 0) { for (int i = 0; i < dtVessel.Rows.Count; i++) { if (dtVessel.Rows[i]["Vessel_id"] != null) { DDLVessel.SelectItems(new string[] { dtVessel.Rows[i]["Vessel_id"].ToString() }); } } } Session["Vessel_Id"] = DDLVessel.SelectedValues; } catch (Exception ex) { } }
protected void BindVesselList() { // DataTable dt = objKPI.Get_KPI_DetailGoals(-1).Tables[0]; BLL_Infra_VesselLib bll_Vessel = new BLL_Infra_VesselLib(); BLL_TMSA_KPI bll_KPI = new BLL_TMSA_KPI(); DataTable dt = bll_Vessel.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString())); dt.Columns.Remove("code"); dt.Columns.Remove("name"); dt.Columns.Remove("fleetname"); dt.Columns.Remove("Super_MailID"); dt.Columns.Remove("TechTeam_MailID"); dt.Columns.Remove("Vessel_Owner"); dt.Columns.Remove("Vessel_Manager"); DataTable dtable = bll_KPI.Get_Fleet_Vessel_List(dt, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID()); ddlvessel.DataSource = dtable; ddlvessel.DataTextField = "VESSEL_NAME"; ddlvessel.DataValueField = "VESSEL_ID"; ddlvessel.DataBind(); ddlvessel.Items.Insert(0, new ListItem("--Select--", "0")); if (dtable != null && dtable.Rows.Count > 0) { ddlvessel.SelectedIndex = 1; hiddenVessel.Value = "1"; } }
/// <summary> /// Method to load fleet and vessels /// </summary> protected void BindVessel() { try { BLL_Infra_VesselLib bll_Vessel = new BLL_Infra_VesselLib(); BLL_TMSA_KPI bll_KPI = new BLL_TMSA_KPI(); DataTable dt = bll_Vessel.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString())); dt.Columns.Remove("code"); dt.Columns.Remove("name"); dt.Columns.Remove("fleetname"); dt.Columns.Remove("Super_MailID"); dt.Columns.Remove("TechTeam_MailID"); dt.Columns.Remove("Vessel_Owner"); dt.Columns.Remove("Vessel_Manager"); DataTable dtable = bll_KPI.Get_Fleet_Vessel_List(dt, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID()); ddlVessel.DataSource = dtable; ddlVessel.DataTextField = "Vessel_Name"; ddlVessel.DataValueField = "Vessel_Id"; ddlVessel.DataBind(); ddlVessel.Items.Insert(0, new ListItem("--Select--", "0")); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void BindVesselList() { // DataTable dt = objKPI.Get_KPI_DetailGoals(-1).Tables[0]; BLL_Infra_VesselLib bll_Vessel = new BLL_Infra_VesselLib(); DataTable dt = bll_Vessel.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString())); dt.Columns.Remove("code"); dt.Columns.Remove("name"); dt.Columns.Remove("fleetname"); dt.Columns.Remove("Super_MailID"); dt.Columns.Remove("TechTeam_MailID"); dt.Columns.Remove("Vessel_Owner"); dt.Columns.Remove("Vessel_Manager"); DataTable dtable = objKPI.Get_Fleet_Vessel_List(dt, 0, Convert.ToInt32(Session["USERCOMPANYID"].ToString()), GetSessionUserID()); ddlvessel.DataSource = dtable; ddlvessel.DataTextField = "Vessel_Name"; ddlvessel.DataValueField = "Vessel_Id"; ddlvessel.DataBind(); ddlvessel.Items.Insert(0, new ListItem("--Select--", "0")); }