public void WhenGetAllFromEmptyDatabase_ThenReturnsEmptyCollection()
{
var repository = new PartTypeRepository(new DatabaseFactory());
IEnumerable<PartType> actual = repository.GetAll();
Assert.NotNull(actual);
var actualList = new List<PartType>(actual);
Assert.Equal(0, actualList.Count);
}
/// <summary>
/// convert project part to part view model
/// </summary>
/// <param name="projectPart"></param>
/// <returns></returns>
public PartViewModel ConvertToView(ProjectPart projectPart)
{
PartViewModel model = new PartViewModel();
var _projectRepository = new ProjectRepository();
var _foundryOrderRepository = new FoundryOrderRepository();
var _partTypeRepository = new PartTypeRepository();
var _partStatusRepository = new PartStatusRepository();
var partType = _partTypeRepository.GetPartType(projectPart.PartTypeId);
var statusEntity = _partStatusRepository.GetPartStatus(projectPart.PartStatusId);
var foundryOrderPart = _foundryOrderRepository.GetFoundryOrderPartByProjectPart(projectPart.ProjectPartId);
if (foundryOrderPart != null)
{
var toolingOrder = _foundryOrderRepository.GetToolingFoundryOrder(foundryOrderPart.FoundryOrderId);
model.FoundryOrderId = (toolingOrder != null) ? foundryOrderPart.FoundryOrderId : Guid.Empty;
model.ToolingOrderNumber = (toolingOrder != null && !string.IsNullOrEmpty(toolingOrder.Number)) ? toolingOrder.Number : "N/A";
model.ToolingDescription = projectPart.ToolingDescription;
}
model.ProjectPartId = projectPart.ProjectPartId;
model.PartId = projectPart.PartId;
model.PartNumber = (!string.IsNullOrEmpty(projectPart.Number)) ? projectPart.Number : "N/A";
model.PartDescription = (!string.IsNullOrEmpty(projectPart.Description)) ? projectPart.Description : "N/A";
model.AccountCode = (!string.IsNullOrEmpty(projectPart.AccountCode)) ? projectPart.AccountCode : "N/A";
model.RevisionNumber = (!string.IsNullOrEmpty(projectPart.RevisionNumber)) ? projectPart.RevisionNumber : "N/A";
model.CustomerId = projectPart.CustomerId;
model.CustomerAddressId = projectPart.CustomerAddressId;
model.FoundryId = projectPart.FoundryId;
model.SubFoundryId = projectPart.SubFoundryId;
model.HtsNumberId = projectPart.HtsNumberId;
model.MaterialId = projectPart.MaterialId;
model.SpecificationMaterialId = projectPart.MaterialSpecificationId;
model.PartStatusId = projectPart.PartStatusId;
model.PartStatusDescription = (statusEntity != null && !string.IsNullOrEmpty(statusEntity.Description)) ? statusEntity.Description : "N/A";
model.PartTypeId = projectPart.PartTypeId;
model.PartTypeDescription = (partType != null && !string.IsNullOrEmpty(partType.Description)) ? partType.Description : "N/A";
model.ShipmentTermId = projectPart.ShipmentTermId;
model.PaymentTermId = projectPart.PaymentTermId;
model.SurchargeId = projectPart.SurchargeId;
model.SiteId = projectPart.SiteId;
model.DestinationId = projectPart.DestinationId;
model.CoatingTypeId = projectPart.CoatingTypeId;
model.PatternMaterialId = projectPart.PatternMaterialId;
model.IsRaw = projectPart.IsRaw;
model.IsMachined = projectPart.IsMachined;
model.PalletQuantity = (projectPart.PalletQuantity != 0) ? projectPart.PalletQuantity : 0;
model.PalletWeight = (projectPart.PalletQuantity != 0) ? projectPart.PalletQuantity * projectPart.Weight : 0.00m;
model.Weight = (projectPart.Weight != 0.00m) ? projectPart.Weight : 0.00m;
model.Cost = (projectPart.Cost != 0.00m) ? projectPart.Cost : 0.00m;
model.Price = (projectPart.Price != 0.00m) ? projectPart.Price : 0.00m;
model.AdditionalCost = (projectPart.AdditionalCost != 0.00m) ? projectPart.AdditionalCost : 0.00m;
model.YearlySalesTotal = 0.00m;
model.SixtyDaysSalesTotal = 0.00m;
model.MonthlySalesTotal = 0.00m;
model.AverageDailySales = 0.00m;
model.QuantityOnHand = 0;
model.FixtureDate = (projectPart.FixtureDate != null) ? projectPart.FixtureDate : DateTime.MinValue;
model.FixtureCost = (projectPart.FixtureCost != 0.00m) ? projectPart.FixtureCost : 0.00m;
model.FixturePrice = (projectPart.FixturePrice != 0.00m) ? projectPart.FixturePrice : 0.00m;
model.PatternDate = projectPart.PatternDate;
model.PatternCost = (projectPart.PatternCost != 0.00m) ? projectPart.PatternCost : 0.00m;
model.PatternPrice = (projectPart.PatternPrice != 0.00m) ? projectPart.PatternPrice : 0.00m;
model.IsFamilyPattern = projectPart.IsFamilyPattern;
model.Notes = (projectPart.Notes != null) ? projectPart.Notes : "N/A";
model.AnnualUsage = (projectPart.PatternPrice != 0) ? projectPart.AnnualUsage : 0;
model.IsActive = true;
model.IsProjectPart = true;
if (projectPart.ProjectPartDrawings != null && projectPart.ProjectPartDrawings.Count > 0)
{
var drawings = new List <DrawingViewModel>();
foreach (var partDrawing in projectPart.ProjectPartDrawings)
{
DrawingViewModel convertedModel = new ProjectPartDrawingConverter().ConvertToView(partDrawing);
drawings.Add(convertedModel);
}
model.Drawings = drawings;
}
if (projectPart.ProjectPartLayouts != null && projectPart.ProjectPartLayouts.Count > 0)
{
var layouts = new List <LayoutViewModel>();
foreach (var partLayout in projectPart.ProjectPartLayouts)
{
LayoutViewModel convertedModel = new ProjectPartLayoutConverter().ConvertToView(partLayout);
layouts.Add(convertedModel);
}
model.Layouts = layouts;
}
if (_projectRepository != null)
{
_projectRepository.Dispose();
_projectRepository = null;
}
if (_foundryOrderRepository != null)
{
_foundryOrderRepository.Dispose();
_foundryOrderRepository = null;
}
if (_partTypeRepository != null)
{
_partTypeRepository.Dispose();
_partTypeRepository = null;
}
if (_partStatusRepository != null)
{
_partStatusRepository.Dispose();
_partStatusRepository = null;
}
return(model);
}
/// <summary>
/// convert part to project part list model
/// </summary>
/// <param name="part"></param>
/// <returns></returns>
public ProjectPartViewModel ConvertToListView(Part part)
{
ProjectPartViewModel model = new ProjectPartViewModel();
var _dynamicsPartRepository = new PartDynamicsRepository();
var _customerDynamicsRepository = new CustomerDynamicsRepository();
var _foundryDynamicsRepository = new FoundryDynamicsRepository();
var _htsNumberRepository = new HtsNumberRepository();
var _partTypeRepository = new PartTypeRepository();
var _partStatusRepository = new PartStatusRepository();
var dynamicsPart = _dynamicsPartRepository.GetPartMaster(part.Number);
var dynamicsCustomer = _customerDynamicsRepository.GetCustomer(part.CustomerId);
var dynamicsFoundry = _foundryDynamicsRepository.GetFoundry(part.FoundryId);
var htsNumber = _htsNumberRepository.GetHtsNumber(part.HtsNumberId);
var partType = _partTypeRepository.GetPartType(part.PartTypeId);
var partStatus = _partStatusRepository.GetPartStatus(part.PartStatusId);
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.CustomerName = (dynamicsCustomer != null && !string.IsNullOrEmpty(dynamicsCustomer.SHRTNAME)) ? dynamicsCustomer.SHRTNAME : "N/A";
model.FoundryId = part.FoundryId;
model.FoundryName = (dynamicsFoundry != null && !string.IsNullOrEmpty(dynamicsFoundry.VENDSHNM)) ? dynamicsFoundry.VENDSHNM : "N/A";
model.HtsNumberId = part.HtsNumberId;
model.HtsNumber = (htsNumber != null && !string.IsNullOrEmpty(htsNumber.Description)) ? htsNumber.Description + "(" + (htsNumber.DutyRate * 100).ToString() + "%)" : "N/A";
model.PartTypeId = part.PartTypeId;
model.PartTypeDescription = (partType != null && !string.IsNullOrEmpty(partType.Description)) ? partType.Description : "N/A";
model.PartStatusId = part.PartStatusId;
model.PartStatusDescription = (partStatus != null && !string.IsNullOrEmpty(partStatus.Description)) ? partStatus.Description : "N/A";
model.IsProject = false;
if (_dynamicsPartRepository != null)
{
_dynamicsPartRepository.Dispose();
_dynamicsPartRepository = null;
}
if (_customerDynamicsRepository != null)
{
_customerDynamicsRepository.Dispose();
_customerDynamicsRepository = null;
}
if (_foundryDynamicsRepository != null)
{
_foundryDynamicsRepository.Dispose();
_foundryDynamicsRepository = null;
}
if (_htsNumberRepository != null)
{
_htsNumberRepository.Dispose();
_htsNumberRepository = null;
}
if (_partTypeRepository != null)
{
_partTypeRepository.Dispose();
_partTypeRepository = null;
}
if (_partStatusRepository != null)
{
_partStatusRepository.Dispose();
_partStatusRepository = null;
}
return(model);
}
/// <summary>
/// convert part to view model
/// </summary>
/// <param name="part"></param>
/// <returns></returns>
public PartViewModel ConvertToView(Part part)
{
PartViewModel model = new PartViewModel();
var _partRepository = new PartRepository();
var _dynamicsPartRepository = new PartDynamicsRepository();
var _projectPartRepository = new ProjectPartRepository();
var _customerDynamicsRepository = new CustomerDynamicsRepository();
var _foundryDynamicsRepository = new FoundryDynamicsRepository();
var _htsNumberRepository = new HtsNumberRepository();
var _partTypeRepository = new PartTypeRepository();
var _partStatusRepository = new PartStatusRepository();
var _foundryOrderRepository = new FoundryOrderRepository();
var dynamicsPart = _dynamicsPartRepository.GetPartMaster(part.Number);
var dynamicsPartQty = _dynamicsPartRepository.GetPartQuantityMaster(part.Number);
var dynamicsPartCurrency = _dynamicsPartRepository.GetPartCurrency(part.Number);
var dynamicsPartRollingSales = _dynamicsPartRepository.GetItemRollingSales(part.Number);
var foundryOrderPart = _foundryOrderRepository.GetFoundryOrderPartByPart(part.PartId);
if (foundryOrderPart != null)
{
var toolingOrder = _foundryOrderRepository.GetToolingFoundryOrder(foundryOrderPart.FoundryOrderId);
model.FoundryOrderId = (toolingOrder != null) ? foundryOrderPart.FoundryOrderId : Guid.Empty;
model.ToolingOrderNumber = (toolingOrder != null && !string.IsNullOrEmpty(toolingOrder.Number)) ? toolingOrder.Number : "N/A";
model.ToolingDescription = (!string.IsNullOrEmpty(part.ToolingDescription)) ? part.ToolingDescription : "N/A";
}
var latestDrawing = _partRepository.GetPartDrawings(part.PartId).FirstOrDefault(x => x.IsLatest == true);
var weight = (dynamicsPart != null) ? Math.Round((dynamicsPart.ITEMSHWT / 100.00m), 2) : 0.00m;
var yearlySalesTotal = (dynamicsPartRollingSales != null) ? (dynamicsPartRollingSales.Sales_1_mo_ago +
dynamicsPartRollingSales.Sales_2_mo_ago +
dynamicsPartRollingSales.Sales_3_mo_ago +
dynamicsPartRollingSales.Sales_4_mo_ago +
dynamicsPartRollingSales.Sales_5_mo_ago +
dynamicsPartRollingSales.Sales_6_mo_ago +
dynamicsPartRollingSales.Sales_7_mo_ago +
dynamicsPartRollingSales.Sales_8_mo_ago +
dynamicsPartRollingSales.Sales_9_mo_ago +
dynamicsPartRollingSales.Sales_10_mo_ago +
dynamicsPartRollingSales.Sales_11_mo_ago +
dynamicsPartRollingSales.Sales_12_mo_ago) : 0.00m;
model.ProjectPartId = Guid.Empty;
model.PartId = part.PartId;
model.PartNumber = (!string.IsNullOrEmpty(part.Number)) ? part.Number : "N/A";
model.AccountCode = (!string.IsNullOrEmpty(part.AccountCode)) ? part.AccountCode : "N/A";
model.PartDescription = (dynamicsPart != null && !string.IsNullOrEmpty(dynamicsPart.ITEMDESC)) ? dynamicsPart.ITEMDESC : "N/A";
model.RevisionNumber = (latestDrawing != null && !string.IsNullOrEmpty(latestDrawing.RevisionNumber)) ? latestDrawing.RevisionNumber : "N/A";
model.CustomerId = part.CustomerId;
model.CustomerAddressId = part.CustomerAddressId;
model.FoundryId = part.FoundryId;
model.SubFoundryId = part.SubFoundryId;
model.HtsNumberId = part.HtsNumberId;
model.MaterialId = part.MaterialId;
model.SpecificationMaterialId = part.MaterialSpecificationId;
model.PartStatusId = part.PartStatusId;
model.PartTypeId = part.PartTypeId;
model.ShipmentTermId = part.ShipmentTermId;
model.PaymentTermId = part.PaymentTermId;
model.SurchargeId = part.SurchargeId;
model.SiteId = part.SiteId;
model.DestinationId = part.DestinationId;
model.CoatingTypeId = part.CoatingTypeId;
model.PatternMaterialId = part.PatternMaterialId;
model.IsRaw = part.IsRaw;
model.IsMachined = part.IsMachined;
model.PalletQuantity = (part.PalletQuantity != 0) ? part.PalletQuantity : 0;
model.PalletWeight = (part.PalletQuantity != 0) ? part.PalletQuantity * weight : 0.00m;
model.Weight = weight;
model.Cost = (dynamicsPart != null && (Math.Round(dynamicsPart.STNDCOST, 2) != 0.00m)) ? Math.Round(dynamicsPart.STNDCOST, 2) : 0.00m;
model.Price = (dynamicsPartCurrency != null && (Math.Round(dynamicsPartCurrency.LISTPRCE, 2) != 0.00m)) ? Math.Round(dynamicsPartCurrency.LISTPRCE, 2) : 0.00m;
model.AdditionalCost = (part.AdditionalCost != 0.00m) ? part.AdditionalCost : 0.00m;
model.YearlySalesTotal = Math.Round(yearlySalesTotal, 2);
model.SixtyDaysSalesTotal = (yearlySalesTotal != 0.00m) ? Math.Round((yearlySalesTotal / 6), 2) : 0.00m;
model.MonthlySalesTotal = (yearlySalesTotal != 0.00m) ? Math.Round((yearlySalesTotal / 12), 2) : 0.00m;
model.AverageDailySales = (yearlySalesTotal != 0.00m) ? Math.Round((yearlySalesTotal / 365), 2) : 0.00m;
model.QuantityOnHand = (dynamicsPartQty != null && (Math.Round(dynamicsPartQty.QTYONHND, 2) != 0.00m)) ? Math.Round(dynamicsPartQty.QTYONHND, 2) : 0.00m;
model.FixtureDate = (part.FixtureDate != null) ? part.FixtureDate : DateTime.MinValue;
model.FixtureDateStr = (part.FixtureDate != null) ? part.FixtureDate.Value.ToShortDateString() : "N/A";
model.FixtureCost = (Math.Round(part.FixtureCost, 2) != 0.00m) ? Math.Round(part.FixtureCost, 2) : 0.00m;
model.FixturePrice = (Math.Round(part.FixturePrice, 2) != 0.00m) ? Math.Round(part.FixturePrice, 2) : 0.00m;
model.PatternDate = (part.PatternDate != null) ? part.PatternDate : DateTime.MinValue;
model.PatternDateStr = (part.PatternDate != null) ? part.PatternDate.Value.ToShortDateString() : "N/A";
model.PatternCost = (Math.Round(part.PatternCost, 2) != 0.00m) ? Math.Round(part.PatternCost, 2) : 0.00m;
model.PatternPrice = (Math.Round(part.PatternPrice, 2) != 0.00m) ? Math.Round(part.PatternPrice, 2) : 0.00m;
model.IsFamilyPattern = part.IsFamilyPattern;
model.Notes = (!string.IsNullOrEmpty(part.Notes)) ? part.Notes : "N/A";
model.AnnualUsage = (part.AnnualUsage != 0) ? part.AnnualUsage : 0;
model.IsActive = part.IsActive;
model.IsProjectPart = false;
var partDrawings = _partRepository.GetPartDrawings(model.PartId ?? Guid.Empty);
if (part.PartDrawings != null && part.PartDrawings.Count > 0)
{
var drawings = new List <DrawingViewModel>();
foreach (var partDrawing in partDrawings)
{
DrawingViewModel convertedModel = new PartDrawingConverter().ConvertToView(partDrawing);
drawings.Add(convertedModel);
}
model.Drawings = drawings;
}
var partLayouts = _partRepository.GetPartLayouts(model.PartId ?? Guid.Empty);
if (part.PartLayouts != null && part.PartLayouts.Count > 0)
{
var layouts = new List <LayoutViewModel>();
foreach (var partLayout in partLayouts)
{
LayoutViewModel convertedModel = new PartLayoutConverter().ConvertToView(partLayout);
layouts.Add(convertedModel);
}
model.Layouts = layouts;
}
if (_partRepository != null)
{
_partRepository.Dispose();
_partRepository = null;
}
if (_dynamicsPartRepository != null)
{
_dynamicsPartRepository.Dispose();
_dynamicsPartRepository = null;
}
if (_projectPartRepository != null)
{
_projectPartRepository.Dispose();
_projectPartRepository = null;
}
if (_customerDynamicsRepository != null)
{
_customerDynamicsRepository.Dispose();
_customerDynamicsRepository = null;
}
if (_foundryDynamicsRepository != null)
{
_foundryDynamicsRepository.Dispose();
_foundryDynamicsRepository = null;
}
if (_htsNumberRepository != null)
{
_htsNumberRepository.Dispose();
_htsNumberRepository = null;
}
if (_partTypeRepository != null)
{
_partTypeRepository.Dispose();
_partTypeRepository = null;
}
if (_partStatusRepository != null)
{
_partStatusRepository.Dispose();
_partStatusRepository = null;
}
if (_foundryOrderRepository != null)
{
_foundryOrderRepository.Dispose();
_foundryOrderRepository = null;
}
return(model);
}
