public List <Author> RetrieveAllAuthors()
{
using (var db = new PlayContext())
{
return(db.Authors.ToList());
}
}
public List <Theatre> RetrieveAllTheatres()
{
using (var db = new PlayContext())
{
return(db.Theatres.ToList());
}
}
public List <Play> RetrieveAllPlays()
{
using (var db = new PlayContext())
{
return(db.Plays.Include(p => p.Author).ToList());
}
}
public List <Play> RetrieveAllPlaysForTheatre(int theatreId)
{
using (var db = new PlayContext())
{
return(db.Plays.Where(t => t.TheatreId == theatreId).Include(p => p.Author).ToList());
}
}
public List <Play> SearchedPlays(string title)
{
using (var db = new PlayContext())
{
return(db.Plays.Where(p => p.Title.Contains(title)).ToList());
}
}
public void Create(Login login)
{
using (var db = new PlayContext())
{
db.Logins.Add(login);
db.SaveChanges();
}
}
public void Create(Order order)
{
using (var db = new PlayContext())
{
db.Orders.Add(order);
db.SaveChanges();
}
}
public void DeleteExistingAuthor(int authorId)
{
using (var db = new PlayContext())
{
selectedAuthor = db.Authors.Where(a => a.AuthorId == authorId).FirstOrDefault();
db.Authors.Remove(selectedAuthor);
db.SaveChanges();
}
}
public List <Play> RetrievePlaysForAuthor(int authorId)
{
using (var db = new PlayContext())
{
var playQuery = db.Plays.Where(p => p.AuthorId == authorId).Include(p => p.Author);
var ans = playQuery.ToList();
return(ans);
}
}
public void DeleteExistingTheatre(int theatreId)
{
using (var db = new PlayContext())
{
SelectedTheatre = db.Theatres.Where(t => t.TheatreId == theatreId).FirstOrDefault();
db.Remove(SelectedTheatre);
db.SaveChanges();
}
}
public void DeleteAPlay(int playId)
{
using (var db = new PlayContext())
{
selectedPlay = db.Plays.Where(p => p.PlayId == playId).FirstOrDefault();
db.Plays.Remove(selectedPlay);
db.SaveChanges();
}
}
public void UpdateExistingAuthor(int authorId, string firstName, string lastName)
{
using (var db = new PlayContext())
{
selectedAuthor = db.Authors.Where(a => a.AuthorId == authorId).FirstOrDefault();
selectedAuthor.FirstName = firstName;
selectedAuthor.LastName = lastName;
db.SaveChanges();
}
}
public void Update(int orderId)
{
using (var db = new PlayContext())
{
var order = db.Orders.First(q => q.Id == orderId);
order.IsPaid = true;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
}
public List <Date> GetDates()
{
List <Date> result = null;
using (var db = new PlayContext())
{
result = db.Dates.ToList();
}
return(result);
}
public List <Login> GetLogins()
{
List <Login> result = null;
using (var db = new PlayContext())
{
result = db.Logins.ToList();
}
return(result);
}
public void DeleteTheatre()
{
using (var db = new PlayContext())
{
var theatres = db.Theatres.ToList();
theatres.Reverse();
var lastTheatre = theatres[0];
db.Theatres.Remove(lastTheatre);
db.SaveChanges();
}
}
public List <Order> GetCurrentDate(int orderId)
{
List <Order> result = null;
using (var db = new PlayContext())
{
result = db.Orders.Where(q => q.Id == orderId).Include(q => q.Date).ToList();
}
return(result);
}
public void DeletePlay()
{
using (var db = new PlayContext())
{
var plays = db.Plays.ToList();
plays.Reverse();
var lastPlay = plays[0];
db.Plays.Remove(lastPlay);
db.SaveChanges();
}
}
public void DeleteAuthor()
{
using (var db = new PlayContext())
{
var authors = db.Authors.ToList();
authors.Reverse();
var lastAuthor = authors[0];
db.Authors.Remove(lastAuthor);
db.SaveChanges();
}
}
public Play GetPlay(int playId)
{
Play result = null;
using (var db = new PlayContext())
{
result = db.Plays.Where(q => q.Id == playId).Include(q => q.Author).FirstOrDefault();
}
return(result);
}
public List <Play> GetPlays()
{
List <Play> result = null;
using (var db = new PlayContext())
{
result = db.Plays.ToList();
}
return(result);
}
public void UpdateExistingTheatre(int theatreId, string name, string location, int capacity)
{
using (var db = new PlayContext())
{
SelectedTheatre = db.Theatres.Where(t => t.TheatreId == theatreId).FirstOrDefault();
SelectedTheatre.Name = name;
SelectedTheatre.Location = location;
SelectedTheatre.Capacity = capacity;
db.SaveChanges();
}
}
public void RemoveRange(IEnumerable <int> ordersToRemoveIds)
{
using (var db = new PlayContext())
{
var ordersToCancel = db.Orders
.Where(q => ordersToRemoveIds.Contains(q.Id));
db.Orders.RemoveRange(ordersToCancel);
db.SaveChanges();
}
}
public void CreateAAuthor(string firstName, string lastName)
{
using (var db = new PlayContext())
{
db.Add(new Author
{
FirstName = firstName,
LastName = lastName
});
db.SaveChanges();
}
}
public void CreateATheatre(string name, string location, int capacity)
{
using (var db = new PlayContext())
{
db.Add(new Theatre
{
Name = name,
Location = location,
Capacity = capacity
});
db.SaveChanges();
}
}
public List <Order> GetOrders()
{
List <Order> result = null;
using (var db = new PlayContext())
{
result = db.Orders
.Include(q => q.Login)
.Include(q => q.Date)
.ToList();
}
return(result);
}
//解释器
public static void testInterpreter()
{
PlayContext context = new PlayContext();
//音乐-上海滩
Console.WriteLine("上海滩：");
//context.演奏文本 = "T 500 O 2 E 0.5 G 0.5 A 3 E 0.5 G 0.5 D 3 E 0.5 G 0.5 A 0.5 O 3 C 1 O 2 A 0.5 G 1 C 0.5 E 0.5 D 3 D 0.5 E 0.5 G 3 D 0.5 E 0.5 O 1 A 3 A 0.5 O 2 C 0.5 D 1.5 E 0.5 D 0.5 O 1 B 0.5 A 0.5 O 2 C 0.5 O 1 G 3 P 0.5 O 2 E 0.5 G 0.5 A 3 E 0.5 G 0.5 D 3 E 0.5 G 0.5 A 0.5 O 3 C 1 O 2 A 0.5 G 1 C 0.5 E 0.5 D 3 D 0.5 E 0.5 G 3 D 0.5 E 0.5 O 1 A 3 A 0.5 O 2 C 0.5 D 1.5 E 0.5 D 0.5 O 1 B 0.5 A 0.5 G 0.5 O 2 C 3 P 0.5 O 3 C 0.5 C 0.5 O 2 A 0.5 O 3 C 2 P 0.5 O 2 A 0.5 O 3 C 0.5 O 2 A 0.5 G 2.5 G 0.5 E 0.5 A 1.5 G 0.5 C 1 D 0.25 C 0.25 D 0.5 E 2.5 E 0.5 E 0.5 D 0.5 E 2.5 O 3 C 0.5 C 0.5 O 2 B 0.5 A 3 E 0.5 E 0.5 D 1.5 E 0.5 O 3 C 0.5 O 2 B 0.5 A 0.5 E 0.5 G 2 P 0.5 O 2 E 0.5 G 0.5 A 3 E 0.5 G 0.5 D 3 E 0.5 G 0.5 A 0.5 O 3 C 1 O 2 A 0.5 G 1 C 0.5 E 0.5 D 3 D 0.5 E 0.5 G 3 D 0.5 E 0.5 O 1 A 3 A 0.5 O 2 C 0.5 D 1.5 E 0.5 D 0.5 O 1 B 0.5 A 0.5 G 0.5 O 2 C 3 ";
context.PlayText = "T 500 O 2 E 0.5 G 0.5 A 3 E 0.5 G 0.5 D 3 E 0.5 G 0.5 A 0.5 O 3 C 1 O 2 A 0.5 G 1 C 0.5 E 0.5 D 3 ";
//音乐-隐形的翅膀
//Console.WriteLine("隐形的翅膀：");
//context.演奏文本 = "T 1000 O 1 G 0.5 O 2 C 0.5 E 1.5 G 0.5 E 1 D 0.5 C 0.5 C 0.5 C 0.5 C 0.5 O 1 A 0.25 G 0.25 G 1 G 0.5 O 2 C 0.5 E 1.5 G 0.5 G 0.5 G 0.5 A 0.5 G 0.5 G 0.5 D 0.25 E 0.25 D 0.5 C 0.25 D 0.25 D 1 A 0.5 G 0.5 E 1.5 G 0.5 G 0.5 G 0.5 A 0.5 G 0.5 E 0.5 D 0.5 C 0.5 C 0.25 D 0.25 O 1 A 1 G 0.5 A 0.5 O 2 C 1.5 D 0.25 E 0.25 D 1 E 0.5 C 0.5 C 3 O 1 G 0.5 O 2 C 0.5 E 1.5 G 0.5 E 1 D 0.5 C 0.5 C 0.5 C 0.5 C 0.5 O 1 A 0.25 G 0.25 G 1 G 0.5 O 2 C 0.5 E 1.5 G 0.5 G 0.5 G 0.5 A 0.5 G 0.5 G 0.5 D 0.25 E 0.25 D 0.5 C 0.25 D 0.25 D 1 A 0.5 G 0.5 E 1.5 G 0.5 G 0.5 G 0.5 A 0.5 G 0.5 E 0.5 D 0.5 C 0.5 C 0.25 D 0.25 O 1 A 1 G 0.5 A 0.5 O 2 C 1.5 D 0.25 E 0.25 D 1 E 0.5 C 0.5 C 3 E 0.5 G 0.5 O 3 C 1.5 O 2 B 0.25 O 3 C 0.25 O 2 B 1 A 0.5 G 0.5 A 0.5 O 3 C 0.5 O 2 E 0.5 D 0.5 C 1 C 0.5 C 0.5 C 0.5 O 3 C 1 O 2 G 0.25 A 0.25 G 0.5 D 0.25 E 0.25 D 0.5 C 0.25 D 0.25 D 3 E 0.5 G 0.5 O 3 C 1.5 O 2 B 0.25 O 3 C 0.25 O 2 B 1 A 0.5 G 0.5 A 0.5 O 3 C 0.5 O 2 E 0.5 D 0.5 C 1 C 0.5 C 0.5 C 0.5 O 3 C 1 O 2 G 0.25 A 0.25 G 0.5 D 0.25 E 0.25 D 0.5 C 0.5 C 3 ";
Expression expression = null;
try
{
while (context.PlayText.Length > 0)
{
string str = context.PlayText.Substring(0, 1);
switch (str)
{
case "O":
expression = new Scale();
break;
case "T":
expression = new Speed();
break;
case "C":
case "D":
case "E":
case "F":
case "G":
case "A":
case "B":
case "P":
expression = new Note();
break;
}
expression.Interpret(context);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.Read();
}
public virtual void Interpret(PlayContext context)
{
if (string.IsNullOrEmpty(context.PlayText))
{
return;
}
var playKey = context.PlayText.Substring(0, 1);
context.PlayText = context.PlayText.Substring(2);
var playValue = context.PlayText.IndexOf(" ", StringComparison.Ordinal) > 0 ? Convert.ToDouble(context.PlayText.Substring(0, context.PlayText.IndexOf(" ", StringComparison.Ordinal))) : 0;
context.PlayText = context.PlayText.Substring(context.PlayText.IndexOf(" ", StringComparison.Ordinal) + 1);
Execute(playKey, playValue);
}
public void Interpret(PlayContext context)
{
if (context.PlayText.Length == 0)
{
return;
}
string playKey = context.PlayText.Substring(0, 1);
context.PlayText = context.PlayText.Substring(2);
var playValue = Convert.ToDouble(context.PlayText.Substring(0, context.PlayText.IndexOf(" ")));
context.PlayText = context.PlayText.Substring(context.PlayText.IndexOf(" ") + 1);
Excute(playKey, playValue);
}
public ActionResult Index()
{
using (var db = new PlayContext())
{
var plays = db.Plays.Include("Author").Include("Genre");
var playsIds = plays.Select(p => p.Id);
plays.ForEachAsync(p =>
{
db.Entry(p).Collection("Dates").Load();
}).Wait();
ViewBag.Plays = plays.ToList();
}
return(View());
}
