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