public List <Show> GetShows()
{
using (var context = new Entities.StarShowDBEntities())
{
shows = context.Shows.ToList();
}
return(shows);
}
public Order GetOrder(string id)
{
var order = new Order();
using (var context = new Entities.StarShowDBEntities())
{
order = context.Orders.Where(a => a.id == id).FirstOrDefault();
}
return(order);
}
public void UpdateOrder(Order order)
{
Order newOrder;
using (var context = new Entities.StarShowDBEntities())
{
newOrder = context.Orders.Add(order);
context.Orders.Add(order);
}
}
public DateTime GetSlotDate(string id)
{
var date = new DateTime();
using (var context = new Entities.StarShowDBEntities())
{
date = context.Slots.Where(a => a.id == id).FirstOrDefault().date.Value;
}
return(date);
}
public Show GetShowById(string id)
{
var show = new Show();
using (var context = new Entities.StarShowDBEntities())
{
show = context.Shows.Where(a => a.id == id).FirstOrDefault();
}
return(show);
}
public bool SignIn(string username, string password)
{
using (var context = new Entities.StarShowDBEntities())
{
var signedIn = context.Users.Where(q => q.email == username).FirstOrDefault();
if (signedIn.password == "ONLINE" || signedIn.password == password)
{
return(true);
}
}
return(false);
}
public Slot GetSlotById(string userId, string showName)
{
Slot slot;
Show show;
using (var context = new Entities.StarShowDBEntities())
{
show = context.Shows.Where(q => q.title == showName).FirstOrDefault();
slot = context.Slots.Where(q => q.showId == show.id).FirstOrDefault();
}
return(slot);
}
public bool SignUp(User user)
{
List <User> users;
using (var context = new Entities.StarShowDBEntities())
{
users = context.Users.ToList();
foreach (var item in users)
{
if (user == item)
{
return(false);
}
}
var newUser = context.Users.Add(user);
}
return(true);
}
public Order GetOrderById(string userId, string showName)
{
Order order = null;
List <Order> orders;
Slot slot;
Show show;
using (var context = new Entities.StarShowDBEntities())
{
show = context.Shows.Where(q => q.title == showName).FirstOrDefault();
slot = context.Slots.Where(q => q.showId == show.id).FirstOrDefault();
orders = context.Orders.Where(q => q.userId == userId).ToList();
}
foreach (var item in orders)
{
if (item.Tickets.Where(q => q.slotId == slot.id).FirstOrDefault().Order.buyTime.Value < slot.date.Value)
{
order = item;
break;
}
}
return(order);
}
