public static List <instation> GetAllInstation() { using (var context = new PARENTSEntities()) { List <instation> instationList = context.instation.ToList(); return(instationList); } }
public static List <times> GetAllTimes() { using (var context = new PARENTSEntities()) { List <times> timesList = context.times.ToList(); return(timesList); } }
public static List <parents> GetAllParents() { using (var context = new PARENTSEntities()) { List <parents> ParentsList = context.parents.ToList(); return(ParentsList); } }
public static parents GetParentById(string id) { using (var context = new PARENTSEntities()) { parents parentList = context.parents.FirstOrDefault(x => x.id == id); return(parentList); } }
public static List <classes> GetAllClasses() { using (var context = new PARENTSEntities()) { List <classes> classesList = context.classes.ToList(); return(classesList); } }
public static List <request> GetAllRequest() { using (var context = new PARENTSEntities()) { List <request> RequestList = context.request.ToList(); return(RequestList); } }
public static List <studens> GetAllStudents() { using (var context = new PARENTSEntities()) { List <studens> studensList = context.studens.ToList(); return(studensList); } }
public static List <parents> GetParentByCodeInstation(int id) { using (var context = new PARENTSEntities()) { List <parents> parentList = context.parents.Where(x => x.code_instation == id).ToList(); return(parentList); } }
public static List <teachers> GetTeachersByCodeInstation(int id) { using (var context = new PARENTSEntities()) { List <teachers> teachersList = context.teachers.Where(x => x.code_instation == id).ToList(); return(teachersList); } }
public static List <teachers> GetAllTeachers() { using (var context = new PARENTSEntities()) { List <teachers> teachersList = context.teachers.ToList(); return(teachersList); } }
public static List <scheduling> GetSchedulingByCodeInstation(int id) { using (var context = new PARENTSEntities()) { List <scheduling> schedulingList = context.scheduling.Where(pp => pp.studens.parents.code_instation == id).ToList(); return(schedulingList); } }
public static instation GetInstationById(int id) { using (var context = new PARENTSEntities()) { instation instationList = context.instation.FirstOrDefault(x => x.code == id); return(instationList); } }
public static List <studens> GetKids(string id) { using (var context = new PARENTSEntities()) { List <studens> studensList = context.studens.Where(s => s.id_parent == id).ToList(); return(studensList); } }
public static List <scheduling> GetAllScheduling() { using (var context = new PARENTSEntities()) { List <scheduling> schedulingList = context.scheduling.ToList(); return(schedulingList); } }
// מחיקה public static void DeleteScheduling(int id) { using (var context = new PARENTSEntities()) { scheduling scheduling = context.scheduling.Where(p => p.code == id).FirstOrDefault(); context.scheduling.Remove(scheduling); context.SaveChanges(); } }
// מחיקה public static void DeleteTeachers(string id) { using (var context = new PARENTSEntities()) { teachers teachers = context.teachers.Where(p => p.id.Equals(id)).FirstOrDefault(); context.teachers.Remove(teachers); context.SaveChanges(); } }
//הוספת public static string AddTeachers(teachers teachers) { using (var context = new PARENTSEntities()) { teachers t = context.teachers.Add(teachers); context.SaveChanges(); return(t.id); } }
// מחיקה public static void DeleteInstation(int code) { using (var context = new PARENTSEntities()) { instation instation = context.instation.Where(p => p.code == code).FirstOrDefault(); context.instation.Remove(instation); context.SaveChanges(); } }
// מחיקה public static void DeleteParents(string id) { using (var context = new PARENTSEntities()) { parents parents = context.parents.Where(p => p.id.Equals(id)).FirstOrDefault(); context.parents.Remove(parents); context.SaveChanges(); } }
// מחיקה 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 int AddScheduling(scheduling scheduling) { using (var context = new PARENTSEntities()) { scheduling s = context.scheduling.Add(scheduling); context.SaveChanges(); return(s.code); } }
public static List <scheduling> GetSchedulingByCodeClass(int id) { using (var context = new PARENTSEntities()) { List <scheduling> schedulingList = context.scheduling.Where(r => r.code_class == id).OrderBy(w => w.hour_).ToList(); return(schedulingList); } }
// מחיקה public static void DeleteRequest(string id) { using (var context = new PARENTSEntities()) { request request = context.request.Where(p => p.code.Equals(id)).FirstOrDefault(); context.request.Remove(request); context.SaveChanges(); } }
//הוספת public static int AddRequest(request request) { using (var context = new PARENTSEntities()) { request r = context.request.Add(request); context.SaveChanges(); return(r.code); } }
//הוספת public static string AddStudens(studens studens) { using (var context = new PARENTSEntities()) { studens s = context.studens.Add(studens); context.SaveChanges(); return(s.id); } }
//הוספת public static int AddClass(classes classes) { using (var context = new PARENTSEntities()) { classes c = context.classes.Add(classes); context.SaveChanges(); return(c.code); } }
//הוספת public static int AddInstation(instation instation) { using (var context = new PARENTSEntities()) { instation i = context.instation.Add(instation); context.SaveChanges(); return(i.code); } }
//הוספת public static string AddParents(parents parents) { using (var context = new PARENTSEntities()) { parents p = context.parents.Add(parents); context.SaveChanges(); return(p.id); } }
// מחיקה public static void DeleteClass(int code) { using (var context = new PARENTSEntities()) { classes classes = context.classes.Where(p => p.code == code).FirstOrDefault(); context.classes.Remove(classes); context.SaveChanges(); } }
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); } }