/*Section="Method-CreateTaskDocument"*/ public void CreateTaskDocument(TaskDocument taskDocument) { using (IDAL dal = this.DAL) { dal.BeginTransaction(); try { IUniParameter prmOverStoreTask = dal.CreateParameter("OverStoreTask", taskDocument.OverStoreTask); IUniParameter prmDocument = dal.CreateParameter("Document", taskDocument.Document); dal.ExecuteNonQuery("OSM_INS_TASKDOCUMENT_SP", prmOverStoreTask, prmDocument); dal.CommitTransaction(); } catch { dal.RollbackTransaction(); throw; } } }
public async Task <TaskDocument> AddTaskAsync(ObjectId idUser, TaskDocument newTask) { var filterUser = Builders <UserDocument> .Filter.Eq("_id", idUser); var user = await _collection.Find(filterUser).FirstOrDefaultAsync(); if (null == user) { return(null); } newTask.Id = ObjectId.GenerateNewId(); newTask.Done = false; var updateCommand = Builders <UserDocument> .Update.Push("Tasks", newTask); await _collection.FindOneAndUpdateAsync(filterUser, updateCommand); return(newTask); }
public async Task <bool> UpdateTaskAsync(ObjectId idUser, ObjectId idTask, TaskDocument updatedTask) { var filterUser = Builders <UserDocument> .Filter.Eq("_id", idUser); var user = await _collection.Find(filterUser).FirstOrDefaultAsync(); if (null == user) { return(false); } user.Tasks.RemoveAll(t => t.Id.Equals(idTask)); user.Tasks.Add(updatedTask); var r = await _collection.ReplaceOneAsync(filterUser, user); return(r.ModifiedCount > 0); /*var updateCommand = Builders<UserDocument>.Update.Push("Tasks", updatedTask); * var updatedUser = await _collection.FindOneAndUpdateAsync(filterUser, updateCommand); * var taskUpdated = updatedUser?.Tasks.Find(t => t.Id.Equals(idTask)); * return taskUpdated != null;*/ }
public BaseResponse <TaskDocument> Add(TaskDocument model) { return(taskService.AddTaskDocument(model)); }
public async Task <ActionResult> TaskDocumentDownload(TaskDocument _taskDocument) { TaskDocument taskDocument = new TaskDocument(); taskDocument.Cid = _taskDocument.Cid; taskDocument.DocumentName = _taskDocument.DocumentName; taskDocument.Tskid = _taskDocument.Tskid; taskDocument.UplodedBy = _taskDocument.UplodedBy; Byte[] bytesFile = Convert.FromBase64String(_taskDocument.Filestream); byte[] tstArry = { 0, 1 }; taskDocument.FileData = tstArry; taskDocument.FileType = _taskDocument.FileType; taskDocument.Filestream = "test"; //_context.TaskDocument.Add(taskDocument); //await _context.SaveChangesAsync(); //CreatedAtAction("GetAuditorPortfolio", new { id = _taskDocument.Tskid }, _taskDocument); #region "Blob Storage Download" try { MemoryStream ms = new MemoryStream(); if (CloudStorageAccount.TryParse("DefaultEndpointsProtocol=https;AccountName=mccog;AccountKey=oan1RKJMPe82KxZDhfHqZArWCSHzSukEdwl8VSQgSP+w3pxIvLkHEObL6iUwMbiSM9Kx6mcmx5ZYsj3lBQ29GQ==;EndpointSuffix=core.windows.net", out CloudStorageAccount storageAccount)) { CloudBlobClient BlobClient = storageAccount.CreateCloudBlobClient(); string strContainerName = "taskdocuments"; CloudBlobContainer container = BlobClient.GetContainerReference(strContainerName); if (await container.ExistsAsync()) { CloudBlob file = container.GetBlobReference(_taskDocument.DocumentName); if (await file.ExistsAsync()) { await file.DownloadToStreamAsync(ms); Stream blobStream = file.OpenReadAsync().Result; return(File(blobStream, file.Properties.ContentType, file.Name)); } else { return(Content("File does not exist")); } } else { return(Content("Container does not exist")); } } else { return(Content("Error opening storage")); } } catch (Exception ex) { throw (ex); } #endregion return(NoContent()); }
public async Task <ActionResult <TaskDocument> > TaskDocumentUpload(TaskDocument _taskDocument) { TaskDocument taskDocument = new TaskDocument(); taskDocument.Cid = _taskDocument.Cid; taskDocument.DocumentName = _taskDocument.DocumentName; taskDocument.Tskid = _taskDocument.Tskid; taskDocument.UplodedBy = _taskDocument.UplodedBy; Byte[] bytesFile = Convert.FromBase64String(_taskDocument.Filestream); byte[] tstArry = { 0, 1 }; taskDocument.FileData = tstArry; taskDocument.FileType = _taskDocument.FileType; taskDocument.Filestream = "test"; _context.TaskDocument.Add(taskDocument); await _context.SaveChangesAsync(); CreatedAtAction("GetAuditorPortfolio", new { id = _taskDocument.Tskid }, _taskDocument); #region "Blob Storage Upload" try { CloudStorageAccount cloudStorageAccount = CloudStorageAccount.Parse("DefaultEndpointsProtocol=https;AccountName=mccog;AccountKey=oan1RKJMPe82KxZDhfHqZArWCSHzSukEdwl8VSQgSP+w3pxIvLkHEObL6iUwMbiSM9Kx6mcmx5ZYsj3lBQ29GQ==;EndpointSuffix=core.windows.net"); CloudBlobClient cloudBlobClient = cloudStorageAccount.CreateCloudBlobClient(); string strContainerName = "taskdocuments"; CloudBlobContainer cloudBlobContainer = cloudBlobClient.GetContainerReference(strContainerName); if (await cloudBlobContainer.CreateIfNotExistsAsync()) { await cloudBlobContainer.SetPermissionsAsync(new BlobContainerPermissions { PublicAccess = BlobContainerPublicAccessType.Blob }); } if (_taskDocument.DocumentName != null && bytesFile != null) { CloudBlockBlob cloudBlockBlob = cloudBlobContainer.GetBlockBlobReference(_taskDocument.DocumentName); cloudBlockBlob.Properties.ContentType = _taskDocument.FileType; await cloudBlockBlob.UploadFromByteArrayAsync(bytesFile, 0, bytesFile.Length); string URI = cloudBlockBlob.Uri.AbsoluteUri; } } catch (Exception ex) { throw (ex); } #endregion #region "Service Bus Entry" TaskDocument taskDocumentServiceBus = new TaskDocument(); taskDocumentServiceBus.Cid = _taskDocument.Cid; taskDocumentServiceBus.DocumentName = _taskDocument.DocumentName; taskDocumentServiceBus.Tskid = _taskDocument.Tskid; taskDocumentServiceBus.UplodedBy = _taskDocument.UplodedBy; taskDocumentServiceBus.FileType = _taskDocument.FileType; const string ServiceBusConnectionString = "Endpoint=sb://auditor2client.servicebus.windows.net/;SharedAccessKeyName=RootManageSharedAccessKey;SharedAccessKey=BJtC7Tu9IhAH62XqaazRBI24PgeRj43cwbXAy0zbFLE="; //access policy const string QueueName = "a2cdoc"; queueClient = new QueueClient(ServiceBusConnectionString, QueueName); string ShareMessage = JsonConvert.SerializeObject(taskDocumentServiceBus); var message = new Message(Encoding.UTF8.GetBytes(ShareMessage)); await queueClient.SendAsync(message); #endregion return(NoContent()); }
protected void addTask_OnClick(object sender, EventArgs e) { //var checkDate = CheckPreviousDate(dueDate.Text); //if (checkDate) //{ // lblError.Visible = true; // return; //} //lblError.Visible = false; var taskDescription = taskDesciption.Text; var id = Convert.ToInt64(Session["ID"]); var taskDoc = new TaskDocument(); var stats = 0; var selectedUserId = Convert.ToInt32(userList.SelectedValue); if (attachments.HasFile) { var files = attachments.PostedFiles; foreach (var file in files) { var fileName = Page.Server.MapPath("~/Uploads/TaskDocuments/" + Path.GetFileName(file.FileName)); file.SaveAs(fileName); var fileByte = _imageService.ReadToEnd(file.InputStream); taskDoc = _insedlu.TaskDocuments.Add( new TaskDocument { name = fileName, created_at = DateTime.Today, file = fileByte }); try { _insedlu.SaveChanges(); } catch (DbEntityValidationException exception) { Console.WriteLine(exception.EntityValidationErrors); throw; } } } if (!string.IsNullOrEmpty(taskDescription)) { var date = DateTime.ParseExact(dueDate.Text, "dd/MM/yyyy", null); var todaysDate = DateTime.Today; var numberOfDays = GetRemainingDays(date, todaysDate); var task = new Task { created_at = DateTime.Now, body = taskDescription, modified_at = DateTime.Now, due_date = date, user_id = (int)id, status = (int)TaskStatus.Assigned, task_document_id = taskDoc.id, number_of_days_left = numberOfDays }; myTasksList.Text = task.body; var check = _projectService.SaveTask(task); var taskComplete = new TaskCompletion { completion = numberOfDays.ToString(), task_id = (int)task.id }; _insedlu.TaskCompletions.Add(taskComplete); _insedlu.SaveChanges(); stats = Status("Assigned"); var taskStatus = Convert.ToInt32(stats); //var task = _insedlu.Tasks.Single(x => x.id == taskId); task.status = taskStatus; task.assigned_to = selectedUserId; _insedlu.Entry(task).State = EntityState.Modified; _insedlu.SaveChanges(); if (check == 1) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('Task saved successfully')", true); } } SetTasks(_id); }
public void EnsureSeedData() { var context = new MongoDbContext(_connection); IMongoDatabase db = context.Database("mongocore"); IMongoCollection <UserDocument> userCollection = context.Collection <UserDocument>("mongocore", "usertasks"); var count = userCollection.Count(new BsonDocument()); if (count > 0) { Console.WriteLine($">>>>> {count} documents already exist in collection"); var filter = Builders <UserDocument> .Filter.Eq("Username", "sapaul"); var user = userCollection.Find(filter).First(); Console.WriteLine($"\n[Admin Info] {user.FirstName} {user.LastName}"); if (PasswordHasher.Match("sapaul", user.PasswordHash)) { Console.WriteLine("Password Match test #1 passed"); } if (!PasswordHasher.Match("sapauul", user.PasswordHash)) { Console.WriteLine("Password Match test #2 passed"); } return; } var task1 = new TaskDocument { Id = ObjectId.GenerateNewId(), Name = "Remember the milk!", Description = "", Done = true, }; var task2 = new TaskDocument { Id = ObjectId.GenerateNewId(), Name = "update bio", Description = "", Done = false }; userCollection.InsertOne(new UserDocument { Admin = true, FirstName = "Santanu", LastName = "Paul", Username = "******", Email = "*****@*****.**", PasswordHash = PasswordHasher.Generate("sapaul"), Tasks = new List <TaskDocument>(new[] { task1, task2 }) }); userCollection.InsertOne(new UserDocument { Admin = false, FirstName = "Joe", LastName = "Doe", Username = "******", Email = "*****@*****.**", PasswordHash = PasswordHasher.Generate("jodoe"), Tasks = new List <TaskDocument>(new[] { new TaskDocument { Id = ObjectId.GenerateNewId(), Name = "John's task 1", Done = false } }) }); userCollection.InsertOne(new UserDocument { Admin = false, FirstName = "Jane", LastName = "Doe", Username = "******", Email = "*****@*****.**", PasswordHash = PasswordHasher.Generate("jndoe"), Tasks = new List <TaskDocument>(new[] { new TaskDocument { Id = ObjectId.GenerateNewId(), Name = "Jane's task 1", Description = "some description", Done = false }, new TaskDocument { Id = ObjectId.GenerateNewId(), Name = "Jane's task 2", Description = "some more description", Done = true } }) }); count = userCollection.Count(new BsonDocument()); Console.WriteLine($">>>>> {count} documents created in collection"); }