コード例 #1
0
 public static void NewEwithS(int idExpertise, SubjectDto subjectDto)
 {
     using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities())
     {
         Expertise expertise = placementDepartmentDB.Expertise.Find(idExpertise);
         Subject   subject   = placementDepartmentDB.Subject.Find(subjectDto.Id);
         if (!expertise.Subject.Contains(subject))
         {
             expertise.Subject.Add(subject);
             placementDepartmentDB.SaveChanges();
         }
         else
         {
             throw new Exception("Duplicate");
         }
     }
 }
コード例 #2
0
 public static void DeleteExpertise(int id)
 {
     using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities())
     {
         try
         {
             Expertise expertise = placementDepartmentDB.Expertise.Find(id);
             placementDepartmentDB.Expertise.Remove(expertise);
             placementDepartmentDB.SaveChanges();
         }
         catch (DbUpdateException ex)
         {
             var sqlException = ex.GetBaseException() as SqlException;
             if (sqlException != null)
             {
                 if (sqlException.Number == 547)
                 {
                     throw new DbUpdateException("547");
                 }
             }
         }
     }
 }