public void AddCategory_ReturnCreatedItem_WhenModelStateIsValid()
        {
            //Arrange
            var dbContext = new DocumentDbContext();

            dbContext.Categories = GetQueryableMockDbSetCategory();

            var categoryRepo = new CategoryRepo(string.Empty, dbContext);
            var controller   = new CategoryController(categoryRepo);

            AddCategoryModel addCategoryModel = new AddCategoryModel()
            {
                Title = "Tình Cảm"
            };

            //Act
            var result = controller.AddCategory(addCategoryModel);

            //Assert
            Assert.IsType <OkObjectResult>(result);

            var okObjectResult = result as OkObjectResult;

            Assert.IsType <Category>(okObjectResult.Value);

            var categoryObject = okObjectResult.Value as Category;

            Assert.Equal(categoryObject.Title, addCategoryModel.Title);
        }
Example #2
0
 public GetDocumentByIdQueryHandler(
     DocumentDbContext dbContext,
     ICustomEntityDefinitionRepository customEntityDefinitionRepository)
 {
     DbContext = dbContext;
     CustomEntityDefinitionRepository = customEntityDefinitionRepository;
 }
Example #3
0
        public void AddDocument_ReturnCreateItem_WhenModelModelValid()
        {
            //Arrange
            var dbContext = new DocumentDbContext();

            dbContext.Categories = GetQueryableMockDbSetCategory();
            dbContext.Documents  = GetQueryableMockDbSetDocument();

            var categoryRepo = new CategoryRepo(string.Empty, dbContext);
            var documentRepo = new DocumentRepo(string.Empty, dbContext);
            var controller   = new DocumentController(categoryRepo, documentRepo);

            AddDocumentModel addDocumentModel = new AddDocumentModel {
                Title = "Đời sống con người", Description = "Nói về đời sống con người", CategoryId = 1, Cover = "", PublishYear = 2013
            };
            //Act
            var result = controller.AddDocument(addDocumentModel);

            //Assert
            Assert.IsType <OkObjectResult>(result);

            var okObjectResult = result as OkObjectResult;

            Assert.IsType <Document>(okObjectResult.Value);

            var model = okObjectResult.Value as Document;

            Assert.Equal(model.Title, addDocumentModel.Title);
            Assert.Equal(model.Description, addDocumentModel.Description);
            Assert.Equal(model.CategoryId, addDocumentModel.CategoryId);
            Assert.Equal(model.Cover, addDocumentModel.Cover);
            Assert.Equal(model.PublishYear, addDocumentModel.PublishYear);
        }
