private static DataSet GetJobDetails(string sqlsPath, string eodDate, IJobDetailRepository jobDetailRepository)
{
var xdoc = XDocument.Load(sqlsPath);
var result = from item in xdoc.Element("sqls")?.Elements("category")
select new
{
Category = item.Attribute("Name")?.Value,
Sqls = (from sql in item.Elements("sql")
select new
{
Priority = sql.Attribute("priority")?.Value,
Description = sql.Attribute("description")?.Value,
SqlStatement = sql.Value
}).OrderBy(x => x.Priority).ToList()
};
DataSet dataSet = new DataSet();
foreach (var category in result)
{
DataTable jobDeatils = new DataTable(category.Category);
foreach (var sql in category.Sqls)
{
var table = jobDetailRepository.GetJobDetail(sql.SqlStatement.Replace("{eodDate}", eodDate), category.Category);
if (table.Rows.Count != 0)
{
break;
}
}
dataSet.Tables.Add(jobDeatils);
}
return(dataSet);
}
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);
}
// GET: Account
public DefinitionController(IUserRepository userRepository,
ICompanyRepository companyRepository,
IContractRepository contractRepository,
IDriverRepository driverRepository,
IFlightCodeRepository flightCodeRepository,
IJobDetailRepository jobDetailRepository,
IJobTypeRepository jobTypeRepository,
IMeetingPointRepository meetingPointRepository,
IVehicleRepository vehicleRepository,
IVehicleTypeRepository vehicleTypeRepository
)
{
_userRepository = userRepository;
_companyRepository = companyRepository;
_contractRepository = contractRepository;
_driverRepository = driverRepository;
_flightCodeRepository = flightCodeRepository;
_jobDetailRepository = jobDetailRepository;
_jobTypeRepository = jobTypeRepository;
_meetingPointRepository = meetingPointRepository;
_vehicleRepository = vehicleRepository;
_vehicleTypeRepository = vehicleTypeRepository;
}
public JobDetailService(IJobDetailRepository jobDetailRepository)
{
_jobDetailRepository = jobDetailRepository;
}
