public bool CheckUserId(string userId)
{
using (var db = new osu2008Entities1())
{
return(db.UserSet_Alumni.Any(x => x.UserId == userId));
}
}
public EventSet GetTByID(string id)
{
using (var db = new osu2008Entities1())
{
return(db.EventSet.FirstOrDefault(x => x.EventId == id));
}
}
public int GetIdByName(string name)
{
using (var db = new osu2008Entities1())
{
return(db.OccupationSet.First(x => x.Name == name).OccupationId);
}
}
IQueryable <EventSet_Activity> IActivityRepository.GetAll()
{
using (var db = new osu2008Entities1())
{
return(db.EventSet_Activity.ToList().AsQueryable());
}
}
public IQueryable <UserSet_Alumni> GetAll()
{
using (var db = new osu2008Entities1())
{
return(db.UserSet_Alumni /*.OfType<Activity>()*/.ToList().AsQueryable());
}
}
public IQueryable <T> GetAll()
{
using (var db = new osu2008Entities1())
{
return(db.Set <T>().ToList().AsQueryable());
}
}
public IQueryable <OccupationSet> GetAll()
{
using (var db = new osu2008Entities1())
{
return(db.OccupationSet.ToList().AsQueryable());
}
}
public IQueryable <ProgramSet> GetAll()
{
using (var db = new osu2008Entities1())
{
return(db.ProgramSet.ToList().AsQueryable());
}
}
public IQueryable <AlumniAddressSet> GetAll()
{
using (var db = new osu2008Entities1())
{
return(db.AlumniAddressSet.ToList().AsQueryable());
}
}
public IQueryable <ClassYearSet> GetAll()
{
using (var db = new osu2008Entities1())
{
return(db.ClassYearSet.ToList().AsQueryable());
}
}
public UserSet GetById(string ID)
{
using (var db = new osu2008Entities1())
{
return(db.UserSet.FirstOrDefault(x => x.UserId == ID));
}
}
EventSet_Activity IActivityRepository.GetById(string ID)
{
using (var db = new osu2008Entities1())
{
return(db.EventSet_Activity.FirstOrDefault(x => x.EventId == ID));
}
}
public IList <UserSet> ShowConnectedAlumnis(string eventId)
{
using (var db = new osu2008Entities1())
{
var join = db.EventSet.Where(c => c.EventId == eventId).Include(z => z.UserSets).FirstOrDefault();
return(join.UserSets.ToList());
}
}
public IQueryable <EventSet> GetAll()
{
osu2008Entities1 osu2008Entities1 = new osu2008Entities1();
var s = from c in osu2008Entities1.EventSet
select c;
return(s);
}
public void Create(EventSet _event)
{
using (var db = new osu2008Entities1())
{
var _entity = _event;
db.Set <EventSet>().Add(_entity);
db.SaveChanges();
}
}
public void Create(T entity)
{
using (var db = new osu2008Entities1())
{
var _entity = entity;
db.Set <T>().Add(_entity);
db.SaveChanges();
}
}
public void DeleteById(string eventId)
{
using (var db = new osu2008Entities1())
{
var entity = db.EventSet.Where(x => x.EventId == eventId).FirstOrDefault();
db.EventSet.Remove(entity);
db.SaveChanges();
}
}
public void Create(ProgramSet _program)
{
using (var db = new osu2008Entities1())
{
var program = _program;
db.ProgramSet.Add(_program);
db.SaveChanges();
}
}
public void Create(AlumniAddressSet _alumniAddress)
{
using (var db = new osu2008Entities1())
{
var alumniAddress = _alumniAddress;
db.AlumniAddressSet.Add(_alumniAddress);
db.SaveChanges();
}
}
public void Create(OccupationSet _occupation)
{
using (var db = new osu2008Entities1())
{
var occupation = _occupation;
db.OccupationSet.Add(_occupation);
db.SaveChanges();
}
}
public void Create(ClassYearSet _classYear)
{
using (var db = new osu2008Entities1())
{
var classYear = _classYear;
db.ClassYearSet.Add(_classYear);
db.SaveChanges();
}
}
public void Create(UserSet_Alumni _alumni)
{
using (var db = new osu2008Entities1())
{
var alumni = _alumni;
db.UserSet_Alumni.Add(_alumni);
db.SaveChanges();
}
}
public void Create(UserSet _user)
{
using (var db = new osu2008Entities1())
{
var user = _user;
db.UserSet.Add(_user);
db.SaveChanges();
}
}
public void AttachUser(string id, string userID)
{
using (var db = new osu2008Entities1())
{
var _event = db.EventSet.Where(x => x.EventId == id).Include(x => x.UserSets).FirstOrDefault();
var _user = db.UserSet.Where(x => x.UserId == userID).FirstOrDefault();
_event.UserSets.Add(_user);
db.SaveChanges();
}
}
