// iserir novos dados no banco Update
public void InserirAluno(ModelAluno aluno)
{
SQLiteCommand com = new SQLiteCommand();
com.Connection = ClassConUp.ConUp();
com.CommandText = "INSERT INTO blog_aluno (nome, ra, curso, tel, cel, email, author_id, cpf, created_date, published_date) " +
"VALUES (@nome, @ra, @curso, @tel, @cel, @email, @author_id, @cpf, @created_date, @published_date)";
com.Parameters.AddWithValue("@nome", aluno.Nome);
com.Parameters.AddWithValue("@ra", aluno.Ra);
com.Parameters.AddWithValue("@curso", aluno.Curso);
com.Parameters.AddWithValue("@tel", aluno.Tel);
com.Parameters.AddWithValue("@cel", aluno.Cel);
com.Parameters.AddWithValue("@email", aluno.Email);
com.Parameters.AddWithValue("@author_id", aluno.Author_id);
com.Parameters.AddWithValue("@cpf", aluno.Cpf);
com.Parameters.AddWithValue("@created_date", aluno.Created_date);
com.Parameters.AddWithValue("@published_date", aluno.Published_date);
try
{
com.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("Error inserir: " + ex);
}
finally
{
com.Connection.Clone();
}
}
public ActionResult DeleteConfirmed(int id)
{
ModelAluno modelAluno = db.aluno.Find(id);
db.aluno.Remove(modelAluno);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "idAluno,RA,nome,senha")] ModelAluno modelAluno)
{
if (ModelState.IsValid)
{
db.Entry(modelAluno).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modelAluno));
}
public ActionResult Create([Bind(Include = "idAluno,RA,nome,senha")] ModelAluno modelAluno)
{
if (ModelState.IsValid)
{
db.aluno.Add(modelAluno);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modelAluno));
}
// GET: ModelAlunoes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ModelAluno modelAluno = db.aluno.Find(id);
if (modelAluno == null)
{
return(HttpNotFound());
}
return(View(modelAluno));
}
// teste atualização bancos
private void Upbd()
{
List <ModelAluno> alunos = new List <ModelAluno>();
ClassAlunoDao dao = new ClassAlunoDao();
alunos = dao.GetIds(); // ok
int i = 0;
for (i = 0; i < alunos.Count; i++)
{
ModelAluno aluno = new ModelAluno();
aluno = dao.ConsultaAluno(alunos[i].Cpf);
aluno.Nome = alunos[i].Nome;
aluno.Ra = alunos[i].Ra;
aluno.Curso = alunos[i].Curso;
aluno.Tel = alunos[i].Tel;
aluno.Cel = alunos[i].Cel;
aluno.Author_id = alunos[i].Author_id;
aluno.Cpf = alunos[i].Cpf;
aluno.Created_date = alunos[i].Created_date;
aluno.Published_date = alunos[i].Published_date;
MessageBox.Show("get" + i);
if (aluno.Id > 0)
{
MessageBox.Show("consulta" + i);
dao.UpdateAlunos(aluno); // update dados existentes
MessageBox.Show("update" + i);
log.Add(aluno.Nome + " = atualizado");
Thread.Sleep(500);
}
else
{
dao.InserirAluno(aluno); // cadastro novos dados
log.Add(aluno.Nome + " = Cadastrado");
}
txtlog += "\n" + log[i];
}
on = true;
//button1.Enabled = on;
lblNome.Text = txtlog;
}
// update dados no banco Update no banco Update
public void UpdateAlunos(ModelAluno aluno)
{
//SQLiteCommand com = new SQLiteCommand();
//com.Connection = ClassConUp.ConUp();
//com.CommandText = "UPDATE blog_aluno SET nome='" + aluno.Nome + " ', ra='" + aluno.Ra + " ', curso='" + aluno.Curso + " ', tel='" + aluno.Tel +
// "', cel='" + aluno.Cel + " ', email='" + aluno.Email + " ', author_id='" + aluno.Author_id + " ', cpf='" + aluno.Cpf + " ', created_date='" + aluno.Created_date + " ', published_date='" + aluno.Published_date + " ' WHERE cpf= '"+aluno.Cpf+"'";
try
{
using (SQLiteConnection con = new SQLiteConnection(strCon))
using (SQLiteCommand com = new SQLiteCommand("UPDATE blog_aluno SET nome='" + aluno.Nome + " ', ra='" + aluno.Ra + " ', curso='" + aluno.Curso + " ', tel='" + aluno.Tel + "', cel='" + aluno.Cel + " ', email='" + aluno.Email + " ', author_id='" + aluno.Author_id + " ', cpf='" + aluno.Cpf + " ', created_date='" + aluno.Created_date + " ', published_date='" + aluno.Published_date + " ' WHERE cpf= '" + aluno.Cpf + "'", con))
{
con.Open();
com.ExecuteNonQuery();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("ERRO UP" + ex);
}
}
// consulta de dados da tabela alunos
public ModelAluno ConsultaAluno(string cpf)
{
ModelAluno aluno = new ModelAluno();
try
{
using (SQLiteConnection con = new SQLiteConnection(strCon))
using (SQLiteCommand com = new SQLiteCommand("SELECT * FROM blog_aluno WHERE cpf='" + cpf + "'", con))
{
//com.Parameters.AddWithValue("@cpf", cpf);
con.Open();
SQLiteDataReader consulta = com.ExecuteReader();
if (consulta.HasRows)
{
consulta.Read();
aluno.Id = Convert.ToInt16(consulta["id"]);
aluno.Nome = consulta["nome"].ToString();
aluno.Ra = consulta["ra"].ToString();
aluno.Curso = consulta["curso"].ToString();
aluno.Tel = consulta["tel"].ToString();
aluno.Cel = consulta["cel"].ToString();
aluno.Email = consulta["email"].ToString();
aluno.Author_id = consulta["author_id"].ToString();
aluno.Cpf = consulta["cpf"].ToString();
aluno.Created_date = consulta["created_date"].ToString();
aluno.Published_date = consulta["published_date"].ToString();
}
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show("ERRO CONSULTA " + ex);
}
return(aluno);
}
public ActionResult ExibeDadosCadastroAlunoTipado(ModelAluno aluno)
{
return(View(aluno));
}
public ActionResult CadastroAluno()
{
ModelAluno objAluno = new ModelAluno();
return(View(objAluno));
}
