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();
}
}