Example #4
0
        private List <UserBoxVM> GetListOfDoccumentToAccept()
        {
            List <UserBoxVM> listDocToAccep = new List <UserBoxVM>();
            UserAccount      tempAcceptUser;
            User             acceptUser;
            List <Models.DocumentData.Document> listaTemp = new List <Models.DocumentData.Document>();
            var user = (string)Session["UserName"];

            using (var db = new DocumentDbContext())
            {
                using (var db1 = new AccountDbContext())
                {
                    tempAcceptUser = db1.userAccount.Where(x => x.UserName == user).First();
                    acceptUser     = db.Users.Where(x => x.LastName == tempAcceptUser.LastName).First();

                    foreach (var item in db.Documents.Where(x => x.DateOfAcceptance == null && x.Status.StatusId == 1).ToList())
                    {
                        UserBoxVM temp = new UserBoxVM();
                        temp.DocumentId   = item.DocumentId;
                        temp.DateOfAccept = item.DateOfAcceptance;
                        temp.FileToCheck  = item.DocumentFile;
                        temp.Status       = item.Status.Description;
                        temp.Index        = item.Index;
                        listDocToAccep.Add(temp);
                    }
                }
            }
            return(listDocToAccep);
        }
 public AddDocumentCommandHandler(
     DocumentDbContext dbContext,
     ITransactionScopeManager transactionScopeFactory)
 {
     DbContext = dbContext;
     TransactionScopeFactory = transactionScopeFactory;
 }
        // GET: Manage
        public ActionResult Index()
        {
            List<DocumentAndTypeVM> ListDocToShow = new List<DocumentAndTypeVM>();
            using (var db = new DocumentDbContext())
            {
                foreach (var item in db.Documents.ToList())
                {
                  
                    DocumentAndTypeVM temp = new DocumentAndTypeVM();
                    temp.Title = item.Title;
                    temp.Version = item.Version;
                    temp.DocumentFile = item.DocumentFile;
                    temp.DocumentFileExcel = item.DocumentFileExcel;
                    temp.DocumentId = item.DocumentId;
                    temp.Index = item.Index;
                    temp.DescriptionOp = db.Operations.Where(x => x.OperationId == item.OperationId).First().Description;
                    temp.OperationNumber = db.Operations.Where(x => x.OperationId == item.OperationId).First().OperationNumber;
                    temp.DocumentTypeDescription = db.DocumentTypes.Where(x => x.DocumentTypeId == item.DocumentTypeId).First().Description;
                    temp.LineName = db.Lines.Where(x => x.LineId == item.LineId).First().LineName;
                    ListDocToShow.Add(temp);
                }
                ViewData["Lines"] = new SelectList(ListDocToShow,"LineName","LineName");
                    
                ViewData["Operation"] = new SelectList(ListDocToShow, "OperationNumber");
                ViewData["DocumentVariant"] = new SelectList(ListDocToShow, "DocumentTypeDescription");

            }
            return View(ListDocToShow);
        }
        public void UpdateCategory_ReturnUpdateItem_WhenStateIsValidAndCategoryExist()
        {
            //Arrange
            var dbContext = new DocumentDbContext();

            dbContext.Categories = GetQueryableMockDbSetCategory();

            var categoryRepo = new CategoryRepo(string.Empty, dbContext);
            var controller   = new CategoryController(categoryRepo);

            UpdateCategoryModel updateCategoryModel = new UpdateCategoryModel()
            {
                Id    = 1,
                Title = "Khoa Học"
            };

            //Act
            var result = controller.UpdateCategory(updateCategoryModel);

            //Assert
            Assert.IsType <OkObjectResult>(result);

            var okObjectResult = result as OkObjectResult;

            Assert.IsType <Category>(okObjectResult.Value);

            var categoryObject = okObjectResult.Value as Category;

            Assert.Equal(categoryObject.Id, updateCategoryModel.Id);
            Assert.Equal(categoryObject.Title, updateCategoryModel.Title);
        }
        public void RemoveCategory_ReturnRemovedItem_WhenCategoryExist()
        {
            //Arrange
            var dbContext = new DocumentDbContext();

            dbContext.Categories = GetQueryableMockDbSetCategory();

            var categoryRepo = new CategoryRepo(string.Empty, dbContext);
            var controller   = new CategoryController(categoryRepo);

            int testCategoryId = 1;

            //Act
            var result = controller.RemoveCategory(testCategoryId);

            //Assert
            Assert.IsType <OkObjectResult>(result);

            var okObjectResult = result as OkObjectResult;

            Assert.IsType <Category>(okObjectResult.Value);

            var categoryObject = okObjectResult.Value as Category;

            Assert.Equal(categoryObject.Id, testCategoryId);
        }
        public ActionResult ShowDoc(string idDoc)
        {
            Document doc = new Document();
            List<AcceptedUser> listOfAccept = new List<AcceptedUser>();
            using (var db = new DocumentDbContext())
            {
                bool exist = db.Documents.ToList().Any(x => x.Index == idDoc);
                if(exist==false)
                {
                    return  View("DocumentDoesntExist");
                }

                doc = GetNewOne(db, idDoc);
                foreach (var item in db.UserAccept.ToList())
                {
                    AcceptedUser temp = new AcceptedUser();
                    temp.AcceptedUserId = item.AcceptedUserId;
                    temp.DoccumentAccepted = item.DoccumentAccepted;
                    temp.User = item.User;
                    listOfAccept.Add(temp);
                }
                ViewData["Lines"] = new SelectList(db.Lines.ToList(), "LineId", "LineName");
                ViewData["User"] = new SelectList(db.Users.ToList(), "UserId", "UserName");
                ViewData["Operation"] = new SelectList(db.Operations.ToList(), "OperationId", "OperationNumber");
                ViewData["DocumentVariant"] = new SelectList(db.DocumentTypes.ToList(), "DocumentTypeId", "Description");
            }
            ViewData["AcceptUser"] = new SelectList(listOfAccept, "AcceptedUserId", "User.Email");

            return View(doc); 
        }
        private async static Task AddRidesToSummary(DocumentDbContext docdbCtx, IEnumerable <TrackedRideDocument> rides)
        {
            var summaryCollection = await docdbCtx.GetCollectionAsync(DocumentDbContext.CollectionVehiclesSummary);

            var summary  = await new VehicleSummaryQuery(docdbCtx).ExecuteAsync();
            var vehicles = new List <string>(summary.Vehicles);

            foreach (var ride in rides)
            {
                if (!vehicles.Contains(ride.Device))
                {
                    vehicles.Add(ride.Device);
                }


                var rideSpeed = ride.GpsAverageSpeed;
                summary.AverageSpeed  = ((summary.AverageSpeed * summary.TotalMiles) + (rideSpeed * ride.Miles)) / (summary.TotalMiles + ride.Miles);
                summary.TotalMiles   += ride.Miles;
                summary.TotalSeconds += (ride.EndTime - ride.StartTime).TotalSeconds;
                summary.Breakdowns   += ride.Breakdowns;
            }
            summary.Vehicles      = vehicles.ToArray();
            summary.VehiclesCount = vehicles.Count;
            await docdbCtx.UpdateDocumentAsync(summary, summaryCollection);
        }
