public static instation GetInstationById(int id)
{
using (var context = new PARENTSEntities1())
{
instation instationList = context.instation.FirstOrDefault(x => x.code == id);
return(instationList);
}
}
// מחיקה
public static void DeleteInstation(int code)
{
using (var context = new PARENTSEntities1())
{
instation instation = context.instation.Where(p => p.code == code).FirstOrDefault();
context.instation.Remove(instation);
context.SaveChanges();
}
}
//הוספת
public static int AddInstation(instation instation)
{
using (var context = new PARENTSEntities1())
{
instation i = context.instation.Add(instation);
context.SaveChanges();
return(i.code);
}
}
//עדכון
public static void UpdateInstation(instation instation)
{
using (var context = new PARENTSEntities1())
{
instation pro = context.instation.Where(p => p.code == instation.code).FirstOrDefault();
if (pro != null)
{
pro.code = instation.code;
pro.email = instation.email;
pro.NAME = instation.NAME;
pro.password = instation.password;
context.SaveChanges();
}
}
}
