private void TestConnection()
{
using (AmsModel dbContext = ConnectionHelper.CreateConnection())
{
new LevelsRepository().GetLevels().ToList();
}
}
public User GetUser(string Username)
{
using (_context = ConnectionHelper.CreateConnection())
{
var User = _context.Users.FirstOrDefault(r => r.Username == Username);
return(User);
}
}
public List <User> GetUsers()
{
using (_context = ConnectionHelper.CreateConnection())
{
var Users = _context.Users.ToList();
return(Users);
}
}
public Section AddSection(Section Section)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Sections.Add(Section);
_context.SaveChanges();
}
return(Section);
}
public void DeleteRelDistributionList(Guid id)
{
using (_context = ConnectionHelper.CreateConnection())
{
var RelDistributionList = _context.RelDistributionLists.FirstOrDefault(r => r.RelDistributionListID == id);
_context.Entry(RelDistributionList).State = EntityState.Deleted;
_context.SaveChanges();
}
}
public void DeleteUser(string Username)
{
using (_context = ConnectionHelper.CreateConnection())
{
var User = _context.Users.FirstOrDefault(r => r.Username == Username);
_context.Entry(User).State = EntityState.Deleted;
_context.SaveChanges();
}
}
public Student AddStudent(Student Student)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Students.Add(Student);
_context.SaveChanges();
}
return(Student);
}
public Organization AddOrganization(Organization Organization)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Organizations.Add(Organization);
_context.SaveChanges();
}
return(Organization);
}
public void DeleteBiometric(Guid id)
{
using (_context = ConnectionHelper.CreateConnection())
{
var Biometric = _context.Biometrics.FirstOrDefault(r => r.FingerID == id);
_context.Entry(Biometric).State = EntityState.Deleted;
_context.SaveChanges();
}
}
public DistributionList AddDistributionList(DistributionList DistributionList)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.DistributionLists.Add(DistributionList);
_context.SaveChanges();
}
return(DistributionList);
}
public RelOrganization AddRelOrganization(RelOrganization RelOrganization)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.RelOrganizations.Add(RelOrganization);
_context.SaveChanges();
}
return(RelOrganization);
}
public void DeleteAttendance(Guid id)
{
using (_context = ConnectionHelper.CreateConnection())
{
var Attendance = _context.Attendances.FirstOrDefault(r => r.AttendanceID == id);
_context.Entry(Attendance).State = EntityState.Deleted;
_context.SaveChanges();
}
}
public void DeleteRelOrganization(Guid id)
{
using (_context = ConnectionHelper.CreateConnection())
{
var RelOrganization = _context.RelOrganizations.FirstOrDefault(r => r.RelOrganizationID == id);
_context.Entry(RelOrganization).State = EntityState.Deleted;
_context.SaveChanges();
}
}
public RelDistributionList AddRelDistributionList(RelDistributionList RelDistributionList)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.RelDistributionLists.Add(RelDistributionList);
_context.SaveChanges();
}
return(RelDistributionList);
}
public void DeleteContact(Guid id)
{
using (_context = ConnectionHelper.CreateConnection())
{
var Contact = _context.Contacts.FirstOrDefault(r => r.ContactID == id);
_context.Entry(Contact).State = EntityState.Deleted;
_context.SaveChanges();
}
}
public void DeleteLevel(Guid id)
{
using (_context = ConnectionHelper.CreateConnection())
{
var Level = _context.Levels.FirstOrDefault(r => r.LevelID == id);
_context.Entry(Level).State = EntityState.Deleted;
_context.SaveChanges();
}
}
public Biometric GetBiometric(Guid id)
{
using (_context = ConnectionHelper.CreateConnection())
{
var Biometric = _context.Biometrics
.Include(biometric => biometric.RelBiometrics)
.FirstOrDefault(r => r.FingerID == id);
return(Biometric);
}
}
public Attendance AddAttendance(Attendance Attendance)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Attendances.Add(Attendance);
_context.SaveChanges();
return(Attendance);
}
}
public List <RelOrganization> GetRelOrganizations()
{
List <RelOrganization> RelOrganizations;
using (_context = ConnectionHelper.CreateConnection())
{
RelOrganizations = _context.RelOrganizations.ToList();
}
return(RelOrganizations);
}
public RelOrganization GetRelOrganization(Guid id)
{
RelOrganization RelOrganization;
using (_context = ConnectionHelper.CreateConnection())
{
RelOrganization = _context.RelOrganizations.FirstOrDefault(r => r.RelOrganizationID == id);
}
return(RelOrganization);
}
public Contact AddContact(Contact Contact)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Contacts.Add(Contact);
_context.SaveChanges();
return(Contact);
}
}
public List <Biometric> GetBiometrics()
{
using (_context = ConnectionHelper.CreateConnection())
{
var Biometrics = _context.Biometrics
.Include(biometric => biometric.RelBiometrics)
.ToList();
return(Biometrics);
}
}
public RelDistributionList GetRelDistributionList(Guid id)
{
RelDistributionList RelDistributionList;
using (_context = ConnectionHelper.CreateConnection())
{
RelDistributionList = _context.RelDistributionLists.FirstOrDefault(r => r.RelDistributionListID == id);
}
return(RelDistributionList);
}
public Level AddLevel(Level Level)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Levels.Add(Level);
_context.SaveChanges();
return(Level);
}
}
public List <Organization> GetOrganizations()
{
List <Organization> Organizations;
using (_context = ConnectionHelper.CreateConnection())
{
Organizations = _context.Organizations.ToList();
}
return(Organizations);
}
public Organization GetOrganization(Guid id)
{
Organization Organization;
using (_context = ConnectionHelper.CreateConnection())
{
Organization = _context.Organizations.FirstOrDefault(r => r.OrganizationID == id);
}
return(Organization);
}
public List <DistributionList> GetDistributionLists()
{
List <DistributionList> DistributionLists;
using (_context = ConnectionHelper.CreateConnection())
{
DistributionLists = _context.DistributionLists.ToList();
}
return(DistributionLists);
}
public Biometric AddBiometric(Biometric Biometric)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Biometrics.Add(Biometric);
_context.SaveChanges();
return(Biometric);
}
}
public List <RelDistributionList> GetRelDistributionLists()
{
List <RelDistributionList> RelDistributionLists;
using (_context = ConnectionHelper.CreateConnection())
{
RelDistributionLists = _context.RelDistributionLists.ToList();
}
return(RelDistributionLists);
}
public User AddUser(User User)
{
using (_context = ConnectionHelper.CreateConnection())
{
_context.Users.Add(User);
_context.SaveChanges();
return(User);
}
}
