public override int AddTask(DotNetNuke.Modules.TaskManager.Components.Task t)
{
return(Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, NamePrefix + "AddTask"
, new SqlParameter("@TaskName", t.TaskName)
, new SqlParameter("@TaskDescription", t.TaskDescription)
, new SqlParameter("@AssignedUserId", t.AssignedUserId)
, new SqlParameter("@ModuleId", t.ModuleId)
, new SqlParameter("@TargetCompletionDate", t.TargetCompletionDate)
, new SqlParameter("@CompletedOnDate", t.CompletedOnDate)
, new SqlParameter("@CreatedByUserId", t.CreatedByUserId)
)));
}
public override void UpdateTask(DotNetNuke.Modules.TaskManager.Components.Task t)
{
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, NamePrefix + "UpdateTask"
, new SqlParameter("@TaskId", t.TaskId)
, new SqlParameter("@TaskName", t.TaskName)
, new SqlParameter("@TaskDescription", t.TaskDescription)
, new SqlParameter("@AssignedUserId", t.AssignedUserId)
, new SqlParameter("@ModuleId", t.ModuleId)
, new SqlParameter("@TargetCompletionDate", t.TargetCompletionDate)
, new SqlParameter("@CompletedOnDate", t.CompletedOnDate)
, new SqlParameter("@ContentItemId", t.ContentItemId)
, new SqlParameter("@LastModifiedByUserId", t.LastModifiedByUserId)
);
}
