// מחיקה
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();
}
}
}
