public async Task <string> ExcelExport(string langId)
{
AppSettings.SetSiteLanguage(langId);
var parentDirectory = Directory.GetParent(Environment.CurrentDirectory).FullName;
var fileName = string.Format("OperatingRooms_{0}.xlsx", Guid.NewGuid().ToString());
FileStream fs = new FileStream(Path.Combine(parentDirectory, "Surgicalogic.Web", "static", fileName), FileMode.CreateNew);
var excelService = new ExcelDocumentService();
var items = await _operatingRoomStoreService.GetExportAsync <OperatingRoomExportModel>();
await excelService.WriteAsync(fs, "Worksheet", items, typeof(OperatingRoomExportModel), System.Globalization.CultureInfo.CurrentCulture);
return(fileName);
}
public async Task <string> ExcelExport(string langId)
{
AppSettings.SetSiteLanguage(langId);
var parentDirectory = Directory.GetParent(Environment.CurrentDirectory).FullName;
var fileName = string.Format("Equipments_{0}.xlsx", Guid.NewGuid().ToString());
FileStream fs = new FileStream(Path.Combine(parentDirectory, "Surgicalogic.Web", "static", fileName), FileMode.CreateNew);
var excelService = new ExcelDocumentService();
var items = await _equipmentStoreService.GetExportAsync <EquipmentExportModel>();
foreach (var item in items)
{
item.IsPortable = item.IsPortable == "+" ? Resources.Resource.Yes : Resources.Resource.No;
}
await excelService.WriteAsync(fs, "Worksheet", items, typeof(EquipmentExportModel), System.Globalization.CultureInfo.CurrentCulture);
return(fileName);
}
public async Task WriteToFile(string filePath, string worksheetName, ExcelModel[] excelModels, CultureInfo cultureInfo)
{
await excelDocumentService.WriteAsync(filePath, worksheetName, excelModels, cultureInfo);
}