private void Btn_exportToExcel_Click_1(object sender, RoutedEventArgs e)
{
//excel
try
{
HelpClass.StartAwait(grid_main);
#region
//Thread t1 = new Thread(() =>
//{
BuildReport();
this.Dispatcher.Invoke(() =>
{
saveFileDialog2.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
//});
//t1.Start();
#endregion
HelpClass.EndAwait(grid_main);
}
catch (Exception ex)
{
HelpClass.EndAwait(grid_main);
HelpClass.ExceptionMessage(ex, this);
}
}
private async void excelRowinDatagrid(object sender, RoutedEventArgs e)
{
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
for (var vis = sender as Visual; vis != null; vis = VisualTreeHelper.GetParent(vis) as Visual)
{
if (vis is DataGridRow)
{
POSOpenCloseModel row = (POSOpenCloseModel)dgClosing.SelectedItems[0];
cashTransID = row.cashTransId;
openCashTransID = row.openCashTransId.Value;
await getopquery(row);
if (opquery.Count() == 0)
{
Toaster.ShowWarning(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trNoChange"), animation: ToasterAnimation.FadeIn);
}
else
{
BuildOperationReport();
this.Dispatcher.Invoke(() =>
{
saveFileDialog.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
}
}
}
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}
public void ExcelDaily()
{
BuildReport();
this.Dispatcher.Invoke(() =>
{
saveFileDialog.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
}
private void Btn_exportToExcel_Click(object sender, RoutedEventArgs e)
{//excel
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
if (MainWindow.groupObject.HasPermissionAction(reportsPermission, MainWindow.groupObjects, "one") || SectionData.isAdminPermision())
{
#region
if (itemLocationListQuery != null)
{
//Thread t1 = new Thread(() =>
//{
BuildReport();
this.Dispatcher.Invoke(() =>
{
saveFileDialog.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
//});
//t1.Start();
}
#endregion
}
else
{
Toaster.ShowInfo(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trdontHavePermission"), animation: ToasterAnimation.FadeIn);
}
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}
private async void Btn_exportToExcel_Click(object sender, RoutedEventArgs e)
{//excel
try
{
HelpClass.StartAwait(grid_main);
#region
//Thread t1 = new Thread(() =>
//{
if (packuser.packageUserId <= 0)
{
//no book saved
Toaster.ShowWarning(Window.GetWindow(this), message: "You have to book first", animation: ToasterAnimation.FadeIn);
}
else
{
result = await BuildReport();
if (result == "0")
{
// not payed yet
Toaster.ShowWarning(Window.GetWindow(this), message: "The customer must pay first", animation: ToasterAnimation.FadeIn);
}
else
{
this.Dispatcher.Invoke(() =>
{
saveFileDialog.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
}
//});
//t1.Start();
}
#endregion
HelpClass.EndAwait(grid_main);
}
catch (Exception ex)
{
HelpClass.EndAwait(grid_main);
HelpClass.ExceptionMessage(ex, this);
}
}
private async void Btn_exportToExcel_Click(object sender, RoutedEventArgs e)
{//excel
try
{
HelpClass.StartAwait(grid_main);
PackageUser puModel = new PackageUser();
PackageUser pu = await puModel.GetByID(packageUserID);
string customer = pu.customerName + " " + pu.customerLastName;
string package = pu.packageName;
string key = pu.packageSaleCode;
string agent = pu.userName + " " + pu.userLastName;
string s = "";
#region
Thread t1 = new Thread(() =>
{
BuildReport();
this.Dispatcher.Invoke(() =>
{
saveFileDialog.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
});
t1.Start();
#endregion
HelpClass.EndAwait(grid_main);
}
catch (Exception ex)
{
HelpClass.EndAwait(grid_main);
HelpClass.ExceptionMessage(ex, this);
}
}
private void Btn_exportToExcel_Click(object sender, RoutedEventArgs e)
{//excel
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
List <ItemTransferInvoice> query = new List <ItemTransferInvoice>();
#region
BuildReport();
this.Dispatcher.Invoke(() =>
{
saveFileDialog.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
#endregion
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}
private void Btn_exportToExcel_Click(object sender, RoutedEventArgs e)
{//export to excel
try
{
if (sender != null)
{
SectionData.StartAwait(grid_main);
}
if (MainWindow.groupObject.HasPermissionAction(reportsPermission, MainWindow.groupObjects, "one") || SectionData.isAdminPermision())
{
#region
if (invItemsQuery != null)
{
// Thread t1 = new Thread(() =>
//{
List <ReportParameter> paramarr = new List <ReportParameter>();
string addpath;
bool isArabic = ReportCls.checkLang();
if (isArabic)
{
addpath = @"\Reports\Store\Ar\ArDestroyReport.rdlc";
}
else
{
addpath = @"\Reports\Store\EN\DestroyReport.rdlc";
}
string reppath = reportclass.PathUp(Directory.GetCurrentDirectory(), 2, addpath);
ReportCls.checkLang();
clsReports.invItem(invItemsQuery, rep, reppath, paramarr);
clsReports.setReportLanguage(paramarr);
clsReports.Header(paramarr);
rep.SetParameters(paramarr);
rep.Refresh();
this.Dispatcher.Invoke(() =>
{
saveFileDialog.Filter = "EXCEL|*.xls;";
if (saveFileDialog.ShowDialog() == true)
{
string filepath = saveFileDialog.FileName;
LocalReportExtensions.ExportToExcel(rep, filepath);
}
});
//});
// t1.Start();
}
#endregion
}
else
{
Toaster.ShowInfo(Window.GetWindow(this), message: MainWindow.resourcemanager.GetString("trdontHavePermission"), animation: ToasterAnimation.FadeIn);
}
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
}
catch (Exception ex)
{
if (sender != null)
{
SectionData.EndAwait(grid_main);
}
SectionData.ExceptionMessage(ex, this);
}
}