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; }