Example #11
0
 public void Update(AssetMetadata metadata)
 {
     using (var context = new DocumentDbContext())
     {
         context.OpenDatabase(_databaseName);
         context.UpdateDocument(metadata.Id, metadata, _collectioName);
     }
 }
Example #12
0
 public DocumentDbQueryProvider(DocumentDbMetadata dbMetadata, string connectionString, string collectionName, Type collectionType)
 {
     this.dbContext        = new DocumentDbContext(connectionString);
     this.dbMetadata       = dbMetadata;
     this.connectionString = connectionString;
     this.collectionName   = collectionName;
     this.collectionType   = collectionType;
 }
Example #13
0
 private async static Task DeleteCollections(DocumentDbContext docdbCtx)
 {
     foreach (var cname in docdbCtx.CollectionNames)
     {
         Console.WriteLine("Deleting collection " + cname);
         await docdbCtx.DeleteCollectionAsync(cname);
     }
 }
 private async static Task DeleteCollections(DocumentDbContext docdbCtx)
 {
     foreach (var cname in docdbCtx.CollectionNames)
     {
         Console.WriteLine("Deleting collection " + cname);
         await docdbCtx.DeleteCollectionAsync(cname);
     }
 }
Example #15
0
 public DocumentRepo(
     string connectionString,
     DocumentDbContext context
     )
 {
     _connectionString = connectionString;
     _context          = context;
 }
 public static void EnsureSeeded(this DocumentDbContext context)
 {
     if (!context.DocumentsTypes.Any())
     {
         var types = JsonConvert.DeserializeObject <List <DocumentType> >(File.ReadAllText("Seeds" + Path.DirectorySeparatorChar + "DocumentTypes.json"));
         context.AddRange(types);
         context.SaveChanges();
     }
 }
Example #17
0
        public ActionResult AddComment(int docId)
        {
            using (var db = new DocumentDbContext())
            {
                Models.DocumentData.Document document = db.Documents.Where(x => x.DocumentId == docId).First();

                return(View(document));
            }
        }
Example #18
0
 public ActionResult AddComments(string doc, int id)
 {
     using (var db = new DocumentDbContext())
     {
         db.Documents.Where(x => x.DocumentId == id).First().Comments = doc;
         db.SaveChanges();
     }
     return(RedirectToAction("Index"));
 }
        private void UpdateMetadataFromResourceSet(DocumentDbContext dbContext, ResourceSet resourceSet, JToken document)
        {
            var resourceType = dbMetadata.ResolveResourceType(resourceSet.Name);

            foreach (var element in document)
            {
                dbMetadata.RegisterResourceProperty(dbContext, resourceType, element as JProperty);
            }
        }
Example #20
0
        /// <summary>
        /// Initializes the document client.
        /// </summary>
        /// <returns>Task that denotes opening client</returns>
        private Task InitializeDocumentClientAsync()
        {
            if (this.client == null)
            {
                var documentDbContext = new DocumentDbContext();
                this.client = documentDbContext.GetDocumentClient(this.connectionString, this.retryCount, this.retryInterval);
            }

            return(this.client.OpenAsync());
        }
Example #21
0
 public ActionResult CancelDocument(int docId)
 {
     //9 wycofana z obiegu
     using (var db = new DocumentDbContext())
     {
         db.Documents.Where(x => x.DocumentId == docId).First().Status = db.Status.Where(c => c.StatusId == 9).First();
         db.SaveChanges();
     }
     return(RedirectToAction("Index"));
 }
