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