//SELECT
public static Disciplinas_Gerais Select(int codigo)
{
try
{
Disciplinas_Gerais objDisciplina = null;
IDbConnection objConnection;
IDbCommand objCommnad;
IDataReader objDataReader;
objConnection = Mapped.Connection();
objCommnad = Mapped.Command("SELECT * FROM dge_disciplinas_gerais WHERE dge_codigo = ?codigo", objConnection);
objCommnad.Parameters.Add(Mapped.Parameter("?codigo", codigo));
objDataReader = objCommnad.ExecuteReader();
while (objDataReader.Read())
{
objDisciplina = new Disciplinas_Gerais();
objDisciplina.Dge_codigo = Convert.ToInt32(objDataReader["dge_codigo"]);
objDisciplina.Dge_nome = objDataReader["dge_nome"].ToString();
objDisciplina.Dge_sigla = objDataReader["dge_sigla"].ToString();
}
objDataReader.Close();
objConnection.Close();
objConnection.Dispose();
objCommnad.Dispose();
objDataReader.Dispose();
return(objDisciplina);
}
catch (Exception e)
{
return(null);
}
}
//UPDATE
public static int Update(Disciplinas_Gerais disciplina)
{
int retorno = 0;
try
{
IDbConnection conexao;
IDbCommand objCommand;
string sql = "UPDATE dge_disciplinas_gerais SET dge_codigo = ?dge_codigo, dge_nome = ?dge_nome, dge_sigla = ?dge_sigla " +
" WHERE dge_codigo = ?dge_codigo ";
conexao = Mapped.Connection();
objCommand = Mapped.Command(sql, conexao);
objCommand.Parameters.Add(Mapped.Parameter("?dge_codigo", disciplina.Dge_codigo));
objCommand.Parameters.Add(Mapped.Parameter("?dge_nome", disciplina.Dge_nome));
objCommand.Parameters.Add(Mapped.Parameter("?dge_sigla", disciplina.Dge_sigla));
objCommand.ExecuteNonQuery();
conexao.Close();
objCommand.Dispose();
conexao.Dispose();
}
catch (Exception e)
{
retorno = -2;
}
return(retorno);
}
public static int Insert(Disciplinas_Gerais disciplina)
{
int retorno = 0;
try
{
IDbConnection conexao;
IDbCommand objCommand;
string sql = "INSERT INTO dge_disciplinas_gerais(dge_codigo, dge_nome, dge_sigla) VALUES (?dge_codigo, ?dge_nome, ?dge_sigla)";
conexao = Mapped.Connection();
objCommand = Mapped.Command(sql, conexao);
objCommand.Parameters.Add(Mapped.Parameter("?dge_codigo", disciplina.Dge_codigo));
objCommand.Parameters.Add(Mapped.Parameter("?dge_nome", disciplina.Dge_nome));
objCommand.Parameters.Add(Mapped.Parameter("?dge_sigla", disciplina.Dge_sigla));
conexao.Close();
objCommand.Dispose();
conexao.Dispose();
}
catch (Exception e)
{
retorno = -2;
}
return(retorno);
}
