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!"); }