private void CbItemTypes_SelectedIndexChanged(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
DataTable dt = sQLclass.GetAllTypeItems(cbItemTypes.SelectedValue.ToString());
dgvItems.DataSource = dt;
}
private void InventoryHistory_Load(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
DataTable dt = sQLclass.GetInventoryHistory();
dgvHistory.DataSource = dt;
}
private void refreshGrid()
{
SQLclass sQLclass = new SQLclass();
DataTable dt = sQLclass.GetAllItems();
dgvItems.DataSource = dt;
}
private void InventoryCheckItems_Load(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
DataTable dt = sQLclass.GetAllItemsTypes();
cbItemTypes.DataSource = dt;
cbItemTypes.ValueMember = "Type";
cbItemTypes.DisplayMember = "Description";
}
private void BtnRemove_Click(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
sQLclass.RemoveItem(Int32.Parse(dgvItems.SelectedRows[0].Cells[0].Value.ToString()));
refreshGrid();
MessageBox.Show("Item removed");
}
private void BtnModify_Click(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
sQLclass.ModifyItemQuantity(tbItemId.Text, Int32.Parse(tbQuantity.Text));
tbItemId.Text = "";
tbQuantity.Text = "";
refreshGrid();
}
private void BtnAddItem_Click(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
sQLclass.AddItem(tbItem.Text, cbType.SelectedValue.ToString(), Int32.Parse(tbQuantity.Text));
MessageBox.Show(tbItem.Text + " Added");
tbItem.Text = "";
tbQuantity.Text = "";
}
private void BtnAddItemType_Click(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
sQLclass.AddItemType(tbItemType.Text, tbDescription.Text);
MessageBox.Show("Item Type Added");
refreshgrid();
tbItemType.Text = "";
tbDescription.Text = "";
}
private void InventoryAdd_Load(object sender, EventArgs e)
{
SQLclass sQLclass = new SQLclass();
DataTable dt = sQLclass.GetAllItemsTypes();
if (dt.Rows.Count == 0)
{
MessageBox.Show("No item types found. Add item types first before adding items");
this.Close();
}
cbType.DataSource = dt;
cbType.ValueMember = "Type";
cbType.DisplayMember = "Description";
AcceptButton = btnAddItem;
}