public Framework.DataStreamServiceResult BuildResult(TCollection input, Framework.DataServiceTypes dataServiceType) { if (dataServiceType == Framework.DataServiceTypes.Csv) { Framework.DataStreamServiceResult result = new Framework.DataStreamServiceResult { DataServiceType = dataServiceType, MIMEType = "text/csv", FileExtension = ".csv" }; result.Result = BuildStreamOfLinqToCsv(input); return(result); } else if (dataServiceType == Framework.DataServiceTypes.Excel2010) { Framework.DataStreamServiceResult result = new Framework.DataStreamServiceResult { DataServiceType = dataServiceType, MIMEType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", FileExtension = ".xlsx" }; result.Result = BuildStreamOfCloseXmlExcel2010(input); return(result); } else { throw new Exception(string.Format("Service Not Provided: {0}", dataServiceType)); } }
public ActionResult Import(HttpPostedFileBase file) { ViewBag.FileFormat = "Id,EventCode,Description"; if (file != null && file.ContentLength > 0 && !string.IsNullOrWhiteSpace(file.FileName)) { log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Started.ToString())); Framework.DataStreamServiceResult dataStreamServiceResult = new Framework.DataStreamServiceResult(file.FileName, file.ContentType, file.ContentLength, file.InputStream); dataStreamServiceResult.TempFilePath = Framework.Web.WebFormApplicationApplicationVariables.FileStorageRootFolder; MSBuildExtensionPack.CommonBLL.BuildEventCodeDataStreamService dataStreamServiceProvider = new MSBuildExtensionPack.CommonBLL.BuildEventCodeDataStreamService(); MSBuildExtensionPack.DataSourceEntities.BuildEventCodeCollection collection = dataStreamServiceProvider.GetCollectionFromStream(dataStreamServiceResult); if (collection != null) { MSBuildExtensionPack.DataSourceEntities.BuildEventCodeCollection resultCollection = collection; var result = MSBuildExtensionPack.CommonBLLIoC.IoCBuildEventCode.BatchInsert(resultCollection); ViewBag.Message = Framework.Resx.UIStringResource.Data_Import_Success; } else { ViewBag.Message = Framework.Resx.UIStringResource.Data_Import_NoRecordInSourceFile; } log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Ended.ToString())); return(View()); } else { ViewBag.Message = ""; return(View()); } }
public ActionResult Import(HttpPostedFileBase file) { ViewBag.FileFormat = "Organization_1_UniqueIdentifier,Organization_1_UniqueidentifierColumn,Organization_1_Name,Id,Organization_2Id,Organization_2_UniqueIdentifier,Organization_2_UniqueidentifierColumn,Organization_2_Name,ExternalParentId,Name,Description,OrganizationId"; if (file != null && file.ContentLength > 0 && !string.IsNullOrWhiteSpace(file.FileName)) { log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Started.ToString())); Framework.DataStreamServiceResult dataStreamServiceResult = new Framework.DataStreamServiceResult(file.FileName, file.ContentType, file.ContentLength, file.InputStream); dataStreamServiceResult.TempFilePath = Framework.Web.WebFormApplicationApplicationVariables.FileStorageRootFolder; MSBuildExtensionPack.CommonBLL.SolutionDataStreamService.Default dataStreamServiceProvider = new MSBuildExtensionPack.CommonBLL.SolutionDataStreamService.Default(); MSBuildExtensionPack.DataSourceEntities.Solution.DefaultCollection collection = dataStreamServiceProvider.GetCollectionFromStream(dataStreamServiceResult); if (collection != null) { MSBuildExtensionPack.DataSourceEntities.SolutionCollection resultCollection = new MSBuildExtensionPack.DataSourceEntities.SolutionCollection(); MSBuildExtensionPack.EntityContracts.ISolutionHelper.CopyCollection <MSBuildExtensionPack.DataSourceEntities.Solution.DefaultCollection, MSBuildExtensionPack.DataSourceEntities.SolutionCollection, MSBuildExtensionPack.DataSourceEntities.Solution.Default, MSBuildExtensionPack.DataSourceEntities.Solution>(collection, resultCollection); var result = MSBuildExtensionPack.CommonBLLIoC.IoCSolution.BatchInsert(resultCollection); ViewBag.Message = Framework.Resx.UIStringResource.Data_Import_Success; } else { ViewBag.Message = Framework.Resx.UIStringResource.Data_Import_NoRecordInSourceFile; } log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Ended.ToString())); return(View()); } else { ViewBag.Message = ""; return(View()); } }
public static TCollection Read <TCollection, TItem>(Framework.DataStreamServiceResult file) where TCollection : List <TItem>, new() where TItem : class, new() { string _tempFilePath = Path.Combine(file.TempFilePath, file.FileName); (new FileInfo(_tempFilePath)).Directory.Create(); using (var fileStream = File.Create(_tempFilePath)) { file.Result.CopyTo(fileStream); } var excelSheet = new LinqToExcel.ExcelQueryFactory(_tempFilePath); var result = (from t in excelSheet.Worksheet <TItem>(0) select t).AsEnumerable(); TCollection collection = new TCollection(); collection.AddRange(result); File.Delete(_tempFilePath); return(collection); }
public ActionResult Import(HttpPostedFileBase file) { ViewBag.FileFormat = "Organization_2_UniqueidentifierColumn,Organization_2_UniqueIdentifier,Organization_2_Name,Id,ParentId,Name,IsSystemBuiltIn,UniqueIdentifier,CreatedDateTime,CharColumn,VarcharColumn,TextColumn,NcharColumn,NvarcharColumn,NtextColumn,BitColumn,BinaryColumn,VarbinaryColumn,ImageColumn,TinyintColumn,SmallintColumn,IntColumn,BigintColumn,DecimalColumn,NumericColumn,SmallmoneyColumn,MoneyColumn,FloatColumn,RealColumn,DatetimeColumn,Datetime2Column,SmalldatetimeColumn,DateColumn,TimeColumn,UniqueidentifierColumn"; if (file != null && file.ContentLength > 0 && !string.IsNullOrWhiteSpace(file.FileName)) { log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Started.ToString())); Framework.DataStreamServiceResult dataStreamServiceResult = new Framework.DataStreamServiceResult(file.FileName, file.ContentType, file.ContentLength, file.InputStream); dataStreamServiceResult.TempFilePath = Framework.Web.WebFormApplicationApplicationVariables.FileStorageRootFolder; MSBuildExtensionPack.CommonBLL.OrganizationDataStreamService.Default dataStreamServiceProvider = new MSBuildExtensionPack.CommonBLL.OrganizationDataStreamService.Default(); MSBuildExtensionPack.DataSourceEntities.Organization.DefaultCollection collection = dataStreamServiceProvider.GetCollectionFromStream(dataStreamServiceResult); if (collection != null) { MSBuildExtensionPack.DataSourceEntities.OrganizationCollection resultCollection = new MSBuildExtensionPack.DataSourceEntities.OrganizationCollection(); MSBuildExtensionPack.EntityContracts.IOrganizationHelper.CopyCollection <MSBuildExtensionPack.DataSourceEntities.Organization.DefaultCollection, MSBuildExtensionPack.DataSourceEntities.OrganizationCollection, MSBuildExtensionPack.DataSourceEntities.Organization.Default, MSBuildExtensionPack.DataSourceEntities.Organization>(collection, resultCollection); var result = MSBuildExtensionPack.CommonBLLIoC.IoCOrganization.BatchInsert(resultCollection); ViewBag.Message = Framework.Resx.UIStringResource.Data_Import_Success; } else { ViewBag.Message = Framework.Resx.UIStringResource.Data_Import_NoRecordInSourceFile; } log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Ended.ToString())); return(View()); } else { ViewBag.Message = ""; return(View()); } }
public ActionResult Import(HttpPostedFileBase file) { ViewBag.FileFormat = "Build_1_Name,Id,Solution_1Id,Solution_1_Name,BuildEventCode_1_Name,BuildId,BuildEventCodeId,Message,EventTime"; if (file != null && file.ContentLength > 0 && !string.IsNullOrWhiteSpace(file.FileName)) { log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Started.ToString())); Framework.DataStreamServiceResult dataStreamServiceResult = new Framework.DataStreamServiceResult(file.FileName, file.ContentType, file.ContentLength, file.InputStream); dataStreamServiceResult.TempFilePath = Framework.Web.WebFormApplicationApplicationVariables.FileStorageRootFolder; MSBuildLogsExtended.CommonBLL.BuildLogDataStreamService.Default dataStreamServiceProvider = new MSBuildLogsExtended.CommonBLL.BuildLogDataStreamService.Default(); MSBuildLogsExtended.DataSourceEntities.BuildLog.DefaultCollection collection = dataStreamServiceProvider.GetCollectionFromStream(dataStreamServiceResult); if (collection != null) { MSBuildLogsExtended.DataSourceEntities.BuildLogCollection resultCollection = new MSBuildLogsExtended.DataSourceEntities.BuildLogCollection(); MSBuildLogsExtended.EntityContracts.IBuildLogHelper.CopyCollection <MSBuildLogsExtended.DataSourceEntities.BuildLog.DefaultCollection, MSBuildLogsExtended.DataSourceEntities.BuildLogCollection, MSBuildLogsExtended.DataSourceEntities.BuildLog.Default, MSBuildLogsExtended.DataSourceEntities.BuildLog>(collection, resultCollection); var result = MSBuildLogsExtended.CommonBLLIoC.IoCBuildLog.BatchInsert(resultCollection); ViewBag.Message = Framework.Resources.UIStringResource.Data_Import_Success; } else { ViewBag.Message = Framework.Resources.UIStringResource.Data_Import_NoRecordInSourceFile; } log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Ended.ToString())); return(View()); } else { ViewBag.Message = ""; return(View()); } }
public TCollection GetCollectionFromStream(Framework.DataStreamServiceResult input) { TCollection collection; if (input.DataServiceType == Framework.DataServiceTypes.Csv) { collection = Framework.Services.LinqToCsvHelper.ReadFromStream <TCollection, TItem>(input.Result); } else if (input.DataServiceType == Framework.DataServiceTypes.Excel2010) { collection = Framework.Services.LinqToExcelHelper.Read <TCollection, TItem>(input); } else { collection = null; } return(collection); }
public ActionResult Import(HttpPostedFileBase file) { ViewBag.FileFormat = "Id,EventCode,Description"; if (file != null && file.ContentLength > 0 && !string.IsNullOrWhiteSpace(file.FileName)) { log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Started.ToString())); Framework.DataStreamServiceResult dataStreamServiceResult = new Framework.DataStreamServiceResult(file.FileName, file.ContentType, file.ContentLength, file.InputStream); dataStreamServiceResult.TempFilePath = Framework.Web.WebFormApplicationApplicationVariables.FileStorageRootFolder; MSBuildLogsExtended.CommonBLL.DataStreamServiceProviderBuildEventCode dataStreamServiceProvider = new MSBuildLogsExtended.CommonBLL.DataStreamServiceProviderBuildEventCode(); MSBuildLogsExtended.DataSourceEntities.BuildEventCodeCollection collection = dataStreamServiceProvider.GetCollectionFromStream(dataStreamServiceResult); if (collection != null) { MSBuildLogsExtended.DataSourceEntities.BuildEventCodeCollection resultCollection = collection; var result = MSBuildLogsExtended.CommonBLLIoC.BusinessLogicLayerEntityStaticBuildEventCode.BatchInsert(resultCollection); ViewBag.Message = Framework.Resources.UIStringResource.Data_Import_Success; } else { ViewBag.Message = Framework.Resources.UIStringResource.Data_Import_NoRecordInSourceFile; } log.Info(string.Format("{0}: Import", Framework.LoggingOptions.UI_Process_Ended.ToString())); return View(); } else { ViewBag.Message = ""; return View(); } }