public ActionResult ConsultaHistorialCobros(DTOHistorialCobros cobros)
{
ManagerHistorialCobros mang = new ManagerHistorialCobros();
var listaHistorial = mang.consultaHistorialCobros(cobros);
return(Json(listaHistorial));
}
public List <DTOHistorialCobros> consultaHistorialCobros(DTOHistorialCobros cobros)
{
string xClase = string.Format("{0}|{1}", MethodBase.GetCurrentMethod().Module.Name, MethodBase.GetCurrentMethod().DeclaringType.Name);
string xProceso = MethodBase.GetCurrentMethod().Name;
var dto_excepcion = new UTL_TRA_EXCEPCION
{
STR_CLASE = xClase,
STR_EVENTO = xProceso,
STR_APLICATIVO = ConfigurationManager.AppSettings["Aplicativo"],
STR_SERVIDOR = System.Net.Dns.GetHostName()
};
var dto = new DynamicDto();
dto.ParameterList = new List <SpParameter>();
var dto_result = new List <DTOHistorialCobros>();
try
{
dto.ParameterList.AddRange(from nodo in cobros.GetType().GetProperties()
where nodo.GetValue(cobros) != null
select new SpParameter
{
Name = nodo.Name,
Value = nodo.GetValue(cobros).ToString()
}
);
dto.Result = null;
dto.SPName = "usp_getHistorialCobros";
var objRet = DynamicSqlDAO.ExecuterSp(dto, GlobalClass.connectionString.Where(a => a.Key == infDto.STR_COD_PAIS).FirstOrDefault().Value);
if (objRet.HasResult)
{
dto_result = JsonConvert.DeserializeObject <List <DTOHistorialCobros> >(JsonConvert.SerializeObject(objRet.Result.Tables[0]));
}
}
catch (Exception ex)
{
dto_excepcion.STR_MENSAJE = ex.Message;
dto_excepcion.STR_DETALLE = ex.StackTrace;
}
return(dto_result);
}
