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); }