public TasksRegister Create(TasksRegister tasksRegister)
{
// Raw SQL - for university class purpose
if (tasksRegister.Deadline == null)
{
var query = @"INSERT INTO dbo.TasksRegisters(Name, UserID) VALUES(@Name, @UserID);";
_ctx.Database.ExecuteSqlCommand
(query,
new SqlParameter("@Name", tasksRegister.Name),
new SqlParameter("@UserID", tasksRegister.UserID));
}
else
{
var query = @"INSERT INTO dbo.TasksRegisters(Name, UserID, Deadline) VALUES(@Name, @UserID, @Deadline);";
_ctx.Database.ExecuteSqlCommand
(query,
new SqlParameter("@Name", tasksRegister.Name),
new SqlParameter("@UserID", tasksRegister.UserID),
new SqlParameter("@Deadline", tasksRegister.Deadline));
}
// LINQ
//_ctx.TasksRegisters.Add(tasksRegister);
_ctx.SaveChanges();
return(tasksRegister);
}
public void Update(TasksRegister tasksRegister)
{
var tasksRegisterToUpdate = _ctx.TasksRegisters.Where(t => t.UserID == tasksRegister.UserID).SingleOrDefault(ut => ut.ID == tasksRegister.ID);
if (tasksRegisterToUpdate == null)
{
throw new ApiException("No tasks registers indexed " + tasksRegister.ID);
}
tasksRegisterToUpdate.Name = tasksRegister.Name;
tasksRegisterToUpdate.Deadline = tasksRegister.Deadline;
tasksRegisterToUpdate.IsInArchive = tasksRegister.IsInArchive;
_ctx.TasksRegisters.Update(tasksRegisterToUpdate);
_ctx.SaveChanges();
}
