public override Order Get(int id) { using (TravelRoadContext context = new TravelRoadContext()) { return(context.Order.Include("Line").Include("Line.Bike").Where(x => x.Id == id).FirstOrDefault()); } }
public List <T> ListAll() { using (TravelRoadContext context = new TravelRoadContext()) { return(context.Set <T>().ToList()); } }
public int InsertWithIdReturn(Order order) { using (TravelRoadContext context = new TravelRoadContext()) { context.Order.Add(order); context.SaveChanges(); return(order.Id); } }
public List <Bike> Search(string criterio) { using (TravelRoadContext context = new TravelRoadContext()) { var query = from b in context.Bike where (b.Brand.Contains(criterio)) || (b.Model.Contains(criterio)) || (b.Price.ToString().Contains(criterio)) select b; return(query.ToList()); } }
public List <Bike> Search(Bike criterio) { using (TravelRoadContext context = new TravelRoadContext()) { var query = from b in context.Bike where (criterio.Brand == null || b.Brand.Contains(criterio.Brand)) && (criterio.Model == null || b.Model.Contains(criterio.Model)) && (criterio.Price == null || criterio.Price == b.Price) select b; return(query.ToList()); } }
public virtual T Get(ID id) { try { using (TravelRoadContext context = new TravelRoadContext()) { return(context.Set <T>().Find(id)); } } catch (Exception ex) { log.Error(ex, ex.Message, null); return(null); } }
public virtual bool DeleteItem(T item) { try { using (TravelRoadContext context = new TravelRoadContext()) { context.Entry <T>(item).State = System.Data.Entity.EntityState.Deleted; return(context.SaveChanges() > 0); } } catch (Exception ex) { log.Error(ex, ex.Message, null); return(false); } }