private void FullTextSearch_Click(object sender, RoutedEventArgs e)
{
if (tbSearch.Text == String.Empty)
{
FillFilms();
}
else
{
countOfFilms = 0;
filmNames.Clear();
listOfFilms.Children.Clear();
SqlCommand cmd = new SqlCommand("TextSearch", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@search", tbSearch.Text);
cn.Open();
SqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
while (data.Read())
{
BitmapImage newBitmapImage = new BitmapImage();
if (data[5].GetType().ToString() != "System.DBNull")
{
System.IO.MemoryStream ms = new System.IO.MemoryStream(data[5] as byte[]);
ms.Seek(0, System.IO.SeekOrigin.Begin);
newBitmapImage.BeginInit();
newBitmapImage.StreamSource = ms;
newBitmapImage.EndInit();
}
DateTime date = (DateTime)data[2];
SqlParameter genres = Connection.GetSetGenres(data[1].ToString(), cn);
SqlParameter actors = Connection.GetSetActors(data[1].ToString(), cn);
Movie movie = new Movie(data[0].ToString(), data[1].ToString(),
date.ToString("yy/MM/dd"), Convert.ToInt32(data[3].ToString()), data[4].ToString(), newBitmapImage, data[6] as byte[],
data[7].ToString(), genres.Value.ToString(), data[8].ToString(), actors.Value.ToString());
if (isAdmin)
{
filmButtons.Add(new filmButton(movie, admin));
filmButtons[countOfFilms] = new filmButton(movie, admin);
}
else
{
filmButtons.Add(new filmButton(movie, user));
filmButtons[countOfFilms] = new filmButton(movie, user);
}
listOfFilms.Children.Add(filmButtons[countOfFilms]);
countOfFilms++;
}
cn.Close();
}
else
{
MessageBox.Show("Ничего не найдено! Проверьте правильность введённых данных.");
}
}
}
public void FillFilms()
{
countOfFilms = 0;
filmNames.Clear();
SqlCommand cmd = new SqlCommand("GetMovieInfo", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
SqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
while (data.Read())
{
BitmapImage newBitmapImage = new BitmapImage();
if (data[5].GetType().ToString() != "System.DBNull")
{
System.IO.MemoryStream ms = new System.IO.MemoryStream(data[5] as byte[]);
ms.Seek(0, System.IO.SeekOrigin.Begin);
newBitmapImage.BeginInit();
newBitmapImage.StreamSource = ms;
newBitmapImage.EndInit();
}
DateTime date = (DateTime)data[2];
SqlParameter genres = Connection.GetSetGenres(data[1].ToString(), cn);
SqlParameter actors = Connection.GetSetActors(data[1].ToString(), cn);
Movie movie = new Movie(data[0].ToString(), data[1].ToString(),
date.ToString("yy/MM/dd"), Convert.ToInt32(data[3].ToString()), data[4].ToString(), newBitmapImage, data[6] as byte[],
data[7].ToString(), genres.Value.ToString(), data[10].ToString(), actors.Value.ToString());
if (isAdmin)
{
filmButtons.Add(new filmButton(movie, admin));
filmButtons[countOfFilms] = new filmButton(movie, admin);
}
else
{
filmButtons.Add(new filmButton(movie, user));
filmButtons[countOfFilms] = new filmButton(movie, user);
}
listOfFilms.Children.Add(filmButtons[countOfFilms]);
countOfFilms++;
}
cn.Close();
}
}
