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