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