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 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 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 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 LastUser GetLastRegistration()
{
using (var site = new SCBWIContext()) {
var us = (from u in site.Users
orderby u.Cleared descending
select u).FirstOrDefault();
LastUser toReturn;
if (us == null)
{
toReturn = new LastUser {
Created = DateTime.UtcNow,
Name = "No registrations yet :("
};
}
else
{
toReturn = new LastUser {
Created = us.Created,
Name = us.FullName
};
}
return(toReturn);
}
}
public static SelectList GetTracksBox()
{
using (var site = new SCBWIContext()) {
var tracks = site.Tracks.ToList();
return(new SelectList(tracks, "Name", "Display"));
}
}
public static SelectList GetCategoryBox()
{
using (var site = new SCBWIContext()) {
var categories = from Category c in Enum.GetValues(typeof(Category))
select new { ID = c, Name = c.ToString() };
return(new SelectList(categories, "ID", "Name"));
}
}
public static string GetCritiquePrice()
{
using (var site = new SCBWIContext()) {
var critiques = (from p in site.Prices
where p.Category == Category.Critique
select p).FirstOrDefault();
return(critiques.Value.ToString());
}
}
public static SelectList GetLunchBox(Category cat)
{
using (var site = new SCBWIContext()) {
var lunch = from i in site.Information
where i.Category == cat
select i;
return(new SelectList(lunch.ToList(), "Value", "Value"));
}
}
public static SelectList GetIntensivesBox()
{
using (var site = new SCBWIContext()) {
var intensives = from p in site.Prices
where p.Category == Category.Intensive
select p;
return(new SelectList(intensives.ToList(), "Name", "Name"));
}
}
public static SelectList GetCritiqueTypeBox()
{
using (var site = new SCBWIContext()) {
var critiques = from p in site.Prices
where p.Category == Category.Critique
select p;
return(new SelectList(critiques.ToList(), "Name", "Name"));
}
}
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 LisaWheeler GetLisaByAccount(string account)
{
var site = new SCBWIContext();
var user = (from u in site.LisaWheelers
where u.Account == account
select u).SingleOrDefault();
if (user == null)
{
return(null);
}
return(user);
}
public static User GetUserByAccount(string account)
{
var site = new SCBWIContext();
var user = (from u in site.Users
where u.Account == account
select u).SingleOrDefault();
if (user == null)
{
return(null);
}
user.Registration = site.Registrations.Find(user.RegistrationID);
return(user);
}
public static LisaWheeler ConvertToLisaWheeler(User user)
{
var site = new SCBWIContext();
var lisa = new LisaWheeler();
lisa.FirstName = user.FirstName;
lisa.LastName = user.LastName;
lisa.Address1 = user.Address1;
lisa.Address2 = user.Address2;
lisa.City = user.City;
lisa.State = user.State;
lisa.Zip = user.PostalCode;
lisa.Email = user.Email;
lisa.Phone = user.Phone;
lisa.Account = user.Account;
return(lisa);
}
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();
}
public static Date GetDate(Category c)
{
using (var site = new SCBWIContext())
{
var date = (from d in site.Dates
where d.Category == c
select d).SingleOrDefault();
if (date == null)
{
date = new Date
{
DateID = -1,
Name = "NO DATE SET",
Value = new DateTime(1, 1, 1)
};
}
return(date);
}
}
public static SelectList GetRegTypesBox()
{
using (var site = new SCBWIContext()) {
var late = (from d in site.Dates
where d.Category == Category.Late
select d).SingleOrDefault();
Category c = Category.Reg;
System.Diagnostics.Debug.WriteLine(DateTime.UtcNow);
if (late.Value < DateTime.UtcNow)
{
c = Category.RegLate;
}
var reg = from p in site.Prices
where p.Category == c
select p;
return(new SelectList(reg.ToList(), "Name", "Name"));
}
}
/*
* ------------------------------------------------------
* SETTERS
* ------------------------------------------------------
*
*/
public static Status SetupStatus()
{
using (var site = new SCBWIContext())
{
var setup = (from s in site.Information
where s.Category == Category.Ready
select s).SingleOrDefault();
if (setup == null)
{
return(Status.NotStarted);
}
if (setup.Value == "ready")
{
return(Status.Completed);
}
if (setup.Value == "in progress")
{
return(Status.InProgress);
}
return(Status.NotStarted);
}
}
public static ICollection <Critique> GetUserCritiques(string account)
{
var site = new SCBWIContext();
return(GetUserByAccount(account).Critiques.ToList());
}