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