/// <summary>
/// AddTask
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public bool AddTask(TaskModel taskModel)
{
TaskEntities entity = new TaskEntities();
Task addTask = new Task();
addTask.Task1 = taskModel.Task;
if (taskModel.StartDateString != null)
{
addTask.Start_Date = Convert.ToDateTime(taskModel.StartDateString);
}
if (taskModel.EndDateString != null)
{
addTask.End_Date = Convert.ToDateTime(taskModel.EndDateString);
}
addTask.Priority = taskModel.Priority;
addTask.Parent_Id = taskModel.ParentId;
if (!string.IsNullOrEmpty(taskModel.ParentTask))
{
ParentTask pTask = new ParentTask();
pTask.Parent_Task = taskModel.ParentTask;
addTask.ParentTask = pTask;
}
entity.Tasks.Add(addTask);
entity.SaveChanges();
return(true);
}
/// <summary>
/// GetAllTask
/// </summary>
/// <returns></returns>
public List <TaskModel> GetAllTask()
{
TaskEntities entity = new TaskEntities();
var taskE = (from task in entity.Tasks.Include("ParentTask")
select new TaskModel()
{
TaskId = task.Task_Id,
Task = task.Task1,
ParentTask = task.ParentTask.Parent_Task,
Priority = task.Priority,
StartDate = task.Start_Date,
EndDate = task.End_Date,
ParentId = task.ParentTask.Parent_Id,
}).ToList();
if (taskE != null)
{
foreach (var item in taskE)
{
if (item.StartDate != null)
{
item.StartDateString = item.StartDate.ToString();
}
if (item.EndDate != null)
{
item.EndDateString = item.EndDate.ToString();
}
}
}
return(taskE);
}
/// <summary>
/// GetTaskById
/// </summary>
/// <param name="taskId"></param>
/// <returns></returns>
public TaskModel GetTaskById(int taskId)
{
TaskEntities entity = new TaskEntities();
var taskE = (from task in entity.Tasks.Include("ParentTask")
where task.Task_Id == taskId
select new TaskModel()
{
TaskId = task.Task_Id,
Task = task.Task1,
ParentTask = task.ParentTask.Parent_Task,
Priority = task.Priority,
StartDate = task.Start_Date,
EndDate = task.End_Date,
ParentId = task.ParentTask.Parent_Id,
}).FirstOrDefault();
if (taskE != null)
{
if (taskE.StartDate != null)
{
taskE.StartDateString = taskE.StartDate.ToString();
}
if (taskE.EndDate != null)
{
taskE.EndDateString = taskE.EndDate.ToString();
}
}
return(taskE);
}
/// <summary>
/// DeleteTask
/// </summary>
/// <param name="taskId"></param>
/// <returns></returns>
public bool DeleteTask(TaskModel taskModel)
{
TaskEntities entity = new TaskEntities();
var taskE = entity.Tasks.Where(x => x.Task_Id == taskModel.TaskId).FirstOrDefault();
if (taskE != null)
{
entity.Tasks.Remove(taskE);
entity.SaveChanges();
}
return(true);
}
/// <summary>
/// UpdateTask
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public bool UpdateTask(TaskModel taskModel)
{
TaskEntities entity = new TaskEntities();
var taskE = entity.Tasks.Where(x => x.Task_Id == taskModel.TaskId).FirstOrDefault();
if (taskE != null)
{
taskE.Task1 = taskModel.Task;
if (taskModel.StartDateString != null)
{
taskE.Start_Date = Convert.ToDateTime(taskModel.StartDateString);
}
if (taskModel.EndDateString != null)
{
taskE.End_Date = Convert.ToDateTime(taskModel.EndDateString);
}
taskE.Priority = taskModel.Priority;
taskE.Parent_Id = taskModel.ParentId;
entity.SaveChanges();
}
return(true);
}
public List <TaskModel> SearchTask(TaskModel taskModel)
{
TaskEntities entity = new TaskEntities();
DateTime startDate = DateTime.Now;
DateTime endDate = DateTime.Now;
if (!string.IsNullOrEmpty(taskModel.StartDateString))
{
startDate = Convert.ToDateTime(taskModel.StartDateString);
}
if (!string.IsNullOrEmpty(taskModel.EndDateString))
{
endDate = Convert.ToDateTime(taskModel.EndDateString);
}
var taskE = (from task in entity.Tasks.Include("ParentTask")
//where ((!string.IsNullOrEmpty(taskModel.Task) ? task.Task1.Contains(taskModel.Task) : true)
//&& (!string.IsNullOrEmpty(taskModel.ParentTask) ? task.ParentTask.Parent_Task.Contains(taskModel.ParentTask) : true)
//&& ((taskModel.Priority != null && taskModel.PriorityEnd != null && task.Priority >= taskModel.Priority && task.Priority <= taskModel.PriorityEnd) || (taskModel.Priority != null && taskModel.PriorityEnd == null && task.Priority >= taskModel.Priority) || (taskModel.PriorityEnd != null && taskModel.Priority != null && task.Priority <= taskModel.PriorityEnd))
//&& ((taskModel.StartDate != null && taskModel.EndDate != null && task.Start_Date >= startDate && task.End_Date <= endDate) || (taskModel.StartDate != null && taskModel.EndDate == null && task.Start_Date >= startDate) || (taskModel.EndDate != null && taskModel.StartDate == null && task.End_Date <= endDate))
//)
select new TaskModel()
{
TaskId = task.Task_Id,
Task = task.Task1,
ParentTask = task.ParentTask.Parent_Task,
Priority = task.Priority,
StartDate = task.Start_Date,
EndDate = task.End_Date,
ParentId = task.ParentTask.Parent_Id,
}).ToList();
List <TaskModel> taskDeatisls = taskE;
if (!string.IsNullOrEmpty(taskModel.Task))
{
taskDeatisls = taskDeatisls.Where(x => x.Task.ToUpper() == taskModel.Task.ToUpper()).ToList();
}
if (!string.IsNullOrEmpty(taskModel.ParentTask))
{
taskDeatisls = taskDeatisls.Where(x => x.ParentTask.ToUpper() == taskModel.ParentTask.ToUpper()).ToList();
}
int?startPriority = taskModel.Priority;
int?endPriority = taskModel.PriorityEnd;
if (taskModel.Priority != null && taskModel.PriorityEnd != null)
{
taskDeatisls = taskDeatisls.Where(x => x.Priority <= endPriority && x.Priority >= startPriority).ToList();
}
if (taskModel.Priority != null && taskModel.PriorityEnd == null)
{
taskDeatisls = taskDeatisls.Where(x => x.Priority == startPriority).ToList();
}
if (taskModel.Priority == null && taskModel.PriorityEnd != null)
{
taskDeatisls = taskDeatisls.Where(x => x.Priority == endPriority).ToList();
}
if (!string.IsNullOrEmpty(taskModel.StartDateString) && !string.IsNullOrEmpty(taskModel.EndDateString))
{
taskDeatisls = taskDeatisls.Where(x => x.StartDate <= endDate && x.EndDate >= startDate).ToList();
}
if (!string.IsNullOrEmpty(taskModel.StartDateString) && string.IsNullOrEmpty(taskModel.EndDateString))
{
taskDeatisls = taskDeatisls.Where(x => x.StartDate == startDate).ToList();
}
if (string.IsNullOrEmpty(taskModel.StartDateString) && !string.IsNullOrEmpty(taskModel.EndDateString))
{
taskDeatisls = taskDeatisls.Where(x => x.EndDate == endDate).ToList();
}
if (taskDeatisls != null)
{
foreach (var item in taskDeatisls)
{
if (item.StartDate != null)
{
item.StartDateString = item.StartDate.ToString();
}
if (item.EndDate != null)
{
item.EndDateString = item.EndDate.ToString();
}
}
}
return(taskDeatisls);
}