public static BOL.Models.Task GetTaskByIdProjectAndIdUser(int userId, int projectId)
{
string query = $"SELECT * FROM task.task where task.task.idUser={userId} and task.task.idProject={projectId};";
Func <MySqlDataReader, List <BOL.Models.Task> > func = (reader) =>
{
List <BOL.Models.Task> tasks = new List <BOL.Models.Task>();
while (reader.Read())
{
tasks.Add(ConvertorTask.convertToTask(reader));
}
return(tasks);
};
List <BOL.Models.Task> tasksList = DBAccess.RunReader(query, func);
return(tasksList[0]);
}
public static List <BOL.Models.Task> GetTasksWithUserAndProjectByProjectId(int idProject)
{
string query = $"SELECT task.task.*,task.project.name,task.user.userName FROM task.task join task.user on task.user.idUser=task.task.idUser join task.project on task.project.idProject=task.task.idProject where task.task.idProject={idProject};";
Func <MySqlDataReader, List <BOL.Models.Task> > func = (reader) =>
{
List <BOL.Models.Task> tasks = new List <BOL.Models.Task>();
while (reader.Read())
{
tasks.Add(ConvertorTask.convertToProjectWithProjectAndUser(reader));
}
return(tasks);
};
List <BOL.Models.Task> tasksList = DBAccess.RunReader(query, func);
return(tasksList);
}
public static bool CheckIfExists(BOL.Models.Task task)
{
string query = $"SELECT * FROM task.task WHERE idProject={task.IdProject} and idUser={task.IdUser};";
List <BOL.Models.Task> projects = new List <BOL.Models.Task>();
Func <MySqlDataReader, List <BOL.Models.Task> > func = (reader) =>
{
List <BOL.Models.Task> projectsWorker = new List <BOL.Models.Task>();
while (reader.Read())
{
projectsWorker.Add(ConvertorTask.convertToTask(reader));
}
return(projectsWorker);
};
List <BOL.Models.Task> ProjectWorker = DBAccess.RunReader(query, func);
if (ProjectWorker != null && ProjectWorker.Count > 0)
{
return(true);
}
return(false);
}
