public CatalogPage(GoodsCategory item, List <string> GoodsNameCart1, List <CartGoods> GoodsCartList1, List <int> GoodsPiece)
{
InitializeComponent();
GoodsNameCart = GoodsNameCart1;
GoodsCartList = GoodsCartList1;
Piece = GoodsPiece;
AddGoodsCategory();
AddGoodsInformation();
AddGoodsImage();
AddGoodsToCatalog();
DisplayDatabase();
GetValueForShopCartInfo(GoodsCartList);
List <Goods> goods1 = GoodsDatabase.GetItemsNotDoneAsync().Result;
List <GoodsCategory> goodscategory1 = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
List <GoodsInformation> goodsinformation1 = GoodsInformationDatabase.GetItemsNotDoneAsync().Result;
List <GoodsImage> goodsimage1 = GoodsImageDatabase.GetItemsNotDoneAsync().Result;
var query = from goods in goods1
join goodscategory in goodscategory1 on goods.GoodsCategoryID equals goodscategory.GoodsCategoryID
where goodscategory.Category == item.Category
join goodsinformation in goodsinformation1 on goods.GoodsInformationID equals goodsinformation.GoodsInformationID
join goodsimage in goodsimage1 on goods.GoodsImageID equals goodsimage.ImageID
select new { Name = goods.Name, Price = goods.Price, Category = goodscategory.Category, Type = goodsinformation.Type, ImageName = goodsimage.ImageName };
GoodsListview.ItemsSource = query;
}
public DetailPage(Goods selectedgoods, List <string> GoodsNameFromCart, List <CartGoods> GoodsFromCart, List <int> PieceList1)
{
InitializeComponent();
GoodsName = GoodsNameFromCart;
GoodsCartList = GoodsFromCart;
PieceList = PieceList1;
GetValueForShopCartInfo(GoodsCartList);
List <Goods> goods1 = GoodsDatabase.GetItemsNotDoneAsync().Result;
Goods goods = new Goods();
for (int i = 0; i < goods1.Count; i++)
{
if (selectedgoods.Name.Equals(goods1[i].Name))
{
goods = goods1[i];
}
}
var category = GoodsCategoryDatabase.GetItemAsync(goods.GoodsCategoryID).Result;
var information = GoodsInformationDatabase.GetItemAsync(goods.GoodsInformationID).Result;
var queryofcatefories = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
var queryofimage = GoodsImageDatabase.GetItemAsync(goods.GoodsImageID).Result;
ListViewOfCategories.ItemsSource = queryofcatefories;
Name.Text = goods.Name;
YearOfRealising.Text = information.YearOfRealising.ToString();
Category.Text = category.Category;
Type.Text = information.Type.ToString();
Price.Text = goods.Price.ToString() + " Kc";
Buy_Button.Tag = goods.Name;
Description.Text = information.Description.ToString();
ImageOfAlbum.Source = new BitmapImage(new Uri($"{queryofimage.ImageName}", UriKind.Relative));
}
private void Search_Click(object sender, RoutedEventArgs e)
{
string SearchWord = Search.Text.ToString();
var queryofsearchingword = GoodsDatabase.GetSearchWord(SearchWord).Result;
List <GoodsCategory> goodscategory1 = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
List <GoodsInformation> goodsinformation1 = GoodsInformationDatabase.GetItemsNotDoneAsync().Result;
List <GoodsImage> goodsimage1 = GoodsImageDatabase.GetItemsNotDoneAsync().Result;
var query = from goods in queryofsearchingword
join goodscategory in goodscategory1 on goods.GoodsCategoryID equals goodscategory.GoodsCategoryID
join goodsinformation in goodsinformation1 on goods.GoodsInformationID equals goodsinformation.GoodsInformationID
join goodsimage in goodsimage1 on goods.GoodsImageID equals goodsimage.ImageID
select new { Name = goods.Name, Price = goods.Price, Category = goodscategory.Category, Type = goodsinformation.Type, ImageName = goodsimage.ImageName };
GoodsListview.ItemsSource = query;
}
private void ListViewOfCategories_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (ListViewOfCategories.SelectedItem != null)
{
var item = ListViewOfCategories.SelectedItem as GoodsCategory;
List <Goods> goods1 = GoodsDatabase.GetItemsNotDoneAsync().Result;
List <GoodsCategory> goodscategory1 = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
List <GoodsInformation> goodsinformation1 = GoodsInformationDatabase.GetItemsNotDoneAsync().Result;
List <GoodsImage> goodsimage1 = GoodsImageDatabase.GetItemsNotDoneAsync().Result;
var query = from goods in goods1
join goodscategory in goodscategory1 on goods.GoodsCategoryID equals goodscategory.GoodsCategoryID
where goodscategory.Category == item.Category
join goodsinformation in goodsinformation1 on goods.GoodsInformationID equals goodsinformation.GoodsInformationID
join goodsimage in goodsimage1 on goods.GoodsImageID equals goodsimage.ImageID
select new { Name = goods.Name, Price = goods.Price, Category = goodscategory.Category, Type = goodsinformation.Type, ImageName = goodsimage.ImageName };
GoodsListview.ItemsSource = query;
}
}
public void AddGoodsCategory()
{
//DisplayDatabase();
Category = new string[] { "Pop", "Punk-Rock", "Rock", "Metal" };
for (int i = 0; i < Category.Length; i++)
{
GoodsCategory category = new GoodsCategory();
category.Category = Category[i];
int count = 0;
foreach (GoodsCategory item in GoodsCategoryDatabase.GetItemsAsync().Result)
{
if (item.Category.Equals(Category[i]))
{
count += 1;
}
}
if (count == 0)
{
GoodsCategoryDatabase.SaveItemAsync(category);
}
}
}
private void DisplayDatabase()
{
List <Goods> goods1 = GoodsDatabase.GetItemsNotDoneAsync().Result;
List <GoodsCategory> goodscategory1 = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
List <GoodsInformation> goodsinformation1 = GoodsInformationDatabase.GetItemsNotDoneAsync().Result;
List <GoodsImage> goodsimage1 = GoodsImageDatabase.GetItemsNotDoneAsync().Result;
var query = from goods in goods1
join goodscategory in goodscategory1 on goods.GoodsCategoryID equals goodscategory.GoodsCategoryID
join goodsinformation in goodsinformation1 on goods.GoodsInformationID equals goodsinformation.GoodsInformationID
join goodsimage in goodsimage1 on goods.GoodsImageID equals goodsimage.ImageID
select new { Name = goods.Name, Price = goods.Price, Category = goodscategory.Category, Type = goodsinformation.Type, ImageName = goodsimage.ImageName };
var queryofcategories = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
Debug.WriteLine(goods1.Count);
foreach (Goods Item in goods1)
{
Debug.WriteLine(Item);
}
GoodsListview.ItemsSource = query;
ListViewOfCategories.ItemsSource = queryofcategories;
}
public void GetJoinedDatatable(string selectedtext)
{
List <Goods> goods1 = new List <Goods>();
if (selectedtext.Equals("dle nazvu"))
{
goods1 = GoodsDatabase.GetGoodsByName().Result;
}
else if (selectedtext.Equals("od nejlevnejsiho"))
{
goods1 = GoodsDatabase.GetGoodsByLowestPrice().Result;
}
else if (selectedtext.Equals("od nejdrazsiho"))
{
goods1 = GoodsDatabase.GetGoodsByHighestPrice().Result;
}
List <GoodsCategory> goodscategory1 = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
List <GoodsInformation> goodsinformation1 = GoodsInformationDatabase.GetItemsNotDoneAsync().Result;
List <GoodsImage> goodsimage1 = GoodsImageDatabase.GetItemsNotDoneAsync().Result;
var query = from goods in goods1
join goodscategory in goodscategory1 on goods.GoodsCategoryID equals goodscategory.GoodsCategoryID
join goodsinformation in goodsinformation1 on goods.GoodsInformationID equals goodsinformation.GoodsInformationID
join goodsimage in goodsimage1 on goods.GoodsImageID equals goodsimage.ImageID
select new { Name = goods.Name, Price = goods.Price, Category = goodscategory.Category, Type = goodsinformation.Type, ImageName = goodsimage.ImageName };
var queryofcategories = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
Debug.WriteLine(goods1.Count);
foreach (Goods Item in goods1)
{
Debug.WriteLine(Item);
}
GoodsListview.ItemsSource = query;
ListViewOfCategories.ItemsSource = queryofcategories;
}
private void OrderBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string value = OrderBox.SelectedItem.ToString();
ComboBoxItem cbi = (ComboBoxItem)OrderBox.SelectedItem;
string selectedText = cbi.Content.ToString();
if (selectedText.Equals("neseřazeno"))
{
}
if (selectedText.Equals("dle nazvu"))
{
GetJoinedDatatable(selectedText);
}
if (selectedText.Equals("od nejlevnejsiho"))
{
GetJoinedDatatable(selectedText);
}
if (selectedText.Equals("od nejdrazsiho"))
{
GetJoinedDatatable(selectedText);
}
if (selectedText.Equals("od nejnovejsiho"))
{
List <Goods> goods1 = GoodsDatabase.GetItemsNotDoneAsync().Result;
List <GoodsCategory> goodscategory1 = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
List <GoodsInformation> goodsinformation1 = GoodsInformationDatabase.GetItemsNotDoneAsync().Result;
List <GoodsImage> goodsimage1 = GoodsImageDatabase.GetItemsNotDoneAsync().Result;
var query = from goods in goods1
join goodscategory in goodscategory1 on goods.GoodsCategoryID equals goodscategory.GoodsCategoryID
join goodsinformation in goodsinformation1 on goods.GoodsInformationID equals goodsinformation.GoodsInformationID
join goodsimage in goodsimage1 on goods.GoodsImageID equals goodsimage.ImageID
orderby goodsinformation.YearOfRealising descending
select new { Name = goods.Name, Price = goods.Price, Category = goodscategory.Category, Type = goodsinformation.Type, ImageName = goodsimage.ImageName };
var queryofcategories = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
Debug.WriteLine(goods1.Count);
foreach (Goods Item in goods1)
{
Debug.WriteLine(Item);
}
GoodsListview.ItemsSource = query;
ListViewOfCategories.ItemsSource = queryofcategories;
}
if (selectedText.Equals("od nejstarsiho"))
{
List <Goods> goods1 = GoodsDatabase.GetItemsNotDoneAsync().Result;
List <GoodsCategory> goodscategory1 = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
List <GoodsInformation> goodsinformation1 = GoodsInformationDatabase.GetItemsNotDoneAsync().Result;
List <GoodsImage> goodsimage1 = GoodsImageDatabase.GetItemsNotDoneAsync().Result;
var query = from goods in goods1
join goodscategory in goodscategory1 on goods.GoodsCategoryID equals goodscategory.GoodsCategoryID
join goodsinformation in goodsinformation1 on goods.GoodsInformationID equals goodsinformation.GoodsInformationID
join goodsimage in goodsimage1 on goods.GoodsImageID equals goodsimage.ImageID
orderby goodsinformation.YearOfRealising
select new { Name = goods.Name, Price = goods.Price, Category = goodscategory.Category, Type = goodsinformation.Type, ImageName = goodsimage.ImageName };
var queryofcategories = GoodsCategoryDatabase.GetItemsNotDoneAsync().Result;
Debug.WriteLine(goods1.Count);
foreach (Goods Item in goods1)
{
Debug.WriteLine(Item);
}
GoodsListview.ItemsSource = query;
ListViewOfCategories.ItemsSource = queryofcategories;
}
}
