//public IList<String> GetCities() //{ // List<String> citiesList = new List<String>(); // using (var context = new CinemaEntities()) // { // var cities = (from city in context.Addresses // where city.ObjectType.Description == "Theater" // select city).ToList(); // if (cities.Count > 0) // { // foreach (var city in cities) // { // AddressModelDTO cityRow = new AddressModelDTO(); // cityRow.City = city.City; // citiesList.Add(cityRow); // } // } // return citiesList; // } //} public IList <AddressModelDTO> GetCities() { IList <AddressModelDTO> citiesList = new List <AddressModelDTO>(); using (var context = new CinemaEntities()) { var cities = (from city in context.Addresses where city.ObjectType.Description == "Theater" select city).ToList(); if (cities.Count > 0) { foreach (var city in cities) { var cityRow = new AddressModelDTO(); cityRow.City = city.City; citiesList.Add(cityRow); List <AddressModelDTO> newCitiesList = new List <AddressModelDTO>(); foreach (var item in citiesList) { if (!newCitiesList.Contains(item)) { newCitiesList.Add(item); } } //if (citiesList != null) //{ // foreach (var cit in citiesList) // { // if (cit.City != cityRow.City) // { citiesList.Add(cityRow); } // //if (cityRow.City != city.City) // //{ // // citiesList.Add(cityRow); // //} // else // { // return citiesList; // } } } } return(citiesList); }
// [Guid("4531D5B6-268C-4AB3-81EB-57D0845E21DF")] protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (this.LoadData != null) { var ex = new EventArgs(); LoadData(ex); } Label1.Text = "it works, yeah!!!!"; string theat = Session["TheaterID"].ToString(); Guid theaterId = new Guid(); theaterId = Guid.Parse(theat); TheaterServices showTheater = new TheaterServices(); TheaterModelDTO currentTheater = new TheaterModelDTO(); currentTheater = showTheater.GetTheater(theaterId); lblName.Text = currentTheater.Name; AddressServices showAddress = new AddressServices(); AddressModelDTO currentAddress = new AddressModelDTO(); currentAddress = showAddress.GetAddress(theaterId); lblAddressLine1.Text = currentAddress.AddressLine1; lblCity.Text = currentAddress.City; lblCountry.Text = currentAddress.Country; lblEmail.Text = currentAddress.Email; lblPhone.Text = currentAddress.Phone; lblPostalCode.Text = currentAddress.PostalCode; lblProvince.Text = currentAddress.Province; PerformanceServices showAllPerformances = new PerformanceServices(); GridViewPerformance.DataSource = showAllPerformances.GetPerformances(theaterId); GridViewPerformance.DataBind(); } }
//public IList<String> GetCities() //{ // List<String> citiesList = new List<String>(); // using (var context = new CinemaEntities()) // { // var cities = (from city in context.Addresses // where city.ObjectType.Description == "Theater" // select city).ToList(); // if (cities.Count > 0) // { // foreach (var city in cities) // { // AddressModelDTO cityRow = new AddressModelDTO(); // cityRow.City = city.City; // citiesList.Add(cityRow); // } // } // return citiesList; // } //} public IList<AddressModelDTO> GetCities() { IList<AddressModelDTO> citiesList = new List<AddressModelDTO>(); using (var context = new CinemaEntities()) { var cities = (from city in context.Addresses where city.ObjectType.Description == "Theater" select city).ToList(); if (cities.Count > 0) { foreach (var city in cities) { var cityRow = new AddressModelDTO(); cityRow.City = city.City; citiesList.Add(cityRow); List<AddressModelDTO> newCitiesList = new List<AddressModelDTO>(); foreach (var item in citiesList) { if (!newCitiesList.Contains(item)) { newCitiesList.Add(item);} } //if (citiesList != null) //{ // foreach (var cit in citiesList) // { // if (cit.City != cityRow.City) // { citiesList.Add(cityRow); } // //if (cityRow.City != city.City) // //{ // // citiesList.Add(cityRow); // //} // else // { // return citiesList; // } } } } return citiesList; }
// [Guid("4531D5B6-268C-4AB3-81EB-57D0845E21DF")] protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (this.LoadData != null) { var ex = new EventArgs(); LoadData(ex); } Label1.Text = "it works, yeah!!!!"; string theat = Session["TheaterID"].ToString(); Guid theaterId = new Guid(); theaterId= Guid.Parse(theat); TheaterServices showTheater=new TheaterServices(); TheaterModelDTO currentTheater = new TheaterModelDTO(); currentTheater = showTheater.GetTheater(theaterId); lblName.Text = currentTheater.Name; AddressServices showAddress = new AddressServices(); AddressModelDTO currentAddress = new AddressModelDTO(); currentAddress=showAddress.GetAddress(theaterId); lblAddressLine1.Text = currentAddress.AddressLine1; lblCity.Text = currentAddress.City; lblCountry.Text = currentAddress.Country; lblEmail.Text = currentAddress.Email; lblPhone.Text = currentAddress.Phone; lblPostalCode.Text = currentAddress.PostalCode; lblProvince.Text = currentAddress.Province; PerformanceServices showAllPerformances=new PerformanceServices(); GridViewPerformance.DataSource = showAllPerformances.GetPerformances(theaterId); GridViewPerformance.DataBind(); } }
//Method that extracts all data to populate the Labels and the table Performance private void LoadData(Guid theaterId) { //Data extraction from database IPerformance performanceServices = new PerformanceServices(); IList <PerformanceModelDTO> ListOfPerformances = performanceServices.GetPerformances(theaterId); ITheater showTheater = new TheaterServices(); String currentTheater = showTheater.GetTheater(theaterId); IAddress showAddress = new AddressServices(); AddressModelDTO currentAddress = showAddress.GetAddress(theaterId); //Data transfer to Theater Model Myview.Model.ListOfPerformances = new List <PerformanceLine>(); foreach (var item in ListOfPerformances) { PerformanceLine row = new PerformanceLine(); row.PerformanceID = item.PerformanceID.ToString(); row.Title = item.Title; row.Date = item.Date; row.StartingTime = item.StartingTime; row.RoomNumber = item.RoomNumber.ToString(); row.Duration = item.Duration; row.Price = item.Price.ToString(); Myview.Model.ListOfPerformances.Add(row); } Myview.Model.TheaterName = currentTheater; Myview.Model.AddressLine1 = currentAddress.AddressLine1; Myview.Model.City = currentAddress.City; Myview.Model.Country = currentAddress.Country; Myview.Model.Province = currentAddress.Province; Myview.Model.PostalCode = currentAddress.PostalCode; Myview.Model.Phone = currentAddress.Phone; Myview.Model.Email = currentAddress.Email; }
public AddressModelDTO GetAddress(Guid objectId) { Address spesificAddress = new Address(); using (var context = new CinemaEntities()) { spesificAddress = (from address in context.Addresses where address.ObjectID == objectId select address).FirstOrDefault(); } AddressModelDTO addressToReturn = new AddressModelDTO(); addressToReturn.AddressID = spesificAddress.AddressID; addressToReturn.AddressLine1 = spesificAddress.AddressLine1; addressToReturn.City = spesificAddress.City; addressToReturn.PostalCode = spesificAddress.PostalCode; addressToReturn.Province = spesificAddress.Province; addressToReturn.Country = spesificAddress.Country; addressToReturn.Phone = spesificAddress.Phone; addressToReturn.Email = spesificAddress.Email; return addressToReturn; }
public AddressModelDTO GetAddress(Guid objectId) { Address spesificAddress = new Address(); using (var context = new CinemaEntities()) { spesificAddress = (from address in context.Addresses where address.ObjectID == objectId select address).FirstOrDefault(); } AddressModelDTO addressToReturn = new AddressModelDTO(); addressToReturn.AddressID = spesificAddress.AddressID; addressToReturn.AddressLine1 = spesificAddress.AddressLine1; addressToReturn.City = spesificAddress.City; addressToReturn.PostalCode = spesificAddress.PostalCode; addressToReturn.Province = spesificAddress.Province; addressToReturn.Country = spesificAddress.Country; addressToReturn.Phone = spesificAddress.Phone; addressToReturn.Email = spesificAddress.Email; return(addressToReturn); }