public List <TaskGet> GetTaskInfo(int projectId)
{
var taskInfoList = new List <TaskGet>();
using (var client = new SqlConnection(connectionString))
using (var com = new SqlCommand())
{
com.Connection = client;
com.CommandText = "SELECT PROJECT.Name AS 'Project_Name', TASK.IdTask, TASK.Name, TASK.Description, TASK.Deadline FROM TASK INNER JOIN PROJECT ON PROJECT.IdProject = TASK.IdProject WHERE TASK.IdProject = @projectId ORDER BY Task.Deadline;";
com.Parameters.AddWithValue("projectId", projectId);
client.Open();
var dr = com.ExecuteReader();
while (dr.Read())
{
var taskInfo = new TaskGet();
taskInfo.ProjectName = dr["Project_Name"].ToString();
taskInfo.IdTask = Int32.Parse(dr["IdTask"].ToString());
taskInfo.Name = dr["Name"].ToString();
taskInfo.Description = dr["Description"].ToString();
taskInfo.Deadline = DateTime.Parse(dr["Deadline"].ToString());
taskInfoList.Add(taskInfo);
}
if (!dr.HasRows)
{
return(null);
}
return(taskInfoList);
}
}
public async Task<TaskGet.response> TaskGet(TaskGet.request request, CancellationToken? token = null)
{
return await SendAsync<TaskGet.response>(request.ToXmlString(), token.GetValueOrDefault(CancellationToken.None));
}
