public ArquivoConvenio ObterDadosUltimoCadastrado() { using (OleDbConnection objConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["DBASANM"].ConnectionString)) { try { objConn.Open(); ArquivoConvenio ac = new ArquivoConvenio(); OleDbCommand cmd1 = new OleDbCommand("SELECT MAX(IDArquivoConvenio) AS IDArquivoConvenio FROM TB_ArquivoConvenio", objConn); OleDbDataReader dr1 = cmd1.ExecuteReader(); if (dr1.Read()) { OleDbCommand cmd2 = new OleDbCommand("SELECT IDArquivoConvenio,IDConvenio,NMArquivo,DSArquivo FROM TB_ArquivoConvenio WHERE IDArquivoConvenio = " + dr1["IDArquivoConvenio"], objConn); OleDbDataReader dr2 = cmd2.ExecuteReader(); ConvenioDAL cDAL = new ConvenioDAL(); if (dr2.Read()) { ac.IDArquivoConvenio = Convert.ToInt32(dr2["IDArquivoConvenio"]); ac.Convenio = cDAL.ObterDadosPorId(Convert.ToInt32(dr2["IDConvenio"])); ac.NMArquivo = dr2["NMArquivo"].ToString(); ac.DSArquivo = dr2["DSArquivo"].ToString(); } } return(ac); } catch (Exception) { throw; } finally { objConn.Close(); } } }
public IList Listar() { using (OleDbConnection objConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["DBASANM"].ConnectionString)) { try { objConn.Open(); List <ArquivoConvenio> lst = new List <ArquivoConvenio>(); OleDbCommand cmd = new OleDbCommand("SELECT IDArquivoConvenio,IDConvenio,NMArquivo,DSArquivo FROM TB_ArquivoConvenio ORDER BY DSArquivo", objConn); OleDbDataReader dr = cmd.ExecuteReader(); ConvenioDAL cDAL = new ConvenioDAL(); while (dr.Read()) { lst.Add( new ArquivoConvenio() { IDArquivoConvenio = Convert.ToInt32(dr["IDArquivoConvenio"]), Convenio = cDAL.ObterDadosPorId(Convert.ToInt32(dr["IDConvenio"])), NMArquivo = dr["NMArquivo"].ToString(), DSArquivo = dr["DSArquivo"].ToString() } ); } return(lst); } catch (Exception) { throw; } finally { objConn.Close(); } } }
public ArquivoConvenio ObterDadosPorId(int _IdArquivoConvenio) { using (OleDbConnection objConn = new OleDbConnection(ConfigurationManager.ConnectionStrings["DBASANM"].ConnectionString)) { try { objConn.Open(); ArquivoConvenio ac = new ArquivoConvenio(); OleDbCommand cmd = new OleDbCommand("SELECT IDArquivoConvenio,IDConvenio,NMArquivo,DSArquivo FROM TB_ArquivoConvenio WHERE IDArquivoConvenio = @IDArquivoConvenio", objConn); cmd.Parameters.Add("@IDArquivoConvenio", OleDbType.Integer).Value = _IdArquivoConvenio; OleDbDataReader dr = cmd.ExecuteReader(); ConvenioDAL cDAL = new ConvenioDAL(); if (dr.Read()) { ac.IDArquivoConvenio = Convert.ToInt32(dr["IDArquivoConvenio"]); ac.Convenio = cDAL.ObterDadosPorId(Convert.ToInt32(dr["IDConvenio"])); ac.NMArquivo = dr["NMArquivo"].ToString(); ac.DSArquivo = dr["DSArquivo"].ToString(); } return(ac); } catch (Exception) { throw; } finally { objConn.Close(); } } }