public ControlCaja retornarUltimoControlCaja() { ControlCaja controlCaja = new ControlCaja(); try { cmd.CommandText = "PACKAGE_CONTROL_CAJA.PR_ULTIMO_CONTROL_CAJA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("CURSOR_CONTROL_CAJA", OracleDbType.RefCursor).Direction = ParameterDirection.Output; OracleDataReader reader = cmd.ExecuteReader(); foreach (var item in reader) { controlCaja.IdControlCaja = reader.GetInt32(0); controlCaja.FechaControlCaja = reader.GetDateTime(1); controlCaja.TotalBoleta = reader.GetInt32(2); controlCaja.UtilidadBruta = reader.GetInt32(3); controlCaja.MontoFinal = reader.GetInt32(4); System.Console.WriteLine("monto final" + reader.GetValue(4)); controlCaja.MontoInicial = reader.GetInt32(5); Personal personal = new Personal(); personal.IdPersonal = reader.GetInt32(6); controlCaja.Personal = personal; } if (!reader.HasRows) { controlCaja = null; } con.Close(); return(controlCaja); } catch (Exception ex) { System.Console.WriteLine("error: " + ex.Message.ToString()); controlCaja = null; return(controlCaja); } }
public IActionResult IndexCierreCaja() { Electron.IpcMain.On("async-boletas-cierre-caja", (args) => { var mainWindow = Electron.WindowManager.BrowserWindows.First(); try { BoletaService boletaService = new BoletaService(); List <Boleta> boletasHoy = boletaService.listarBoletasDeHoy(); boletaService = null; ControlCajaService controlCajaService = new ControlCajaService(); ControlCaja ultimoControlCaja = controlCajaService.retornarUltimoControlCaja(); controlCajaService = new ControlCajaService(); //DateTime fechaActual = new Date(day:) // DateTime fechaActual = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); if (ultimoControlCaja != null) { if (ultimoControlCaja.FechaControlCaja.ToString("dd/MM/yy") == DateTime.Now.ToString("dd/MM/yy")) { //System.Console.WriteLine("fecha actual: " + DateTime.Now.ToString("dd/MM/yy")); Electron.IpcMain.Send(mainWindow, "asynchronous-reply-boletas-cierre-caja", -1); } else { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-boletas-cierre-caja", boletasHoy); } } else { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-boletas-cierre-caja", boletasHoy); } // System.Console.WriteLine(ultimoControlCaja.FechaControlCaja); } catch (Exception ex) { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-boletas-cierre-caja", ex.Message); } }); Electron.IpcMain.On("async-ultimo-cierre-caja", (args) => { var mainWindow = Electron.WindowManager.BrowserWindows.First(); ControlCajaService controlCajaService = new ControlCajaService(); try { ControlCaja ultimoControlCaja = controlCajaService.retornarUltimoControlCaja(); controlCajaService = null; if (ultimoControlCaja == null) { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-ultimo-cierre-caja", -1); } else { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-ultimo-cierre-caja", ultimoControlCaja); } } catch (Exception ex) { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-ultimo-cierre-caja", ex.Message); } }); Electron.IpcMain.On("modalBoleta-window-finanzas", async(argument) => { //carga el puerto disponible string viewPath = $"http://localhost:{BridgeSettings.WebPort}/Finanzas/ModalBoletaFinanzas?idBoleta={argument}"; // string viewPath = $"http://localhost:{BridgeSettings.WebPort}/Finanzas/ModalBoletaFinanzas"; var optionsWindows = new BrowserWindowOptions { Frame = false }; await Electron.WindowManager.CreateWindowAsync(optionsWindows, viewPath); }); Electron.IpcMain.On("async-cerrar-caja", (args) => { var mainWindow = Electron.WindowManager.BrowserWindows.First(); var datos = args; List <ControlCaja> cj = ((JArray)args).Select(x => new ControlCaja { MontoInicial = (int)x["montoInicial"], TotalBoleta = (int)x["recaudacionHoy"], MontoFinal = (int)x["montoFinal"] }).ToList(); try { ControlCajaService controlCajaService = new ControlCajaService(); // se debe cambiar la utilidad y el id del personal, ya que estan en duro Boolean exito = controlCajaService.insertarControlCaja(cj[0].TotalBoleta, 1288, cj[0].MontoFinal, cj[0].MontoInicial, 195); if (exito) { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-cerrar-caja", 1); } else { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-cerrar-caja", -1); } } catch (Exception ex) { Electron.IpcMain.Send(mainWindow, "asynchronous-reply-cerrar-caja", ex.Message); } }); Electron.IpcMain.On("information-dialog-cierre-caja", async(args) => { var options = new MessageBoxOptions("¿Seguro que desea cerrar la caja?") { Type = MessageBoxType.info, Title = "Informatión", Buttons = new string[] { "Si", "No" } }; //var p= Microsoft.VisualBasic.Interaction.InputBox("Question?", "Title", "Default Text"); var result = await Electron.Dialog.ShowMessageBoxAsync(options); var mainWindow = Electron.WindowManager.BrowserWindows.First(); Electron.IpcMain.Send(mainWindow, "information-dialog-reply-cierre-caja", result.Response); }); Electron.IpcMain.On("information-dialog-cambiarMontoFinal-cierre-caja", async(args) => { var options = new MessageBoxOptions("¿Seguro que desea cambiar el valor del monto total?") { Type = MessageBoxType.info, Title = "Informatión", Buttons = new string[] { "Si", "No" } }; //var p= Microsoft.VisualBasic.Interaction.InputBox("Question?", "Title", "Default Text"); var result = await Electron.Dialog.ShowMessageBoxAsync(options); var mainWindow = Electron.WindowManager.BrowserWindows.First(); Electron.IpcMain.Send(mainWindow, "information-dialog-reply-cambiarMontoFinal-cierre-caja", result.Response); }); return(View()); }