public User CreateUser(User user, Location location)
{
User createdUser = null;
using (var db = new EventRegEntities())
{
using (var tx = db.Database.BeginTransaction())
{
var queriedLocation = db.Locations.Where(l =>
l.city.Equals(location.city, StringComparison.OrdinalIgnoreCase) &&
l.state.Equals(location.state, StringComparison.OrdinalIgnoreCase) &&
l.zip == location.zip && l.address.Equals(location.address, StringComparison.OrdinalIgnoreCase))
.FirstOrDefault();
if (queriedLocation != null)
{
user.location_ID = queriedLocation.location_ID;
}
else
{
db.Locations.Add(location);
db.SaveChanges();
user.location_ID = location.location_ID;
}
createdUser = db.Users.Add(user);
db.SaveChanges();
tx.Commit();
}
}
return(createdUser);
}
public Event CreateEvent(Event newEvent, Location location)
{
Event createdEvent;
using (var db = new EventRegEntities())
{
using (var tx = db.Database.BeginTransaction(IsolationLevel.Unspecified))
{
var queriedLocation = db.Locations.Where(l =>
l.city.Equals(location.city, StringComparison.OrdinalIgnoreCase) &&
l.state.Equals(location.state, StringComparison.OrdinalIgnoreCase) &&
l.zip == location.zip && l.address.Equals(location.address, StringComparison.OrdinalIgnoreCase))
.FirstOrDefault();
if (queriedLocation != null)
{
newEvent.location_ID = queriedLocation.location_ID;
}
else
{
db.Locations.Add(location);
db.SaveChanges();
newEvent.location_ID = location.location_ID;
}
createdEvent = db.Events.Add(newEvent);
db.SaveChanges();
tx.Commit();
}
}
return(createdEvent);
}
public void UpdateEvent(Event theEvent, Location location)
{
using (var db = new EventRegEntities())
{
using (var tx = db.Database.BeginTransaction())
{
db.Entry(location).State = System.Data.Entity.EntityState.Modified;
db.Entry(theEvent).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
tx.Commit();
}
}
}
public IQueryable <Event> GetAllEvents()
{
IQueryable <Event> events;
using (var db = new EventRegEntities())
{
using (var tx = db.Database.BeginTransaction(IsolationLevel.Unspecified))
{
events = db.Events;
tx.Commit();
}
}
return(events);
}
public User GetUser(int userId)
{
User user = null;
using (var db = new EventRegEntities())
{
using (var tx = db.Database.BeginTransaction())
{
user = db.Users.Find(userId);
tx.Commit();
}
}
return(user);
}
public IEnumerable <User> GetAllUsersWithLocationInfo()
{
IEnumerable <User> users = null;
using (var db = new EventRegEntities())
{
using (var tx = db.Database.BeginTransaction())
{
users = db.Users.Include(u => u.Location).ToList();
tx.Commit();
}
}
return(users);
}
public void DeleteUser(int userId)
{
using (var db = new EventRegEntities())
{
using (var tx = db.Database.BeginTransaction())
{
var userToBeDeleted = db.Users.Find(userId);
var numberOfUsersWithSameLocation = db.Users
.Include(u => u.Location)
.Where(u => u.location_ID == userToBeDeleted.location_ID)
.Count();
if (numberOfUsersWithSameLocation == 0)
{
var location = db.Locations.Find(userToBeDeleted.location_ID);
db.Locations.Remove(location);
}
db.Users.Remove(userToBeDeleted);
db.SaveChanges();
tx.Commit();
}
}
}