public static void CreateRegistration(Registration reg, string account)
{
using (var site = new SCBWIContext()) {
var user = (from u in site.Users
where u.Account == account
select u).First();
user.Registration = reg;
site.Entry(user).State = EntityState.Modified;
site.SaveChanges();
}
}
public static void CompleteWizard()
{
using (var site = new SCBWIContext()) {
var status = (from c in site.Information
where c.Category == Category.Ready
select c).SingleOrDefault();
status.Value = "ready";
site.Entry(status).State = EntityState.Modified;
site.SaveChanges();
}
}
public static string CalcTotalByAccount(string account)
{
var site = new SCBWIContext();
var user = (from u in site.Users
where u.Account == account
select u).SingleOrDefault();
user.Registration = site.Registrations.Find(user.RegistrationID);
double total = 0;
var regtype = (from r in site.Prices
where r.Name == user.Registration.Type
select r).SingleOrDefault();
total += regtype.Value;
if (user.Registration.Intensive != null)
{
var intensive = (from i in site.Prices
where i.Name == user.Registration.Intensive
select i).SingleOrDefault();
total += intensive.Value;
}
if (user.Critiques != null || user.Critiques.Count() > 0)
{
var critiques = (from p in site.Prices
where p.Category == Category.Critique
select p).FirstOrDefault();
total += (critiques.Value * user.Critiques.Count());
}
user.Total = total;
site.Entry(user).State = EntityState.Modified;
site.SaveChanges();
return(total.ToString());
}