/// <summary>
/// Generic Delete method for the entities
/// </summary>
/// <param name="entityToDelete"></param>
public virtual void Delete(TEntity entityToDelete)
{
if (Context.Entry(entityToDelete).State == EntityState.Detached)
{
DbSet.Attach(entityToDelete);
}
DbSet.Remove(entityToDelete);
}
public async Task <IActionResult> Patch(int id, [FromBody] TodoTask task)
{
if (id != task.Id)
{
BadRequest();
}
_ctx.Entry(task).State = EntityState.Modified;
await _ctx.SaveChangesAsync();
return(NoContent());
}
public ProgressStatus Modify(int id, bool isdone)
{
AirPortModel.Models.FlightToDo dodo = new AirPortModel.Models.FlightToDo();
dodo = _db.FlightToDos.FirstOrDefault(x => x.id.Equals(id));
if (dodo != null)
{
dodo.IsDon = isdone;
}
try
{
_db.FlightToDos.Attach(dodo);
_db.Entry(dodo).Property(x => x.IsDon).IsModified = true;
_db.SaveChanges();
var result = new ProgressStatus {
Number = 1, Title = "Update Successful", Message = "FlightToDo Has been Update"
};
return(result);
}
catch (Exception ex)
{
var result = new ProgressStatus {
Number = 0, Title = "Update Error", Message = ex.Message
};
return(result);
}
}
public async Task <IActionResult> PutSkill([FromRoute] int id, [FromBody] Skill skill)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != skill.id)
{
return(BadRequest());
}
_context.Entry(skill).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SkillExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PutNote(int id, Note note)
{
if (id != note.Id)
{
return(BadRequest());
}
_context.Entry(note).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!NoteExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IHttpActionResult> PutOrder(int id, Order order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != order.OrderId)
{
return(BadRequest());
}
db.Entry(order).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Update(T entity)
{
if (entity == null)
{
throw new ArgumentNullException("entity was not supplied");
}
_dbSet.Attach(entity);
_dbContext.Entry(entity).State = EntityState.Modified;
}
public async Task <IActionResult> Delete(long id)
{
Person person = _context.Persons.Where(c => c.id == id).FirstOrDefault();
_context.Entry(person).Collection(c => c.skills).Load();
_context.Persons.Remove(person);
_context.SaveChanges();
return(Ok(person));
}
/// <summary>
/// Explicitly loads all audio and images associated with the specified page.
/// Additional information pages are loaded recursively in the same way.
/// </summary>
/// <param name="page"></param>
public static void LoadPageDetails(Page page)
{
// Loading must happen in one DbContext scope so that
// references between pages are correctly fixed up.
using (var db = new AppDatabaseContext(QueryTrackingBehavior.TrackAll))
{
db.Attach(page);
var pageEntry = db.Entry(page);
pageEntry.Navigation(nameof(Page.Audio)).Load();
switch (page)
{
case ImagePage imagePage:
db.Entry(imagePage).Navigation(nameof(ImagePage.Image)).Load();
break;
case TimeSliderPage timeSliderPage:
pageEntry.Navigation(nameof(TimeSliderPage.SliderImages)).Load();
foreach (var img in timeSliderPage.SliderImages)
{
db.Entry(img).Navigation(nameof(TimeSliderPageImage.Image)).Load();
}
break;
}
var subpageNav = pageEntry.Navigation(nameof(Page.AdditionalInformationPagesRefs));
// Recursively load additional information pages
// (Note: page references may be circular - this check breaks the recursion)
if (!subpageNav.IsLoaded)
{
subpageNav.Load();
foreach (var subpageRef in page.AdditionalInformationPagesRefs)
{
db.Entry(subpageRef).Navigation(nameof(JoinPagePage.AdditionalInformationPage)).Load();
LoadPageDetails(subpageRef.AdditionalInformationPage);
}
}
}
}
//сохранить новую либо обновить существующую запись в БД
public int SaveNote(Note entity)
{
if (entity.Id == default)
{
entity.Date = DateTime.Now;
context.Notes.Add(entity);
// context.Entry(entity).State = EntityState.Added;
}
else
{
context.Entry(entity).State = EntityState.Modified;
}
context.SaveChanges();
return(entity.Id);
}
public async Task UpdateComplexityAsync(Complexity complexity)
{
_context.Entry(complexity).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateGroupAsync(Group group)
{
_context.Entry(group).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateAlgorithmTaskAsync(AlgorithmTask algorithmTask)
{
_context.Entry(algorithmTask).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateExamAsync(Exam exam)
{
_context.Entry(exam).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateCategoryAsync(Category category)
{
_context.Entry(category).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateFlashcardSetAsync(FlashcardSet flashcardSet)
{
_context.Entry(flashcardSet).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public void Update(T entity)
{
_db.Entry(entity).State = EntityState.Modified;
}
public async Task UpdateCourseAsync(Course course)
{
_context.Entry(course).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateVerdictAsync(Verdict verdict)
{
_context.Entry(verdict).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateUserDataAsync(User user)
{
_context.Entry(user).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateLevelAsync(Level level)
{
_context.Entry(level).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public static string LoadSavedGame()
{
var filenames = new List <string>();
var fileNames2 = new Dictionary <int, string>();
int savedFileInt;
string savedFile;
using var ctx = new AppDatabaseContext();
do
{
Console.WriteLine("Saved Games :");
foreach (var fileName in ctx.Settings)
{
Console.WriteLine(fileName.GameSettingsId + " " + fileName.PlayerName + " " + fileName.Time.ToString("yyyy-MM-dd HH:mm"));
fileNames2.Add(fileName.GameSettingsId, fileName.PlayerName);
filenames.Add(fileName.PlayerName);
}
Console.WriteLine();
Console.WriteLine("Enter saved game number");
Console.WriteLine("Enter EXIT to leave");
Console.Write(">");
savedFile = Console.ReadLine();
if (savedFile == "EXIT")
{
return("");
}
var loadSuccess = false;
loadSuccess = int.TryParse(savedFile, out savedFileInt);
if (!loadSuccess)
{
Console.WriteLine($"{savedFile} is not a number");
}
if (!ctx.Settings.Any(n => n.GameSettingsId == savedFileInt))
{
Console.WriteLine("No Such Saved game!");
}
} while (!fileNames2.ContainsKey(savedFileInt));
GameSettings savedGame = ctx.Settings.First(n => n.GameSettingsId == savedFileInt);
if (savedGame != null)
{
ctx.Entry(savedGame).State = EntityState.Detached;
}
var game = new Game(savedGame);
game.SetBoard(savedGame?.CellStates);
bool done;
do
{
UserInterface.BoardPrint(game);
int userYInt;
bool success;
do
{
if (savedGame?.MovesCounter % 2 == 0 && savedGame.AgainstAi)
{
Console.WriteLine("Mastermind AI move");
Random r = new Random();
userYInt = r.Next(0, savedGame.BoardWidth - 1);
success = true;
}
else
{
Console.WriteLine("Enter EXIT to Go to Main Menu");
Console.WriteLine($"Enter column number(0-{savedGame?.BoardHeight - 1})");
Console.WriteLine("Your move");
Console.Write(">");
var userY = Console.ReadLine();
if (userY == "EXIT")
{
Menu.AgainstAi = false;
return("");
}
success = int.TryParse(userY, out userYInt);
if (!success || userYInt > savedGame?.BoardWidth)
{
Console.WriteLine($"{userY} is not a number or is out of board!");
success = false;
}
}
} while (!success);
savedGame.MovesCounter += game.Move(userYInt);
savedGame.CellStates = game.GetBoard();
ctx.Entry(savedGame).State = EntityState.Modified;
//ctx.Settings.Update(savedGame);
ctx.SaveChanges();
done = Validator(savedGame.CellStates, savedGame.BoardHeight, savedGame.BoardWidth);
} while (!done);
UserInterface.BoardPrint(game);
ctx.Attach(savedGame);
ctx.Remove(savedGame);
ctx.SaveChanges();
Console.WriteLine("Game Over!");
return("");
}
public async Task UpdateMultiSelectQuestionAsync(MultiSelectQuestion multiSelectQuestion)
{
_context.Entry(multiSelectQuestion).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateLessonAsync(Lesson lesson)
{
_context.Entry(lesson).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
public async Task UpdateVerificationDataAsync(VerificationData verificationData)
{
_context.Entry(verificationData).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
