public Login GetLogin(string email, string password)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
return(context.login.Where(x => x.Email == email && x.Password == password).FirstOrDefault());;
}
}
public Student GetStudent(int ID)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
return(context.student.Find(ID));
}
}
public Teacher GetTeacher(int ID)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
return(context.teacher.Find(ID));
}
}
public void SaveLogin(Login std)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
context.login.Add(std);
context.SaveChanges();
}
}
public void EditStudent(Student std)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
context.Entry(std).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public List <Student> GetAllStudent()
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
var stds = context.student.ToList();
return(stds);
}
}
public List <Teacher> GetAllTeachers()
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
var teachers = context.teacher.ToList();
return(teachers);
}
}
public void SaveTeacher(Teacher teach)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
context.teacher.Add(teach);
context.SaveChanges();
}
}
public void DeleteStudent(int ID)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
var student = context.student.Find(ID);
context.Entry(student).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
public void DeleteTeacher(int ID)
{
var ensureDLLIsCopied = System.Data.Entity.SqlServer.SqlProviderServices.Instance;
using (var context = new TOContext())
{
var teacher = context.teacher.Find(ID);
context.Entry(teacher).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
}
