private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (var storageContext = new StorageContext())
{
storageContext.Categories.Load();
storageContext.Models.Load();
var categoriesList = storageContext.Categories.Local.ToList();
categoriesList.Insert(0, new Category { Name = "Vælg venligst", CategoryId = -1 });
var modelsList = storageContext.Models.Local.ToList();
modelsList.Insert(0, new Model { Name = "Vælg venligst", ModelId = -1 });
categoryViewSource.Source = categoriesList;
modelViewSource.Source = modelsList;
}
}
private void ComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
using (var storageContext = new StorageContext())
{
storageContext.Types.Load();
var queryCategoryTypes =
from categories in storageContext.Categories
join types in storageContext.Types on categories.CategoryId equals types.CategoryId
where categories.CategoryId == (int)ComboBoxCategory.SelectedValue
select types;
var queryCategoryTypesList = queryCategoryTypes.ToList();
if (queryCategoryTypesList.Count > 0)
queryCategoryTypesList.Insert(0, new Type { Name = "Vælg venligst", TypeId = -1 });
else
queryCategoryTypesList.Insert(0, new Type { Name = "Ingen data", TypeId = -1 });
typeViewSource.Source = queryCategoryTypesList;
}
}
private void ButtonDelete_Click(object sender, RoutedEventArgs e)
{
using (var storageContext = new StorageContext())
{
storageContext.Products.Remove(storageContext.Products.Find(Convert.ToInt32(TextBoxProductNumber.Text)));
storageContext.SaveChanges();
}
Close();
}
private void ButtonSave_Click(object sender, RoutedEventArgs e)
{
bool allRequiredBoxesValidated = true;
if (TextBoxName.Text.Equals(""))
allRequiredBoxesValidated = false;
else if (ComboBoxCategory.SelectedValue.Equals(-1))
allRequiredBoxesValidated = false;
else if (ComboBoxModel.SelectedValue.Equals(-1))
allRequiredBoxesValidated = false;
else if (ComboBoxType.SelectedValue.Equals(-1))
allRequiredBoxesValidated = false;
else if (TextBoxAmount.Text.Equals(""))
allRequiredBoxesValidated = false;
if (allRequiredBoxesValidated)
{
using (var storageContext = new StorageContext())
{
var product = new Product();
if (!TextBoxProductNumber.Text.Equals(""))
{
product = storageContext.Products.Find(Convert.ToInt32(TextBoxProductNumber.Text));
}
else
{
storageContext.Products.Add(product);
}
product.Name = TextBoxName.Text;
product.ModelId = (int)ComboBoxModel.SelectedValue;
product.TypeId = (int)ComboBoxType.SelectedValue;
product.Quantity = Convert.ToInt32(TextBoxAmount.Text);
product.Comment = new TextRange(RichTextBoxComment.Document.ContentStart, RichTextBoxComment.Document.ContentEnd).Text;
storageContext.SaveChanges();
var productsList =
from products in storageContext.Products
orderby products.ProductId descending
select products;
productViewSource.Source = productsList.ToList();
Title = "Se produkt";
UpdateUI();
}
}
}
private void Row_DoubleClick(object sender, MouseButtonEventArgs e)
{
ProductPage productPage = new ProductPage();
DataRowView row = (DataRowView)products_ViewDataGrid.SelectedItems[0];
productPage.Title = "Se produkt";
productPage.UpdateUI();
using (var storageContext = new StorageContext())
{
var product = storageContext.Products.Find(Convert.ToInt32(row["Product_Number"].ToString()));
productPage.TextBoxName.Text = product.Name;
productPage.TextBoxProductNumber.Text = product.ProductId.ToString();
productPage.ComboBoxCategory.SelectedValue = product.Type.CategoryId;
productPage.ComboBoxModel.SelectedValue = product.ModelId;
productPage.ComboBoxType.SelectedValue = product.TypeId;
productPage.TextBoxAmount.Text = product.Quantity.ToString();
productPage.RichTextBoxComment.AppendText(product.Comment);
}
productPage.ShowDialog();
populateView();
}