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 InitializeDatabase()
{
if (dbhelper == null)
{
dbhelper = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation);
}
}
private void InitializeDBConnection()
{
if (File.Exists(Constants.DatabaseConfigFileLocation))
{
DBHelper_EmailAlarms = StaticHelper.InitializeDatabase(Constants.DatabaseConfigFileLocation);
}
else
{
DBHelper_EmailAlarms = null;
}
}
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 bool ValidateVariableNamesAtLogic()
{
List <string> _strings = StaticHelper.GetStringsBetweenGivenChar(txt_AlarmLogic.Text, '\'');
bool result;
foreach (string v in _strings)
{
result = DBHelper_AddNewOrUpdateExistingMailAlarm.IsSignalAvalibale(v);
if (!result)
{
MessageBox.Show(String.Format("'{0}' geçerli bir sinyal ismi değil. Sinyal ismini konrol ediniz.", v), Constants.MessageBoxHeader, MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
return(true);
}
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();
}
