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());
}
