private bool FillODataEntityValues(IEnumerable <XElement> propertiesElements, ODataAssignment assignment)
{
foreach (XElement xElement in propertiesElements)
{
switch (xElement.Name.LocalName)
{
case "ProjectId":
if (!String.IsNullOrEmpty(xElement.Value))
{
assignment.ProjectId = Guid.Parse(xElement.Value);
}
break;
case "TaskId":
if (!String.IsNullOrEmpty(xElement.Value))
{
assignment.TaskId = Guid.Parse(xElement.Value);
}
break;
case "AssignmentId":
if (!String.IsNullOrEmpty(xElement.Value))
{
assignment.AssignmentId = Guid.Parse(xElement.Value);
}
break;
case "ResourceId":
if (!String.IsNullOrEmpty(xElement.Value))
{
assignment.ResourceId = Guid.Parse(xElement.Value);
}
break;
case "TaskName":
assignment.TaskName = xElement.Value;
break;
case ProjectServerConstants.SystemId + ProjectServerConstants.ODataReferencePostfix:
decimal systemId;
if (!String.IsNullOrEmpty(xElement.Value) && Decimal.TryParse(xElement.Value, out systemId))
{
assignment.SystemId = (int)systemId;
}
break;
case ProjectServerConstants.IssueKey + ProjectServerConstants.ODataReferencePostfix:
assignment.IssueKey = xElement.Value;
break;
case ProjectServerConstants.IssueId + ProjectServerConstants.ODataReferencePostfix:
assignment.IssueId = xElement.Value;
break;
case ProjectServerConstants.ParentEpicKey + ProjectServerConstants.ODataReferencePostfix:
assignment.ParentEpicKey = xElement.Value;
break;
case ProjectServerConstants.ParentVersionId + ProjectServerConstants.ODataReferencePostfix:
assignment.ParentVersionId = xElement.Value;
break;
case ProjectServerConstants.IssueTypeName + ProjectServerConstants.ODataReferencePostfix:
assignment.IssueTypeName = xElement.Value;
break;
}
}
return(true);
}
public void TimesheetTest()
{
Guid guidYaroslav = Guid.Parse("9f52b233-4135-e511-80d0-00155d646d0b");
//string emailYaroslav = "*****@*****.**";
Guid guidAlex = Guid.Parse("a72f2f98-bd2f-e511-80c9-00155d60910a");
//string emailAlex = "*****@*****.**";
Guid guidKiryl = Guid.Parse("79d8d031-0801-e711-80d3-00155d74dc09");
//string emailKiryl = "*****@*****.**";
int oDataEntitesPerRequest = int.Parse(ConfigurationManager.AppSettings["ODataEntitesPerRequest"]);
int oDataMaxQueryLength = int.Parse(ConfigurationManager.AppSettings["ODataMaxQueryLength"]);
int requestTimeout = int.Parse(ConfigurationManager.AppSettings["RequestTimeout"]);
bool isProjectOnline = Boolean.Parse(ConfigurationManager.AppSettings["IsProjectOnline"]);
ProjectOnlineAccessService projectOnlineAccessService = new ProjectOnlineAccessService(ConfigurationManager
.AppSettings["ProjectOnlineUrl"], ConfigurationManager.AppSettings["ProjectOnlineUserName"],
ConfigurationManager.AppSettings["ProjectOnlinePassword"], isProjectOnline, Guid.NewGuid());
ProjectOnlineODataService projectOnlineODataService = new ProjectOnlineODataService(ConfigurationManager
.AppSettings["ProjectOnlineUrl"], ConfigurationManager.AppSettings["ProjectOnlineUserName"],
ConfigurationManager.AppSettings["ProjectOnlinePassword"], isProjectOnline);
List <ODataAssignment> assignments = projectOnlineODataService
.GetODataAssignments(Guid.Parse("8cc0d309-bd02-e711-80d4-00155d70390b"));
ODataAssignment assignmentYaroslavYaroslavHours = assignments
.FirstOrDefault(x => x.TaskName == "Yaroslav Hours" && x.ResourceId == guidYaroslav);
ODataAssignment assignmentYaroslavAlexHours = assignments
.FirstOrDefault(x => x.TaskName == "Alex Hours" && x.ResourceId == guidYaroslav);
ODataAssignment assignmentKyrilKyrilHours = assignments
.FirstOrDefault(x => x.TaskName == "Kyril Hours" && x.ResourceId == guidKiryl);
ODataAssignment assignmentKyrilAlexHours = assignments
.FirstOrDefault(x => x.TaskName == "Alex Hours" && x.ResourceId == guidKiryl);
if (assignmentYaroslavYaroslavHours == null || assignmentYaroslavAlexHours == null ||
assignmentKyrilKyrilHours == null || assignmentKyrilAlexHours == null)
{
return;
}
//EnterpriseResource resourceAlex = projectOnlineAccessService.ProjectContext.EnterpriseResources.GetByGuid(guidAlex);
//projectOnlineAccessService.ProjectContext.Load(resourceAlex.Assignments);
//EnterpriseResource resourceKyril = projectOnlineAccessService.ProjectContext.EnterpriseResources.GetByGuid(guidKiryl);
//projectOnlineAccessService.ProjectContext.Load(resourceKyril.Assignments);
EnterpriseResource resourceYaroslav = projectOnlineAccessService.ProjectContext.EnterpriseResources.GetByGuid(guidYaroslav);
TimePhase timePhaseYaroslav = resourceYaroslav.Assignments.GetTimePhase(new DateTime(2017, 8, 22), new DateTime(2017, 8, 22));
projectOnlineAccessService.ProjectContext.Load(resourceYaroslav.Assignments);
projectOnlineAccessService.ProjectContext.Load(timePhaseYaroslav);
projectOnlineAccessService.ProjectContext.Load(timePhaseYaroslav.Assignments);
projectOnlineAccessService.ProjectContext.ExecuteQuery();
foreach (StatusAssignment statusAssignment in timePhaseYaroslav.Assignments)
{
if (statusAssignment.Id == assignmentYaroslavYaroslavHours.AssignmentId)
{
statusAssignment.ActualWork = "1h";
}
if (statusAssignment.Id == assignmentYaroslavAlexHours.AssignmentId)
{
statusAssignment.ActualWork = "2h";
}
if (statusAssignment.Id == assignmentKyrilKyrilHours.AssignmentId)
{
statusAssignment.ActualWork = "3h";
}
if (statusAssignment.Id == assignmentKyrilAlexHours.AssignmentId)
{
statusAssignment.ActualWork = "4h";
}
}
timePhaseYaroslav.Assignments.Update();
timePhaseYaroslav.Assignments.SubmitAllStatusUpdates($"Submitted by CSOM on {DateTime.Now}");
projectOnlineAccessService.ProjectContext.ExecuteQuery();
var temp = 1;
//projectOnlineAccessService.ProjectContext.Load(projectOnlineAccessService.ProjectContext.TimeSheetPeriods, c => c.Where(p => p.Start <= DateTime.Now && p.End >= DateTime.Now).IncludeWithDefaultProperties(p => p.TimeSheet, p => p.TimeSheet.Lines.Where(l => l.LineClass == TimeSheetLineClass.StandardLine).IncludeWithDefaultProperties(l => l.Assignment, l => l.Assignment.Task, l => l.Work)));
//projectOnlineAccessService.ProjectContext.ExecuteQuery();
}
