public async Task <IActionResult> GetTransactions(int wbsId, [FromQuery] TransParams transParams)
{
transParams.WBSId = wbsId;
var TransactionsFromRepo = await _repo.GetTransactions(transParams);
Response.AddPagination(TransactionsFromRepo.CurrentPage, TransactionsFromRepo.PageSize,
TransactionsFromRepo.TotalCount, TransactionsFromRepo.TotalPages);
return(Ok(TransactionsFromRepo));
}
public async Task <IEnumerable <Transaction> > GetTransReport(TransParams transParams)
{
var transaction = _Context.transactions.Include(u => u.Created).Include(c => c.Category).Include(a => a.Activity)
.OrderBy(t => t.CategoryId).ThenByDescending(t => t.Id).AsQueryable();
if (transParams.activity > 0)
{
transaction = transaction.Where(t => t.ActivityId == transParams.activity);
}
if (!string.IsNullOrEmpty(transParams.Active))
{
int active = 0;
if (int.TryParse(transParams.Active, out active))
{
transaction = transaction.Where(t => t.Active == active);
}
}
DateTime?dtFr = null;
DateTime?dtTo = null;
if (!string.IsNullOrEmpty(transParams.dateFr))
{
dtFr = CommonMethod.stringToDate(transParams.dateFr);
}
if (!string.IsNullOrEmpty(transParams.dateTo))
{
dtTo = CommonMethod.stringToDate(transParams.dateTo);
}
if (dtFr != null)
{
if (dtTo != null)
{
transaction = transaction.Where(t => t.TransactionDate >= dtFr && t.TransactionDate <= dtTo);
}
else
{
transaction = transaction.Where(t => t.TransactionDate >= dtFr);
}
}
else if (dtTo != null)
{
transaction = transaction.Where(t => t.TransactionDate <= dtTo);
}
if (!string.IsNullOrEmpty(transParams.trType))
{
transaction = transaction.Where(t => t.TransactionType == transParams.trType);
}
return(await transaction.ToListAsync());
}
/*public MapEventData[] GetMapEventData()
* {
* int index = SceneManager.GetActiveScene().buildIndex;
* return MapEvents.Where(val => val.SceneNumber == index).ToArray();
* }*/
public TransParam[] GetTransitionParams(MapEventData mapEvent, Vector2Int pos)
{
var param = TransParams.SingleOrDefault(p => p.CurrentScene == mapEvent.SceneNumber);
var list = new List <TransParam>();
foreach (var e in mapEvent[pos])
{
if (e.Event == MapEventData.Event.Transition || e.Event == MapEventData.Event.Transition_Action)
{
list.AddRange(param.GetParameters(e.NextScene));
}
}
return(list.ToArray());
}
public async Task <IHttpActionResult> Gettransactions([FromUri] TransParams transParams)
{
var trans = await _Repo.GetTransaction(transParams);
var result = _Mapper.Map <IEnumerable <TransactionDto> >(trans);
var paginationHeader = new PaginationHeader(trans.CurrentPage, trans.PageSize, trans.TotalCount, trans.TotalPages);
var camelCaseFormatter = new JsonSerializerSettings();
camelCaseFormatter.ContractResolver = new CamelCasePropertyNamesContractResolver();
Request.Properties["Pagination"] = JsonConvert.SerializeObject(paginationHeader, camelCaseFormatter);
return(Ok(_Mapper.Map <IEnumerable <TransactionDto> >(trans)));
}
public async Task <PagedList <Transaction> > GetTransaction(TransParams transParams)
{
var transaction = _Context.transactions.Include(u => u.Created).Include(c => c.Category).Include(a => a.Activity)
.OrderByDescending(t => t.Id).AsQueryable();
if (transParams.activity > 0)
{
transaction = transaction.Where(t => t.ActivityId == transParams.activity);
}
DateTime?dtFr = null;
DateTime?dtTo = null;
if (!string.IsNullOrEmpty(transParams.dateFr))
{
dtFr = CommonMethod.stringToDate(transParams.dateFr);
}
if (!string.IsNullOrEmpty(transParams.dateTo))
{
dtTo = CommonMethod.stringToDate(transParams.dateTo);
}
if (dtFr != null)
{
if (dtTo != null)
{
transaction = transaction.Where(t => t.TransactionDate >= dtFr && t.TransactionDate <= dtTo);
}
else
{
transaction = transaction.Where(t => t.TransactionDate >= dtFr);
}
}
else if (dtTo != null)
{
transaction = transaction.Where(t => t.TransactionDate <= dtTo);
}
if (!string.IsNullOrEmpty(transParams.trType))
{
transaction = transaction.Where(t => t.TransactionType == transParams.trType);
}
return(await PagedList <Transaction> .CreateAsync(transaction, transParams.PageNumber, transParams.PageSize));
}
public async Task <PagedList <TransactionsForListDto> > GetTransactions(TransParams transParams)
{
var res = (from transaction in _context.ProjectTransactions where (transaction.IsDeleted == false && transaction.WBSId == transParams.WBSId) orderby transaction.TransactionDate descending select new TransactionsForListDto {
Id = transaction.Id,
TransactionTypeId = transaction.TransactionTypeId,
TransactionDate = transaction.TransactionDate,
Amount = transaction.Amount,
CurrencyId = transaction.CurrencyId,
ExchangeRate = transaction.ExchangeRate,
ProvinceId = transaction.ProvinceId,
ProvinceName = transaction.Province.ProvinceName,
CurrencyName = transaction.Currency.CurrencyName,
Description = transaction.Description,
WBSId = transaction.WBSId,
WBSName = transaction.WBS.WBSName,
TransactionType = transaction.TransactionType.TransactionTypeName
});
if (transParams.TransactionTypeId != null)
{
res = res.Where(c => c.TransactionTypeId == transParams.TransactionTypeId);
}
if (!string.IsNullOrWhiteSpace(transParams.FromDate))
{
var strDateTime = transParams.FromDate.Substring(4, 20);
DateTime fromDate = DateTime.Parse(strDateTime);
res = res.Where(c => c.TransactionDate >= fromDate);
}
if (!string.IsNullOrWhiteSpace(transParams.ToDate))
{
var strDateTime = transParams.ToDate.Substring(4, 20);
DateTime toDate = DateTime.Parse(strDateTime);
res = res.Where(c => c.TransactionDate <= toDate);
}
if (transParams.ProvinceId != null)
{
res = res.Where(c => c.ProvinceId == transParams.ProvinceId);
}
return(await PagedList <TransactionsForListDto> .CreateAsync(res, transParams.PageNumber, transParams.PageSize));
}
public async Task <IHttpActionResult> GetTransReport([FromUri] TransParams transParams)
{
var trans = await _Repo.GetTransReport(transParams);
return(Ok(_Mapper.Map <IEnumerable <TransactionDto> >(trans)));
}
