public TopFive Create(NewTopFive topFive)
{
var thirdId = Query(d => d.Query <int>("SELECT Id FROM Thirds WHERE StartDate <= GETDATE() AND EndDate >= GETDATE()")).Single();
var parameters = new
{
Name = topFive.Name,
Description = topFive.Description,
ParentId = topFive.ParentId,
ThirdId = thirdId,
CreationDate = DateTime.Now,
AuthorId = topFive.AuthorId,
StatusId = topFive.StatusId,
LastStatusUpdate = DateTime.Now,
DepartmentId = topFive.DepartmentId
};
var id = Query(d => d.Query <int>(
@"
INSERT INTO TopFives (
Name, Description, ParentId, ThirdId, CreationDate, AuthorId, StatusId, DepartmentId, LastStatusUpdate) VALUES (
@Name, @Description, @ParentId, @ThirdId, @CreationDate, @AuthorId, @StatusId, @DepartmentId, @LastStatusUpdate);
SELECT CAST(SCOPE_IDENTITY() AS INT)",
parameters)).Single();
return(GetByIds(new[] { id }).Single());
}
public TopFive Create(NewTopFive topFive)
{
return(_repo.Create(topFive));
}
