public static void SetupTracks(TrackModel model)
{
using (var site = new SCBWIContext()) {
site.Tracks.Add(new Track {
Name = model.Track1,
Presenters = model.Track1Presenters
});
site.Tracks.Add(new Track
{
Name = model.Track2,
Presenters = model.Track2Presenters
});
site.Tracks.Add(new Track
{
Name = model.Track3,
Presenters = model.Track3Presenters
});
site.Tracks.Add(new Track
{
Name = model.Track4,
Presenters = model.Track4Presenters
});
site.Tracks.Add(new Track
{
Name = model.Track5,
Presenters = model.Track5Presenters
});
site.SaveChanges();
}
}
public static void CreateUser(string accountname, User u)
{
using (var site = new SCBWIContext()) {
var n = new User();
n.Account = accountname;
n.Address1 = u.Address1;
n.Address2 = u.Address2;
n.BadgeName = u.BadgeName;
n.City = u.City;
n.Country = u.Country;
n.Email = u.Email;
n.FirstName = u.FirstName;
n.LastName = u.LastName;
n.Phone = u.Phone;
n.PostalCode = u.PostalCode;
n.State = u.State;
n.SpecialNeeds = u.SpecialNeeds;
n.Created = DateTime.UtcNow;
n.Paid = DateTime.UtcNow;
n.Cleared = DateTime.UtcNow;
n.PayPalID = User.GetSHA1(n.FullName + n.Created);
n.Registration = new Registration();
site.Users.Add(n);
site.SaveChanges();
}
}
public static void SetupMeals(MealModel model)
{
using (var site = new SCBWIContext()) {
site.Information.Add(new Information {
Category = Category.Lunch,
Title = model.Meal1,
Value = model.Meal1
});
site.Information.Add(new Information
{
Category = Category.Lunch,
Title = model.Meal2,
Value = model.Meal2
});
site.Information.Add(new Information
{
Category = Category.Lunch,
Title = model.Meal3,
Value = model.Meal3
});
site.SaveChanges();
}
}
public static void SetupRegistrationTypes(RegTypes model)
{
using (var site = new SCBWIContext()) {
site.Prices.Add(new Price {
Name = "Early Member Price",
Category = Category.Reg,
Value = model.EarlyMemberPrice
});
site.Prices.Add(new Price {
Name = "Late Member Price",
Category = Category.RegLate,
Value = model.LateMemberPrice
});
site.Prices.Add(new Price {
Name = "Early Non Member Price",
Value = model.EarlyNonMemberPrice,
Category = Category.Reg
});
site.Prices.Add(new Price {
Name = "Late Non Member Price",
Value = model.LateNonMemberPrice,
Category = Category.RegLate
});
site.SaveChanges();
}
}
public static void SetupConferenceDates(OpenCloseDate model)
{
using (var site = new SCBWIContext()) {
var open = new Date {
Category = Category.Open,
Name = "Conference Open",
Value = model.OpenDate
};
var close = new Date {
Category = Category.Close,
Name = "Conference Close",
Value = model.CloseDate
};
var regopen = new Date {
Category = Category.RegistrationOpen,
Name = "Registration Open",
Value = model.RegOpenDate
};
var regclose = new Date {
Category = Category.RegistrationClose,
Name = "Registration Close",
Value = model.RegCloseDate
};
var late = new Date {
Category = Category.Late,
Name = "Late Registration Date",
Value = model.RegLateDate
};
var edit = new Date {
Category = Category.LastEdit,
Name = "Last Edit Date",
Value = model.LastEditDate
};
site.Dates.Add(open);
site.Dates.Add(close);
site.Dates.Add(regclose);
site.Dates.Add(regopen);
site.Dates.Add(late);
site.Dates.Add(edit);
site.Information.Add(new Information {
Category = Category.Ready,
Title = "Conference Setup Begun",
Value = "in progress"
});
site.SaveChanges();
}
}
public static void Log(string origin, string message)
{
using (var site = new SCBWIContext()) {
site.Logs.Add(new Log {
Message = message,
Origin = origin,
Time = DateTime.UtcNow
});
site.SaveChanges();
}
}
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 SetupIntensives(IntensivePrices model)
{
using (var site = new SCBWIContext()) {
site.Prices.Add(new Price {
Name = model.Intensive1,
Category = Category.Intensive,
Value = model.IntensivePrice
});
site.Prices.Add(new Price
{
Name = model.Intensive2,
Category = Category.Intensive,
Value = model.IntensivePrice
});
site.Prices.Add(new Price
{
Name = model.Intensive3,
Category = Category.Intensive,
Value = model.IntensivePrice
});
site.Prices.Add(new Price
{
Name = model.Intensive4,
Category = Category.Intensive,
Value = model.IntensivePrice
});
site.Prices.Add(new Price {
Name = model.AuthorCritique,
Category = Category.Critique,
Value = model.CritiquePrice
});
site.Prices.Add(new Price {
Name = model.ArtCritique,
Category = Category.Critique,
Value = model.CritiquePrice
});
site.Prices.Add(new Price {
Name = model.DummyCritique,
Category = Category.Critique,
Value = model.CritiquePrice
});
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());
}
public static void CreateCritiques(string account, CritiqueView model)
{
var site = new SCBWIContext();
var user = GetUserByAccount(account);
var critiques = new Critique[model.NumCritiques];
for (int i = 0; i < model.NumCritiques; i++)
{
critiques[i] = new Critique {
Type = model.CritiqueType,
UserID = user.UserID
};
site.Critiques.Add(critiques[i]);
}
site.SaveChanges();
}
