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