public static async Task CloseAsync(int id, string creatorSid)
{
TaskTrackerContext db = new TaskTrackerContext();
var checkpoint = await db.TaskComments.SingleAsync(x => x.TaskCommentId == id);
checkpoint.Enabled = false;
checkpoint.DeleterSid = creatorSid;
checkpoint.DateDelete = DateTime.Now;
await db.SaveChangesAsync();
}
public async Task<int> AddAsync(string creatorSid)
{
TaskTrackerContext db = new TaskTrackerContext();
Enabled = true;
CreatorSid = creatorSid;
DateCreate = DateTime.Now;
db.TaskCheckpoints.Add(this);
await db.SaveChangesAsync();
return TaskCheckpointId;
}
public static async Task AddRange(string creatorSid,DateTime planDate, int[] taskIds, int[] checkpointIds)
{
if (taskIds == null && checkpointIds == null) throw new ArgumentException("Не указаны задачи и контрольные точки для сохранения");
TaskTrackerContext db = new TaskTrackerContext();
var taskPlanList = new List<TaskPlan>();
if (taskIds != null && taskIds.Any())
{
foreach (int taskId in taskIds)
{
var taskPlan = new TaskPlan()
{
PlanDate = planDate,
TaskId = taskId,
Enabled = true,
CreatorSid = creatorSid,
DateCreate = DateTime.Now
};
taskPlanList.Add(taskPlan);
}
//taskPlanList = taskIds.Select(delegate(int taskId)
//{
// return new TaskPlan()
// {
// PlanDate = planDate,
// TaskId = taskId,
// Enabled = true,
// CreatorSid = creatorSid,
// DateCreate = DateTime.Now
// };
//}).ToList();
}
if (checkpointIds != null && checkpointIds.Any())
{
taskPlanList.AddRange(checkpointIds.Select(checkpointId => new TaskPlan()
{
PlanDate = planDate,
TaskId = TaskCheckpoint.Get(checkpointId).TaskId,
TaskCheckpointId = checkpointId,
Enabled = true,
CreatorSid = creatorSid,
DateCreate = DateTime.Now
}));
}
db.TaskPlans.AddRange(taskPlanList);
await db.SaveChangesAsync();
}
public async Task<System.Guid> Add(string creatorSid)
{
TaskTrackerContext db = new TaskTrackerContext();
TaskFileId=Guid.NewGuid();
Enabled = true;
CreatorSid = creatorSid;
DateCreate = DateTime.Now;
db.TaskFiles.Add(this);
await db.SaveChangesAsync();
return TaskFileId;
}
public static async Task SetDoneAsync(int id, string creatorSid)
{
TaskTrackerContext db = new TaskTrackerContext();
var checkpoint = await db.TaskCheckpoints.SingleAsync(x => x.TaskCheckpointId == id);
checkpoint.Done = true;
checkpoint.DonerSid = creatorSid;
checkpoint.DateDone = DateTime.Now;
await db.SaveChangesAsync();
}