public TViewModel MapToViewModel(InventoryMovement model)
        {
            var viewModel = new TViewModel()
            {
                No              = model.No,
                Date            = model.Date,
                ReferenceNo     = model.ReferenceNo,
                ReferenceType   = model.ReferenceType,
                ProductId       = model.ProductId,
                ProductCode     = model.ProductCode,
                ProductName     = model.ProductName,
                UomId           = model.UomId,
                UomUnit         = model.UomUnit,
                StorageId       = model.StorageId,
                StorageCode     = model.StorageCode,
                StorageName     = model.StorageName,
                StockPlanning   = model.StockPlanning,
                Before          = model.Before,
                Quantity        = model.Quantity,
                After           = model.After,
                Remark          = model.Remark,
                Type            = model.Type,
                LastModifiedUtc = model.LastModifiedUtc
            };

            PropertyCopier <InventoryMovement, TViewModel> .Copy(model, viewModel);

            return(viewModel);
        }
        public InventoryMovement MapToModel(InventoryMovementViewModel viewModel)
        {
            var model = new InventoryMovement()
            {
                No            = viewModel.no,
                Date          = viewModel.date,
                ReferenceNo   = viewModel.referenceNo,
                ReferenceType = viewModel.referenceType,
                ProductId     = viewModel.productId,
                ProductCode   = viewModel.productCode,
                ProductName   = viewModel.productName,
                UomId         = viewModel.uomId,
                UomUnit       = viewModel.uomUnit,
                StorageId     = viewModel.storageId,
                StorageCode   = viewModel.storageCode,
                StorageName   = viewModel.storageName,
                StockPlanning = viewModel.stockPlanning,
                Before        = viewModel.before,
                Quantity      = viewModel.quantity,
                After         = viewModel.after,
                Remark        = viewModel.remark,
                Type          = viewModel.type
            };

            PropertyCopier <InventoryMovementViewModel, InventoryMovement> .Copy(viewModel, model);

            return(model);
        }
Example #3
0
        async Task <string> GenerateNo(InventoryMovement model)
        {
            do
            {
                model.No = CodeGenerator.GenerateCode();
            }while (this.dbSet.Any(d => d.No.Equals(model.No)));

            return(model.No);
            //string Year = model.Date.ToString("yy");
            //string Month = model.Date.ToString("MM");


            //string no = $"MOV-{Year}-{Month}-{model.StorageCode}-";
            //int Padding = 7;

            //var lastNo = await this.dbSet.Where(w => w.No.StartsWith(no) && !w._IsDeleted).OrderByDescending(o => o.No).FirstOrDefaultAsync();

            //if (lastNo == null)
            //{
            //    return no + "1".PadLeft(Padding, '0');
            //}
            //else
            //{
            //    int lastNoNumber = Int32.Parse(lastNo.No.Replace(no, "")) + 1;
            //    return no + lastNoNumber.ToString().PadLeft(Padding, '0');
            //}
        }
        public InventoryMovement MapToModel(TViewModel viewModel)
        {
            var model = new InventoryMovement()
            {
                No            = viewModel.No,
                Date          = viewModel.Date,
                ReferenceNo   = viewModel.ReferenceNo,
                ReferenceType = viewModel.ReferenceType,
                ProductId     = viewModel.ProductId,
                ProductCode   = viewModel.ProductCode,
                ProductName   = viewModel.ProductName,
                UomId         = viewModel.UomId,
                UomUnit       = viewModel.UomUnit,
                StorageId     = viewModel.StorageId,
                StorageCode   = viewModel.StorageCode,
                StorageName   = viewModel.StorageName,
                StockPlanning = viewModel.StockPlanning,
                Before        = viewModel.Before,
                Quantity      = viewModel.Quantity,
                After         = viewModel.After,
                Remark        = viewModel.Remark,
                Type          = viewModel.Type
            };

            PropertyCopier <TViewModel, InventoryMovement> .Copy(viewModel, model);

            return(model);
        }
        public InventoryMovementViewModel MapToViewModel(InventoryMovement model)
        {
            var viewModel = new InventoryMovementViewModel()
            {
                no               = model.No,
                date             = model.Date,
                referenceNo      = model.ReferenceNo,
                referenceType    = model.ReferenceType,
                productId        = model.ProductId,
                productCode      = model.ProductCode,
                productName      = model.ProductName,
                uomId            = model.UomId,
                uomUnit          = model.UomUnit,
                storageId        = model.StorageId,
                storageCode      = model.StorageCode,
                storageName      = model.StorageName,
                stockPlanning    = model.StockPlanning,
                before           = model.Before,
                quantity         = model.Quantity,
                after            = model.After,
                remark           = model.Remark,
                type             = model.Type,
                _LastModifiedUtc = model._LastModifiedUtc
            };

            PropertyCopier <InventoryMovement, InventoryMovementViewModel> .Copy(model, viewModel);

            return(viewModel);
        }
        public async Task <int> CreateForPOS(TransferOutDoc model2, string username, int clientTimeZoneOffset = 7)
        {
            int Created = 0;

            using (var transaction = this.dbContext.Database.BeginTransaction())
            {
                try
                {
                    EntityExtension.FlagForCreate(model2, username, USER_AGENT);
                    foreach (var i in model2.Items)
                    {
                        var inventorymovement = new InventoryMovement();
                        var inven             = dbContext.Inventories.Where(x => x.ItemId == i.ItemId && x.StorageId == model2.SourceId).FirstOrDefault();
                        if (inven != null)
                        {
                            inventorymovement.Before = inven.Quantity;
                            inven.Quantity           = inven.Quantity - i.Quantity;
                        }
                        inventorymovement.After                      = inventorymovement.Before - i.Quantity;
                        inventorymovement.Date                       = DateTimeOffset.UtcNow;
                        inventorymovement.ItemCode                   = i.ItemCode;
                        inventorymovement.ItemDomesticCOGS           = i.DomesticCOGS;
                        inventorymovement.ItemDomesticRetail         = i.DomesticRetail;
                        inventorymovement.ItemDomesticWholeSale      = i.DomesticWholeSale;
                        inventorymovement.ItemDomesticSale           = i.DomesticSale;
                        inventorymovement.ItemId                     = i.ItemId;
                        inventorymovement.ItemInternationalCOGS      = 0;
                        inventorymovement.ItemInternationalRetail    = 0;
                        inventorymovement.ItemInternationalSale      = 0;
                        inventorymovement.ItemInternationalWholeSale = 0;
                        inventorymovement.ItemName                   = i.ItemName;
                        inventorymovement.ItemSize                   = i.Size;
                        inventorymovement.ItemUom                    = i.Uom;
                        inventorymovement.Quantity                   = i.Quantity;
                        inventorymovement.StorageCode                = model2.SourceCode;
                        inventorymovement.StorageId                  = model2.SourceId;
                        inventorymovement.StorageName                = model2.SourceName;
                        inventorymovement.Type                       = "OUT";
                        inventorymovement.Reference                  = model2.Code;
                        inventorymovement.Remark                     = model2.Remark;
                        inventorymovement.StorageIsCentral           = model2.SourceName.Contains("GUDANG") ? true : false;
                        EntityExtension.FlagForCreate(inventorymovement, username, USER_AGENT);
                        dbSetInventoryMovement.Add(inventorymovement);

                        EntityExtension.FlagForCreate(i, username, USER_AGENT);
                    }
                    dbSet.Add(model2);
                    Created = await dbContext.SaveChangesAsync();

                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }
            return(Created);
        }
        public async Task <InventoryMovement> GetTestData()
        {
            InventoryMovement invMov = GetNewData();

            await _inventoryMovementRepository.Create(invMov);

            return(invMov);
        }
        public async Task <InventoryMovement> GetTestData()
        {
            InventoryMovement invMov = GetNewData();

            await Service.Create(invMov);

            return(invMov);
        }
Example #9
0
        public async Task <int> Create(InventoryMovement model, string username)
        {
            int Created = 0;

            var internalTransaction = dbContext.Database.CurrentTransaction == null;
            var transaction         = !internalTransaction ? dbContext.Database.CurrentTransaction : dbContext.Database.BeginTransaction();

            try
            {
                model.No = await GenerateNo(model);

                model._CreatedAgent      = "Facade";
                model._CreatedBy         = username;
                model._LastModifiedAgent = "Facade";
                model._LastModifiedBy    = username;
                model._CreatedUtc        = DateTime.UtcNow;
                model._LastModifiedUtc   = DateTime.UtcNow;

                InventorySummaryFacade summary = new InventorySummaryFacade(this.serviceProvider, this.dbContext);

                this.dbSet.Add(model);
                Created = await dbContext.SaveChangesAsync();

                //var SumQty = this.dbSet.Where(a => a._IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == model.ProductId && a.UomId == model.UomId).Sum(a => a.Quantity);
                var SumQty = this.dbSet.OrderByDescending(a => a._CreatedUtc).FirstOrDefault(a => a._IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == model.ProductId && a.UomId == model.UomId);

                var SumStock = this.dbSet.Where(a => a._IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == model.ProductId && a.UomId == model.UomId).Sum(a => a.StockPlanning);
                InventorySummary summaryModel = new InventorySummary
                {
                    ProductId     = model.ProductId,
                    ProductCode   = model.ProductCode,
                    ProductName   = model.ProductName,
                    UomId         = model.UomId,
                    UomUnit       = model.UomUnit,
                    StockPlanning = SumStock,
                    Quantity      = SumQty.After,
                    StorageId     = model.StorageId,
                    StorageCode   = model.StorageCode,
                    StorageName   = model.StorageName
                };
                await summary.Create(summaryModel, username);

                if (internalTransaction)
                {
                    transaction.Commit();
                }

                return(Created);
            }
            catch (Exception e)
            {
                if (internalTransaction)
                {
                    transaction.Rollback();
                }
                throw new Exception(e.Message);
            }
        }
        private string GenerateNo(InventoryMovement model)
        {
            do
            {
                model.No = CodeGenerator.GenerateCode();
            }while (this._dbSet.Any(d => d.No.Equals(model.No)));

            return(model.No);
        }
    public void OnDrag(PointerEventData eventData)
    {
        Debug.Log("OnDrag");

        InventoryMovement dragging = eventData.pointerDrag.GetComponent <InventoryMovement>();

        if (dragging != null)
        {
            dragging.parentToReturnTo = this.transform;
        }
    }
Example #12
0
        public bool CreateInventoryMovement(InventoryMovement i)
        {
            SqlParameter p1 = new SqlParameter("sId", i.ShoeId);
            SqlParameter p2 = new SqlParameter("count", i.Count);
            SqlParameter p3 = new SqlParameter("no", i.No);
            SqlParameter p4 = new SqlParameter("type", i.Type);

            string sql = "exec dbo.CreateInventoryMovement @sId, @count, @no, @type";

            return(DataHelper.RunCommand(sql, p1, p2, p3, p4));
        }
        private InventoryMovement FetchInventoryMovement(SqlDataReader dr)
        {
            InventoryMovement iv = new InventoryMovement()
            {
                ProductName = DatabaseHelper.GetString("ProductName", dr),
                TypeName    = DatabaseHelper.GetString("TypeName", dr),
                Issued      = DatabaseHelper.GetMoney("Issued", dr),
                Returned    = DatabaseHelper.GetMoney("Returned", dr)
            };

            return(iv);
        }
        public async Task <int> Create(InventoryMovement model)
        {
            int Created = 0;

            var internalTransaction = DbContext.Database.CurrentTransaction == null;
            var transaction         = !internalTransaction ? DbContext.Database.CurrentTransaction : DbContext.Database.BeginTransaction();

            try
            {
                model.No = GenerateNo(model);
                model.FlagForCreate(IdentityService.Username, UserAgent);
                model.FlagForUpdate(IdentityService.Username, UserAgent);
                IInventorySummaryService summary = ServiceProvider.GetService <IInventorySummaryService>();

                this.DbSet.Add(model);
                Created = await DbContext.SaveChangesAsync();

                //var SumQty = this.dbSet.Where(a => a._IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == model.ProductId && a.UomId == model.UomId).Sum(a => a.Quantity);
                var SumQty = this.DbSet.OrderByDescending(a => a._CreatedUtc).FirstOrDefault(a => a._IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == model.ProductId && a.UomId == model.UomId);

                var SumStock = this.DbSet.Where(a => a._IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == model.ProductId && a.UomId == model.UomId).Sum(a => a.StockPlanning);
                InventorySummary summaryModel = new InventorySummary
                {
                    ProductId     = model.ProductId,
                    ProductCode   = model.ProductCode,
                    ProductName   = model.ProductName,
                    UomId         = model.UomId,
                    UomUnit       = model.UomUnit,
                    StockPlanning = SumStock,
                    Quantity      = SumQty.After,
                    StorageId     = model.StorageId,
                    StorageCode   = model.StorageCode,
                    StorageName   = model.StorageName
                };
                await summary.Create(summaryModel);

                if (internalTransaction)
                {
                    transaction.Commit();
                }

                return(Created);
            }
            catch (Exception e)
            {
                if (internalTransaction)
                {
                    transaction.Rollback();
                }
                throw new Exception(e.Message);
            }
        }
        public InventoryMovementDto WriteDto(InventoryMovement inventoryMovement)
        {
            if (inventoryMovement == null)
                throw new ArgumentNullException();

            var invMovementDto = new InventoryMovementDto();

            invMovementDto.Id = inventoryMovement.Id;
            invMovementDto.EventDate = inventoryMovement.EventDate;
            invMovementDto.EventType = ObjectFactory.GetInstance<IInventoryEventTypeAssembler>().WriteDto(inventoryMovement.EventType);
            invMovementDto.Description = inventoryMovement.Description;

            return invMovementDto;
        }
        public InventoryMovement ReadDto(InventoryMovementDto inventoryMovementDto)
        {
            if (inventoryMovementDto == null)
                throw new ArgumentNullException();

            var invMovement = ObjectFactory.GetInstance<IInventoryMovementRepository>().GetById(inventoryMovementDto.Id);

            if (invMovement != null)
                return invMovement;

            var newInvMovement = new InventoryMovement();
            newInvMovement.Id = inventoryMovementDto.Id;
            newInvMovement.EventDate = inventoryMovementDto.EventDate;
            newInvMovement.EventType = ObjectFactory.GetInstance<IInventoryEventTypeAssembler>().ReadDto(inventoryMovementDto.EventType);
            newInvMovement.Description = inventoryMovementDto.Description;

            return newInvMovement;
        }
 public void Save(InventoryMovement inventoryMovement)
 {
     using (var session = ObjectFactory.GetInstance<IMySessionFactory>().OpenSession())
     using (var transaction = session.BeginTransaction())
     {
         try
         {
             session.SaveOrUpdate(inventoryMovement);
             session.Flush();
             transaction.Commit();
         }
         catch (Exception)
         {
             transaction.Rollback();
             throw;
         }
     }
 }
        public void AssemblerCorrectlyWritesInventoryMovementDto()
        {
            var inventoryMovement = new InventoryMovement();
            inventoryMovement.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECEIPT_FROM_VENDOR };
            inventoryMovement.Description = "Description";
            inventoryMovement.EventDate = new DateTime(2012, 11, 9);
            inventoryMovement.InventoryItem = new InventoryItem() { SerialNumber = 12456 };

            _mockInvEventTypeAssembler.Setup(x => x.WriteDto(inventoryMovement.EventType)).Returns(new InventoryEventTypeDto() { EventType = inventoryMovement.EventType.EventType });

            var inventoryMovementDto = _assembler.WriteDto(inventoryMovement);

            Assert.IsNotNull(inventoryMovementDto);
            Assert.AreEqual(inventoryMovement.EventType.EventType, inventoryMovementDto.EventType.EventType);
            Assert.AreEqual(inventoryMovement.EventDate, inventoryMovementDto.EventDate);
            Assert.AreEqual(inventoryMovement.Description, inventoryMovementDto.Description);
            _mockInvEventTypeAssembler.VerifyAll();
        }
Example #19
0
        async Task <string> GenerateNo(InventoryMovement model)
        {
            string Year  = model.Date.ToString("yy");
            string Month = model.Date.ToString("MM");


            string no      = $"MOV-{Year}-{Month}-{model.StorageCode}-{model.ReferenceType}-";
            int    Padding = 7;

            var lastNo = await this.dbSet.Where(w => w.No.StartsWith(no) && !w._IsDeleted).OrderByDescending(o => o.No).FirstOrDefaultAsync();

            if (lastNo == null)
            {
                return(no + "1".PadLeft(Padding, '0'));
            }
            else
            {
                int lastNoNumber = Int32.Parse(lastNo.No.Replace(no, "")) + 1;
                return(no + lastNoNumber.ToString().PadLeft(Padding, '0'));
            }
        }
