using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using Travel.Vendor; using System.Security.Permissions; using AssetTableAdapters; using DestinationTableAdapters; [PrincipalPermission(SecurityAction.Demand, Role = "Vendor")] [PrincipalPermission(SecurityAction.Demand, Role = "Admin")] public partial class partners_resort_Location : System.Web.UI.Page { Asset.AssetsRow asset; protected void Page_Load(object sender, EventArgs e) { // Highlight the current nav button HyperLink curBtn = Master.FindControl("LocationBtn") as HyperLink; curBtn.CssClass = "on"; if (!IsPostBack) { LoadDestinations(); LoadData(); } } private void LoadData() { asset = Session["Asset"] as Asset.AssetsRow; if (asset == null) Response.Redirect("~/Default.aspx"); AssetTitle.Text = asset.Title; //load the corresponding destination data DestinationsTableAdapter destinationAdapter = new DestinationsTableAdapter(); Destination.DestinationsRow curDestinationData = destinationAdapter.GetByDestinationId(asset.DestinationId)[0]; //load the corresponding subdestination data SubDestinationsTableAdapter subDestinationAdapter = new SubDestinationsTableAdapter(); Destination.SubDestinationsRow curSubDestinationData = subDestinationAdapter.GetBySubDestinationId(asset.SubDestinationId)[0]; //load the corresponding asset data AssetDataTableAdapter assetDataAdapter = new AssetDataTableAdapter(); Asset.AssetDataRow curAssetData = assetDataAdapter.GetByAssetIdAndPublishLevel( (int)AssetPublishLevel.Preview, asset.AssetId )[0] ; Destinations.SelectedValue = curDestinationData.Title; // if (asset["Destination"] != null && !asset["Destination"].Equals(string.Empty)) if (curDestinationData.Title != "") LoadSubDestinations(Int32.Parse(curDestinationData.Title)); else SubDestinations.Items.Insert(0, new ListItem("Please Select Destination First", string.Empty)); // SubDestinations.SelectedValue = asset["SubDestination"]; // Address1.Text = asset["Address1"]; // Address2.Text = asset["Address2"]; // Address3.Text = asset["Address3"]; SubDestinations.SelectedValue = curSubDestinationData.Title; Address1.Text = curAssetData.Address1; Address2.Text = curAssetData.Address2; Address3.Text = curAssetData.Address3; //>> CHECK FOR UPDATED VALUES /* DestinationsModified.Text = asset.GetModified("Destination"); SubDestinationsModified.Text = asset.GetModified("SubDestination"); Address1Modified.Text = asset.GetModified("Address1"); Address2Modified.Text = asset.GetModified("Address2"); Address3Modified.Text = asset.GetModified("Address3"); */ } private void SaveData() { asset = Session["Asset"] as Asset.AssetsRow; if (asset == null) Response.Redirect("~/Default.aspx"); //load the corresponding destination data DestinationsTableAdapter destinationAdapter = new DestinationsTableAdapter(); Destination.DestinationsRow curDestination = destinationAdapter.GetByDestinationId(asset.DestinationId)[0]; //load the corresponding subdestination data SubDestinationsTableAdapter subDestinationAdapter = new SubDestinationsTableAdapter(); Destination.SubDestinationsRow curSubDestination = subDestinationAdapter.GetBySubDestinationId(asset.SubDestinationId)[0]; //load the corresponding asset data AssetDataTableAdapter assetDataAdapter = new AssetDataTableAdapter(); Asset.AssetDataRow curAssetData = assetDataAdapter.GetByAssetIdAndPublishLevel( (int)AssetPublishLevel.Preview, asset.AssetId )[0] ; // asset["Destination"] = Destinations.SelectedValue; // asset["SubDestination"] = SubDestinations.SelectedValue; // asset["Address1"] = Address1.Text.Trim(); // asset["Address2"] = Address2.Text.Trim(); // asset["Address3"] = Address3.Text.Trim(); curDestination.Title = Destinations.SelectedValue; curSubDestination.Title = SubDestinations.SelectedValue; curAssetData.Address1 = Address1.Text.Trim(); curAssetData.Address2 = Address2.Text.Trim(); curAssetData.Address3 = Address3.Text.Trim(); destinationAdapter.Update(curDestination); subDestinationAdapter.Update(curSubDestination); assetDataAdapter.Update(curAssetData); // asset.Save(); } protected void Update_Click(object sender, ImageClickEventArgs e) { SaveData(); } private void LoadDestinations() { DestinationsTableAdapter destinationAdapter = new DestinationsTableAdapter(); Destination.DestinationsDataTable allDestinations = destinationAdapter.GetAll(); Destinations.DataSource = allDestinations; Destinations.DataBind(); Destinations.Items.Insert(0,new ListItem("Select", string.Empty)); } private void LoadSubDestinations(int destinationID) { SubDestinations.Items.Clear(); //SubDestinationCollection subDestinations = SubDestination.FetchByDestinationID(destinationID); //load the corresponding subdestination data SubDestinationsTableAdapter subDestinationAdapter = new SubDestinationsTableAdapter(); // if (subDestinations.Count == 0) // SubDestinations.Items.Insert(0,new ListItem("N/A", string.Empty)); // else // { // SubDestinations.DataSource = subDestinations; SubDestinations.DataSource = subDestinationAdapter; SubDestinations.DataBind(); SubDestinations.Items.Insert(0,new ListItem("N/A", string.Empty)); // } } protected void Destinations_SelectedIndexChanged(object sender, EventArgs e) { if (Destinations.SelectedValue.Equals(string.Empty)) SubDestinations.Items.Clear(); else LoadSubDestinations(Int32.Parse(Destinations.SelectedValue)); } }