public void GetAllCustomerFromDb() { // Arange var userService = new UsersService(db); var firstCustomer = new CustomerUser { Id = "0", FullName = "BHTC" }; var secondCustomer = new CustomerUser { Id = "1", FullName = "FischerTech" }; var thirdCustomer = new CustomerUser { Id = "2", FullName = "InnoTape" }; db.CustomerUser.AddRange(firstCustomer, secondCustomer, thirdCustomer); db.SaveChanges(); // Act var result = userService.AllCustomer(); // Assert var expectedCount = 3; Assert.Equal(expectedCount, result.Count()); }
public void UploadFileAsync(IFormFile file) { var files = new Files { ContentType = file.ContentType, FileName = file.FileName }; using (var stream = new MemoryStream()) { file.CopyToAsync(stream); files.FileBytes = stream.ToArray(); byte[] buffer = new byte[4096]; var dd = stream.ReadAsync(buffer, 0, 4096); var st = new StreamReader(stream); stream.Close(); } db.Files.Add(files); db.SaveChanges(); }
public void Create(string ReportText, string orderId) { var a = this.db.Report.Where(o => o.OrderId == orderId).ToList(); db.Report.RemoveRange(a); this.db.Add(new Report { ReportText = ReportText, OrderId = orderId }); db.SaveChanges(); }
public void Create(string name, int CountToFinishOrder, string OderNumber, string customerUser) { var customerId = this.db.CustomerUser.Where(n => n.FullName == customerUser).Select(x => x.Id).FirstOrDefault(); var order = new Order { Name = name, CountToFinishOrder = CountToFinishOrder, Status = false, OrderNumber = OderNumber, StartOrder = DateTime.UtcNow, CustomerUserId = customerId }; this.db.Order.Add(order); db.SaveChanges(); }
public void OrderById() { //Arange var orderService = new OrdersService(db); var customerUser = new CustomerUser { Id = "1", FullName = "BHTC" }; var firstOrder = new Order { Id = "0", Name = "firstOrder", CustomerUserId = customerUser.Id, CustomerUser = customerUser }; var secondOrder = new Order { Id = "1", Name = "secondOrder" }; var thirdOrder = new Order { Id = "2", Name = "thirdOrder" }; db.CustomerUser.Add(customerUser); db.Order.AddRange(firstOrder, secondOrder, thirdOrder); db.SaveChanges(); //Act var resultCount = orderService.OrderById("1").Count(); var firstResult = orderService.OrderById("1").First(); //Assert var expected = new CustomerOrderModel { Name = "firstOrder", OrderId = "0", CustomerUserId = "1" }; var expectedResultCount = 1; Assert.Equal(expectedResultCount, resultCount); Assert.Equal(expected.Name, firstResult.Name); Assert.Equal(expected.OrderId, firstResult.OrderId); Assert.Equal(expected.CustomerUserId, firstResult.CustomerUserId); }
public void CheckIfThereIsAorderInTheReports() { //Arange var reportService = new ReportsService(db); var firstOrder = new Order { Id = "1", Name = "Test1" }; var secondOrder = new Order { Id = "2", Name = "Test2" }; var thirdOrder = new Order { Id = "3", Name = "Test3" }; var firstReport = new Report { Id = "1", OrderId = firstOrder.Id, Order = firstOrder }; var secondReport = new Report { Id = "2", OrderId = secondOrder.Id, Order = secondOrder }; var thirdReport = new Report { Id = "3", OrderId = thirdOrder.Id, Order = thirdOrder }; db.Order.AddRange(firstOrder, secondOrder, thirdOrder); db.Report.AddRange(firstReport, secondReport, thirdReport); db.SaveChanges(); //Act var positiveResult = reportService.CheckForOrderId("1"); var negativeResult = reportService.CheckForOrderId("11"); //Assert var expectedPositive = true; var expectedNegative = false; Assert.Equal(expectedPositive, positiveResult); Assert.Equal(expectedNegative, negativeResult); }