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