public void addClientInfo(clientInfo u)
{
tema2psEntities entities = new tema2psEntities();
entities.clientInfoes.Add(u);
entities.SaveChanges();
}
public void addUser(user u)
{
tema2psEntities entities = new tema2psEntities();
entities.users.Add(u);
entities.SaveChanges();
}
public void addcourse(course u)
{
tema2psEntities entities = new tema2psEntities();
entities.courses.Add(u);
entities.SaveChanges();
}
public void addstudentInfo(studentInfo u)
{
tema2psEntities entities = new tema2psEntities();
entities.studentInfoes.Add(u);
entities.SaveChanges();
}
public void addenrollment(enrollment u)
{
tema2psEntities entities = new tema2psEntities();
entities.enrollments.Add(u);
entities.SaveChanges();
}
public void deleteclientInfoByID(int id)
{
tema2psEntities entities = new tema2psEntities();
foreach (clientInfo uDB in entities.clientInfoes)
{
if (uDB.id == id)
{
entities.clientInfoes.Remove(uDB);
}
}
entities.SaveChanges();
}
public void deletecourseID(int id)
{
tema2psEntities entities = new tema2psEntities();
foreach (course uDB in entities.courses)
{
if (uDB.id == id)
{
entities.courses.Remove(uDB);
}
}
entities.SaveChanges();
}
public void deleteUserByID(int id)
{
tema2psEntities entities = new tema2psEntities();
foreach (user uDB in entities.users)
{
if (uDB.id == id)
{
entities.users.Remove(uDB);
}
}
entities.SaveChanges();
}
public void deleteenrollmentID(int id)
{
tema2psEntities entities = new tema2psEntities();
foreach (enrollment uDB in entities.enrollments)
{
if (uDB.id == id)
{
entities.enrollments.Remove(uDB);
}
}
entities.SaveChanges();
}
public void updatecourse(course u)
{
tema2psEntities entities = new tema2psEntities();
foreach (course uDB in entities.courses)
{
if (uDB.id == u.id)
{
uDB.name = u.name;
uDB.description = u.description;
}
}
entities.SaveChanges();
}
public void updateclientInfo(studentInfo u)
{
tema2psEntities entities = new tema2psEntities();
foreach (studentInfo uDB in entities.studentInfoes)
{
if (uDB.id == u.id)
{
uDB.userID = u.userID;
uDB.identificationNR = u.identificationNR;
uDB.groupNR = u.groupNR;
}
}
entities.SaveChanges();
}
public void updateUser(user u)
{
tema2psEntities entities = new tema2psEntities();
foreach (user uDB in entities.users)
{
if (uDB.id == u.id)
{
uDB.username = u.username;
uDB.password = u.password;
uDB.type = u.type;
}
}
entities.SaveChanges();
}
public void updateenrollment(enrollment u)
{
tema2psEntities entities = new tema2psEntities();
foreach (enrollment uDB in entities.enrollments)
{
if (uDB.id == u.id)
{
uDB.userID = u.userID;
uDB.courseID = u.courseID;
uDB.grade = u.grade;
}
}
entities.SaveChanges();
}
public void updateclientInfo(clientInfo u)
{
tema2psEntities entities = new tema2psEntities();
foreach (clientInfo uDB in entities.clientInfoes)
{
if (uDB.id == u.id)
{
uDB.adress = u.adress;
uDB.CNP = u.CNP;
uDB.identityCardNumber = u.identityCardNumber;
uDB.userID = u.userID;
uDB.name = u.name;
}
}
entities.SaveChanges();
}