Example #20
0
        public async Task <int> Create(TransferInDoc model, string username, int clientTimeZoneOffset = 7)
        {
            int Created = 0;

            using (var transaction = this.dbContext.Database.BeginTransaction())
            {
                try
                {
                    string code = GenerateCode("MM-TB/BBP");
                    model.Code = code;
                    var SPK = dbContext.SPKDocs.Where(x => x.PackingList == model.Reference).Single();
                    SPK.IsReceived = true;
                    var Id = SPK.Id;
                    EntityExtension.FlagForCreate(model, username, USER_AGENT);
                    foreach (var i in model.Items)
                    {
                        i.Id = 0;
                        EntityExtension.FlagForCreate(i, username, USER_AGENT);
                        var SPKItems = dbContext.SPKDocsItems.Where(x => x.ItemArticleRealizationOrder == i.ArticleRealizationOrder && x.ItemCode == i.ItemCode && i.ItemName == i.ItemName && x.SPKDocsId == Id).Single();
                        SPKItems.SendQuantity = i.Quantity;
                        var inventorymovement = new InventoryMovement();
                        var inven             = dbContext.Inventories.Where(x => x.ItemId == i.ItemId && x.StorageId == model.DestinationId).FirstOrDefault();
                        if (inven != null)
                        {
                            inventorymovement.Before = inven.Quantity;
                            inven.Quantity           = inven.Quantity + i.Quantity;//inven.Quantity + i.quantity;
                            //dbSetInventory.Update(inven);
                        }
                        else
                        {
                            Inventory inventory = new Inventory
                            {
                                ItemArticleRealizationOrder = i.ArticleRealizationOrder,
                                ItemCode              = i.ItemCode,
                                ItemDomesticCOGS      = i.DomesticCOGS,
                                ItemDomesticRetail    = i.DomesticRetail,
                                ItemDomesticSale      = i.DomesticSale,
                                ItemDomesticWholeSale = i.DomesticWholeSale,
                                ItemId = i.ItemId,
                                ItemInternationalCOGS      = 0,
                                ItemInternationalRetail    = 0,
                                ItemInternationalSale      = 0,
                                ItemInternationalWholeSale = 0,
                                ItemName         = i.ItemName,
                                ItemSize         = i.Size,
                                ItemUom          = i.Uom,
                                Quantity         = i.Quantity,
                                StorageCode      = model.DestinationCode,
                                StorageId        = model.DestinationId,
                                StorageName      = model.DestinationName,
                                StorageIsCentral = model.DestinationName.Contains("GUDANG") ? true : false,
                            };
                            EntityExtension.FlagForCreate(inventory, username, USER_AGENT);
                            dbSetInventory.Add(inventory);
                        }

                        inventorymovement.After                      = inventorymovement.Before + i.Quantity;
                        inventorymovement.Date                       = DateTimeOffset.UtcNow;
                        inventorymovement.ItemCode                   = i.ItemCode;
                        inventorymovement.ItemDomesticCOGS           = i.DomesticCOGS;
                        inventorymovement.ItemDomesticRetail         = i.DomesticRetail;
                        inventorymovement.ItemDomesticWholeSale      = i.DomesticRetail;
                        inventorymovement.ItemDomesticSale           = i.DomesticSale;
                        inventorymovement.ItemId                     = i.ItemId;
                        inventorymovement.ItemInternationalCOGS      = 0;
                        inventorymovement.ItemInternationalRetail    = 0;
                        inventorymovement.ItemInternationalSale      = 0;
                        inventorymovement.ItemInternationalWholeSale = 0;
                        inventorymovement.ItemName                   = i.ItemName;
                        inventorymovement.ItemSize                   = i.Size;
                        inventorymovement.ItemUom                    = i.Uom;
                        inventorymovement.Quantity                   = i.Quantity;
                        inventorymovement.StorageCode                = model.DestinationCode;
                        inventorymovement.StorageId                  = model.DestinationId;
                        inventorymovement.StorageName                = model.DestinationName;
                        inventorymovement.Type                       = "IN";
                        inventorymovement.Reference                  = code;
                        inventorymovement.Remark                     = model.Remark;
                        inventorymovement.StorageIsCentral           = model.DestinationName.Contains("GUDANG") ? true : false;
                        EntityExtension.FlagForCreate(inventorymovement, username, USER_AGENT);
                        dbSetInventoryMovement.Add(inventorymovement);
                    }

                    dbSet.Add(model);
                    Created = await dbContext.SaveChangesAsync();

                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }

            return(Created);
        }
        public async Task <int> Create(Expedition model, string username, int clientTimeZoneOffset = 7)
        {
            int Created = 0;

            using (var transaction = this.dbContext.Database.BeginTransaction())
            {
                try
                {
                    int    totalweight = 0;
                    string code        = GenerateCode("EFR-KB/EXP");

                    model.Code = code;
                    model.Date = DateTimeOffset.Now;
                    TransferOutDoc transferOutDoc = new TransferOutDoc();
                    foreach (var i in model.Items)
                    {
                        i.Id         = 0;
                        totalweight += i.Weight;
                        string CodeTransferOut = GenerateCode("EFR-KB/EXP");
                        var    SPK             = dbContext.SPKDocs.Where(x => x.PackingList == i.PackingList).Single();
                        SPK.IsDistributed              = true;
                        transferOutDoc.Code            = CodeTransferOut;
                        transferOutDoc.Reference       = model.Code;
                        transferOutDoc.DestinationId   = i.DestinationId;
                        transferOutDoc.DestinationCode = i.DestinationCode;
                        transferOutDoc.DestinationName = i.DestinationName;
                        transferOutDoc.Remark          = model.Remark;
                        transferOutDoc.SourceId        = i.SourceId;
                        transferOutDoc.SourceCode      = i.SourceCode;
                        transferOutDoc.SourceName      = i.SourceName;
                        List <TransferOutDocItem> transferOutDocItems = new List <TransferOutDocItem>();
                        foreach (var d in i.Details)
                        {
                            d.Id = 0;
                            var inven = dbContext.Inventories.Where(x => x.ItemArticleRealizationOrder == d.ArticleRealizationOrder && x.ItemCode == d.ItemCode && x.ItemName == d.ItemName && x.StorageId == i.SourceId).Single();
                            //inven.Quantity = inven.Quantity - d.SendQuantity;

                            InventoryMovement movement = new InventoryMovement {
                                After  = inven.Quantity - d.SendQuantity,
                                Before = inven.Quantity,
                                Date   = DateTimeOffset.Now,
                                ItemArticleRealizationOrder = d.ArticleRealizationOrder,
                                ItemCode                   = d.ItemCode,
                                ItemDomesticCOGS           = d.DomesticCOGS,
                                ItemDomesticRetail         = d.DomesticRetail,
                                ItemDomesticSale           = d.DomesticSale,
                                ItemDomesticWholeSale      = d.DomesticWholesale,
                                ItemInternationalCOGS      = 0,
                                ItemInternationalRetail    = 0,
                                ItemInternationalSale      = 0,
                                ItemInternationalWholeSale = 0,
                                ItemId           = d.ItemId,
                                ItemName         = d.ItemName,
                                ItemSize         = d.Size,
                                Quantity         = d.Quantity,
                                Reference        = CodeTransferOut,
                                Remark           = d.Remark,
                                StorageCode      = i.SourceCode,
                                StorageIsCentral = i.SourceName.Contains("GUDANG") ? true : false,
                                StorageId        = i.SourceId,
                                StorageName      = i.DestinationName,
                                Type             = "OUT"
                            };

                            inven.Quantity = inven.Quantity - d.SendQuantity;
                            TransferOutDocItem transferItem = new TransferOutDocItem
                            {
                                ArticleRealizationOrder = d.ArticleRealizationOrder,
                                DomesticCOGS            = d.DomesticCOGS,
                                DomesticRetail          = d.DomesticRetail,
                                DomesticSale            = d.DomesticSale,
                                DomesticWholeSale       = d.DomesticWholesale,
                                ItemCode = d.ItemCode,
                                ItemId   = d.ItemId,
                                ItemName = d.ItemName,
                                Quantity = d.Quantity,
                                Remark   = d.Remark,
                                Size     = d.Size,
                                Uom      = d.Uom
                            };
                            EntityExtension.FlagForCreate(transferItem, username, USER_AGENT);
                            transferOutDocItems.Add(transferItem);
                            //transferOutDoc.Items.Add(transferItem);
                            //transferOutDoc.Items.Add(new TransferOutDocItem
                            //{
                            //    ArticleRealizationOrder = d.ArticleRealizationOrder
                            //    DomesticCOGS = d.DomesticCOGS,
                            //    DomesticRetail = d.DomesticRetail,
                            //    DomesticSale = d.DomesticSale,
                            //    DomesticWholeSale = d.DomesticWholesale,
                            //    ItemCode = d.ItemCode,
                            //    ItemId = d.ItemId,
                            //    ItemName = d.ItemName,
                            //    Quantity = d.Quantity,
                            //    Remark = d.Remark,
                            //    Size = d.Size,
                            //    Uom = d.Uom


                            //});
                            EntityExtension.FlagForCreate(d, username, USER_AGENT);
                            EntityExtension.FlagForCreate(movement, username, USER_AGENT);
                            this.dbSetInventoryMovement.Add(movement);
                        }
                        transferOutDoc.Items = transferOutDocItems;
                        EntityExtension.FlagForCreate(i, username, USER_AGENT);
                        EntityExtension.FlagForCreate(transferOutDoc, username, USER_AGENT);
                        this.dbSetTransfer.Add(transferOutDoc);
                    }
                    model.Weight = totalweight;
                    model.Remark = "";
                    EntityExtension.FlagForCreate(model, username, USER_AGENT);

                    dbSet.Add(model);
                    Created = await dbContext.SaveChangesAsync();

                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }

            return(Created);
        }
        public void Setup()
        {
            _mockSessionFactory = new Mock<IMySessionFactory>();
            _mockSettingsFactory = new Mock<ISettingsFactory>();
            _session = new Mock<ISession>();
            _transaction = new Mock<ITransaction>();
            _repository = new InventoryMovementRepository();
            _inventoryMovement = new InventoryMovement();

            Bootstrapper.BootstrapStructureMap();
            ObjectFactory.Inject(typeof(IMySessionFactory), _mockSessionFactory.Object);
            ObjectFactory.Inject(typeof(ISettingsFactory), _mockSettingsFactory.Object);

            _mockSessionFactory.Setup(x => x.OpenSession()).Returns(_session.Object);
            _session.Setup(x => x.BeginTransaction()).Returns(_transaction.Object);
        }
        public static void LoadSampleAthletes()
        {
            #region Repositories
            var athleteRepository = ObjectFactory.GetInstance<IAthleteRepository>();
            var modelRepository = ObjectFactory.GetInstance<IModelRepository>();
            var inventoryRepository = ObjectFactory.GetInstance<IInventoryItemRepository>();
            var invMovementRepository = ObjectFactory.GetInstance<IInventoryMovementRepository>();
            var userRepository = ObjectFactory.GetInstance<IUserRepository>();
            #endregion

            #region Athletes
            var athlete1 = new Athlete() { FirstName = "Jeff", LastName = "Artis-Gray", Nickname = "JArtis-Gray", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Jeff Artis-Gray", Status = "Future" };
            var athlete2 = new Athlete() { FirstName = "Darren", LastName = "Barlow", Nickname = "DBarlow", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Darren Barlow", Status = "Past" };
            var athlete3 = new Athlete() { FirstName = "Jared", LastName = "Berman", Nickname = "JBerman", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Jared Berman", Status = "Past" };
            var athlete4 = new Athlete() { FirstName = "Ronnie", LastName = "Black", Nickname = "RBlack", Gender = 'M', TrainerSizeM = 15, TrainerSizeW = 13, SpikeSizeM = 15, SpikeSizeW = 13, Notes = "Notes about Ronnie Black", Status = "Current" };
            var athlete5 = new Athlete() { FirstName = "Brayden", LastName = "Burleigh", Nickname = "BBurleigh", Gender = 'M', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Brayden Burleigh", Status = "Current" };
            var athlete6 = new Athlete() { FirstName = "Scott", LastName = "Campbell", Nickname = "SCampbell", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Scott Campbell", Status = "Current" };
            var athlete7 = new Athlete() { FirstName = "Juan", LastName = "Campos", Nickname = "JCampos", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Juan Campos", Status = "Current" };
            var athlete8 = new Athlete() { FirstName = "George", LastName = "Carter", Nickname = "GCarter", Gender = 'M', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about George Carter", Status = "Current" };
            var athlete9 = new Athlete() { FirstName = "Travis", LastName = "Correa", Nickname = "TCorrea", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Travis Correa", Status = "Future" };
            var athlete10 = new Athlete() { FirstName = "Thomas", LastName = "Curtin", Nickname = "TCurtin", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Thomas Curtin", Status = "Future" };
            var athlete11 = new Athlete() { FirstName = "Jason", LastName = "Cusack", Nickname = "JCusack", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Jason Cusack", Status = "Future" };
            var athlete12 = new Athlete() { FirstName = "Martin", LastName = "Dally", Nickname = "MDally", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Martin Dally", Status = "Future" };
            var athlete13 = new Athlete() { FirstName = "Leoule", LastName = "Degfae", Nickname = "LDegfae", Gender = 'M', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Leoule Degfae", Status = "Past" };
            var athlete14 = new Athlete() { FirstName = "Tihut", LastName = "Degfae", Nickname = "TDegfae", Gender = 'M', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Tihut Degfae", Status = "Past" };
            var athlete15 = new Athlete() { FirstName = "Kevin", LastName = "Dewillie", Nickname = "KDewillie", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Kevin Dewillie", Status = "Past" };
            var athlete16 = new Athlete() { FirstName = "Kevin", LastName = "Dowd", Nickname = "KDowd", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Kevin Dowd", Status = "Current" };
            var athlete17 = new Athlete() { FirstName = "Armando", LastName = "Drain", Nickname = "ADrain", Gender = 'M', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Armando Drain", Status = "Current" };
            var athlete18 = new Athlete() { FirstName = "James", LastName = "Ertel", Nickname = "JErtel", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about James Ertel", Status = "Current" };
            var athlete19 = new Athlete() { FirstName = "Corey", LastName = "Fuller", Nickname = "CFuller", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Corey Fuller", Status = "Current" };
            var athlete20 = new Athlete() { FirstName = "Ryan", LastName = "Hagen", Nickname = "RHagen", Gender = 'M', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Ryan Hagen", Status = "Current" };
            var athlete21 = new Athlete() { FirstName = "Michael", LastName = "Hammond", Nickname = "MHammond", Gender = 'M', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Michael Hammond", Status = "Current" };
            var athlete22 = new Athlete() { FirstName = "Eric", LastName = "Hoepker", Nickname = "EHoepker", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Eric Hoepker", Status = "Future" };
            var athlete23 = new Athlete() { FirstName = "Matt", LastName = "Hoogland", Nickname = "MHoogland", Gender = 'M', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Matt Hoogland", Status = "Future" };
            var athlete24 = new Athlete() { FirstName = "Brad", LastName = "Johnson", Nickname = "BJohnson", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Brad Johnson", Status = "Future" };
            var athlete25 = new Athlete() { FirstName = "Demitri", LastName = "Knowles", Nickname = "DKnowles", Gender = 'M', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Demitri Knowles", Status = "Future" };
            var athlete26 = new Athlete() { FirstName = "Tomas", LastName = "Kruzliak", Nickname = "TKruzliak", Gender = 'M', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Tomas Kruzliak", Status = "Future" };
            var athlete27 = new Athlete() { FirstName = "Ryan", LastName = "Kuhns", Nickname = "RKuhns", Gender = 'M', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Ryan Kuhns", Status = "Future" };
            var athlete28 = new Athlete() { FirstName = "Zach", LastName = "Link", Nickname = "ZLink", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Zach Link", Status = "Future" };
            var athlete29 = new Athlete() { FirstName = "Matt", LastName = "Little", Nickname = "MLittle", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Matt Little", Status = "Future" };
            var athlete30 = new Athlete() { FirstName = "Denis", LastName = "Mahmic", Nickname = "DMahmic", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Denis Mahmic", Status = "Past" };
            var athlete31 = new Athlete() { FirstName = "Jonathan", LastName = "McCants", Nickname = "JMcCants", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Jonathan McCants", Status = "Past" };
            var athlete32 = new Athlete() { FirstName = "Michael", LastName = "McNamee", Nickname = "MMcNamee", Gender = 'M', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Michael McNamee", Status = "Past" };
            var athlete33 = new Athlete() { FirstName = "Jaka", LastName = "Muhar", Nickname = "JMuhar", Gender = 'M', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Jaka Muhar", Status = "Past" };
            var athlete34 = new Athlete() { FirstName = "Will", LastName = "Mulherin", Nickname = "WMulherin", Gender = 'M', TrainerSizeM = 15, TrainerSizeW = 13, SpikeSizeM = 15, SpikeSizeW = 13, Notes = "Notes about Will Mulherin", Status = "Current" };
            var athlete35 = new Athlete() { FirstName = "Stephan", LastName = "Munz", Nickname = "SMunz", Gender = 'M', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Stephan Munz", Status = "Current" };
            var athlete36 = new Athlete() { FirstName = "Joseph", LastName = "Murray", Nickname = "JMurray", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Joseph Murray", Status = "Current" };
            var athlete37 = new Athlete() { FirstName = "Brian", LastName = "O'Loughlin", Nickname = "BO'Loughlin", Gender = 'M', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Brian O'Loughlin", Status = "Current" };
            var athlete38 = new Athlete() { FirstName = "Tadashi", LastName = "Pinder", Nickname = "TPinder", Gender = 'M', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Tadashi Pinder", Status = "Current" };
            var athlete39 = new Athlete() { FirstName = "Grant", LastName = "Pollock", Nickname = "GPollock", Gender = 'M', TrainerSizeM = 15, TrainerSizeW = 13, SpikeSizeM = 15, SpikeSizeW = 13, Notes = "Notes about Grant Pollock", Status = "Current" };
            var athlete40 = new Athlete() { FirstName = "Stuart", LastName = "Robertson", Nickname = "SRobertson", Gender = 'M', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Stuart Robertson", Status = "Current" };
            var athlete41 = new Athlete() { FirstName = "Garrett", LastName = "Smith", Nickname = "GSmith", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Garrett Smith", Status = "Current" };
            var athlete42 = new Athlete() { FirstName = "Matthias", LastName = "Treff", Nickname = "MTreff", Gender = 'M', TrainerSizeM = 14, TrainerSizeW = 12, SpikeSizeM = 14, SpikeSizeW = 12, Notes = "Notes about Matthias Treff", Status = "Current" };
            var athlete43 = new Athlete() { FirstName = "Chris", LastName = "Uhle", Nickname = "CUhle", Gender = 'M', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Chris Uhle", Status = "Current" };
            var athlete44 = new Athlete() { FirstName = "Benjamin", LastName = "Unger", Nickname = "BUnger", Gender = 'M', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Benjamin Unger", Status = "Current" };
            var athlete45 = new Athlete() { FirstName = "Brian", LastName = "Welch", Nickname = "BWelch", Gender = 'M', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Brian Welch", Status = "Current" };
            var athlete46 = new Athlete() { FirstName = "Darrell", LastName = "Wesh", Nickname = "DWesh", Gender = 'M', TrainerSizeM = 15, TrainerSizeW = 13, SpikeSizeM = 15, SpikeSizeW = 13, Notes = "Notes about Darrell Wesh", Status = "Current" };
            var athlete47 = new Athlete() { FirstName = "Patrick", LastName = "Woodford", Nickname = "PWoodford", Gender = 'M', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Patrick Woodford", Status = "Future" };
            var athlete48 = new Athlete() { FirstName = "Alexander", LastName = "Ziegler", Nickname = "AZiegler", Gender = 'M', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Alexander Ziegler", Status = "Future" };
            var athlete49 = new Athlete() { FirstName = "Leigh", LastName = "Allin", Nickname = "LAllin", Gender = 'F', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Leigh Allin", Status = "Future" };
            var athlete50 = new Athlete() { FirstName = "Yvonne", LastName = "Amegashie", Nickname = "YAmegashie", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Yvonne Amegashie", Status = "Future" };
            var athlete51 = new Athlete() { FirstName = "Adeyani", LastName = "Aromolaran", Nickname = "AAromolaran", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Adeyani Aromolaran", Status = "Future" };
            var athlete52 = new Athlete() { FirstName = "Kaila", LastName = "Blackburn", Nickname = "KBlackburn", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Kaila Blackburn", Status = "Future" };
            var athlete53 = new Athlete() { FirstName = "Camille", LastName = "Bouvet", Nickname = "CBouvet", Gender = 'F', TrainerSizeM = 6, TrainerSizeW = 4, SpikeSizeM = 6, SpikeSizeW = 4, Notes = "Notes about Camille Bouvet", Status = "Future" };
            var athlete54 = new Athlete() { FirstName = "Stephanie", LastName = "Cario", Nickname = "SCario", Gender = 'F', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Stephanie Cario", Status = "Future" };
            var athlete55 = new Athlete() { FirstName = "Taylor", LastName = "Crosson", Nickname = "TCrosson", Gender = 'F', TrainerSizeM = 6, TrainerSizeW = 4, SpikeSizeM = 6, SpikeSizeW = 4, Notes = "Notes about Taylor Crosson", Status = "Future" };
            var athlete56 = new Athlete() { FirstName = "Jameice", LastName = "DeCoster", Nickname = "JDeCoster", Gender = 'F', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Jameice DeCoster", Status = "Past" };
            var athlete57 = new Athlete() { FirstName = "Courtney", LastName = "Dobbs", Nickname = "CDobbs", Gender = 'F', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Courtney Dobbs", Status = "Past" };
            var athlete58 = new Athlete() { FirstName = "Johanna", LastName = "Dominick", Nickname = "JDominick", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Johanna Dominick", Status = "Past" };
            var athlete59 = new Athlete() { FirstName = "Sammy", LastName = "Dow", Nickname = "SDow", Gender = 'F', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Sammy Dow", Status = "Past" };
            var athlete60 = new Athlete() { FirstName = "Frances", LastName = "Dowd", Nickname = "FDowd", Gender = 'F', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Frances Dowd", Status = "Past" };
            var athlete61 = new Athlete() { FirstName = "Grace", LastName = "Giampietro", Nickname = "GGiampietro", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Grace Giampietro", Status = "Current" };
            var athlete62 = new Athlete() { FirstName = "Hannah", LastName = "Gray", Nickname = "HGray", Gender = 'F', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Hannah Gray", Status = "Current" };
            var athlete63 = new Athlete() { FirstName = "Jenna", LastName = "Hadley", Nickname = "JHadley", Gender = 'F', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Jenna Hadley", Status = "Current" };
            var athlete64 = new Athlete() { FirstName = "Shanice", LastName = "Hairston", Nickname = "SHairston", Gender = 'F', TrainerSizeM = 6, TrainerSizeW = 4, SpikeSizeM = 6, SpikeSizeW = 4, Notes = "Notes about Shanice Hairston", Status = "Current" };
            var athlete65 = new Athlete() { FirstName = "Ashley", LastName = "Hayes", Nickname = "AHayes", Gender = 'F', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Ashley Hayes", Status = "Current" };
            var athlete66 = new Athlete() { FirstName = "Lauren", LastName = "Jaeger", Nickname = "LJaeger", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Lauren Jaeger", Status = "Current" };
            var athlete67 = new Athlete() { FirstName = "Erin", LastName = "Jankowski", Nickname = "EJankowski", Gender = 'F', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Erin Jankowski", Status = "Current" };
            var athlete68 = new Athlete() { FirstName = "Alyson", LastName = "Jones", Nickname = "AJones", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Alyson Jones", Status = "Current" };
            var athlete69 = new Athlete() { FirstName = "Ginny", LastName = "Jones", Nickname = "GJones", Gender = 'F', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Ginny Jones", Status = "Future" };
            var athlete70 = new Athlete() { FirstName = "Tamzin", LastName = "Kaiser", Nickname = "TKaiser", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Tamzin Kaiser", Status = "Future" };
            var athlete71 = new Athlete() { FirstName = "Sabine", LastName = "Kopplin", Nickname = "SKopplin", Gender = 'F', TrainerSizeM = 6, TrainerSizeW = 4, SpikeSizeM = 6, SpikeSizeW = 4, Notes = "Notes about Sabine Kopplin", Status = "Future" };
            var athlete72 = new Athlete() { FirstName = "Ally", LastName = "Kuehm", Nickname = "AKuehm", Gender = 'F', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Ally Kuehm", Status = "Future" };
            var athlete73 = new Athlete() { FirstName = "Paige", LastName = "Kvartunas", Nickname = "PKvartunas", Gender = 'F', TrainerSizeM = 6, TrainerSizeW = 4, SpikeSizeM = 6, SpikeSizeW = 4, Notes = "Notes about Paige Kvartunas", Status = "Future" };
            var athlete74 = new Athlete() { FirstName = "Shaquera", LastName = "Leach", Nickname = "SLeach", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Shaquera Leach", Status = "Past" };
            var athlete75 = new Athlete() { FirstName = "Shalonda", LastName = "Mitchell", Nickname = "SMitchell", Gender = 'F', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Shalonda Mitchell", Status = "Past" };
            var athlete76 = new Athlete() { FirstName = "Colleen", LastName = "Moore", Nickname = "CMoore", Gender = 'F', TrainerSizeM = 8, TrainerSizeW = 6, SpikeSizeM = 8, SpikeSizeW = 6, Notes = "Notes about Colleen Moore", Status = "Past" };
            var athlete77 = new Athlete() { FirstName = "Shannon", LastName = "Morton", Nickname = "SMorton", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Shannon Morton", Status = "Current" };
            var athlete78 = new Athlete() { FirstName = "Britani", LastName = "Myers", Nickname = "BMyers", Gender = 'F', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Britani Myers", Status = "Current" };
            var athlete79 = new Athlete() { FirstName = "Rachel", LastName = "Nichols", Nickname = "RNichols", Gender = 'F', TrainerSizeM = 13, TrainerSizeW = 11, SpikeSizeM = 13, SpikeSizeW = 11, Notes = "Notes about Rachel Nichols", Status = "Current" };
            var athlete80 = new Athlete() { FirstName = "Madalyn", LastName = "Nuckols", Nickname = "MNuckols", Gender = 'F', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Madalyn Nuckols", Status = "Current" };
            var athlete81 = new Athlete() { FirstName = "Leah", LastName = "Nugent", Nickname = "LNugent", Gender = 'F', TrainerSizeM = 8, TrainerSizeW = 6, SpikeSizeM = 8, SpikeSizeW = 6, Notes = "Notes about Leah Nugent", Status = "Current" };
            var athlete82 = new Athlete() { FirstName = "Elizabeth", LastName = "Powell", Nickname = "EPowell", Gender = 'F', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Elizabeth Powell", Status = "Current" };
            var athlete83 = new Athlete() { FirstName = "Amanda", LastName = "Presler", Nickname = "APresler", Gender = 'F', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Amanda Presler", Status = "Current" };
            var athlete84 = new Athlete() { FirstName = "Sarah", LastName = "Rapp", Nickname = "SRapp", Gender = 'F', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Sarah Rapp", Status = "Current" };
            var athlete85 = new Athlete() { FirstName = "Lyndsey", LastName = "Saunders", Nickname = "LSaunders", Gender = 'F', TrainerSizeM = 6, TrainerSizeW = 4, SpikeSizeM = 6, SpikeSizeW = 4, Notes = "Notes about Lyndsey Saunders", Status = "Current" };
            var athlete86 = new Athlete() { FirstName = "Erinn", LastName = "Schaal", Nickname = "ESchaal", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Erinn Schaal", Status = "Future" };
            var athlete87 = new Athlete() { FirstName = "Martina", LastName = "Schultze", Nickname = "MSchultze", Gender = 'F', TrainerSizeM = 10, TrainerSizeW = 8, SpikeSizeM = 10, SpikeSizeW = 8, Notes = "Notes about Martina Schultze", Status = "Future" };
            var athlete88 = new Athlete() { FirstName = "Katherine", LastName = "Sheridan", Nickname = "KSheridan", Gender = 'F', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Katherine Sheridan", Status = "Future" };
            var athlete89 = new Athlete() { FirstName = "Oshin", LastName = "Shukla", Nickname = "OShukla", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Oshin Shukla", Status = "Future" };
            var athlete90 = new Athlete() { FirstName = "Ciara", LastName = "Simms", Nickname = "CSimms", Gender = 'F', TrainerSizeM = 6, TrainerSizeW = 4, SpikeSizeM = 6, SpikeSizeW = 4, Notes = "Notes about Ciara Simms", Status = "Past" };
            var athlete91 = new Athlete() { FirstName = "Katarina", LastName = "Smiljanec", Nickname = "KSmiljanec", Gender = 'F', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Katarina Smiljanec", Status = "Past" };
            var athlete92 = new Athlete() { FirstName = "Amanda", LastName = "Smith", Nickname = "ASmith", Gender = 'F', TrainerSizeM = 11, TrainerSizeW = 9, SpikeSizeM = 11, SpikeSizeW = 9, Notes = "Notes about Amanda Smith", Status = "Past" };
            var athlete93 = new Athlete() { FirstName = "Leigh Ann", LastName = "Soistmann", Nickname = "LSoistmann", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Leigh Ann Soistmann", Status = "Past" };
            var athlete94 = new Athlete() { FirstName = "Annjulie", LastName = "Vester", Nickname = "AVester", Gender = 'F', TrainerSizeM = 12, TrainerSizeW = 10, SpikeSizeM = 12, SpikeSizeW = 10, Notes = "Notes about Annjulie Vester", Status = "Past" };
            var athlete95 = new Athlete() { FirstName = "Alex", LastName = "Watt", Nickname = "AWatt", Gender = 'F', TrainerSizeM = 9, TrainerSizeW = 7, SpikeSizeM = 9, SpikeSizeW = 7, Notes = "Notes about Alex Watt", Status = "Current" };
            var athlete96 = new Athlete() { FirstName = "Natalie", LastName = "Woodford", Nickname = "NWoodford", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Natalie Woodford", Status = "Current" };
            var athlete97 = new Athlete() { FirstName = "Sarah", LastName = "Woynicz", Nickname = "SWoynicz", Gender = 'F', TrainerSizeM = 7, TrainerSizeW = 5, SpikeSizeM = 7, SpikeSizeW = 5, Notes = "Notes about Sarah Woynicz", Status = "Current" };
            #endregion

            #region Event Areas
            var crossCountry = new EventArea() { EventName = Constants.EventAreas.CROSS_COUNTRY };
            var distance = new EventArea() { EventName = Constants.EventAreas.DISTANCE };
            var hurdles = new EventArea() { EventName = Constants.EventAreas.HURDLES };
            var jumps = new EventArea() { EventName = Constants.EventAreas.JUMPS };
            var sprints = new EventArea() { EventName = Constants.EventAreas.SPRINTS };
            var throws = new EventArea() { EventName = Constants.EventAreas.THROWS };
            var poleVault = new EventArea() { EventName = Constants.EventAreas.POLE_VAULT };
            #endregion

            #region Athlete Event Participation
            athlete1.EventAreas.Add(jumps);
            athlete2.EventAreas.Add(distance);
            athlete3.EventAreas.Add(distance);
            athlete4.EventAreas.Add(jumps);
            athlete5.EventAreas.Add(distance);
            athlete6.EventAreas.Add(jumps);
            athlete7.EventAreas.Add(distance);
            athlete8.EventAreas.Add(distance);
            athlete9.EventAreas.Add(distance);
            athlete10.EventAreas.Add(distance);
            athlete11.EventAreas.Add(distance);
            athlete12.EventAreas.Add(distance);
            athlete13.EventAreas.Add(distance);
            athlete14.EventAreas.Add(distance);
            athlete15.EventAreas.Add(distance);
            athlete16.EventAreas.Add(distance);
            athlete17.EventAreas.Add(jumps);
            athlete18.EventAreas.Add(distance);
            athlete19.EventAreas.Add(jumps);
            athlete20.EventAreas.Add(distance);
            athlete21.EventAreas.Add(distance);
            athlete22.EventAreas.Add(jumps);
            athlete23.EventAreas.Add(poleVault);
            athlete24.EventAreas.Add(poleVault);
            athlete25.EventAreas.Add(jumps);
            athlete26.EventAreas.Add(throws);
            athlete27.EventAreas.Add(distance);
            athlete28.EventAreas.Add(distance);
            athlete29.EventAreas.Add(distance);
            athlete30.EventAreas.Add(throws);
            athlete31.EventAreas.Add(jumps);
            athlete32.EventAreas.Add(distance);
            athlete33.EventAreas.Add(throws);
            athlete34.EventAreas.Add(distance);
            athlete35.EventAreas.Add(poleVault);
            athlete36.EventAreas.Add(distance);
            athlete37.EventAreas.Add(distance);
            athlete38.EventAreas.Add(jumps);
            athlete39.EventAreas.Add(distance);
            athlete40.EventAreas.Add(distance);
            athlete41.EventAreas.Add(jumps);
            athlete42.EventAreas.Add(throws);
            athlete43.EventAreas.Add(poleVault);
            athlete44.EventAreas.Add(jumps);
            athlete45.EventAreas.Add(distance);
            athlete46.EventAreas.Add(jumps);
            athlete47.EventAreas.Add(distance);
            athlete48.EventAreas.Add(throws);
            athlete49.EventAreas.Add(poleVault);
            athlete50.EventAreas.Add(jumps);
            athlete51.EventAreas.Add(jumps);
            athlete52.EventAreas.Add(distance);
            athlete53.EventAreas.Add(distance);
            athlete54.EventAreas.Add(distance);
            athlete55.EventAreas.Add(distance);
            athlete56.EventAreas.Add(jumps);
            athlete57.EventAreas.Add(distance);
            athlete58.EventAreas.Add(jumps);
            athlete59.EventAreas.Add(distance);
            athlete60.EventAreas.Add(distance);
            athlete61.EventAreas.Add(poleVault);
            athlete62.EventAreas.Add(distance);
            athlete63.EventAreas.Add(distance);
            athlete64.EventAreas.Add(throws);
            athlete65.EventAreas.Add(distance);
            athlete66.EventAreas.Add(distance);
            athlete67.EventAreas.Add(distance);
            athlete68.EventAreas.Add(distance);
            athlete69.EventAreas.Add(distance);
            athlete70.EventAreas.Add(distance);
            athlete71.EventAreas.Add(throws);
            athlete72.EventAreas.Add(distance);
            athlete73.EventAreas.Add(distance);
            athlete74.EventAreas.Add(jumps);
            athlete75.EventAreas.Add(distance);
            athlete76.EventAreas.Add(distance);
            athlete77.EventAreas.Add(distance);
            athlete78.EventAreas.Add(distance);
            athlete79.EventAreas.Add(distance);
            athlete80.EventAreas.Add(distance);
            athlete81.EventAreas.Add(jumps);
            athlete82.EventAreas.Add(poleVault);
            athlete83.EventAreas.Add(distance);
            athlete84.EventAreas.Add(distance);
            athlete85.EventAreas.Add(poleVault);
            athlete86.EventAreas.Add(poleVault);
            athlete87.EventAreas.Add(poleVault);
            athlete88.EventAreas.Add(distance);
            athlete89.EventAreas.Add(distance);
            athlete90.EventAreas.Add(jumps);
            athlete91.EventAreas.Add(distance);
            athlete92.EventAreas.Add(distance);
            athlete93.EventAreas.Add(distance);
            athlete94.EventAreas.Add(throws);
            athlete95.EventAreas.Add(distance);
            athlete96.EventAreas.Add(jumps);
            athlete97.EventAreas.Add(distance);
            athlete1.EventAreas.Add(hurdles);
            athlete6.EventAreas.Add(jumps);
            athlete17.EventAreas.Add(hurdles);
            athlete19.EventAreas.Add(jumps);
            athlete38.EventAreas.Add(hurdles);
            athlete41.EventAreas.Add(hurdles);
            athlete44.EventAreas.Add(hurdles);
            athlete51.EventAreas.Add(hurdles);
            athlete58.EventAreas.Add(hurdles);
            athlete74.EventAreas.Add(hurdles);
            athlete81.EventAreas.Add(hurdles);
            athlete1.EventAreas.Add(jumps);
            athlete6.EventAreas.Add(poleVault);
            athlete17.EventAreas.Add(jumps);
            athlete38.EventAreas.Add(jumps);
            athlete41.EventAreas.Add(jumps);
            athlete44.EventAreas.Add(jumps);
            athlete51.EventAreas.Add(jumps);
            athlete58.EventAreas.Add(jumps);
            athlete74.EventAreas.Add(jumps);
            #endregion

            #region Save Athlete with assigned Event Areas
            athleteRepository.Save(athlete1);
            athleteRepository.Save(athlete2);
            athleteRepository.Save(athlete3);
            athleteRepository.Save(athlete4);
            athleteRepository.Save(athlete5);
            athleteRepository.Save(athlete6);
            athleteRepository.Save(athlete7);
            athleteRepository.Save(athlete8);
            athleteRepository.Save(athlete9);
            athleteRepository.Save(athlete10);
            athleteRepository.Save(athlete11);
            athleteRepository.Save(athlete12);
            athleteRepository.Save(athlete13);
            athleteRepository.Save(athlete14);
            athleteRepository.Save(athlete15);
            athleteRepository.Save(athlete16);
            athleteRepository.Save(athlete17);
            athleteRepository.Save(athlete18);
            athleteRepository.Save(athlete19);
            athleteRepository.Save(athlete20);
            athleteRepository.Save(athlete21);
            athleteRepository.Save(athlete22);
            athleteRepository.Save(athlete23);
            athleteRepository.Save(athlete24);
            athleteRepository.Save(athlete25);
            athleteRepository.Save(athlete26);
            athleteRepository.Save(athlete27);
            athleteRepository.Save(athlete28);
            athleteRepository.Save(athlete29);
            athleteRepository.Save(athlete30);
            athleteRepository.Save(athlete31);
            athleteRepository.Save(athlete32);
            athleteRepository.Save(athlete33);
            athleteRepository.Save(athlete34);
            athleteRepository.Save(athlete35);
            athleteRepository.Save(athlete36);
            athleteRepository.Save(athlete37);
            athleteRepository.Save(athlete38);
            athleteRepository.Save(athlete39);
            athleteRepository.Save(athlete40);
            athleteRepository.Save(athlete41);
            athleteRepository.Save(athlete42);
            athleteRepository.Save(athlete43);
            athleteRepository.Save(athlete44);
            athleteRepository.Save(athlete45);
            athleteRepository.Save(athlete46);
            athleteRepository.Save(athlete47);
            athleteRepository.Save(athlete48);
            athleteRepository.Save(athlete49);
            athleteRepository.Save(athlete50);
            athleteRepository.Save(athlete51);
            athleteRepository.Save(athlete52);
            athleteRepository.Save(athlete53);
            athleteRepository.Save(athlete54);
            athleteRepository.Save(athlete55);
            athleteRepository.Save(athlete56);
            athleteRepository.Save(athlete57);
            athleteRepository.Save(athlete58);
            athleteRepository.Save(athlete59);
            athleteRepository.Save(athlete60);
            athleteRepository.Save(athlete61);
            athleteRepository.Save(athlete62);
            athleteRepository.Save(athlete63);
            athleteRepository.Save(athlete64);
            athleteRepository.Save(athlete65);
            athleteRepository.Save(athlete66);
            athleteRepository.Save(athlete67);
            athleteRepository.Save(athlete68);
            athleteRepository.Save(athlete69);
            athleteRepository.Save(athlete70);
            athleteRepository.Save(athlete71);
            athleteRepository.Save(athlete72);
            athleteRepository.Save(athlete73);
            athleteRepository.Save(athlete74);
            athleteRepository.Save(athlete75);
            athleteRepository.Save(athlete76);
            athleteRepository.Save(athlete77);
            athleteRepository.Save(athlete78);
            athleteRepository.Save(athlete79);
            athleteRepository.Save(athlete80);
            athleteRepository.Save(athlete81);
            athleteRepository.Save(athlete82);
            athleteRepository.Save(athlete83);
            athleteRepository.Save(athlete84);
            athleteRepository.Save(athlete85);
            athleteRepository.Save(athlete86);
            athleteRepository.Save(athlete87);
            athleteRepository.Save(athlete88);
            athleteRepository.Save(athlete89);
            athleteRepository.Save(athlete90);
            athleteRepository.Save(athlete91);
            athleteRepository.Save(athlete92);
            athleteRepository.Save(athlete93);
            athleteRepository.Save(athlete94);
            athleteRepository.Save(athlete95);
            athleteRepository.Save(athlete96);
            athleteRepository.Save(athlete97);
            #endregion

            #region Models
            var model1 = new Model() { ModelNumber = "524395-386", ModelName = "Air Pegasus+ 29 Trail", Type = "Running", Price = 105, Color = "Silver Sage/Team Red/University Red/Total Orange", IsDiscontinued = false };
            var model2 = new Model() { ModelNumber = "524395-038", ModelName = "Air Pegasus+ 29 Trail", Type = "Running", Price = 105, Color = "Cool Grey/Total Orange/Signal Blue/Electric Green", IsDiscontinued = false };
            var model3 = new Model() { ModelNumber = "524950-007", ModelName = "Air Pegasus+ 29", Type = "Running", Price = 100, Color = "Wolf Grey/Volt/Black", IsDiscontinued = false };
            var model4 = new Model() { ModelNumber = "524950-700", ModelName = "Air Pegasus+ 29", Type = "Running", Price = 100, Color = "Volt/Dark Grey/Pure Platinum/Black", IsDiscontinued = false };
            var model5 = new Model() { ModelNumber = "524950-800", ModelName = "Air Pegasus+ 29", Type = "Running", Price = 100, Color = "Total Orange/Dark Grey/Pure Platinum/Black", IsDiscontinued = false };
            var model6 = new Model() { ModelNumber = "524950-004", ModelName = "Air Pegasus+ 29", Type = "Running", Price = 100, Color = "Black/Black", IsDiscontinued = false };
            var model7 = new Model() { ModelNumber = "530985-007", ModelName = "Air Pegasus+ 29 (WIDE)", Type = "Running", Price = 100, Color = "Wolf Grey/Volt/Black", IsDiscontinued = false };
            var model8 = new Model() { ModelNumber = "530984-007", ModelName = "Air Pegasus+ 29 (NARROW)", Type = "Running", Price = 100, Color = "Wolf Grey/Volt/Black", IsDiscontinued = false };
            var model9 = new Model() { ModelNumber = "524951-007", ModelName = "Air Pegasus+ 29 (4E)", Type = "Running", Price = 100, Color = "Wolf Grey/Volt/Black", IsDiscontinued = false };

            modelRepository.Save(model1);
            modelRepository.Save(model2);
            modelRepository.Save(model3);
            modelRepository.Save(model4);
            modelRepository.Save(model5);
            modelRepository.Save(model6);
            modelRepository.Save(model7);
            modelRepository.Save(model8);
            modelRepository.Save(model9);
            #endregion

            #region Inventory Items
            //var inventoryItem1 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete7, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 8, 18, 11, 26, 13)};
            //var inventoryItem2 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 2, 16, 11, 4, 23) };
            //var inventoryItem3 = new InventoryItem() { Model = model7, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete93, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 26, 8, 16, 22) };
            //var inventoryItem4 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete2, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 12, 28, 15, 3, 13) };
            //var inventoryItem5 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 1, 12, 22, 49, 55) };
            //var inventoryItem6 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete61, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 9, 18, 10, 59, 31) };
            //var inventoryItem7 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 5, 21, 21, 45, 33) };
            //var inventoryItem8 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete59, RequestName = "request1", Status = Constants.Inventory.RECORDED_AS_LOST, StatusLastChanged = new DateTime(2012, 1, 19, 2, 50, 54) };
            //var inventoryItem9 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 3, 16, 58, 1) };
            //var inventoryItem10 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 8, 2, 1, 5, 13) };
            //var inventoryItem11 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete83, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 5, 28, 21, 22, 44) };
            //var inventoryItem12 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete2, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 6, 9, 11, 22, 22) };
            //var inventoryItem13 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 8, 25, 7, 31, 0) };
            //var inventoryItem14 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 11, 13, 7, 3, 21) };
            //var inventoryItem15 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete6, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 10, 28, 9, 10, 26) };
            //var inventoryItem16 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete46, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 1, 28, 4, 25, 9) };
            //var inventoryItem17 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 4, 9, 11, 10, 45) };
            //var inventoryItem18 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete22, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 10, 24, 20, 45, 36) };
            //var inventoryItem19 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 9, 19, 21, 51, 42) };
            //var inventoryItem20 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete3, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 4, 12, 10, 46, 39) };
            //var inventoryItem21 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete73, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 2, 12, 18, 43, 26) };
            //var inventoryItem22 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete68, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 9, 11, 22, 24, 20) };
            //var inventoryItem23 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete15, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 4, 7, 11, 25, 47) };
            //var inventoryItem24 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 3, 18, 0, 3, 45) };
            //var inventoryItem25 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete79, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 11, 7, 19, 58, 55) };
            //var inventoryItem26 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete65, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 7, 1, 20, 18, 50) };
            //var inventoryItem27 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete74, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 11, 25, 4, 52, 14) };
            //var inventoryItem28 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete3, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 7, 25, 14, 48, 50) };
            //var inventoryItem29 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete25, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 1, 15, 17, 37, 50) };
            //var inventoryItem30 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 11, 1, 15, 29, 22) };
            //var inventoryItem31 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete52, RequestName = "request1", Status = Constants.Inventory.RECORDED_AS_LOST, StatusLastChanged = new DateTime(2012, 4, 7, 10, 39, 25) };
            //var inventoryItem32 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete57, RequestName = "request1", Status = Constants.Inventory.RECORDED_AS_LOST, StatusLastChanged = new DateTime(2012, 4, 21, 20, 2, 57) };
            //var inventoryItem33 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete56, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 11, 4, 6, 50, 47) };
            //var inventoryItem34 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete43, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 6, 23, 4, 41, 8) };
            //var inventoryItem35 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete45, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 3, 27, 13, 47, 22) };
            //var inventoryItem36 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 9, 18, 8, 47, 32) };
            //var inventoryItem37 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete80, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 1, 25, 7, 54, 35) };
            //var inventoryItem38 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete43, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 10, 5, 8, 27, 17) };
            //var inventoryItem39 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete14, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 9, 8, 0, 36) };
            //var inventoryItem40 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete51, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 15, 2, 46, 45) };
            //var inventoryItem41 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 14, 23, 56, 38) };
            //var inventoryItem42 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete27, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 18, 2, 58, 45) };
            //var inventoryItem43 = new InventoryItem() { Model = model8, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 14, 14, 26, 29) };
            //var inventoryItem44 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete52, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 5, 19, 48, 26) };
            //var inventoryItem45 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete46, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 12, 6, 1, 46) };
            //var inventoryItem46 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 15, 23, 54, 7) };
            //var inventoryItem47 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete80, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 27, 16, 15, 30) };
            //var inventoryItem48 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 5, 4, 46, 15) };
            //var inventoryItem49 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete54, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 18, 7, 38, 28) };
            //var inventoryItem50 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete21, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 9, 10, 22, 11) };
            //var inventoryItem51 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete92, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 24, 18, 29, 34) };
            //var inventoryItem52 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete17, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 15, 12, 13, 53) };
            //var inventoryItem53 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete51, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 16, 11, 11, 46) };
            //var inventoryItem54 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 23, 20, 14, 59) };
            //var inventoryItem55 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete18, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 7, 1, 36, 0) };
            //var inventoryItem56 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete71, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 6, 13, 25, 45) };
            //var inventoryItem57 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete47, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 12, 5, 33, 44) };
            //var inventoryItem58 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 2, 14, 27, 42) };
            //var inventoryItem59 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 14, 17, 17, 59) };
            //var inventoryItem60 = new InventoryItem() { Model = model9, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete89, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 6, 19, 23, 10) };
            //var inventoryItem61 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete94, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 26, 21, 48, 33) };
            //var inventoryItem62 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete36, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 15, 17, 2, 22) };
            //var inventoryItem63 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 5, 21, 8, 13) };
            //var inventoryItem64 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete48, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 6, 18, 18, 56) };
            //var inventoryItem65 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete92, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 4, 4, 24, 22) };
            //var inventoryItem66 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete64, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 15, 16, 19, 40) };
            //var inventoryItem67 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete77, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 1, 24, 23, 53, 19) };
            //var inventoryItem68 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete42, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 10, 14, 11, 47, 43) };
            //var inventoryItem69 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete51, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 11, 12, 21, 7, 54) };
            //var inventoryItem70 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete57, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 2, 14, 23, 42, 36) };
            //var inventoryItem71 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete5, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 7, 14, 10, 42, 16) };
            //var inventoryItem72 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete93, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 2, 1, 11, 12, 17) };
            //var inventoryItem73 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 11, 25, 12, 5, 17) };
            //var inventoryItem74 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete37, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 11, 20, 9, 41, 32) };
            //var inventoryItem75 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 5, 9, 12, 2, 12) };
            //var inventoryItem76 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete14, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 1, 8, 23, 17, 45) };
            //var inventoryItem77 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 8, 14, 9, 42, 32) };
            //var inventoryItem78 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete33, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 1, 6, 22, 44, 2) };
            //var inventoryItem79 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 9, 19, 18, 55, 22) };
            //var inventoryItem80 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete73, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 16, 23, 31, 15) };
            //var inventoryItem81 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 14, 18, 42, 11) };
            //var inventoryItem82 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete2, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 17, 0, 2, 53) };
            //var inventoryItem83 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete75, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 13, 0, 34, 29) };
            //var inventoryItem84 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete86, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 22, 19, 50, 21) };
            //var inventoryItem85 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete37, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 26, 14, 31, 47) };
            //var inventoryItem86 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 22, 9, 15, 24) };
            //var inventoryItem87 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete76, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 11, 9, 8, 49) };
            //var inventoryItem88 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete42, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 28, 16, 56, 43) };
            //var inventoryItem89 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete6, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 1, 21, 21, 54) };
            //var inventoryItem90 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete6, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 8, 6, 28, 6) };
            //var inventoryItem91 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete28, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 16, 0, 12, 24) };
            //var inventoryItem92 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete94, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 1, 14, 55, 5) };
            //var inventoryItem93 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete97, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 8, 3, 5, 29, 16) };
            //var inventoryItem94 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 7, 22, 22, 6, 25) };
            //var inventoryItem95 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 6, 6, 17, 44, 41) };
            //var inventoryItem96 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete71, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 7, 8, 17, 47, 1) };
            //var inventoryItem97 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 23, 23, 7, 57) };
            //var inventoryItem98 = new InventoryItem() { Model = model4, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete74, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 6, 20, 5, 10) };
            //var inventoryItem99 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete41, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 4, 4, 36, 21) };
            //var inventoryItem100 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete56, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 23, 23, 27, 39) };
            //var inventoryItem101 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete90, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 15, 22, 36, 27) };
            //var inventoryItem102 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete22, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 5, 10, 34, 18) };
            //var inventoryItem103 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete72, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 21, 2, 47, 37) };
            //var inventoryItem104 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 10, 22, 59, 43) };
            //var inventoryItem105 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete67, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 9, 10, 30, 56) };
            //var inventoryItem106 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete39, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 27, 1, 49, 27) };
            //var inventoryItem107 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 27, 5, 49, 45) };
            //var inventoryItem108 = new InventoryItem() { Model = model9, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete21, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 15, 13, 51, 27) };
            //var inventoryItem109 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete14, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 14, 2, 40, 58) };
            //var inventoryItem110 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete61, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 15, 15, 14, 21) };
            //var inventoryItem111 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete94, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 18, 0, 14, 8) };
            //var inventoryItem112 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 15, 6, 57, 8) };
            //var inventoryItem113 = new InventoryItem() { Model = model4, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 4, 21, 20, 28) };
            //var inventoryItem114 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 6, 10, 27, 51) };
            //var inventoryItem115 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete36, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 23, 21, 31, 46) };
            //var inventoryItem116 = new InventoryItem() { Model = model8, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete53, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 28, 18, 33, 43) };
            //var inventoryItem117 = new InventoryItem() { Model = model7, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete74, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 22, 13, 2, 53) };
            //var inventoryItem118 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 25, 2, 48, 28) };
            //var inventoryItem119 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 3, 23, 21, 16) };
            //var inventoryItem120 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete84, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 1, 20, 55, 21) };
            //var inventoryItem121 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 2, 10, 39, 19) };
            //var inventoryItem122 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete1, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 11, 14, 44, 3) };
            //var inventoryItem123 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 6, 22, 43, 32) };
            //var inventoryItem124 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete78, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 14, 2, 18, 25) };
            //var inventoryItem125 = new InventoryItem() { Model = model8, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 19, 21, 4, 31) };
            //var inventoryItem126 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete60, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 27, 13, 18, 22) };
            //var inventoryItem127 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete57, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 24, 7, 1, 42) };
            //var inventoryItem128 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete88, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 15, 5, 29, 22) };
            //var inventoryItem129 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete52, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 26, 11, 57, 7) };
            //var inventoryItem130 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete88, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 16, 10, 54, 1) };
            //var inventoryItem131 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete30, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 14, 20, 49, 58) };
            //var inventoryItem132 = new InventoryItem() { Model = model8, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete40, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 25, 13, 47, 28) };
            //var inventoryItem133 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 8, 16, 58, 16) };
            //var inventoryItem134 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete84, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 19, 13, 56, 26) };
            //var inventoryItem135 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete46, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 19, 3, 43, 30) };
            //var inventoryItem136 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete86, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 24, 5, 56, 37) };
            //var inventoryItem137 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 1, 8, 12, 51) };
            //var inventoryItem138 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete3, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 1, 6, 7, 39, 2) };
            //var inventoryItem139 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete40, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 11, 11, 19, 38, 17) };
            //var inventoryItem140 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete14, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 6, 6, 3, 5, 2) };
            //var inventoryItem141 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 10, 17, 5, 0, 29) };
            //var inventoryItem142 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete78, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 9, 24, 12, 26, 12) };
            //var inventoryItem143 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 12, 21, 18, 5, 56) };
            //var inventoryItem144 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete43, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 4, 18, 40, 4) };
            //var inventoryItem145 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 21, 7, 22, 16) };
            //var inventoryItem146 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete36, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 6, 14, 58, 54) };
            //var inventoryItem147 = new InventoryItem() { Model = model4, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete35, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 25, 11, 23, 57) };
            //var inventoryItem148 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 28, 9, 26, 35) };
            //var inventoryItem149 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete34, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 27, 8, 59, 31) };
            //var inventoryItem150 = new InventoryItem() { Model = model8, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 25, 13, 39, 20) };
            //var inventoryItem151 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 16, 0, 27, 3) };
            //var inventoryItem152 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete96, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 24, 12, 14, 52) };
            //var inventoryItem153 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete42, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 2, 14, 2, 39) };
            //var inventoryItem154 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete40, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 6, 10, 2, 44) };
            //var inventoryItem155 = new InventoryItem() { Model = model8, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete47, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 17, 1, 3, 51) };
            //var inventoryItem156 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 16, 11, 49, 0) };
            //var inventoryItem157 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete17, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 23, 1, 25, 28) };
            //var inventoryItem158 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete70, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 27, 16, 40, 42) };
            //var inventoryItem159 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 22, 7, 1, 36) };
            //var inventoryItem160 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete85, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 15, 13, 51, 7) };
            //var inventoryItem161 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete49, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 5, 19, 42, 38) };
            //var inventoryItem162 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete18, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 22, 1, 41, 9) };
            //var inventoryItem163 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 22, 10, 30, 14) };
            //var inventoryItem164 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete61, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 20, 9, 38, 5) };
            //var inventoryItem165 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete60, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 4, 5, 28, 20) };
            //var inventoryItem166 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 4, 14, 39, 16) };
            //var inventoryItem167 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete86, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 17, 5, 51, 57) };
            //var inventoryItem168 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 24, 17, 3, 5) };
            //var inventoryItem169 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 3, 6, 35, 25) };
            //var inventoryItem170 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete48, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 4, 4, 3, 22) };
            //var inventoryItem171 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 28, 14, 58, 46) };
            //var inventoryItem172 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete80, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 2, 19, 45, 44) };
            //var inventoryItem173 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 1, 23, 17, 26) };
            //var inventoryItem174 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 5, 8, 53, 43) };
            //var inventoryItem175 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete29, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 11, 20, 3, 47) };
            //var inventoryItem176 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete93, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 27, 0, 55, 33) };
            //var inventoryItem177 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete70, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 11, 2, 51, 52) };
            //var inventoryItem178 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete29, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 28, 19, 30, 14) };
            //var inventoryItem179 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete7, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 1, 21, 35, 0) };
            //var inventoryItem180 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 20, 21, 41, 24) };
            //var inventoryItem181 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete6, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 3, 6, 15, 44) };
            //var inventoryItem182 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete73, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 17, 6, 11, 5) };
            //var inventoryItem183 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 16, 7, 16, 39) };
            //var inventoryItem184 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete37, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 7, 3, 54, 11) };
            //var inventoryItem185 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete78, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 17, 20, 59, 39) };
            //var inventoryItem186 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 24, 17, 33, 7) };
            //var inventoryItem187 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete57, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 7, 20, 23, 11, 31) };
            //var inventoryItem188 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete73, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 4, 25, 10, 4, 28) };
            //var inventoryItem189 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete74, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 2, 8, 2, 4, 56) };
            //var inventoryItem190 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete41, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 3, 6, 5, 1, 57) };
            //var inventoryItem191 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete40, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 4, 2, 9, 9, 32) };
            //var inventoryItem192 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 10, 7, 6, 56, 35) };
            //var inventoryItem193 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete72, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 10, 5, 16, 39, 21) };
            //var inventoryItem194 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete50, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 13, 6, 47, 12) };
            //var inventoryItem195 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete81, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 16, 2, 56, 14) };
            //var inventoryItem196 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete10, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 24, 17, 15, 52) };
            //var inventoryItem197 = new InventoryItem() { Model = model9, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete72, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 21, 13, 3, 20) };
            //var inventoryItem198 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete54, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 4, 4, 12, 4) };
            //var inventoryItem199 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete39, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 8, 17, 30, 35) };
            //var inventoryItem200 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete50, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 1, 23, 24, 9) };
            //var inventoryItem201 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete10, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 8, 7, 15, 29) };
            //var inventoryItem202 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete6, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 17, 8, 50, 51) };
            //var inventoryItem203 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete25, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 15, 15, 15, 22) };
            //var inventoryItem204 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete87, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 28, 5, 7, 18) };
            //var inventoryItem205 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 5, 11, 1, 16) };
            //var inventoryItem206 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete6, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 28, 19, 27, 41) };
            //var inventoryItem207 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete89, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 3, 1, 12, 56) };
            //var inventoryItem208 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete30, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 8, 7, 53, 34) };
            //var inventoryItem209 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete51, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 25, 12, 1, 10) };
            //var inventoryItem210 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete86, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 1, 1, 14, 58) };
            //var inventoryItem211 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete13, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 26, 14, 48, 17) };
            //var inventoryItem212 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete16, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 28, 21, 12, 30) };
            //var inventoryItem213 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete39, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 21, 23, 25, 48) };
            //var inventoryItem214 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete41, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 21, 6, 29, 40) };
            //var inventoryItem215 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete63, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 4, 22, 36, 42) };
            //var inventoryItem216 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete49, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 12, 6, 5, 37) };
            //var inventoryItem217 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 7, 6, 37, 7) };
            //var inventoryItem218 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete92, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 15, 13, 43, 16) };
            //var inventoryItem219 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete51, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 17, 3, 17, 48) };
            //var inventoryItem220 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 15, 18, 28, 15) };
            //var inventoryItem221 = new InventoryItem() { Model = model9, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete45, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 17, 18, 39, 7) };
            //var inventoryItem222 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 1, 11, 59, 52) };
            //var inventoryItem223 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete51, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 15, 3, 46, 27) };
            //var inventoryItem224 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete17, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 14, 7, 40, 13) };
            //var inventoryItem225 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete66, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 7, 1, 38, 43) };
            //var inventoryItem226 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete66, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 16, 21, 18, 42) };
            //var inventoryItem227 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete56, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 27, 18, 47, 38) };
            //var inventoryItem228 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 4, 8, 29, 8) };
            //var inventoryItem229 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete16, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 7, 11, 53, 19) };
            //var inventoryItem230 = new InventoryItem() { Model = model8, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete97, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 26, 2, 54, 53) };
            //var inventoryItem231 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete28, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 20, 19, 59, 41) };
            //var inventoryItem232 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete1, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 20, 3, 38, 39) };
            //var inventoryItem233 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 21, 3, 26, 13) };
            //var inventoryItem234 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 14, 6, 14, 50) };
            //var inventoryItem235 = new InventoryItem() { Model = model9, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete75, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 13, 5, 59, 13) };
            //var inventoryItem236 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete66, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 18, 17, 42, 19) };
            //var inventoryItem237 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete33, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 3, 3, 1, 35) };
            //var inventoryItem238 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete29, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 25, 22, 3, 17) };
            //var inventoryItem239 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 13, 7, 13, 39) };
            //var inventoryItem240 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete66, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 11, 20, 21, 22) };
            //var inventoryItem241 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 14, 19, 20, 14) };
            //var inventoryItem242 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete88, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 7, 17, 58, 18) };
            //var inventoryItem243 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete15, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 6, 12, 38, 33) };
            //var inventoryItem244 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 18, 22, 38, 39) };
            //var inventoryItem245 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 6, 15, 57, 6) };
            //var inventoryItem246 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete27, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 17, 1, 3, 23) };
            //var inventoryItem247 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 8, 9, 51, 6) };
            //var inventoryItem248 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete73, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 18, 12, 3, 40) };
            //var inventoryItem249 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete71, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 28, 15, 4, 11) };

            var inventoryItem1 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete65, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 4, 2, 4, 15, 4), EventAreaAssignment = athlete65.EventAreas.ElementAt(0) };
            var inventoryItem2 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete30, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 1, 15, 20, 45, 56), EventAreaAssignment = athlete30.EventAreas.ElementAt(0) };
            var inventoryItem3 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete66, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 4, 11, 22, 21), EventAreaAssignment = athlete66.EventAreas.ElementAt(0) };
            var inventoryItem4 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete50, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 8, 17, 0, 5, 53), EventAreaAssignment = athlete50.EventAreas.ElementAt(0) };
            var inventoryItem5 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 10, 27, 1, 5, 40), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem6 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 11, 20, 21, 37, 53), EventAreaAssignment = athlete11.EventAreas.ElementAt(0) };
            var inventoryItem7 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 7, 19, 15, 15, 18), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem8 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete62, RequestName = "request1", Status = Constants.Inventory.RECORDED_AS_LOST, StatusLastChanged = new DateTime(2012, 10, 3, 9, 15, 18), EventAreaAssignment = athlete62.EventAreas.ElementAt(0) };
            var inventoryItem9 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete14, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 13, 12, 18, 44), EventAreaAssignment = athlete14.EventAreas.ElementAt(0) };
            var inventoryItem10 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete46, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 11, 4, 22, 24, 6), EventAreaAssignment = athlete46.EventAreas.ElementAt(0) };
            var inventoryItem11 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete70, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 5, 4, 17, 14, 3), EventAreaAssignment = athlete70.EventAreas.ElementAt(0) };
            var inventoryItem12 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete42, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 1, 26, 21, 38, 4), EventAreaAssignment = athlete42.EventAreas.ElementAt(0) };
            var inventoryItem13 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 9, 2, 11, 5, 12), EventAreaAssignment = athlete24.EventAreas.ElementAt(0) };
            var inventoryItem14 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete49, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 7, 7, 2, 14, 48), EventAreaAssignment = athlete49.EventAreas.ElementAt(0) };
            var inventoryItem15 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete78, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 7, 27, 17, 19, 44), EventAreaAssignment = athlete78.EventAreas.ElementAt(0) };
            var inventoryItem16 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 8, 5, 6, 38, 12), EventAreaAssignment = athlete9.EventAreas.ElementAt(0) };
            var inventoryItem17 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete91, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 8, 4, 19, 20, 27), EventAreaAssignment = athlete91.EventAreas.ElementAt(0) };
            var inventoryItem18 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete7, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 5, 1, 5, 44, 45), EventAreaAssignment = athlete7.EventAreas.ElementAt(0) };
            var inventoryItem19 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete71, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 4, 11, 20, 23, 10), EventAreaAssignment = athlete71.EventAreas.ElementAt(0) };
            var inventoryItem20 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 4, 25, 18, 2, 56), EventAreaAssignment = athlete19.EventAreas.ElementAt(0) };
            var inventoryItem21 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete42, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 1, 9, 3, 6, 14), EventAreaAssignment = athlete42.EventAreas.ElementAt(0) };
            var inventoryItem22 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete54, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 12, 14, 18, 25, 13), EventAreaAssignment = athlete54.EventAreas.ElementAt(0) };
            var inventoryItem23 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 11, 1, 9, 11, 37), EventAreaAssignment = athlete20.EventAreas.ElementAt(0) };
            var inventoryItem24 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete26, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 9, 19, 11, 16, 45), EventAreaAssignment = athlete26.EventAreas.ElementAt(0) };
            var inventoryItem25 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 1, 24, 5, 4, 58), EventAreaAssignment = athlete20.EventAreas.ElementAt(0) };
            var inventoryItem26 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete85, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 5, 18, 9, 39, 19), EventAreaAssignment = athlete85.EventAreas.ElementAt(0) };
            var inventoryItem27 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete77, RequestName = "request1", Status = Constants.Inventory.REQUESTED, StatusLastChanged = new DateTime(2012, 2, 5, 20, 7, 47), EventAreaAssignment = athlete77.EventAreas.ElementAt(0) };
            var inventoryItem28 = new InventoryItem() { Model = model6, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete52, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 5, 3, 22, 26, 56), EventAreaAssignment = athlete52.EventAreas.ElementAt(0) };
            var inventoryItem29 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete68, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 12, 4, 10, 23, 9), EventAreaAssignment = athlete68.EventAreas.ElementAt(0) };
            var inventoryItem30 = new InventoryItem() { Model = model7, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete96, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 6, 25, 14, 22, 10), EventAreaAssignment = athlete96.EventAreas.ElementAt(0) };
            var inventoryItem31 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete70, RequestName = "request1", Status = Constants.Inventory.RECORDED_AS_LOST, StatusLastChanged = new DateTime(2012, 4, 22, 5, 31, 40), EventAreaAssignment = athlete70.EventAreas.ElementAt(0) };
            var inventoryItem32 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete28, RequestName = "request1", Status = Constants.Inventory.RECORDED_AS_LOST, StatusLastChanged = new DateTime(2012, 6, 8, 1, 51, 7), EventAreaAssignment = athlete28.EventAreas.ElementAt(0) };
            var inventoryItem33 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete29, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 2, 25, 6, 19, 39), EventAreaAssignment = athlete29.EventAreas.ElementAt(0) };
            var inventoryItem34 = new InventoryItem() { Model = model9, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete27, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 8, 4, 1, 46, 3), EventAreaAssignment = athlete27.EventAreas.ElementAt(0) };
            var inventoryItem35 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete91, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 6, 23, 2, 26, 24), EventAreaAssignment = athlete91.EventAreas.ElementAt(0) };
            var inventoryItem36 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete43, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 1, 8, 15, 42, 46), EventAreaAssignment = athlete43.EventAreas.ElementAt(0) };
            var inventoryItem37 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete88, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 12, 10, 8, 2, 5), EventAreaAssignment = athlete88.EventAreas.ElementAt(0) };
            var inventoryItem38 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete71, RequestName = "request1", Status = Constants.Inventory.RETURNED, StatusLastChanged = new DateTime(2012, 1, 10, 1, 52, 15), EventAreaAssignment = athlete71.EventAreas.ElementAt(0) };
            var inventoryItem39 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete18, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 2, 1, 37, 56), EventAreaAssignment = athlete18.EventAreas.ElementAt(0) };
            var inventoryItem40 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 25, 8, 59, 57), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem41 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete30, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 14, 17, 25, 48), EventAreaAssignment = athlete30.EventAreas.ElementAt(0) };
            var inventoryItem42 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete13, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 26, 11, 6, 36), EventAreaAssignment = athlete13.EventAreas.ElementAt(0) };
            var inventoryItem43 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete73, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 23, 15, 26, 0), EventAreaAssignment = athlete73.EventAreas.ElementAt(0) };
            var inventoryItem44 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete10, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 14, 23, 29, 28), EventAreaAssignment = athlete10.EventAreas.ElementAt(0) };
            var inventoryItem45 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete57, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 25, 8, 2, 28), EventAreaAssignment = athlete57.EventAreas.ElementAt(0) };
            var inventoryItem46 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete62, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 14, 17, 13, 22), EventAreaAssignment = athlete62.EventAreas.ElementAt(0) };
            var inventoryItem47 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 14, 12, 31, 4), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem48 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete75, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 10, 1, 57, 40), EventAreaAssignment = athlete75.EventAreas.ElementAt(0) };
            var inventoryItem49 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete29, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 1, 14, 56, 34), EventAreaAssignment = athlete29.EventAreas.ElementAt(0) };
            var inventoryItem50 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 24, 9, 20, 21), EventAreaAssignment = athlete24.EventAreas.ElementAt(0) };
            var inventoryItem51 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete43, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 7, 11, 56, 13), EventAreaAssignment = athlete43.EventAreas.ElementAt(0) };
            var inventoryItem52 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 12, 4, 25, 14), EventAreaAssignment = athlete8.EventAreas.ElementAt(0) };
            var inventoryItem53 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete62, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 25, 17, 21, 35), EventAreaAssignment = athlete62.EventAreas.ElementAt(0) };
            var inventoryItem54 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete56, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 1, 2, 24, 25), EventAreaAssignment = athlete56.EventAreas.ElementAt(0) };
            var inventoryItem55 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete47, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 22, 15, 7, 7), EventAreaAssignment = athlete47.EventAreas.ElementAt(0) };
            var inventoryItem56 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete12, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 16, 17, 5, 44), EventAreaAssignment = athlete12.EventAreas.ElementAt(0) };
            var inventoryItem57 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete68, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 26, 16, 58, 24), EventAreaAssignment = athlete68.EventAreas.ElementAt(0) };
            var inventoryItem58 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete15, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 1, 14, 25, 9), EventAreaAssignment = athlete15.EventAreas.ElementAt(0) };
            var inventoryItem59 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete88, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 24, 12, 46, 18), EventAreaAssignment = athlete88.EventAreas.ElementAt(0) };
            var inventoryItem60 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 22, 14, 59, 43), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem61 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 3, 21, 56, 7), EventAreaAssignment = athlete38.EventAreas.ElementAt(0) };
            var inventoryItem62 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete67, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 20, 22, 16, 37), EventAreaAssignment = athlete67.EventAreas.ElementAt(0) };
            var inventoryItem63 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete33, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 19, 14, 40, 24), EventAreaAssignment = athlete33.EventAreas.ElementAt(0) };
            var inventoryItem64 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete63, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 27, 15, 34, 20), EventAreaAssignment = athlete63.EventAreas.ElementAt(0) };
            var inventoryItem65 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete78, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 12, 16, 37, 24), EventAreaAssignment = athlete78.EventAreas.ElementAt(0) };
            var inventoryItem66 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete40, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 23, 17, 10, 49), EventAreaAssignment = athlete40.EventAreas.ElementAt(0) };
            var inventoryItem67 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete91, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 2, 4, 3, 10, 31), EventAreaAssignment = athlete91.EventAreas.ElementAt(0) };
            var inventoryItem68 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete54, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 1, 23, 21, 1, 14), EventAreaAssignment = athlete54.EventAreas.ElementAt(0) };
            var inventoryItem69 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete58, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 6, 13, 18, 16, 32), EventAreaAssignment = athlete58.EventAreas.ElementAt(0) };
            var inventoryItem70 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete17, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 12, 25, 1, 58, 51), EventAreaAssignment = athlete17.EventAreas.ElementAt(0) };
            var inventoryItem71 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete66, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 8, 21, 8, 28, 49), EventAreaAssignment = athlete66.EventAreas.ElementAt(0) };
            var inventoryItem72 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 2, 1, 1, 23, 22), EventAreaAssignment = athlete9.EventAreas.ElementAt(0) };
            var inventoryItem73 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete32, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 5, 26, 7, 10, 32), EventAreaAssignment = athlete32.EventAreas.ElementAt(0) };
            var inventoryItem74 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete83, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 3, 16, 15, 1, 46), EventAreaAssignment = athlete83.EventAreas.ElementAt(0) };
            var inventoryItem75 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete34, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 7, 4, 17, 9, 6), EventAreaAssignment = athlete34.EventAreas.ElementAt(0) };
            var inventoryItem76 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete33, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 2, 14, 23, 8, 46), EventAreaAssignment = athlete33.EventAreas.ElementAt(0) };
            var inventoryItem77 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 12, 18, 1, 22, 59), EventAreaAssignment = athlete20.EventAreas.ElementAt(0) };
            var inventoryItem78 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete52, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 10, 9, 13, 11, 49), EventAreaAssignment = athlete52.EventAreas.ElementAt(0) };
            var inventoryItem79 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete84, RequestName = "request1", Status = Constants.Inventory.DISTRIBUTED, StatusLastChanged = new DateTime(2012, 2, 7, 4, 11, 59), EventAreaAssignment = athlete84.EventAreas.ElementAt(0) };
            var inventoryItem80 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 24, 2, 46, 56), EventAreaAssignment = athlete20.EventAreas.ElementAt(0) };
            var inventoryItem81 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete32, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 11, 23, 59, 24), EventAreaAssignment = athlete32.EventAreas.ElementAt(0) };
            var inventoryItem82 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete94, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 9, 19, 29, 8), EventAreaAssignment = athlete94.EventAreas.ElementAt(0) };
            var inventoryItem83 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete58, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 7, 4, 46, 6), EventAreaAssignment = athlete58.EventAreas.ElementAt(0) };
            var inventoryItem84 = new InventoryItem() { Model = model4, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 21, 19, 19, 6), EventAreaAssignment = athlete8.EventAreas.ElementAt(0) };
            var inventoryItem85 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete30, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 21, 1, 55, 49), EventAreaAssignment = athlete30.EventAreas.ElementAt(0) };
            var inventoryItem86 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete7, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 3, 22, 48, 6), EventAreaAssignment = athlete7.EventAreas.ElementAt(0) };
            var inventoryItem87 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete35, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 3, 16, 15, 27), EventAreaAssignment = athlete35.EventAreas.ElementAt(0) };
            var inventoryItem88 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete45, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 6, 21, 53, 55), EventAreaAssignment = athlete45.EventAreas.ElementAt(0) };
            var inventoryItem89 = new InventoryItem() { Model = model5, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete13, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 18, 17, 19, 13), EventAreaAssignment = athlete13.EventAreas.ElementAt(0) };
            var inventoryItem90 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete84, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 2, 1, 13, 41), EventAreaAssignment = athlete84.EventAreas.ElementAt(0) };
            var inventoryItem91 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete40, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 28, 7, 18, 33), EventAreaAssignment = athlete40.EventAreas.ElementAt(0) };
            var inventoryItem92 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 6, 12, 16, 41), EventAreaAssignment = athlete95.EventAreas.ElementAt(0) };
            var inventoryItem93 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete97, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 9, 25, 22, 23, 34), EventAreaAssignment = athlete97.EventAreas.ElementAt(0) };
            var inventoryItem94 = new InventoryItem() { Model = model4, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 1, 25, 22, 14, 46), EventAreaAssignment = athlete69.EventAreas.ElementAt(0) };
            var inventoryItem95 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete37, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 2, 24, 15, 57, 40), EventAreaAssignment = athlete37.EventAreas.ElementAt(0) };
            var inventoryItem96 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete82, RequestName = "request1", Status = Constants.Inventory.ORDERED, StatusLastChanged = new DateTime(2012, 6, 12, 2, 17, 46), EventAreaAssignment = athlete82.EventAreas.ElementAt(0) };
            var inventoryItem97 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete66, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 4, 8, 22, 42), EventAreaAssignment = athlete66.EventAreas.ElementAt(0) };
            var inventoryItem98 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete22, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 5, 16, 57, 21), EventAreaAssignment = athlete22.EventAreas.ElementAt(0) };
            var inventoryItem99 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 22, 21, 39, 8), EventAreaAssignment = athlete19.EventAreas.ElementAt(0) };
            var inventoryItem100 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete16, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 5, 15, 14, 51), EventAreaAssignment = athlete16.EventAreas.ElementAt(0) };
            var inventoryItem101 = new InventoryItem() { Model = model4, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete32, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 16, 10, 32, 49), EventAreaAssignment = athlete32.EventAreas.ElementAt(0) };
            var inventoryItem102 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete57, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 15, 2, 52, 21), EventAreaAssignment = athlete57.EventAreas.ElementAt(0) };
            var inventoryItem103 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 27, 3, 30, 47), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem104 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete51, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 8, 6, 46, 57), EventAreaAssignment = athlete51.EventAreas.ElementAt(0) };
            var inventoryItem105 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete70, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 13, 16, 0, 16), EventAreaAssignment = athlete70.EventAreas.ElementAt(0) };
            var inventoryItem106 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete2, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 28, 14, 51, 15), EventAreaAssignment = athlete2.EventAreas.ElementAt(0) };
            var inventoryItem107 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 27, 7, 36, 41), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem108 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 15, 1, 13, 11), EventAreaAssignment = athlete9.EventAreas.ElementAt(0) };
            var inventoryItem109 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 22, 17, 17, 15), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem110 = new InventoryItem() { Model = model8, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete3, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 19, 23, 27, 13), EventAreaAssignment = athlete3.EventAreas.ElementAt(0) };
            var inventoryItem111 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete82, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 16, 3, 2, 43), EventAreaAssignment = athlete82.EventAreas.ElementAt(0) };
            var inventoryItem112 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete49, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 23, 3, 59, 25), EventAreaAssignment = athlete49.EventAreas.ElementAt(0) };
            var inventoryItem113 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete17, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 27, 10, 59, 50), EventAreaAssignment = athlete17.EventAreas.ElementAt(0) };
            var inventoryItem114 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete25, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 1, 2, 52, 58), EventAreaAssignment = athlete25.EventAreas.ElementAt(0) };
            var inventoryItem115 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete13, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 26, 20, 44, 52), EventAreaAssignment = athlete13.EventAreas.ElementAt(0) };
            var inventoryItem116 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete64, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 2, 1, 26, 24), EventAreaAssignment = athlete64.EventAreas.ElementAt(0) };
            var inventoryItem117 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete7, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 5, 22, 51, 35), EventAreaAssignment = athlete7.EventAreas.ElementAt(0) };
            var inventoryItem118 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 10, 14, 55, 32), EventAreaAssignment = athlete24.EventAreas.ElementAt(0) };
            var inventoryItem119 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete7, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 4, 17, 11, 37), EventAreaAssignment = athlete7.EventAreas.ElementAt(0) };
            var inventoryItem120 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete78, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 5, 6, 59, 49), EventAreaAssignment = athlete78.EventAreas.ElementAt(0) };
            var inventoryItem121 = new InventoryItem() { Model = model7, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete58, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 9, 21, 34, 29), EventAreaAssignment = athlete58.EventAreas.ElementAt(0) };
            var inventoryItem122 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete34, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 26, 15, 38, 9), EventAreaAssignment = athlete34.EventAreas.ElementAt(0) };
            var inventoryItem123 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete28, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 20, 2, 22, 1), EventAreaAssignment = athlete28.EventAreas.ElementAt(0) };
            var inventoryItem124 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete57, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 11, 10, 48, 9), EventAreaAssignment = athlete57.EventAreas.ElementAt(0) };
            var inventoryItem125 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 19, 5, 4, 47), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem126 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 26, 14, 38, 48), EventAreaAssignment = athlete9.EventAreas.ElementAt(0) };
            var inventoryItem127 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete23, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 27, 5, 24, 36), EventAreaAssignment = athlete23.EventAreas.ElementAt(0) };
            var inventoryItem128 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete70, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 14, 10, 6, 17), EventAreaAssignment = athlete70.EventAreas.ElementAt(0) };
            var inventoryItem129 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 4, 3, 56, 44), EventAreaAssignment = athlete95.EventAreas.ElementAt(0) };
            var inventoryItem130 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 20, 17, 12, 35), EventAreaAssignment = athlete24.EventAreas.ElementAt(0) };
            var inventoryItem131 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 1, 11, 25, 0), EventAreaAssignment = athlete44.EventAreas.ElementAt(0) };
            var inventoryItem132 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete75, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 24, 18, 40, 12), EventAreaAssignment = athlete75.EventAreas.ElementAt(0) };
            var inventoryItem133 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete14, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 9, 6, 54, 36), EventAreaAssignment = athlete14.EventAreas.ElementAt(0) };
            var inventoryItem134 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete81, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 28, 1, 53, 34), EventAreaAssignment = athlete81.EventAreas.ElementAt(0) };
            var inventoryItem135 = new InventoryItem() { Model = model7, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete33, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 3, 18, 48, 18), EventAreaAssignment = athlete33.EventAreas.ElementAt(0) };
            var inventoryItem136 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete97, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 23, 22, 31, 20), EventAreaAssignment = athlete97.EventAreas.ElementAt(0) };
            var inventoryItem137 = new InventoryItem() { Model = model9, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 28, 8, 1, 55), EventAreaAssignment = athlete8.EventAreas.ElementAt(0) };
            var inventoryItem138 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete80, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 9, 14, 14, 47, 51), EventAreaAssignment = athlete80.EventAreas.ElementAt(0) };
            var inventoryItem139 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete58, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 4, 7, 9, 27, 2), EventAreaAssignment = athlete58.EventAreas.ElementAt(0) };
            var inventoryItem140 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete22, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 1, 5, 7, 54, 30), EventAreaAssignment = athlete22.EventAreas.ElementAt(0) };
            var inventoryItem141 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete93, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 11, 25, 18, 23, 17), EventAreaAssignment = athlete93.EventAreas.ElementAt(0) };
            var inventoryItem142 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete26, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 2, 4, 10, 3, 6), EventAreaAssignment = athlete26.EventAreas.ElementAt(0) };
            var inventoryItem143 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.RECALLED, StatusLastChanged = new DateTime(2012, 5, 5, 15, 27, 29), EventAreaAssignment = athlete4.EventAreas.ElementAt(0) };
            var inventoryItem144 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete12, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 27, 17, 47, 57), EventAreaAssignment = athlete12.EventAreas.ElementAt(0) };
            var inventoryItem145 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete65, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 24, 8, 35, 1), EventAreaAssignment = athlete65.EventAreas.ElementAt(0) };
            var inventoryItem146 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete88, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 16, 18, 20, 22), EventAreaAssignment = athlete88.EventAreas.ElementAt(0) };
            var inventoryItem147 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete50, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 28, 9, 23, 52), EventAreaAssignment = athlete50.EventAreas.ElementAt(0) };
            var inventoryItem148 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete56, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 19, 12, 15, 57), EventAreaAssignment = athlete56.EventAreas.ElementAt(0) };
            var inventoryItem149 = new InventoryItem() { Model = model8, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete27, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 9, 15, 53, 19), EventAreaAssignment = athlete27.EventAreas.ElementAt(0) };
            var inventoryItem150 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 9, 4, 35, 52), EventAreaAssignment = athlete38.EventAreas.ElementAt(0) };
            var inventoryItem151 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete34, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 28, 10, 24, 28), EventAreaAssignment = athlete34.EventAreas.ElementAt(0) };
            var inventoryItem152 = new InventoryItem() { Model = model9, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete30, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 24, 22, 20, 23), EventAreaAssignment = athlete30.EventAreas.ElementAt(0) };
            var inventoryItem153 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete93, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 18, 23, 37, 10), EventAreaAssignment = athlete93.EventAreas.ElementAt(0) };
            var inventoryItem154 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete37, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 14, 12, 54, 31), EventAreaAssignment = athlete37.EventAreas.ElementAt(0) };
            var inventoryItem155 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete79, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 4, 15, 31, 48), EventAreaAssignment = athlete79.EventAreas.ElementAt(0) };
            var inventoryItem156 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete52, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 25, 16, 48, 45), EventAreaAssignment = athlete52.EventAreas.ElementAt(0) };
            var inventoryItem157 = new InventoryItem() { Model = model2, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete71, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 15, 10, 15, 5), EventAreaAssignment = athlete71.EventAreas.ElementAt(0) };
            var inventoryItem158 = new InventoryItem() { Model = model4, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete56, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 18, 8, 21, 53), EventAreaAssignment = athlete56.EventAreas.ElementAt(0) };
            var inventoryItem159 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete89, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 25, 21, 53, 28), EventAreaAssignment = athlete89.EventAreas.ElementAt(0) };
            var inventoryItem160 = new InventoryItem() { Model = model7, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete5, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 4, 16, 5, 23), EventAreaAssignment = athlete5.EventAreas.ElementAt(0) };
            var inventoryItem161 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete62, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 9, 18, 27, 50), EventAreaAssignment = athlete62.EventAreas.ElementAt(0) };
            var inventoryItem162 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete52, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 27, 5, 37, 32), EventAreaAssignment = athlete52.EventAreas.ElementAt(0) };
            var inventoryItem163 = new InventoryItem() { Model = model9, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete50, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 3, 10, 50, 14), EventAreaAssignment = athlete50.EventAreas.ElementAt(0) };
            var inventoryItem164 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete48, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 22, 1, 6, 56), EventAreaAssignment = athlete48.EventAreas.ElementAt(0) };
            var inventoryItem165 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 8, 13, 22, 33), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem166 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete30, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 27, 18, 29, 9), EventAreaAssignment = athlete30.EventAreas.ElementAt(0) };
            var inventoryItem167 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete48, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 23, 3, 42, 11), EventAreaAssignment = athlete48.EventAreas.ElementAt(0) };
            var inventoryItem168 = new InventoryItem() { Model = model1, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 23, 22, 42, 20), EventAreaAssignment = athlete9.EventAreas.ElementAt(0) };
            var inventoryItem169 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 13, 21, 51, 21), EventAreaAssignment = athlete24.EventAreas.ElementAt(0) };
            var inventoryItem170 = new InventoryItem() { Model = model5, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete13, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 18, 3, 54, 33), EventAreaAssignment = athlete13.EventAreas.ElementAt(0) };
            var inventoryItem171 = new InventoryItem() { Model = model1, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete24, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 6, 3, 9, 30), EventAreaAssignment = athlete24.EventAreas.ElementAt(0) };
            var inventoryItem172 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete14, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 6, 6, 56, 36), EventAreaAssignment = athlete14.EventAreas.ElementAt(0) };
            var inventoryItem173 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete95, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 1, 2, 11, 36), EventAreaAssignment = athlete95.EventAreas.ElementAt(0) };
            var inventoryItem174 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 5, 20, 35, 42), EventAreaAssignment = athlete38.EventAreas.ElementAt(0) };
            var inventoryItem175 = new InventoryItem() { Model = model6, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete28, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 24, 23, 44, 37), EventAreaAssignment = athlete28.EventAreas.ElementAt(0) };
            var inventoryItem176 = new InventoryItem() { Model = model2, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete76, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 14, 11, 22, 28), EventAreaAssignment = athlete76.EventAreas.ElementAt(0) };
            var inventoryItem177 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 15, 15, 19, 55), EventAreaAssignment = athlete44.EventAreas.ElementAt(0) };
            var inventoryItem178 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 28, 15, 18, 56), EventAreaAssignment = athlete4.EventAreas.ElementAt(0) };
            var inventoryItem179 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 25, 21, 23, 4), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem180 = new InventoryItem() { Model = model8, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete11, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 16, 23, 41, 23), EventAreaAssignment = athlete11.EventAreas.ElementAt(0) };
            var inventoryItem181 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 27, 2, 45, 7), EventAreaAssignment = athlete38.EventAreas.ElementAt(0) };
            var inventoryItem182 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete76, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 9, 22, 30, 4), EventAreaAssignment = athlete76.EventAreas.ElementAt(0) };
            var inventoryItem183 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete53, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 11, 1, 53, 44), EventAreaAssignment = athlete53.EventAreas.ElementAt(0) };
            var inventoryItem184 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete59, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 21, 20, 22, 10), EventAreaAssignment = athlete59.EventAreas.ElementAt(0) };
            var inventoryItem185 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete46, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 19, 12, 34, 24), EventAreaAssignment = athlete46.EventAreas.ElementAt(0) };
            var inventoryItem186 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 8, 16, 31, 36), EventAreaAssignment = athlete20.EventAreas.ElementAt(0) };
            var inventoryItem187 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 11, 27, 14, 4, 38), EventAreaAssignment = athlete20.EventAreas.ElementAt(0) };
            var inventoryItem188 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete27, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 11, 2, 5, 22, 53), EventAreaAssignment = athlete27.EventAreas.ElementAt(0) };
            var inventoryItem189 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete10, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 6, 1, 20, 39, 22), EventAreaAssignment = athlete10.EventAreas.ElementAt(0) };
            var inventoryItem190 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete94, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 8, 5, 18, 25, 22), EventAreaAssignment = athlete94.EventAreas.ElementAt(0) };
            var inventoryItem191 = new InventoryItem() { Model = model4, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete79, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 12, 1, 22, 33, 36), EventAreaAssignment = athlete79.EventAreas.ElementAt(0) };
            var inventoryItem192 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete65, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 5, 23, 15, 3, 57), EventAreaAssignment = athlete65.EventAreas.ElementAt(0) };
            var inventoryItem193 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete79, RequestName = "request1", Status = Constants.Inventory.SURPLUSED, StatusLastChanged = new DateTime(2012, 9, 21, 17, 54, 21), EventAreaAssignment = athlete79.EventAreas.ElementAt(0) };
            var inventoryItem194 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete15, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 24, 1, 29, 44), EventAreaAssignment = athlete15.EventAreas.ElementAt(0) };
            var inventoryItem195 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete38, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 24, 20, 17, 54), EventAreaAssignment = athlete38.EventAreas.ElementAt(0) };
            var inventoryItem196 = new InventoryItem() { Model = model4, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete83, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 3, 20, 22, 23), EventAreaAssignment = athlete83.EventAreas.ElementAt(0) };
            var inventoryItem197 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 18, 10, 11, 29), EventAreaAssignment = athlete69.EventAreas.ElementAt(0) };
            var inventoryItem198 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete90, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 18, 20, 6, 33), EventAreaAssignment = athlete90.EventAreas.ElementAt(0) };
            var inventoryItem199 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete69, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 12, 14, 40, 55), EventAreaAssignment = athlete69.EventAreas.ElementAt(0) };
            var inventoryItem200 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete85, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 22, 13, 14, 52), EventAreaAssignment = athlete85.EventAreas.ElementAt(0) };
            var inventoryItem201 = new InventoryItem() { Model = model8, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete54, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 26, 17, 25, 29), EventAreaAssignment = athlete54.EventAreas.ElementAt(0) };
            var inventoryItem202 = new InventoryItem() { Model = model8, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete34, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 11, 0, 56, 40), EventAreaAssignment = athlete34.EventAreas.ElementAt(0) };
            var inventoryItem203 = new InventoryItem() { Model = model2, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete41, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 12, 27, 13, 10, 46), EventAreaAssignment = athlete41.EventAreas.ElementAt(0) };
            var inventoryItem204 = new InventoryItem() { Model = model1, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete65, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 14, 11, 21, 28), EventAreaAssignment = athlete65.EventAreas.ElementAt(0) };
            var inventoryItem205 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete27, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 8, 21, 24, 39), EventAreaAssignment = athlete27.EventAreas.ElementAt(0) };
            var inventoryItem206 = new InventoryItem() { Model = model7, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete49, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 9, 23, 35, 0), EventAreaAssignment = athlete49.EventAreas.ElementAt(0) };
            var inventoryItem207 = new InventoryItem() { Model = model3, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete86, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 10, 1, 35, 38), EventAreaAssignment = athlete86.EventAreas.ElementAt(0) };
            var inventoryItem208 = new InventoryItem() { Model = model7, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete42, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 28, 2, 46, 4), EventAreaAssignment = athlete42.EventAreas.ElementAt(0) };
            var inventoryItem209 = new InventoryItem() { Model = model6, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 23, 11, 39, 16), EventAreaAssignment = athlete19.EventAreas.ElementAt(0) };
            var inventoryItem210 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete85, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 9, 11, 41, 7), EventAreaAssignment = athlete85.EventAreas.ElementAt(0) };
            var inventoryItem211 = new InventoryItem() { Model = model4, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 15, 4, 46, 13), EventAreaAssignment = athlete19.EventAreas.ElementAt(0) };
            var inventoryItem212 = new InventoryItem() { Model = model2, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete86, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 8, 5, 11, 9), EventAreaAssignment = athlete86.EventAreas.ElementAt(0) };
            var inventoryItem213 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete63, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 24, 6, 49, 55), EventAreaAssignment = athlete63.EventAreas.ElementAt(0) };
            var inventoryItem214 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete29, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 11, 1, 13, 51), EventAreaAssignment = athlete29.EventAreas.ElementAt(0) };
            var inventoryItem215 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 9, 6, 0, 1), EventAreaAssignment = athlete44.EventAreas.ElementAt(0) };
            var inventoryItem216 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete21, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 13, 7, 16, 19), EventAreaAssignment = athlete21.EventAreas.ElementAt(0) };
            var inventoryItem217 = new InventoryItem() { Model = model9, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete20, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 14, 23, 57, 46), EventAreaAssignment = athlete20.EventAreas.ElementAt(0) };
            var inventoryItem218 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete2, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 19, 6, 9, 32), EventAreaAssignment = athlete2.EventAreas.ElementAt(0) };
            var inventoryItem219 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete85, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 11, 4, 35, 59), EventAreaAssignment = athlete85.EventAreas.ElementAt(0) };
            var inventoryItem220 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete85, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 22, 13, 47, 53), EventAreaAssignment = athlete85.EventAreas.ElementAt(0) };
            var inventoryItem221 = new InventoryItem() { Model = model8, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete88, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 1, 16, 28, 27), EventAreaAssignment = athlete88.EventAreas.ElementAt(0) };
            var inventoryItem222 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete80, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 6, 23, 33, 4), EventAreaAssignment = athlete80.EventAreas.ElementAt(0) };
            var inventoryItem223 = new InventoryItem() { Model = model5, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete28, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 4, 14, 57, 42), EventAreaAssignment = athlete28.EventAreas.ElementAt(0) };
            var inventoryItem224 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete62, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 27, 21, 36, 52), EventAreaAssignment = athlete62.EventAreas.ElementAt(0) };
            var inventoryItem225 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete17, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 9, 20, 21, 33), EventAreaAssignment = athlete17.EventAreas.ElementAt(0) };
            var inventoryItem226 = new InventoryItem() { Model = model2, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete96, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 13, 18, 48, 54), EventAreaAssignment = athlete96.EventAreas.ElementAt(0) };
            var inventoryItem227 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete21, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 28, 11, 2, 38), EventAreaAssignment = athlete21.EventAreas.ElementAt(0) };
            var inventoryItem228 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete85, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 27, 3, 15, 23), EventAreaAssignment = athlete85.EventAreas.ElementAt(0) };
            var inventoryItem229 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete15, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 13, 22, 45, 30), EventAreaAssignment = athlete15.EventAreas.ElementAt(0) };
            var inventoryItem230 = new InventoryItem() { Model = model3, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete9, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 10, 19, 16, 8, 8), EventAreaAssignment = athlete9.EventAreas.ElementAt(0) };
            var inventoryItem231 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete2, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 20, 16, 4, 19), EventAreaAssignment = athlete2.EventAreas.ElementAt(0) };
            var inventoryItem232 = new InventoryItem() { Model = model3, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete22, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 8, 28, 22, 38, 56), EventAreaAssignment = athlete22.EventAreas.ElementAt(0) };
            var inventoryItem233 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete67, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 25, 18, 10, 8), EventAreaAssignment = athlete67.EventAreas.ElementAt(0) };
            var inventoryItem234 = new InventoryItem() { Model = model7, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 2, 8, 1, 55, 31), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem235 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete4, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 11, 28, 2, 26, 41), EventAreaAssignment = athlete4.EventAreas.ElementAt(0) };
            var inventoryItem236 = new InventoryItem() { Model = model5, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete8, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 8, 3, 13, 35), EventAreaAssignment = athlete8.EventAreas.ElementAt(0) };
            var inventoryItem237 = new InventoryItem() { Model = model5, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete92, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 4, 3, 42, 1), EventAreaAssignment = athlete92.EventAreas.ElementAt(0) };
            var inventoryItem238 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 3, 7, 1, 33), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem239 = new InventoryItem() { Model = model3, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete33, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 3, 15, 17, 6), EventAreaAssignment = athlete33.EventAreas.ElementAt(0) };
            var inventoryItem240 = new InventoryItem() { Model = model8, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete31, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 4, 8, 10, 11, 39), EventAreaAssignment = athlete31.EventAreas.ElementAt(0) };
            var inventoryItem241 = new InventoryItem() { Model = model6, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete58, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 18, 3, 42, 41), EventAreaAssignment = athlete58.EventAreas.ElementAt(0) };
            var inventoryItem242 = new InventoryItem() { Model = model6, SizeM = 11, SizeW = 9, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 9, 9, 13, 29, 53), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem243 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete44, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 7, 13, 10, 27, 21), EventAreaAssignment = athlete44.EventAreas.ElementAt(0) };
            var inventoryItem244 = new InventoryItem() { Model = model9, SizeM = 8, SizeW = 6, Width = "N", Athlete = athlete55, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 1, 4, 34, 7), EventAreaAssignment = athlete55.EventAreas.ElementAt(0) };
            var inventoryItem245 = new InventoryItem() { Model = model1, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete78, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 23, 17, 15, 39), EventAreaAssignment = athlete78.EventAreas.ElementAt(0) };
            var inventoryItem246 = new InventoryItem() { Model = model8, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete61, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 1, 19, 4, 9, 44), EventAreaAssignment = athlete61.EventAreas.ElementAt(0) };
            var inventoryItem247 = new InventoryItem() { Model = model3, SizeM = 10, SizeW = 8, Width = "N", Athlete = athlete19, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 6, 3, 2, 2, 0), EventAreaAssignment = athlete19.EventAreas.ElementAt(0) };
            var inventoryItem248 = new InventoryItem() { Model = model7, SizeM = 12, SizeW = 10, Width = "N", Athlete = athlete58, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 5, 15, 9, 23, 42), EventAreaAssignment = athlete58.EventAreas.ElementAt(0) };
            var inventoryItem249 = new InventoryItem() { Model = model1, SizeM = 9, SizeW = 7, Width = "N", Athlete = athlete18, RequestName = "request1", Status = Constants.Inventory.IN_STOCK, StatusLastChanged = new DateTime(2012, 3, 19, 8, 23, 44), EventAreaAssignment = athlete18.EventAreas.ElementAt(0) };

            #endregion

            #region Save Inventory Items
            inventoryRepository.Save(inventoryItem1);
            inventoryRepository.Save(inventoryItem2);
            inventoryRepository.Save(inventoryItem3);
            inventoryRepository.Save(inventoryItem4);
            inventoryRepository.Save(inventoryItem5);
            inventoryRepository.Save(inventoryItem6);
            inventoryRepository.Save(inventoryItem7);
            inventoryRepository.Save(inventoryItem8);
            inventoryRepository.Save(inventoryItem9);
            inventoryRepository.Save(inventoryItem10);
            inventoryRepository.Save(inventoryItem11);
            inventoryRepository.Save(inventoryItem12);
            inventoryRepository.Save(inventoryItem13);
            inventoryRepository.Save(inventoryItem14);
            inventoryRepository.Save(inventoryItem15);
            inventoryRepository.Save(inventoryItem16);
            inventoryRepository.Save(inventoryItem17);
            inventoryRepository.Save(inventoryItem18);
            inventoryRepository.Save(inventoryItem19);
            inventoryRepository.Save(inventoryItem20);
            inventoryRepository.Save(inventoryItem21);
            inventoryRepository.Save(inventoryItem22);
            inventoryRepository.Save(inventoryItem23);
            inventoryRepository.Save(inventoryItem24);
            inventoryRepository.Save(inventoryItem25);
            inventoryRepository.Save(inventoryItem26);
            inventoryRepository.Save(inventoryItem27);
            inventoryRepository.Save(inventoryItem28);
            inventoryRepository.Save(inventoryItem29);
            inventoryRepository.Save(inventoryItem30);
            inventoryRepository.Save(inventoryItem31);
            inventoryRepository.Save(inventoryItem32);
            inventoryRepository.Save(inventoryItem33);
            inventoryRepository.Save(inventoryItem34);
            inventoryRepository.Save(inventoryItem35);
            inventoryRepository.Save(inventoryItem36);
            inventoryRepository.Save(inventoryItem37);
            inventoryRepository.Save(inventoryItem38);
            inventoryRepository.Save(inventoryItem39);
            inventoryRepository.Save(inventoryItem40);
            inventoryRepository.Save(inventoryItem41);
            inventoryRepository.Save(inventoryItem42);
            inventoryRepository.Save(inventoryItem43);
            inventoryRepository.Save(inventoryItem44);
            inventoryRepository.Save(inventoryItem45);
            inventoryRepository.Save(inventoryItem46);
            inventoryRepository.Save(inventoryItem47);
            inventoryRepository.Save(inventoryItem48);
            inventoryRepository.Save(inventoryItem49);
            inventoryRepository.Save(inventoryItem50);
            inventoryRepository.Save(inventoryItem51);
            inventoryRepository.Save(inventoryItem52);
            inventoryRepository.Save(inventoryItem53);
            inventoryRepository.Save(inventoryItem54);
            inventoryRepository.Save(inventoryItem55);
            inventoryRepository.Save(inventoryItem56);
            inventoryRepository.Save(inventoryItem57);
            inventoryRepository.Save(inventoryItem58);
            inventoryRepository.Save(inventoryItem59);
            inventoryRepository.Save(inventoryItem60);
            inventoryRepository.Save(inventoryItem61);
            inventoryRepository.Save(inventoryItem62);
            inventoryRepository.Save(inventoryItem63);
            inventoryRepository.Save(inventoryItem64);
            inventoryRepository.Save(inventoryItem65);
            inventoryRepository.Save(inventoryItem66);
            inventoryRepository.Save(inventoryItem67);
            inventoryRepository.Save(inventoryItem68);
            inventoryRepository.Save(inventoryItem69);
            inventoryRepository.Save(inventoryItem70);
            inventoryRepository.Save(inventoryItem71);
            inventoryRepository.Save(inventoryItem72);
            inventoryRepository.Save(inventoryItem73);
            inventoryRepository.Save(inventoryItem74);
            inventoryRepository.Save(inventoryItem75);
            inventoryRepository.Save(inventoryItem76);
            inventoryRepository.Save(inventoryItem77);
            inventoryRepository.Save(inventoryItem78);
            inventoryRepository.Save(inventoryItem79);
            inventoryRepository.Save(inventoryItem80);
            inventoryRepository.Save(inventoryItem81);
            inventoryRepository.Save(inventoryItem82);
            inventoryRepository.Save(inventoryItem83);
            inventoryRepository.Save(inventoryItem84);
            inventoryRepository.Save(inventoryItem85);
            inventoryRepository.Save(inventoryItem86);
            inventoryRepository.Save(inventoryItem87);
            inventoryRepository.Save(inventoryItem88);
            inventoryRepository.Save(inventoryItem89);
            inventoryRepository.Save(inventoryItem90);
            inventoryRepository.Save(inventoryItem91);
            inventoryRepository.Save(inventoryItem92);
            inventoryRepository.Save(inventoryItem93);
            inventoryRepository.Save(inventoryItem94);
            inventoryRepository.Save(inventoryItem95);
            inventoryRepository.Save(inventoryItem96);
            inventoryRepository.Save(inventoryItem97);
            inventoryRepository.Save(inventoryItem98);
            inventoryRepository.Save(inventoryItem99);
            inventoryRepository.Save(inventoryItem100);
            inventoryRepository.Save(inventoryItem101);
            inventoryRepository.Save(inventoryItem102);
            inventoryRepository.Save(inventoryItem103);
            inventoryRepository.Save(inventoryItem104);
            inventoryRepository.Save(inventoryItem105);
            inventoryRepository.Save(inventoryItem106);
            inventoryRepository.Save(inventoryItem107);
            inventoryRepository.Save(inventoryItem108);
            inventoryRepository.Save(inventoryItem109);
            inventoryRepository.Save(inventoryItem110);
            inventoryRepository.Save(inventoryItem111);
            inventoryRepository.Save(inventoryItem112);
            inventoryRepository.Save(inventoryItem113);
            inventoryRepository.Save(inventoryItem114);
            inventoryRepository.Save(inventoryItem115);
            inventoryRepository.Save(inventoryItem116);
            inventoryRepository.Save(inventoryItem117);
            inventoryRepository.Save(inventoryItem118);
            inventoryRepository.Save(inventoryItem119);
            inventoryRepository.Save(inventoryItem120);
            inventoryRepository.Save(inventoryItem121);
            inventoryRepository.Save(inventoryItem122);
            inventoryRepository.Save(inventoryItem123);
            inventoryRepository.Save(inventoryItem124);
            inventoryRepository.Save(inventoryItem125);
            inventoryRepository.Save(inventoryItem126);
            inventoryRepository.Save(inventoryItem127);
            inventoryRepository.Save(inventoryItem128);
            inventoryRepository.Save(inventoryItem129);
            inventoryRepository.Save(inventoryItem130);
            inventoryRepository.Save(inventoryItem131);
            inventoryRepository.Save(inventoryItem132);
            inventoryRepository.Save(inventoryItem133);
            inventoryRepository.Save(inventoryItem134);
            inventoryRepository.Save(inventoryItem135);
            inventoryRepository.Save(inventoryItem136);
            inventoryRepository.Save(inventoryItem137);
            inventoryRepository.Save(inventoryItem138);
            inventoryRepository.Save(inventoryItem139);
            inventoryRepository.Save(inventoryItem140);
            inventoryRepository.Save(inventoryItem141);
            inventoryRepository.Save(inventoryItem142);
            inventoryRepository.Save(inventoryItem143);
            inventoryRepository.Save(inventoryItem144);
            inventoryRepository.Save(inventoryItem145);
            inventoryRepository.Save(inventoryItem146);
            inventoryRepository.Save(inventoryItem147);
            inventoryRepository.Save(inventoryItem148);
            inventoryRepository.Save(inventoryItem149);
            inventoryRepository.Save(inventoryItem150);
            inventoryRepository.Save(inventoryItem151);
            inventoryRepository.Save(inventoryItem152);
            inventoryRepository.Save(inventoryItem153);
            inventoryRepository.Save(inventoryItem154);
            inventoryRepository.Save(inventoryItem155);
            inventoryRepository.Save(inventoryItem156);
            inventoryRepository.Save(inventoryItem157);
            inventoryRepository.Save(inventoryItem158);
            inventoryRepository.Save(inventoryItem159);
            inventoryRepository.Save(inventoryItem160);
            inventoryRepository.Save(inventoryItem161);
            inventoryRepository.Save(inventoryItem162);
            inventoryRepository.Save(inventoryItem163);
            inventoryRepository.Save(inventoryItem164);
            inventoryRepository.Save(inventoryItem165);
            inventoryRepository.Save(inventoryItem166);
            inventoryRepository.Save(inventoryItem167);
            inventoryRepository.Save(inventoryItem168);
            inventoryRepository.Save(inventoryItem169);
            inventoryRepository.Save(inventoryItem170);
            inventoryRepository.Save(inventoryItem171);
            inventoryRepository.Save(inventoryItem172);
            inventoryRepository.Save(inventoryItem173);
            inventoryRepository.Save(inventoryItem174);
            inventoryRepository.Save(inventoryItem175);
            inventoryRepository.Save(inventoryItem176);
            inventoryRepository.Save(inventoryItem177);
            inventoryRepository.Save(inventoryItem178);
            inventoryRepository.Save(inventoryItem179);
            inventoryRepository.Save(inventoryItem180);
            inventoryRepository.Save(inventoryItem181);
            inventoryRepository.Save(inventoryItem182);
            inventoryRepository.Save(inventoryItem183);
            inventoryRepository.Save(inventoryItem184);
            inventoryRepository.Save(inventoryItem185);
            inventoryRepository.Save(inventoryItem186);
            inventoryRepository.Save(inventoryItem187);
            inventoryRepository.Save(inventoryItem188);
            inventoryRepository.Save(inventoryItem189);
            inventoryRepository.Save(inventoryItem190);
            inventoryRepository.Save(inventoryItem191);
            inventoryRepository.Save(inventoryItem192);
            inventoryRepository.Save(inventoryItem193);
            inventoryRepository.Save(inventoryItem194);
            inventoryRepository.Save(inventoryItem195);
            inventoryRepository.Save(inventoryItem196);
            inventoryRepository.Save(inventoryItem197);
            inventoryRepository.Save(inventoryItem198);
            inventoryRepository.Save(inventoryItem199);
            inventoryRepository.Save(inventoryItem200);
            inventoryRepository.Save(inventoryItem201);
            inventoryRepository.Save(inventoryItem202);
            inventoryRepository.Save(inventoryItem203);
            inventoryRepository.Save(inventoryItem204);
            inventoryRepository.Save(inventoryItem205);
            inventoryRepository.Save(inventoryItem206);
            inventoryRepository.Save(inventoryItem207);
            inventoryRepository.Save(inventoryItem208);
            inventoryRepository.Save(inventoryItem209);
            inventoryRepository.Save(inventoryItem210);
            inventoryRepository.Save(inventoryItem211);
            inventoryRepository.Save(inventoryItem212);
            inventoryRepository.Save(inventoryItem213);
            inventoryRepository.Save(inventoryItem214);
            inventoryRepository.Save(inventoryItem215);
            inventoryRepository.Save(inventoryItem216);
            inventoryRepository.Save(inventoryItem217);
            inventoryRepository.Save(inventoryItem218);
            inventoryRepository.Save(inventoryItem219);
            inventoryRepository.Save(inventoryItem220);
            inventoryRepository.Save(inventoryItem221);
            inventoryRepository.Save(inventoryItem222);
            inventoryRepository.Save(inventoryItem223);
            inventoryRepository.Save(inventoryItem224);
            inventoryRepository.Save(inventoryItem225);
            inventoryRepository.Save(inventoryItem226);
            inventoryRepository.Save(inventoryItem227);
            inventoryRepository.Save(inventoryItem228);
            inventoryRepository.Save(inventoryItem229);
            inventoryRepository.Save(inventoryItem230);
            inventoryRepository.Save(inventoryItem231);
            inventoryRepository.Save(inventoryItem232);
            inventoryRepository.Save(inventoryItem233);
            inventoryRepository.Save(inventoryItem234);
            inventoryRepository.Save(inventoryItem235);
            inventoryRepository.Save(inventoryItem236);
            inventoryRepository.Save(inventoryItem237);
            inventoryRepository.Save(inventoryItem238);
            inventoryRepository.Save(inventoryItem239);
            inventoryRepository.Save(inventoryItem240);
            inventoryRepository.Save(inventoryItem241);
            inventoryRepository.Save(inventoryItem242);
            inventoryRepository.Save(inventoryItem243);
            inventoryRepository.Save(inventoryItem244);
            inventoryRepository.Save(inventoryItem245);
            inventoryRepository.Save(inventoryItem246);
            inventoryRepository.Save(inventoryItem247);
            inventoryRepository.Save(inventoryItem248);
            inventoryRepository.Save(inventoryItem249);
            #endregion

            #region Inventory History
            var inventoryItems = new List<InventoryItem>();

            inventoryItems.Add(inventoryItem1);
            inventoryItems.Add(inventoryItem2);
            inventoryItems.Add(inventoryItem3);
            inventoryItems.Add(inventoryItem4);
            inventoryItems.Add(inventoryItem5);
            inventoryItems.Add(inventoryItem6);
            inventoryItems.Add(inventoryItem7);
            inventoryItems.Add(inventoryItem8);
            inventoryItems.Add(inventoryItem9);
            inventoryItems.Add(inventoryItem10);
            inventoryItems.Add(inventoryItem11);
            inventoryItems.Add(inventoryItem12);
            inventoryItems.Add(inventoryItem13);
            inventoryItems.Add(inventoryItem14);
            inventoryItems.Add(inventoryItem15);
            inventoryItems.Add(inventoryItem16);
            inventoryItems.Add(inventoryItem17);
            inventoryItems.Add(inventoryItem18);
            inventoryItems.Add(inventoryItem19);
            inventoryItems.Add(inventoryItem20);
            inventoryItems.Add(inventoryItem21);
            inventoryItems.Add(inventoryItem22);
            inventoryItems.Add(inventoryItem23);
            inventoryItems.Add(inventoryItem24);
            inventoryItems.Add(inventoryItem25);
            inventoryItems.Add(inventoryItem26);
            inventoryItems.Add(inventoryItem27);
            inventoryItems.Add(inventoryItem28);
            inventoryItems.Add(inventoryItem29);
            inventoryItems.Add(inventoryItem30);
            inventoryItems.Add(inventoryItem31);
            inventoryItems.Add(inventoryItem32);
            inventoryItems.Add(inventoryItem33);
            inventoryItems.Add(inventoryItem34);
            inventoryItems.Add(inventoryItem35);
            inventoryItems.Add(inventoryItem36);
            inventoryItems.Add(inventoryItem37);
            inventoryItems.Add(inventoryItem38);
            inventoryItems.Add(inventoryItem39);
            inventoryItems.Add(inventoryItem40);
            inventoryItems.Add(inventoryItem41);
            inventoryItems.Add(inventoryItem42);
            inventoryItems.Add(inventoryItem43);
            inventoryItems.Add(inventoryItem44);
            inventoryItems.Add(inventoryItem45);
            inventoryItems.Add(inventoryItem46);
            inventoryItems.Add(inventoryItem47);
            inventoryItems.Add(inventoryItem48);
            inventoryItems.Add(inventoryItem49);
            inventoryItems.Add(inventoryItem50);
            inventoryItems.Add(inventoryItem51);
            inventoryItems.Add(inventoryItem52);
            inventoryItems.Add(inventoryItem53);
            inventoryItems.Add(inventoryItem54);
            inventoryItems.Add(inventoryItem55);
            inventoryItems.Add(inventoryItem56);
            inventoryItems.Add(inventoryItem57);
            inventoryItems.Add(inventoryItem58);
            inventoryItems.Add(inventoryItem59);
            inventoryItems.Add(inventoryItem60);
            inventoryItems.Add(inventoryItem61);
            inventoryItems.Add(inventoryItem62);
            inventoryItems.Add(inventoryItem63);
            inventoryItems.Add(inventoryItem64);
            inventoryItems.Add(inventoryItem65);
            inventoryItems.Add(inventoryItem66);
            inventoryItems.Add(inventoryItem67);
            inventoryItems.Add(inventoryItem68);
            inventoryItems.Add(inventoryItem69);
            inventoryItems.Add(inventoryItem70);
            inventoryItems.Add(inventoryItem71);
            inventoryItems.Add(inventoryItem72);
            inventoryItems.Add(inventoryItem73);
            inventoryItems.Add(inventoryItem74);
            inventoryItems.Add(inventoryItem75);
            inventoryItems.Add(inventoryItem76);
            inventoryItems.Add(inventoryItem77);
            inventoryItems.Add(inventoryItem78);
            inventoryItems.Add(inventoryItem79);
            inventoryItems.Add(inventoryItem80);
            inventoryItems.Add(inventoryItem81);
            inventoryItems.Add(inventoryItem82);
            inventoryItems.Add(inventoryItem83);
            inventoryItems.Add(inventoryItem84);
            inventoryItems.Add(inventoryItem85);
            inventoryItems.Add(inventoryItem86);
            inventoryItems.Add(inventoryItem87);
            inventoryItems.Add(inventoryItem88);
            inventoryItems.Add(inventoryItem89);
            inventoryItems.Add(inventoryItem90);
            inventoryItems.Add(inventoryItem91);
            inventoryItems.Add(inventoryItem92);
            inventoryItems.Add(inventoryItem93);
            inventoryItems.Add(inventoryItem94);
            inventoryItems.Add(inventoryItem95);
            inventoryItems.Add(inventoryItem96);
            inventoryItems.Add(inventoryItem97);
            inventoryItems.Add(inventoryItem98);
            inventoryItems.Add(inventoryItem99);
            inventoryItems.Add(inventoryItem100);
            inventoryItems.Add(inventoryItem101);
            inventoryItems.Add(inventoryItem102);
            inventoryItems.Add(inventoryItem103);
            inventoryItems.Add(inventoryItem104);
            inventoryItems.Add(inventoryItem105);
            inventoryItems.Add(inventoryItem106);
            inventoryItems.Add(inventoryItem107);
            inventoryItems.Add(inventoryItem108);
            inventoryItems.Add(inventoryItem109);
            inventoryItems.Add(inventoryItem110);
            inventoryItems.Add(inventoryItem111);
            inventoryItems.Add(inventoryItem112);
            inventoryItems.Add(inventoryItem113);
            inventoryItems.Add(inventoryItem114);
            inventoryItems.Add(inventoryItem115);
            inventoryItems.Add(inventoryItem116);
            inventoryItems.Add(inventoryItem117);
            inventoryItems.Add(inventoryItem118);
            inventoryItems.Add(inventoryItem119);
            inventoryItems.Add(inventoryItem120);
            inventoryItems.Add(inventoryItem121);
            inventoryItems.Add(inventoryItem122);
            inventoryItems.Add(inventoryItem123);
            inventoryItems.Add(inventoryItem124);
            inventoryItems.Add(inventoryItem125);
            inventoryItems.Add(inventoryItem126);
            inventoryItems.Add(inventoryItem127);
            inventoryItems.Add(inventoryItem128);
            inventoryItems.Add(inventoryItem129);
            inventoryItems.Add(inventoryItem130);
            inventoryItems.Add(inventoryItem131);
            inventoryItems.Add(inventoryItem132);
            inventoryItems.Add(inventoryItem133);
            inventoryItems.Add(inventoryItem134);
            inventoryItems.Add(inventoryItem135);
            inventoryItems.Add(inventoryItem136);
            inventoryItems.Add(inventoryItem137);
            inventoryItems.Add(inventoryItem138);
            inventoryItems.Add(inventoryItem139);
            inventoryItems.Add(inventoryItem140);
            inventoryItems.Add(inventoryItem141);
            inventoryItems.Add(inventoryItem142);
            inventoryItems.Add(inventoryItem143);
            inventoryItems.Add(inventoryItem144);
            inventoryItems.Add(inventoryItem145);
            inventoryItems.Add(inventoryItem146);
            inventoryItems.Add(inventoryItem147);
            inventoryItems.Add(inventoryItem148);
            inventoryItems.Add(inventoryItem149);
            inventoryItems.Add(inventoryItem150);
            inventoryItems.Add(inventoryItem151);
            inventoryItems.Add(inventoryItem152);
            inventoryItems.Add(inventoryItem153);
            inventoryItems.Add(inventoryItem154);
            inventoryItems.Add(inventoryItem155);
            inventoryItems.Add(inventoryItem156);
            inventoryItems.Add(inventoryItem157);
            inventoryItems.Add(inventoryItem158);
            inventoryItems.Add(inventoryItem159);
            inventoryItems.Add(inventoryItem160);
            inventoryItems.Add(inventoryItem161);
            inventoryItems.Add(inventoryItem162);
            inventoryItems.Add(inventoryItem163);
            inventoryItems.Add(inventoryItem164);
            inventoryItems.Add(inventoryItem165);
            inventoryItems.Add(inventoryItem166);
            inventoryItems.Add(inventoryItem167);
            inventoryItems.Add(inventoryItem168);
            inventoryItems.Add(inventoryItem169);
            inventoryItems.Add(inventoryItem170);
            inventoryItems.Add(inventoryItem171);
            inventoryItems.Add(inventoryItem172);
            inventoryItems.Add(inventoryItem173);
            inventoryItems.Add(inventoryItem174);
            inventoryItems.Add(inventoryItem175);
            inventoryItems.Add(inventoryItem176);
            inventoryItems.Add(inventoryItem177);
            inventoryItems.Add(inventoryItem178);
            inventoryItems.Add(inventoryItem179);
            inventoryItems.Add(inventoryItem180);
            inventoryItems.Add(inventoryItem181);
            inventoryItems.Add(inventoryItem182);
            inventoryItems.Add(inventoryItem183);
            inventoryItems.Add(inventoryItem184);
            inventoryItems.Add(inventoryItem185);
            inventoryItems.Add(inventoryItem186);
            inventoryItems.Add(inventoryItem187);
            inventoryItems.Add(inventoryItem188);
            inventoryItems.Add(inventoryItem189);
            inventoryItems.Add(inventoryItem190);
            inventoryItems.Add(inventoryItem191);
            inventoryItems.Add(inventoryItem192);
            inventoryItems.Add(inventoryItem193);
            inventoryItems.Add(inventoryItem194);
            inventoryItems.Add(inventoryItem195);
            inventoryItems.Add(inventoryItem196);
            inventoryItems.Add(inventoryItem197);
            inventoryItems.Add(inventoryItem198);
            inventoryItems.Add(inventoryItem199);
            inventoryItems.Add(inventoryItem200);
            inventoryItems.Add(inventoryItem201);
            inventoryItems.Add(inventoryItem202);
            inventoryItems.Add(inventoryItem203);
            inventoryItems.Add(inventoryItem204);
            inventoryItems.Add(inventoryItem205);
            inventoryItems.Add(inventoryItem206);
            inventoryItems.Add(inventoryItem207);
            inventoryItems.Add(inventoryItem208);
            inventoryItems.Add(inventoryItem209);
            inventoryItems.Add(inventoryItem210);
            inventoryItems.Add(inventoryItem211);
            inventoryItems.Add(inventoryItem212);
            inventoryItems.Add(inventoryItem213);
            inventoryItems.Add(inventoryItem214);
            inventoryItems.Add(inventoryItem215);
            inventoryItems.Add(inventoryItem216);
            inventoryItems.Add(inventoryItem217);
            inventoryItems.Add(inventoryItem218);
            inventoryItems.Add(inventoryItem219);
            inventoryItems.Add(inventoryItem220);
            inventoryItems.Add(inventoryItem221);
            inventoryItems.Add(inventoryItem222);
            inventoryItems.Add(inventoryItem223);
            inventoryItems.Add(inventoryItem224);
            inventoryItems.Add(inventoryItem225);
            inventoryItems.Add(inventoryItem226);
            inventoryItems.Add(inventoryItem227);
            inventoryItems.Add(inventoryItem228);
            inventoryItems.Add(inventoryItem229);
            inventoryItems.Add(inventoryItem230);
            inventoryItems.Add(inventoryItem231);
            inventoryItems.Add(inventoryItem232);
            inventoryItems.Add(inventoryItem233);
            inventoryItems.Add(inventoryItem234);
            inventoryItems.Add(inventoryItem235);
            inventoryItems.Add(inventoryItem236);
            inventoryItems.Add(inventoryItem237);
            inventoryItems.Add(inventoryItem238);
            inventoryItems.Add(inventoryItem239);
            inventoryItems.Add(inventoryItem240);
            inventoryItems.Add(inventoryItem241);
            inventoryItems.Add(inventoryItem242);
            inventoryItems.Add(inventoryItem243);
            inventoryItems.Add(inventoryItem244);
            inventoryItems.Add(inventoryItem245);
            inventoryItems.Add(inventoryItem246);
            inventoryItems.Add(inventoryItem247);
            inventoryItems.Add(inventoryItem248);
            inventoryItems.Add(inventoryItem249);

            foreach (var inventoryItem in inventoryItems)
            {
                if (inventoryItem.Status == Constants.Inventory.IN_STOCK)
                {
                    var invMovement = new InventoryMovement();
                    invMovement.EventDate = inventoryItem.StatusLastChanged;
                    invMovement.Description = String.Format("{0} inventory item {1}", Constants.Inventory.IN_STOCK, inventoryItem.SerialNumber);
                    invMovement.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECEIPT_FROM_VENDOR };
                    invMovement.InventoryItem = inventoryItem;

                    invMovementRepository.Save(invMovement);
                }
                else if (inventoryItem.Status == Constants.Inventory.DISTRIBUTED)
                {
                    var invMovement1 = new InventoryMovement();
                    invMovement1.EventDate = inventoryItem.StatusLastChanged.Subtract(TimeSpan.FromDays(15));
                    invMovement1.Description = String.Format("{0} inventory item {1}", Constants.Inventory.IN_STOCK, inventoryItem.SerialNumber);
                    invMovement1.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECEIPT_FROM_VENDOR };
                    invMovement1.InventoryItem = inventoryItem;

                    var invMovement2 = new InventoryMovement();
                    invMovement2.EventDate = inventoryItem.StatusLastChanged;
                    invMovement2.Description = String.Format("{0} inventory item {1}", Constants.Inventory.DISTRIBUTED, inventoryItem.SerialNumber);
                    invMovement2.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.DISTRIBUTE_TO_ATHLETE };
                    invMovement2.InventoryItem = inventoryItem;

                    invMovementRepository.Save(invMovement1);
                    invMovementRepository.Save(invMovement2);
                }
                else if (inventoryItem.Status == Constants.Inventory.SURPLUSED)
                {
                    var invMovement1 = new InventoryMovement();
                    invMovement1.EventDate = inventoryItem.StatusLastChanged.Subtract(TimeSpan.FromDays(15));
                    invMovement1.Description = String.Format("{0} inventory item {1}", Constants.Inventory.IN_STOCK, inventoryItem.SerialNumber);
                    invMovement1.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECEIPT_FROM_VENDOR };
                    invMovement1.InventoryItem = inventoryItem;

                    var invMovement2 = new InventoryMovement();
                    invMovement2.EventDate = inventoryItem.StatusLastChanged;
                    invMovement2.Description = String.Format("{0} inventory item {1}", Constants.Inventory.SURPLUSED, inventoryItem.SerialNumber);
                    invMovement2.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.SURPLUS };
                    invMovement2.InventoryItem = inventoryItem;

                    invMovementRepository.Save(invMovement1);
                    invMovementRepository.Save(invMovement2);
                }
                else if (inventoryItem.Status == Constants.Inventory.RETURNED)
                {
                    var invMovement1 = new InventoryMovement();
                    invMovement1.EventDate = inventoryItem.StatusLastChanged.Subtract(TimeSpan.FromDays(15));
                    invMovement1.Description = String.Format("{0} inventory item {1}", Constants.Inventory.IN_STOCK, inventoryItem.SerialNumber);
                    invMovement1.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECEIPT_FROM_VENDOR };
                    invMovement1.InventoryItem = inventoryItem;

                    var invMovement2 = new InventoryMovement();
                    invMovement2.EventDate = inventoryItem.StatusLastChanged;
                    invMovement2.Description = String.Format("{0} inventory item {1}", Constants.Inventory.RETURNED, inventoryItem.SerialNumber);
                    invMovement2.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RETURN_TO_VENDOR };
                    invMovement2.InventoryItem = inventoryItem;

                    invMovementRepository.Save(invMovement1);
                    invMovementRepository.Save(invMovement2);
                }
                else if (inventoryItem.Status == Constants.Inventory.RECALLED)
                {
                    var invMovement1 = new InventoryMovement();
                    invMovement1.EventDate = inventoryItem.StatusLastChanged.Subtract(TimeSpan.FromDays(15));
                    invMovement1.Description = String.Format("{0} inventory item {1}", Constants.Inventory.IN_STOCK, inventoryItem.SerialNumber);
                    invMovement1.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECEIPT_FROM_VENDOR };
                    invMovement1.InventoryItem = inventoryItem;

                    var invMovement2 = new InventoryMovement();
                    invMovement2.EventDate = inventoryItem.StatusLastChanged;
                    invMovement2.Description = String.Format("{0} inventory item {1}", Constants.Inventory.RECALLED, inventoryItem.SerialNumber);
                    invMovement2.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECALL_FROM_ATHLETE };
                    invMovement2.InventoryItem = inventoryItem;

                    invMovementRepository.Save(invMovement1);
                    invMovementRepository.Save(invMovement2);
                }
                else if (inventoryItem.Status == Constants.Inventory.RECORDED_AS_LOST)
                {
                    var invMovement1 = new InventoryMovement();
                    invMovement1.EventDate = inventoryItem.StatusLastChanged.Subtract(TimeSpan.FromDays(15));
                    invMovement1.Description = String.Format("{0} inventory item {1}", Constants.Inventory.IN_STOCK, inventoryItem.SerialNumber);
                    invMovement1.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECEIPT_FROM_VENDOR };
                    invMovement1.InventoryItem = inventoryItem;

                    var invMovement2 = new InventoryMovement();
                    invMovement2.EventDate = inventoryItem.StatusLastChanged.Subtract(TimeSpan.FromDays(10));
                    invMovement2.Description = String.Format("{0} inventory item {1}", Constants.Inventory.DISTRIBUTED, inventoryItem.SerialNumber);
                    invMovement2.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.DISTRIBUTE_TO_ATHLETE };
                    invMovement2.InventoryItem = inventoryItem;

                    var invMovement3 = new InventoryMovement();
                    invMovement3.EventDate = inventoryItem.StatusLastChanged;
                    invMovement3.Description = String.Format("{0} inventory item {1}", Constants.Inventory.RECORDED_AS_LOST, inventoryItem.SerialNumber);
                    invMovement3.EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.RECORD_AS_LOST };
                    invMovement3.InventoryItem = inventoryItem;

                    invMovementRepository.Save(invMovement1);
                    invMovementRepository.Save(invMovement2);
                    invMovementRepository.Save(invMovement3);
                }
            }

            #endregion

            #region Users
            var daveCianelli = new User() { Username = "******", FirstName = "Dave", LastName = "Cianelli", Password = "******", IsAdmin = false, Status = Constants.Users.ACTIVE };
            var gregJack = new User() { Username = "******", FirstName = "Greg", LastName = "Jack", Password = "******", IsAdmin = false, Status = Constants.Users.ACTIVE };
            var charlesFoster = new User() { Username = "******", FirstName = "Charles", LastName = "Foster", Password = "******", IsAdmin = false, Status = Constants.Users.ACTIVE };
            var benThomas = new User() { Username = "******", FirstName = "Ben", LastName = "Thomas", Password = "******", IsAdmin = false, Status = Constants.Users.ACTIVE };
            var natalieHall = new User() { Username = "******", FirstName = "Natalie", LastName = "Hall", Password = "******", IsAdmin = false, Status = Constants.Users.ACTIVE };
            var bobPhillips = new User() { Username = "******", FirstName = "Bob", LastName = "Phillips", Password = "******", IsAdmin = true, Status = Constants.Users.ACTIVE };
            var staceyVidt = new User() { Username = "******", FirstName = "Stacey", LastName = "Vidt", Password = "******", IsAdmin = true, Status = Constants.Users.ACTIVE };
            #endregion

            #region User Event Area Reposibilities
            daveCianelli.EventAreaResponsibilities.Add(crossCountry);
            gregJack.EventAreaResponsibilities.Add(throws);
            charlesFoster.EventAreaResponsibilities.Add(sprints);
            charlesFoster.EventAreaResponsibilities.Add(hurdles);
            charlesFoster.EventAreaResponsibilities.Add(jumps);
            benThomas.EventAreaResponsibilities.Add(crossCountry);
            benThomas.EventAreaResponsibilities.Add(distance);
            natalieHall.EventAreaResponsibilities.Add(crossCountry);
            natalieHall.EventAreaResponsibilities.Add(distance);
            bobPhillips.EventAreaResponsibilities.Add(poleVault);
            staceyVidt.EventAreaResponsibilities.Add(crossCountry);
            staceyVidt.EventAreaResponsibilities.Add(distance);
            staceyVidt.EventAreaResponsibilities.Add(hurdles);
            staceyVidt.EventAreaResponsibilities.Add(jumps);
            staceyVidt.EventAreaResponsibilities.Add(sprints);
            staceyVidt.EventAreaResponsibilities.Add(throws);
            staceyVidt.EventAreaResponsibilities.Add(poleVault);
            #endregion

            #region Save Users
            userRepository.Save(daveCianelli);
            userRepository.Save(gregJack);
            userRepository.Save(charlesFoster);
            userRepository.Save(benThomas);
            userRepository.Save(natalieHall);
            userRepository.Save(bobPhillips);
            userRepository.Save(staceyVidt);
            #endregion
        }
        public void AssemblerCorrectlyWritesInventoryItemDto()
        {
            var eventArea = new EventArea() { EventName = Constants.EventAreas.POLE_VAULT };
            var poleVaulter = new Athlete() { Nickname = "poleVaulter", FirstName = "Pole", LastName = "Vaulter1", Gender = 'M', Status = "Current" };
            var modelDto = new ModelDto();
            var inventoryItem = new InventoryItem()
                {
                    SerialNumber = 1,
                    Model = new Model(),
                    SizeM = 9,
                    SizeW = 11,
                    Width = "N",
                    RequestName = "request1",
                    Status = "Requested",
                    StatusLastChanged = new DateTime(2012, 10, 31, 12, 0, 0),
                    EventAreaAssignment = eventArea,
                    Athlete = poleVaulter
                };
            var movement = new InventoryMovement() { EventType = new InventoryEventType() { EventType = Constants.InventoryEventTypes.ORDER } };
            inventoryItem.MovementHistory.Add(movement);

            _mockModelAssembler.Setup(x => x.WriteDto(inventoryItem.Model)).Returns(modelDto);
            _mockInventoryMovementAssembler.Setup(x => x.WriteDto(movement));
            _mockEventAreaAssembler.Setup(x => x.WriteDto(eventArea)).Returns(new EventAreaDto() { EventName = eventArea.EventName });

            var inventoryItemDto = _assembler.WriteDto(inventoryItem);

            Assert.AreEqual(inventoryItem.SerialNumber, inventoryItemDto.SerialNumber);
            Assert.AreEqual(modelDto, inventoryItemDto.ModelDto);
            Assert.AreEqual(inventoryItem.SizeM, inventoryItemDto.SizeM);
            Assert.AreEqual(inventoryItem.SizeW, inventoryItemDto.SizeW);
            Assert.AreEqual(inventoryItem.Width, inventoryItemDto.Width);
            Assert.AreEqual(inventoryItem.RequestName, inventoryItemDto.RequestName);
            Assert.AreEqual(inventoryItem.Status, inventoryItemDto.Status);
            Assert.AreEqual(inventoryItem.StatusLastChanged, inventoryItemDto.StatusLastChanged);
            Assert.AreEqual(inventoryItem.EventAreaAssignment.EventName, inventoryItemDto.EventAreaAssignmentDto.EventName);
            Assert.AreEqual(1, inventoryItemDto.MovementHistory.Count);

            _mockModelAssembler.VerifyAll();
            _mockInventoryMovementAssembler.VerifyAll();
            _mockEventAreaAssembler.VerifyAll();
        }
