public List <Accommodation> Search(string searchTerm) { List <Accommodation> accommodationList = new List <Accommodation>(); searchTerm = CustomFormat(searchTerm); try { string sql = "SELECT [AccommodationID], [Title], [Description], [Image], [Country] FROM Accommodation WHERE [Title] LIKE @SearchTerm OR [Description] LIKE @SearchTerm"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("@SearchTerm", "%" + searchTerm + "%") }; DataSet results = ExecuteSql(sql, parameters); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Accommodation a = DataSetParser.DataSetToAccommodation(results, x); accommodationList.Add(GetPrices(a)); } return(accommodationList); } catch { throw; } }
public List <Accommodation> QuickSearch(SearchVm sm) { List <Accommodation> result = new List <Accommodation>(); if (!string.IsNullOrEmpty(sm.Search)) { sm.Search = CustomFormat(sm.Search); } string sql = "SELECT [AccommodationId], [Title], [Description], [Image], " + "[Country] FROM [Accommodation]"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >(); if (sm.Country != null) { sql += "WHERE [Country] = @country"; parameters.Add(new KeyValuePair <string, string>("@country", Convert.ToInt32(sm.Country).ToString())); } DataSet results = ExecuteSql(sql, parameters); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Accommodation a = DataSetParser.DataSetToAccommodation(results, x); result.Add(GetPrices(a)); } if (sm.TravelType == TravelTypes.Zomer) { result = result.Where(n => n.DatePrices.Count(m => m.Date.Month >= 3 || m.Date.Month <= 9) != 0).ToList(); } else if (sm.TravelType == TravelTypes.Winter) { result = result.Where(n => n.DatePrices.Count(m => m.Date.Month <= 2 || m.Date.Month >= 10) != 0) .ToList(); } if (sm.Month != null) { result = result.Where(n => n.DatePrices.Count(m => m.Date.Month == (int)(Months)sm.Month + 1) != 0).ToList(); } return(result); }
public Accommodation GetById(int id) { try { string sql = "SELECT AccommodationID, Title, [Description], [Image], [Country] FROM [Accommodation] WHERE AccommodationID = @AccommodationID"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("@AccommodationID", id.ToString()) }; DataSet results = ExecuteSql(sql, parameters); Accommodation a = DataSetParser.DataSetToAccommodation(results, 0); return(GetPrices(a)); } catch { return(null); } }
public List <Accommodation> GetAll() { List <Accommodation> accommodationList = new List <Accommodation>(); try { string sql = "SELECT AccommodationID, Title, Description, Image, Country FROM [Accommodation]"; DataSet results = ExecuteSql(sql, new List <KeyValuePair <string, string> >()); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Accommodation a = DataSetParser.DataSetToAccommodation(results, x); accommodationList.Add(GetPrices(a)); } return(accommodationList); } catch { throw; } }