public void Create(Disciplina pDisciplina) { string sql = "insert into disciplinas values ("; sql += pDisciplina.id + ",'" + pDisciplina.nome + "')"; conn.executarComando(sql); }
public void Update(Disciplina pDisciplina) { //int aux = disciplina.FindIndex(x => x.Id == pDisciplina.Id); //disciplina[aux] = pDisciplina; string update = "Update disciplinas set nome='" + pDisciplina.Nome + "' where id=" + pDisciplina.Id; conn.executarComando(update); }
public void Update(Disciplina pDisciplina) { string updateSql = "UPDATE disciplinas SET nome = " + pDisciplina.Nome + " WHERE id = " + pDisciplina.Id; conn.executarComando(updateSql); }
public void Create(Disciplina pDisciplina) { string insert = "INSERT INTO disciplinas VALUES ("; insert += pDisciplina.Id + ",'" + pDisciplina.Nome + "')"; conn.executarComando(insert); }
public Disciplina getOne(int pId) { string sql = "SELECT * FROM disciplinas WHERE id = " + pId; MySqlDataReader dr = conn.executarConsulta(sql); dr.Read(); Disciplina discEdit = new Disciplina((int)dr["id"], (string)dr["nome"]); return discEdit; }
public Disciplina GetOne(int pId) { string sql = "select * from disciplinas where id =" + pId; MySqlDataReader dr = conn.executarConsulta(sql); dr.Read(); Disciplina dipEditando = new Disciplina((int)dr["id"], (string)dr["nome"]); return dipEditando; }
public ActionResult Update(Disciplina disciplina) { discRep.Update(disciplina); return RedirectToAction("Index"); }
public ActionResult CreateDisciplina(Disciplina disciplina) { discRep.Create(disciplina); return RedirectToAction("Disciplina"); }
public void Update(Disciplina pDisciplina) { int pos = disciplinas.FindIndex(x => x.Id == pDisciplina.Id); disciplinas[pos].Id = pDisciplina.Id; disciplinas[pos].Nome = pDisciplina.Nome; }
public void Create(Disciplina pDisciplina) { disciplinas.Add(pDisciplina); }