public frmTermoNovo(Usuario user, String terId) { InitializeComponent(); ter = new Termo(); util = new Utils(); this.user = user; lblUserOn.Text = user.Login; alu = new Aluno(); if (terId != "") //atualizar { lblUltimaAlter.Visible = true; lblUltimaAlter1.Visible = true; ter.TerId = terId; ter = ter.getTermoById(); userTermo = new Usuario(); userTermo.Id = Convert.ToInt32(ter.TerQuemCadastrou); userTermo = userTermo.getUserById(); lblUltimaAlter.Text = userTermo.Login; btnSelecionar.Visible = false; alu.TerId = terId; ttbAluno.Text = alu.getAlunoByTermo(); pictureBox1.ImageLocation = fotoPath + "" + ter.TerId + ".jpg"; } else { lblUltimaAlter.Visible = false; lblUltimaAlter1.Visible = false; } }
public frmTermoControlar(Usuario user) { InitializeComponent(); this.user = user; ter = new Termo(); atualizaDtgv(); }
public bool atualiza(Termo ter) { sql = "UPDATE termo SET ter_quemcadastrou='@1' "+ "WHERE ter_id = @2"; sql = sql.Replace("@1", ter.TerQuemCadastrou); sql = sql.Replace("@2", ter.TerId); bco.conecta(); result = bco.executeNonQuery(sql); bco.desconecta(); return result; }
public Termo getTermoById(String id) { Termo ter = null; sql = "SELECT * FROM termo WHERE ter_id = @1"; sql = sql.Replace("@1", id); bco.conecta(); bco.executeQuery(sql, out dt); bco.desconecta(); if (dt.Rows.Count > 0) { ter = new Termo(); ter.TerId = id; ter.TerQuemCadastrou = dt.Rows[0]["ter_quemcadastrou"].ToString(); } return ter; }
public bool excluir(Termo ter) { sql = "UPDATE aluno SET ter_id = null WHERE ter_id = @1"; sql = sql.Replace("@1", ter.TerId); bco.conecta(); result = bco.executeNonQuery(sql); bco.desconecta(); if (result) { sql = "DELETE FROM termo WHERE ter_id = @1"; sql = sql.Replace("@1", ter.TerId); bco.conecta(); result = bco.executeNonQuery(sql); bco.desconecta(); } return result; }
private void btnGravar_Click(object sender, EventArgs e) { if (ttbAluno.Text == "") ttbAluno.BackColor = Color.Red; else if (pictureBox1.Image == null) MessageBox.Show("Selecione uma imagem!", "Sem imagem!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else { if (ter.TerId != "") //atualiza { ter = ter.getTermoById(); ter.TerQuemCadastrou =""+user.Id; if (ter.atualiza()) { util.gravarFoto(fotoPath + "" + ter.TerId + ".jpg", pictureBox1.Image); MessageBox.Show("Termo alterado com sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else MessageBox.Show("Ocorreu um erro ao atualizar o termo!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { ter.AluId = alu.Id + ""; ter.TerQuemCadastrou = user.Id + ""; if (ter.novo()) { ter.TerId = ter.getUltimoId(); util.gravarFoto(fotoPath + "" + ter.TerId + ".jpg", pictureBox1.Image); MessageBox.Show("Termo cadastrado com sucesso!", "Sucesso!", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else MessageBox.Show("Ocorreu um erro ao cadastrar o termo!", "Erro!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } }
public bool novo(Termo ter) { sql = "INSERT INTO termo(ter_quemcadastrou) " +"VALUES (@1)"; sql = sql.Replace("@1", ter.TerQuemCadastrou); bco.conecta(); result = bco.executeNonQuery(sql); bco.desconecta(); if (result) { Aluno alu = new Aluno(); alu.Id = Convert.ToInt32(ter.AluId); alu.TerId = ter.getUltimoId(); result = alu.addTermo(); } return result; }