public ApiResult <Account> GetById(string accountId)
{
if (accountId == null)
{
return(ApiResult <Account> .CreateFailed(
Constants.ApiResultCode.BadRequest, $"Null {nameof(accountId)}"));
}
// SELECT FROM Account
IQueryable <Account> accountResultSearch = _dbContext.Set <Account>().AsQueryable().Where(a => a.AccountId == accountId);
var account = accountResultSearch.Include(c => c.Cards).SingleOrDefault();
if (account == null)
{
return(new ApiResult <Account>()
{
Code = Constants.ApiResultCode.NotFound,
ErrorText = $"Customer {accountId} was not found"
});
}
else
{
return(new ApiResult <Account>()
{
Data = account
});
}
}
//private string CardNumberGenerator()
//{
// Random random = new Random();
// string cardNum = string.Empty;
// for (int j = 0; j < random.Next(3) + 13; j++) {
// cardNum += random.Next(0, 10).ToString();
// }
// return cardNum;
//}
public ApiResult <Card> GetById(Guid?cardId)
{
if (cardId == null)
{
return(ApiResult <Card> .CreateFailed(
Constants.ApiResultCode.BadRequest, $"Null {nameof(cardId)}"));
}
IQueryable <Card> cardsSearchRes = _dbContext.Set <Card>().AsQueryable().Where(a => a.CardId == cardId);
var card = cardsSearchRes.SingleOrDefault();
if (card == null)
{
return(ApiResult <Card> .CreateFailed(
Constants.ApiResultCode.NotFound, $"CardId {cardId} was not found"));
}
return(new ApiResult <Card>()
{
Data = card
});
}
public ApiResult <Card> GetByNumber(string cardnumber)
{
if (string.IsNullOrWhiteSpace(cardnumber))
{
return(new ApiResult <Card>()
{
Code = ApiResultCode.BadRequest,
ErrorText = $"Invalid cardnumber"
});
}
try {
var card = _dbContext.Set <Card>()
.Where(c => c.CardNumber == cardnumber)
.Include(c => c.Accounts)
.SingleOrDefault();
if (card == null)
{
return(new ApiResult <Card>()
{
Code = ApiResultCode.NotFound,
ErrorText = $"card doesn't exist"
});
}
return(new ApiResult <Card>()
{
Data = card,
ErrorText = "",
Code = ApiResultCode.Success
});
}
catch (Exception) {
return(new ApiResult <Card>()
{
Code = ApiResultCode.InternalServerError,
ErrorText = $"Internal error"
});
}
}
public IQueryable <Account> Search(SearchAccountOptions options)
{
if (options == null)
{
throw new ArgumentNullException(nameof(options));
}
// SELECT FROM CUSTOMER
var q = _dbContext.Set <Account>()
.AsQueryable();
// SELECT FROM CUSTOMER WHERE CustomerId = options.CustomerId
if (!string.IsNullOrWhiteSpace(options.AccountId))
{
q = q.Where(a => a.AccountId == options.AccountId);
}
// SELECT FROM CUSTOMER WHERE CustomerId = options.CustomerId
// AND VatNumber = options.VatNumber
if (options.CustomerId != Guid.Parse("00000000-0000-0000-0000-000000000000"))
{
q = q.Where(a => a.CustomerId == options.CustomerId);
}
if (options.TrackResults != null &&
!options.TrackResults.Value)
{
q = q.AsNoTracking();
}
if (options.Skip != null)
{
q = q.Skip(options.Skip.Value);
}
q = q.Take(options.MaxResults ?? 500);
return(q);
}
private Card GetByCardNumber(string cardNumber)
{
var card = _dbContext.Set <Card>().AsQueryable().Where(c => c.CardNumber == cardNumber).Include(c => c.Accounts).SingleOrDefault();
return(card);
}
