/// <summary>
/// Поиск в таблице фильмов
/// </summary>
/// <param name="type">столбец</param>
/// <param name="param">значение</param>
/// <param name="viewedType">просмотрено ли</param>
/// <returns></returns>
public IList <Film> SearchTableFilms(string type, string param, ViewedType viewedType)
{
IQuery query;
switch (viewedType)
{
case ViewedType.Full:
query = Singleton.Instance.OpenSession().CreateQuery("SELECT f FROM Film f WHERE f." + type + " :param");
if (type.Contains("Rating"))
{
query.SetParameter("param", float.Parse(param));
}
else
{
query.SetParameter("param", param);
}
return(query.List <Film>());
case ViewedType.TRUE:
query = Singleton.Instance.OpenSession().CreateQuery("SELECT f FROM Film f WHERE f." + type + " :param AND f.Viewed = true");
if (type.Contains("Rating"))
{
query.SetParameter("param", float.Parse(param));
}
else
{
query.SetParameter("param", param);
}
return(query.List <Film>());
case ViewedType.FALSE:
query = Singleton.Instance.OpenSession().CreateQuery("SELECT f FROM Film f WHERE f." + type + " :param AND f.Viewed = false");
if (type.Contains("Rating"))
{
query.SetParameter("param", float.Parse(param));
}
else
{
query.SetParameter("param", param);
}
return(query.List <Film>());
}
return(null);
}
private void ButtonAddClick(object sender, EventArgs e)
{
try
{
Form form;
switch (ViewedType.Name)
{
case nameof(AircraftWorkerCategory):
form = new AircraftWorkerCategoryForm(new AircraftWorkerCategory());
break;
case nameof(Product):
form = new ProductForm(new Product());
break;
case nameof(AccessoryRequired):
form = new KitForm(new AccessoryRequired());
break;
default:
{
var ci = ViewedType.GetConstructor(Type.EmptyTypes);
var item = (BaseEntityObject)ci.Invoke(null);
form = new CommonEditorForm(item);
break;
}
}
if (form.ShowDialog() == DialogResult.OK)
{
itemsListView.Items[itemsListView.Items.IndexOf(itemsListView.SelectedItems[0])] =
new ListViewItem(GetListViewSubItems(SelectedItem), null)
{
Tag = SelectedItem
};
}
}
catch (Exception ex)
{
Program.Provider.Logger.Log("Error while building new object", ex);
return;
}
}
private void ButtonAddClick(object sender, EventArgs e)
{
try
{
Form form;
if (ViewedType.Name == typeof(AircraftWorkerCategory).Name)
{
form = new AircraftWorkerCategoryForm(new AircraftWorkerCategory());
}
else if (ViewedType.Name == typeof(AccessoryDescription).Name)
{
form = new AccessoryDescriptionForm(new AccessoryDescription());
}
else if (ViewedType.Name == typeof(AccessoryRequired).Name)
{
form = new KitForm(new AccessoryRequired());
}
else
{
ConstructorInfo ci = ViewedType.GetConstructor(new Type[0]);
BaseEntityObject item = (BaseEntityObject)ci.Invoke(null);
form = new CommonEditorForm(item);
}
if (form.ShowDialog() == DialogResult.OK)
{
itemsListView.Items[itemsListView.Items.IndexOf(itemsListView.SelectedItems[0])] =
new ListViewItem(GetListViewSubItems(SelectedItem), null)
{
Tag = SelectedItem
};
}
}
catch (Exception ex)
{
Program.Provider.Logger.Log("Error while building new object", ex);
return;
}
}
public IList <Film> SearchFilmsCascade(int Id_param, Subtable subtable, ViewedType viewedType)
{
IQuery query;
switch (subtable)
{
case Subtable.Ganres:
switch (viewedType)
{
case ViewedType.Full:
query = Singleton.Instance.OpenSession().CreateQuery(
"SELECT f FROM Film f " +
"WHERE f.Id IN (SELECT fg.Id_Film FROM Films_Genres fg WHERE fg.Id_Genres = :param)");
query.SetParameter("param", Id_param);
return(query.List <Film>());
case ViewedType.TRUE:
query = Singleton.Instance.OpenSession().CreateQuery(
"SELECT f FROM Film f " +
"WHERE f.Id IN (SELECT fg.Id_Film FROM Films_Genres fg WHERE fg.Id_Genres = :param) " +
"AND f.Viewed = true");
query.SetParameter("param", Id_param);
return(query.List <Film>());
case ViewedType.FALSE:
query = Singleton.Instance.OpenSession().CreateQuery(
"SELECT f FROM Film f " +
"WHERE f.Id IN (SELECT fg.Id_Film FROM Films_Genres fg WHERE fg.Id_Genres = :param) " +
"AND f.Viewed = false");
query.SetParameter("param", Id_param);
return(query.List <Film>());
}
break;
case Subtable.Actors:
switch (viewedType)
{
case ViewedType.Full:
query = Singleton.Instance.OpenSession().CreateQuery(
"SELECT f FROM Film f " +
"WHERE f.Id IN (SELECT fa.Id_Film FROM Films_Actors fa WHERE fa.Id_Actors = :param)");
query.SetParameter("param", Id_param);
return(query.List <Film>());
case ViewedType.TRUE:
query = Singleton.Instance.OpenSession().CreateQuery(
"SELECT f FROM Film f " +
"WHERE f.Id IN (SELECT fa.Id_Film FROM Films_Actors fa WHERE fa.Id_Actors = :param) " +
"AND f.Viewed = true");
query.SetParameter("param", Id_param);
return(query.List <Film>());
case ViewedType.FALSE:
query = Singleton.Instance.OpenSession().CreateQuery(
"SELECT f FROM Film f " +
"WHERE f.Id IN (SELECT fa.Id_Film FROM Films_Actors fa WHERE fa.Id_Actors = :param) " +
"AND f.Viewed = false");
query.SetParameter("param", Id_param);
return(query.List <Film>());
}
break;
default:
break;
}
/*
* SELECT* from Films WHERE Films.Id IN(SELECT fg.Фильм FROM films_genres fg WHERE fg.Жанр = '2')
*
* */
return(null);
}
