public RepasseParceria ObterDadosPorId(int _IdRepasseParceria) { using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString)) { try { objConn.Open(); RepasseParceria rp = new RepasseParceria(); SqlCommand cmd = new SqlCommand("SELECT IDRepasseParceria,IDParceria,DTVencimento,DTRepasse,VLRepasse,DSStatus FROM TB_RepasseParceria WHERE IDRepasseParceria = " + _IdRepasseParceria, objConn); SqlDataReader dr = cmd.ExecuteReader(); ParceriaDAL pDAL = new ParceriaDAL(); if (dr.Read()) { rp.IdRepasseParceria = Convert.ToInt32(dr["IDRepasseParceria"]); rp.Parceria = pDAL.ObterDadosPorId(Convert.ToInt32(dr["IDParceria"])); rp.DataVencimento = Convert.ToDateTime(dr["DTVencimento"]); if (dr["DTRepasse"] != DBNull.Value) { rp.DataRepasse = Convert.ToDateTime(dr["DTRepasse"]); } rp.ValorRepasse = Convert.ToDecimal(dr["VLRepasse"]); rp.Status = dr["DSStatus"].ToString(); } return(rp); } catch (Exception) { throw; } finally { objConn.Close(); } } }
public IList ListarPorParceria(int _IdParceria) { using (SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBGesDoc"].ConnectionString)) { try { objConn.Open(); ParceriaDAL pDAL = new ParceriaDAL(); IList lst = new List <RepasseParceria>(); SqlCommand cmd = new SqlCommand("SELECT IDRepasseParceria,IDParceria,DTVencimento,DTRepasse,VLRepasse,DSStatus FROM TB_RepasseParceria WHERE IDParceria = " + _IdParceria, objConn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { lst.Add( new RepasseParceria() { IdRepasseParceria = Convert.ToInt32(dr["IDRepasseParceria"]), Parceria = pDAL.ObterDadosPorId(Convert.ToInt32(dr["IDParceria"])), DataVencimento = Convert.ToDateTime(dr["DTVencimento"]), DataRepasse = Convert.ToDateTime(dr["DTRepasse"]), ValorRepasse = Convert.ToDecimal(dr["VLRepasse"]), Status = dr["DSStatus"].ToString() } ); } return(lst); } catch (Exception) { throw; } finally { objConn.Close(); } } }