public void Add(User newItem)
{
using (IConferenceDbContext db = factory.Create())
{
db.Users.Add(newItem);
db.SaveChanges();
}
}
public void Add(Location newItem)
{
using (IConferenceDbContext db = factory.Create())
{
db.Locations.Add(newItem);
db.SaveChanges();
}
}
public void Add(Data.Entities.Conference newItem)
{
using (IConferenceDbContext db = factory.Create())
{
db.Conferences.Add(newItem);
db.SaveChanges();
}
}
public IEnumerable <User> GetItems()
{
IEnumerable <User> users = null;
using (IConferenceDbContext db = factory.Create())
{
users = db.Users;
}
return(users);
}
public void Delete(User deleteItem)
{
using (IConferenceDbContext db = factory.Create())
{
User user = db.Users
.Where(u => u.Email == deleteItem.Email)
.FirstOrDefault();
db.Users.Remove(user);
db.SaveChanges();
}
}
public IEnumerable <Location> GetItems()
{
IEnumerable <Location> locations = null;
using (IConferenceDbContext db = factory.Create())
{
locations = db.Locations;
}
return(locations);
}
public void Delete(Location deleteItem)
{
using (IConferenceDbContext db = factory.Create())
{
Location location = db.Locations
.Where(l => l.LocationId == deleteItem.LocationId)
.FirstOrDefault();
db.Locations.Remove(location);
db.SaveChanges();
}
}
public Data.Entities.Conference GetSingleItemByID(Guid conferenceId)
{
Data.Entities.Conference conference = null;
using (IConferenceDbContext db = factory.Create())
{
conference = db.Conferences.Where(l => l.ConferenceId == conferenceId)
.FirstOrDefault();
}
return(conference);
}
public IEnumerable <Data.Entities.Conference> GetItems()
{
IEnumerable <Data.Entities.Conference> conferences = null;
using (IConferenceDbContext db = factory.Create())
{
conferences = db.Conferences;
}
return(conferences);
}
public void Delete(Data.Entities.Conference deleteItem)
{
using (IConferenceDbContext db = factory.Create())
{
Data.Entities.Conference conference = db.Conferences
.Where(c => c.ConferenceId == deleteItem.ConferenceId)
.FirstOrDefault();
db.Conferences.Remove(conference);
db.SaveChanges();
}
}
public Location GetSingleItemByID(Guid LocationId)
{
Location location = null;
using (IConferenceDbContext db = factory.Create())
{
location = db.Locations.Where(l => l.LocationId == LocationId)
.FirstOrDefault();
}
return(location);
}
public User GetSingleItemByID(string Email)
{
User user = null;
using (IConferenceDbContext db = factory.Create())
{
user = db.Users
.Where(u => u.Email == Email)
.FirstOrDefault();
}
return(user);
}
public bool IsValidUser(string Email, string HashedPassword)
{
bool retval = false;
using (IConferenceDbContext db = dbFactory.Create())
{
UserService userService = new UserService(this.dbFactory);
User user = userService.GetSingleItemByID(Email);
if (user != null && user.HashedPassword == HashedPassword)
{
retval = true;
}
}
return(retval);
}
public void Update(Data.Entities.Conference changedItem)
{
using (IConferenceDbContext db = factory.Create())
{
Data.Entities.Conference conference = db.Conferences.Where(l => l.ConferenceId == changedItem.ConferenceId)
.FirstOrDefault();
conference.Abstract = changedItem.Abstract;
conference.AmountOfLastingDays = changedItem.AmountOfLastingDays;
conference.Location = changedItem.Location;
conference.StartsAt = changedItem.StartsAt;
conference.Title = changedItem.Title;
db.SaveChanges();
}
}
