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;
}