public Visitor Get(string ID)
{
using (CinemaSeatingEntities entities = new CinemaSeatingEntities())
{
return(entities.Visitors.FirstOrDefault(e => e.VisitorID == ID));
}
}
public IEnumerable <CinemaHall> getAll(int x)
{
using (CinemaSeatingEntities entities = new CinemaSeatingEntities())
{
return(entities.CinemaHalls.ToList());
}
}
public static bool Login(string username, string password)
{
using (CinemaSeatingEntities entities = new CinemaSeatingEntities())
{
return(entities.Users.Any(user => (user.username == username && user.password == password)));
}
}
public HttpResponseMessage Post([FromBody] User user)
{
using (CinemaSeatingEntities entities = new CinemaSeatingEntities())
{
entities.Users.Add(user);
try
{
entities.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
var messages = Request.CreateResponse(HttpStatusCode.Created, user);
return(messages);
}
}
public static bool Login(string username, string Password)
{
using (CinemaSeatingEntities entities = new CinemaSeatingEntities())
{
//It returns something according to the db records
return(entities.Users.Any(User => User.username == username && User.password == Password));
}
}