Example #22
0
        public MainViewModel()
        {
            // Документы
            dc = new DocumentDbContext();
            TemplateCollection = new ObservableCollection<Template>(dc.Templates);
            ProductCollection = new ObservableCollection<Product>(dc.Products);

            // Победители
            wc = new WinnersDbContext();
        }
Example #23
0
        public DataSourceRepository(
            DocumentDbContext dbContext,
            CloudBlobClient cloudBlobClient,
            string dataSourceContainerPath)
        {
            _dbContext       = dbContext;
            _cloudBlobClient = cloudBlobClient;

            _dataSourceContainerPath = dataSourceContainerPath;
        }
        public override DSPInMemoryContext CreateContext(string connectionString)
        {
            var dspContext = new DSPInMemoryContext();

            using (DocumentDbContext dbContext = new DocumentDbContext(connectionString))
            {
                PopulateData(dspContext, dbContext);
            }

            return(dspContext);
        }
Example #25
0
        public AssetMetadata Get(string id)
        {
            using (var context = new DocumentDbContext())
            {
                context.OpenDatabase(_databaseName);
                var query = context.CreateDocumentQuery <AssetMetadata>(_collectioName)
                            .Where(asset => asset.Id == id);

                return(query.AsEnumerable().FirstOrDefault());
            }
        }
Example #26
0
 public ActionResult CancelPutToArchive(int docId)
 {
     //Powrot do status id=4
     using (var db = new DocumentDbContext())
     {
         db.Documents.Where(x => x.DocumentId == docId).First().Status       = db.Status.Where(c => c.StatusId == 4).First();
         db.Documents.Where(x => x.DocumentId == docId).First().DateOfDelete = null;
         db.SaveChanges();
     }
     return(RedirectToAction("Index"));
 }
Example #27
0
 public ActionResult SayNo(int docId)
 {
     //3 status odrzucona w bazie danych
     using (var db = new DocumentDbContext())
     {
         db.Documents.Where(x => x.DocumentId == docId).First().Status           = db.Status.Where(c => c.StatusId == 3).First();
         db.Documents.Where(x => x.DocumentId == docId).First().DateOfAcceptance = DateTime.Today;
         db.SaveChanges();
     }
     return(RedirectToAction("Index"));
 }
Example #28
0
 public ActionResult PutToArchive(int docId)
 {
     //5 archiwum
     using (var db = new DocumentDbContext())
     {
         db.Documents.Where(x => x.DocumentId == docId).First().Status       = db.Status.Where(c => c.StatusId == 5).First();
         db.Documents.Where(x => x.DocumentId == docId).First().DateOfDelete = DateTime.Today;
         db.SaveChanges();
     }
     return(RedirectToAction("Index"));
 }
Example #29
0
        private static void Create()
        {
            using (var dbContext = new DocumentDbContext())
            {
                dbContext.OpenDatabase(_databaseName);
                Console.WriteLine("Recreating db collection");
                dbContext.CreateCollection(_collectionName);
            }

            Console.WriteLine("Recreating blob storage");
            _blobStorage.GetBlobContainer(_containerName);
        }
 public ActionResult Delete(int UserId, int id)
 {
     //przypisanie osoby odpowiedzialnej za zaakceptowanie usuniecia
     //7 status oczekuje na akceptacje do usuniecia
     using (var db = new DocumentDbContext())
     {
         db.Documents.Where(x => x.DocumentId == id).First().DeleteUser = db.DeleteAuthor.Where(z => z.DeleteUserId == UserId).First();
         db.Documents.Where(x => x.DocumentId == id).First().StatusId = 7;
         db.SaveChanges();
     }
     return RedirectToAction("DeleteDocument");
 }
Example #31
0
 public ActionResult RegisterDocument()
 {
     using (var db = new DocumentDbContext())
     {
         ViewData["Lines"]           = new SelectList(db.Lines.ToList(), "LineId", "LineName");
         ViewData["User"]            = new SelectList(db.Users.ToList(), "UserId", "UserName");
         ViewData["Operation"]       = new SelectList(db.Operations.ToList(), "OperationId", "OperationNumber");
         ViewData["DocumentVariant"] = new SelectList(db.DocumentTypes.ToList(), "DocumentTypeId", "Description");
         var authorSelect = from us in db.UserAccept
                            join su in db.Users on us.AcceptedUserId equals su.AcceptUser.AcceptedUserId
                            select us;
         ViewData["AcceptedUser"] = new SelectList(authorSelect.ToList(), "AcceptedUserId", "User.Email");
     }
     return(View());
 }
