public IActionResult Post(ContactType contactType) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _db.ContactType.AddOrUpdate(contactType); _db.SaveChanges(); return(Created(contactType)); }
public static async Task Run( [QueueTrigger("filemetadataproductionistest", Connection = "QueueStorage")] CloudQueueMessage myQueueItem, Binder binder, ILogger log) { //log.LogInformation($"C# Queue trigger function processed: {myQueueItem}"); var dto = JsonConvert.DeserializeObject <DocumentDto>(myQueueItem.AsString); var blobName = dto.AzureFileName; //todo get blob from storage (by guid from the queue) var attributes = new Attribute[] { new BlobAttribute("docstoragecontaineristest/" + blobName), new StorageAccountAttribute("AzureWebJobsStorage") }; CloudBlockBlob blob = await binder.BindAsync <CloudBlockBlob>(attributes); dto.DocumentContent = new byte[dto.DocumentContentLenght]; var result = blob.DownloadToByteArrayAsync(dto.DocumentContent, 0).Result; //dto.DocumentContent = ReadBlob("docstoragecontaineristest", blobName, dto.DocumentContentLenght); var connectionString = Environment.GetEnvironmentVariable("AdventureWorksDatabase"); var optionsBuilder = new DbContextOptionsBuilder <AdventureWorks2016Context>(); optionsBuilder.UseSqlServer(connectionString); using (var context = new AdventureWorks2016Context(optionsBuilder.Options)) { // add doc to the db //var owner = context.Employee.Where(x => x.BusinessEntityId == 1).FirstOrDefault(); var docId = context.GetNextDocId(); context.Document.Add(new Document() { ChangeNumber = 1, DocumentContent = dto.DocumentContent, DocumentNode = docId, DocumentSummary = dto.DocumentMetadata, FileExtension = Path.GetExtension(dto.FileName), FileName = dto.FileName, FolderFlag = false, ModifiedDate = DateTime.Now, Owner = 1, Revision = "", Rowguid = Guid.NewGuid(), Status = 1, Title = dto.DocumentName }); context.SaveChanges(); } }