public List <TransactionModel> Paginate(int currentPageIndex, int pageSize, int walletId)
{
List <TransactionModel> listModel = null;
try
{
using (IDAOTransaction daoTransaction = new DAOTransaction())
{
var result = daoTransaction.GetList(x => x.WalletId == walletId);
List <Transaction> transactions = daoTransaction.Paginate(currentPageIndex, pageSize, walletId);
if (transactions != null)
{
listModel = new List <TransactionModel>();
foreach (var item in transactions)
{
listModel.Add(TransactionToModel(item));
}
}
}
}
catch (Exception)
{
throw;
}
return(listModel);
}
public void Delete(int transactionId, int walletId)
{
using (IDAOTransaction daoTransaction = new DAOTransaction())
{
Transaction transaction = daoTransaction.GetSingle(x => x.Id == transactionId && x.WalletId == walletId);
daoTransaction.Remove(transaction);
}
}
public TransactionModel Insert(TransactionModel transactionModel)
{
try
{
using (IDAOTransaction daoTransaction = new DAOTransaction())
{
Transaction transaction = this.ModelToTransaction(transactionModel);
transaction.WalletId = transactionModel.WalletId;
transaction = daoTransaction.Add(transaction);
return(this.TransactionToModel(transaction));
}
}
catch (Exception)
{
throw;
}
}
public int SelectCount(int walletId)
{
int count = 0;
try
{
using (IDAOTransaction daoTransaction = new DAOTransaction())
{
count = daoTransaction.GetTotal(walletId);
}
}
catch (Exception)
{
throw;
}
return(count);
}
public TransactionModel Select(int id, int walletId)
{
try
{
using (IDAOTransaction daoTransaction = new DAOTransaction())
{
Transaction transaction = daoTransaction.GetSingle(x => x.Id == id && x.WalletId == walletId);
//Transaction transaction = daoTransaction.Select(id, walletId);
if (transaction != null)
{
return(this.TransactionToModel(transaction));
}
}
}
catch (Exception)
{
throw;
}
return(null);
}
public TransactionModel Update(TransactionModel transactionModel)
{
try
{
using (IDAOTransaction daoTransactionModel = new DAOTransaction())
{
Transaction transaction = daoTransactionModel.GetSingle(x => x.Id == transactionModel.Id && x.WalletId == transactionModel.WalletId);
//Transaction transaction = daoTransactionModel.GetSingle(transactionModel.Id, transactionModel.WalletId);
if (transaction != null)
{
int transactionId = transaction.Id;
decimal oldValue = transaction.Value;
TransactionType oldtype = transaction.Type ? TransactionType.Debit : TransactionType.Credit;
transaction = this.ModelToTransaction(transactionModel);
transaction.Id = transactionId;
transaction.WalletId = transactionModel.WalletId;
daoTransactionModel.Update(transaction);
transactionModel = this.TransactionToModel(transaction);
this.ColectValueToWallet(transactionModel, oldValue, decimal.Parse(transactionModel.Value), oldtype, transactionModel.Type);
return(transactionModel);
}
else
{
return(null);
}
}
}
catch (Exception)
{
throw;
}
}