private void editButton_Click(object sender, EventArgs e)
{
// get DGV record ID and instantiate new ItemForm with arg
var recordIDValue = Convert.ToInt32(inventoryDataGridView.CurrentRow.Cells[0].Value);
ItemForm editItemForm = new ItemForm(this, recordIDValue);
// Query db to retrieve record that matches ID and populates form
string connStringValue = Data.connString;
string queryString = $"SELECT * FROM Inventory WHERE Id = {recordIDValue}";
SqlConnection conn = new SqlConnection(connStringValue);
conn.Open();
SqlCommand cmd = new SqlCommand(queryString, conn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
string name = reader.GetString(1);
int productNumber = reader.GetInt32(2);
string description = reader.GetString(3);
int quantity = reader.GetInt32(4);
string expirationDate = reader.GetString(5);
editItemForm.nameInput.Text = name;
editItemForm.productNumberInput.Text = productNumber.ToString();
editItemForm.descriptionInput.Text = description;
editItemForm.quantityInput.Text = quantity.ToString();
editItemForm.expirationDateInput.Text = expirationDate;
}
}
conn.Close();
editItemForm.Show();
}
private void UIColorPicker_ButtonClick(object sender, EventArgs e)
{
item.SelectedColor = Value;
item.Translate();
item.SetDPIScale();
ItemForm.Show(this);
}
private void UIComboDataGridView_ButtonClick(object sender, EventArgs e)
{
item.FilterColumnName = FilterColumnName;
item.ShowFilter = ShowFilter;
ItemForm.Size = ItemSize;
item.ShowButtons = true;
item.SetDPIScale();
item.Translate();
ItemForm.Show(this);
}
private void itemDataGridView_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
DataGridViewRow dr = itemDataGridView.SelectedRows[0];
this.Hide();
ItemForm aItemForm = new ItemForm();
aItemForm.itemNameTextBox.Text = dr.Cells["Name"].Value.ToString();
aItemForm.itemIdLabel.Text = dr.Cells["ItemID"].Value.ToString();
aItemForm.Show();
}
public void DataGridView_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (checkIfGridEnableToShowItemForm(Name) && !checkIfDoubleClicedRowsIsHeader(e.RowIndex))
{
int itemId = getItemIdFromRow(e.RowIndex);
var itemForm = new ItemForm(itemId);
if (itemForm != null)
{
itemForm.Show();
}
}
}
private void mnuItem_Click(object sender, EventArgs e)
{
if (itemForm == null || itemForm.IsDisposed)
{
itemForm = new ItemForm();
itemForm.Show();
itemForm.MdiParent = this;
}
else
{
itemForm.Activate();
}
}
private void edit_Click(object sender, EventArgs e)
{
PanelStart panel = Panels.getPanelByName(Panels.PanelsName.PSTART) as PanelStart;
var row = panel.getGridViewItemRow();
if (panel.Visible == true && panel.getGridViewName() == DataGridViewNew.DGVMainDataNames.items.ToString() &&
row != null)
{
var itemId = Int32.Parse(row.Cells[0].Value.ToString());
var form = new ItemForm(itemId);
form.Show();
}
else
{
MessageBox.Show(Utils.GetEnumDescription(Messages.warnings.EDIT), "Warrning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void menu_Clicked(object sender, ToolStripItemClickedEventArgs e)
{
var clicked = e.ClickedItem.Text;
if (clicked == "Podgląd")
{
var itemId = getItemIdFromRow(menuClickedRow);
var itemForm = new ItemForm(itemId);
if (itemForm != null)
{
itemForm.Show();
}
}
else if (clicked == "Usuń")
{
string messageBoxText = String.Format("Czy na pewno chcesz usunąć {0}?",
Rows[menuClickedRow].Cells["name"].Value.ToString());
string caption = "Usuwanie";
MessageBoxButtons button = MessageBoxButtons.YesNo;
DialogResult res = MessageBox.Show(messageBoxText, caption, button);
if (res == DialogResult.Yes)
{
var itemId = getItemIdFromRow(menuClickedRow);
queries.changeItemDeletedById(itemId, true);
Panels.refreshPanelStartGrid();
}
}
else if (clicked == "Przywróć")
{
string messageBoxText = String.Format("Czy na pewno chcesz przywrócić {0}?",
Rows[menuClickedRow].Cells["name"].Value.ToString());
string caption = "Przywracanie";
MessageBoxButtons button = MessageBoxButtons.YesNo;
DialogResult res = MessageBox.Show(messageBoxText, caption, button);
if (res == DialogResult.Yes)
{
var itemId = getItemIdFromRow(menuClickedRow);
queries.changeItemDeletedById(itemId, false);
Panels.refreshPanelBinGrid();
}
}
}
private void control(int action)
{
;
switch (ondeEstou.GetType().Name)
{
case "ProdutoForm":
ProdutoForm produtoForm = new ProdutoForm(action);
produtoForm.Execute(Convert.ToInt32(indice));
produtoForm.Show();
break;
case "IngredienteForm":
IngredienteForm ingredienteForm = new IngredienteForm(action);
ingredienteForm.Execute(Convert.ToInt32(indice));
ingredienteForm.Show();
break;
case "ItemForm":
ItemForm itemForm = new ItemForm(action);
itemForm.Execute(Convert.ToInt32(indice));
itemForm.Show();
break;
}
}
private void detailButton_Click(object sender, EventArgs e)
{
var form = new ItemForm(1, null, new AddressSearcherStub());
form.Show(this);
}
private void UIColorPicker_ButtonClick(object sender, EventArgs e)
{
item.SelectedColor = Value;
ItemForm.Show(this);
}
private void itemFormButton_Click(object sender, EventArgs e)
{
ItemForm aItemForm = new ItemForm();
aItemForm.Show();
}
private void itemSetupToolStripMenuItem_Click(object sender, EventArgs e)
{
ItemForm iForm = new ItemForm();
iForm.Show();
}
private void addButton_Click(object sender, EventArgs e)
{
ItemForm addItemForm = new ItemForm(this, 0);
addItemForm.Show();
}
private void add_Click(object sender, EventArgs e)
{
var form = new ItemForm();
form.Show();
}