public object GetAllWorkPackage(int idUser) { SetParameters(); _restRequest.Parameters.Clear(); _restClient.BaseUrl = new Uri(StringUri); _restRequest.AddHeader("Content-type", "application/json"); //-------------ACESSO POR TOKEN-------------------\\ _restClient.AddDefaultHeader("Authorization", "Basic " + Convert.ToBase64String(Encoding.Default.GetBytes($"apikey:{AccessToken}"))); _restRequest.AddHeader("Authorization", "Basic " + Convert.ToBase64String(Encoding.Default.GetBytes($"apikey:{AccessToken}"))); _restRequest.Resource = stringlistWorkPackage; _restRequest.RequestFormat = DataFormat.Json; var result = _restClient.Get(_restRequest); WorkPackages workPackage = DeserializeWorkPackage(result.Content); listWorkPackage = workPackage._embedded; CompareUserId(); for (int i = 0; i < listWorkPackage.Count; i++) { listWorkPackage[i].Activity = GetActivitys(listWorkPackage[i].activities.href)._embedded; } return(listWorkPackage); }
public WorkPackages loadWorkPackages() { if (mID != "") { SqlCommand cmd = new SqlCommand("select w.Name, w.Description, w.CreatedDate, w.EndDate, w.ProjectID, w.WorkPackageID from Workpackage as w where ProjectID = @id", Main.GetConnection()); cmd.Parameters.Add(new SqlParameter("id", mID)); SqlDataReader reader = cmd.ExecuteReader(); WorkPackages ws = new WorkPackages(); while (reader.Read()) { WorkPackage w = new WorkPackage(); w.Name = reader.GetString(0); w.Description = reader.GetString(1); w.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); w.EndDate = Convert.ToDateTime(reader["EndDate"]); w.ProjectID = reader.GetString(4); w.ID = reader.GetString(5); ws.Add(w); } return ws; } else return null; }