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