public void ExportToExcel(string fileName)
{
this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
ExportToCSV exporterCSV = new ExportToCSV(_separator);
ExportToExcel exporter = new ExportToExcel();
_fileName = fileName;
string directory = _fileName.Substring(0, _fileName.LastIndexOf(@"\") + 1);
if (_table != null && _fileName != null && !_fileName.Equals(string.Empty) && Directory.Exists(directory))
{
_gridLayoutProperties = _manager.GetLayoutProperties(_excludedColumns);
if (!exporter.IsOpen(_fileName))
{
if (_canExportToExcel)
{
exporter.Export(_table, _fileName, "Prueba", _gridLayoutProperties);
}
else
{
exporterCSV.Export(_table, _fileName, _gridLayoutProperties);
}
}
else // else "Archivo abierto...."
{
DialogResult result;
result = MessageBox.Show("El archivo '" + _fileName + "' se encuentra abierto (Para poder exportar los datos el mismo debe estar cerrado). Ciérrelo y vuelva a intentarlo.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
this.Cursor = System.Windows.Forms.Cursors.Default;
}
protected void Page_Load(object sender, EventArgs e)
{
MobileVer = MobileDetector.IsMobile;
if (UrlParameters.Action != "export")
{
_phListBase.Controls.Add(LoadControl(ListBaseView.Location));
}
else
{
var cases = GetCasesByFilter();
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
const string fileName = "cases.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName));
Response.Write(ExportToCSV.ExportCasesToCSV(cases, false));
MessageService.Send(HttpContext.Current.Request, MessageAction.CasesExportedToCsv, cases.Select(x => x.Title));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportCasesToCSV(cases, true);
Response.Redirect(fileUrl);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
MobileVer = ASC.Web.Core.Mobile.MobileDetector.IsRequestMatchesMobile(this.Context);
if (UrlParameters.Action != "export")
{
InitPanels();
Page.RegisterClientScript(typeof(Masters.ClientScripts.ListDealViewData));
RegisterScript();
InitExchangeRateView();
}
else
{
var deals = GetDealsByFilter();
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
var fileName = "opportunity.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName)); Response.Write(ExportToCSV.ExportDealsToCSV(deals, false));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportDealsToCSV(deals, true);
Response.Redirect(fileUrl);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (UrlParameters.Action != "export")
{
InitPage();
}
else
{
var contacts = GetContactsByFilter();
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
const string fileName = "contacts.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName));
Response.Write(ExportToCSV.ExportContactsToCSV(contacts, false));
MessageService.Send(HttpContext.Current.Request, MessageAction.ContactsExportedToCsv, MessageTarget.Create(contacts.Select(x => x.ID)), contacts.Select(x => x.GetTitle()));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportContactsToCSV(contacts, true);
Response.Redirect(fileUrl);
}
}
}
private void btnExport_Click(object sender, RoutedEventArgs e)
{
if (OutCsventList.Count() > 0)
{
ExportToCSV.ExportDataGridWithDataSourceSaveAs(ADtGrid, OutCsventList);
}
}
private void RunExportToCSV(string fileName, ref bool openExportFile)
{
ExportToCSV csvExporter = new ExportToCSV(this.radGridView1);
csvExporter.CSVCellFormatting += csvExporter_CSVCellFormatting;
//set export settings
csvExporter.ExportHierarchy = true;
csvExporter.HiddenColumnOption = HiddenOption.DoNotExport;
try
{
this.Cursor = Cursors.WaitCursor;
csvExporter.RunExport(fileName);
RadMessageBox.SetThemeName(radGridView1.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
openExportFile = true;
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}
finally
{
this.Cursor = Cursors.Default;
}
}
public IProgressItem GetExportToCSVStatus()
{
if (!CRMSecurity.IsAdmin)
{
throw CRMSecurity.CreateSecurityException();
}
return(ExportToCSV.GetStatus());
}
public IProgressItem StartExportData()
{
if (!CRMSecurity.IsAdmin)
{
throw new Exception();
}
return(ExportToCSV.Start());
}
protected void Page_Load(object sender, EventArgs e)
{
MobileVer = ASC.Web.Core.Mobile.MobileDetector.IsRequestMatchesMobile(this.Context);
if (UrlParameters.Action != "export")
{
if (contactID == 0)
{
GetDataFromCookie();
if (NoDeals)
{
InitEmptyScreenForNoDeals();
}
else
{
InitEmptyScreenForFilter();
InitContactSelectorForFilter();
RegisterClientScriptForFilter();
}
}
else //if (contactID != 0)
{
NoDeals = false;
InitEmptyScreenForNoDealsInContact();
}
}
else if (contactID == 0)
{
if (!CRMSecurity.IsAdmin)
{
Response.Redirect(PathProvider.StartURL());
}
var deals = GetDealsByFilter();
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
var fileName = "opportunity.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName)); Response.Write(ExportToCSV.ExportDealsToCSV(deals, false));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportDealsToCSV(deals, true);
Response.Redirect(fileUrl);
}
}
}
public IProgressItem StartExportData()
{
if (!CRMSecurity.IsAdmin)
{
throw new Exception();
}
AdminLog.PostAction("CRM Settings: started crm data export");
return(ExportToCSV.Start());
}
public IProgressItem StartExportData()
{
if (!CRMSecurity.IsAdmin)
{
throw CRMSecurity.CreateSecurityException();
}
MessageService.Send(Request, MessageAction.CrmAllDataExported);
return(ExportToCSV.Start());
}
public IProgressItem StartExportData()
{
if (!CRMSecurity.IsAdmin)
{
throw new Exception();
}
MessageService.Send(HttpContext.Current.Request, MessageAction.CrmAllDataExported);
return(ExportToCSV.Start());
}
private void RunExportToCSV(string fileName, ref bool openExportFile)
{
ExportToCSV csvExporter = new ExportToCSV(this.radGridView1);
switch (this.radComboBoxSummaries.SelectedIndex)
{
case 0:
csvExporter.SummariesExportOption = SummariesOption.ExportAll;
break;
case 1:
csvExporter.SummariesExportOption = SummariesOption.ExportOnlyTop;
break;
case 2:
csvExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom;
break;
case 3:
csvExporter.SummariesExportOption = SummariesOption.DoNotExport;
break;
}
//set export settings
csvExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked;
csvExporter.HiddenColumnOption = HiddenOption.DoNotExport;
try
{
this.Cursor = Cursors.WaitCursor;
csvExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
openExportFile = true;
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}
finally
{
this.Cursor = Cursors.Default;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (UrlParameters.Action != "export")
{
_phListBase.Controls.Add(LoadControl(ListBaseView.Location));
}
else // export to csv
{
var tasks = GetTasksByFilter();
if (tasks.Count != 0)
{
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
const string fileName = "tasks.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName));
Response.Write(ExportToCSV.ExportTasksToCSV(tasks, false));
MessageService.Send(HttpContext.Current.Request, MessageAction.CrmTasksExportedToCsv, tasks.Select(x => x.Title));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportTasksToCSV(tasks, true);
Response.Redirect(fileUrl);
}
}
else
{
var cookie = HttpContext.Current.Request.Cookies.Get(ExportErrorCookieKey);
if (cookie == null)
{
cookie = new HttpCookie(ExportErrorCookieKey)
{
Value = CRMTaskResource.ExportTaskListEmptyError
};
HttpContext.Current.Response.Cookies.Add(cookie);
}
Response.Redirect(PathProvider.StartURL() + "tasks.aspx");
}
}
}
private void onExportToCSVtCommand()
{
//Get Save File Location
this.saveFileDialog.ShowDialog();
this.saveFileFullPath = saveFileDialog.FileName;
//Change ObservableCollection to list
this.listEventLog = new List <EventLog>(this.ListEventLog);
//Generate CSV File
if (ExportToCSV.CreateCSVFromGenericList(listEventLog, this.saveFileFullPath))
{
MessageBox.Show("Saving Complete @ " + this.saveFileFullPath.ToString(), "Saved Location", MessageBoxButton.OK, MessageBoxImage.Information);
}
this.listEventLog = null;
}
protected void Page_Load(object sender, EventArgs e)
{
MobileVer = ASC.Web.Core.Mobile.MobileDetector.IsRequestMatchesMobile(this.Context);
if (UrlParameters.Action != "export")
{
PageLoadRegular();
}
else // export to csv
{
var tasks = GetTasksByFilter();
if (tasks.Count != 0)
{
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
var fileName = "tasks.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName));
Response.Write(ExportToCSV.ExportTasksToCSV(tasks, false));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportTasksToCSV(tasks, true);
Response.Redirect(fileUrl);
}
}
else
{
var cookie = HttpContext.Current.Request.Cookies.Get(ExportErrorCookieKey);
if (cookie == null)
{
cookie = new HttpCookie(ExportErrorCookieKey);
cookie.Value = CRMTaskResource.ExportTaskListEmptyError;
HttpContext.Current.Response.Cookies.Add(cookie);
}
Response.Redirect(PathProvider.StartURL() + "tasks.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//Page.RegisterClientScript(typeof(Masters.ClientScripts.ListInvoiceViewData));
if (UrlParameters.Action != "export")
{
RegisterScript();
}
else // export to csv
{
var invoiceItems = GetInvoiceItemsByFilter();
if (invoiceItems.Count != 0)
{
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
var fileName = "products_services.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName));
Response.Write(ExportToCSV.ExportInvoiceItemsToCSV(invoiceItems, false));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportInvoiceItemsToCSV(invoiceItems, true);
Response.Redirect(fileUrl);
}
}
else
{
var cookie = HttpContext.Current.Request.Cookies.Get(ExportErrorCookieKey);
if (cookie == null)
{
cookie = new HttpCookie(ExportErrorCookieKey);
cookie.Value = CRMSettingResource.ExportInvoiceItemsEmptyError;
HttpContext.Current.Response.Cookies.Add(cookie);
}
Response.Redirect(PathProvider.StartURL() + "settings.aspx?type=invoice_items");
}
}
}
public static void ExportGridCSV(RadGridView rv)
{
//sv.fi
sv.Filter = "Spread Sheet files (*.csv)|*.csv|All files (*.csv)|*.csv";
sv.Title = "Save an CSV File";
sv.ShowDialog();
if (sv.FileName != "")
{
ExportToCSV exporter = new ExportToCSV(rv);
exporter.FileExtension = "csv";
exporter.ColumnDelimiter = ",";
exporter.HiddenColumnOption = HiddenOption.DoNotExport;
exporter.HiddenRowOption = HiddenOption.DoNotExport;
exporter.SummariesExportOption = SummariesOption.DoNotExport;
exporter.RunExport(sv.FileName);
MessageBox.Show("Export Completed");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (UrlParameters.Action != "export")
{
InitPage();
Page.RegisterClientScript(typeof(Masters.ClientScripts.ListContactViewData));
if (showEmptyScreen.Get("crmScreen" + TenantProvider.CurrentTenantID) == null)
{
var hasactivity = Global.DaoFactory.GetContactDao().HasActivity();
if (hasactivity)
{
showEmptyScreen.Insert("crmScreen" + TenantProvider.CurrentTenantID, new object(), TimeSpan.FromMinutes(30));
}
else
{
RenderDashboardEmptyScreen();
}
}
RegisterScript();
}
else
{
var contacts = GetContactsByFilter();
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
var fileName = "contacts.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName)); Response.Write(ExportToCSV.ExportContactsToCSV(contacts, false));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportContactsToCSV(contacts, true);
Response.Redirect(fileUrl);
}
}
}
public static void RunExportToCSV(string fileName, RadGridView radGridView)
{
ExportToCSV csvExporter = new ExportToCSV(radGridView);
csvExporter.CSVCellFormatting += csvExporter_CSVCellFormatting;
csvExporter.SummariesExportOption = SummariesOption.ExportAll;
//set export settings
//csvExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked;
csvExporter.HiddenColumnOption = HiddenOption.DoNotExport;
try
{
//this.Cursor = Cursors.WaitCursor;
csvExporter.RunExport(fileName);
RadMessageBox.SetThemeName(radGridView.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
try
{
System.Diagnostics.Process.Start(fileName);
}
catch (Exception ex)
{
string message = String.Format("The file cannot be opened on your system.\nError message: {0}", ex.Message);
RadMessageBox.Show(message, "Open File", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(radGridView.ThemeName);
//RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
System.Windows.Forms.MessageBox.Show(ex.Message, "ERR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
//this.Cursor = Cursors.Default;
}
}
private void ExportCSVClick(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = String.Format("{0} (*{1})|*{1}",
"CSV Files",
".csv");
if (sfd.ShowDialog() == DialogResult.OK)
{
ExportToCSV exporter = new ExportToCSV(this.radGridView1);
exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport;
exporter.SummariesExportOption = SummariesOption.DoNotExport;
exporter.CSVCellFormatting += new
Telerik.WinControls.UI.Export.CSV.CSVCellFormattingEventHandler(exporter_CSVCellFormatting);
exporter.CSVTableCreated += new
Telerik.WinControls.UI.Export.CSV.CSVTableCreatedEventHandler(exporter_CSVTableCreated);
exporter.RunExport(sfd.FileName);
MessageBox.Show("Export completed");
}
}
private void RunExportToCSV(string fileName, ref bool openExportFile)
{
ExportToCSV csvExporter = new ExportToCSV(this.radGridView1);
switch (this.radComboBoxSummaries.SelectedIndex)
{
case 0:
csvExporter.SummariesExportOption = SummariesOption.ExportAll;
break;
case 1:
csvExporter.SummariesExportOption = SummariesOption.ExportOnlyTop;
break;
case 2:
csvExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom;
break;
case 3:
csvExporter.SummariesExportOption = SummariesOption.DoNotExport;
break;
}
try
{
csvExporter.RunExport(fileName);
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?",
"Export to CSV", MessageBoxButtons.YesNo, RadMessageIcon.Question);
if (dr == DialogResult.Yes)
{
openExportFile = true;
}
}
catch (IOException ex)
{
RadMessageBox.SetThemeName(this.radGridView1.ThemeName);
RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error);
}
}
/// <summary>
/// 导出Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOutExcel_Click(object sender, RoutedEventArgs e)
{
string strEmployeeID = string.Empty, strSignInState = string.Empty, strCurStartDate = string.Empty, strCurEndDate = string.Empty, strSortKey = string.Empty, strOwnerID = string.Empty;
int pageIndex = 0, pageSize = 0, pageCount = 0;
strOwnerID = SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID;
strSignInState = (Convert.ToInt32(IsChecked.No) + 1).ToString();
strSortKey = " T_HR_ATTENDANCERECORD.EMPLOYEEID, ABNORMALDATE ";
CheckInputFilter(ref strEmployeeID, ref strCurStartDate, ref strCurEndDate);
pageIndex = 1;
pageSize = 1000000;//导出所有
if (OutCsventList == null)
{
outExcell = true;
MessageBox.Show("由于silverlight安全限制，请等待返回数据后再次点击导出Excel");
clientAtt.GetAbnormRecordRdListByMultSearchAsync(strOwnerID, strEmployeeID, strSignInState, strCurStartDate, strCurEndDate, strSortKey, pageIndex, pageSize, pageCount);
loadbar.Start();
}
else
{
ExportToCSV.ExportDataGridWithDataSourceSaveAs(dgAbnormRecordList, OutCsventList);
}
}
private void btnExportCSV_Click(object sender, EventArgs e)
{
if (grdEvtxData.DataSource == null)
{
MessageBox.Show("Önce dosya seçip Import ediniz.");
return;
}
var r = MessageBox.Show("Bu işlem çoook uzun sürmekte devam etmek istiyor musunuz? :)", "", MessageBoxButtons.OKCancel);
if (r != DialogResult.OK)
return;
var exporter = new ExportToCSV(grdEvtxData)
{
HiddenColumnOption = HiddenOption.DoNotExport,
SummariesExportOption = SummariesOption.DoNotExport
};
var saveFileDialog = new SaveFileDialog();
var result = saveFileDialog.ShowDialog();
if (result == DialogResult.OK)
{
exporter.RunExport(saveFileDialog.FileName);
MessageBox.Show("Excel aktarımı tamamlandı");
}
}
protected void Page_Load(object sender, EventArgs e)
{
MobileVer = ASC.Web.Core.Mobile.MobileDetector.IsRequestMatchesMobile(this.Context);
if (UrlParameters.Action != "export")
{
InitEmptyScreenControls();
Utility.RegisterTypeForAjax(typeof(AjaxProHelper));
if (EntityID == 0 && CurrentContact == null)//the main page with tasks
{
RegisterClientScriptForFilter();
GetDataFromCookie();
}
else // the tab with tasks
{
if (CurrentContact != null)
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "8adeda71-2ad7-43b7-9939-f69c776dfbc0",
"contactForInitTaskActionPanel = "
+ JavaScriptSerializer.Serialize(new
{
id = CurrentContact.ID,
displayName = CurrentContact.GetTitle().HtmlEncode(),
smallFotoUrl = ContactPhotoManager.GetSmallSizePhoto(CurrentContact.ID, CurrentContact is Company)
})
+ "; ", true);
}
if (UserList != null && UserList.Count > 0)
{
_taskActionView.UserList = UserList;
}
}
}
else // export to csv
{
if (!CRMSecurity.IsAdmin)
{
Response.Redirect(PathProvider.StartURL());
}
var tasks = GetTasksByFilter();
if (UrlParameters.View != "editor")
{
Response.Clear();
Response.ContentType = "text/csv; charset=utf-8";
Response.ContentEncoding = Encoding.UTF8;
Response.Charset = Encoding.UTF8.WebName;
var fileName = "tasks.csv";
Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName));
Response.Write(ExportToCSV.ExportTasksToCSV(tasks, false));
Response.End();
}
else
{
var fileUrl = ExportToCSV.ExportTasksToCSV(tasks, true);
Response.Redirect(fileUrl);
}
}
}
/// <summary>
/// 导出当前页的数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnExportForm_Click(object sender, RoutedEventArgs e)
{
ExportToCSV.ExportDataGridSaveAs(DtGrid);
}
public IProgressItem GetStatus()
{
return(ExportToCSV.GetStatus());
}
public IProgressItem Cancel()
{
ExportToCSV.Cancel();
return(GetStatus());
}
