private void btnUpdate_Click(object sender, EventArgs e)
{
dbClass db = new dbClass();
db.dbUpdate("UPDATE items SET name='" + txtItemName.Text + "', price=" + txtItemPrice.Text + ", owner='" + cmbItemOwner.Text + "', quantity=" + numItemQuantity.Value + ", slot='" + txtItemSlot.Text + "' WHERE id='" + this.uid + "'");
this.Close();
MessageBox.Show("Item Updated with uid: " + this.uid);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
dbClass db = new dbClass();
db.dbUpdate($"UPDATE Owners SET name='{txtOwner.Text}', contact='{txtContact.Text}' WHERE id='{this.uid}'");
this.Close();
MessageBox.Show("Owner Updated!");
}
private void btnAdd_Click(object sender, EventArgs e)
{
dbClass db = new dbClass();
db.dbInsert("INSERT INTO items (name,price,owner,quantity,slot) VALUES ('" + txtItemName.Text + "', " + txtItemPrice.Text + ", '" + cmbItemOwner.Text + "', " + numItemQuantity.Value + ", '" + txtItemSlot.Text + "')");
this.Close();
MessageBox.Show("Item added!");
}
private void cmbItem_SelectedIndexChanged(object sender, EventArgs e)
{
dbClass db = new dbClass();
System.Data.DataTable dt = db.dbSelect($"Select * FROM Items WHERE slot='{cmbSlot.Text}' AND owner='{cmbOwner.Text}' AND name='{cmbItem.Text}'");
this.selectedItemPrice = dt.Rows[0][2].ToString();
lblAvailable.Text = dt.Rows[0][4].ToString();
}
private void button1_Click(object sender, EventArgs e)
{
dbClass db = new dbClass();
db.dbInsert($"INSERT INTO Owners(name, contact) VALUES('{txtOwner.Text}', '{txtContact.Text}')");
this.Close();
MessageBox.Show($"Owner {txtOwner.Text} added!");
}
private void getOwnerList()
{
dbClass db = new dbClass();
System.Data.DataTable owners = db.dbSelect("SELECT id as 'uid', name as 'Owner Name', contact as 'Contact Number' FROM Owners");
dataGridViewOwners.DataSource = owners;
dataGridViewOwners.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewOwners.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewOwners.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void toolStripButton3_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show($"Delete {dataGridViewItems.CurrentRow.Cells[1].Value.ToString()}?", "Confirm", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result.Equals(DialogResult.OK))
{
dbClass db = new dbClass();
db.dbDelete("DELETE FROM Items WHERE id='" + dataGridViewItems.CurrentRow.Cells[0].Value.ToString() + "'");
getItemList();
MessageBox.Show("Item Deleted");
}
}
private void getItemList()
{
dbClass db = new dbClass();
System.Data.DataTable items = db.dbSelect("SELECT id as 'uid', name as 'Item Name', price as 'Price', owner as 'Owner', quantity as 'Quantity', slot as 'Slot Number' FROM Items");
dataGridViewItems.DataSource = items;
dataGridViewItems.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewItems.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewItems.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewItems.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewItems.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridViewItems.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void getOwners()
{
try
{
dbClass db = new dbClass();
System.Data.DataTable dt = db.dbSelect("Select * FROM Owners");
for (int i = 0; i < dt.Rows.Count; i++)
{
cmbItemOwner.Items.Add(dt.Rows[i]["name"]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void getSlot()
{
try
{
dbClass db = new dbClass();
System.Data.DataTable dt = db.dbSelect($"Select * FROM Items");
for (int i = 0; i < dt.Rows.Count; i++)
{
cmbSlot.Items.Add(dt.Rows[i]["slot"]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void getItems()
{
cmbItem.Items.Clear();
try
{
dbClass db = new dbClass();
System.Data.DataTable dt = db.dbSelect($"Select * FROM Items WHERE slot='{cmbSlot.Text}' AND owner='{cmbOwner.Text}'");
for (int i = 0; i < dt.Rows.Count; i++)
{
cmbItem.Items.Add(dt.Rows[i]["name"]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
