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