public List <FinalExamPratice> ListGender()
{
GrupoBhmaisEntities myDB = new GrupoBhmaisEntities();
List <FinalExamPratice> listGender = myDB.FinalExamPratices.Where(s => s.Id > 0).ToList <FinalExamPratice>();
return(listGender);
}
public List <FinalExamPratice> ListStudentsLast(string lastName)
{
GrupoBhmaisEntities myDB = new GrupoBhmaisEntities();
List <FinalExamPratice> listLastName = myDB.FinalExamPratices.Where(s => s.LastName == lastName).ToList <FinalExamPratice>();
return(listLastName);
}
public List <FinalExamPratice> ListStudentsEmail(string email)
{
GrupoBhmaisEntities myDB = new GrupoBhmaisEntities();
List <FinalExamPratice> listEmail = myDB.FinalExamPratices.Where(s => s.EmailAddress == email).ToList <FinalExamPratice>();
return(listEmail);
}
public List <FinalExamPratice> ListStudentsBirth(DateTime date)
{
GrupoBhmaisEntities myDB = new GrupoBhmaisEntities();
List <FinalExamPratice> listBirth = myDB.FinalExamPratices.Where(s => s.BirthDate == date).ToList <FinalExamPratice>();
return(listBirth);
}
public string RemoveStudents(int id)
{
GrupoBhmaisEntities myDB = new GrupoBhmaisEntities();
FinalExamPratice myStudent = myDB.FinalExamPratices.Where(s => s.Id == id).FirstOrDefault();
myDB.FinalExamPratices.Remove(myStudent);
myDB.SaveChanges();
return("DELETE Success!");
}
public string PutStudents(int id, string FirstName, string LastName, string EmailAddress, DateTime BirthDate, string Gender)
{
GrupoBhmaisEntities myDB = new GrupoBhmaisEntities();
FinalExamPratice myStudent = myDB.FinalExamPratices.Where(s => s.Id == id).FirstOrDefault();
myStudent.FirstName = FirstName;
myStudent.LastName = LastName;
myStudent.EmailAddress = EmailAddress;
myStudent.BirthDate = BirthDate;
myStudent.Gender = Gender;
myDB.SaveChanges();
return("PUT Success!");
}
public string PostNewStudent(string FirstName, string LastName, string EmailAddress, DateTime BirthDate, string Gender)
{
GrupoBhmaisEntities myDB = new GrupoBhmaisEntities();
FinalExamPratice myStudent = new FinalExamPratice();
myStudent.FirstName = FirstName;
myStudent.LastName = LastName;
myStudent.EmailAddress = EmailAddress;
myStudent.BirthDate = BirthDate;
myStudent.Gender = Gender;
myDB.FinalExamPratices.Add(myStudent);
myDB.SaveChanges();
return("POST Success!");
}
