//admin crud işlemleri için gereken bölüm public T GetById(int id) { using (OMDBEntities context = new OMDBEntities()) { return(context.Set <T>().Find(id)); } }
public bool Any(Expression <Func <T, bool> > predicate) { using (OMDBEntities context = new OMDBEntities()) { return(context.Set <T>().Any(predicate)); } }
public T FirstOrDefault(Expression <Func <T, bool> > predicate) { using (OMDBEntities context = new OMDBEntities()) { return(context.Set <T>().FirstOrDefault(predicate)); } }
public List <T> Where(Expression <Func <T, bool> > predicate) { using (OMDBEntities context = new OMDBEntities()) { return(context.Set <T>().Where(predicate).ToList()); } }
// GET: api/User/5 public List <KeyValuePair <string, string> > Get(int id) { List <KeyValuePair <string, string> > keyValuePairs = new List <KeyValuePair <string, string> >(); using (OMDBEntities dbEntity = new OMDBEntities()) { IEnumerable <Order> orderList = dbEntity.Orders.Where(X => X.userID == id); //orders.orderID foreach (Order order in orderList) { keyValuePairs.Add(new KeyValuePair <string, string>("OrderID", order.orderID.ToString())); IEnumerable <OrderItem> itemsList = dbEntity.OrderItems.Where(b => b.orderID == order.orderID); foreach (OrderItem item in itemsList) { Product product = dbEntity.Products.SingleOrDefault(X => X.productID == item.productID); if (product != null) { keyValuePairs.Add(new KeyValuePair <string, string>("Product", product.pname)); keyValuePairs.Add(new KeyValuePair <string, string>("Quantity", item.quantity.ToString())); keyValuePairs.Add(new KeyValuePair <string, string>("Status", item.ostatus)); } } } } return(keyValuePairs); }
public List <int> GetSelectedCategoriesByMovieId(int movieId) { using (OMDBEntities context = new OMDBEntities()) { MovieCategoryRepository crepo = new MovieCategoryRepository(); return(crepo.Where(x => x.MovieId == movieId).Select(x => x.CategoryId).ToList()); } }
public void Update(T item) { using (OMDBEntities context = new OMDBEntities()) { context.Set <T>().AddOrUpdate(item); context.SaveChanges(); } }
public void RemoveRange(Expression <Func <T, bool> > predicate) { using (OMDBEntities context = new OMDBEntities()) { context.Set <T>().RemoveRange(context.Set <T>().Where(predicate)); context.SaveChanges(); } }
public void Add(List <T> items) { using (OMDBEntities context = new OMDBEntities()) { context.Set <T>().AddRange(items); context.SaveChanges(); } }
public List <Movie> ListByCategoryId(int categoryId) { using (OMDBEntities context = new OMDBEntities()) { var query = (from movie in context.Movie join movieCategory in context.MovieCategory on movie.Id equals movieCategory.MovieId where movieCategory.CategoryId == categoryId select movie); return(query.ToList()); } }
public void Remove(int id) { using (OMDBEntities context = new OMDBEntities()) { T item = context.Set <T>().Find(id); if (item != null) { context.Set <T>().Remove(item); context.SaveChanges(); } } }
public void Add(T item) { using (OMDBEntities context = new OMDBEntities()) { try { context.Set <T>().Add(item); context.SaveChanges(); } catch (Exception e) { throw e; } } }
public List <MovieCastCrewDtoModel> GetMovieCastCrewByActorId(int actorId) { using (OMDBEntities context = new OMDBEntities()) { var query = (from movieCastCrew in context.MovieCastCrew where movieCastCrew.CastCrewId == actorId select new MovieCastCrewDtoModel { RelationId = movieCastCrew.Id, Movie = movieCastCrew.Movie, Actor = movieCastCrew.CastCrew, Title = movieCastCrew.Title }); return(query.ToList()); } }
// POST: api/Product public HttpResponseMessage Post([FromBody] Product value) { try { if (ModelState.IsValid) { using (OMDBEntities Productdetails = new OMDBEntities()) { Productdetails.Products.Add(value); Productdetails.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } else { return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Invalid Model")); } } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } }