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); } }
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; } }
public TmTaskManagement GetTaskCode(string DateGetTaskCode) { TmTaskManagement GetTaskCode = Context.TmTaskManagement.Where(x => x.TaskName == DateGetTaskCode).FirstOrDefault(); if (GetTaskCode == null) { return(null); } else { return(GetTaskCode); } }
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); }
public ActionResult <string> PutEditTask(TmTaskManagement classTask) { TaskService.EditTask(classTask); return(Ok(classTask)); }