public List <MODEL.Model_Turma> Select() { List <MODEL.Model_Turma> lst_Turma = new List <MODEL.Model_Turma>(); SqlConnection conexao = new SqlConnection(strCon); string sql = "select * from Turma;"; SqlCommand cmd = new SqlCommand(sql, conexao); conexao.Open(); try { SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { MODEL.Model_Turma turma = new MODEL.Model_Turma(); turma.Descricao = Convert.ToInt32(reader["Desc_Turma"]); lst_Turma.Add(turma); } } catch { Console.WriteLine("Erro ao consultar turma pela Descrição"); } finally { conexao.Close(); } return(lst_Turma); }
public void Insert(MODEL.Model_Turma turma) { SqlConnection conexao = new SqlConnection(strCon); string sql = "insert into Turma values "; sql = sql + "(@DESC)"; SqlCommand cmd = new SqlCommand(sql, conexao); cmd.Parameters.AddWithValue("@DESC", turma.Descricao); conexao.Open(); try { cmd.ExecuteNonQuery(); } catch { Console.WriteLine("Erro ao inserir turma...."); } finally { conexao.Close(); } }
public void Insert(MODEL.Model_Turma turma) { DAL.Dal_Turma dal_Turma = new DAL.Dal_Turma(); dal_Turma.Insert(turma); }