uoDropDownListPort_SelectedIndexChanged(object sender, EventArgs e) { try { if (uoDropDownListPort.SelectedIndex == 0) { LoadAllCombo(); return; } List <CrewAssistHotelList> list = new List <CrewAssistHotelList>(); SF = new CrewAssistBLL(); list = SF.GetGetHotelPortExpendTypeList(1, uoHiddenFieldUser.Value, "0", uoDropDownListPort.SelectedValue.ToString()); lstHotel.Items.Clear(); int iRowCount = list.Count; if (iRowCount > 0) { lstHotel.DataSource = list; lstHotel.DataTextField = "HotelName"; lstHotel.DataValueField = "HotelID"; lstHotel.DataBind(); } //BindVendors(uoHiddenFieldUser.Value, GlobalCode.Field2Int(uoDropDownListPort.SelectedValue), 0); } catch (Exception ex) { AlertMessage("DownListPort: " + ex.Message); } }
/// ---------------------------------------------- /// Modified By: Muhallidin G Wali /// Date Modified: 07/02/2012 /// Description: Add option "Select ALL Hotel" ,"-1" if there is selected Region /// ---------------------------------------------- /// </summary> private void LoadAllCombo() { List <CrewAssistGenericClass> list = new List <CrewAssistGenericClass>(); try { SF = new CrewAssistBLL(); list = SF.GetGetHotelPortExpendTypeList(uoHiddenFieldUser.Value, "0", "0"); lstHotel.DataSource = null; lstHotel.Items.Clear(); uoDropDownListPort.DataSource = null; uoDropDownListPort.Items.Clear(); uoDropDownListHotel.DataSource = null; uoDropDownListHotel.Items.Clear(); Session["CrewAssistVehicleVendor"] = null; int iRowCount = list.Count; if (iRowCount > 0) { Session["HotelNameList"] = list[0].CrewAssistHotelList; lstHotel.DataSource = list[0].CrewAssistHotelList; lstHotel.DataTextField = "HotelName"; lstHotel.DataValueField = "HotelID"; lstHotel.DataBind(); uoDropDownListPort.DataSource = null; uoDropDownListPort.Items.Clear(); Session["CrewAssitPortList"] = list[0].CrewAssitPortList; uoDropDownListPort.DataSource = list[0].CrewAssitPortList; uoDropDownListPort.DataTextField = "PORTName"; uoDropDownListPort.DataValueField = "PORTID"; uoDropDownListPort.DataBind(); uoDropDownListPort.Items.Insert(0, new ListItem("--Select Port--", "0")); //lstPort.DataSource = list[0].CrewAssitPortList; //lstPort.DataTextField = "PORTName"; //lstPort.DataValueField = "PORTID"; //lstPort.DataBind(); uoDropDownListCurrency.DataSource = list[0].CrewAssistCurrency; uoDropDownListCurrency.DataTextField = "CurrencyName"; uoDropDownListCurrency.DataValueField = "CurrencyID"; uoDropDownListCurrency.DataBind(); //uoDropDownListRouteFrom.Items.Clear(); //uoDropDownListRouteFrom.Items.Add(new ListItem("--Select Route From--", "0")); //uoDropDownListRouteFrom.DataSource = list[0].CrewAssistRout; //uoDropDownListRouteFrom.DataTextField = "RoutName"; //uoDropDownListRouteFrom.DataValueField = "RoutId"; //uoDropDownListRouteFrom.DataBind(); //uoDropDownListMAGTo.Items.Clear(); //uoDropDownListMAGTo.Items.Add(new ListItem("--Select To--", "0")); //uoDropDownListMAGTo.DataSource = list[0].CrewAssistRout; //uoDropDownListMAGTo.DataTextField = "RoutName"; //uoDropDownListMAGTo.DataValueField = "RoutId"; //uoDropDownListMAGTo.DataBind(); //ListView mylist = ((ListView)uoListViewTranportationRoute); //ListViewItem lvi = null; //if (mylist.Controls.Count == 1) // lvi = mylist.Controls[0] as ListViewItem; //ListView mylist = ((ListView)uoListViewTranportationRoute) //if (lvi == null || lvi.ItemType != ListViewItemType.EmptyItem) // return; //Literal literal1 = (Literal)lvi.FindControl("Literal1"); //if (literal1 != null) // literal1.Text = "No items to display"; //Session["CrewAssistVehicleVendor"] = list[0].VehicleVendor; //var Vehresult = (from dbo in list[0].VehicleVendor // select new // { // Vehicle = dbo.Vehicle, // VehicleID = dbo.VehicleID, // IsPortAgent = dbo.IsPortAgent // }).Distinct(); //uoDropDownListVehicleVendor.DataSource = null; //uoDropDownListVehicleVendor.Items.Clear(); //uoDropDownListVehicleVendor.DataSource = Vehresult; //uoDropDownListVehicleVendor.DataTextField = "Vehicle"; //uoDropDownListVehicleVendor.DataValueField = "VehicleID"; //uoDropDownListVehicleVendor.DataBind(); //uoDropDownListVehicleVendor.Items.Insert(0, new ListItem("--Select Vehicle--", "0")); //uoDropDownListVCountryVisiting.DataSource = list[0].CrewAssistNationality; //uoDropDownListVCountryVisiting.DataTextField = "Nationality"; //uoDropDownListVCountryVisiting.DataValueField = "NatioalityID"; //uoDropDownListVCountryVisiting.DataBind(); //uoDropDownListVCountryVisiting.Items.Insert(0, new ListItem("--Select Country Visit--", "0")); //Session["MeetAndGreetVendor"] = list[0].CrewAssistMeetAndGreetVendor; //var result = (from dbo in list[0].CrewAssistMeetAndGreetVendor // select new // { // MeetAndGreetVendor = dbo.MeetAndGreetVendor, // MeetAndGreetVendorID = dbo.MeetAndGreetVendorID // }) // .ToList().Distinct(); ////var rr = list[0].CrewAssistMeetAndGreetVendor.Select(e => new { e.MeetAndGreetVendor, e.MeetAndGreetVendorID }).Distinct(); //uoDropDownListMAndGVendor.DataSource = null; //uoDropDownListMAndGVendor.Items.Clear(); //uoDropDownListMAndGVendor.DataSource = result; //uoDropDownListMAndGVendor.DataTextField = "MeetAndGreetVendor"; //uoDropDownListMAndGVendor.DataValueField = "MeetAndGreetVendorID"; //uoDropDownListMAndGVendor.DataBind(); //uoDropDownListMAndGVendor.Items.Insert(0, new ListItem("--Select Meet And Greet--", "0")); //Session["PortAgentVendor"] = list[0].CrewAssistVendorPortAgent; //var PAsult = (from dbo in list[0].CrewAssistVendorPortAgent // select new // { // PortAgentVendorName = dbo.PortAgentVendorName, // PortAgentVendorID = dbo.PortAgentVendorID // }) // .ToList().Distinct(); //uoDropDownListPortAgent.DataSource = PAsult; //uoDropDownListPortAgent.DataTextField = "PortAgentVendorName"; //uoDropDownListPortAgent.DataValueField = "PortAgentVendorID"; //uoDropDownListPortAgent.DataBind(); //uoDropDownListPortAgent.Items.Insert(0, new ListItem("--Select Service Provider--", "0")); //var Safresult = (from dbo in list[0].CrewAssistSafeguardVendor // select new // { // SafeguardName = dbo.SafeguardName, // SafeguardVendorID = dbo.SafeguardVendorID // }) // .ToList().Distinct(); //Session["CrewAssistSafeguardVendor"] = list[0].CrewAssistSafeguardVendor; //uoDropDownListSafeguard.Items.Clear(); //uoDropDownListSafeguard.Items.Add(new ListItem("--Select Safeguard--", "0")); //uoDropDownListSafeguard.DataSource = Safresult; //uoDropDownListSafeguard.DataTextField = "SafeguardName"; //uoDropDownListSafeguard.DataValueField = "SafeguardVendorID"; //uoDropDownListSafeguard.DataBind(); ////uoDropDownListSafeguard.SelectedValue = "0"; //cboAirportList.DataSource = list[0].CrewAssistAirport; //cboAirportList.DataTextField = "PortName"; //cboAirportList.DataValueField = "PortCode"; //cboAirportList.DataBind(); //cboRemarkType.Items.Clear(); //cboRemarkType.Items.Add(new ListItem("--Select Type--", "0")); //cboRemarkType.DataSource = list[0].RemarkType; //cboRemarkType.DataTextField = "RemarkType"; //cboRemarkType.DataValueField = "RemarkTypeID"; //cboRemarkType.DataBind(); //cboRemarkStatus.Items.Clear(); //cboRemarkStatus.Items.Add(new ListItem("--Select Remark Status--", "0")); //cboRemarkStatus.DataSource = list[0].RemarkStatus; //cboRemarkStatus.DataTextField = "RemarkType"; //cboRemarkStatus.DataValueField = "RemarkTypeID"; //cboRemarkStatus.DataBind(); //cboRemarkRequestor.Items.Clear(); //cboRemarkRequestor.Items.Add(new ListItem("--Select Remark Requestor--", "0")); //cboRemarkRequestor.DataSource = list[0].RemarkRequestor; //cboRemarkRequestor.DataTextField = "RemarkType"; //cboRemarkRequestor.DataValueField = "RemarkTypeID"; //cboRemarkRequestor.DataBind(); } } catch (Exception ex) { throw ex; } }