public InstanceDTO(ExerciseInstanceEntity entity)
{
Id = entity.Id;
TimeStamp = entity.TimeStamp;
Name = entity.Name;
TemplateName = entity.Template.Name;
DateCreated = entity.DateCreated.ToJsonString();
}
public bool Delete(int id, byte[] timeStamp)
{
var entity = new ExerciseInstanceEntity()
{
Id = id,
TimeStamp = timeStamp
};
_context.Exercises.Remove(entity);
return(_context.SaveChanges() == 1);
}
public bool Create(int templateId, Guid studentId, string name, string nameOnServer, Guid userId)
{
var entity = new ExerciseInstanceEntity() //AutoMapper
{
TemplateId = templateId,
StudentId = studentId,
Name = name,
NameOnServer = nameOnServer,
DateCreated = DateTime.UtcNow,
CreatedBy = userId,
};
_context.Exercises.Add(entity);
return(_context.SaveChanges() == 1);
}
public bool UpdateSql(ExerciseInstanceEntity entity, byte[] requestTimeStamp, string sql)
{
entity.TimeStamp = requestTimeStamp;
entity.SqlScript = sql;
return(_context.SaveChanges() == 1);
}
