public bool InviteCustomers(string outputFilename)
{
var customerWithinRadius = GetCustomersWithinRadius();
if (customerWithinRadius.Count > 0)
{
var output = ToCustomerOutput(customerWithinRadius);
return(FileHanlder.CreateOutputFile(outputFilename, output));
}
Console.WriteLine("There is no customers within radius of given coordinates.");
return(false);
}
public int GenerateCommandLineTextFile(SybaseInfo sybaseInfo, string outputPath, string sqlXmlPath, string eodDate, FileHanlder fileHanlder)
{
string connectionString =
$"Data Source={sybaseInfo.ServerName};Port={sybaseInfo.Port};Initial Catalog={sybaseInfo.DatabaseName};UID={sybaseInfo.UserName};PWD={sybaseInfo.Password};Connection Timeout=120;Command Timeout=120;";
JobDetailRepository = new JobDetailRepository(connectionString);
var jobDetailsTable = new DataTable();
var jobDetailSet = GetJobDetails(sqlXmlPath, eodDate, JobDetailRepository);
foreach (DataTable table in jobDetailSet.Tables)
{
jobDetailsTable.Merge(table);
}
return(0);
}
