/// <summary>
/// Seed data into the table
/// </summary>
/// <param name="context">DbContext</param>
public static void Seed(this TrappistDbContext context)
{
if (context.CodingLanguage.Any())
{
return;
}
var Languages = new CodingLanguage[]
{
new CodingLanguage {
Language = ProgrammingLanguage.Java.ToString()
},
new CodingLanguage {
Language = ProgrammingLanguage.Cpp.ToString()
},
new CodingLanguage {
Language = ProgrammingLanguage.C.ToString()
}
};
foreach (CodingLanguage language in Languages)
{
context.CodingLanguage.Add(language);
}
context.SaveChanges();
}
public static void AddSampleData(DbContextOptions <CompetitionGameContext>?options)
{
using var context = new CompetitionGameContext(options);
var cSharp = new CodingLanguage
{
Id = 1, Name = "C#"
};
context.CodingLanguages.AddRange(new List <CodingLanguage>
{
cSharp
});
var sampleFibonacci = new SampleCode {
Id = 1, CodingLanguage = cSharp, Code = @"using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;
namespace Rextester
{
public class Program
{
public static void Main(string[] args)
{
var N = Console.In.ReadLine();
//Your code goes here
Console.WriteLine(""Hello, world!"");
}
}
}"
};
context.SampleCodes.AddRange(new List <SampleCode>
{
sampleFibonacci
});
var fibonacciTask = new Task
{
Id = 1,
Name = "Simple Fibonacci",
Description = "Write a program that based on the given input number (N) returns the N-th number from the Fibonacci's sequence",
ExpectedOutput = "6765\r\n",
Input = "20",
SampleCodes = new List <SampleCode>
{
sampleFibonacci
}
};
context.Tasks.AddRange(new List <Task>
{
fibonacciTask
});
context.SaveChanges();
}
public ActionResult DeleteConfirmed(int id)
{
CodingLanguage codingLanguage = db.CodingLanguages.Find(id);
db.CodingLanguages.Remove(codingLanguage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CodingLanguageId,CodingLanguageName")] CodingLanguage codingLanguage)
{
if (ModelState.IsValid)
{
db.Entry(codingLanguage).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(codingLanguage));
}
public bool CreateCodingLanguage(CodingLanguageCreate codingLanguageCreate)
{
var entity = new CodingLanguage()
{
CodingLanguageName = codingLanguageCreate.CodingLanguageName
};
_ctx.CodingLanguages.Add(entity);
return(_ctx.SaveChanges() == 1);
}
public ActionResult Create([Bind(Include = "CodingLanguageId,CodingLanguageName")] CodingLanguage codingLanguage)
{
if (ModelState.IsValid)
{
db.CodingLanguages.Add(codingLanguage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(codingLanguage));
}
public ActionResult Delete(string id)
{
CodingLanguage cToDelete = context.Find(id);
if (cToDelete == null)
{
return(HttpNotFound());
}
else
{
return(View(cToDelete));
}
}
public ActionResult Edit(string id)
{
CodingLanguage cToEdit = context.Find(id);
if (cToEdit == null)
{
return(HttpNotFound());
}
else
{
return(View(cToEdit));
}
}
// GET: CodingLanguages/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CodingLanguage codingLanguage = db.CodingLanguages.Find(id);
if (codingLanguage == null)
{
return(HttpNotFound());
}
return(View(codingLanguage));
}
public ActionResult ConfirmDelete(string id)
{
CodingLanguage cToDelete = context.Find(id);
if (cToDelete == null)
{
return(HttpNotFound());
}
else
{
context.Delete(id);
context.Commit();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(CodingLanguage n, String id)
{
CodingLanguage cToEdit = context.Find(n.Id);
if (cToEdit == null)
{
return(HttpNotFound());
}
else
{
cToEdit.Name = n.Name;
context.Commit();
return(RedirectToAction("Index"));
}
}
public static void ClearDatabaseAndSeed(TrappistDbContext dbContext)
{
dbContext.Database.EnsureDeleted();
//seed data will go here.
var Languages = new CodingLanguage[]
{
new CodingLanguage {
Language = ProgrammingLanguage.Java.ToString()
},
new CodingLanguage {
Language = ProgrammingLanguage.Cpp.ToString()
},
new CodingLanguage {
Language = ProgrammingLanguage.C.ToString()
}
};
foreach (CodingLanguage language in Languages)
{
dbContext.CodingLanguage.Add(language);
}
dbContext.SaveChanges();
}
public ActionResult Create(CodingLanguage n)
{
context.Insert(n);
context.Commit();
return(RedirectToAction("Index"));
}
public void SetLanguage(CodingLanguage lang, bool isSet)
{
desiredLanguages[lang] = isSet;
}
