예제 #1
0
        public TmTaskManagement EditTask(TmTaskManagement EditTasks)
        {
            TmTaskManagement EditTaskCode = Context.TmTaskManagement.Where(x => x.TaskCode == EditTasks.TaskCode).FirstOrDefault();

            if (EditTaskCode == null)
            {
                return(EditTaskCode);
            }
            else
            {
                EditTaskCode.TaskName    = EditTasks.TaskName;
                EditTaskCode.SystemCode  = EditTasks.SystemCode;
                EditTaskCode.ProjectCode = EditTasks.ProjectCode;
                EditTaskCode.Comment     = EditTasks.Comment;
                EditTaskCode.Active      = true;
                EditTaskCode.Manday      = EditTasks.Manday;
                EditTaskCode.Status      = EditTasks.Status;
                EditTaskCode.StartDate   = EditTasks.StartDate;
                EditTaskCode.EndDate     = EditTasks.EndDate;
                EditTaskCode.UpdatedBy   = "TEST";
                EditTaskCode.UpdatedDate = DateTime.Now;

                Context.TmTaskManagement.Update(EditTaskCode);
                Context.SaveChanges();
                return(EditTaskCode);
            }
        }
예제 #2
0
        public void AddTasks(TaskDTO addsTask)
        {
            TmTaskManagement insert = new TmTaskManagement();

            if (insert == null)
            {
            }
            else
            {
                insert.TaskCode    = TaskRuningNo.GenerateRunningNo().Result.Code;
                insert.TaskName    = addsTask.TaskName;
                insert.ProjectCode = addsTask.ProjectCode;
                insert.Comment     = addsTask.Comment;
                insert.Manday      = addsTask.Manday;
                insert.Status      = addsTask.Status;
                insert.CreatedBy   = "Test";
                insert.CreatedDate = DateTime.Now;

                var InsertSystemCode = Context.TmTaskManagement.Where(x => x.SystemCode == addsTask.SystemCode && x.Active == false && x.SystemCode == null).FirstOrDefault();
                if (InsertSystemCode != null)
                {
                    insert.Active = false;
                    Context.TmTaskManagement.Add(insert);
                    Context.SaveChanges();
                }
                else
                {
                    insert.Active     = true;
                    insert.SystemCode = addsTask.SystemCode;
                    insert.StartDate  = addsTask.StartDate.ToLocalTime();
                    insert.EndDate    = addsTask.EndDate.ToLocalTime();
                    var countDup = Context.TmTaskManagement.Count(x => (x.StartDate >= insert.StartDate && x.EndDate <= insert.EndDate));
                    if (countDup > 0)
                    {
                        return;
                    }
                    Context.TmTaskManagement.Add(insert);
                    Context.SaveChanges();
                }
                // insert.Active = false;
                // insert.Comment = addsTask.Comment;
                // insert.Manday = addsTask.Manday;
                // insert.Status = addsTask.Status;
                // //insert.StartDate = addsTask.StartDate.ToLocalTime();
                // //insert.EndDate = addsTask.EndDate.ToLocalTime();
                // insert.CreatedBy = "Test";
                // insert.CreatedDate = DateTime.Now;

                // Context.TmTaskManagement.Add(insert);
                // Context.SaveChanges();
                // return insert;
            }
        }
예제 #3
0
        public TmTaskManagement GetTaskCode(string DateGetTaskCode)
        {
            TmTaskManagement GetTaskCode = Context.TmTaskManagement.Where(x => x.TaskName == DateGetTaskCode).FirstOrDefault();

            if (GetTaskCode == null)
            {
                return(null);
            }
            else
            {
                return(GetTaskCode);
            }
        }
예제 #4
0
        public string Deletecode(string code)
        {
            string           result;
            TmTaskManagement DeleteTaskCode = Context.TmTaskManagement.Where(x => x.TaskCode == code).FirstOrDefault();

            if (DeleteTaskCode != null)
            {
                Context.TmTaskManagement.Remove(DeleteTaskCode);
                Context.SaveChanges();
                result = "Delete Success!!";
            }
            else
            {
                result = "Error!!";
            }
            return(result);
        }
예제 #5
0
 public ActionResult <string> PutEditTask(TmTaskManagement classTask)
 {
     TaskService.EditTask(classTask);
     return(Ok(classTask));
 }