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