public static CodeTransactionDTO ToCodeTransactionDTO(this MCodeTransaction entityCodeTransaction) { return((entityCodeTransaction == null) ? new CodeTransactionDTO() : new CodeTransactionDTO() { ID = entityCodeTransaction.ID, Code = entityCodeTransaction.Code }); }
public async Task <int> DeleteTransactionCode(uint id) { _cache.ClearValues(KEY_CACHE_CODES); MCodeTransaction mCodeTransaction = this._contextDB.MCodeTransaction.Where(x => x.ID == id).SingleOrDefault(); if (mCodeTransaction == null) { throw new Exception($"Code ID: {id} not found!"); } int transactionCodesInUse = this._contextDB.TransactionOutlay.Where(x => x.CodeTransaction_ID == mCodeTransaction.ID).Count(); if (transactionCodesInUse > 0) { throw new Exception("Not possible delete due to is being using in a transactions"); } this._contextDB.Context.Remove(mCodeTransaction); await this._contextDB.Context.SaveChangesAsync(); return(mCodeTransaction.ID); }
public async Task <int> AddTransactionCode(CodeTransactionDTO codeTransactionDTO) { _cache.ClearValues(KEY_CACHE_CODES); string transactionCodeFormat = codeTransactionDTO.Code.ToUpperInvariant().Trim(); HashSet <string> codesAvailables = this._contextDB.MCodeTransaction.Select(x => x.Code).ToHashSet(); if (codesAvailables.Contains(transactionCodeFormat)) { throw new Exception($"The code {transactionCodeFormat} already exist!"); } MCodeTransaction mCodeTransaction = new MCodeTransaction() { Code = transactionCodeFormat }; await this._contextDB.MCodeTransaction.AddAsync(mCodeTransaction); await this._contextDB.Context.SaveChangesAsync(); return(mCodeTransaction.ID); }