public IMDResponse <EntReporteVenta> CReporteGlobalVentas([FromUri] string psFolio = null, [FromUri] string psIdEmpresa = null, [FromUri] string psIdProducto = null, [FromUri] string psIdTipoProducto = null, [FromUri] string psIdOrigen = null, [FromUri] string psOrderId = null, [FromUri] string psStatus = null, [FromUri] string psCupon = null, [FromUri] string psTipoPago = null, [FromUri] DateTime?pdtFechaInicio = null, [FromUri] DateTime?pdtFechaFinal = null, [FromUri] DateTime?pdtFechaVencimiento = null) { IMDResponse <EntReporteVenta> response = new IMDResponse <EntReporteVenta>(); string metodo = nameof(this.CReporteGlobalVentas); logger.Info(IMDSerialize.Serialize(67823458599211, $"Inicia {metodo}([FromUri]string psFolio = null, [FromUri]string psIdEmpresa = null, [FromUri]string psIdProducto = null, [FromUri]string psIdTipoProducto = null, [FromUri]string psIdOrigen = null, [FromUri]string psOrderId = null, [FromUri]string psStatus = null,[FromUri]string psCupon = null, [FromUri]DateTime ? pdtFechaInicio = null, [FromUri]DateTime ? pdtFechaFinal = null, [FromUri]DateTime ? pdtFechaVencimiento = null)", psFolio, psIdEmpresa, psIdProducto, psIdTipoProducto, psIdOrigen, psOrderId, psStatus, psCupon, pdtFechaInicio, pdtFechaFinal, pdtFechaVencimiento)); try { BusReportes busReportes = new BusReportes(); response = busReportes.BReporteGlobalVentas(psFolio, psIdEmpresa, psIdProducto, psIdTipoProducto, psIdOrigen, psOrderId, psStatus, psCupon, psTipoPago, pdtFechaInicio, pdtFechaFinal, pdtFechaVencimiento); } catch (Exception ex) { response.Code = 67823458599988; response.Message = "Ocurrió un error inesperado al consultar los folios del reporte en la base de datos."; logger.Error(IMDSerialize.Serialize(67823458599988, $"Error en {metodo}([FromUri]string psFolio = null, [FromUri]string psIdEmpresa = null, [FromUri]string psIdProducto = null, [FromUri]string psIdTipoProducto = null, [FromUri]string psIdOrigen = null, [FromUri]string psOrderId = null, [FromUri]string psStatus = null,[FromUri]string psCupon = null, [FromUri]DateTime ? pdtFechaInicio = null, [FromUri]DateTime ? pdtFechaFinal = null, [FromUri]DateTime ? pdtFechaVencimiento = null): {ex.Message}", psFolio, psIdEmpresa, psIdProducto, psIdTipoProducto, psIdOrigen, psOrderId, psStatus, psCupon, pdtFechaInicio, pdtFechaFinal, pdtFechaVencimiento, ex, response)); } return(response); }
public HttpResponseMessage CDescargarReporteDoctores([FromUri] string psIdColaborador = null, [FromUri] string psColaborador = null, [FromUri] string psIdTipoDoctor = null, [FromUri] string psIdEspecialidad = null, [FromUri] string psIdConsulta = null, [FromUri] string psIdEstatusConsulta = null, [FromUri] string psRFC = null, [FromUri] string psNumSala = null, [FromUri] DateTime?pdtFechaProgramadaInicio = null, [FromUri] DateTime?pdtFechaProgramadaFinal = null, [FromUri] DateTime?pdtFechaConsultaInicio = null, [FromUri] DateTime?pdtFechaConsultaFin = null) { HttpResponseMessage response; string metodo = nameof(this.CDescargarReporteDoctores); logger.Info(IMDSerialize.Serialize(67823458575901, $"Inicia {metodo}([FromUri]string psIdColaborador = null, [FromUri]string psColaborador = null, [FromUri]string psIdTipoDoctor = null, [FromUri]string psIdEspecialidad = null, [FromUri]string psIdConsulta = null, [FromUri]string psIdEstatusConsulta = null, [FromUri]string psRFC = null, [FromUri]string psNumSala = null, [FromUri]DateTime ? pdtFechaProgramadaInicio = null, [FromUri]DateTime ? pdtFechaProgramadaFinal = null, [FromUri]DateTime ? pdtFechaConsultaInicio = null, [FromUri]DateTime ? pdtFechaConsultaFin = null)", psIdColaborador, psColaborador, psIdTipoDoctor, psIdEspecialidad, psIdConsulta, psIdEstatusConsulta, psRFC, psNumSala, pdtFechaProgramadaInicio, pdtFechaProgramadaFinal, pdtFechaConsultaInicio, pdtFechaConsultaFin)); try { BusReportes busReportes = new BusReportes(); IMDResponse <MemoryStream> resExcel = busReportes.BDescargarReporteDoctores(psIdColaborador, psColaborador, psIdTipoDoctor, psIdEspecialidad, psIdConsulta, psIdEstatusConsulta, psRFC, psNumSala, pdtFechaProgramadaInicio, pdtFechaProgramadaFinal, pdtFechaConsultaInicio, pdtFechaConsultaFin); if (resExcel.Code != 0) { response = Request.CreateResponse(HttpStatusCode.InternalServerError, resExcel.Message); } else { response = Request.CreateResponse(HttpStatusCode.OK); response.Content = new StreamContent(resExcel.Result); response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); response.Content.Headers.ContentDisposition.FileName = "ReporteDoctores.xlsx"; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); } } catch (Exception ex) { response = Request.CreateResponse(HttpStatusCode.InternalServerError, "No se pudo generar el reporte de doctores."); logger.Error(IMDSerialize.Serialize(67823458576678, $"Error en {metodo}([FromUri]string psIdColaborador = null, [FromUri]string psColaborador = null, [FromUri]string psIdTipoDoctor = null, [FromUri]string psIdEspecialidad = null, [FromUri]string psIdConsulta = null, [FromUri]string psIdEstatusConsulta = null, [FromUri]string psRFC = null, [FromUri]string psNumSala = null, [FromUri]DateTime ? pdtFechaProgramadaInicio = null, [FromUri]DateTime ? pdtFechaProgramadaFinal = null, [FromUri]DateTime ? pdtFechaConsultaInicio = null, [FromUri]DateTime ? pdtFechaConsultaFin = null): {ex.Message}", psIdColaborador, psColaborador, psIdTipoDoctor, psIdEspecialidad, psIdConsulta, psIdEstatusConsulta, psRFC, psNumSala, pdtFechaProgramadaInicio, pdtFechaProgramadaFinal, pdtFechaConsultaInicio, pdtFechaConsultaFin, ex, response)); } return(response); }
public IMDResponse <EntReporteDoctores> CObtenerReporteDoctores( [FromUri] string psIdColaborador = null, [FromUri] string psColaborador = null, [FromUri] string psIdTipoDoctor = null, [FromUri] string psIdEspecialidad = null, [FromUri] string psIdConsulta = null, [FromUri] string psIdEstatusConsulta = null, [FromUri] string psRFC = null, [FromUri] string psNumSala = null, [FromUri] DateTime?pdtFechaProgramadaInicio = null, [FromUri] DateTime?pdtFechaProgramadaFinal = null, [FromUri] DateTime?pdtFechaConsultaInicio = null, [FromUri] DateTime?pdtFechaConsultaFin = null) { IMDResponse <EntReporteDoctores> response = new IMDResponse <EntReporteDoctores>(); string metodo = nameof(this.CObtenerReporteDoctores); logger.Info(IMDSerialize.Serialize(67823458574347, $"Inicia {metodo}([FromUri]string psIdColaborador = null, [FromUri]string psColaborador = null, [FromUri]string psIdTipoDoctor = null, [FromUri]string psIdEspecialidad = null, [FromUri]string psIdConsulta = null, [FromUri]string psIdEstatusConsulta = null, [FromUri]string psRFC = null, [FromUri]string psNumSala = null, [FromUri]DateTime ? pdtFechaProgramadaInicio = null, [FromUri]DateTime ? pdtFechaProgramadaFinal = null, [FromUri]DateTime ? pdtFechaConsultaInicio = null, [FromUri]DateTime ? pdtFechaConsultaFin = null)", psIdColaborador, psColaborador, psIdTipoDoctor, psIdEspecialidad, psIdConsulta, psIdEstatusConsulta, psRFC, psNumSala, pdtFechaProgramadaInicio, pdtFechaProgramadaFinal, pdtFechaConsultaInicio, pdtFechaConsultaFin)); try { BusReportes busReportes = new BusReportes(); response = busReportes.BObtenerReporteDoctores(psIdColaborador, psColaborador, psIdTipoDoctor, psIdEspecialidad, psIdConsulta, psIdEstatusConsulta, psRFC, psNumSala, pdtFechaProgramadaInicio, pdtFechaProgramadaFinal, pdtFechaConsultaInicio, pdtFechaConsultaFin); } catch (Exception ex) { response.Code = 67823458575124; response.Message = "Ocurrió un error inesperado al consultar la información de doctores para el reporte en la base de datos."; logger.Error(IMDSerialize.Serialize(67823458575124, $"Error en {metodo}([FromUri]string psIdColaborador = null, [FromUri]string psColaborador = null, [FromUri]string psIdTipoDoctor = null, [FromUri]string psIdEspecialidad = null, [FromUri]string psIdConsulta = null, [FromUri]string psIdEstatusConsulta = null, [FromUri]string psRFC = null, [FromUri]string psNumSala = null, [FromUri]DateTime ? pdtFechaProgramadaInicio = null, [FromUri]DateTime ? pdtFechaProgramadaFinal = null, [FromUri]DateTime ? pdtFechaConsultaInicio = null, [FromUri]DateTime ? pdtFechaConsultaFin = null): {ex.Message}", psIdColaborador, psColaborador, psIdTipoDoctor, psIdEspecialidad, psIdConsulta, psIdEstatusConsulta, psRFC, psNumSala, pdtFechaProgramadaInicio, pdtFechaProgramadaFinal, pdtFechaConsultaInicio, pdtFechaConsultaFin, ex, response)); } return(response); }
public void TestMethod2() { BusReportes busReportes = new BusReportes(); var res = busReportes.BObtenerFolios(psIdOrigen: "2"); string json = JsonConvert.SerializeObject(res, Formatting.Indented); }
public void TestMethod1() { BusReportes busReportes = new BusReportes(); var res = busReportes.BReporteGlobalVentas(psIdOrigen: "1, 2"); string json = JsonConvert.SerializeObject(res, Formatting.Indented); }
public static string SelectExistenciasProducto(string piezas) { List <EntProductosPedido> productos = new List <EntProductosPedido>(); productos = new BusReportes().SelectPedidoProductos(Convert.ToInt32(piezas)); JavaScriptSerializer oSerializer = new JavaScriptSerializer(); string sJson = oSerializer.Serialize(productos); return(sJson); }
public static string SelectVentasEmpleados(string fechaVentas) { List <EntProductosVentas> productos = new List <EntProductosVentas>(); productos = new BusReportes().SelectVentasEmpleados(fechaVentas); JavaScriptSerializer oSerializer = new JavaScriptSerializer(); string sJson = oSerializer.Serialize(productos); return(sJson); }
public static string SelectVentasEmpleadosNEW() { EntUsuarios usua = new EntUsuarios(); usua = (EntUsuarios)HttpContext.Current.Session["Login"]; List <EntTotales> totales = new List <EntTotales>(); totales = new BusReportes().SelectVentasEmpleadosNEW(usua.Id_Usuario); JavaScriptSerializer oSerializer = new JavaScriptSerializer(); string sJson = oSerializer.Serialize(totales); return(sJson); }
public static string SelectVentasMedicoNEW() { EntUsuarios usua = new EntUsuarios(); usua = (EntUsuarios)HttpContext.Current.Session["Login"]; List <EntVentasMedico> ventas = new List <EntVentasMedico>(); ventas = new BusReportes().SelectVentasMedicoNEW(usua.Id_Usuario); JavaScriptSerializer oSerializer = new JavaScriptSerializer(); string sJson = oSerializer.Serialize(ventas); return(sJson); }
public HttpResponseMessage CDescargarReporteVentas([FromUri] string psFolio = null, [FromUri] string psIdEmpresa = null, [FromUri] string psIdProducto = null, [FromUri] string psIdTipoProducto = null, [FromUri] string psIdOrigen = null, [FromUri] string psOrderId = null, [FromUri] string psStatus = null, [FromUri] string psCupon = null, [FromUri] string psTipoPago = null, [FromUri] DateTime?pdtFechaInicio = null, [FromUri] DateTime?pdtFechaFinal = null, [FromUri] DateTime?pdtFechaVencimiento = null) { HttpResponseMessage response; string metodo = nameof(this.CDescargarReporteVentas); logger.Info(IMDSerialize.Serialize(67823458572793, $"Inicia {metodo}([FromUri]string psFolio = null, [FromUri]string psIdEmpresa = null, [FromUri]string psIdProducto = null, [FromUri]string psIdTipoProducto = null, [FromUri]string psIdOrigen = null, [FromUri]string psOrderId = null, [FromUri]string psStatus = null,[FromUri]string psCupon = null, [FromUri]DateTime ? pdtFechaInicio = null, [FromUri]DateTime ? pdtFechaFinal = null, [FromUri]DateTime ? pdtFechaVencimiento = null)", psFolio, psIdEmpresa, psIdProducto, psIdTipoProducto, psIdOrigen, psOrderId, psStatus, psCupon, pdtFechaInicio, pdtFechaFinal, pdtFechaVencimiento)); try { BusReportes busReportes = new BusReportes(); IMDResponse <MemoryStream> resExcel = busReportes.BDescargarReporteVentas(psFolio, psIdEmpresa, psIdProducto, psIdTipoProducto, psIdOrigen, psOrderId, psStatus, psCupon, psTipoPago, pdtFechaInicio, pdtFechaFinal, pdtFechaVencimiento); if (resExcel.Code != 0) { response = Request.CreateResponse(HttpStatusCode.InternalServerError, resExcel.Message); } else { response = Request.CreateResponse(HttpStatusCode.OK); response.Content = new StreamContent(resExcel.Result); response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); response.Content.Headers.ContentDisposition.FileName = "ReporteVentas.xlsx"; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); } } catch (Exception ex) { response = Request.CreateResponse(HttpStatusCode.InternalServerError, "No se pudo generar el reporte de ventas."); logger.Error(IMDSerialize.Serialize(67823458573570, $"Error en {metodo}([FromUri]string psFolio = null, [FromUri]string psIdEmpresa = null, [FromUri]string psIdProducto = null, [FromUri]string psIdTipoProducto = null, [FromUri]string psIdOrigen = null, [FromUri]string psOrderId = null, [FromUri]string psStatus = null,[FromUri]string psCupon = null, [FromUri]DateTime ? pdtFechaInicio = null, [FromUri]DateTime ? pdtFechaFinal = null, [FromUri]DateTime ? pdtFechaVencimiento = null): {ex.Message}", psFolio, psIdEmpresa, psIdProducto, psIdTipoProducto, psIdOrigen, psOrderId, psStatus, psCupon, pdtFechaInicio, pdtFechaFinal, pdtFechaVencimiento, ex, response)); } return(response); }