public Result Insert(DefinitionEntity entity)
{
var con = new DapperConnectionManager();
var query = new QueryEntity();
query.Entity = entity;
query.Query = @"INSERT INTO Definitions (Name, Text) VALUES(@Name, @Text)";
var result = con.InsertQuery(query);
result.Message = result.Success ? "The Definition has been created" : "An error occurred";
return(result);
}
public Result Update(DefinitionEntity entity)
{
var con = new DapperConnectionManager();
var query = new QueryEntity();
query.Entity = entity;
query.Query = @"UPDATE Definitions set Name = @Name, Text = @Text where DefinitionId = @DefinitionId";
var result = con.ExecuteQuery(query);
result.Message = result.Success ? "The Definition has been updated" : "An error occurred";
result.Entity = entity.DefinitionId;
return(result);
}
public static void Run(AlloyContext context)
{
// player exercise ID fc41c788-063b-4018-9f28-5f68a52f4e76
// caster directory ID 0cec99ba-26a5-4825-b2e2-b91b493931b5
// steamfitter scenario ID 9fd3c38e-58b0-4af1-80d1-1895af91f1f9
var mccorc1 = new DefinitionEntity()
{
Id = Guid.Parse("930bec74-0c28-40ad-811e-b1b9a7b9b00e"),
ExerciseId = Guid.Parse("fc41c788-063b-4018-9f28-5f68a52f4e76"),
DirectoryId = Guid.Parse("0cec99ba-26a5-4825-b2e2-b91b493931b5"),
ScenarioId = Guid.Parse("21ab824c-990b-4067-9baf-c6f3036ac116"),
Name = "Lab 1",
Description = "Lab 1",
DurationHours = 2
};
context.Definitions.Add(mccorc1);
context.SaveChanges();
Console.WriteLine("Seed of data has completed.");
}
