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); }
public GetDocumentByIdQueryHandler( DocumentDbContext dbContext, ICustomEntityDefinitionRepository customEntityDefinitionRepository) { DbContext = dbContext; CustomEntityDefinitionRepository = customEntityDefinitionRepository; }
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); }
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); }
public void Update(AssetMetadata metadata) { using (var context = new DocumentDbContext()) { context.OpenDatabase(_databaseName); context.UpdateDocument(metadata.Id, metadata, _collectioName); } }
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; }
private async static Task DeleteCollections(DocumentDbContext docdbCtx) { foreach (var cname in docdbCtx.CollectionNames) { Console.WriteLine("Deleting collection " + cname); await docdbCtx.DeleteCollectionAsync(cname); } }
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(); } }
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)); } }
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); } }
/// <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()); }
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")); }
public MainViewModel() { // Документы dc = new DocumentDbContext(); TemplateCollection = new ObservableCollection<Template>(dc.Templates); ProductCollection = new ObservableCollection<Product>(dc.Products); // Победители wc = new WinnersDbContext(); }
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); }
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()); } }
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")); }
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")); }
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")); }
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"); }
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()); }
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); }
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) { }
private async static Task CreateNeededCollections(DocumentDbContext docdbCtx) { Console.WriteLine("Recreating collections"); await docdbCtx.CreateAllNeededCollectionsAsync(); }
public DriverStatisticsQuery(DocumentDbContext ctx) : base(ctx) { GetGlobalStatisticsAlso = true; }