public void ShowPartsByLocationCode(PartRepository partRepository, string locationCode)
{
int partCount = 0;
Console.WriteLine($"Parts in stock({partRepository.Retrieve().Count}):");
foreach (var part in partRepository.Retrieve())
{
if (locationCode == part.Location.Code)
{
Console.WriteLine($"Part Id: {part.Id}" +
$", Code: {part.Code}" +
$", Brand: {part.Brand}" +
$", Model: {part.Model}" +
$", Description: {part.Description}" +
$", Location: {part.Location.Code} {part.Location.Description}");
partCount++;
}
}
if (partCount == 0)
{
Console.WriteLine($"Location {locationCode} is empty!");
}
Console.WriteLine();
}
public static List <Part> GetPartsWithoutSpoilages()
{
var paRep = new PartRepository();
var parts = paRep.All().ToList();
return(parts.Where(p => p.Spoilages.Count < 1).ToList());
}
private void PartRmv_Click(object sender, EventArgs e)
{
int index = partsDataGridView.SelectedCells.Count > 0 ? partsDataGridView.SelectedCells[0].RowIndex : -1;
index = index != -1 ? Int32.Parse(partsDataGridView.Rows[index].Cells[0].Value.ToString()) : 0;
if (index == 0)
{
MessageBox.Show("Please select row!", "No record selected?", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
DialogResult result = MessageBox.Show("Сигурни ли сте, че искате да изтриете записа?", "Изтриване?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
if (PartRepository.IsUsed(index))
{
MessageBox.Show("Частта се използва в карта!", "Използвана част!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
PartRepository.Remove(PartRepository.Get(index));
this.getRecords();
}
}
}
static void Main(string[] args)
{
InfoDisplay infoDisplay = new InfoDisplay();
OrderController orderController = new OrderController();
PartRepository partRepository = new PartRepository();
List <Part> parts = partRepository.Retrieve();
ReportGenerator reportGenerator = new ReportGenerator(orderController);
orderController.CreateNewOrder(1, "UAB EAMV");
orderController.CreateNewOrder(2, "UAB Rasmitas");
orderController.CreateNewOrder(3, "UAB TRT Shop");
infoDisplay.ShowPartsInStock(partRepository);
orderController.AddPart(1, parts[1]);
orderController.AddPart(1, parts[2]);
orderController.AddPart(2, parts[3]);
orderController.AddPart(2, parts[4]);
orderController.AddPart(3, parts[5]);
orderController.AddPart(3, parts[0]);
infoDisplay.ShowAvailablePartsInStock(orderController, partRepository);
orderController.CloseOrder(3, partRepository);
infoDisplay.ShowAllOrders(reportGenerator);
infoDisplay.ShowPartsInStock(partRepository);
Console.ReadLine();
}
public static List <CustomerShippingInfo> GetShippingInfo(int id)
{
ISqlHelper sqlHelper = new SqlHelper();
PriviledgeRepository priviledgeRepository = new PriviledgeRepository(sqlHelper);
IUserRepository userRepository = new UserRepository(priviledgeRepository);
IEntityTrackerRepository entityTrackerRepository = new EntityTrackerRepository(sqlHelper);
IOrderRepository oRepository = new OrderRepository(sqlHelper, userRepository, entityTrackerRepository);
ICompanyRepository companyRepository = new CompanyRepository(sqlHelper);
IPartRepository partRepository = new PartRepository(sqlHelper, userRepository, companyRepository);
ICustomerRepository customerRepository = new CustomerRepository(sqlHelper, userRepository);
ITransactionRepository transactionRepository = new TransactionRepository();
IPoRepository poRepository = new PoRepository(sqlHelper, entityTrackerRepository, userRepository);
IUserActivityReportRepository userActivityRepository = new UserActivityReportRepository(sqlHelper);
ISupplierInvoiceRepository supplierInvoiceRepository = new SupplierInvoiceRepository(sqlHelper, poRepository, transactionRepository, userRepository);
IPackingSlipRepository pRepository = new PackingSlipRepository(sqlHelper, oRepository, partRepository, entityTrackerRepository, customerRepository, userRepository, supplierInvoiceRepository, userActivityRepository);
var result = pRepository.GetPackingSlip(id);
List <CustomerShippingInfo> customerShippingInfos = new List <CustomerShippingInfo>();
customerShippingInfos.Add(result.customerShippingInfo);
//packingSlips.Add(GetPackingSlipAsync(id).Result);
return(customerShippingInfos.ToList());
}
public void TestAddPart()
{
// Arrange
Part part;
Order order;
PartCategory partCategory;
OrderController orderController = new OrderController();
PartRepository partRepository = new PartRepository();
List <Part> parts = partRepository.Retrieve();
orderController.CreateNewOrder(1, "UAB EAMV");
orderController.CreateNewOrder(2, "UAB Rasmitas");
orderController.CreateNewOrder(3, "UAB TRT Shop");
orderController.AddPart(2, parts[1]);
order = orderController.Retrieve(2);
List <Part> orderedPart = order.Parts;
part = orderedPart[0];
partCategory = part.Category;
string expected = "Brakes";
// Act
string actual = partCategory.Decription;
// Assert
Assert.AreEqual(expected, actual);
}
public void TestCloseOrderStatus()
{
// Arrange
Order order;
OrderController orderController = new OrderController();
PartRepository partRepository = new PartRepository();
List <Part> parts = partRepository.Retrieve();
orderController.CreateNewOrder(1, "UAB EAMV");
orderController.CreateNewOrder(2, "UAB Rasmitas");
orderController.CreateNewOrder(3, "UAB TRT Shop");
orderController.AddPart(2, parts[1]);
orderController.AddPart(2, parts[2]);
orderController.CloseOrder(3, partRepository);
order = orderController.Retrieve(3);
string expected = "Closed";
// Act
string actual = order.Status;
// Assert
Assert.AreEqual(expected, actual);
}
public void TestGenerateReportByOrderId()
{
// Arrange
OrderController orderController = new OrderController();
PartRepository partRepository = new PartRepository();
List <Part> parts = partRepository.Retrieve();
ReportGenerator reportGenerator = new ReportGenerator(orderController);
orderController.CreateNewOrder(1, "UAB EAMV");
orderController.CreateNewOrder(2, "UAB Rasmitas");
orderController.CreateNewOrder(3, "UAB TRT Shop");
orderController.AddPart(1, parts[1]);
orderController.AddPart(1, parts[2]);
orderController.AddPart(2, parts[3]);
orderController.AddPart(2, parts[4]);
orderController.AddPart(3, parts[5]);
orderController.AddPart(3, parts[0]);
int expected = 1;
// Act
int actual = reportGenerator.GenerateReport(2).Count;
// Assert
Assert.AreEqual(expected, actual);
}
public void when_getting_all_parts_from_repository()
{
var repository = new PartRepository(_db);
var parts = repository.GetAll(x => true);
_output.WriteLine(parts.ToJson());
}
private void SetUpPartRepository(CoreAngularDemoDBContext context)
{
var partRepository = new PartRepository(context);
_unitOfWork.Setup(u => u.SaveAsync()).Returns(() => context.SaveChangesAsync());
_unitOfWork.Setup(u => u.PartRepository).Returns(() => partRepository);
}
public void TestRemovePart()
{
// Arrange
Order order;
OrderController orderController = new OrderController();
PartRepository partRepository = new PartRepository();
List <Part> parts = partRepository.Retrieve();
orderController.CreateNewOrder(1, "UAB EAMV");
orderController.CreateNewOrder(2, "UAB Rasmitas");
orderController.CreateNewOrder(3, "UAB TRT Shop");
orderController.AddPart(2, parts[1]);
orderController.AddPart(2, parts[2]);
orderController.RemovePart(2, 2);
order = orderController.Retrieve(2);
List <Part> orderedPart = order.Parts;
int expected = 1;
// Act
int actual = orderedPart.Count;
// Assert
Assert.AreEqual(expected, actual);
}
public async Task Part_Repository_Should_Get_All_Async()
{
// Arrange
var context = TestSetUpHelper.CreateDbContext();
var repository = new PartRepository(context);
var expectedEntity = new Part()
{
Id = 4,
Name = "TestName",
Code = "123456",
UnitId = 1,
Unit = new Unit {
Id = 1, Name = "Kilo", ShortName = "kg",
},
ManufacturerId = 1,
Manufacturer = new Manufacturer {
Id = 1, Name = "",
}
};
await repository.AddAsync(expectedEntity);
await context.SaveChangesAsync();
// Act
var entities = await repository.GetAllAsync();
// Assert
Assert.Single(entities.ToList());
}
public PartController(UserManager <Player> UserManager, GameRepository GameRepo, PlayerRepository PlayerRepo, PartRepository PartRepo)
{
userManager = UserManager;
this.gameRepository = GameRepo;
this.playerRepository = PlayerRepo;
this.partRepository = PartRepo;
}
public async Task Part_Repository_Should_Remove_Part_Async()
{
// Arrange
var context = TestSetUpHelper.CreateDbContext();
var repository = new PartRepository(context);
var expectedEntity = new Part()
{
Id = 4,
Name = "TestName",
Code = "123456",
UnitId = 1,
Unit = new Unit {
Id = 1, Name = "Kilo", ShortName = "kg",
},
ManufacturerId = 1,
Manufacturer = new Manufacturer {
Id = 1, Name = "",
}
};
await repository.AddAsync(expectedEntity);
await context.SaveChangesAsync();
// Act
await repository.RemoveAsync(expectedEntity.Id);
await context.SaveChangesAsync();
var actualEntity = await repository.GetByIdAsync(expectedEntity.Id);
// Assert
Assert.Null(actualEntity);
}
public AccountController(UserManager <Player> UserManager, SignInManager <Player> SignInManager, PartRepository PartRepo, IWebHostEnvironment host, IEmailService mailService)
{
this.userManager = UserManager;
this.signInManager = SignInManager;
partRepo = PartRepo;
this.host = host;
this.mailService = mailService;
}
public static Part GetHighestValue()
{
//Static method that returns the Part with the highest current inventory value as a public static method.
var paRep = new PartRepository();
var parts = paRep.All().ToList();
return(parts.OrderByDescending(p => p.CurrentValue).FirstOrDefault());
}
private void LoadLists()
{
m_partModels = PartRepository.GetAllPartModels(UnitOfWork);
m_shopfloorlines = AreaRepository.GetAllShopfloorlines(UnitOfWork);
m_routeStations = Scout.Core.Service <IShopfloorService>()
.GetAllRouteStations(UnitOfWork);
}
public OptionPartController(OptionPartRepository optionPartRepository, IEntityMapper <OptionPart, OptionPartViewModel> entitytoVmMapper, IEntityMapper <OptionPartViewModel, OptionPart> vmToEntityMapper, PartRepository partRepository, IEntityMapper <Part, PartViewModel> parttoVmMapper, IEntityMapper <PartViewModel, Part> vmToPartMapper)
{
this.optionPartRepository = optionPartRepository;
this.entitytoVmMapper = entitytoVmMapper;
this.vmToEntityMapper = vmToEntityMapper;
this.partRepository = partRepository;
this.parttoVmMapper = parttoVmMapper;
this.vmToPartMapper = vmToPartMapper;
}
public void WhenGetAllFromEmptyDatabase_ThenReturnsEmptyCollection()
{
var repository = new PartRepository(new DatabaseFactory());
IEnumerable<Part> actual = repository.GetAll();
Assert.NotNull(actual);
var actualList = new List<Part>(actual);
Assert.Equal(0, actualList.Count);
}
/// <summary>
/// convert containerPart to view model
/// </summary>
/// <param name="containerPart"></param>
/// <returns></returns>
public ContainerPartViewModel ConvertToView(ContainerPart containerPart)
{
ContainerPartViewModel model = new ContainerPartViewModel();
var _containerRepository = new ContainerRepository();
var _partRepository = new PartRepository();
var _dynamicsPartRepository = new PartDynamicsRepository();
var _foundryOrderRepository = new FoundryOrderRepository();
var container = _containerRepository.GetContainer(containerPart.ContainerId);
var foundryOrderPart = _foundryOrderRepository.GetFoundryOrderParts().FirstOrDefault(x => x.FoundryOrderPartId == containerPart.FoundryOrderPartId);
var part = _partRepository.GetPart((foundryOrderPart != null) ? foundryOrderPart.PartId : Guid.Empty);
var dynamicsPart = _dynamicsPartRepository.GetPartMaster(part != null && !string.IsNullOrEmpty(part.Number) ? part.Number : null);
var foundryOrder = _foundryOrderRepository.GetFoundryOrder((foundryOrderPart != null) ? foundryOrderPart.FoundryOrderId : Guid.Empty);
model.FoundryOrderPartId = containerPart.FoundryOrderPartId;
model.ContainerPartId = containerPart.ContainerPartId;
model.ContainerId = containerPart.ContainerId;
model.PartId = (part != null) ? part.PartId : Guid.Empty;
model.ContainerNumber = (container != null) ? container.Number : "N/A";
model.PartNumber = (part != null && !string.IsNullOrEmpty(part.Number)) ? part.Number : "N/A";
model.FoundryOrderId = (foundryOrder != null) ? foundryOrder.FoundryOrderId : Guid.Empty;
model.OrderNumber = (foundryOrder != null && !string.IsNullOrEmpty(foundryOrder.Number)) ? foundryOrder.Number : "N/A";
model.PalletNumber = (!string.IsNullOrEmpty(containerPart.PalletNumber)) ? containerPart.PalletNumber : "N/A";
model.Quantity = containerPart.Quantity;
model.Weight = (dynamicsPart != null) ? (dynamicsPart.ITEMSHWT / 100.00m) : 0.00m;
model.Cost = foundryOrderPart.Cost;
model.Price = foundryOrderPart.Price;
model.AvailableQuantity = (foundryOrderPart != null) ? foundryOrderPart.Quantity : 0;
model.ShipCode = (foundryOrderPart != null && !string.IsNullOrEmpty(foundryOrderPart.ShipCode)) ? foundryOrderPart.ShipCode : "N/A";
if (_containerRepository != null)
{
_containerRepository.Dispose();
_containerRepository = null;
}
if (_partRepository != null)
{
_partRepository.Dispose();
_partRepository = null;
}
if (_dynamicsPartRepository != null)
{
_dynamicsPartRepository.Dispose();
_dynamicsPartRepository = null;
}
if (_foundryOrderRepository != null)
{
_foundryOrderRepository.Dispose();
_foundryOrderRepository = null;
}
return(model);
}
public static Dictionary <int, Part> GetPartDictionary()
{
//Static method that returns the Part with the highest current inventory value as a public static method.
var paRep = new PartRepository();
var parts = paRep.All().ToList();
//return (from part in parts group part by part.PartId into pg select pg).ToDictionary();
return(parts.ToDictionary(p => p.PartId));
}
public UnitOfWork(JPartsContext context)
{
_context = context;
Addresses = new AddressRepository(_context);
Cars = new CarRepository(_context);
Clients = new ClientRepository(_context);
Orders = new OrderRepository(_context);
Parts = new PartRepository(_context);
Shops = new ShopRepository(_context);
}
public void get_part_dto_from_assembler()
{
var repository = new PartRepository(_db);
var assembler = new PartAssembler();
var partCatalogService = new PartCatalogService(repository, assembler);
var partDto = partCatalogService.GetPart("TEST-PART-NUMBER|1");
partDto.Should().BeOfType <PartDTO>();
}
public static async Task DeleteAll()
{
DbContextOptionsBuilder <ManufacturingContext> optionsBuilder = new DbContextOptionsBuilder <ManufacturingContext>();
optionsBuilder.UseSqlServer("server=172.20.4.20;database=manufacturing_inventory_dev;user=aelmendorf;password=Drizzle123!;MultipleActiveResultSets=true");
using var context = new ManufacturingContext(optionsBuilder.Options);
IRepository <PartInstance> instanceRepository = new PartInstanceRepository(context);
IRepository <Part> partRepository = new PartRepository(context);
await partRepository.LoadAsync();
var parts = await context.Parts.Include(e => e.PartInstances).Where(e => e.Id > 1).ToListAsync();
List <int> instanceIds = new List <int>();
foreach (var part in parts)
{
var ids = part.PartInstances.Select(e => e.Id);
instanceIds.AddRange(ids);
}
await instanceRepository.LoadAsync();
Console.WriteLine("Attempting to delete id list, see log below");
foreach (var id in instanceIds)
{
var partInstance = await instanceRepository.GetEntityAsync(e => e.Id == id);
if (partInstance != null)
{
var output = await instanceRepository.DeleteAsync(partInstance);
if (output != null)
{
var count = await context.SaveChangesAsync();
if (count > 0)
{
Console.WriteLine("Successfully Deleted: Id:{0} Name:{1}", partInstance.Id, partInstance.Name);
}
else
{
Console.WriteLine("Error Saving Id:{0} Name:{1}", partInstance.Id, partInstance.Name);
}
}
else
{
Console.WriteLine("Error Deleting: Id:{0} Name:{1}", partInstance.Id, partInstance.Name);
}
}
else
{
Console.WriteLine("Could Not Find: Id:{0} ", id);
}
}
}
public void Save_GivenNewPart_ShouldSave()
{
//---------------Set up test pack-------------------
var car = new PartBuilder().WithNewId().BuildSaved();
var userRepository = new PartRepository();
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
userRepository.Save(car);
//---------------Test Result -----------------------
}
public ViewResult ListParts(string searchline)
{
//var parts = _parts.Partslistsearch(searchline);
List <SearchPart> parts = (List <SearchPart>)_parts.Partslistsearch(searchline);
PartRepository partRepository = new PartRepository();
partRepository.FillList((List <SearchPart>)parts);
return(View(parts));
}
public void TestPartsGetAllMemory()
{
// arrange
var repo = new PartRepository <Memory>(_context, _mapper);
// act
var result = repo.GetAll();
// assert
Assert.Equal(MockData.Memories.Count(), result.Count());
}
public void get_part_catalog_dto_from_assembler()
{
var repository = new PartRepository(_db);
var assembler = new PartAssembler();
var partCatalogService = new PartCatalogService(repository, assembler);
var partCatalogDto = partCatalogService.GetAllParts();
_output.WriteLine(partCatalogDto.ToJson());
partCatalogDto.Should().BeOfType <List <PartDTO> >();
}
public void Calculating_total_cost_of_a_parts_components()
{
var repository = new PartRepository(_db);
var assembler = new PartAssembler();
var service = new PartCatalogService(repository, assembler);
var partDto = service.GetPart("TEST-PART-NUMBER|0");
partDto.Quantity = 50;
_output.WriteLine(partDto.TotalComponentCost.ToString());
}
public async void TestPartRepoForAdd()
{
// arrange
int indexCpu = 5;
var repo = new PartRepository <Cpu>(_context, _mapper);
var expected = MockData.Cpus.Where(c => c.Id == indexCpu).FirstOrDefault();
// act
var result = await repo.Add(expected);
// assert
Assert.Equal(expected.Description, result.Description);
}
/// <summary>
/// convert part to rfq part view model
/// </summary>
/// <param name="part"></param>
/// <returns></returns>
public RfqPartViewModel ConvertToView(Part part)
{
RfqPartViewModel model = new RfqPartViewModel();
var _partRepository = new PartRepository();
var _dynamicsPartRepository = new PartDynamicsRepository();
var _materialRepository = new MaterialRepository();
var dynamicsPart = _dynamicsPartRepository.GetPartMaster(part.Number);
var material = _materialRepository.GetMaterial(part.MaterialId);
var partDrawing = _partRepository.GetPartDrawings(part.PartId).FirstOrDefault(x => x.IsLatest);
model.PartId = part.PartId;
model.PartNumber = (!string.IsNullOrEmpty(part.Number)) ? part.Number : "N/A";
model.PartDescription = (dynamicsPart != null && !string.IsNullOrEmpty(dynamicsPart.ITEMDESC)) ? dynamicsPart.ITEMDESC : "N/A";
model.CustomerId = part.CustomerId;
model.FoundryId = part.FoundryId;
model.Weight = (dynamicsPart != null) ? (dynamicsPart.ITEMSHWT / 100.00m) : 0.00m;
model.AnnualUsage = part.AnnualUsage;
model.IsMachined = part.IsMachined;
model.MaterialId = part.MaterialId;
model.MaterialDescription = (material != null && !string.IsNullOrEmpty(material.Description)) ? material.Description : "N/A";
model.RevisionNumber = (partDrawing != null && !string.IsNullOrEmpty(partDrawing.RevisionNumber)) ? partDrawing.RevisionNumber : "N/A";
model.PartDrawingId = (partDrawing != null) ? partDrawing.PartDrawingId : Guid.Empty;
model.PartTypeId = part.PartTypeId;
model.PartStatusId = part.PartStatusId;
model.DestinationId = part.DestinationId;
model.SurchargeId = part.SurchargeId;
model.SubFoundryId = part.SubFoundryId;
if (_partRepository != null)
{
_partRepository.Dispose();
_partRepository = null;
}
if (_dynamicsPartRepository != null)
{
_dynamicsPartRepository.Dispose();
_dynamicsPartRepository = null;
}
if (_materialRepository != null)
{
_materialRepository.Dispose();
_materialRepository = null;
}
return(model);
}
