public void SetupDependencies() { var configurationManager = new ConfigurationManagerAdapter(); var configuration = new AppConfiguration(configurationManager); SqlQueryExecutor = new SqlQueryExecutor(configuration); }
public TemporalTableSqlExecutor( ISqlQueryExecutor <TContext> sqlQueryExecutor, ITemporalTableSqlBuilder <TContext> temporalTableSqlBuilder) { this.sqlQueryExecutor = sqlQueryExecutor; this.temporalTableSqlBuilder = temporalTableSqlBuilder; }
public void LogXuatPhieu(string status, string content) { string sql = String.Format("INSERT INTO LogXuatPhieu VALUES(CONVERT(datetime, '{0}', 103),'{1}', '{2}')", DateTime.Now, status, content); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); sqlQueryExecutor.ExecuteUpdate(sql); }
public void InsertAlarm(ALARM alarm) { string sql = String.Format("INSERT INTO ALARM VALUES('{0}','{1}', CONVERT(datetime, '{2}', 103), CONVERT(datetime, '{3}', 103), '{4}', '{5}', '{6}', '{7}', CONVERT(datetime, '{8}', 103))", alarm.DLU, alarm.ERL, alarm.startDate, alarm.endDate, alarm.isSuccess, alarm.LevelAlarm, alarm.Status, alarm.HOST, alarm.dateEvent); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); sqlQueryExecutor.ExecuteUpdate(sql); }
public SearchService( IReportsDataSourceFactory reportsDataSourceFactory, ISqlQueryExecutor sqlQueryExecutor, IRenderFilterService renderFilterService) { this.reportsDataSourceFactory = reportsDataSourceFactory; this.sqlQueryExecutor = sqlQueryExecutor; this.renderFilterService = renderFilterService; }
public DataTable GetMaxTimeEvent(string host) { string sql = "SELECT MAX(DateEvent) AS MAXDATE FROM ALARM WHERE HOST = '" + host + "'"; sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); DataTable result = new DataTable(); result = sqlQueryExecutor.Execute(sql); return(result); }
public DataTable GetDMVeTinh(string dlu, string host) { string sql = String.Format("SELECT * FROM QuanLyVT WHERE UR = '{0}' AND Host = '{1}'", dlu, host); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); DataTable lsAlarm = new DataTable(); lsAlarm = sqlQueryExecutor.Execute(sql); return(lsAlarm); }
public DataTable GetDMAlarm(string maAlarm, string host, string loai) { string sql = String.Format("SELECT * FROM DM_ALARM WHERE MaAlarm = '{0}' AND HOST = '{1}' AND Loai = '{2}'", maAlarm, host, loai); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); DataTable lsAlarm = new DataTable(); lsAlarm = sqlQueryExecutor.Execute(sql); return(lsAlarm); }
public DataTable GetAlarmBegin(ALARM alarm) { string sql = String.Format("SELECT * FROM ALARM WHERE DLU = '{0}' AND ERL = '{1}' AND HOST = '{2}' AND IsSuccess = 0 ORDER BY ID desc", alarm.DLU, alarm.ERL, alarm.HOST); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); DataTable lsAlarm = new DataTable(); lsAlarm = sqlQueryExecutor.Execute(sql); return(lsAlarm); }
public DataTable GetAlarmBeginCCSM(ALARM alarm) { string sql = String.Format("SELECT * FROM PSTNAlarmTapTrung WHERE NAlarm like '{0}%' AND TrangThaiEnd = 0 ORDER BY MaSend desc", alarm.HOST + "_" + alarm.DLU + "_" + alarm.ERL + "_"); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); DataTable lsAlarm = new DataTable(); lsAlarm = sqlQueryExecutor.Execute(sql); return(lsAlarm); }
public void UpdateAlarmEndCCSM(ALARM alarm) { var lsAlarm = GetAlarmBeginCCSM(alarm); if (lsAlarm.Rows.Count > 0) { string sql = String.Format("UPDATE PSTNAlarmTapTrung SET TimeEnd = '{0}', TrangThaiEnd = 1, TrangThaiXL = 0 WHERE MaSend = {1}", alarm.endDate.Value.ToString("dd/MM/yyyy HH:mm:ss"), lsAlarm.Rows[0]["MaSend"]); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); sqlQueryExecutor.ExecuteUpdate(sql); } }
public void UpdateAlarmEnd(ALARM alarm) { var lsAlarm = GetAlarmBegin(alarm); if (lsAlarm.Rows.Count > 0) { string sql = String.Format("UPDATE ALARM SET EndDate = CONVERT(datetime, '{0}', 103), IsSuccess = 1, DateEvent = CONVERT(datetime, '{1}', 103) WHERE ID = {2}", alarm.endDate, alarm.dateEvent, lsAlarm.Rows[0]["ID"]); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); sqlQueryExecutor.ExecuteUpdate(sql); } }
public MainViewModel(ISqlQueryExecutor sqlExecutor, IMainView mainView, IWindowsIdentityProvider windowsIdentityProvider, IDBInfoBuilder dbInfoBuilder) { _sqlExecutor = sqlExecutor; _mainView = mainView; _dbInfoBuilder = dbInfoBuilder; AllDataBases = new ObservableCollection <DBInfoListItem>(); Connect = new RelayCommand(ConnectClicked); Analyse = new RelayCommand(AnalyseClicked, CanClickAnalyse); ShowAboutWindow = new RelayCommand(AboutClicked); SqlConnectionSettingsViewModel = new SqlConnectionSettingsViewModel(windowsIdentityProvider); HelpText = INIT_TEXT; }
public MainViewModel(ISqlQueryExecutor sqlExecutor, IMainView mainView, IWindowsIdentityProvider windowsIdentityProvider, IDBInfoBuilder dbInfoBuilder) { _sqlExecutor = sqlExecutor; _mainView = mainView; _dbInfoBuilder = dbInfoBuilder; AllDataBases = new ObservableCollection<DBInfoListItem>(); Connect = new RelayCommand(ConnectClicked); Analyse = new RelayCommand(AnalyseClicked, CanClickAnalyse); ShowAboutWindow = new RelayCommand(AboutClicked); SqlConnectionSettingsViewModel = new SqlConnectionSettingsViewModel(windowsIdentityProvider); HelpText = INIT_TEXT; }
public DataBasesPresenter(IDataBasesView view, ISqlQueryExecutor sqlExecutor, IWindowsIdentityProvider windowsIdentityProvider, IDBInfoBuilder dbInfoBuilder) { _view = view; _sqlExecutor = sqlExecutor; _windowsIdentityProvider = windowsIdentityProvider; _dbInfoBuilder = dbInfoBuilder; _view.Shown += _view_Shown; _view.ConnectClicked += _view_ConnectClicked; _view.DataBaseCheckedChanged += _view_DataBaseCheckedChanged; _view.AnalyseClicked += _view_AnalyseClicked; }
public void LoadDLUCombobox(string host) { string sql = String.Format("SELECT UR, TenVT FROM QuanLyVT WHERE Host = '{0}' UNION SELECT 0 MaDLU, N'Tất cả' Name", host); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); DataTable dt = new DataTable(); dt = sqlQueryExecutor.Execute(sql); cbDLU.ValueMember = "UR"; cbDLU.DisplayMember = "TenVT"; cbDLU.DataSource = dt; }
public DatabaseDetailsViewModel(ISqlQueryExecutor queryExecutor, string databaseConnectionString, string databaseName, IDatabaseDetailsWindow view) { _queryExecutor = queryExecutor; _databaseConnectionString = databaseConnectionString; WindowCaption = string.Format("Database {0} tables details", databaseName); _numValues = DEFAULT_NUM_VALUES_TO_SHOW; _characteristicToDisplay = Characteristic.DataSize; ItemsToShow = new ObservableCollection <TableInfoViewItem>(); Refresh = new RelayCommand(RefreshClicked); ProgressVisible = false; ProgressValue = 0; view.Loaded += (sender, args) => RefreshClicked(); _queryExecutor.TableLoadProgressChanged += queryExecutor_TableLoadProgressChanged; }
public DatabaseDetailsViewModel(ISqlQueryExecutor queryExecutor, string databaseConnectionString, string databaseName, IDatabaseDetailsWindow view) { _queryExecutor = queryExecutor; _databaseConnectionString = databaseConnectionString; WindowCaption = string.Format("Database {0} tables details", databaseName); _numValues = DEFAULT_NUM_VALUES_TO_SHOW; _characteristicToDisplay = Characteristic.DataSize; ItemsToShow = new ObservableCollection<TableInfoViewItem>(); Refresh = new RelayCommand(RefreshClicked); ProgressVisible = false; ProgressValue = 0; view.Loaded += (sender, args) => RefreshClicked(); _queryExecutor.TableLoadProgressChanged += queryExecutor_TableLoadProgressChanged; }
public DatabaseDetailsPresenter(IDatabaseDetailsView view, ISqlQueryExecutor queryExecutor, string databaseConnectionString, string databaseName) { _view = view; _queryExecutor = queryExecutor; _databaseConnectionString = databaseConnectionString; _view.Shown += view_RefreshClicked; _view.RefreshClicked += view_RefreshClicked; _view.SelectedCharacteristicChanged += view_SelectedDataToDisplayChanged; _view.SetCaption(string.Format("Database {0} details", databaseName)); _loadDataWorker.DoWork += loadDataWorker_DoWork; _loadDataWorker.WorkerReportsProgress = true; _loadDataWorker.ProgressChanged += loadDataWorker_ProgressChanged; _loadDataWorker.RunWorkerCompleted += loadDataWorker_RunWorkerCompleted; _queryExecutor.TableLoadProgressChanged += queryExecutor_TableLoadProgressChanged; }
public AsyncReportGeneratorService( ISqlQueryExecutor sqlQueryExecutor, IReportsDataSourceFactory reportsDataSourceFactory, IReportStatusQueryService reportStatusQueryService, IReportStatusCreationService reportStatusCreationService, IReportStatusUpdaterService reportStatusUpdaterService, IRenderFilterService renderFilterService, ISpreadsheetWriterFactory spreadsheetWriterFactory ) { this.sqlQueryExecutor = sqlQueryExecutor; _reportsDataSourceFactory = reportsDataSourceFactory; _reportStatusQueryService = reportStatusQueryService; _reportStatusCreationService = reportStatusCreationService; _reportStatusUpdaterService = reportStatusUpdaterService; _renderFilterService = renderFilterService; _spreadsheetWriterFactory = spreadsheetWriterFactory; }
public void InsertAlarmCCSM(ALARM alarm) { var dmAlarm = GetDMAlarm(alarm.ERL, alarm.HOST, "VETINH"); var dmVeTinh = GetDMVeTinh(alarm.DLU, alarm.HOST); if (dmAlarm.Rows.Count > 0 && dmVeTinh.Rows.Count > 0) { string sql = String.Format("INSERT INTO PSTNAlarmTapTrung VALUES('{0}','{1}', '', CONVERT(datetime, '{2}', 103),'{3}', '{4}', '{5}', '{6}', '', '{7}', '{7}', '', '{8}', '{9}', '{10}', '')", alarm.HOST, dmVeTinh.Rows[0]["MaVT"], alarm.dateEvent, "", "Cap " + dmAlarm.Rows[0]["CapDo"], dmVeTinh.Rows[0]["MaVT"] + ":" + dmAlarm.Rows[0]["Name"], alarm.startDate.Value.ToString("dd/MM/yyyy HH:mm:ss"), alarm.isSuccess, alarm.DLU, dmAlarm.Rows[0]["LoaiCCSM"], alarm.HOST + "_" + alarm.DLU + "_" + alarm.ERL + "_" + alarm.dateEvent.ToString("yyyyMMddHHmmss")); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); sqlQueryExecutor.ExecuteUpdate(sql); var lsAlarm = GetAlarmBeginCCSM(alarm); if (lsAlarm.Rows.Count > 0) { string sql1 = String.Format("UPDATE PSTNAlarmTapTrung SET MaClear = '{0}' WHERE MaSend = {1}", alarm.HOST + lsAlarm.Rows[0]["MaSend"], lsAlarm.Rows[0]["MaSend"]); sqlQueryExecutor = new SqlServerSqlQueryExecutor(Properties.Settings.Default.Server, 1433, Properties.Settings.Default.Database, Properties.Settings.Default.User, Properties.Settings.Default.Pass); sqlQueryExecutor.ExecuteUpdate(sql1); } } }
public PostRepository(ISqlQueryExecutor executor) => _executor = executor;
public XmlToDBAdapter(ISqlQueryExecutor queryExecutor) { this.queryExecutor = queryExecutor; }
public XmlToDBAdapter() { queryExecutor = new SqlQueryExecutor(); }
/// <summary> /// Commission agent for a file. /// </summary> public CommissionAgent(ISqlQueryExecutor executor) { _queryExecutor = executor; }
public AllEntitiesQueryHandler(ISqlQueryExecutor sqlQueryExecutor, IMapper <SqlDataReader, TEntity> entitiesMapper) { this.sqlQueryExecutor = sqlQueryExecutor; this.entitiesMapper = entitiesMapper; }
public UpdateEntityCommandHandler(ISqlQueryExecutor sqlQueryExecutor) { this.sqlQueryExecutor = sqlQueryExecutor; }
public ChargeTypeDataAccessLayer(ISqlQueryExecutor dataMapper) { this._dataMapper = dataMapper; }
public CommunicationBusModule(ISqlQueryExecutor sqe) { sqlQueryExecutor = sqe; }
public CommunicationBusModule() { XmlRequest = null; sqlQueryExecutor = new SqlQueryExecutor(); }
public AllConfigCmsSettingsQueryHandler(ISqlQueryExecutor sqlQueryExecutor) { this.sqlQueryExecutor = sqlQueryExecutor ?? throw new ArgumentNullException(nameof(sqlQueryExecutor)); }
public ProfessorByIdQueryHandler(ISqlQueryExecutor sqlQueryExecutor) { this.sqlQueryExecutor = sqlQueryExecutor; }