private void btnRevertPShipment_Click(object sender, EventArgs e) { if (MessageBox.Show(this, "Biztosan vissza akarja vonni a szállítmányt?", "Biztos?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } DataGridViewRow row = gridPartnerShipment.SelectedRows[0]; PartnerShipmentSummary shipment = (PartnerShipmentSummary)row.Tag; switch (ComplexQueries.RevertPartnerShipment(shipment)) { case ComplexQueries.ShipmentStatus.DatabaseError: Error("Adatbázis hiba!", "Hiba"); break; case ComplexQueries.ShipmentStatus.InvalidItemCount: Error("A cél raktárban nincs elég a cikkből, hogy csökkenteni lehessen!", "Hiba"); break; case ComplexQueries.ShipmentStatus.OK: LoadStockTab(); LoadPartnerShipmentTab(); Info("Szállítmány visszavonva!", "Kész"); break; } }
private void cbItem_SelectedIndexChanged(object sender, EventArgs e) { cbFrom.SelectedIndex = -1; cbTo.SelectedIndex = -1; cbFrom.Items.Clear(); cbTo.Items.Clear(); if (cbItem.SelectedIndex > -1) { List <WarehouseStock> stock = ComplexQueries.GetItemStock(((Item)cbItem.Items[cbItem.SelectedIndex]).ID); int[] ids = stock.Select(x => x.WarehouseID).ToArray(); List <Warehouse> emptyWarehouse = _allWarehouse.Where(x => !ids.Contains(x.ID)).ToList(); if (stock != null && stock.Count > 0) { stock = stock.OrderBy(s => s.WarehouseName).ToList(); foreach (WarehouseStock s in stock) { if (s.ItemCount <= 0) { continue; } cbFrom.Items.Add(s); cbTo.Items.Add(s); } } if (emptyWarehouse != null && emptyWarehouse.Count > 0) { emptyWarehouse = emptyWarehouse.OrderBy(s => s.Name).ToList(); foreach (Warehouse s in emptyWarehouse) { cbFrom.Items.Add(new EmptyWarehouseStock() { WarehouseID = s.ID, WarehouseName = s.Name }); cbTo.Items.Add(new EmptyWarehouseStock() { WarehouseID = s.ID, WarehouseName = s.Name }); } } cbFrom.Enabled = cbTo.Enabled = (cbFrom.Items.Count > 0); } else { cbFrom.Enabled = cbTo.Enabled = false; } }
private void btnNewPShipment_Click(object sender, EventArgs e) { using (NewPartnerShipmentForm newPartnerShipment = new NewPartnerShipmentForm()) { if (newPartnerShipment.ShowDialog(this) == DialogResult.OK) { PartnerShipment pshipment = newPartnerShipment.NewShipment; if (!Global.Database.InsertInto <PartnerShipment>("partnershipment", pshipment)) { Error("Hiba a szállítmány létrehozása közben!", "Hiba"); return; } PartnerShipmentSummary newSummary = ComplexQueries.GetPartnerShipmentSummary(pshipment); if (newSummary == null) { Error("Hiba a szállítmány létrehozása közben!", "Hiba"); return; } switch (ComplexQueries.DoPartnerShipment(newSummary)) { case ComplexQueries.ShipmentStatus.DatabaseError: Error("Adatbázis hiba!", "Hiba"); break; case ComplexQueries.ShipmentStatus.InvalidItemCount: Error("Nincs elég a szállított tárgyból a raktárban!", "Hiba"); break; case ComplexQueries.ShipmentStatus.OK: DataGridManager.AddDataGridEntry <PartnerShipmentSummary>(gridPartnerShipment, newSummary); LoadStockTab(); break; } } } }
private void StockManagerForm_Load(object sender, System.EventArgs e) { SuspendLayout(); { //Fejléc Item item = Global.Database.SelectOne <Item>("item", new Dictionary <string, object>() { { "ID", _stockItemID } }); if (item != null) { this.Text = "Készlet - \"" + item.Name + "\""; } //Adat DataGridManager.AddDataGridEntries <WarehouseStock>(gridStock, ComplexQueries.GetItemStock(_stockItemID)); gridStock.Focus(); } ResumeLayout(); }
private void LoadStockTab() { int selectedEntryID = -1; if (gridStock.SelectedRows.Count > 0) { selectedEntryID = ((StockSummary)gridStock.SelectedRows[0].Tag).ItemID; } DataGridManager.AddDataGridEntries <StockSummary>(gridStock, ComplexQueries.GetStockSummary(), true, new Action <DataGridViewRow>( (DataGridViewRow row) => { StockSummary sum = (StockSummary)row.Tag; if (selectedEntryID != -1 && sum.ItemID == selectedEntryID) { row.Selected = true; } } )); }
private void LoadItemsTab() { int selectedEntryID = -1; if (gridItems.SelectedRows.Count > 0) { selectedEntryID = ((ItemWithCategory)gridItems.SelectedRows[0].Tag).ID; } DataGridManager.AddDataGridEntries <ItemWithCategory>(gridItems, ComplexQueries.GetItemsWithCategories(), true, new Action <DataGridViewRow>( (DataGridViewRow row) => { ItemWithCategory sum = (ItemWithCategory)row.Tag; if (selectedEntryID != -1 && sum.ID == selectedEntryID) { row.Selected = true; } } )); }
private void LoadShipmentTab() { ShipmentSummary selectedEntry = null; if (gridShipment.SelectedRows.Count > 0) { selectedEntry = ((ShipmentSummary)gridShipment.SelectedRows[0].Tag); } DataGridManager.AddDataGridEntries <ShipmentSummary>(gridShipment, ComplexQueries.GetShipmentSummary(), true, new Action <DataGridViewRow>( (DataGridViewRow row) => { ShipmentSummary sum = (ShipmentSummary)row.Tag; if (selectedEntry != null && sum.ItemID == selectedEntry.ItemID && sum.WarehouseFrom == selectedEntry.WarehouseFrom && sum.WarehouseTo == selectedEntry.WarehouseTo && sum.Date == selectedEntry.Date) { row.Selected = true; } } )); gridShipment.Sort(gridShipment.Columns["colDate"], ListSortDirection.Ascending); }
private void btnStat3_Click(object sender, EventArgs e) { DataGridManager.AddDataGridEntries <WarehouseStockStatistics>(gridStat3, ComplexQueries.GetWarehouseStatistics()); }
private void btnStat2_Click(object sender, EventArgs e) { DataGridManager.AddDataGridEntries <PartnerBuyStatistics>(gridStat2, ComplexQueries.GetPartnerBuyStatistics()); }