protected void DownloadButton_Click(object sender, EventArgs e)
{
string file = string.Format("{0}-SchoolCrosswalk.xlsx",
DateTime.Now.ToString("yyyyMMdd"));
CreateExcelFile.CreateExcelDocument(DAL.SchoolCrosswalk.GetExport(), file, Response);
}
public void ExportData()
{
var sid = int.Parse(SID.SelectedValue);
string SourceType = string.Empty;
int SourceID = 0;
int SchoolID = 0;
if (ddSource.SelectedValue == "0")
{
SourceType = string.Empty;
SourceID = 0;
}
else
{
string[] stringSeparators = new string[] { "_|_" };
var arr = ddSource.SelectedValue.Split(stringSeparators, StringSplitOptions.None);
SourceType = arr[0];
SourceID = int.Parse(arr[1]);
}
int.TryParse(ddSchool.SelectedValue, out SchoolID);
var ds = DAL.SurveyResults.GetExport(sid, SourceType, SourceID, SchoolID);
string excelFilename = Server.MapPath("~/SurveyOrTestResultsExport.xlsx");
CreateExcelFile.CreateExcelDocument(ds, excelFilename);
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment; filename=SurveyOrTestResultsExport.xlsx");
EnableViewState = false;
Response.BinaryWrite(File.ReadAllBytes(excelFilename));
File.Delete(excelFilename);
Response.End();
}
public DataTable GetLocalAccountsInfo()
{
_localAccounts = new LocalAccountService(_scope, _options);
var localAccountsList = _localAccounts.GetAllLocalAccounts();
return(CreateExcelFile.ListToDataTable(localAccountsList, "Local Accounts"));
}
protected void btnExportExcel_Click(object sender, EventArgs e)
{
var payableProvider = new PayableProvider();
var DataSource = payableProvider.GetResultPayables().ToList();
var CollectionsListData = from payableModel in DataSource
select new PayableDurationModel
{
JournalID = payableModel.JournalID,
JournalNo = payableModel.JournalNo,
ApplicationNo = payableModel.ApplicationNo,
ProcessingDays = payableProvider.CalculateProcessDay((DateTime)payableModel.PaymentDate, payableModel.CreateDate),
LatePayment = payableProvider.IsPaymentlate(payableModel.CreateDate)
};
var FileName = "PaymentDurationData.xlsx";
var memoryStream = new MemoryStream();
CreateExcelFile.CreateExcelDocument(CollectionsListData.ToList(), memoryStream, "Payment Durations Report");
HttpResponse httpresponse = HttpContext.Current.Response;
httpresponse.ClearContent();
httpresponse.ClearHeaders();
httpresponse.Buffer = true;
httpresponse.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
httpresponse.AddHeader("content-Disposition", "attachment;filename=\"" + FileName);
httpresponse.BinaryWrite(memoryStream.ToArray());
httpresponse.Flush();
httpresponse.End();
}
protected void DownloadReport_Click(object sender, EventArgs e)
{
ReportPanel.Visible = true;
AlertPanel.Visible = false;
try
{
var ds = PrepareReport();
if (ds.Tables != null && ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count != 0)
{
ds.Tables[0].TableName = ReportName;
CreateExcelFile.CreateExcelDocument(
ds,
string.Format("{0}.xlsx", ReportName.Replace(" ", string.Empty)),
Response);
}
}
catch (Exception ex)
{
ReportPanel.Visible = false;
AlertPanel.Visible = true;
AlertMessage.Text = ex.Message;
}
}
public DataTable GetPrintersInfo()
{
_printers = new PrintersService(_scope, _options);
var printerNamesList = _printers.GetPrinters();
return(CreateExcelFile.ListToDataTable(printerNamesList, "Printers"));
}
public DataTable GetServicesInfo()
{
_services = new ServicesService(_scope, _options);
var serviceNamesList = _services.GetAllServices();
return(CreateExcelFile.ListToDataTable(serviceNamesList, "Services"));
}
public async Task <IHttpActionResult> ExportMediaNewsToExcel(MediaSearchModel model)
{
var userId = User.Identity.GetUserId <int>();
DateTime?fromDate = null, toDate = null;
string pathnew = Request.RequestUri.AbsolutePath;
if ((!String.IsNullOrEmpty(model.startDate)))
{
fromDate = DateTime.ParseExact(model.startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
if ((!String.IsNullOrEmpty(model.endDate)))
{
toDate = DateTime.ParseExact(model.endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
var taskResult = repository.GeMediaListAll(userId, model.mediaTypeId, model.newsTypeIds, model.channelIds, model.categoryIds, model.sentimentIds, model.relevanceIds, model.createdBy, model.script, fromDate, toDate);
var excelData = taskResult.MediaFormList;
string baseUrl = "";
string excelFilename = "MediaNews" + DateTime.Now.Year + DateTime.Now.Month + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Millisecond + ".xls";
string SaveLocation = HttpContext.Current.Request.PhysicalApplicationPath + "Files\\" + excelFilename;
DataTable dt = CreateExcelFile.ListToDataTable(excelData);
CreateExcelFile file = new CreateExcelFile();
string detail = file.CreateExcelSheet(dt, SaveLocation, new List <int>(), new List <int>(), new List <string>());
baseUrl = "Files/" + excelFilename;
return(Ok(baseUrl));
}
public void showStuff(DataSet ds)
{
//// baz kardane dialoge save
Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog();
dlg.FileName = ""; // Default file name
dlg.DefaultExt = ".xls"; // Default file extension
dlg.Filter = "Excel Document (.xls)|*.xls"; // Filter files by extension
Nullable <bool> result = dlg.ShowDialog();
string filename = "";
if (result == true)
{
filename = dlg.FileName;
// Step 2: Create the Excel .xlsx file
try
{
bool b = CreateExcelFile.CreateExcelDocument(ds, filename);
}
catch (Exception ex)
{
MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message);
return;
}
}
//// --
}
public ActionResult ExportToExcel(Enumerations.ExcelExport id = Enumerations.ExcelExport.ALL)
{
try
{
IAdminService adminService = new AdminService();
var listofMemberships = adminService.GetMemberships(null).ToList();
IUserService userService = new UserService();
var members = userService.GetMembers(null, null, true);
if (id == Enumerations.ExcelExport.ALL)
{
}
var memberlist = members.
Select(group =>
new
{
memberid = group.MemberId,
name = group.TitleFullname,
Age = group.Age,
DateOfBirth = group.DateOfBirth,
Town = group.Town,
Mobile = group.MobilePhone,
Phone = group.HomePhone,
Office = group.OfficePhone,
Email = group.EmailAddress,
NumVisits = group.NumberVisits,
LastVisit = group.LastVisit,
Membership = group.Membership.Name,
HasArrears = (group.HasArrears?"Yes":"No"),
LongOverdue = (group.IsLongOverdue ? "Yes" : "No"),
Birthday = (group.IsBirthday ? "Yes" : "No"),
IsActive = (group.IsActive ? "Yes" : "No"),
LastOrNextPaymentDate = group.PaymentUntilDate,
DuetoDate = (group.HasArrears?group.AmountDueToDate:0)
}).ToList();
var Dt = DateTime.Now;
ContentResult excel = new ContentResult();
var target = ConfigurationHelper.GetReportFolder() + "Members as at " + Dt.ToString("dd-MMM-yyyy-HHmmss") + ".xlsx";
ViewBag.Target = target;
CreateExcelFile.CreateExcelDocument(memberlist, target);
return(View());
}
catch (Exception e)
{
log.Error("ExportToExcel] - Exception Caught" + e.ToString());
TempData["errorLog"] = new ErrorLog(e);
return(RedirectToAction("Error", "Home"));
}
}
protected void DownloadReport_Click(object sender, EventArgs e)
{
ReportPanel.Visible = true;
AlertPanel.Visible = false;
try
{
var ds = PrepareReport();
if (ds.Tables != null && ds.Tables.Count >= 1 && ds.Tables[0].Rows.Count != 0)
{
ds.Tables[0].TableName = "Events+Codes";
CreateExcelFile.CreateExcelDocument(
ds,
string.Format("{0}-{1}-EventCodes.xlsx",
LibraryDistrictList.SelectedItem.Text.Replace(" ", string.Empty),
LibraryBranchList.SelectedItem.Text.Replace(" ", string.Empty)),
Response);
}
}
catch (Exception ex)
{
ReportPanel.Visible = false;
AlertPanel.Visible = true;
AlertMessage.Text = ex.Message;
}
}
public JsonResult GenerateSpreadsheet()
{
// Create temp path and file name
var path = Server.MapPath("~/temp");
var fileName = "Spreadsheet.xlsx";
// Create temp path if not exits
if (Directory.Exists(path) == false)
{
Directory.CreateDirectory(path);
}
// Create the sample DataSet
DataSet dataSet = new System.Data.DataSet("Hospital");
dataSet.Tables.Add(Table());
// Create the Excel file in temp path
string fullPath = Path.Combine(path, fileName);
//CreateExcelFile cef = new CreateExcelFile();
CreateExcelFile.CreateExcelDocument(dataSet, fullPath, includeAutoFilter: true);
// Return the Excel file name
return(Json(new { fileName = fileName, errorMessage = "" }));
}
public void CreateExcelDoc()
{
SqlConnection connection = new SqlConnection(ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter(sql, connection);
DataSet dst = CreateSampleData(sda); //new DataSet();
SaveFileDialog savef = new SaveFileDialog();
savef.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
savef.FilterIndex = 1;
if (savef.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
CreateExcelFile.CreateExcelDocument(dst, savef.FileName);
if (ToOpen(savef.FileName) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(savef.FileName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
}
public void ProcessAllFtp()
{
_ConnectionString = Helper.LoadConfigKeys("ConnectionString");// +";Integrated Security=SSPI; trusted_connection=Yes;";
try{
_processes = GetDataFromDb();
}
catch (Exception ex)
{
LogObj.WriteLog("Failed Accessing DB for windows user identity " + WindowsIdentity.GetCurrent() + " error:" + ex.Message, enMsgType.enMsgType_Error, _LogPrefix, _AppLogDirectory);
}
_AppLogDirectory = Helper.GetMyDir(_ConnectionString);
foreach (Process p in _processes)
{
string res = "For Upload ProcessID " + p.ID + " HostIP " + p.HostIP + ": ";
LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory);
if (ValidInput(p))
{
_results += res;
p.LocalDir = _UploadFolder; //we change it to the user-selected folder !
FTPProcess ftp = new FTPProcess(p.RAM, p.HostIP, p.Port, p.Login, p.Password, p.RemoteDir, p.Pattern,
_UploadFolder, p.PharmacyName, "not used here");
ftp.SetExcelTable(_tblExcel);
IFtpType requiredTFtp = null;
FtpFactory factory = new FtpFactory();
requiredTFtp = factory.CreateFtpFactory(p.FtpType, "upload", "", "");
res = ftp.ComputeFtp(requiredTFtp);
_tblExcel = ftp.GetExcelTbl();
LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory);
_results += res;
}
// LogObj.WriteLog(res, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory);
_results += "\r\n";
}
LogObj.WriteLog("Completed!", enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory);
/* Create the Excel report */
try
{
if (_tblExcel == null)
{
throw new Exception("No Excel Report content was generated");
}
CreateExcelFile.CreateExcelDocument(_tblExcel, _AppLogDirectory, _LogPrefix);
}
catch (Exception ex)
{
LogObj.WriteLog("Couldn't create Excel report. nException: " + ex.Message, enMsgType.enMsgType_Info, _LogPrefix, _AppLogDirectory);
}
}
public DataTable GetSoftwareInfo()
{
_applications = new SoftwareService(_scope, _options);
var softwareNamesList = _applications.GetAllSoftware();
var dt = CreateExcelFile.ListToDataTable(softwareNamesList, "Software");
DataView dv = dt.DefaultView;
dv.Sort = "Name asc";
return(dv.ToTable());
}
public void ExportOperationsOld(int id)
{
//Create table for results
var result = _exportService.ExportOperationsForEventOld(id);
if (result != null)
{
CreateExcelFile.CreateExcelDocument(result.Table, result.Name + ".xlsx", System.Web.HttpContext.Current.Response);
}
}
protected ActionResult ExportToExcel <T>(FromToQuery query, List <T> list, ExportDefinition <T> exportDefinition,
string prefix, Action <DataTable> postProcessDataTable = null)
{
var tempFile = Path.GetTempFileName();
CreateExcelFile.CreateExcelDocument(list, exportDefinition, tempFile, postProcessDataTable);
return(File(System.IO.File.ReadAllBytes(tempFile),
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
$"{prefix}-Export_{query.From:yyyyMMdd}-{query.To:yyyyMMdd}.xlsx"));
}
//export data to excel
private void btnOK_Click(object sender, EventArgs e)
{
Maticsoft.BLL.Patient patientBLL = new Maticsoft.BLL.Patient();
DataSet ds = patientBLL.GetAllListWithTitle();
ds.Tables[0].TableName = "患者信息";
//人口学数据
Maticsoft.BLL.Demographic demoBLL = new Maticsoft.BLL.Demographic();
DataTable dtDemo = demoBLL.GetAllListWithTitle().Tables[0].Copy();
dtDemo.TableName = "人口学数据";
//一般情况
Maticsoft.BLL.GeneralInfo geneBLL = new Maticsoft.BLL.GeneralInfo();
DataTable dtGene = geneBLL.GetAllListWithTitle().Tables[0].Copy();
dtGene.TableName = "一般情况";
ds.Tables.Add(dtDemo);
ds.Tables.Add(dtGene);
DialogResult result = this.folderBrowserDialog1.ShowDialog();
if (result == DialogResult.OK)
{
string foldername = this.folderBrowserDialog1.SelectedPath;
try
{
if (cbTreatInfo.Checked || cbTreatInfoBadAction.Checked)
{
DataSet dsTreatInfo = GetTreatInfo();
CreateExcelFile.CreateExcelDocument(dsTreatInfo, foldername + @"\治疗情况.xlsx");
}
if (cbCOPD.Checked || cbBlood.Checked || cbLung.Checked || cbDicom.Checked || cbChartis.Checked || cbSport.Checked)
{
DataSet dsBeforeTreatInfo = GetBeforeTreatInfo();
CreateExcelFile.CreateExcelDocument(dsBeforeTreatInfo, foldername + @"\治疗前基线指标.xlsx");
}
CreateExcelFile.CreateExcelDocument(ds, foldername + @"\患者基本信息.xlsx");
MessageBox.Show("数据提取成功!");
if (File.Exists(foldername))
{
Process.Start("explorer.exe", foldername);
}
}
catch (Exception ex)
{
MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message);
return;
}
// the code here will be executed if the user presses Open in
// the dialog.
}
}
protected void btnExportToExcel_Click(object sender, EventArgs e)
{
if (GridView1.Caption == "ProfitAndLoss")
{
CreateExcelFile.CreateExcelDocument((List <ProfitAndLoss>)ViewState["ProfitAndLossData"], "D:\\ProfitAndLoss-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx");
}
else
{
CreateExcelFile.CreateExcelDocument((List <SalesData>)ViewState["ListSalePurchase"], "D:\\" + GridView1.Caption + "-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx");
}
}
public IHttpActionResult SaveFile(int id)
{
Survey survey = surveyService.GetWithResult(id);
if (survey == null)
{
return(NotFound());
}
survey.Questions.ToList().ForEach(q =>
{
q.QuestionAnswers = q.QuestionAnswers.OrderBy(qa => qa.OrdinalNumber).ToList();
});
var users = surveyService.UsersWhoFilledSurvey(survey.Users.Select(u => u.UserId).ToList());
SurveyResultViewModel surveyVM = AutoMapper.Mapper.Map <Survey, SurveyResultViewModel>(survey);
this.SetSurveyResultVMValues(surveyVM, survey, users, 0, true);
using (var xlPackage = new ExcelPackage())
{
var ws = xlPackage.Workbook.Worksheets.Add("Anketa: " + survey.Name);
CreateExcelFile createEF = new CreateExcelFile(surveyService);
if (!survey.Anonymous)
{
createEF.CreateSurveyWorksheet(ws, surveyVM);
}
createEF.CreateQuestionsOnSurveyWorksheet(ws, surveyVM);
surveyVM.Questions.ToList().ForEach(q =>
{
createEF.CreateQuestionWorksheet(xlPackage, q, surveyVM, survey);
});
users.ForEach(u =>
{
var answers = surveyService.GetAnswersForUser(u.Id).ToList();
createEF.CreateUserWorksheet(xlPackage, u, survey, answers, users.IndexOf(u));
});
ExcelFiles obj = new ExcelFiles()
{
Bytes = xlPackage.GetAsByteArray(), SurveyId = survey.Id, CreationDate = DateTime.Now, Name = survey.Name + DateTime.Now.ToString() + ".xlsx"
};
surveyService.AddExcel(obj);
unitOfWork.Commit();
}
return(Ok());
}
private void BtnExel_Click(object sender, RoutedEventArgs e)
{
var entities = ak.Capitals.ToList();
var table = new System.Data.DataTable();
table.Columns.Add("شماره", typeof(int));
table.Columns.Add("تاریخ", typeof(string));
table.Columns.Add("مبلغ", typeof(string));
foreach (var entity in entities)
{
var row = table.NewRow();
row["شماره"] = entity.CNO;
row["تاریخ"] = entity.CDate;
row["مبلغ"] = entity.CTotalPrice;
table.Rows.Add(row);
}
//// -------
DataSet ds = new DataSet("New_DataSet");
ds.Locale = System.Threading.Thread.CurrentThread.CurrentCulture;
ds.Tables.Add(table);
//// baz kardane dialoge save
Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog();
dlg.FileName = ""; // Default file name
dlg.DefaultExt = ".xls"; // Default file extension
dlg.Filter = "Text documents (.xls)|*.xls"; // Filter files by extension
Nullable <bool> result = dlg.ShowDialog();
string filename = "";
if (result == true)
{
filename = dlg.FileName;
//ExcelLibrary.DataSetHelper.CreateWorkbook(filename, ds);
// Step 2: Create the Excel .xlsx file
try
{
bool b = CreateExcelFile.CreateExcelDocument(ds, filename);
}
catch (Exception ex)
{
MessageBox.Show("Couldn't create Excel file.\r\nException: " + ex.Message);
return;
}
}
//// ---------
}
private void ExportarAExcel()
{
var a = this.columnas;
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "Libro de Excel|.xlsx";
saveFileDialog1.Title = "Exportar a Excel";
saveFileDialog1.ShowDialog();
if (saveFileDialog1.FileName != "")
{
CreateExcelFile.CreateExcelDocument(Items.ToList(), saveFileDialog1.FileName);
}
}
private void ExecuteExportToExcel(object parameter)
{
try
{
CreateExcelFile c = new CreateExcelFile();
c.CreatePlaybookSheets(FailedTrials, NewSales, ScheduledTrials, ImportantProjects);
}
catch
{
IMessageBoxService _msg = new MessageBoxService();
_msg.ShowMessage("There was a problem creating the Excel report", "Unable to create Excel report", GenericMessageBoxButton.OK, GenericMessageBoxIcon.Error);
}
}
private void ExecuteExportToExcel(object parameter)
{
try
{
CreateExcelFile c = new CreateExcelFile();
c.CreateExcelSummaryReport(_datatable, _projectcountdatatable);
}
catch
{
IMessageBoxService _msg = new MessageBoxService();
_msg.ShowMessage("There was a problem creating the Excel report", "Unable to create Excel report", GenericMessageBoxButton.OK, GenericMessageBoxIcon.Error);
}
}
private void ExecuteExportToExcel(object parameter)
{
CreateExcelFile c = new CreateExcelFile();
if (Assets.Count > 0)
{
c.CreateExcelReport(MakeDTReport(Assets, "Duplicate Asset Labels"));
}
if (AssetsWithNoLocationInformation.Count > 0)
{
c.CreateExcelReport(MakeDTReport(AssetsWithNoLocationInformation, "Missing Location Data"));
}
}
private void ExportExcel(DataTable data)
{
string fileName;
SaveFileDialog fileDialog = new SaveFileDialog()
{
Filter = "Excel files (*.xlsx)|*.xlsx"
};
if (fileDialog.ShowDialog() == DialogResult.OK)
{
fileName = fileDialog.FileName;
CreateExcelFile.CreateExcelDocument(data, fileName);
}
}
protected void btnExport_Click(object sender, EventArgs e)
{
var ds = GetReportData();
string excelFilename = Server.MapPath("~/FinisherStatsReportResults.xlsx");
CreateExcelFile.CreateExcelDocument(ds, excelFilename);
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment; filename=FinisherStatsReportResults.xlsx");
EnableViewState = false;
Response.BinaryWrite(File.ReadAllBytes(excelFilename));
File.Delete(excelFilename);
Response.End();
}
private bool GenerarFacturacion()
{
string Reporte = "Listado para facturación";
string FileName = GetFileName(Reporte);
if (CheckFile(FileName, Reporte))
{
Facturaciones Facturaciones = new Facturaciones();
List <Facturacion> lstReporte = Facturaciones.Generar(semanaToReport);
List <string> header = GetHeader(semanaToReport, "Listado para facturación");
string footer = lstReporte.Count.ToString() + " registros";
CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer);
return(true);
}
return(false);
}
private bool GenerarSituacionBSPs()
{
string Reporte = "Situacion BSP";
string FileName = GetFileName(Reporte);
if (CheckFile(FileName, Reporte))
{
SituacionBSPs SituacionBSPs = new SituacionBSPs();
List <SituacionBSP> lstReporte = SituacionBSPs.Generar(semanaToReport);
List <string> header = GetHeader(semanaToReport, "Situación BSP (Movimientos registrados en BSP y no en su sistema)");
string footer = lstReporte.Count.ToString() + " registros";
CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer);
return(true);
}
return(false);
}
private bool GenerarReembolsos()
{
string Reporte = "Reembolsos";
string FileName = GetFileName(Reporte);
if (CheckFile(FileName, Reporte))
{
Reembolsos Reembolsos = new Reembolsos();
List <Reembolso> lstReporte = Reembolsos.Generar(semanaToReport);
List <string> header = GetHeader(semanaToReport, "Reembolsos en BSP");
string footer = lstReporte.Count(x => x.BoletoNro != "TOTAL").ToString() + " registros";
CreateExcelFile.CreateExcelDocument(lstReporte, Reporte, FileName, header.ToArray(), footer);
return(true);
}
return(false);
}
