protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { int advertID = 0; if (!int.TryParse(Request.QueryString["id"], out advertID)) Response.Redirect("/"); GetAdvertResult advert = new UltimateDataContext().GetAdvert(advertID).Single<GetAdvertResult>(); if (!advert.PlaceberryAdvert) { advertframe.Attributes.Add("src", advert.URLLink); } else if (advert.AccommodationId.HasValue) { Response.Redirect(String.Format("/AgencyListing.aspx?id={0}", advert.AccommodationId.Value), true); } else { Response.Redirect("/", true); } } else Response.Redirect("/", true); }
protected UltimateDC.Agency GetAgency() { if (_agency == null) { UltimateDataContext dc = new UltimateDataContext(); int agencyId = 0; if (Int32.TryParse(Request.QueryString["agencyid"], out agencyId)) { bool isAdmin = User.IsInRole("Administrators"); _agency = (from p in dc.Agencies where p.Id == agencyId && (isAdmin || p.PlaceberryUser.aspnet_User.UserName == User.Identity.Name) select p).SingleOrDefault(); } if (_agency == null) { //Ne postoji ili trenutni korisnik nema prava Response.Redirect("/manage/customer.aspx"); } } return _agency; }
protected void Page_Load(object sender, EventArgs e) { bool admin = User.IsInRole("Administrators"); plhAdminOptions.Visible = admin; using (UltimateDataContext dc = new UltimateDataContext()) { var agencies = from p in dc.Agencies where admin || p.ManagerId == (Guid)Membership.GetUser().ProviderUserKey select p; if (agencies.Any()) { //Ako je samo jedna onda neka odmah ide na stranicu s agencijom if (agencies.Count() == 1 && !admin) Response.Redirect(String.Format("/manage/Agency.aspx?agencyId={0}", agencies.Single().Id)); repAgencies.DataSource = agencies; repAgencies.DataBind(); } else if(!admin) { //Ako nema ni jedne Agencije neka korisnik stvori novu agenciju Response.Redirect(String.Format("/manage/Agency.aspx?action=newagency")); } } }
protected void Page_Load(object sender, EventArgs e) { var cookie = Request.Cookies.Get("savedAds"); if (cookie != null) { string vals = cookie.Value; if (!string.IsNullOrEmpty(vals)) { int ad = 0; var list = from p in HttpUtility.UrlDecode(vals).Split(',') select int.TryParse(p, out ad) ? ad : -1; var listfiltered = (from p in list where p != -1 select p).Distinct().ToList(); if (listfiltered.Any()) { using (UltimateDataContext dc = new UltimateDataContext()) { var favoriteAds = from p in dc.Adverts where listfiltered.Contains(p.Id) select new { Id = p.Id, Title = p.Title, }; repFavoriteAds.DataSource = favoriteAds; repFavoriteAds.DataBind(); } } } } }
protected void GetChildren() { using (UltimateDataContext dc = new UltimateDataContext()) { var children = from p in dc.UltimateTableRelations where p.Active == true && p.Child.Active == true && p.Parent.Title.ToLower() == parentTerm && p.Child.UltimateTableObjectType.GroupCode == "GEO" select p.Child; var parents = from p in dc.UltimateTableRelations where p.Active == true && p.Parent.Active == true && p.Child.Title.ToLower() == parentTerm select p.Parent; var brothers = from p in dc.UltimateTableRelations where p.Active == true && p.Child.Active == true && parents.Contains(p.Parent) && p.Child.Title.ToLower() != parentTerm && p.Child.UltimateTableObjectType.GroupCode == "GEO" select p.Child; //Ako parent nema djece onda ispisuje braću var query = children.Any() ? children : brothers; //LEFT OUTER JOIN pa ako nema prijevoda onda prikazujemo Title iz UltimateTable var translation = from p in query join q in dc.UltimateTableTranslations on p equals q.UltimateTable into trans from r in trans.Where(i => i.Language.Abbrevation == language && i.Active == true).DefaultIfEmpty() select new { UltimateId = p.Id, Title = r != null ? r.Title : p.Title }; if (translation.Any()) { var trans = translation.Take(1).SingleOrDefault(); var parentnodes = (from p in dc.GetParents(null, trans.UltimateId, Common.GetLanguageId()) select p.ParentTitle).ToArray(); //string parentlink = parentnodes.Any() ? string.Join(" ", parentnodes) + " " : string.Empty; aParent.HRef = string.Format("{0}?{1}{2}={3}", landingPage, queryString, queryStringVar, HttpUtility.UrlEncode(parentnodes.Last())); aParent.InnerText = parentnodes.Last(); var data = from p in translation select new { Href = String.Format("{0}?{1}{2}={3}", landingPage, queryString, queryStringVar, HttpUtility.UrlEncode(p.Title)), Title = p.Title }; repDirectory.DataSource = data; repDirectory.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { DateTime arrivDate; int numOfDays; int numOfPers; if (DateTime.TryParse(Request.QueryString["arrivDate"], out arrivDate) && Int32.TryParse(Request.QueryString["numOfDays"], out numOfDays) && Int32.TryParse(Request.QueryString["numOfPers"], out numOfPers)) { XDocument xdoc = new XDocument(new XElement("root")); if (arrivDate > DateTime.Now) { List<Booking> lstBook = Booking.GetAllBookingsForAgency(NOVAK_AGENCY_ID, true, null); UltimateDataContext dc = new UltimateDataContext(); var accommodations = from a in dc.Accommodations where a.AgencyId == NOVAK_AGENCY_ID select a; foreach (var accomm in accommodations) { bool isAvail = numOfPers <= accomm.CapacityMax; if (isAvail) { List<Booking> thisAccommBookings = (from b in lstBook where b.AccommodationId == accomm.Id select b).ToList<Booking>(); isAvail = CheckDateAvail(thisAccommBookings, numOfDays, arrivDate); } if (isAvail) { xdoc.Root.Add(new XElement("itemId", accomm.Id.ToString())); } } //XDocument doc = new XDocument( //new XElement("root", // new XAttribute("name", "value"), // new XElement("child", "text node"))); } Response.Clear(); Response.ContentType = "text/xml; encoding='utf-8'"; Response.Write(xdoc.ToString()); Response.End(); } }
public static bool CheckAgencyExists(string agency) { bool exists = false; agency = agency == null ? string.Empty : agency.Trim().ToLower(); using (UltimateDataContext dc = new UltimateDataContext()) { exists = dc.Agencies.Any(i => i.Name.ToLower() == agency); } return exists; }
public IEnumerable GetChildrenByType(int? parentId, int? childTypeId, int? languageId) { IEnumerable children = null; using (UltimateDataContext dc = new UltimateDataContext()) { children = (from p in dc.GetParentChildsByType(parentId, childTypeId, languageId) orderby p.ParentTitle ascending select new { Id = p.ChildId, Title = p.ChildTitle }).ToList(); } return children; }
public IEnumerable GetParents(string childTitle, int? childId, int? languageId) { IEnumerable parents = null; using (UltimateDataContext dc = new UltimateDataContext()) { parents = (from p in dc.GetParents(null, childId, languageId) orderby p.ParentTitle ascending select new { Id = p.ParentId, Title = p.ParentTitle, Type = p.ObjectTypeCode }).ToList(); } return parents; }
public IEnumerable GetParentCities(int countryId, int? languageId) { IEnumerable cities = null; using (UltimateDataContext dc = new UltimateDataContext()) { cities = (from p in dc.GetParentCities(countryId, languageId) orderby p.ChildTitle ascending select new { Id = p.ChildId.Value, Title = p.ChildTitle, DisplayTitle = String.Format("{0}, {1}", p.ChildTitle, p.ParentTitle) }).ToList(); } return cities; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (UltimateDC.UltimateDataContext dc = new UltimateDC.UltimateDataContext()) { repPopularQueries.DataSource = (from p in dc.PopularQueries where p.Active == true && p.LanguageId == Common.GetLanguageId() orderby p.Priority descending select new { Title = p.Query, Link = String.Format("/{0}?q={1}", Resources.placeberry.General_VacationUrl, HttpUtility.UrlEncode(p.Query)) }).Take(12); repPopularQueries.DataBind(); } } }
private void DoActivate() { mvwLogin.ActiveViewIndex = 1; string activationkey = Request.QueryString["activationkey"]; if (!string.IsNullOrEmpty(activationkey)) { Guid key = new Guid(activationkey); using (UltimateDataContext dc = new UltimateDataContext()) { var user = (from p in dc.PlaceberryUsers where p.ActivationKey.HasValue && p.ActivationKey.Value == key select p).SingleOrDefault(); if (user != null) { user.aspnet_User.aspnet_Membership.IsApproved = true; user.ActivationKey = null; dc.SubmitChanges(); FormsAuthentication.SetAuthCookie(user.aspnet_User.UserName, true); ltlSucess.Visible = true; Response.AddHeader("REFRESH", "3;URL=/manage"); } else { ltlError.Visible = true; } } } else { ltlError.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int bookingId; if (!Int32.TryParse(Request.QueryString["bookid"], out bookingId)) { this.phMainContent.Visible = false; this.phError.Visible = true; this.ltErrMsg.Text = "Error: Missing bookid parametar!"; return; //Response.Redirect("/manage/customer.aspx"); } Booking booking = Booking.GetBooking(bookingId); if (booking == null) { this.phMainContent.Visible = false; this.phError.Visible = true; this.ltErrMsg.Text = "Error: Booking not found in database!"; return; //Response.Redirect("/manage/customer.aspx"); } UltimateDataContext dc = new UltimateDataContext(); UltimateDC.Accommodation accommodation = (from a in dc.Accommodations where a.Id == booking.AccommodationId select a).SingleOrDefault(); if (accommodation == null) { this.phMainContent.Visible = false; this.phError.Visible = true; this.ltErrMsg.Text = "Error: Accommodation not found in database!"; return; //Response.Redirect("/manage/customer.aspx"); } // kako je ovo booking sa admina provjeriti prava bool isAdmin = User.IsInRole("Administrators"); UltimateDC.Agency agency = (from p in dc.Agencies where p.Id == accommodation.AgencyId && (isAdmin || p.PlaceberryUser.aspnet_User.UserName == User.Identity.Name) // svaka agencija ima samo jednog usera pa ako nije admin provjeriti dali je user od pripadajuce agencije select p).SingleOrDefault(); if (agency == null) { this.phMainContent.Visible = false; this.phError.Visible = true; this.ltErrMsg.Text = "Error: Access not allowed!"; return; //Response.Redirect("/manage/customer.aspx"); } this.hfAccommodationId.Value = accommodation.Id.ToString(); this.hfBookingId.Value = bookingId.ToString(); ddlStatus.Items.Add(new ListItem("T", "T")); ddlStatus.Items.Add(new ListItem("O", "O")); ddlStatus.SelectedValue = booking.Status.ToString(); tbPriceBasic.Text = booking.PriceBasic.ToString(); tbPriceSum.Text = booking.PriceSum.ToString(); var currencies = from c in dc.Currencies select c; foreach (var c in currencies) { this.ddlCurrency.Items.Add(new ListItem(c.Abbrevation, c.Id.ToString())); } this.ddlCurrency.SelectedValue = booking.CurrencyId.ToString(); calFrom.VisibleDate = booking.DateFrom; calFrom.SelectedDate = booking.DateFrom; for (int i = BookingSessionManager.DEF_MIN_NUM_OF_NIGHTS; i <= BookingSessionManager.DEF_MAX_NUM_OF_NIGHTS; ++i) { this.ddlNumOfNights.Items.Add(new ListItem(i.ToString(), i.ToString())); } this.ddlNumOfNights.SelectedValue = ((booking.DateTo - booking.DateFrom).Days + 1).ToString(); int capMin = accommodation.CapacityMin.HasValue ? accommodation.CapacityMin.Value : 1; int capMax = accommodation.CapacityMax.HasValue ? accommodation.CapacityMax.Value : 1; for (int i = capMin; i <= capMax; ++i) { this.ddlNumOfPersons.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddlNumOfPersons.SelectedValue = booking.NumOfPersons.ToString(); for (int i = 0; i <= BookingSessionManager.DEF_MAX_NUM_OF_BABIES; ++i) { this.ddlNumOfBabies.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddlNumOfBabies.SelectedValue = booking.NumOfBabies.ToString(); lblCreateDate.Text = booking.DateCreated.ToShortDateString(); lblAdminCreateName.Text = booking.AdminUserName != null ? booking.AdminUserName : String.Empty; lblLastUpdateDate.Text = booking.LastUpdateDate.HasValue ? booking.LastUpdateDate.Value.ToShortDateString() : String.Empty; lblUserFirstName.Text = booking.User.FirstName; lblUserLastName.Text = booking.User.LastName; lblUserEmail.Text = booking.User.Email; lblUserPhone.Text = booking.User.Phone; lblUserCountry.Text = booking.User.Country; lblUserCity.Text = booking.User.City; lblUserStreet.Text = booking.User.Street; hlBack.NavigateUrl = "/manage/bookingadmin.aspx?agencyId=" + accommodation.AgencyId.ToString() + "&accommid=" + accommodation.Id; } lblRetMsg.Text = " "; }
protected void Page_Load(object sender, EventArgs e) { int languageId = Common.GetLanguageId(); dc = new UltimateDataContext(); FetchAgency(); ContactAgency1.AgencyEmail = agency.ContactEmail; ContactAgency1.AgencyName = agency.Name; if (!IsPostBack) { this.Title = String.Format(Resources.placeberry.Agency_Title, agency.Name); ltlAdress.Text = String.Format("{0}, {1}, {2}", agency.Address, agency.City, agency.Country); ltlAgencyTitle.Text = agency.Name; ltlEmail.Text = agency.ContactEmail; ltlPhones.Text = agency.ContactPhone; string agencyUrl = string.Empty; var agencyUrlTag = agency.AgencyUrlTags.SingleOrDefault(); if (agencyUrlTag == null) { agencyUrl = "/Agency.aspx?id=" + agency.Id; } else { agencyUrl = Common.GenerateAgencyUrl(agencyUrlTag.UrlTag); } aAgencyLogo.HRef = agencyUrl; aAgencyName.HRef = agencyUrl; aAgencyName.InnerText = agency.Name; if (agency.AgencyDescriptions.Any()) { var opisi = agency.AgencyDescriptions; ltlDescription.Text = opisi.Where(i => i.LanguageId == languageId).Select(i => i.Description).SingleOrDefault() ?? opisi.Where(i => i.LanguageId == agency.LangaugeId).Select(i => i.Description).SingleOrDefault() ?? opisi.Take(1).Select(i => i.Description).SingleOrDefault(); } else { ltlDescription.Text = string.Empty; } if (agency.Image != null) { imgLogo.Src = "/thumb.aspx?src=" + agency.Image.Src + "&mw=185&mh=160&crop=1"; imgLogo.Alt = agency.Image.Alt; } else { imgLogo.Src = "/resources/noimg.jpg"; imgLogo.Alt = ""; } aWebsite.HRef = agency.UrlWebsite ?? "#"; aWebsite.InnerText = agency.UrlWebsite ?? string.Empty; RefeshAgencyAds(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { Validate(); if (IsValid) { ccJoin.ValidateCaptcha(tbxCaptcha.Text); if (!ccJoin.UserValidated) { ltlCaptchaError.Visible = true; return; } string username = tbxUserName.Text.Trim(); string password = tbxPassword.Text.Trim(); string email = tbxEmail.Text.Trim().ToLower(); //Ako postoji NEAKTIVIRANI korisnik s istim korisničkim imenom/emailom pobriši ga, da bezveze ne baca duplicate email grešku using (UltimateDataContext dc = new UltimateDataContext()) { var user = (from p in dc.PlaceberryUsers where p.aspnet_User.aspnet_Membership.LoweredEmail == email && p.aspnet_User.aspnet_Membership.IsApproved == false && p.ActivationKey != null select p).SingleOrDefault(); if (user != null) { Membership.DeleteUser(user.aspnet_User.UserName); } } MembershipCreateStatus status; MembershipUser newuser = Membership.CreateUser(username, password, email, null, null, false, Guid.NewGuid(), out status); switch (status) { case MembershipCreateStatus.DuplicateEmail: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.DuplicateProviderUserKey: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.DuplicateUserName: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.InvalidAnswer: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.InvalidEmail: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.InvalidPassword: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.InvalidProviderUserKey: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.InvalidQuestion: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.InvalidUserName: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.ProviderError: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.UserRejected: ltlStatusErrorMessage.Text = status.ToString(); break; case MembershipCreateStatus.Success: CreatePlaceberryUser(newuser); ltlStatusErrorMessage.Text = "Uspješno ste se registirali, na email vam trebaju stići podaci za registraciju"; break; default: break; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { UltimateDataContext dc = new UltimateDataContext(); Accommodation accommodation; int advertId = 0; int accommId = 0; // booking ce se moc pokretati i preko oglasa i preko agencije (accommodationid) if (Int32.TryParse(Request.QueryString["advertid"], out advertId)) { GetAdvertResult advert = dc.GetAdvert(advertId).Single<GetAdvertResult>(); // nisam siguran da je ovo dobar uvjet! if (advert != null && advert.PlaceberryAdvert && advert.AccommodationId.HasValue) { accommId = advert.AccommodationId.Value; } } else { Int32.TryParse(Request.QueryString["accommid"], out accommId); } if (accommId == 0) { Response.Redirect("/"); } accommodation = (from a in dc.Accommodations where a.Id == accommId select a).SingleOrDefault(); if (accommodation == null) { Response.Redirect("/"); } lblAgencyName.Text = accommodation.Agency.Name == null ? string.Empty : accommodation.Agency.Name; lblAccommName.Text = accommodation.Name == null ? string.Empty : accommodation.Name; int capMin = accommodation.CapacityMin.HasValue ? accommodation.CapacityMin.Value : 1; int capMax = accommodation.CapacityMax.HasValue ? accommodation.CapacityMax.Value : 1; for (int i = capMin; i <= capMax; ++i) { this.ddlNumOfPersons.Items.Add(new ListItem(i.ToString(), i.ToString())); } for (int i = 0; i <= BookingSessionManager.DEF_MAX_NUM_OF_BABIES; ++i) { this.ddlNumOfBabies.Items.Add(new ListItem(i.ToString(), i.ToString())); } bool priceByPerson = false; // ovo se mora nekako postaviti _booking = new BookingSessionManager(accommodation.Id, accommodation.Name, accommodation.AgencyId, priceByPerson, true); // ukoliko admin kreira i ovdje booking takoder ga spremiti if (User.IsInRole("Administrators") || accommodation.Agency.PlaceberryUser.aspnet_User.UserName == User.Identity.Name) { _booking.SetAdminUserName(User.Identity.Name); } HttpContext.Current.Session[BookingSessionManager.BOOKING_SESSION_NAME] = _booking; } }
protected void Page_Load(object sender, EventArgs e) { dc = new UltimateDataContext(); string action = Request["action"]; action = action == null ? string.Empty : action.ToLower(); switch (action) { case "editaccomm": EditAccomm(); break; case "newaccomm": NewAccomm(); break; case "editimages": EditImages(); break; case "editprices": EditPrices(); break; case "entrysuccess": ReadAccomm(); ltlStatus.Text = (string)HttpContext.Current.Items["statusmessage"]; break; default: ReadAccomm(); break; } if (!IsPostBack && accommodation != null) { aAccomm.HRef = String.Format("/manage/accommodation.aspx?accommid={0}", accommodation.Id); aAccomm.InnerText = accommodation.Name; } }
protected void Page_Load(object sender, EventArgs e) { dc = new UltimateDataContext(); string action = Request.QueryString["action"] ?? string.Empty; switch (action) { case "newentry": NewEntry(); break; case "editentry": EditEntry(); break; default: EditEntry(); break; } if (!IsPostBack) { RefreshUltimateTableGrid(); var querystring = HttpUtility.ParseQueryString(Request.Url.Query); querystring["action"] = "newentry"; aNewUltimate.HRef = String.Format("/manage/ultimatetable.aspx?{0}", querystring.ToString()); } GetShowStatusMessage(); }
protected void Page_Load(object sender, EventArgs e) { string action = Request["action"]; action = action == null ? string.Empty : action.ToLower(); dc = new UltimateDataContext(); switch (action) { case "newagency": NewAgency(); break; case "editagency": EditAgency(); break; case "entrysuccess": ReadAgency(); ltlStatus.Text = (string)HttpContext.Current.Items["statusmessage"]; break; default: ReadAgency(); break; } }
public IEnumerable SuggestCity(string term, int maxresults) { IEnumerable cities = null; term = term.ToLower(); using (UltimateDataContext dc = new UltimateDataContext()) { cities = (from p in dc.UltimateTables where p.UltimateTableObjectType.Id == (int)ObjectType.CITY && p.Title.ToLower().Contains(term) orderby p.Title ascending select new { Id = p.Id, Title = p.Title }).Take(maxresults).ToList(); } return cities; }
public static string GetAutoRegex(string term, int languageid) { string regex = string.Empty; using (UltimateDataContext dc = new UltimateDataContext()) { dc.GetAutoRegex(term, languageid, ref regex); } return regex; }
public static IEnumerable GetAutoParentSuggestions(string term, int childtypeid, int maxresults) { IEnumerable results = null; if (childtypeid > 0) { ObjectType childtype = (ObjectType)childtypeid; using (UltimateDataContext dc = new UltimateDataContext()) { IQueryable<UltimateTable> query = null; bool noquery = false; switch (childtype) { case ObjectType.ISLAND: query = from p in dc.UltimateTables where (p.ObjectTypeId == (int)ObjectType.SUBREGION || p.ObjectTypeId == (int)ObjectType.REGION) && p.Title.Contains(term) select p; break; case ObjectType.CITY: query = from p in dc.UltimateTables where (p.ObjectTypeId == (int)ObjectType.SUBREGION || p.ObjectTypeId == (int)ObjectType.REGION || p.ObjectTypeId == (int)ObjectType.ISLAND) && p.Title.Contains(term) select p; break; case ObjectType.COUNTRY: noquery = true; break; case ObjectType.REGION: query = from p in dc.UltimateTables where p.ObjectTypeId == (int)ObjectType.COUNTRY && p.Title.Contains(term) select p; break; case ObjectType.SUBREGION: query = from p in dc.UltimateTables where p.ObjectTypeId == (int)ObjectType.REGION && p.Title.Contains(term) select p; break; default: noquery = true; break; } if (!noquery) { results = (from p in query orderby p.Title ascending select new { Id = p.Id, Title = String.Format("{0} [id={1}, type={2}]", p.Title, p.Id, p.UltimateTableObjectType.Code.ToLower()) }).Take(maxresults).ToList(); } } } return results; }
protected void Page_Load(object sender, EventArgs e) { int languageId = Common.GetLanguageId(); string termTag = Request.QueryString["tag"] ?? string.Empty; termTag = termTag.Split('/').LastOrDefault(); Repeater topAdverts = TopAdverts.Adverts; if (!string.IsNullOrEmpty(termTag)) { using (UltimateDataContext dc = new UltimateDataContext()) { var query = (from p in dc.UltimateTableUrlTags where p.UrlTag == termTag && p.LanguageId == languageId select new { Id = p.UltimateTable.Id, Title = p.UltimateTable.Title, UrlTag = p.UrlTag }).Distinct(); if (query.Any()) { var term = query.First(); string termTitle = (from p in dc.UltimateTableTranslations where p.UltimateTableId == term.Id && p.Active == true && p.LanguageId == languageId select p.Title).SingleOrDefault() ?? term.Title; ltlCurrentTerm.Text = termTitle; this.Title = String.Format(Resources.placeberry.Directory_TitleFormat, termTitle); string termDesc = (from p in dc.UltimateTableInfos where p.UltimateTableId == term.Id && p.LanguageId == languageId select p.WikiDescription).SingleOrDefault() ?? string.Empty; if (!string.IsNullOrEmpty(termDesc)) { termDesc = termDesc.Replace("\n", "<br />"); ltlDescription.Text = termDesc; pnlDescription.Visible = true; } else { pnlDescription.Visible = false; } //BREADCRUMBS //dodajemo root breadcrumbs.Add(new UltimateTerm() { Id = 0, Title = "dir", UrlLink = Resources.placeberry.URL_Directory, UrlTag = Resources.placeberry.URL_Directory }); //dodajemo ostale elemente breadcrumbs.AddRange(from p in dc.GetParents(null, term.Id, languageId) where p.ObjectTypeGroupCode != null && p.ObjectTypeGroupCode == "GEO" select new UltimateTerm() { Id = p.ParentId, Title = p.ParentTitle, UrlTag = p.UrlTag, UrlLink = string.Empty }); //gradimo linkove for (int i = 1; i < breadcrumbs.Count; i++) { breadcrumbs[i].UrlLink = breadcrumbs[i - 1].UrlLink + "/" + breadcrumbs[i].UrlTag; } //dodajemo trenutni pojam zato što GetParents vrati samo roditelje, a ne i trenutni var currTerm = new UltimateTerm() { Id = term.Id, Title = termTitle, UrlTag = term.UrlTag }; var previousTerm = breadcrumbs.Last(); breadcrumbs.Add(currTerm); currTerm.UrlLink = previousTerm.UrlLink + "/" + currTerm.UrlTag; repBreadcrumbs.DataSource = breadcrumbs; repBreadcrumbs.DataBind(); //CHILDREN var children = from p in dc.UltimateTableRelations where p.ParentId == term.Id && p.Child.UltimateTableObjectType.GroupCode == "GEO" select p.Child; var childrenTranslated = from p in children join q in dc.UltimateTableTranslations on p equals q.UltimateTable into trans join t in dc.UltimateTableUrlTags on p equals t.UltimateTable into tags from r in trans.Where(i => i.LanguageId == languageId && i.Active == true).DefaultIfEmpty() from s in tags.Where(i => i.LanguageId == languageId).DefaultIfEmpty() select new { Id = p.Id, Title = r != null ? r.Title : p.Title, UrlLink = String.Format("{0}/{1}", currTerm.UrlLink, s.UrlTag) }; if (childrenTranslated.Any()) { repChildren.DataSource = childrenTranslated; repChildren.DataBind(); } else { repChildren.Visible = false; } string queryMessage = string.Empty; topAdverts.DataSource = Placeberry.DAL.GetResults.Execute(termTitle, languageId, 5, 0, 5, 0, out queryMessage); topAdverts.DataBind(); aCurrentTerm.HRef = String.Format("/{0}?q={1}", Resources.placeberry.General_VacationUrl, termTitle); aCurrentTerm.InnerText = String.Format(Resources.placeberry.Directory_SearchCurrentTerm, termTitle); aCurrentTerm.Visible = true; string keywords = string.Join(", ", breadcrumbs.Skip(1).Select(i => i.Title).ToArray()); HtmlMeta metaKeywords = new HtmlMeta() { Name = "keywords", Content = string.Empty }; HtmlMeta metaDescription = new HtmlMeta() { Name = "description", Content = string.Empty }; metaDescription.Content = String.Format(Resources.placeberry.Directory_MetaDescription, termTitle); metaKeywords.Content = String.Format(Resources.placeberry.Directory_MetaKeywords, keywords); Header.Controls.Add(metaDescription); Header.Controls.Add(metaKeywords); } else { //ERROR ne postoji taj pojam u direktoriju } } } else { using (UltimateDataContext dc = new UltimateDataContext()) { var countries = from p in dc.UltimateTables where p.Active == true && p.UltimateTableObjectType.Code == "COUNTRY" select p; var countriesTranslated = from p in countries join q in dc.UltimateTableTranslations on p equals q.UltimateTable into trans join t in dc.UltimateTableUrlTags on p equals t.UltimateTable into tags from r in trans.Where(i => i.LanguageId == languageId && i.Active == true).DefaultIfEmpty() from s in tags.Where(i => i.LanguageId == languageId).DefaultIfEmpty() select new { Id = p.Id, Title = r != null ? r.Title : p.Title, UrlLink = String.Format("{0}/{1}", Resources.placeberry.URL_Directory, s.UrlTag) }; if (countriesTranslated.Any()) { repChildren.DataSource = countriesTranslated; repChildren.DataBind(); } ltlTopAdsText.Visible = false; topAdverts.Visible = false; HtmlMeta metaKeywords = new HtmlMeta() { Name = "keywords", Content = string.Empty }; HtmlMeta metaDescription = new HtmlMeta() { Name = "description", Content = string.Empty }; metaDescription.Content = String.Format(Resources.placeberry.Directory_MetaDescription, "smještaj"); metaKeywords.Content = String.Format(Resources.placeberry.Directory_MetaKeywords, "smještaj"); Header.Controls.Add(metaDescription); Header.Controls.Add(metaKeywords); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { phMainContent.Visible = true; phLoadError.Visible = false; UltimateDataContext dc = new UltimateDataContext(); Accommodation accommodation; int accommId = 0; if(!Int32.TryParse(Request.QueryString["accommid"], out accommId)) { phMainContent.Visible = false; phLoadError.Visible = true; lblLoadErrorMsg.Text = ERR_MSG_WRONG_PARAMETARS; return; } accommodation = (from a in dc.Accommodations where a.Id == accommId select a).SingleOrDefault(); if (accommodation == null) { phMainContent.Visible = false; phLoadError.Visible = true; lblLoadErrorMsg.Text = ERR_MSG_ACCOMMODATION_NOT_FOUND; return; } // kako je ovo booking sa admina provjeriti prava bool isAdmin = User.IsInRole("Administrators"); UltimateDC.Agency agency = (from p in dc.Agencies where p.Id == accommodation.AgencyId && (isAdmin || p.PlaceberryUser.aspnet_User.UserName == User.Identity.Name) // svaka agencija ima samo jednog usera pa ako nije admin provjeriti dali je user od pripadajuce agencije select p).SingleOrDefault(); if (agency == null) { phMainContent.Visible = hlReturn.Visible = false; phLoadError.Visible = true; lblLoadErrorMsg.Text = ERR_MSG_ACCESS_NOT_ALLOWED_OR_AGENCY_NOT_FOUND; return; } lblAgencyName.Text = accommodation.Agency.Name == null ? string.Empty : accommodation.Agency.Name; lblAccommName.Text = accommodation.Name == null ? string.Empty : accommodation.Name; for (int i = BookingSessionManager.DEF_MIN_NUM_OF_NIGHTS; i <= BookingSessionManager.DEF_MAX_NUM_OF_NIGHTS; ++i) { this.ddlNumOfNights.Items.Add(new ListItem(i.ToString(), i.ToString())); } int capMin = accommodation.CapacityMin.HasValue ? accommodation.CapacityMin.Value : 1; int capMax = accommodation.CapacityMax.HasValue ? accommodation.CapacityMax.Value : 1; for (int i = capMin; i <= capMax; ++i) { this.ddlNumOfPersons.Items.Add(new ListItem(i.ToString(), i.ToString())); } for (int i = 0; i <= BookingSessionManager.DEF_MAX_NUM_OF_BABIES; ++i) { this.ddlNumOfBabies.Items.Add(new ListItem(i.ToString(), i.ToString())); } this.lblPriceSum.Text = "0"; this.lblNumOfPersons.Text = ddlNumOfPersons.SelectedValue; this.lblNumOfBabies.Text = ddlNumOfBabies.SelectedValue; this.phPriceByDay.Visible = false; this.phNoPrices.Visible = false; // OVO JOS DODATI hlReturn.NavigateUrl = "bookingadmin.aspx?agencyId=" + agency.Id + "&accommid=" + accommodation.Id; bool priceByPerson = false; // ovo se mora nekako postaviti _bookingSession = new BookingSessionManager(accommodation.Id, accommodation.Name, agency.Id, priceByPerson, false); // stavi checkmembership na false jer admin radi rezervaciju za nekoga ko moze ili ne mora bit clan placeberrya _bookingSession.SetAdminUserName(User.Identity.Name); // spremiti admina koji kreira booking HttpContext.Current.Session[BookingSessionManager.BOOKING_SESSION_NAME] = _bookingSession; } }
private void CreatePlaceberryUser(MembershipUser user) { using (UltimateDataContext dc = new UltimateDataContext()) { PlaceberryUser newuser = new PlaceberryUser(); newuser.UserId = (Guid)user.ProviderUserKey; newuser.ActivationKey = Guid.NewGuid(); dc.PlaceberryUsers.InsertOnSubmit(newuser); dc.SubmitChanges(); SendActivationEmailToUser(user, newuser.ActivationKey.Value.ToString()); } }
public static IEnumerable GetAutoNotGeoChildSuggestions(string term, int parentid, int maxresults) { IEnumerable results = null; using (UltimateDataContext dc = new UltimateDataContext()) { var parent = (from p in dc.UltimateTables where p.Id == parentid select p).SingleOrDefault(); var children = from p in dc.UltimateTableRelations where p.Parent == parent select p.Child; var query = from p in dc.UltimateTables where !children.Contains(p) && p != parent && p.Title.Contains(term) select p; if (parent.UltimateTableObjectType.GroupCode == "GEO") { query = from p in query where p.UltimateTableObjectType.GroupCode != "GEO" || p.UltimateTableObjectType.GroupCode == null select p; } results = (from p in query orderby p.Title ascending select new { Id = p.Id, Title = String.Format("{0} [id={1}, type={2}]", p.Title, p.Id, p.UltimateTableObjectType.Code.ToLower()) }).Take(maxresults).ToList(); } return results; }
public static IEnumerable GetUltimateTableSearchSuggestions(string term, int maxresults) { IEnumerable results = null; using (UltimateDataContext dc = new UltimateDataContext()) { results = (from p in dc.UltimateTables where p.Title.Contains(term) orderby p.Title ascending select new { Id = p.Id, Title = String.Format("{0} [id={1}, type={2}]", p.Title, p.Id, p.UltimateTableObjectType.Code.ToLower()), Url = String.Format("/manage/ultimatetable.aspx?ultimateid={0}", p.Id) }).Take(maxresults).ToList(); } return results; }
protected void Page_Load(object sender, EventArgs e) { dc = new UltimateDataContext(); if (!IsPostBack) { var countrys = from p in dc.UltimateTables where (ObjectType)p.ObjectTypeId == ObjectType.COUNTRY orderby p.Title ascending select p.Title; cbxCountry.DataSource = countrys; cbxCountry.DataBind(); var languages = (from p in dc.Languages orderby p.Title ascending select new { Id = p.Id, Title = p.Title }).ToList(); languages.Insert(0, new { Id = 0, Title = string.Empty }); ddlLanguage.DataSource = languages; ddlLanguage.DataTextField = "Title"; ddlLanguage.DataValueField = "Id"; ddlLanguage.DataBind(); if (string.IsNullOrEmpty(Request["id"])) { int agencyId; if (!int.TryParse(Request["agencyId"], out agencyId)) Response.Redirect("/Manage/Customer.aspx"); litNaslov.Text = "Novi zapis"; } else { litNaslov.Text = "Uređivanje zapisa"; int advertId; if (!int.TryParse(Request["id"], out advertId)) Response.Redirect("/Manage/Customer.aspx"); LoadAdvert(advertId); } } else { Validate(); } }
protected void Page_Load(object sender, EventArgs e) { dc = new UltimateDataContext(); FetchAccommodation(); ContactAgency1.AgencyEmail = accommodation.Agency.ContactEmail; ContactAgency1.AgencyName = accommodation.Agency.Name; if (!IsPostBack) { SetJavascriptVariables(); int languageId = Common.GetLanguageId(); var agency = accommodation.Agency; this.Title = String.Format(Resources.placeberry.AgencyListing_Title, agency.Name + " - " + accommodation.Name); string agencyUrl = string.Empty; var agencyUrlTag = agency.AgencyUrlTags.SingleOrDefault(); if (agencyUrlTag == null) { agencyUrl = "/Agency.aspx?id=" + agency.Id; } else { agencyUrl = Common.GenerateAgencyUrl(agencyUrlTag.UrlTag); } aAgencyLogo.HRef = agencyUrl; aAgencyName.HRef = agencyUrl; aAgencyName.InnerText = agency.Name; ltlAgencyAdress.Text = String.Format("{0}, {1}, {2}", agency.Address, agency.City, agency.Country); ltlAgencyEmail.Text = agency.ContactEmail; ltlAgencyPhones.Text = agency.ContactPhone; if (agency.Image != null) { imgAgencyLogo.Src = "/thumb.aspx?src=" + agency.Image.Src + "&mw=185&mh=160&crop=1"; imgAgencyLogo.Alt = agency.Image.Alt; } else { imgAgencyLogo.Src = "/resources/noimg.jpg"; imgAgencyLogo.Alt = ""; } aAgencyWebsite.HRef = agency.UrlWebsite ?? "#"; aAgencyWebsite.InnerText = agency.UrlWebsite ?? string.Empty; ltlListingTitle.Text = accommodation.Name; ltlListingType.Text = dc.GetTraslation(accommodation.TypeId, languageId); ltlListingCapacity.Text = Common.FormatCapacity(accommodation.CapacityMin, accommodation.CapacityMax); var descriptions = from p in accommodation.AccommodationDescriptions where p.LanguageId == languageId || p.LanguageId == accommodation.Agency.LangaugeId select p; string translation = descriptions.Where(i => i.LanguageId == languageId).Select(i => i.Description).SingleOrDefault() ?? descriptions.Where(i => i.LanguageId == agency.LangaugeId).Select(i => i.Description).SingleOrDefault(); ltlListingDescription.Text = translation ?? string.Empty; string location = dc.GetTraslation(accommodation.AccommodationCity.UltimateTableId, languageId); var parents = (from p in dc.GetParents(null, accommodation.AccommodationCity.UltimateTableId, languageId) orderby p.Lvl select p.ParentTitle).ToArray(); if (parents.Any()) { location += ", " + string.Join(", ", parents); } ltlListingLocation.Text = location; RefeshGallery(); RefreshPrices(); } }
public static IEnumerable GetAutoChildSuggestions(string term, int parentid, int parenttypeid, int maxresults) { IEnumerable results = null; if (parenttypeid > 0) { ObjectType parentype = (ObjectType)parenttypeid; using (UltimateDataContext dc = new UltimateDataContext()) { IQueryable<UltimateTable> query = null; bool noquery = false; switch (parentype) { case ObjectType.ISLAND: query = from p in dc.UltimateTables where p.ObjectTypeId == (int)ObjectType.CITY && p.Title.Contains(term) select p; break; case ObjectType.CITY: noquery = true; break; case ObjectType.COUNTRY: query = from p in dc.UltimateTables where (p.ObjectTypeId == (int)ObjectType.REGION || p.ObjectTypeId == (int)ObjectType.SUBREGION) && p.Title.Contains(term) select p; break; case ObjectType.REGION: query = from p in dc.UltimateTables where (p.ObjectTypeId == (int)ObjectType.SUBREGION || p.ObjectTypeId == (int)ObjectType.ISLAND || p.ObjectTypeId == (int)ObjectType.CITY) && p.Title.Contains(term) select p; break; case ObjectType.SUBREGION: query = from p in dc.UltimateTables where (p.ObjectTypeId == (int)ObjectType.ISLAND || p.ObjectTypeId == (int)ObjectType.CITY) && p.Title.Contains(term) select p; break; default: noquery = true; break; } if (!noquery) { var check = from p in dc.UltimateTableRelations where p.Parent.UltimateTableObjectType.GroupCode == "GEO" select p.Child; var children = from p in dc.UltimateTableRelations where p.ParentId == parentid && p.Child.UltimateTableObjectType.GroupCode == "GEO" select p.Child; results = (from p in query where !check.Contains(p) && !children.Contains(p) orderby p.Title ascending select new { Id = p.Id, Title = String.Format("{0} [id={1}, type={2}]", p.Title, p.Id, p.UltimateTableObjectType.Code.ToLower()) }).Take(maxresults).ToList(); } } } return results; }