private async void SaveInventoryHeaderButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dbCtx = new DBContext())
{
InventoryHeader inventoryHeader = dbCtx.InventoryHeaders.First(x => x.DocumentID == DocumentIDTb.Text);
dbCtx.Attach(inventoryHeader);
var warehouse = WarehouseNameCb.SelectedItem as Warehouse;
if (warehouse != null)
{
inventoryHeader.DocumentID = DocumentIDTb.Text;
inventoryHeader.Description = DescriptionTb.Text;
inventoryHeader.InventoryDate = Convert.ToDateTime(InventoryDateDP.Date.ToString());
inventoryHeader.WarehouseName = warehouse.WarehouseName;
string errorMsg = InvMgt.isInventoryHeaderValid(inventoryHeader);
if (String.IsNullOrEmpty(errorMsg))
{
dbCtx.SaveChanges();
this.Frame.Navigate(typeof(MainPage), "BackToInventoryHeaderList");
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
}
}
private async void SaveReleaseHeaderButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dbCtx = new DBContext())
{
ReleaseHeader releaseHeader = dbCtx.ReleaseHeaders.First(x => x.DocumentID == DocumentIDTb.Text);
dbCtx.Attach(releaseHeader);
var customer = CustomerIDCb.SelectedItem as Customer;
if (customer != null)
{
releaseHeader.DocumentID = DocumentIDTb.Text;
releaseHeader.Description = DescriptionTb.Text;
releaseHeader.ReleaseDate = Convert.ToDateTime(ReleaseDateDP.Date.ToString());
releaseHeader.CustomerID = customer.CustomerID;
string errorMsg = InvMgt.isReleaseHeaderValid(releaseHeader);
if (String.IsNullOrEmpty(errorMsg))
{
dbCtx.SaveChanges();
this.Frame.Navigate(typeof(MainPage), "BackToReleaseHeaderList");
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
}
}
private async void DeleteEditButton_Click(object sender, RoutedEventArgs e)
{
Item item;
using (DBContext dbCtx = new DBContext())
{
item = dbCtx.Items.First(x => x.ItemID == ItemIDTb.Text);
}
string errorMsg = InvMgt.isItemAvaibleToDelete(item);
if (String.IsNullOrEmpty(errorMsg))
{
using (DBContext dbCtx = new DBContext())
{
dbCtx.Items.Remove(item);
dbCtx.SaveChanges();
this.Frame.Navigate(typeof(MainPage), "BackToItemList");
}
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
}
}
private async void DeleteEditButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dBCtx = new DBContext())
{
if (!dBCtx.Warehouses.Any(x => x.WarehouseName == WarehouseNameTb.Text))
{
Warehouse warehouse = dBCtx.Warehouses.Single(x => x.WarehouseName == WarehouseNameTb.Text);
string errorMsg = InvMgt.isWarehouseAvaibleToDelete(warehouse);
if (String.IsNullOrEmpty(errorMsg))
{
dBCtx.Warehouses.Remove(warehouse);
dBCtx.SaveChanges();
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
}
this.Frame.Navigate(typeof(MainPage), "BackToWarehousesList");
}
private async void SaveEditButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dbCtx = new DBContext())
{
Item item = dbCtx.Items.First(x => x.ItemID == ItemIDTb.Text);
dbCtx.Attach(item);
var cat = CategorySelectCb.SelectedItem as Category;
if (cat != null)
{
item.Name = NameTb.Text;
item.Description = DescriptionTb.Text;
item.CategoryID = cat.CategoryID;
string IsValidMsg = InvMgt.isItemValid(item);
if (String.IsNullOrEmpty(IsValidMsg))
{
dbCtx.SaveChanges();
this.Frame.Navigate(typeof(MainPage), "BackToItemList");
}
else
{
MessageDialog message = new MessageDialog(IsValidMsg, "Operacja przerwana");
await message.ShowAsync();
}
}
}
}
private async void SaveEditButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dbCtx = new DBContext())
{
Vendor vendor = dbCtx.Vendors.First(x => x.VendorID == VendorIDTb.Text);
dbCtx.Attach(vendor);
if (vendor != null)
{
vendor.Name = NameTb.Text;
vendor.Address = AddressTb.Text;
vendor.City = CityTb.Text;
vendor.Country = CountryTb.Text;
string IsValidMsg = InvMgt.isVendorValid(vendor);
if (String.IsNullOrEmpty(IsValidMsg))
{
dbCtx.SaveChanges();
this.Frame.Navigate(typeof(MainPage), "BackToVendorList");
}
else
{
MessageDialog message = new MessageDialog(IsValidMsg, "Operacja przerwana. Nie wszystkie dane zostały wprowadzone");
await message.ShowAsync();
}
}
}
}
private async void DeleteEditButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dBCtx = new DBContext())
{
if (!dBCtx.Categories.Any(x => x.CategoryID == CategoryTb.Text))
{
Category category = dBCtx.Categories.Single(x => x.CategoryID == CategoryTb.Text);
string errorMsg = InvMgt.isCategoryValid(category);
if (String.IsNullOrEmpty(errorMsg))
{
dBCtx.Categories.Remove(category);
dBCtx.SaveChanges();
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
}
this.Frame.Navigate(typeof(MainPage), "BackToCategoriesList");
}
private async void SaveReleaseLineButton_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(QuantityTb.Text))
{
MessageDialog message = new MessageDialog("Nie podano ilości.", "Operacja przerwana");
await message.ShowAsync();
return;
}
var Itm = ItemIDCb.SelectedItem as Item;
var ISKU = StockKeepUnitCb.SelectedItem as ItemStockKeepUnit;
var MagNr = WarehouseNameCb.SelectedItem as Warehouse;
var MagPl = WarehousePlaceCb.SelectedItem as WarehousePlace;
if (Itm == null)
{
MessageDialog message = new MessageDialog("Nie wybrano produktu", "Operacja przerwana");
await message.ShowAsync();
return;
}
if (ISKU == null)
{
MessageDialog message = new MessageDialog("Nie wybrano jednostki.", "Operacja przerwana");
await message.ShowAsync();
return;
}
using (DBContext dbCtx = new DBContext())
{
int position = 0;
if (dbCtx.ReleaseLines.Any(x => x.DocumentID == DocumentIDTb.Text))
{
position = dbCtx.ReleaseLines.Last(x => x.DocumentID == DocumentIDTb.Text).PositionNumber + 1;
}
else
{
position = 1;
}
releaseLine = new ReleaseLine(DocumentIDTb.Text, position, Itm.ItemID, ISKU.Code, MagNr.WarehouseName, MagPl.WarehousePlaceName, Convert.ToDouble(QuantityTb.Text));
string errorMsg = InvMgt.isReleaseLineValid(releaseLine);
if (String.IsNullOrEmpty(errorMsg))
{
dbCtx.ReleaseLines.Add(releaseLine);
dbCtx.SaveChanges();
this.Frame.Navigate(typeof(ReleaseHeaderPage), releaseHeader);
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
}
private async void PostByButton_Click(object sender, RoutedEventArgs e)
{
string errorMsg = InvMgt.PostInventory(inventoryHeader);
if (!String.IsNullOrEmpty(errorMsg))
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
}
else
{
this.Frame.Navigate(typeof(MainPage), "BackToInventoryHeaderList");
}
}
private async void PostReleaseHeaderButton_Click(object sender, RoutedEventArgs e)
{
string errorMsg = null;
errorMsg = InvMgt.postReleaseHeader(releaseHeader);
if (!String.IsNullOrEmpty(errorMsg))
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
BindReleaseLineList();
}
private async void AddWPToListButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dBCtx = new DBContext())
{
WarehousePlace warehousePlace = new WarehousePlace(WarehouseNameTb.Text, WarehousePlaceTb.Text);
string errorMsg = InvMgt.isWarehousePlaceValid(warehousePlace);
if (String.IsNullOrEmpty(errorMsg))
{
dBCtx.WarehousePlaces.Add(warehousePlace);
dBCtx.SaveChanges();
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
}
}
BindList();
}
private async void DeleteWP_Click(object sender, RoutedEventArgs e)
{
Button DeleteWP = (Button)sender;
string errorMsg = InvMgt.isWarehousePlaceAvaibleToDelete((WarehousePlace)DeleteWP.DataContext);
using (DBContext dBCtx = new DBContext())
{
if (String.IsNullOrEmpty(errorMsg))
{
dBCtx.WarehousePlaces.Remove((WarehousePlace)DeleteWP.DataContext);
dBCtx.SaveChanges();
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
BindList();
}
private async void SaveEditButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dBCtx = new DBContext())
{
if (!dBCtx.Categories.Any(x => x.CategoryID == CategoryTb.Text))
{
Warehouse warehouse = (Warehouse)WarehouseCb.SelectedItem;
WarehousePlace warehousePlace = (WarehousePlace)WarehousePlaceCb.SelectedItem;
Category category = new Category(CategoryTb.Text, DescriptionTb.Text, warehouse.WarehouseName, warehousePlace.WarehousePlaceName);
string errorMsg = InvMgt.isCategoryValid(category);
if (String.IsNullOrEmpty(errorMsg))
{
dBCtx.Categories.Add(category);
dBCtx.SaveChanges();
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
else
{
Warehouse warehouse = (Warehouse)WarehouseCb.SelectedItem;
WarehousePlace warehousePlace = (WarehousePlace)WarehousePlaceCb.SelectedItem;
Category category = dBCtx.Categories.Single(x => x.CategoryID == CategoryTb.Text);
dBCtx.Attach(category);
category.Description = DescriptionTb.Text;
category.DefaultWarehouse = warehouse.WarehouseName;
category.DefaultWarehousePlace = warehousePlace.WarehousePlaceName;
dBCtx.SaveChanges();
}
this.Frame.Navigate(typeof(MainPage), "BackToCategoriesList");
}
}
private async void AddReceiveLineButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dbCtx = new DBContext())
{
ReceiveHeader receiveHeader = dbCtx.ReceiveHeaders.First(x => x.DocumentID == DocumentIDTb.Text);
dbCtx.Attach(receiveHeader);
var vendor = VendorIDCb.SelectedItem as Vendor;
if (vendor != null)
{
receiveHeader.DocumentID = DocumentIDTb.Text;
receiveHeader.Description = DescriptionTb.Text;
receiveHeader.ReceiveDate = Convert.ToDateTime(ReceiveDateDP.Date.ToString());
receiveHeader.VendorID = vendor.VendorID;
string errorMsg = InvMgt.isReceiveHeaderValid(receiveHeader);
if (String.IsNullOrEmpty(errorMsg))
{
dbCtx.SaveChanges();
Frame.Navigate(typeof(ReceiveLineAddPage), new ReceiveLine(receiveHeader.DocumentID));
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
else
{
MessageDialog message = new MessageDialog("Nie wybrano sprzedawcy", "Operacja przerwana");
await message.ShowAsync();
return;
}
}
}
private async void SaveEditButton_Click(object sender, RoutedEventArgs e)
{
using (DBContext dBCtx = new DBContext())
{
Warehouse warehouse = new Warehouse();
warehouse.WarehouseName = WarehouseNameTb.Text;
warehouse.Description = DescriptionTb.Text;
warehouse.Address = AddressTb.Text;
string errorMsg = InvMgt.IsWarehouseValid(warehouse);
if (String.IsNullOrEmpty(errorMsg))
{
if (!dBCtx.Warehouses.Any(x => x.WarehouseName == WarehouseNameTb.Text))
{
dBCtx.Warehouses.Add(warehouse);
dBCtx.SaveChanges();
this.Frame.Navigate(typeof(MainPage), "BackToWarehousesList");
}
else
{
warehouse = dBCtx.Warehouses.Single(x => x.WarehouseName == WarehouseNameTb.Text);
dBCtx.Attach(warehouse);
warehouse.Description = DescriptionTb.Text;
warehouse.Address = AddressTb.Text;
dBCtx.SaveChanges();
}
}
else
{
MessageDialog message = new MessageDialog(errorMsg, "Operacja przerwana");
await message.ShowAsync();
return;
}
}
this.Frame.Navigate(typeof(MainPage), "BackToWarehousesList");
}
