/// <summary>
/// Obtiene un listado de pagos registrados en la base de datos
/// </summary>
/// <returns></returns>
public List <Pago> GetList()
{
using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPYOpera))
{
List <Pago> lista = new List <Pago>();
SqlCommand _SqlCommand = new SqlCommand("MDOSPS_OBTENER_PAGOS", _SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
try
{
_SqlConnection.Open();
SqlDataReader _SqlDataReader = _SqlCommand.ExecuteReader();
if (_SqlDataReader.HasRows)
{
while (_SqlDataReader.Read())
{
Pago item = new Pago()
{
iIdPago = int.Parse(_SqlDataReader["IdPago"].ToString()),
dtFecha = DateTime.Parse(_SqlDataReader["FechaPago"].ToString()),
sNoFactura = _SqlDataReader["NoFactura"].ToString(),
sNoSocio = _SqlDataReader["NoSocio"].ToString(),
sNombre = _SqlDataReader["Nombre"].ToString(),
sNoOperacion = _SqlDataReader["NoOperacion"].ToString(),
sConcepto = _SqlDataReader["Concepto"].ToString(),
sBanco = _SqlDataReader["Banco"].ToString(),
dMonto = Decimal.Parse(_SqlDataReader["Monto"].ToString()),
sReferencia = _SqlDataReader["Referencia"].ToString(),
dCostoFiscal = decimal.Parse(_SqlDataReader["CostoFiscal"].ToString()),
dGanancia = decimal.Parse(_SqlDataReader["Ganancia"].ToString()),
dComisionNeta = decimal.Parse(_SqlDataReader["ComisionNeta"].ToString())
};
List <Concepto> GetConcepts = new Concepto().GetConcepto(item.iIdPago);
for (int i = 0; i < GetConcepts.Count; i++)
{
Concepto itemConcepto = new Concepto(GetConcepts[i].iIdConcepto, GetConcepts[i].sConcepto, GetConcepts[i].dImporte);
item.lConceptos.Add(itemConcepto);
}
lista.Add(item);
}
}
}
catch (Exception)
{
lista = null;
}
return(lista);
}
}
public List <Concepto> GetConcepto(int iIdPago)
{
using (SqlConnection _SqlConnection = new SqlConnection(ConnectionString.DbMPYOpera))
{
List <Concepto> conceptos = new List <Concepto>();
SqlCommand _SqlCommand = new SqlCommand("MDOSPS_OBTENER_CONCEPTOS", _SqlConnection)
{
CommandType = CommandType.StoredProcedure
};
_SqlCommand.Parameters.AddWithValue("@IdPago", iIdPago);
try
{
_SqlConnection.Open();
SqlDataReader _SqlDataReader = _SqlCommand.ExecuteReader();
if (_SqlDataReader.HasRows)
{
while (_SqlDataReader.Read())
{
Concepto item = new Concepto()
{
iIdConcepto = int.Parse(_SqlDataReader["IdTipoConcepto"].ToString()),
sConcepto = _SqlDataReader["Descripcion"].ToString(),
dImporte = decimal.Parse(_SqlDataReader["Precio"].ToString())
};
conceptos.Add(item);
}
}
}
catch (Exception)
{
conceptos = null;
}
return(conceptos);
}
}