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());
}
}
/// <summary>
/// Assigns the enity reference Ids.
/// </summary>
/// <param name="input">The input.</param>
public static void AssignEnityReferenceIDs(MSBuildExtensionPack.DataSourceEntities.OrganizationCollection input, System.Int64 parentId)
{
for (int i = 0; i < input.Count; i++)
{
MSBuildExtensionPack.DataSourceEntities.Organization _Item = input[i];
_Item.ParentId = parentId;
}
}
/// <summary>
/// Validates the value before save to database.
/// </summary>
/// <param name="input">The input.</param>
public static void ValidateValueBeforeSaveToDatabase(MSBuildExtensionPack.DataSourceEntities.OrganizationCollection input)
{
for (int i = 0; i < input.Count; i++)
{
MSBuildExtensionPack.DataSourceEntities.Organization _Item = input[i];
ValidateValueBeforeSaveToDatabase(_Item);
}
}
public async Task <MSBuildExtensionPack.CommonBLLEntities.OrganizationResponseMessageBuiltIn> BatchDelete(MSBuildExtensionPack.DataSourceEntities.OrganizationCollection input)
{
Task <MSBuildExtensionPack.CommonBLLEntities.OrganizationResponseMessageBuiltIn> resultTask = Task.Factory.StartNew <MSBuildExtensionPack.CommonBLLEntities.OrganizationResponseMessageBuiltIn>(() =>
{
MSBuildExtensionPack.CommonBLLEntities.OrganizationResponseMessageBuiltIn responseMessage = MSBuildExtensionPack.CommonBLLIoC.IoCOrganization.BatchDelete(input);
return(responseMessage);
});
return(await resultTask);
}
/// <summary>
/// batch delete a collection of <see cref=" MSBuildExtensionPack.DataSourceEntities.Organization"/>.
/// http://[host]/api/OrganizationApi/BatchDelete
/// </summary>
/// <param name="input">The input collection.</param>
// [HttpDelete, ActionName("BatchDelete")] //although JSON allowed in Http Delete request body, but not allowed in HttpClient
public async Task <MSBuildExtensionPack.CommonBLLEntities.OrganizationResponseMessageBuiltIn> BatchDeleteAsync(MSBuildExtensionPack.DataSourceEntities.OrganizationCollection input)
{
string url = GetHttpRequestUrl(ActionName_BatchDelete);
return(await Post <MSBuildExtensionPack.DataSourceEntities.OrganizationCollection, MSBuildExtensionPack.CommonBLLEntities.OrganizationResponseMessageBuiltIn>(url, input));
}
