// מחיקה public static void DeleteStudens(string id) { using (var context = new PARENTSEntities()) { studens studens = context.studens.Where(p => p.id.Equals(id)).FirstOrDefault(); context.studens.Remove(studens); context.SaveChanges(); } }
//הוספת public static string AddStudens(studens studens) { using (var context = new PARENTSEntities()) { studens s = context.studens.Add(studens); context.SaveChanges(); return(s.id); } }
public static parents GetParentByIdStudent(string id) { using (var context = new PARENTSEntities()) { studens student = context.studens.Where(s => s.id == id).FirstOrDefault(); parents parentList = context.parents.Where(p => p.id == student.id_parent).FirstOrDefault(); return(parentList); } }
//עדכון public static void UpdateStudens(studens studens) { using (var context = new PARENTSEntities()) { studens s = context.studens.Where(x => x.id == studens.id).FirstOrDefault(); if (s != null) { s.id = studens.id; s.last_name = studens.last_name; s.first_name = studens.first_name; s.code_class = studens.code_class; s.id_parent = studens.id_parent; context.SaveChanges(); } } }