public FotoGaleria ObterDadosPorId(int _IdFotoGaleria)
{
using (OleDbConnection objConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["DBASANM"].ConnectionString))
{
try
{
objConn.Open();
FotoGaleria fg = new FotoGaleria();
OleDbCommand cmd = new OleDbCommand("SELECT IDFotoGaleria,IDGaleria,DSArquivoFoto FROM TB_FotoGaleria WHERE IDFotoGaleria = @IDFotoGaleria", objConn);
cmd.Parameters.Add("@IDFotoGaleria", OleDbType.Integer).Value = _IdFotoGaleria;
OleDbDataReader dr = cmd.ExecuteReader();
GaleriaDAL gDAL = new GaleriaDAL();
if (dr.Read())
{
fg.IDFotoGaleria = Convert.ToInt32(dr["IDFotoGaleria"]);
fg.Galeria = gDAL.ObterDadosPorId(Convert.ToInt32(dr["IDGaleria"]));
fg.DSArquivoFoto = dr["DSArquivoFoto"].ToString();
}
return(fg);
}
catch (Exception)
{
throw;
}
finally
{
objConn.Close();
}
}
}
public Noticia ObterDadosUltimoCadastrado()
{
using (OleDbConnection objConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["DBASANM"].ConnectionString))
{
try
{
objConn.Open();
Noticia n = new Noticia();
OleDbCommand cmd1 = new OleDbCommand("SELECT MAX(IDNoticia) AS IDNoticia FROM TB_Noticia", objConn);
OleDbDataReader dr1 = cmd1.ExecuteReader();
if (dr1.Read())
{
OleDbCommand cmd2 = new OleDbCommand("SELECT IDNoticia,DSTitulo,DSCorpo,DSArquivoImagem,BTAtiva FROM TB_Noticia WHERE IDNoticia = " + dr1["IDNoticia"], objConn);
OleDbDataReader dr2 = cmd2.ExecuteReader();
GaleriaDAL gDAL = new GaleriaDAL();
if (dr2.Read())
{
n.IDNoticia = Convert.ToInt32(dr2["IDNoticia"]);
n.DSTitulo = dr2["DSTitulo"].ToString();
n.DSCorpo = dr2["DSCorpo"].ToString();
n.DSArquivoImagem = dr2["DSArquivoImagem"].ToString();
n.BTAtiva = Convert.ToBoolean(dr2["BTAtiva"]);
}
}
return(n);
}
catch (Exception)
{
throw;
}
finally
{
objConn.Close();
}
}
}
public FotoGaleria ObterDadosUltimoCadastrado()
{
using (OleDbConnection objConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["DBASANM"].ConnectionString))
{
try
{
objConn.Open();
FotoGaleria fg = new FotoGaleria();
OleDbCommand cmd1 = new OleDbCommand("SELECT MAX(IDFotoGaleria) AS IDFotoGaleria FROM TB_FotoGaleria", objConn);
OleDbDataReader dr1 = cmd1.ExecuteReader();
if (dr1.Read())
{
OleDbCommand cmd2 = new OleDbCommand("SELECT IDFotoGaleria,IDGaleria,DSArquivoFoto FROM TB_FotoGaleria WHERE IDFotoGaleria = " + dr1["IDFotoGaleria"], objConn);
OleDbDataReader dr2 = cmd2.ExecuteReader();
GaleriaDAL gDAL = new GaleriaDAL();
if (dr2.Read())
{
fg.IDFotoGaleria = Convert.ToInt32(dr2["IDFotoGaleria"]);
fg.Galeria = gDAL.ObterDadosPorId(Convert.ToInt32(dr2["IDGaleria"]));
fg.DSArquivoFoto = dr2["DSArquivoFoto"].ToString();
}
}
return(fg);
}
catch (Exception)
{
throw;
}
finally
{
objConn.Close();
}
}
}
public IList Listar()
{
using (OleDbConnection objConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["DBASANM"].ConnectionString))
{
try
{
objConn.Open();
List <FotoGaleria> lst = new List <FotoGaleria>();
OleDbCommand cmd = new OleDbCommand("SELECT IDFotoGaleria,IDGaleria,DSArquivoFoto FROM TB_FotoGaleria", objConn);
OleDbDataReader dr = cmd.ExecuteReader();
GaleriaDAL gDAL = new GaleriaDAL();
while (dr.Read())
{
lst.Add(
new FotoGaleria()
{
IDFotoGaleria = Convert.ToInt32(dr["IDFotoGaleria"]),
Galeria = gDAL.ObterDadosPorId(Convert.ToInt32(dr["IDGaleria"])),
DSArquivoFoto = dr["DSArquivoFoto"].ToString()
}
);
}
return(lst);
}
catch (Exception)
{
throw;
}
finally
{
objConn.Close();
}
}
}