private void btnUpdate_Click(object sender, EventArgs e)
{
WarehouseStock stock = ((WarehouseStock)gridStock.SelectedRows[0].Tag);
if (stock == null)
{
return;
}
int count;
if (!Int32.TryParse(tbNumber.Text, out count) || count < 0)
{
return;
}
if (tbNumber.Tag == null)
{
return;
}
int originalCount = (int)tbNumber.Tag;
if (MessageBox.Show(this, "Frissíteni akarja a cikk \"" + stock.WarehouseName + "\" raktárban lévő számát?\nEredeti darabszám: " + originalCount.ToString() +
"\nÚj darabszám: " + count.ToString(),
"Módosítás",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
Stock stockRow = Global.Database.SelectOne <Stock>("stock", new Dictionary <string, object>()
{
{ "ItemID", _stockItemID },
{ "WarehouseID", stock.WarehouseID }
});
if (stockRow == null)
{
Error("Hiba az adatbázis elérése közben!", "Hiba");
return;
}
stockRow.Count = count;
if (Global.Database.Update <Stock>("stock", stockRow))
{
stock.ItemCount = count;
DataGridManager.UpdateRow <WarehouseStock>(gridStock.SelectedRows[0], stock);
DataChanged = true;
tbNumber.Tag = count;
btnUpdate.Enabled = false;
}
else
{
Error("Hiba az adat módosítása közben!", "Hiba");
}
}
}
public ViewList_Window()
{
InitializeComponent();
dataGrid = DataGridManager.Init();
TextBoxSerchViewList.Focus();
}
public Reports_Window()
{
InitializeComponent();
dataGrid = DataGridManager.Init();
TextBoxSerchExel.Focus();
TextBoxSerchHtml.Focus();
}
private void btnAddRow_Click(object sender, EventArgs e)
{
NewRowForm newRowForm = new NewRowForm(this);
if (newRowForm.ShowDialog() == DialogResult.OK)
{
DataGridManager dataManager = new DataGridManager(customDataGridView);
dataManager.AddRow((int)newRowForm.rowPosition.Value, newRowForm.rowContent.Text);
}
}
private void btnAddColumn_Click(object sender, EventArgs e)
{
NewColumnForm newColumnForm = new NewColumnForm(this);
if (newColumnForm.ShowDialog() == DialogResult.OK)
{
DataGridManager dataManager = new DataGridManager(customDataGridView);
dataManager.AddColumn((int)newColumnForm.columnPosition.Value, "New Column");
}
}
private void btnNewPartner_Click(object sender, System.EventArgs e)
{
using (PartnerEditForm edit = new PartnerEditForm())
{
if (edit.ShowDialog(this) == DialogResult.OK)
{
Partner newPartner = edit.EditPartner;
if (Global.Database.InsertInto <Partner>("partner", newPartner))
{
DataGridManager.AddDataGridEntry <Partner>(gridPartners, newPartner);
}
else
{
Error("Hiba a(z) \"" + edit.EditPartner.Name + "\" hozzáadása közben!", "Hiba!");
}
}
}
}
private void btnNewItem_Click(object sender, System.EventArgs e)
{
using (ItemEditForm edit = new ItemEditForm())
{
if (edit.ShowDialog(this) == DialogResult.OK)
{
ItemWithCategory newItem = edit.EditedItem;
if (Global.Database.InsertInto <Item>("item", newItem))
{
DataGridManager.AddDataGridEntry <ItemWithCategory>(gridItems, newItem);
}
else
{
Error("Hiba a(z) \"" + edit.EditedItem.Name + "\" hozzáadása közben!", "Hiba!");
}
}
}
}
private void btnNewWarehouse_Click(object sender, System.EventArgs e)
{
using (WarehouseEditForm whEdit = new WarehouseEditForm())
{
if (whEdit.ShowDialog(this) == DialogResult.OK)
{
Warehouse newWarehouse = whEdit.EditedWarehouse;
if (Global.Database.InsertInto <Warehouse>("warehouse", newWarehouse))
{
DataGridManager.AddDataGridEntry <Warehouse>(gridWarehouse, newWarehouse);
}
else
{
Error("Hiba a \"" + whEdit.EditedWarehouse.Name + "\" hozzáadása közben!", "Hiba!");
}
}
}
}
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 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 LoadPartnersTab()
{
int selectedEntryID = -1;
if (gridPartners.SelectedRows.Count > 0)
{
selectedEntryID = ((Partner)gridPartners.SelectedRows[0].Tag).ID;
}
DataGridManager.AddDataGridEntries <Partner>(gridPartners, Global.Database.SelectAll <Partner>("partner"), true, new Action <DataGridViewRow>(
(DataGridViewRow row) =>
{
Partner sum = (Partner)row.Tag;
if (selectedEntryID != -1 && sum.ID == selectedEntryID)
{
row.Selected = true;
}
}
));
}
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 LoadWarehouseTab()
{
int selectedEntryID = -1;
if (gridWarehouse.SelectedRows.Count > 0)
{
selectedEntryID = ((Warehouse)gridWarehouse.SelectedRows[0].Tag).ID;
}
DataGridManager.AddDataGridEntries <Warehouse>(gridWarehouse, Global.Database.SelectAll <Warehouse>("warehouse"), true, new Action <DataGridViewRow>(
(DataGridViewRow row) =>
{
Warehouse sum = (Warehouse)row.Tag;
if (selectedEntryID != -1 && sum.ID == selectedEntryID)
{
row.Selected = true;
}
}
));
}
private void LoadPartnerShipmentTab()
{
PartnerShipmentSummary selectedEntry = null;
if (gridPartnerShipment.SelectedRows.Count > 0)
{
selectedEntry = ((PartnerShipmentSummary)gridPartnerShipment.SelectedRows[0].Tag);
}
DataGridManager.AddDataGridEntries <PartnerShipmentSummary>(gridPartnerShipment, ComplexQueries.GetPartnerShipmentSummary(), true, new Action <DataGridViewRow>(
(DataGridViewRow row) =>
{
PartnerShipmentSummary sum = (PartnerShipmentSummary)row.Tag;
if (selectedEntry != null && sum.ItemID == selectedEntry.ItemID && sum.PartnerID == selectedEntry.PartnerID && sum.WarehouseID == selectedEntry.WarehouseID && sum.Date == selectedEntry.Date)
{
row.Selected = true;
}
}
));
gridPartnerShipment.Sort(gridPartnerShipment.Columns["colPartnerDate"], ListSortDirection.Ascending);
}
private void gridItems_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.RowIndex >= gridItems.Rows.Count)
{
return;
}
DataGridViewRow row = gridItems.Rows[e.RowIndex];
using (ItemEditForm itemEdit = new ItemEditForm((ItemWithCategory)row.Tag))
{
if (itemEdit.ShowDialog(this) == DialogResult.OK)
{
if (Global.Database.Update <Item>("item", itemEdit.EditedItem))
{
DataGridManager.UpdateRow <ItemWithCategory>(row, itemEdit.EditedItem);
}
else
{
Error("Hiba a(z) \"" + itemEdit.EditedItem.Name + "\" frissítése közben!", "Hiba");
}
}
}
}
private void gridPartners_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.RowIndex >= gridPartners.Rows.Count)
{
return;
}
DataGridViewRow row = gridPartners.Rows[e.RowIndex];
using (PartnerEditForm partnerEdit = new PartnerEditForm((Partner)row.Tag))
{
if (partnerEdit.ShowDialog(this) == DialogResult.OK)
{
if (Global.Database.Update <Partner>("partner", partnerEdit.EditPartner))
{
DataGridManager.UpdateRow <Partner>(row, partnerEdit.EditPartner);
}
else
{
Error("Hiba a(z) \"" + partnerEdit.EditPartner.Name + "\" frissítése közben!", "Hiba");
}
}
}
}
private void gridWarehouse_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0 || e.RowIndex >= gridWarehouse.Rows.Count)
{
return;
}
DataGridViewRow row = gridWarehouse.Rows[e.RowIndex];
using (WarehouseEditForm whEdit = new WarehouseEditForm((Warehouse)row.Tag))
{
if (whEdit.ShowDialog(this) == DialogResult.OK)
{
if (Global.Database.Update <Warehouse>("warehouse", whEdit.EditedWarehouse))
{
DataGridManager.UpdateRow <Warehouse>(row, whEdit.EditedWarehouse);
}
else
{
Error("Hiba a(z) \"" + whEdit.EditedWarehouse.Name + "\" frissítése közben!", "Hiba");
}
}
}
}
public Edit_Window()
{
InitializeComponent();
dataGrid = DataGridManager.Init();
TextBoxSerch.Focus();
}
public User_Window()
{
InitializeComponent();
dataGrid = DataGridManager.Init();
}
public DataGrid(DataGridManager dataGridManager)
{
InitializeComponent();
DataContext = dataGridManager;
dataGridManager.Exit = Close;
}
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());
}
