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