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