public void TestJobDetail() { using (var db = new PurchaseSQLDBContext(Utilites.TestDbContextOptions())) { var n = db.Job.Where(c => c.job_id == 1265).Select(p => new JobDetailsDto { JobID = p.job_id, JobName = p.jobname, JobCostName = p.jobdesc, JobOrdersTotal = p.PurchaseOrders.Count > 0 ? p.PurchaseOrders.Sum(w => w.OrderTotal).Value : 0.0m, JobOrders = db.PurchaseOrder.Where(d => d.Job_id == 1265).Select(s => new OrderDto { PurchaseOrderID = s.OrderNum, OrderDate = s.OrderDate.ToShortDateString(), Purchaser = s.Employee.lastname, Supplier = s.Supplier.SupplierName, OrderTotal = s.OrderTotal.Value.ToString(), Received = s.Recieved.Value }).ToList() }).SingleOrDefault(); Assert.True(n.JobID == 1265); ; } }
public void TestTransactionTypesFind() { using (var db = new PurchaseSQLDBContext(Utilites.TestDbContextOptions())) { var result = db.TransActionType.Find(1); Assert.True(result.TransactionsTypeID == 1); } }
public void TestTransactionTypes() { using (var db = new PurchaseSQLDBContext(Utilites.TestDbContextOptions())) { var result = db.TransActionType.ToList(); Assert.True(result.Count > 0); } }
public List <PurchaseOrder> GetAll() { List <PurchaseOrder> result = new List <PurchaseOrder>(); using (var context = new PurchaseSQLDBContext()) { result = context.PurchaseOrder.AsNoTracking().ToList(); } return(result); }
public void TestMethod1() { List <PurchaseOrder> result = new List <PurchaseOrder>(); using (var context = new PurchaseSQLDBContext()) { PurchaseOrderService service = new PurchaseOrderService(); result = service.GetAll(); } Assert.IsTrue(result.Count > 200); }
public async Task TestInventoryGetTransActions() { var result = new List <InventoryDto>(); using (var db = new PurchaseSQLDBContext(Utilites.TestDbContextOptions())) { var _service = new InventoryService(db); result = await _service.GetTransActions(3613); } Assert.True(result.Count() == 6); }
public async Task TestInventoryGetStockLevel() { decimal result; using (var db = new PurchaseSQLDBContext(Utilites.TestDbContextOptions())) { var _service = new InventoryService(db); result = await _service.GetStockLevel(3354); } Assert.True(result == 0.0m); }
public void ViewModelTest() { List <PurchaseOrder> result = new List <PurchaseOrder>(); using (var context = new PurchaseSQLDBContext()) { PurchaseOrderService service = new PurchaseOrderService(); MainViewModel view = new MainViewModel(service); view.Load(); } Assert.IsTrue(result.Count > 200); }
public async Task TestInventoryPushPart() { decimal result; decimal after; using (var db = new PurchaseSQLDBContext(Utilites.TestDbContextOptions())) { var _service = new InventoryService(db); result = await _service.GetStockLevel(3354); _service.PushPart(3354, 10.0m); after = await _service.GetStockLevel(3354); } Assert.True(after == result + 10.0m); }
public void TestProjectsMappingEmployees() { using (var db = new PurchaseSQLDBContext(Utilites.TestDbContextOptions())) { //var part = db.Part.Include(d => d.PartsLink).Where(c => c.PartID == 5717).SingleOrDefault(); var r = db.Part.Include(d => d.PartsLink).Where(c => c.PartID == 5720).Select(p => new PartEditDto { PartID = p.PartID, Description = p.ItemDescription, SupplierDescription = p.SupplierDescription, ItemName = p.ItemName, PartNumber = p.PartNum, SupplierID = p.SupplierID.Value, Location = p.Location, SupplierName = p.Supplier.SupplierName, Manufacturer = db.Manu.Where(f => f.ManuID == p.ManuID).Select(d => d.Manufacturer).FirstOrDefault().ToString(), DateAdded = p.DateAdded.HasValue ? p.DateAdded.Value : DateTime.Today, LastModified = p.ModifiedDate.HasValue ? p.ModifiedDate.Value : DateTime.Today, ManuID = p.ManuID.HasValue ? p.ManuID.Value : 0, ManuPartNum = p.ManuPartNum, //PartTypeID = p.PartTypeID.HasValue ? p.PartTypeID.Value : 0, ModifiedBy = p.ModifiedBy, Cost = p.Cost.Value, UID = p.UID.HasValue ? p.UID.Value : 0, UnitOfMeasure = db.UnitOfMeasure.Where(o => o.UID == p.UID).Select(e => e.UOM).SingleOrDefault().ToString(), Weight = p.Weight.Value, Waste = p.Waste.Value, MarkUp = p.MarkUp.Value, SKU = p.SKU, UseSupplierName = p.UseSupplierNameFlag, Documents = p.PartsLink.Select(f => new PartDocumentsDto { DocID = f.Documents.DocID, Description = f.Documents.Description, DocumentView = f.Documents.DocumentView, Path = f.Documents.DocumentPath }).ToList() }).SingleOrDefault(); var text = r; Assert.True(r.PartID == 5720); } }
public SupplierListModel(PurchaseSQLDBContext context) { _context = context; }
public indexModel(PurchaseSQLDBContext context) { _context = context; }
public editModel(PurchaseSQLDBContext context) { _context = context; }
public OrderDetailModel(PurchaseSQLDBContext context) { _context = context; }
public JobService(PurchaseSQLDBContext context) { _db = context; }
public JobOrdersModel(PurchaseSQLDBContext context) { _context = context; }
public JobDetailModel(PurchaseSQLDBContext context, QQestContext timeContext) { _context = context; _timeContext = timeContext; }
public InventoryListModel(PurchaseSQLDBContext context) { _context = context; }
public EmployeeListModel(PurchaseSQLDBContext context) { _context = context; }
public InventoryService(PurchaseSQLDBContext db) { _db = db; }
public SuppliersList(PurchaseSQLDBContext context) { _db = context; }
public SupplierOrdersModel(PurchaseSQLDBContext context) { _context = context; }