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