private static bool TryConnectToDatabase() { if (DatabaseType != string.Empty & ServerAddress != string.Empty & DatabaseName != string.Empty & UserName != string.Empty & Password != string.Empty) { switch (DatabaseType) { case "MySQL": try { DBHelper = new MySqlDBHelper(ServerAddress, DatabaseName, UserName, Password); // DBHelper null değilse veritabanı bağlantısı kurulmuştur. if (DBHelper != null) { return(DBHelper.CheckDBConnection()); } return(false); } catch (Exception ex) { Log.Instance.Error("{0}: Veritabanı bağlantısı kurulumu esnasında hata oluştu => {1}", "StaticHelper", ex.Message); return(false); } default: Log.Instance.Error("{0} database tipi için driver bulunamadı.", DatabaseType); return(false); } } return(false); }
private void frm_AddMailAlarm_Load(object sender, EventArgs e) { try { DBHelper_AddNewOrUpdateExistingMailAlarm = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); List <MailGroup> mailGroups = DBHelper_AddNewOrUpdateExistingMailAlarm.GetMailGroups(); if (mailGroups.Count > 0) { cb_MailGroups.Items.AddRange(mailGroups.ToArray()); if (formType == FormType.UpdateExistingSignal) { txt_AlarmName.Text = alarmMail.Name; txt_AlarmLogic.Text = alarmMail.LogicText.Replace("$", "'"); txt_EMailSubject.Text = alarmMail.EMailSubject; txt_EmailMessage.Text = alarmMail.EmailText; btn_AddNewOrUpdateAlarm.Text = "Alarm'ı Güncelle"; cb_MailGroups.SelectedItem = mailGroups.Where((mg) => mg.Name == alarmMail.MailGroupName).First(); } } } catch (Exception ex) { MessageBox.Show("Mail Grupları yüklenemedi", Constants.MessageBoxHeader, MessageBoxButtons.OK, MessageBoxIcon.Error); Log.Instance.Error("Mail grupları database'den okunamadı => {0}", ex.Message); } }
private void menu_databaseConnectionSettings_Click(object sender, EventArgs e) { if (StaticHelper.GetDatabaseConnectionInfoFromUser()) { dbHelper = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); } }
private void InitializeDatabase() { if (dbhelper == null) { dbhelper = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); } }
private void InitializeDatabase() { try { DBHelper_AddNewOrUpdateCommandSignalForm = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); } catch (Exception ex) { Log.Instance.Error("{0}: Database bağlantısı oluşturulamadı => {1}", this.GetType().Name, ex.Message); MessageBox.Show("Veritabanına bağlanılamadı", Constants.MessageBoxHeader, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void frm_SelectVariable_Load(object sender, EventArgs e) { try { DbHelper_SelectVariable = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); List <Station> stations = DbHelper_SelectVariable.GetAllStationsInfoWithDeviceInfo(); cb_StationNames.Items.AddRange(stations.ToArray()); } catch (Exception) { MessageBox.Show("Database'e bağlanılamadı", Constants.MessageBoxHeader, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void deneme_Load(object sender, EventArgs e) { DatabaseHelper = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); ModbusAnalogSignal signal = new ModbusAnalogSignal(); if (DatabaseHelper != null) { TemporaryValues.stations = DatabaseHelper.GetAllStationsInfoWithDeviceInfo(); TemporaryValues.archivePeriods = DatabaseHelper.GetArchivePeriods(); TemporaryValues.dataTypes = DatabaseHelper.GetAllDataTypes(); TemporaryValues.statusTexts = DatabaseHelper.GetAllStatusTexts(); } propertyGrid1.SelectedObject = signal; }
public AnalogSignal_BasicValues(CommunicationProtocol protocol, AbstractDBHelper dbHelper) { Protocol = protocol; DBHelper = dbHelper; InitializeComponent(); var stations = GetStations(); if (stations != null) { cbx_StationName.Items.AddRange(stations.ToArray()); } }
public frm_Stations(List <T> stations, AbstractDBHelper dbHelper) { DBHelper = dbHelper; InitializeComponent(); if (stations.Count > 0) { Stations = new BindingList <T>(stations); } else { Stations = new BindingList <T>(); } LoadDataGridView(); }
public frm_Signals(List <T> signals, Device device, AbstractDBHelper dbHelper) { this.device = device; DBHelper = dbHelper; InitializeComponent(); if (signals.Count > 0) { Signals = new BindingList <T>(signals); } else { Signals = new BindingList <T>(); } LoadDataGridView(); }
public MailClient(string _configFileLocation) : this() { MailServerPort = "587"; mailClientTimers = new List <MailClientTimer>(); ConfigFileLocation = _configFileLocation; ReadConfigFile(_configFileLocation); DBHelper_MailClient = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); // Mail alarmları kontrol etmek için cyclic timer cyclicTimer = new Timer(); cyclicTimer.Interval = 500; cyclicTimer.Elapsed += Timer_Elapsed; }
private void MainForm_Load(object sender, EventArgs e) { dbHelper = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); dbHelper.DatabaseConnected += DatabaseConnected; if (dbHelper.IsConnected) { LoadProjectTreeView(); LoadTemporaryValues(); } else { MessageBox.Show("Database bağlantısı kurulamadığı için yazılım kapatılacaktır.", Constants.MessageBoxHeader, MessageBoxButtons.OK, MessageBoxIcon.Error); this.Close(); } }
public frm_Devices(List <T> devices, AbstractDBHelper dbHelper) { DBHelper = dbHelper; InitializeComponent(); if (devices.Count > 0) { Devices = devices; dataGridView1.DataSource = Devices; dataGridView1.HideAllColumns(); dataGridView1.ShowColumn("ID"); dataGridView1.Columns["ID"].DisplayIndex = 0; dataGridView1.ShowColumn("Name"); dataGridView1.Columns["Name"].DisplayIndex = 1; dataGridView1.ShowColumn("Protocol"); dataGridView1.Columns["Protocol"].DisplayIndex = 2; dataGridView1.ShowColumn("isActive"); dataGridView1.Columns["isActive"].DisplayIndex = 3; dataGridView1.ShowColumn("Connected"); dataGridView1.Columns["Connected"].DisplayIndex = 4; } }
public void StartDriver() { try { // Database helper oluşturulmadıysa veritabanı baglantısı için database helper oluşturulur if (DBHelper_MailClient == null) { DBHelper_MailClient = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); } if (DBHelper_MailClient != null) { // Database'den alarm mail bilgileri çekilir. _alarmMails = GetAlarmMails(); // Database'den alarm mail donduyse, if (_alarmMails != null) { // Timer'ın olup olmadığına bakılır. Timer oluşturulmadıysa timer oluşturulur. if (cyclicTimer == null) { cyclicTimer = new Timer(); cyclicTimer.Interval = 500; cyclicTimer.Elapsed += Timer_Elapsed; } isStarted = true; cyclicTimer.Start(); } } } catch (Exception ex) { Log.Instance.Error("{0}: Mail client sürücüsü başlatılamadı => {1}", this.GetType().Name, ex.Message); } }
public frm_EmailAlarms(AbstractDBHelper dbhelper) { InitializeComponent(); DBHelper_EmailAlarms = dbhelper; }
private void frm_Devices_Load(object sender, EventArgs e) { DBHelper_Devices = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); AddDevicesToForm(); }
private void frm_OnlineValues_Load(object sender, EventArgs e) { DBHelper_OnlineValues = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation); LoaddgvAnalogValuesWithData(); LoaddgvBinaryValuesWithData(); }
public frm_Email(AbstractDBHelper dbhelper) { InitializeComponent(); DBHelper_EmailSettings = dbhelper; }
public void Dispose() { Client = null; DBHelper_MailClient = null; }