public async Task <DReturnObject> ListAll(string useremail, CancellationToken cancellationToken)
{
DReturnObject bdr = new DReturnObject();
try
{
var busRepo = _unitOfWork.GetRepository <UserData>();
UserData ud = (await busRepo.GetFirstOrDefaultAsync(
predicate: a => a.email.ToLower().Equals(useremail),
disableTracking: false));
if (ud == null)
{
bdr.status = status.success.ToString();
bdr.message = "No subscription data for this user: "******"select s.id, s.price, s.state, pd.imagePath, pd.title, pd.description from SubscriptionData s inner join ProductData pd on pd.id = s.prodid where s.usrid={0} and s.state=1", ud.id);
bdr.status = status.success.ToString();
}
catch (Exception e)
{
bdr = _exceptionHandler.HandleException(bdr, e);
}
return(bdr);
}
public async Task <DReturnObject> ListAll()
{
DReturnObject bdr = new DReturnObject();
try
{
var busRepo = _unitOfWork.GetRepository <DProductData>();
bdr.data = busRepo.FromSql("select * from ProductData");
bdr.status = status.success.ToString();
}
catch (Exception e)
{
bdr = _exceptionHandler.HandleException(bdr, e);
}
return(bdr);
}