public static List <teacher> GetAll() { using (odev_sql_OKULContext context = new odev_sql_OKULContext()) { return(context.teachers.ToList()); // teacher listview döndürme } }
public void TSadd(teacher teacher) //teacher insert { using (odev_sql_OKULContext context = new odev_sql_OKULContext()) { //öğretmen kayıt context.teachers.Add(teacher); context.SaveChanges(); } }
public void dvDel(ders_ver ders_) { using (odev_sql_OKULContext context = new odev_sql_OKULContext()) //Öğretmen silmek için ilişkili olduğu için bu tablodaki veriler de { //silinir. var entity = context.Entry(ders_); entity.State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } }
// Öğretmen silme ************************************************************************************************************************* public void TSdel(teacher teacher) //teacher delete { using (odev_sql_OKULContext context = new odev_sql_OKULContext()) { //öğretmen silme var entity = context.Entry(teacher); entity.State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } }
public void ResetSTDPsw(int id, string psw) //şifre yenile { psw = Encrypt(psw, "sblw-3hn8-sqoy19"); using (odev_sql_OKULContext context = new odev_sql_OKULContext()) { var entity = from s in context.students where s.std_id == id select s; foreach (student new_psw in entity) { new_psw.std_parola = psw; } context.SaveChanges(); } }
public void ResetTSPsw(int id, string psw) //Teacher şifre yenile { psw = Encrypt(psw, "sblw-3hn8-sqoy19"); using (odev_sql_OKULContext context = new odev_sql_OKULContext()) { var entity = from t in context.teachers where t.teacher_id == id select t; foreach (teacher new_psw in entity) { new_psw.teacher_password = psw; } context.SaveChanges(); } }