コード例 #1
0
        public void SaveTransaction(Model.Transaction.TransactionDTO transaction)
        {
            if (transaction.CodeTransactionID <= 0)
            {
                throw new Exception($"[{nameof(SaveTransaction)}] {nameof(TransactionDTO.CodeTransactionID)} is mandatory");
            }

            if (transaction.TypeTransactionID <= 0)
            {
                throw new Exception($"[{nameof(SaveTransaction)}] {nameof(TransactionDTO.TypeTransactionID)} is mandatory");
            }

            var newTransaction = new EntityModel.Transaction()
            {
                Amount             = transaction.Amount,
                Date               = transaction.Date.ToString(DATE_FORMAT),
                Description        = transaction.Description,
                CodeTransaction_ID = transaction.CodeTransactionID,
                TypeTransaction_ID = transaction.TypeTransactionID
            };

            contextDB.Transaction.Add(newTransaction);
            contextDB.SaveChanges();

            transaction.ID = (uint)newTransaction.ID;
        }
コード例 #2
0
        public void DeleteTransaction(uint transactionID)
        {
            EntityModel.Transaction transactionToDelete = (from EntityModel.Transaction t
                                                           in contextDB.Transaction
                                                           where t.ID == transactionID
                                                           select t)
                                                          .SingleOrDefault() ?? throw new Exception($"[{nameof(DeleteTransaction)}]: Transaction ID:{transactionID} not found");


            contextDB.Transaction.Remove(transactionToDelete);
            contextDB.SaveChanges();
        }
コード例 #3
0
        public void UpdateTransaction(TransactionDTO transaction)
        {
            EntityModel.Transaction transactionToUpdate = (from EntityModel.Transaction t
                                                           in contextDB.Transaction
                                                           .Include(x => x.TypeTransaction)
                                                           .Include(x => x.CodeTransaction)
                                                           where t.ID == transaction.ID
                                                           select t).SingleOrDefault();

            if (transactionToUpdate == null)
            {
                throw new Exception($"[{nameof(UpdateTransaction)}] Requested transaction not exist in DB. ID:{transaction.ID}");
            }

            transactionToUpdate.Amount             = transaction.Amount;
            transactionToUpdate.Date               = transaction.Date.ToString(DATE_FORMAT);
            transactionToUpdate.CodeTransaction_ID = transaction.CodeTransactionID;
            transactionToUpdate.Description        = transaction.Description;
            transactionToUpdate.TypeTransaction_ID = transaction.TypeTransactionID;

            contextDB.SaveChanges();
        }