Example #32
0
        private List <UserBoxVM> GetList(int status, User interested)
        {
            var              user = (string)Session["UserName"];
            UserAccount      tempAcceptUser;
            User             acceptUser;
            AuthorUser       authorUser;
            User             deleteUser;
            List <UserBoxVM> tempList = new List <UserBoxVM>();

            using (var db = new DocumentDbContext())
            {
                using (var db1 = new AccountDbContext())
                {
                    tempAcceptUser = db1.userAccount.Where(x => x.UserName == user).First();
                    acceptUser     = db.Users.Where(x => x.LastName == tempAcceptUser.LastName).First();
                    deleteUser     = db.Users.Where(x => x.LastName == tempAcceptUser.LastName).First();
                }
                if (status == 2)
                {
                    authorUser = db.UserAuthor.Where(x => x.User.UserId == acceptUser.UserId).First();
                    foreach (var item in db.Documents.Where(x => x.Status.StatusId == 2 &&
                                                            x.AuthorUserId == authorUser.AuthorUserId).ToList())
                    {
                        UserBoxVM temp = new UserBoxVM();
                        temp.DocumentId   = item.DocumentId;
                        temp.DateOfAccept = item.DateOfAcceptance;
                        temp.FileToCheck  = item.DocumentFile;
                        temp.Status       = item.Status.Description;
                        temp.Index        = item.Index;
                        tempList.Add(temp);
                    }
                }
                if (status == 7)
                {
                    foreach (var item in db.Documents.Where(x => x.StatusId == 7 && x.DeleteUserId == deleteUser.UserId).ToList())
                    {
                        UserBoxVM temp = new UserBoxVM();
                        temp.DocumentId   = item.DocumentId;
                        temp.DateOfAccept = item.DateOfAcceptance;
                        temp.FileToCheck  = item.DocumentFile;
                        temp.Status       = item.Status.Description;
                        temp.Index        = item.Index;
                        tempList.Add(temp);
                    }
                }
            }
            return(tempList);
        }
Example #33
0
        private async static Task AddRidesToSummary(DocumentDbContext docdbCtx, IEnumerable<TrackedRideDocument> rides)
        {
            var summaryCollection = await docdbCtx.GetCollectionAsync(DocumentDbContext.CollectionVehiclesSummary);
            var summary = await new VehicleSummaryQuery(docdbCtx).ExecuteAsync();
            var vehicles = new List<string>(summary.Vehicles);
            foreach (var ride in rides)
            {
                if (!vehicles.Contains(ride.Device))
                {
                    vehicles.Add(ride.Device);
                }


                var rideSpeed = ride.GpsAverageSpeed;
                summary.AverageSpeed = ((summary.AverageSpeed * summary.TotalMiles) + (rideSpeed * ride.Miles)) / (summary.TotalMiles + ride.Miles);
                summary.TotalMiles += ride.Miles;
                summary.TotalSeconds += (ride.EndTime - ride.StartTime).TotalSeconds;
                summary.Breakdowns += ride.Breakdowns;
            }
            summary.Vehicles = vehicles.ToArray();
            summary.VehiclesCount = vehicles.Count;
            await docdbCtx.UpdateDocumentAsync(summary, summaryCollection);
        }
 public TopRatedDriversQuery(DocumentDbContext ctx) : base(ctx)
 {
     Threshold = new TimeSpan(366, 0, 0, 0);
     DesiredDrivers = 10;
 }
 public TrackedRidesDocumentsFactory(DocumentDbContext ctx)
 {
     _ctx = ctx;
 }
 public DrivingStyleDocumentsFactory(DocumentDbContext ctx)
 {
     _ctx = ctx;
 }
 public TrackedRidesFiller()
 {
     _docCtx = DocumentDbContextFactory.New();
     _routesGps = new Dictionary<string, GpsPoint[]>();
 }
 public DriverStylesQuery(DocumentDbContext ctx) : base(ctx)
 {
 }
 public VehicleSummaryQuery(DocumentDbContext ctx) : base(ctx)
 {
 }
Example #40
0
 private async static Task CreateNeededCollections(DocumentDbContext docdbCtx)
 {
     Console.WriteLine("Recreating collections");
     await docdbCtx.CreateAllNeededCollectionsAsync();
 }
 public DriverStatisticsQuery(DocumentDbContext ctx) : base(ctx)
 {
     GetGlobalStatisticsAlso = true;
 }