public void Insert(T entity) { PCBangEntities context = CreateContext(); context.Entry(entity).State = EntityState.Added; context.SaveChanges(); }
public void Update(T entity) { PCBangEntities context = CreateContext(); context.Entry(entity).State = EntityState.Modified; context.SaveChanges(); }
public void Delete(T entity) { PCBangEntities context = CreateContext(); context.Entry(entity).State = EntityState.Deleted; context.SaveChanges(); }
public List <Game> TopFiveGame() { PCBangEntities context = CreateContext(); List <Game> games = GetAll(); return(games.OrderByDescending(x => x.PlayCount).ToList()); }
protected PCBangEntities CreateContext() { PCBangEntities context = new PCBangEntities(); context.Configuration.ProxyCreationEnabled = false; return(context); }
public int?GetByName(string name) { PCBangEntities context = CreateContext(); var query = from x in context.Products where x.Name == name select x.ProductID; return(query.FirstOrDefault()); }
public int CheckItem(Order order) { PCBangEntities context = CreateContext(); var query = from x in context.Orders where x.OrderID == order.OrderID select x.Product.CodeID; return(query.ToList()[0]); }
public List <Game> GetbyGenre(int codeId) { PCBangEntities context = CreateContext(); var query = from x in context.GameGenres where x.CodeID == codeId select x.Game; return(query.ToList()); }
public void Update(List <T> entities) { PCBangEntities context = CreateContext(); context.Entry(entities).State = EntityState.Modified; /* foreach (var entity in entities) * context.Entry(entity).State = EntityState.Modified;*/ context.SaveChanges(); }
public List <Chatting> GetNotRead(bool sent, int seatId) { PCBangEntities context = CreateContext(); var query = from x in context.Chattings where x.SeatID == seatId select x; return(query.ToList()); }
public List <Seat> GetCanUse() { PCBangEntities context = CreateContext(); var query = from x in context.Seats where x.CustomerID == null && x.Breakdown == false select x; return(query.ToList()); }
public List <Chatting> GetNotRead(bool sent) { PCBangEntities context = CreateContext(); var query = from x in context.Chattings where x.Sent == sent && x.Checked == false select x; return(query.ToList()); }
public List <Seat> GetUsing() { PCBangEntities context = CreateContext(); var query = from x in context.Seats where x.CustomerID != null select x; return(query.ToList()); }
public List <Product> Getbycode(int codeId) { PCBangEntities context = CreateContext(); var query = from x in context.Products where x.CodeID == codeId select x; //select new { album = x, artistname = x.artist.name }; return(query.ToList()); }
public void DeleteAll(bool sent, int seatId) { PCBangEntities context = CreateContext(); var query = from x in context.Chattings where x.SeatID == seatId select x; var chattings = query.ToList(); foreach (var chatting in chattings) { Delete(chatting); } }
public void DeleteAll(bool sent) { PCBangEntities context = CreateContext(); var query = from x in context.Chattings where x.Sent == sent && x.Checked == false select x; var chattings = query.ToList(); foreach (var chatting in chattings) { Update(chatting); } }
public List <Seat> GetWithCustomer() { PCBangEntities context = CreateContext(); var query = from x in context.Seats select new { Seat = x, CustomerName = x.Customer.Name, RemainingTime = x.Customer == null ? 0:x.Customer.RemainingTime }; var list = query.ToList(); foreach (var x in list) { x.Seat.RemainingTime = x.RemainingTime; x.Seat.CustomerName = x.CustomerName; } return(list.ConvertAll(x => x.Seat)); }
public void UpdateAll(bool sent, int seatId) { PCBangEntities context = CreateContext(); var query = from x in context.Chattings where x.Sent == sent && x.Checked == false && x.SeatID == seatId select x; var chattings = query.ToList(); foreach (var chatting in chattings) { chatting.Checked = true; Update(chatting); } }
public List <Order> GetWithProduct(bool buyed, int customerId) { PCBangEntities context = CreateContext(); var query = from x in context.Orders where x.buyed == buyed && x.CustomerID == customerId select new { Order = x, ProductName = x.Product.Name, ProductPrice = x.Product.Price }; var list = query.ToList(); foreach (var x in list) { x.Order.ProductName = x.ProductName; x.Order.ProductPrice = x.ProductPrice; } return(list.ConvertAll(x => x.Order)); }
public int GetTotalPrice(bool buyed, int customerId) { PCBangEntities context = CreateContext(); var query = from x in context.Orders where x.buyed == buyed && x.CustomerID == customerId select x.Product.Price; var list = query.ToList(); int sum = 0; foreach (var x in list) { sum += x; } return(sum); }
public void DeleteOrder(int customerId) { PCBangEntities context = CreateContext(); var query = from x in context.Orders where x.buyed == false && x.CustomerID == customerId select x; List <Order> orders = query.ToList(); if (orders != null) { foreach (var order in orders) { Delete(order); } } }
public Customer Login(string loginId, string password) { PCBangEntities context = CreateContext(); Customer customer = context.Customers.FirstOrDefault(a => a.LoginID == loginId); if (customer == null) { return(null); } else { if (customer.LoginPassword == password) { return(customer); } else { return(null); } } }
public Code Get(int codeId) { PCBangEntities context = CreateContext(); return(context.Codes.FirstOrDefault(a => a.CodeID == codeId)); }
public Customer Get(int customerId) { PCBangEntities context = CreateContext(); return(context.Customers.FirstOrDefault(a => a.CustomerID == customerId)); }
public int GetCount() { PCBangEntities context = CreateContext(); return(context.Set <T>().Count()); }
public List <T> GetAll() { PCBangEntities context = CreateContext(); return(context.Set <T>().ToList()); }
public bool CanUseId(string loginId) { PCBangEntities context = CreateContext(); return(context.Customers.FirstOrDefault(a => a.LoginID == loginId) == null ? true : false); }
public bool LoginCheck(int customerId) { PCBangEntities context = CreateContext(); return(context.Seats.FirstOrDefault(a => a.CustomerID == customerId) == null ? false : true); }
public GameGenre Get(int gameId, int codeId) { PCBangEntities context = CreateContext(); return(context.GameGenres.FirstOrDefault(a => a.GameID == gameId && a.CodeID == codeId)); }
public Seat Get(int seatId) { PCBangEntities context = CreateContext(); return(context.Seats.FirstOrDefault(a => a.SeatID == seatId)); }