private void btnCadastro_Click(object sender, EventArgs e) { string nome = textBoxNome.Text.ToString(); string ip = textBoxIp.Text.ToString(); try { int id; using (var labContext = new LaboratorioContext(_DB)) { id = labContext.Laboratorios.FirstOrDefault(s => s.Nome.Contains(textBoxLab.Text.ToString())).Id; } using (var maqContext = new MaquinaContext(_DB)) { maqContext.Maquinas.Add(maq = new Maquina(nome, ip, id)); maqContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }
private void btnProcurar_Click(object sender, EventArgs e) { try { using (var labContext = new LaboratorioContext(_DB)) { comboBoxLabs.Items.Clear(); lab = labContext.Laboratorios.ToList(); //List<string> nomes = labContext.Laboratorios.Select(c => c.Nome).ToList(); //string[] Lista = new string[nomes.Count]; //int index = 0; //foreach (var item in nomes) //{ // Lista[index] = item; // index++; //} comboBoxLabs.Items.AddRange(labContext.Laboratorios.Select(c => c.Nome).ToArray()); } } catch (Exception ex) { MessageBox.Show(ex.Message); Console.WriteLine(ex.StackTrace); } }
private void btnRemover_Click(object sender, EventArgs e) { try { using (var labContext = new LaboratorioContext(_DB)) { var id = labContext.Laboratorios.Where(s => s.Nome == comboBoxLabs.SelectedItem.ToString()).FirstOrDefault().Id; var lab = labContext.Laboratorios.Where(s => s.Id == id).FirstOrDefault(); labContext.Laboratorios.Remove(lab); labContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); comboBoxLabs.Items.RemoveAt(comboBoxLabs.SelectedIndex); } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }
private void btnListar_Click(object sender, EventArgs e) { comboBoxLabs.Items.Clear(); try { using (var labContext = new LaboratorioContext(_DB)) { IList <Laboratorio> labs = labContext.Laboratorios.ToList(); foreach (var item in labs) { comboBoxLabs.Items.Add(item.Nome); } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }
private void btnCadastrar_Click(object sender, EventArgs e) { string nome = textBoxNome.Text.ToString(); int qtd = Convert.ToInt32(textBoxQtd.Text.ToString()); int id = Convert.ToInt32(textBoxGrupo.Text.ToString()); try { using (var labContext = new LaboratorioContext(_DB)) { labContext.Laboratorios.Add(new Laboratorio(nome, qtd, id)); labContext.SaveChanges(); MessageBox.Show("Realizado com Sucesso!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }
static void listaTipoErro(Maquina maq) { try { using (var Labcont = new LaboratorioContext(_DB)) { var lab = Labcont.Laboratorios.FirstOrDefault(c => c.Id == maq.IdLab); Labname = lab.Nome; idGrupo = lab.IdGrupoErro; using (var GrupoCont = new GErrosContext(_DB)) { IList <GruposDeErro> TodoErros = GrupoCont.GruposErro.Where(c => c.IdGrupo == lab.IdGrupoErro).ToList(); List <int> idDeTodoErros = TodoErros.Select(s => s.IdTipoErro).ToList(); using (var tErros = new TErrosContext(_DB)) { IList <TiposDeErro> tiposDeErros = tErros.TiposErro.ToList(); Lista = new string[idDeTodoErros.Count]; int index = 0; foreach (var item in idDeTodoErros) { if (tiposDeErros.Select(s => s.Id).Contains(item)) { var nome = tiposDeErros.FirstOrDefault(s => s.Id == item).Nome; Lista[index] = nome; index++; } } } } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }
private void btnAtualizar_Click(object sender, EventArgs e) { if (checkBoxNome.Checked) { try { using (var laboratorioContext = new LaboratorioContext(_DB)) { var id = lab.Where(c => c.Nome == comboBoxLabs.SelectedItem.ToString()).First().Id; var item = lab.FirstOrDefault(c => c.Id == id); if (item != null) { item.MudarNome(textBoxNome.Text.ToString()); laboratorioContext.Entry(item).State = System.Data.Entity.EntityState.Modified; laboratorioContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } } if (checkBoxQtd.Checked) { try { using (var laboratorioContext = new LaboratorioContext(_DB)) { var id = lab.Where(c => c.Nome == comboBoxLabs.SelectedItem.ToString()).First().Id; var item = lab.FirstOrDefault(c => c.Id == id); if (item != null) { item.MudarQtd(Convert.ToInt32(textBoxQtd.Text.ToString())); laboratorioContext.Entry(item).State = System.Data.Entity.EntityState.Modified; laboratorioContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } } if (checkBoxId.Checked) { try { using (var laboratorioContext = new LaboratorioContext(_DB)) { var id = lab.Where(c => c.Nome == comboBoxLabs.SelectedItem.ToString()).First().Id; var item = lab.FirstOrDefault(c => c.Id == id); if (item != null) { item.MudarGrupoErro(Convert.ToInt32(textBoxGrupo.Text.ToString())); laboratorioContext.Entry(item).State = System.Data.Entity.EntityState.Modified; laboratorioContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } } }
public CategoriasController(LaboratorioContext context) { _context = context; }
private void btnUpdate_Click(object sender, EventArgs e) { if (checkBoxNome.Checked) { try { using (var maqContext = new MaquinaContext(_DB)) { var item = maqContext.Maquinas.FirstOrDefault(c => c.Ip == textBoxIp.Text.ToString()); if (item != null) { item.MudarNome(textBoxNome.Text.ToString()); maqContext.Entry(item).State = System.Data.Entity.EntityState.Modified; maqContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } } if (checkBoxLab.Checked) { try { int id; using (var labContext = new LaboratorioContext(_DB)) { id = labContext.Laboratorios.Where(s => s.Nome.Contains(textBoxLab.Text.ToString())).FirstOrDefault().Id; } using (var maqContext = new MaquinaContext(_DB)) { var item = maqContext.Maquinas.FirstOrDefault(c => c.Ip == textBoxIp.Text.ToString()); if (item != null) { item.MudarIdLab(id); maqContext.Entry(item).State = System.Data.Entity.EntityState.Modified; maqContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } } if (checkBoxIp.Checked) { try { using (var maqContext = new MaquinaContext(_DB)) { var item = maqContext.Maquinas.FirstOrDefault(c => c.Nome == textBoxNome.Text.ToString()); if (item != null) { item.MudarIp(textBoxIp.Text.ToString()); maqContext.Entry(item).State = System.Data.Entity.EntityState.Modified; maqContext.SaveChanges(); MessageBox.Show("Realizado com sucesso!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } } }