static void Main(string[] args)
{
var companies = new List <string>();
companies.Add("ari");
//companies.Add("agt");
foreach (var company in companies)
{
// Connect to SL database defined in App.config
Console.WriteLine("Connecting to {0} database...", company);
var connectionString = ConfigurationManager.ConnectionStrings[company].ConnectionString;
var source = new DataSource(connectionString);
if (source == null)
{
Console.WriteLine("Error establishing database connection. Exiting.");
return;
}
// Get list of ARI projects and cost codes
Console.WriteLine("Getting list of projects from SL...");
var projects = Project.FetchActiveProjects(source);
Console.WriteLine("Found {0} projects.", projects.Count);
Console.WriteLine("Getting list of cost codes from SL...");
var costCodes = CostCode.FetchCostCodes(source);
Console.WriteLine("Found {0} cost codes.", costCodes.Count);
Project.MapCostCodesToProjectList(projects, costCodes);
// Send mapped project list to API
Console.WriteLine("Sending projects to web API...");
var apiBaseUrl = ConfigurationManager.AppSettings["ApiBaseUrl"];
var apiUsername = ConfigurationManager.AppSettings["ApiUsername"];
var apiPassword = ConfigurationManager.AppSettings["ApiPassword"];
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;
var client = new RestClient(apiBaseUrl);
client.Authenticator = new HttpBasicAuthenticator(apiUsername, apiPassword);
var request = new RestRequest(Method.POST);
var requestBody = JsonConvert.SerializeObject(projects);
request.AddHeader("Content-Type", "application/json");
request.AddParameter("data", requestBody);
try
{
var response = client.Execute(request);
Console.WriteLine("Response code: {0} {1}", response.ResponseStatus, (int)response.StatusCode);
Console.WriteLine(response.Content);
}
catch (Exception e)
{
Console.WriteLine("Server error:");
Console.WriteLine(e);
}
}
// Console.WriteLine("Press any key to exit...");
// Console.ReadKey();
}
public static List <CostCode> FetchCostCodes(DataSource source)
{
var costCodeList = new List <CostCode>();
using (var connection = source.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);
sqlCommand.Connection = 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);
}