private void DeleteDiscipline() { if (this.SelectedDiscipline == null) { return; } var messageBoxResult = MessageBox.Show(Localization["Вы уверены, что хотите удалить дисциплину?"], Localization["Подтверждение удаления"], MessageBoxButton.YesNo, MessageBoxImage.Warning); if (messageBoxResult != MessageBoxResult.Yes) { return; } _db.Disciplines.Remove(this.SelectedDiscipline); _db.SaveChangesAsync(); }
public async Task <Guid> CreateRunAsync(Guid experimentId, string gitCommitHash = "") { using (var db = new LocalDbContext()) { var run = new Run(experimentId) { GitCommitHash = gitCommitHash }; await db.Runs.AddAsync(run); await db.SaveChangesAsync(); return(run.Id); } }
private void DeleteGroup() { if (this.SelectedGroupEntity == null) { return; } var messageBoxResult = MessageBox.Show(Localization["Вы уверены, что хотите удалить группу?"], Localization["Подтверждение удаления"], MessageBoxButton.YesNo, MessageBoxImage.Warning); if (messageBoxResult != MessageBoxResult.Yes) { return; } _db.Groups.Remove(this.SelectedGroupEntity); _db.SaveChangesAsync(); }
private async Task DeleteStream() { if (this.SelectedStream == null) { return; } var messageBoxResult = MessageBox.Show(Localization["Вы уверены, что хотите удалить поток?"], Localization["Подтверждение удаления"], MessageBoxButton.YesNo, MessageBoxImage.Warning); if (messageBoxResult != MessageBoxResult.Yes) { return; } _db.Streams.Remove(this.SelectedStream); await _db.SaveChangesAsync(); }
private void DeleteDepartment() { if (this.SelectedDepartment == null) { return; } var messageBoxResult = MessageBox.Show(Localization["Вы уверены, что хотите удалить факультет?"], Localization["Подтверждение удаления"], MessageBoxButton.YesNo, MessageBoxImage.Warning); if (messageBoxResult != MessageBoxResult.Yes) { return; } _db.Departments.Remove(this.SelectedDepartment); _db.SaveChangesAsync(); }
public async Task Save(Settings settings) { using (var db = new LocalDbContext()) { if (settings.Id > 0) { db.Settings.Update(settings); } else { await db.Settings.AddAsync(settings); } Settings.SetCurrent(settings); await db.SaveChangesAsync(); } }
private async Task Save() { this.Group.Students = this.GroupStudents .Cast <StudentViewModel>() .Select(item => item.Student) .ToList(); if (this.Group.Id == 0) { _db.Groups.Add(this.Group); } else { var group = _db.Groups.Find(this.Group.Id); group?.Apply(this.Group); } await _db.SaveChangesAsync(); _token.Deactivate(); }
private async Task Save() { _entity.Name = this.StreamName; _entity.Groups = this.ChosenGroups.Cast <GroupEntity>().ToList(); _entity.Discipline = this.SelectedDiscipline; _entity.Department = this.SelectedDepartment.Id == DefaultDepartment.Id ? null : this.SelectedDepartment; _entity.ExpirationDate = this.ExpirationDate; _entity.IsActive = this.IsActive; _entity.LectureCount = this.LectureCount; _entity.LabCount = this.LaboratoryCount; _entity.PracticalCount = this.PracticeCount; _entity.Description = this.Description; _entity.Course = this.SelectedCourse.Value == DefaultCourse.Value ? (int?)null : this.SelectedCourse.Value; if (_entity.Id == default) { _context.Streams.Add(_entity); } await _context.SaveChangesAsync(); _token.Deactivate(); }
private async Task SaveAsync() { var persistentEntity = _isCreationMode ? _detachedEntity : await _context.Disciplines.FindAsync(_detachedEntity.Id); if (persistentEntity == null) { var exception = new Exception("Cannot save discipline: item not found"); Logger.Log(LogLevel.Error, exception); throw exception; } persistentEntity.Name = this.DisciplineName; persistentEntity.Description = this.DisciplineDescription; if (_isCreationMode) { _context.Disciplines.Add(persistentEntity); } await _context.SaveChangesAsync(); _token.Deactivate(); }
public void Add(Phrase phrase) { context.Add(phrase); context.SaveChangesAsync(); }
private const string WavStartMetadata = "RIFF"; // wav start metadata public async Task Migrate(LocalDbContext context) { var count = await context.LessonTypes.CountAsync(); var isLessonTypesMissed = count < 5 && count >= 3; if (isLessonTypesMissed) { context.LessonTypes.Add(new LessonTypeEntity { Name = "Аттестация" }); context.LessonTypes.Add(new LessonTypeEntity { Name = "Экзамен" }); await context.SaveChangesAsync(); } await context.Database.ExecuteSqlCommandAsync(RemoveUncascadedStudentLessons); await context.Database.ExecuteSqlCommandAsync("PRAGMA foreign_keys=off;"); await context.Database.ExecuteSqlCommandAsync ( @" CREATE TABLE GROUP_TYPE2 ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT ); INSERT INTO GROUP_TYPE2 (id, name) SELECT id, name FROM GROUP_TYPE; DROP TABLE GROUP_TYPE; ALTER TABLE GROUP_TYPE2 RENAME TO GROUP_TYPE; PRAGMA foreign_keys=off; CREATE TABLE STUDENT_LESSON2 ( id INTEGER PRIMARY KEY AUTOINCREMENT, student_id INTEGER, lesson_id INTEGER, registered INTEGER DEFAULT 0, registration_time TEXT, registration_type TEXT, mark TEXT, mark_time TEXT, FOREIGN KEY(lesson_id) REFERENCES LESSON(id) ON DELETE CASCADE, FOREIGN KEY(student_id) REFERENCES STUDENT(id) ON DELETE CASCADE ); INSERT INTO STUDENT_LESSON2 SELECT * FROM STUDENT_LESSON; DROP TABLE STUDENT_LESSON; ALTER TABLE STUDENT_LESSON2 RENAME TO STUDENT_LESSON; "); await context.Database.ExecuteSqlCommandAsync(@" CREATE TABLE `ALARM2` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `active` INTEGER DEFAULT 0, `time` INTEGER, `volume` DECIMAL ( 1 , 1 ), `sound` BLOB, `discriminator` TEXT, `resource_name` TEXT ); INSERT INTO ALARM2 (id, active, time, volume, sound) SELECT id, active, time, volume, sound FROM ALARM; DROP TABLE ALARM; ALTER TABLE ALARM2 RENAME TO ALARM; "); await context.Database.ExecuteSqlCommandAsync("PRAGMA foreign_keys=on;"); await TrySetAudioDiscriminator(context); await context.Database.ExecuteSqlCommandAsync($"PRAGMA user_version={this.To};"); }