public IHttpActionResult GetUserRankName(string username) { using (var context = _provider.GetNewContext()) { var user = context.Users.FirstOrDefault(u => u.Username.Equals(username)); if (user == null) { return(NotFound()); } string name = user.Rank.Name; return(Ok(name)); } }
private IHttpActionResult Search(string username, ISearchingCriterion <Offer>[] criteria, SortType sortType, SortBy sortBy) { using (var context = _provider.GetNewContext()) { if (context is DbContext) { (context as DbContext).Configuration.ProxyCreationEnabled = false; } if (string.IsNullOrEmpty(username)) { return(NotFound()); } User u = context.Users.FirstOrDefault(us => us.Username.Equals(username)); if (u == null) { return(NotFound()); } IQueryable <Offer> offers = context.Offers.Where(o => o.VendorId != u.Id).Where(o => !o.IsBooked); offers = criteria.Aggregate(offers, (current, criterion) => current.Where(criterion.SelectableExpression)); offers = offers.Take(20).OrderBy(sortType, sortBy); List <Offer> list = offers.ToList(); SearchResultDto dto = new SearchResultDto() { Offers = list }; return(Ok(dto)); } }
public IHttpActionResult GetUserOffers(int userId) { IList <Offer> ret; using (var context = _provider.GetNewContext()) { using (var transaction = new TransactionScope()) { if (context is DbContext) { (context as DbContext).Configuration.ProxyCreationEnabled = false; } ret = context.Offers.Where(o => o.VendorId == userId).ToList(); transaction.Complete(); } } return(Ok(ret)); }
public IHttpActionResult GetUserData(string username) { User user = null; UserBasicDataDto returnDto = new UserBasicDataDto(); using (var context = _provider.GetNewContext()) { user = context.Users.First(u => u.Username.Equals(username)); var data = context.UserData.First(ud => ud.Id == user.UserDataId); if (user == null) { return(NotFound()); } returnDto.FirstName = data.FirstName; returnDto.LastName = data.LastName; returnDto.CompanyName = data.CompanyName; returnDto.Email = data.Email; } return(Ok(returnDto)); }
/// <summary> /// Wysyła pokój o danym id /// </summary> /// <param name="id"></param> /// <returns></returns> public IHttpActionResult Get(int id) { Room room = null; using (var context = _provider.GetNewContext()) { if (context is DbContext) { (context as DbContext).Configuration.ProxyCreationEnabled = false; } room = context.Rooms.FirstOrDefault(r => r.Id == id); } if (room == null) { return(NotFound()); } return(Ok(room)); }
/// <summary> /// Wysyła miejsce o danym id /// </summary> /// <param name="id"></param> /// <returns></returns> public IHttpActionResult Get(int id) { Place place = null; using (var context = _provider.GetNewContext()) { if (context is DbContext) { (context as DbContext).Configuration.ProxyCreationEnabled = false; } place = context.Places.FirstOrDefault(o => o.Id == id); } if (place == null) { return((IHttpActionResult)NotFound()); } return(Ok(place)); }
/// <summary> /// Wysyła informacje o ofercie o danym id /// </summary> /// <param name="id"></param> /// <returns></returns> public IHttpActionResult Get(int id) { OfferInfo offerinfo = null; using (var context = _provider.GetNewContext()) { if (context is DbContext) { (context as DbContext).Configuration.ProxyCreationEnabled = false; } offerinfo = context.OfferInfo.FirstOrDefault(o => o.Id == id); } if (offerinfo == null) { return((IHttpActionResult)NotFound()); } return(Ok(offerinfo)); }
public IHttpActionResult Get(string username = null) { username = username ?? string.Empty; User user = null; using (var context = _provider.GetNewContext()) { if (context is DbContext) { (context as DbContext).Configuration.ProxyCreationEnabled = false; } user = context.Users.FirstOrDefault(o => o.Username.Equals(username)); } if (user == null) { return((IHttpActionResult)NotFound()); } return(Ok(user)); }