private void btnSubmit_Click(object sender, EventArgs e) { if (Checker()) { if (txtItemID.Text != "") { ItemModelEdit item = new ItemModelEdit( Convert.ToInt32(txtItemID.Text), txtItemName.Text, Convert.ToDecimal(txtSelfCost.Text), Convert.ToInt32(cmbItemCategory.SelectedValue) ); SqliteDataAccess.EditItem(item); } else { ItemModelEdit item = new ItemModelEdit( txtItemName.Text, Convert.ToDecimal(txtSelfCost.Text), Convert.ToDecimal(txtItemPrice.Text), Convert.ToInt32(cmbItemCategory.SelectedValue), DateTime.Now ); SqliteDataAccess.CreateItem(item); } } GenerateBarcode(); this.Close(); }
public static void CreateItem(ItemModelEdit item) { using (IDbConnection cnn = new MySqlConnection(LoadConnectionString())) { cnn.Execute("INSERT INTO items (ItemName, ItemBarcode, SelfCost, ItemPrice, ItemCategoryID, ItemAddedDate) " + "VALUES (@ItemName, '', @SelfCost, @ItemPrice, @ItemCategoryID, @ItemAddedDate)", item); } }
public static void EditItem(ItemModelEdit item) { using (IDbConnection cnn = new MySqlConnection(LoadConnectionString())) { cnn.Execute("UPDATE items SET ItemName = @ItemName, " + "SelfCost = @SelfCost, " + "ItemCategoryID = @ItemCategoryID " + "WHERE ItemID = @ItemID ", item); } }