public void display_inventory_data() { inventory = new classes.Inventory(); string search = cbSearchBy.Text; switch (search) { case "Item": inventory_table = inventory.select_inventory_table("b.item_name", txtSearch.Text); break; case "Brand": inventory_table = inventory.select_inventory_table("b.brand", txtSearch.Text); break; case "Model": inventory_table = inventory.select_inventory_table("b.model", txtSearch.Text); break; case "Department": inventory_table = inventory.select_inventory_table("d.department_name", txtSearch.Text); break; case "Propery Number": inventory_table = inventory.select_inventory_table("a.property_number", txtSearch.Text); break; case "--Search by--": inventory_table = inventory.select_inventory_table(); break; default: inventory_table = inventory.select_inventory_table(); break; } dgvInventory.DataSource = inventory_table; dgvInventory.AutoGenerateColumns = false; if (dgvInventory.Columns.Contains("action") && dgvInventory.Columns["action"].Visible) { } else { DataGridViewButtonColumn button = new DataGridViewButtonColumn(); { button.Name = "action"; button.HeaderText = "ACTION"; button.Text = "VIEW ITEM"; button.UseColumnTextForButtonValue = true; this.dgvInventory.Columns.Add(button); } } }
private void btnDelete_Click(object sender, EventArgs e) { DialogResult res = MessageBox.Show("Are you sure you want to delete this item?", "Inventory", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (res == System.Windows.Forms.DialogResult.Yes) { inventory = new classes.Inventory(); if (inventory.delete_inventory(this.inventory_id)) { MessageBox.Show("Item has been deleted!", "Inventory", MessageBoxButtons.OK, MessageBoxIcon.Question); this.Close(); } } }
public void display_selected_inventory(int inventory_id) { this.inventory_id = inventory_id; inventory = new classes.Inventory(); selected_inventory_table = inventory.select_selected_inventory(inventory_id); foreach (DataRow row in selected_inventory_table.Rows) { category_id = Convert.ToInt32(row["category_id"]); supplier_id = Convert.ToInt32(row["supplier_id"]); department_id = Convert.ToInt32(row["department_id"]); productinformation_id = Convert.ToInt32(row["productinformation_id"]); acquired_at = Convert.ToDateTime(row["acquired_at"]); status = row["status"].ToString(); property_number = row["property_number"].ToString(); inventory_type = row["type_name"].ToString(); category_name = row["category_name"].ToString(); business_type_id = Convert.ToInt32(row["business_type_id"]); supplier_name = row["supplier_name"].ToString(); department_name = row["department_name"].ToString(); item_name = row["item_name"].ToString(); description = row["description"].ToString(); brand = row["brand"].ToString(); model = row["model"].ToString(); serial_number = row["serial_number"].ToString(); capacity_id = (row["capacity_id"] == DBNull.Value) ? 0 : Convert.ToInt32(row["capacity_id"]); stocks_id = Convert.ToInt32(row["stocks_id"]); expire_at = (row["expire_at"] == DBNull.Value) ? DateTime.MinValue : Convert.ToDateTime(row["expire_at"]); business_type = row["business_type"].ToString(); quantity = Convert.ToInt32(row["quantity"]); unit_of_measurement = row["unit"].ToString(); capacity = (row["capacity"] == DBNull.Value) ? 0 : Convert.ToInt32(row["capacity"]); capacity_size = (row["size"] == DBNull.Value) ? "" : row["size"].ToString(); } set_preview(); }
public void display_inventory_information() { inventory = new classes.Inventory(); var result = inventory.select_inventory_count(); total = result.Item1; working = result.Item2; defective = result.Item3; condemned = result.Item4; inventory_department_table = inventory.select_inventory_per_department(); inventory_report_count_table = inventory.select_inventory_report_count(); display_inventory_count(); display_inventory_per_department(); display_inventory_report_count(); display_ipd_chart(); display_irc_chart(); }
private void btnSave_Click(object sender, EventArgs e) { //MessageBox.Show(quantity.ToString() + " " + unit_of_measurement); classes.Inventory_Stocks stocks = new classes.Inventory_Stocks(); stocks.quantity = quantity; stocks.unit_of_measurement = unit_of_measurement; if (stocks.create_stocks()) { if (hasCapacity == true) { classes.Inventory_Capacity cp = new classes.Inventory_Capacity(); cp.capacity = capacity; cp.capacity_size = capacity_size; cp.create_capacity(); } classes.Inventory_ProductInformation pi = new classes.Inventory_ProductInformation(); pi.inventory_type = inventory_type; pi.item_name = item_name; pi.description = description; pi.brand = brand; pi.model = model; pi.serial_number = serial_number; pi.hasCapacity = hasCapacity; pi.expire_at = date_expired; if (pi.create_product_information()) { classes.Inventory inv = new classes.Inventory(); inv.category_id = category_id; inv.category_name = category_name; inv.supplier_id = supplier_id; inv.supplier_name = supplier_name; inv.property_number = property_number; inv.department_id = department_id; inv.department_name = department_name; inv.status = status; inv.date_acquired = date_acquired; if (inv.create_inventory()) { MessageBox.Show(item_name + " has been added", "Inventory", MessageBoxButtons.OK, MessageBoxIcon.Information); admin.inv.ucInventory.instance.display_inventory_data(); ((Form)this.TopLevelControl).Close(); } else { return; } } else { return; } } else { return; } }