public List<Serie> getAllSeries() { List<Serie> list = new List<Serie>(); SqlConnection connection = new SqlConnection(cString); string sqlString = "SELECT * FROM Series ORDER BY title ASC"; SqlCommand cmd = new SqlCommand(sqlString, connection); try { connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Serie s = new Serie(); s.id = Int32.Parse(reader[0].ToString()); s.title = reader[1].ToString(); s.plot = reader[2].ToString(); s.genre = reader[3].ToString(); s.imdb = reader[4].ToString(); s.image = reader[5].ToString(); s.search = reader[6].ToString(); list.Add(s); } } catch (Exception e) { Serie s = new Serie(); s.id = -1; s.title = e.ToString(); list.Add(s); return list; } finally { connection.Close(); } return list; }
public List<Serie> SearchSerie(string title) { List<Serie> list = new List<Serie>(); string temp = title.Replace("-", "%"); string search = Regex.Replace(temp, "[^a-zA-Z0-9%]+", "", RegexOptions.Compiled); SqlConnection connection = new SqlConnection(cString); string sqlString = "SELECT * FROM Series WHERE search LIKE '%" + search + "%'"; SqlCommand cmd = new SqlCommand(sqlString, connection); try { connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Serie s = new Serie(); s.id = Int32.Parse(reader[0].ToString()); s.title = reader[1].ToString(); s.plot = reader[2].ToString(); s.genre = reader[3].ToString(); s.imdb = reader[4].ToString(); s.image = reader[5].ToString(); list.Add(s); } } catch (Exception e) { Serie s = new Serie(); s.id = -1; s.title = e.ToString(); list.Add(s); return list; } finally { connection.Close(); } return list; }