private void CrystalReportsViewer1_OnLoaded(object sender, RoutedEventArgs e)
{
try
{
report = new ReportDocument();
report.Load(reportName, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault);
if (data == null)
{
report.SetDataSource(StoredCallbackProcessor.CallDataSet(StoredProcedureName).Tables[0]);
}
else
{
report.SetDataSource(data.Tables[0]);
}
crystalReportsViewer1.ViewerCore.ReuseParameterWhenRefresh = true;
report.Refresh();
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
catch (Exception ex)
{
LoggerHelper.WriteLog(ex);
MessageBox.Show(ViewModelManager.mainWindow, "Error Al cargar Reporte, verifique configuracion",
"Error ", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public static void SaveTransaction(OIGN_GoodsReceipt obj)
{
lock (Extensions.Locker)
{
var db = ContextFactory.GetDBContext();
var transfers = obj.IGN1_GoodsReceiptDetail.Select(t => new OINM_Transaction(obj, t)).ToList();
transfers.ForEach(t => db.OINM_Transaction.Add(t));
ContextFactory.SaveChanges();
//Actualizar existencias
//var articles = (from detail in obj.IGN1_GoodsReceiptDetail
// join article in db.OITW_BranchArticles on detail.ItemCode equals article.ItemCode
// where article.WhsCode == detail.WhsCode
// select article).ToList();
//articles.ForEach(a =>
//{
// var detail = obj.IGN1_GoodsReceiptDetail.FirstOrDefault(d => d.ItemCode == a.ItemCode);
// a.OnHand = a.OnHand + detail.Quantity;
// a.OnHand1 = a.OnHand1 + detail.Quantity;
//});
//ContextFactory.SaveChanges();
StoredCallbackProcessor.UpdateStock();
}
}
private void Process()
{
if (SelectedOrder != null && ValidateDate() && ConfirmDialog("Desea procesar el Pedido", "Confimar"))
{
//Guardar el pedido
SpecialOrdersHelper.AddOrder(SelectedOrder);
SaveChanges();
var currentOrder = SelectedOrder;
var param = new Dictionary <string, string>();
param.Add("@IdSpecialOrder", selectedOrder.IdSpecialOrder.ToString());
var data = StoredCallbackProcessor.CallDataSet("SP_INV_PEDIDOS_ES", param);
//var report = new ReportContainer("rptPedidosEspeciales.rpt", data);
//report.Export(currentOrder.ReportFileName);
ShowProcessLoader(this);
AsyncHelper.DoAsync(() =>
{
Sync(currentOrder);
RaisePropertyChanged("SpecialOrdersCollection");
},
ViewModelManager.CloseProcessLoader);
}
else
{
UndoChanges();
}
}
public override void ViewReport()
{
var param = new Dictionary <string, string>();
param.Add("@id", SelectedGoodsReceipt.IdGoodReceiptL.ToString());
var data = StoredCallbackProcessor.CallDataSet("SP_INV_REP_AJUSTES_E", param);
//var report = new ReportContainer("rptAjustedeInventarios.rpt", data);
//ShowDialog (report,this);
}
public override void ViewReport()
{
var param = new Dictionary <string, string>();
param.Add("@IdSpecialOrder", selectedOrder.IdSpecialOrder.ToString());
var data = StoredCallbackProcessor.CallDataSet("SP_INV_PEDIDOS_ES", param);
//var report = new ReportContainer("rptPedidosEspeciales.rpt", data);
//ShowDialog(report, this);
}
public void ProcessInventoryCount()
{
IsDetailsBusy = true;
InventoryCountHelper.AddOrUpdate(SelectedInventoryCount);
SaveChanges();
StoredCallbackProcessor.StartAlohaSync(ignoreAsync: true);
StoredCallbackProcessor.UpdateStock();
InventoryCountHelper.Process(SelectedInventoryCount);
RefreshItemSource();
}
public void OnApplicationLoaded()
{
IsLoading = true;
BusyContent = "Inicializando";
lock (Extensions.SyncLock)
{
Synchronization.Connect();
IsLoading = false;
StoredCallbackProcessor.Run();
}
}
public void ForceAlohaSync()
{
lock (Extensions.SyncLock)
{
BusyContent = string.Empty;
AsyncHelper.DoAsync(() =>
{
IsRunningSync = true;
StoredCallbackProcessor.StartAlohaSync(ignoreAsync: true);
IsRunningSync = false;
});
}
}
public static ObservableCollection <NotificationItemMenu> GetNotifications()
{
var notifications = new List <NotificationItemMenu>();
var endOfDay = StoredCallbackProcessor.CallDataSet("SP_Notifications");
if (endOfDay != null)
{
foreach (DataTable table in endOfDay.Tables)
{
notifications.AddRange(from DataRow row in table.Rows select new NotificationItemMenu(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), new RelayCommand(() => { })));
}
}
return(new ObservableCollection <NotificationItemMenu>(notifications));
}
public static void SaveTransaction(OWTR_Transfers tranfer)
{
lock (Extensions.Locker)
{
var db = ContextFactory.GetDBContext();
var transfers = tranfer.WTR1_TransferDetails.Select(t => new OINM_Transaction(tranfer, t)).ToList();
transfers.ForEach(t => db.OINM_Transaction.Add(t));
ContextFactory.SaveChanges();
// Actualizar existencias
StoredCallbackProcessor.UpdateStock();
ContextFactory.SaveChanges();
//if (tranfer.Filler != Config.WhsCode)// Es transferencia de entrada
//{
//var articles = (from detail in tranfer.WTR1_TransferDetails
// join article in db.OITW_BranchArticles on detail.ItemCode equals article.ItemCode
// where article.WhsCode == detail.WhsCode
// select article).ToList();
//articles.ForEach(a =>
//{
// var detail = tranfer.WTR1_TransferDetails.FirstOrDefault(d => d.ItemCode == a.ItemCode);
// a.OnHand = a.OnHand + detail.Quantity;
// a.OnHand1 = a.OnHand1 + detail.Quantity;
//});
//}
//else // Es transferencia de salida
//{
//var articles = (from detail in tranfer.WTR1_TransferDetails
// join article in db.OITW_BranchArticles on detail.ItemCode equals article.ItemCode
// where article.WhsCode == Config.WhsCode // Todos los articulos salieron de la sucursal
// select article).ToList();
//articles.ForEach(a =>
//{
// var detail = tranfer.WTR1_TransferDetails.FirstOrDefault(d => d.ItemCode == a.ItemCode);
// a.OnHand = a.OnHand - detail.Quantity;
// a.OnHand1 = a.OnHand1 - detail.Quantity;
//});
//}
}
}
private void BuildReport()
{
var mapping = ViewModelManager.ActionBarViewModel.ReportType;
if (mapping == null)
{
return;
}
var parameters = GetParameters(mapping);
var dataSet = StoredCallbackProcessor.CallDataSet(mapping.StoredProcedureName, parameters);
//var report = new ReportContainer(mapping.ReportFileName, dataSet);
//ViewModelManager.LoadReport(report);
}
public void Export(string filename)
{
try
{
var report = new ReportDocument();
report.Load(reportName, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault);
if (data == null)
{
report.SetDataSource(StoredCallbackProcessor.CallDataSet(StoredProcedureName).Tables[0]);
}
else
{
report.SetDataSource(data.Tables[0]);
}
// crystalReportsViewer1.ViewerCore.ReuseParameterWhenRefresh = true;
report.Refresh();
report.ExportToDisk(ExportFormatType.PortableDocFormat, System.IO.Path.Combine(Config.ReportPath, filename));
//crystalReportsViewer1.ViewerCore.ReportSource = report;
report.Database.Dispose();
report.Close();
report.Dispose();
this.crystalReportsViewer1.ViewerCore.Dispose();
}
catch (Exception ex)
{
LoggerHelper.WriteLog(ex);
MessageBox.Show(ViewModelManager.mainWindow, "Error Al cargar Reporte, verifique configuracion",
"Error ", MessageBoxButton.OK, MessageBoxImage.Warning);
}
finally
{
GC.Collect();
}
}
private void UpdateArticles()
{
StoredCallbackProcessor.CallBack("SP_UpdateArticlesALOHA");
ShowDialog("Actualización realizada correctamente", "Confirmación");
}
public void RunEndOfDayAsync()
{
ProgressValue = 0;
if (!WebApiClient.IsAvailableConnection)
{
BusyContent = "Error de Conneccion Intente nuevamente ..";
return;
}
BusyContent = "Ejectutando Validacion de Fin de Dia";
IsLockedForEndOfDay = IsRunningEndOfDay = true;
EndOfDayNotifications = NotificationsManager.GetEndOfDayNotifications();
IsRunningEndOfDay = false;
IsLoading = true;
if (EndOfDayNotifications.Any(n => n.NotificationName.ToLower() != "completo"))
{
var error = BusyContent = "Error Existen Validaciones Pendientes, Favor verificar";
MessageBox.Show(error, "Fin de dia Error", MessageBoxButton.OK, MessageBoxImage.Error);
IsLoading = IsLockedForEndOfDay = false;
return;
}
BusyContent = "Sincronizando Productos Aloha...";
StoredCallbackProcessor.StartAlohaSync(ignoreAsync: true);
BusyContent = "Procesando Venta Pendiente...";
var idVenta = (int)StoredCallbackProcessor.CallDataSet("SP_INV_VNT_PROCESAR").Tables[0].Rows[0].ItemArray.FirstOrDefault();
if (idVenta <= 0)
{
MessageBox.Show("Error al procesar venta", "Fin de dia Error", MessageBoxButton.OK,
MessageBoxImage.Error);
IsLoading = IsLockedForEndOfDay = false;
}
else
{
var sale = SalesHelper.Get(idVenta);
//Asiganado las formas de pago para la venta por ALOHA
var pagos = SalesHelper.GetiInvoicePayments(sale);
sale.paymentsAloha = pagos;
if (sale != null)
{
BusyContent = "Sincronizando Venta...";
Synchronization.Synchronize(sale);
if (sale.StateL == LocalStatus.Procesado)
{
var token = TransactionLogHelper.ConfirmationLog();
BusyContent = "Proceso completado con exito, Codigo de verificacion " + token;
MessageBox.Show(BusyContent, "Finalizado", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
BusyContent = "Error al procesar venta, Verifique ..";
ProgressValue = 0;
MessageBox.Show(BusyContent, "Error Fin de Dia", MessageBoxButton.OK,
MessageBoxImage.Error);
IsLoading = IsLockedForEndOfDay = false;
}
}
else
{
BusyContent = "Error al procesar venta, Verifique ..";
ProgressValue = 0;
MessageBox.Show(BusyContent, "Error Fin de Dia", MessageBoxButton.OK,
MessageBoxImage.Error);
IsLoading = IsLockedForEndOfDay = false;
}
}
IsLoading = IsLockedForEndOfDay = false;
}