Example #25
0
        public InventoryMovementAddViewModel AddInventoryMovement(InventoryMovementAddViewModel model)
        {
            if (model.Journal == null)
            {
                this._closedMonthsService.ValidateIfMonthIsClosed(model.Date.Value);

                DateTime CurrentDate = DateTime.Now;
                var      entity      = model.ToEntity();

                foreach (var item in entity.InventoryMovementCostCenter)
                {
                    item.CreationDate = CurrentDate;
                }

                var movementTypeList = this._inventoryMovementTypeRepository.Get(null).ToList();

                foreach (var item in entity.InventoryProductHistorys)
                {
                    item.CreationDate = CurrentDate;
                    item.InventoryId  = model.InventoryId;

                    var movementType = movementTypeList.FirstOrDefault(x => x.Id == model.InventoryMovementTypeId);
                    if (movementType.Type == InventoryMovementTypeEnum.GiftsIn ||
                        movementType.Type == InventoryMovementTypeEnum.InventoryIn ||
                        movementType.Type == InventoryMovementTypeEnum.PositiveInventoryDifferences)
                    {
                        var product = new Product
                        {
                            BrandId           = item.BrandId,
                            InventoryId       = item.InventoryId,
                            MeasurementUnitId = item.MeasurementUnitId,
                            NetValue          = item.NetValue,
                            Price             = item.Price,
                            Quantity          = item.Quantity
                        };
                        this._ProductsRepository.Add(product);
                    }
                    else if (movementType.Type == InventoryMovementTypeEnum.GiftsOut ||
                             movementType.Type == InventoryMovementTypeEnum.InventoryOut ||
                             movementType.Type == InventoryMovementTypeEnum.NegativeInventoryDifferences ||
                             movementType.Type == InventoryMovementTypeEnum.Consists)
                    {
                    }
                    else if (movementType.Type == InventoryMovementTypeEnum.Reservation)
                    {
                        var existProduct = this._ProductsRepository.Get(null).Where(x =>
                                                                                    x.BrandId == item.BrandId && x.MeasurementUnitId == item.MeasurementUnitId);

                        if (existProduct.Count() > 0)
                        {
                        }
                        else
                        {
                            var product = new Product
                            {
                                BrandId           = item.BrandId,
                                InventoryId       = item.InventoryId,
                                MeasurementUnitId = item.MeasurementUnitId,
                                NetValue          = item.NetValue,
                                Price             = item.Price,
                                Quantity          = item.Quantity,
                                LockedCount       = item.Quantity
                            };
                            this._ProductsRepository.Add(product);
                        }
                    }
                    else if (movementType.Type == InventoryMovementTypeEnum.ReservationRebate)
                    {
                    }
                }


                //foreach (var item in model.Products)
                //{
                //   var productEntity = item.ToEntity();
                //   productEntity.InventoryId = model.InventoryId;
                //   this._ProductsRepository.Add(productEntity);
                //}


                #region translation
                entity.Description  = "";
                entity.CreationDate = CurrentDate;
                entity.Code         = model.Code;
                entity.Date         = model.Date;
                entity.Language     = Language.None;

                InventoryMovement InventoryMovementAr = new InventoryMovement
                {
                    Description  = model.DescriptionAr,
                    Language     = Language.Arabic,
                    CreationDate = CurrentDate
                };

                InventoryMovement InventoryMovementEn = new InventoryMovement
                {
                    Description  = model.DescriptionEn,
                    Language     = Language.English,
                    CreationDate = CurrentDate
                };

                entity.ChildTranslatedInventoryMovements.Add(InventoryMovementAr);
                entity.ChildTranslatedInventoryMovements.Add(InventoryMovementEn);
                #endregion


                entity = this._InventoryMovementsRepository.Add(entity);

                #region Commit Changes
                this._unitOfWork.Commit();
                #endregion

                #region Generate New Code
                try
                {
                    ConditionFilter <InventoryMovement, long> condition = new ConditionFilter <InventoryMovement, long>
                    {
                        Query = x =>
                                x.ParentKeyInventoryMovement == null &&
                                string.IsNullOrEmpty(x.Code) == false
                        ,
                        Order = Order.Descending
                    };

                    var  z          = this._InventoryMovementsRepository.Get(condition);
                    var  lastEntity = z.FirstOrDefault();
                    long newCode    = 1;

                    if (lastEntity != null)
                    {
                        try
                        {
                            newCode = long.Parse(lastEntity.Code) + 1;
                        }
                        catch
                        {
                            newCode = entity.Id;
                        }
                    }
                    entity.Code = newCode.ToString();
                }
                catch
                {
                    entity.Code = entity.Id.ToString();
                }

                entity = this._InventoryMovementsRepository.Update(entity);

                this._unitOfWork.Commit();
                #endregion

                model.Id   = entity.Id;
                model.Code = entity.Code;
                //model = entity.ToModel();
                if (movementTypeList.FirstOrDefault(x => x.Id == model.InventoryMovementTypeId).Type == InventoryMovementTypeEnum.InventoryOut)
                {
                    model.Journal = this._journalPostingsService.Post(model.Id, MovementType.StoreMovement);

                    model.Journal.Date = model.Date.Value;

                    foreach (var Journal in model.Journal.journalDetails)
                    {
                        AccountChart accountChart = this._accountChartsRepository.Get().FirstOrDefault(x => x.Id == Journal.AccountId);
                        if (accountChart != null)
                        {
                            Journal.AccountFullCode = accountChart.FullCode;
                        }
                    }
                    model.Journal.DescriptionAr = model.DescriptionAr;
                    model.Journal.DescriptionEn = model.DescriptionEn;
                }
            }
            else if (model.Journal.PostingStatus == PostingStatus.Approved)
            {
                model.Journal.PostingStatus = PostingStatus.NeedAprove;
                Journal journal = model.Journal.ToEntity();
                journal = this._journalsRepository.Add(journal);

                Journal journalAr = new Journal
                {
                    Description      = model.Journal.DescriptionAr,
                    Language         = Language.Arabic,
                    ParentKeyJournal = journal
                };
                journalAr = this._journalsRepository.Add(journalAr);
                journal.ChildTranslatedJournals.Add(journalAr);

                Journal journalEn = new Journal
                {
                    Description      = model.Journal.DescriptionEn,
                    Language         = Language.English,
                    ParentKeyJournal = journal
                };
                journalEn = this._journalsRepository.Add(journalEn);
                journal.ChildTranslatedJournals.Add(journalEn);
                var entity = this._InventoryMovementsRepository.Get(model.Id);
                entity.IsPosted       = false;
                entity.PostingDate    = DateTime.Now;
                entity.PostedByUserId = this._currentUserService.CurrentUserId;
                entity = this._InventoryMovementsRepository.Update(entity);
                this._unitOfWork.Commit();
            }
            else if (model.Journal.PostingStatus == PostingStatus.Rejected)
            {
            }
            return(model);
        }
        public async Task <int> Create(InventoryDocument model)
        {
            int created             = 0;
            var internalTransaction = _inventoryDbContext.Database.CurrentTransaction == null;
            var transaction         = !internalTransaction ? _inventoryDbContext.Database.CurrentTransaction : _inventoryDbContext.Database.BeginTransaction();

            try
            {
                model.No = GenerateNo(model);
                model.FlagForCreate(_identityInterface.Username, UserAgent);
                model.FlagForUpdate(_identityInterface.Username, UserAgent);

                foreach (var item in model.Items)
                {
                    item.FlagForCreate(_identityInterface.Username, UserAgent);
                    item.FlagForUpdate(_identityInterface.Username, UserAgent);
                }

                _dbSet.Add(model);
                created = await _inventoryDbContext.SaveChangesAsync();

                foreach (var item in model.Items)
                {
                    var qty = item.Quantity;
                    if (model.Type == "OUT")
                    {
                        qty = item.Quantity * -1;
                    }
                    var sumQty = _inventoryDbContext.InventoryMovements.Where(a => a.IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == item.ProductId && a.UomId == item.UomId).Sum(a => a.Quantity);

                    InventoryMovement movementModel = new InventoryMovement
                    {
                        ProductCode   = item.ProductCode,
                        ProductId     = item.ProductId,
                        ProductName   = item.ProductName,
                        StorageCode   = model.StorageCode,
                        StorageId     = model.StorageId,
                        StorageName   = model.StorageName,
                        Before        = sumQty,
                        Quantity      = qty,
                        After         = sumQty + qty,
                        ReferenceNo   = model.ReferenceNo,
                        ReferenceType = model.ReferenceType,
                        Type          = model.Type,
                        Date          = model.Date,
                        UomId         = item.UomId,
                        UomUnit       = item.UomUnit,
                        Remark        = item.ProductRemark
                    };

                    var movement = _serviceProvider.GetService <IInventoryMovementRepository>();
                    await movement.Create(movementModel);
                }
                if (internalTransaction)
                {
                    transaction.Commit();
                }

                return(created);
            }
            catch (Exception e)
            {
                if (internalTransaction)
                {
                    transaction.Rollback();
                }
                throw new Exception(e.Message);
            }
        }
        private static InventoryMovement GetInventoryMovement(InventoryItem inventoryItem, String inventoryEventType, String description)
        {
            var inventoryMovement = new InventoryMovement();

            inventoryMovement.EventDate = DateTime.Now;
            inventoryMovement.EventType = new InventoryEventType() { EventType = inventoryEventType };
            inventoryMovement.Description = description;
            inventoryMovement.InventoryItem = inventoryItem;

            return inventoryMovement;
        }
        public async Task <int> Create(TransferInDoc model, string username, int clientTimeZoneOffset = 7)
        {
            int Created = 0;

            using (var transaction = this.dbContext.Database.BeginTransaction())
            {
                try
                {
                    string code = GenerateCode("EFR-TB/BBP");
                    model.Code = code;


                    var SPK        = dbContext.SPKDocs.Where(x => x.PackingList == model.Reference).FirstOrDefault();
                    var expedition = dbContext.ExpeditionItems.Where(x => x.PackingList == model.Reference);
                    if (expedition.Count() != 0)
                    {
                        expedition.Single().IsReceived = true;
                    }
                    SPK.IsReceived = true;
                    var Id = SPK.Id;
                    EntityExtension.FlagForCreate(model, username, USER_AGENT);

                    var newItems = new List <TransferInDocItem>();

                    foreach (var i in model.Items)
                    {
                        var SPKItems = dbContext.SPKDocsItems.Where(x => x.ItemArticleRealizationOrder == i.ArticleRealizationOrder && x.ItemCode == i.ItemCode && i.ItemName == i.ItemName && x.SPKDocsId == Id).Single();
                        SPKItems.SendQuantity = i.Quantity;
                        var inventorymovement = new InventoryMovement();

                        int status = 0;
                        var inven  = dbContext.Inventories.OrderByDescending(x => x.CreatedUtc).Where(x => x.ItemId == i.ItemId && x.ItemCode.Contains(i.ItemCode)).FirstOrDefault();
                        if (inven != null)
                        {
                            var latestItemCode       = inven.ItemCode;
                            var latestItemCodeLength = latestItemCode.Length;
                            var latestStatus         = latestItemCode.Substring(latestItemCodeLength - 2);
                            status = int.Parse(latestStatus);
                        }
                        var countLoop = i.Quantity;
                        var itemcode  = i.ItemCode;
                        for (var j = 0; j < countLoop; j++)
                        {
                            status = status + 1;

                            i.Id       = 0;
                            i.Quantity = 1;
                            i.ItemCode = "" + itemcode + status.ToString("00");

                            TransferInDocItem transferInDocItem = new TransferInDocItem
                            {
                                ArticleRealizationOrder = i.ArticleRealizationOrder,
                                DomesticCOGS            = i.DomesticCOGS,
                                DomesticRetail          = i.DomesticRetail,
                                DomesticSale            = i.DomesticSale,
                                DomesticWholeSale       = i.DomesticWholeSale,
                                ItemCode       = "" + itemcode + status.ToString("00"),
                                ItemId         = i.ItemId,
                                ItemName       = i.ItemName,
                                Quantity       = 1,
                                Remark         = i.Remark,
                                Size           = i.Size,
                                TransferDocsId = i.TransferDocsId,
                                TransferInDocs = i.TransferInDocs,
                                Uom            = i.Uom,
                                Id             = 0
                            };

                            EntityExtension.FlagForCreate(transferInDocItem, username, USER_AGENT);
                            newItems.Add(transferInDocItem);

                            Inventory inventory = new Inventory
                            {
                                ItemArticleRealizationOrder = i.ArticleRealizationOrder,
                                ItemCode              = "" + itemcode + status.ToString("00"),
                                ItemDomesticCOGS      = i.DomesticCOGS,
                                ItemDomesticRetail    = i.DomesticRetail,
                                ItemDomesticSale      = i.DomesticSale,
                                ItemDomesticWholeSale = i.DomesticWholeSale,
                                ItemId = i.ItemId,
                                ItemInternationalCOGS      = 0,
                                ItemInternationalRetail    = 0,
                                ItemInternationalSale      = 0,
                                ItemInternationalWholeSale = 0,
                                ItemName         = i.ItemName,
                                ItemSize         = i.Size,
                                ItemUom          = i.Uom,
                                Quantity         = 1,
                                StorageCode      = model.DestinationCode,
                                StorageId        = model.DestinationId,
                                StorageName      = model.DestinationName,
                                StorageIsCentral = model.DestinationName.Contains("GUDANG") ? true : false,
                            };
                            EntityExtension.FlagForCreate(inventory, username, USER_AGENT);
                            dbSetInventory.Add(inventory);

                            inventorymovement.After                      = inventorymovement.Before + 1;
                            inventorymovement.Date                       = DateTimeOffset.UtcNow;
                            inventorymovement.ItemCode                   = "" + itemcode + status.ToString("00");
                            inventorymovement.ItemDomesticCOGS           = i.DomesticCOGS;
                            inventorymovement.ItemDomesticRetail         = i.DomesticRetail;
                            inventorymovement.ItemDomesticWholeSale      = i.DomesticRetail;
                            inventorymovement.ItemDomesticSale           = i.DomesticSale;
                            inventorymovement.ItemId                     = i.ItemId;
                            inventorymovement.ItemInternationalCOGS      = 0;
                            inventorymovement.ItemInternationalRetail    = 0;
                            inventorymovement.ItemInternationalSale      = 0;
                            inventorymovement.ItemInternationalWholeSale = 0;
                            inventorymovement.ItemName                   = i.ItemName;
                            inventorymovement.ItemSize                   = i.Size;
                            inventorymovement.ItemUom                    = i.Uom;
                            inventorymovement.Quantity                   = 1;
                            inventorymovement.StorageCode                = model.DestinationCode;
                            inventorymovement.StorageId                  = model.DestinationId;
                            inventorymovement.StorageName                = model.DestinationName;
                            inventorymovement.Type                       = "IN";
                            inventorymovement.Reference                  = code;
                            inventorymovement.Remark                     = model.Remark;
                            inventorymovement.StorageIsCentral           = model.DestinationName.Contains("GUDANG") ? true : false;
                            EntityExtension.FlagForCreate(inventorymovement, username, USER_AGENT);
                            dbSetInventoryMovement.Add(inventorymovement);
                        }
                    }

                    model.Items = newItems;
                    dbSet.Add(model);
                    Created = await dbContext.SaveChangesAsync();

                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }

            return(Created);
        }
        public async Task <int> Create(InventoryDocument model, string username)
        {
            int Created = 0;

            using (var transaction = this.dbContext.Database.BeginTransaction())
            {
                try
                {
                    model.No = await GenerateNo(model);

                    model._CreatedAgent      = "Facade";
                    model._CreatedBy         = username;
                    model._LastModifiedAgent = "Facade";
                    model._LastModifiedBy    = username;

                    foreach (var item in model.Items)
                    {
                        item._CreatedAgent      = "Facade";
                        item._CreatedBy         = username;
                        item._LastModifiedAgent = "Facade";
                        item._LastModifiedBy    = username;
                    }

                    this.dbSet.Add(model);
                    Created = await dbContext.SaveChangesAsync();

                    transaction.Commit();

                    foreach (var item in model.Items)
                    {
                        var qty = item.Quantity;
                        if (model.Type == "OUT")
                        {
                            qty = item.Quantity * -1;
                        }
                        var SumQty = dbContext.InventoryMovements.Where(a => a._IsDeleted == false && a.StorageId == model.StorageId && a.ProductId == item.ProductId && a.UomId == item.UomId).Sum(a => a.Quantity);
                        InventoryMovementFacade movement      = new InventoryMovementFacade(this.serviceProvider, this.dbContext);
                        InventoryMovement       movementModel = new InventoryMovement
                        {
                            ProductCode   = item.ProductCode,
                            ProductId     = item.ProductId,
                            ProductName   = item.ProductName,
                            StorageCode   = model.StorageCode,
                            StorageId     = model.StorageId,
                            StorageName   = model.StorageName,
                            Before        = SumQty,
                            Quantity      = qty,
                            After         = SumQty + qty,
                            ReferenceNo   = model.ReferenceNo,
                            ReferenceType = model.ReferenceType,
                            Type          = model.Type,
                            Date          = model.Date,
                            UomId         = item.UomId,
                            UomUnit       = item.UomUnit,
                            Remark        = item.ProductRemark
                        };
                        await movement.Create(movementModel, username);
                    }
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }

            return(Created);
        }
        public async Task <int> Create(TransferOutDocViewModel model, TransferOutDoc model2, string username, int clientTimeZoneOffset = 7)
        {
            int Created = 0;

            using (var transaction = this.dbContext.Database.BeginTransaction())
            {
                try
                {
                    string codeOut = GenerateCode("EFR-KB/RTP");
                    model2.Code = codeOut;
                    model2.Date = DateTimeOffset.Now;
                    List <ExpeditionItem>   expeditionItems   = new List <ExpeditionItem>();
                    List <ExpeditionDetail> expeditionDetails = new List <ExpeditionDetail>();
                    List <SPKDocsItem>      sPKDocsItem       = new List <SPKDocsItem>();
                    EntityExtension.FlagForCreate(model2, username, USER_AGENT);
                    foreach (var i in model2.Items)
                    {
                        sPKDocsItem.Add(new SPKDocsItem
                        {
                            ItemArticleRealizationOrder = i.ArticleRealizationOrder,
                            ItemCode              = i.ItemCode,
                            ItemDomesticCOGS      = i.DomesticCOGS,
                            ItemDomesticRetail    = i.DomesticRetail,
                            ItemDomesticSale      = i.DomesticSale,
                            ItemDomesticWholesale = i.DomesticWholeSale,
                            ItemId       = i.ItemId,
                            ItemName     = i.ItemName,
                            ItemSize     = i.Size,
                            ItemUom      = i.Uom,
                            Quantity     = i.Quantity,
                            Remark       = i.Remark,
                            SendQuantity = i.Quantity
                        });
                        EntityExtension.FlagForCreate(i, username, USER_AGENT);
                    }

                    dbSet.Add(model2);
                    //Created = await dbContext.SaveChangesAsync();

                    SPKDocs sPKDocs = new SPKDocs
                    {
                        Code            = GenerateCode("EFR-PK/PBJ"),
                        Date            = DateTimeOffset.Now,
                        IsDistributed   = true,
                        IsDraft         = false,
                        IsReceived      = false,
                        DestinationCode = model2.DestinationCode,
                        DestinationId   = model2.DestinationId,
                        DestinationName = model2.DestinationName,
                        PackingList     = GenerateCode("EFR-KB/PLR"),
                        Password        = String.Join("", GenerateCode(DateTime.Now.ToString("dd")).Split("/")),
                        Reference       = codeOut,
                        SourceCode      = model2.SourceCode,
                        SourceName      = model2.SourceName,
                        SourceId        = model2.SourceId,
                        Weight          = 0,
                        Items           = sPKDocsItem
                    };
                    EntityExtension.FlagForCreate(sPKDocs, username, USER_AGENT);
                    foreach (var i in sPKDocs.Items)
                    {
                        var inventorymovement = new InventoryMovement();
                        var inven             = dbContext.Inventories.Where(x => x.ItemId == i.ItemId && x.StorageId == model2.SourceId).FirstOrDefault();
                        if (inven != null)
                        {
                            inventorymovement.Before = inven.Quantity;
                            inven.Quantity           = inven.Quantity - i.Quantity;
                        }
                        inventorymovement.After                      = inventorymovement.Before + i.Quantity;
                        inventorymovement.Date                       = DateTimeOffset.UtcNow;
                        inventorymovement.ItemCode                   = i.ItemCode;
                        inventorymovement.ItemDomesticCOGS           = i.ItemDomesticCOGS;
                        inventorymovement.ItemDomesticRetail         = i.ItemDomesticRetail;
                        inventorymovement.ItemDomesticWholeSale      = i.ItemDomesticRetail;
                        inventorymovement.ItemDomesticSale           = i.ItemDomesticSale;
                        inventorymovement.ItemId                     = i.ItemId;
                        inventorymovement.ItemInternationalCOGS      = 0;
                        inventorymovement.ItemInternationalRetail    = 0;
                        inventorymovement.ItemInternationalSale      = 0;
                        inventorymovement.ItemInternationalWholeSale = 0;
                        inventorymovement.ItemName                   = i.ItemName;
                        inventorymovement.ItemSize                   = i.ItemSize;
                        inventorymovement.ItemUom                    = i.ItemUom;
                        inventorymovement.Quantity                   = i.Quantity;
                        inventorymovement.StorageCode                = model2.SourceCode;
                        inventorymovement.StorageId                  = model2.SourceId;
                        inventorymovement.StorageName                = model2.SourceName;
                        inventorymovement.Type                       = "OUT";
                        inventorymovement.Reference                  = codeOut;
                        inventorymovement.Remark                     = model2.Remark;
                        inventorymovement.StorageIsCentral           = model2.SourceName.Contains("GUDANG") ? true : false;
                        EntityExtension.FlagForCreate(inventorymovement, username, USER_AGENT);
                        dbSetInventoryMovement.Add(inventorymovement);

                        EntityExtension.FlagForCreate(i, username, USER_AGENT);
                    }
                    dbSetSPKDocs.Add(sPKDocs);
                    Created = await dbContext.SaveChangesAsync();

                    foreach (var i in sPKDocs.Items)
                    {
                        expeditionDetails.Add(new ExpeditionDetail
                        {
                            ArticleRealizationOrder = i.ItemArticleRealizationOrder,
                            DomesticCOGS            = i.ItemDomesticCOGS,
                            DomesticRetail          = i.ItemDomesticRetail,
                            DomesticSale            = i.ItemDomesticSale,
                            DomesticWholesale       = i.ItemDomesticWholesale,
                            ItemCode     = i.ItemCode,
                            ItemId       = i.ItemId,
                            ItemName     = i.ItemName,
                            Quantity     = i.Quantity,
                            Remark       = i.Remark,
                            SendQuantity = i.SendQuantity,
                            Uom          = i.ItemUom,
                            Size         = i.ItemSize,
                            //SPKDocsId = (int)dbContext.SPKDocs.OrderByDescending(x => x.Id).FirstOrDefault().Id + 1
                            SPKDocsId = (int)sPKDocs.Id
                        });
                    }

                    expeditionItems.Add(new ExpeditionItem
                    {
                        Code            = sPKDocs.Code,
                        Date            = sPKDocs.Date,
                        DestinationCode = sPKDocs.DestinationCode,
                        DestinationId   = (int)sPKDocs.DestinationId,
                        DestinationName = sPKDocs.DestinationName,
                        IsDistributed   = sPKDocs.IsDistributed,
                        IsDraft         = sPKDocs.IsDraft,
                        IsReceived      = sPKDocs.IsReceived,
                        PackingList     = sPKDocs.PackingList,
                        Password        = sPKDocs.Password,
                        Reference       = sPKDocs.Reference,
                        SourceCode      = sPKDocs.SourceCode,
                        SourceId        = (int)sPKDocs.SourceId,
                        SourceName      = sPKDocs.SourceName,
                        //SPKDocsId = (int)dbContext.SPKDocs.OrderByDescending(x => x.Id).FirstOrDefault().Id + 1,
                        SPKDocsId = (int)sPKDocs.Id,
                        Weight    = sPKDocs.Weight,
                        Details   = expeditionDetails
                    });

                    Expedition expedition = new Expedition
                    {
                        Code = GenerateCode("EFR-KB/EXP"),
                        Date = DateTimeOffset.Now,
                        ExpeditionServiceCode = model.expeditionService.code,
                        ExpeditionServiceId   = (int)model.expeditionService._id,
                        ExpeditionServiceName = model.expeditionService.name,
                        Remark = "",
                        Weight = 0,
                        Items  = expeditionItems,
                    };
                    EntityExtension.FlagForCreate(expedition, username, USER_AGENT);
                    foreach (var i in expeditionItems)
                    {
                        EntityExtension.FlagForCreate(i, username, USER_AGENT);
                        foreach (var d in expeditionDetails)
                        {
                            EntityExtension.FlagForCreate(d, username, USER_AGENT);
                        }
                    }

                    dbSetExpedition.Add(expedition);
                    Created = await dbContext.SaveChangesAsync();

                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }

            return(Created);
        }
        public async Task <int> CreateForPOS(TransferOutDoc model2, string username, int clientTimeZoneOffset = 7)
        {
            int Created = 0;

            using (var transaction = this.dbContext.Database.BeginTransaction())
            {
                try
                {
                    EntityExtension.FlagForCreate(model2, username, USER_AGENT);
                    foreach (var i in model2.Items)
                    {
                        var inventorymovement = new InventoryMovement();
                        var inven             = dbContext.Inventories.Where(x => x.ItemCode == i.ItemCode && x.StorageId == model2.SourceId).FirstOrDefault();
                        if (inven != null)
                        {
                            inventorymovement.Before = inven.Quantity;
                            inven.Quantity           = inven.Quantity - i.Quantity;
                        }
                        inventorymovement.After                      = inventorymovement.Before - i.Quantity;
                        inventorymovement.Date                       = DateTimeOffset.UtcNow;
                        inventorymovement.ItemCode                   = i.ItemCode;
                        inventorymovement.ItemDomesticCOGS           = i.DomesticCOGS;
                        inventorymovement.ItemDomesticRetail         = i.DomesticRetail;
                        inventorymovement.ItemDomesticWholeSale      = i.DomesticWholeSale;
                        inventorymovement.ItemDomesticSale           = i.DomesticSale;
                        inventorymovement.ItemId                     = i.ItemId;
                        inventorymovement.ItemInternationalCOGS      = 0;
                        inventorymovement.ItemInternationalRetail    = 0;
                        inventorymovement.ItemInternationalSale      = 0;
                        inventorymovement.ItemInternationalWholeSale = 0;
                        inventorymovement.ItemName                   = i.ItemName;
                        inventorymovement.ItemSize                   = i.Size;
                        inventorymovement.ItemUom                    = i.Uom;
                        inventorymovement.Quantity                   = i.Quantity;
                        inventorymovement.StorageCode                = model2.SourceCode;
                        inventorymovement.StorageId                  = model2.SourceId;
                        inventorymovement.StorageName                = model2.SourceName;
                        inventorymovement.Type                       = "OUT";
                        inventorymovement.Reference                  = model2.Code;
                        inventorymovement.Remark                     = model2.Remark;
                        inventorymovement.StorageIsCentral           = model2.SourceName.Contains("GUDANG") ? true : false;
                        EntityExtension.FlagForCreate(inventorymovement, username, USER_AGENT);
                        dbSetInventoryMovement.Add(inventorymovement);

                        EntityExtension.FlagForCreate(i, username, USER_AGENT);

                        //update TotalQty di tabel Items
                        var existItemId = (int)i.ItemId;
                        ItemCoreViewModelUsername itemCore = new ItemCoreViewModelUsername
                        {
                            _id      = existItemId,
                            Username = username,
                            Token    = "Bearer ",
                            TotalQty = i.Quantity
                        };

                        string             itemPutUri = $"items/finished-goods/reduce-qty-by-id/{i.ItemId}";
                        IHttpClientService httpClient = (IHttpClientService)serviceProvider.GetService(typeof(IHttpClientService));
                        var response = await httpClient.PutAsync($"{APIEndpoint.Core}{itemPutUri}", new StringContent(JsonConvert.SerializeObject(itemCore).ToString(), Encoding.UTF8, General.JsonMediaType));

                        response.EnsureSuccessStatusCode();
                    }

                    dbSet.Add(model2);
                    Created = await dbContext.SaveChangesAsync();

                    transaction.Commit();
                }
                catch (Exception e)
                {
                    transaction.Rollback();
                    throw new Exception(e.Message);
                }
            }
            return(Created);
        }