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)); }