public static async Task <IEnumerable <TaskFile> > GetListAsync(int taskId)
{
TaskTrackerContext db = new TaskTrackerContext();
var list = await db.TaskFiles.Where(x => x.TaskClaimId == taskId && x.Enabled).ToListAsync();
return(list);
}
public static async Task <IEnumerable <TaskComment> > GetListAsync(int taskId)
{
TaskTrackerContext db = new TaskTrackerContext();
var list = db.TaskComments.Where(x => x.Enabled && x.TaskClaimId == taskId).OrderBy(x => x.DateCreate).ToListAsync();
return(await list);
}
public static async Task <IEnumerable <int> > GetListIdsAsync(AdUser curUser, DateTime planDate)
{
TaskTrackerContext db = new TaskTrackerContext();
var list = await db.TaskPlans.Where(x => x.Enabled && DbFunctions.TruncateTime(x.PlanDate) == DbFunctions.TruncateTime(planDate)).Select(x => x.TaskPlanId).ToListAsync();
return(list);
}
public static async Task <TaskFile> GetAsync(string guid)
{
TaskTrackerContext db = new TaskTrackerContext();
Guid taskFileId = Guid.Parse(guid);
var list = await db.TaskFiles.SingleAsync(x => x.TaskFileId == taskFileId);
return(list);
}
public static async Task <IEnumerable <TaskCheckpoint> > GetListAsync(int taskId, bool?done = null)
{
TaskTrackerContext db = new TaskTrackerContext();
var list = db.TaskCheckpoints.Where(x => x.Enabled && x.TaskId == taskId && (!done.HasValue || (done.HasValue && x.Done == done))).OrderBy(x => x.OrderNum).ToListAsync();
return(await list);
}
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 static async Task SetUndoneAsync(int id, string creatorSid)
{
TaskTrackerContext db = new TaskTrackerContext();
var checkpoint = await db.TaskCheckpoints.SingleAsync(x => x.TaskCheckpointId == id);
checkpoint.Done = false;
checkpoint.UndonerSid = creatorSid;
checkpoint.DateUndone = DateTime.Now;
await db.SaveChangesAsync();
}
public static async Task CloseAsync(int id, string creatorSid)
{
TaskTrackerContext db = new TaskTrackerContext();
var checkpoint = await db.TaskCheckpoints.SingleAsync(x => x.TaskCheckpointId == id);
checkpoint.Enabled = false;
checkpoint.DeleterSid = creatorSid;
checkpoint.DateDelete = DateTime.Now;
await db.SaveChangesAsync();
}
public static void Undone(string creatorSid, int taskPlanId)
{
TaskTrackerContext db = new TaskTrackerContext();
var taskPlan = db.TaskPlans.Single(x => x.TaskPlanId == taskPlanId);
//taskPlan.Enabled = true;
//taskPlan.DeleterSid = creatorSid;
//taskPlan.DateDelete = DateTime.Now;
db.SaveChanges();
}
public static void Restore(string creatorSid, int taskPlanId)
{
TaskTrackerContext db = new TaskTrackerContext();
var taskPlan = db.TaskPlans.Single(x => x.TaskPlanId == taskPlanId);
taskPlan.Enabled = true;
taskPlan.DeleterSid = null;
taskPlan.DateDelete = null;
db.SaveChanges();
}
public static void SetUndone(int id, string creatorSid)
{
TaskTrackerContext db = new TaskTrackerContext();
var checkpoint = db.TaskCheckpoints.Single(x => x.TaskCheckpointId == id);
checkpoint.Done = false;
checkpoint.UndonerSid = creatorSid;
checkpoint.DateUndone = DateTime.Now;
db.SaveChanges();
}
public static IEnumerable <TaskCategory> GetList()
{
TaskTrackerContext db = new TaskTrackerContext();
var list = db.TaskCategories.OrderBy(c => c.OrderNum).ThenBy(c => c.Name);
if (list.Any())
{
list.First().Selected = true;
}
return(list);
}
public static IEnumerable <Project> GetList()
{
TaskTrackerContext db = new TaskTrackerContext();
var list = db.Projects.OrderBy(c => c.Name).ToList();
if (list.Any())
{
list.First().Selected = true;
}
return(list);
}
public async static Task <TaskState> Get(string sysName)
{
TaskTrackerContext db = new TaskTrackerContext();
//if (db.TaskStates.Any(x => x.SysName.ToUpper().Equals(sysName)))
//{
return(await db.TaskStates.SingleOrDefaultAsync(x => x.SysName.Equals(sysName)));
//}
//return new TaskState();
}
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 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 IEnumerable <TaskState> GetUserDefaultList()
{
TaskTrackerContext db = new TaskTrackerContext();
return(db.TaskStates.Where(x => x.UserSelectDefault));
}
public static IEnumerable <TaskState> GetList()
{
TaskTrackerContext db = new TaskTrackerContext();
return(db.TaskStates);
}
public static TaskCheckpoint Get(int id)
{
TaskTrackerContext db = new TaskTrackerContext();
return(db.TaskCheckpoints.SingleOrDefault(x => x.TaskCheckpointId == id));
}
public static async Task <TaskCheckpoint> GetAsync(int id)
{
TaskTrackerContext db = new TaskTrackerContext();
return(await db.TaskCheckpoints.SingleOrDefaultAsync(x => x.TaskCheckpointId == id));
}
public static TaskPlan Get(int id)
{
TaskTrackerContext db = new TaskTrackerContext();
return(db.TaskPlans.Single(x => x.TaskPlanId == id));
}