private void BEditExt_Click(object sender, EventArgs e)
{
if (nUDCoIleSecond.Value >= 10 || numericUpDownCPU.Value >= 1 || numericUpDownRAM.Value >= 1)
{
using (var db = new DataProgramContext())
{
var result = db.RAMCPUSAVE.SingleOrDefault(b => b.ValueCpuAndRamId == IDValue);
if (result != null)
{
result.Cpu = Convert.ToInt32(numericUpDownCPU.Value);
result.Time = Convert.ToInt32(nUDCoIleSecond.Value);
result.Ram = Convert.ToInt32(numericUpDownRAM.Value);
db.SaveChanges();
}
else
{
var Record = new ValueCpuAndRam
{
Cpu = Convert.ToInt32(numericUpDownCPU.Value),
Ram = Convert.ToInt32(numericUpDownRAM.Value),
Time = Convert.ToInt32(nUDCoIleSecond.Value)
};
db.RAMCPUSAVE.Add(Record);
db.SaveChanges();
};
}
MessageBox.Show("Zapisano ustawienia!", "Informacja", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Nie zapisano ustawień - podano niepoprawne wartości", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void BEdit_Click(object sender, EventArgs e)
{
if (tBAdresEdit.Text.Trim() != string.Empty)
{
string text = tBAdresEdit.Text;
int id = Convert.ToInt32(tBIDEdit.Text);
if (true == IsValid(tBAdresEdit.Text))
{
using (var db = new DataProgramContext())
{
var result = db.ListEmailsDB.SingleOrDefault(b => b.ListEmailsId == id);
if (result != null)
{
result.AdresseEmail = tBAdresEdit.Text;
db.SaveChanges();
}
}
}
else
{
MessageBox.Show("Zły format adresu email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
Reflesh();
}
else
{
MessageBox.Show("Wpisano pusty adres email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
tBAdresDelete.Text = tBAdresEdit.Text;
this.dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
this.dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void BDelete_Click(object sender, EventArgs e)
{
if (tBAdresEdit.Text.Trim() != string.Empty || tBAdresEdit.Text.Trim() != "")
{
int id = Convert.ToInt32(tBIDEdit.Text);
string text = tBAdresEdit.Text;
using (var db = new DataProgramContext())
{
var result = db.ListEmailsDB.SingleOrDefault(b => b.ListEmailsId == id);
if (result != null)
{
db.Entry(result).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
Reflesh();
this.dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
this.dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
tBAdresDelete.Text = "";
tBIDDelete.Text = "";
tBIDEdit.Text = "";
tBAdresEdit.Text = "";
}
public void Reflesh()
{
using (var db = new DataProgramContext())
{
var query = from c in db.ListEmailsDB
select new { Id = c.ListEmailsId, Adres_Email = c.AdresseEmail };
var results = query.OrderByDescending(x => x.Id).ToList();
dataGridView2.DataSource = results;
this.dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
this.dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
}
public void RefleshDataInformation()
{
using (var db = new DataProgramContext())
{
var query = from c in db.RAMCPUSAVE
select new { Id = c.ValueCpuAndRamId, c.Cpu, c.Ram, c.Time };
var results = query.ToList();
foreach (var item in results)
{
numericUpDownCPU.Value = item.Cpu;
numericUpDownRAM.Value = item.Ram;
nUDCoIleSecond.Value = item.Time;
IDValue = item.Id;
}
}
}
private void Button1_Click(object sender, EventArgs e)
{
using (var db = new DataProgramContext())
{
var query = from c in db.ListEmailsDB
select new { c.AdresseEmail };
BookEmails = query.Count();
}
Microsoft.Win32.RegistryKey key;
key = Microsoft.Win32.Registry.CurrentUser.CreateSubKey("MD - RAM CPU");
object o = key.GetValue("Password");
key.Close();
if (o == null)
{
MessageBox.Show("Musisz skonfigurować ustawienia konta email wysyłającego wiadomości", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (BookEmails < 1)
{
MessageBox.Show("Musisz wprowadzić listę osób odbierających wiadomość - użyj menu", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
TimerActiveButton = true;
DateMonit = DateTime.Now.AddSeconds(Convert.ToDouble(nUDCoIleSecond.Value));
button1.Text = "Uruchomiony";
toolStripStatusLabel1.Text = "Status: Uruchomiony";
DateMonit = DateTime.Now;
Reflesh = DateMonit.AddSeconds(Convert.ToInt32(nUDCoIleSecond.Value));
}
timer1.Start();
}
private void BAddEmail_Click(object sender, EventArgs e)
{
if (tBAddEmail.Text.Trim() != string.Empty)
{
string text = tBAddEmail.Text;
if (true == IsValid(tBAddEmail.Text))
{
using (var db = new DataProgramContext())
{
var query = from c in db.ListEmailsDB
where c.AdresseEmail == text
select new { c.ListEmailsId, c.AdresseEmail };
if (query.ToList().Count < 1)
{
var UserFolderSave = new ListEmails {
AdresseEmail = text
};
db.ListEmailsDB.Add(UserFolderSave);
db.SaveChanges();
}
else
{
MessageBox.Show("Dany adres już isnieje, żądanie nie zostało wprowadzone", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
Reflesh();
}
else
{
MessageBox.Show("Zły format adresu email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("Wpisano pusty adres email", "Uwaga", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Timer1_Tick(object sender, EventArgs e)
{
lczas.Text = DateTime.Now.ToLongTimeString();
CPUTimerValue = Convert.ToInt32(cpuValue.NextValue());
textBox1.Text = "CPU Usage: " + CPUTimerValue.ToString() +
"%";
RAMTimerValue = Convert.ToInt32(ramValue.NextValue());
textBox2.Text = RAMTimerValue.ToString() + "MB";
if (TimerActiveButton == true)
{
if (DateTime.Now >= Reflesh)
{
Reflesh = DateTime.Now.AddSeconds(Convert.ToInt32(nUDCoIleSecond.Value));
if (RAMTimerValue < numericUpDownRAM.Value)
{
Microsoft.Win32.RegistryKey key;
key = Microsoft.Win32.Registry.CurrentUser.CreateSubKey("MD - RAM CPU");
try
{
int port = Int32.Parse(key.GetValue("Port").ToString());
SmtpClient mailServer = new SmtpClient(key.GetValue("SMTP").ToString(), port);
mailServer.EnableSsl = true;
mailServer.Credentials = new System.Net.NetworkCredential(key.GetValue("Name").ToString(), key.GetValue("Password").ToString());
MailMessage msg = new MailMessage();
msg.From = new MailAddress(key.GetValue("Name").ToString(), key.GetValue("Signature").ToString());
using (var db = new DataProgramContext())
{
var query = from c in db.ListEmailsDB
select new { c.AdresseEmail };
foreach (var item in query)
{
msg.To.Add(item.AdresseEmail);
}
}
msg.IsBodyHtml = true;
msg.Subject = "Ticket - Wykryto zbyt małą dostępną ilość RAM, data: " + DateTime.Now.ToString() + "";
msg.Body = "Wykryto zbyt mała ilość dostępnej pamięci RAM: " + RAMTimerValue.ToString() + " MB <br><br>";
mailServer.Send(msg);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
key.Close();
}
if (CPUTimerValue > numericUpDownCPU.Value)
{
Microsoft.Win32.RegistryKey key;
key = Microsoft.Win32.Registry.CurrentUser.CreateSubKey("MD - RAM CPU");
try
{
int port = Int32.Parse(key.GetValue("Port").ToString());
SmtpClient mailServer = new SmtpClient(key.GetValue("SMTP").ToString(), port);
mailServer.EnableSsl = true;
mailServer.Credentials = new System.Net.NetworkCredential(key.GetValue("Name").ToString(), key.GetValue("Password").ToString());
MailMessage msg = new MailMessage();
msg.From = new MailAddress(key.GetValue("Name").ToString(), key.GetValue("Signature").ToString());
using (var db = new DataProgramContext())
{
var query = from c in db.ListEmailsDB
select new { c.AdresseEmail };
foreach (var item in query)
{
msg.To.Add(item.AdresseEmail);
}
}
msg.IsBodyHtml = true;
msg.Subject = "Ticket - Wykryto zbyt duże obciążenie CPU, data: " + DateTime.Now.ToString() + "";
msg.Body = "Wykryto zbyt duże obciązenie: " + textBox1.Text + "<br><br>";
mailServer.Send(msg);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
key.Close();
}
}
}
}
