public void CreateItem() { MySqlTransaction transaction = null; try { using (MySqlConnection connection = this._connection.GetConnection()) { using (transaction = connection.BeginTransaction()) { ItemRepository itemRepository = new ItemRepository(this._connection, this._items); switch (ItemExist()) { case true: Console.WriteLine("Item exist."); itemRepository.UpdateItem(); Console.WriteLine("Item Quantity Updated."); break; case false: Console.WriteLine("New Item."); itemRepository.InsertItem(); Console.WriteLine("Item Details Created."); break; default: break; } this._receipt.ItemId = itemRepository.LastInsertID; ReceiptRepository receiptRepository = new ReceiptRepository(this._connection, this._receipt); receiptRepository.InsertReceipt(); Console.WriteLine("Item receipts saved"); if (_items.HasSerial == 1) { SerialRepository serialRepository = new SerialRepository(this._connection, _serial_list); serialRepository.InsertSerial(); Console.WriteLine("Serial Numbers saved."); } Console.WriteLine("Commit to DB"); transaction.Commit(); } } } catch (MySqlException ex) { transaction.Rollback(); throw new ArgumentException(ex.ToString()); } catch (Exception ex) { throw new ArgumentException(ex.Source); } }
private void CreateItemDetails() { itemRepository = new ItemRepository(_items); switch (itemRepository.itemExist()) { case true: itemRepository.UpdateItem(); break; case false: itemRepository.InsertItem(); break; default: // break; } }
private void btn_update_Click(object sender, EventArgs e) { try { Items items = new Items() { Id = _item_id, CategoryId = int.Parse(metroComboBox1.SelectedValue.ToString()), SubCategoryId = int.Parse(metroComboBox2.SelectedValue.ToString()), Model = txt_model.Text, Brand = txt_brand.Text }; ItemRepository itemRepository = new ItemRepository(items); itemRepository.UpdateItem(); MessageBox.Show("Changes Has Been Saved"); _item_list.Items(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }