public List <CostCode> FetchCostCodesForProject(string listUrl, string projectNumber)
{
var costCodeList = new List <CostCode>();
var client = new RestClient(listUrl);
var request = new RestRequest("items", Method.GET);
request.AddQueryParameter("parentCode", projectNumber);
request.AddHeader("Accept", "application/xml");
request.AddHeader("Authorization", "OAuth " + this.accessToken.Token);
var response = client.Execute(request);
var deserializer = new XmlDeserializer();
var listItems = deserializer.Deserialize <List <ListItem> >(response);
foreach (var item in listItems)
{
var costCode = new CostCode
{
Entity = item.Level2Code.Trim(),
Description = item.Name,
ProjectNumber = item.Level1Code.Trim()
};
costCodeList.Add(costCode);
}
return(costCodeList);
}
public static List <CostCode> FetchCostCodes(DataSource dataSource)
{
var costCodeList = new List <CostCode>();
using (var connection = dataSource.CreateConnection())
{
var sqlText = "select pjt_entity, pjt_entity_desc, pjpent.project from PJPENT inner join PJPROJ on pjpent.project = pjproj.project and pjproj.status_pa = 'A'";
var sqlCommand = new SqlCommand(sqlText, connection);
SqlDataReader reader = null;
reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
var costCode = new CostCode
{
Entity = reader["pjt_entity"].ToString().Trim(),
Description = reader["pjt_entity_desc"].ToString(),
ProjectNumber = reader["project"].ToString().Trim()
};
costCodeList.Add(costCode);
}
connection.Close();
}
return(costCodeList);
}
static void Main(string[] args)
{
// Connect to SL database
Console.WriteLine("Connecting to SL database... ");
var connectionString = ConfigurationManager.ConnectionStrings["SL"].ConnectionString;
var dataSource = new DataSource(connectionString);
// Build list of active projects with their cost codes
var activeProjectList = Project.FetchActiveProjects(dataSource);
var costCodeList = CostCode.FetchCostCodes(dataSource);
Project.MapCostCodesToProjectList(activeProjectList, costCodeList);
// Connect to Concur service
Console.WriteLine("Getting access token from Concur service...");
var username = ConfigurationManager.AppSettings["ConcurUsername"];
var password = ConfigurationManager.AppSettings["ConcurPassword"];
var consumerKey = ConfigurationManager.AppSettings["ConcurConsumerKey"];
// Get access token from Concur API
var concur = new ConcurApi(username, password, consumerKey);
var concurProjectListUrl = ConfigurationManager.AppSettings["ProjectListUrl"];
// Fetch list of projects currently in Concur
Console.WriteLine("Fetching list of projects from Concur API...");
var concurProjectList = concur.FetchProjectList(concurProjectListUrl);
// Fetch cost codes currently in Concur
Console.WriteLine("Fetching cost codes for existing projects...");
int i = 0;
foreach (var oldProject in concurProjectList)
{
ClearCurrentConsoleLine();
double percentComplete = ((double)++i / (double)concurProjectList.Count) * 100.0;
Console.Write("{0} - {1}%", oldProject.Number, Math.Ceiling(percentComplete));
oldProject.CostCodes = concur.FetchCostCodesForProject(concurProjectListUrl, oldProject.Number);
}
// Find projects to be deleted
var projectsToDelete = Project.CreateListToDelete(concurProjectList, activeProjectList);
Console.WriteLine("\nFound {0} projects to be deleted.", projectsToDelete.Items.Count);
// Delete items from concur
if (projectsToDelete.Items.Count > 0)
{
Console.Write("Deleting projects from Concur...");
var deleteResponse = concur.Batch(concurProjectListUrl, projectsToDelete, "delete");
Console.WriteLine(deleteResponse.ResponseStatus.ToString());
}
// Find projects to be added
var projectsToAdd = Project.CreateListToAdd(concurProjectList, activeProjectList);
Console.WriteLine("Found {0} projects to be added.", projectsToAdd.Items.Count);
var foo = concurProjectList.Find(c => c.Number == "15OS11");
// Add items to Concur
if (projectsToAdd.Items.Count > 0)
{
Console.Write("Adding projects to Concur...");
var createResponse = concur.Batch(concurProjectListUrl, projectsToAdd, "create");
Console.WriteLine(createResponse.ResponseStatus.ToString());
}
// Find cost codes to add and remove
var costCodesToDelete = new ListItems {
Items = new List <ListItem>()
};
var costCodesToAdd = new ListItems {
Items = new List <ListItem>()
};
foreach (var project in activeProjectList)
{
var oldProject = concurProjectList.Find(p => p.Number == project.Number);
if (oldProject != null)
{
var deleteables = project.GetCostCodesToDelete(oldProject.CostCodes);
var addables = project.GetCostCodesToAdd(oldProject.CostCodes);
foreach (var cc in deleteables)
{
costCodesToDelete.Items.Add(cc);
}
foreach (var cc in addables)
{
costCodesToAdd.Items.Add(cc);
}
}
else
{
// Project is new, so all cost codes must be added
foreach (var costCode in project.CostCodes)
{
costCodesToAdd.Items.Add(new ListItem
{
Level1Code = costCode.ProjectNumber,
Level2Code = costCode.Entity,
Name = costCode.Description
});
}
}
}
Console.WriteLine("Found {0} cost codes to be added, {1} to be deleted.", costCodesToAdd.Items.Count, costCodesToDelete.Items.Count);
if (costCodesToDelete.Items.Count > 0)
{
Console.Write("Deleting old cost codes from Concur... ");
var deleteCcResponse = concur.Batch(concurProjectListUrl, costCodesToDelete, "delete");
Console.WriteLine(deleteCcResponse.ResponseStatus.ToString());
}
if (costCodesToAdd.Items.Count > 0)
{
Console.Write("Adding new cost codes to Concur... ");
var addCcResponse = concur.Batch(concurProjectListUrl, costCodesToAdd, "create");
Console.WriteLine(addCcResponse.ResponseStatus.ToString());
}
}