public static LessonLevelsDTO GetLessonLevel(long?id = null, string name = null) { if (!id.HasValue && string.IsNullOrEmpty(name)) { return(null); } try { using (var ctx = new DAL.tutorDBEntities()) { var dbLessonLevel = ctx.LessonLevels.FirstOrDefault(x => x.id == id || x.name == name); if (dbLessonLevel != null) { var lessonLevel = new LessonLevelsDTO { id = dbLessonLevel.id, name = dbLessonLevel.name }; return(lessonLevel); } throw new Exception($"Уровень обучения: {name} не найден"); } } catch (Exception ex) { return(null); } }
public static long CreateUpdateLessonLevel(LessonLevelsDTO lessonLevels) { try { using (var ctx = new DAL.tutorDBEntities()) { var dbLessonLevel = ctx.LessonLevels.FirstOrDefault(x => x.id == lessonLevels.id) ?? ctx.LessonLevels.Add(new DAL.LessonLevels()); if (ctx.LessonLevels.Any(x => x.name == lessonLevels.name && x.id != dbLessonLevel.id)) { throw new Exception($"Уровень образования: {lessonLevels.name} уже существует"); } dbLessonLevel.name = lessonLevels.name; ctx.SaveChanges(); return(dbLessonLevel.id); } } catch (Exception ex) { throw; //return -1; } }