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<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 void SetDone(int id, string creatorSid) { TaskTrackerContext db = new TaskTrackerContext(); var checkpoint = db.TaskCheckpoints.Single(x => x.TaskCheckpointId == id); checkpoint.Done = true; checkpoint.DonerSid = creatorSid; checkpoint.DateDone = DateTime.Now; db.SaveChanges(); }
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 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 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 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 IEnumerable<TaskState> GetUserDefaultList() { TaskTrackerContext db = new TaskTrackerContext(); return db.TaskStates.Where(x => x.UserSelectDefault); }
public static TaskComment Get(int id) { TaskTrackerContext db = new TaskTrackerContext(); return db.TaskComments.SingleOrDefault(x => x.TaskCommentId == id); }
public static async Task<TaskComment> GetAsync(int id) { TaskTrackerContext db = new TaskTrackerContext(); return await db.TaskComments.SingleOrDefaultAsync(x => x.TaskCommentId == id); }
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 TaskPlan Get(int id) { TaskTrackerContext db = new TaskTrackerContext(); return db.TaskPlans.Single(x => x.TaskPlanId == id); }
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 IEnumerable<TaskState> GetList() { TaskTrackerContext db = new TaskTrackerContext(); return db.TaskStates; }
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 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(); }