private static List <Manufacturer> ManufacturersSetup(HammondsIBMSContext context) { var manufacturers = new List <Manufacturer> { new Manufacturer { ManufacturerId = 1, Name = "Sony" }, new Manufacturer { ManufacturerId = 2, Name = "LG" }, new Manufacturer { ManufacturerId = 3, Name = "Phillips" }, new Manufacturer { ManufacturerId = 4, Name = "Samsung" }, }; //var manufacturers = (from line in File.ReadAllLines("Manufacturers.csv") // let rec = line.Split(',') // select new Manufacturer // { // ManufacturerId = int.Parse(rec[0]), // Name = rec[1] // }).ToList(); manufacturers.ForEach(m => context.Manufacturers.Add(m)); return(manufacturers); }
private static void CategoriesSetup(HammondsIBMSContext context) { #region Categories var categories = new List <Category> { new Category { CategoryId = 1, Description = "Television" }, new Category { CategoryId = 2, Description = "Blue Ray & DVD Player" }, new Category { CategoryId = 3, Description = "Home Cinema receiver" }, new Category { CategoryId = 4, Description = "Speakers" }, new Category { CategoryId = 5, Description = "PVR" } }; categories.ForEach(c => context.Categories.Add(c)); #endregion }
private static void ExchangeRangeSetup(HammondsIBMSContext context) { var rates = new List <ExchangeRate> { new ExchangeRate { ExchangeRateId = 1, Abbreviation = "GBP", Symbol = "£", CurrencyName = "Gibraltar Pound", RateToGBP = 1 }, new ExchangeRate { ExchangeRateId = 2, Abbreviation = "EUR", Symbol = "€", CurrencyName = "Euro", RateToGBP = 1.20m }, new ExchangeRate { ExchangeRateId = 3, Abbreviation = "USD", Symbol = "$", CurrencyName = "US Dollar", RateToGBP = 1.61m } }; rates.ForEach(r => context.ExchangeRates.Add(r)); }
public static void ClearTables(HammondsIBMSContext context) { context.Database.ExecuteSqlCommand("EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all' "); context.Database.ExecuteSqlCommand("EXEC sp_MSForEachTable 'DELETE FROM ?' "); context.Database.ExecuteSqlCommand("EXEC sp_msforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all' "); try { context.Database.ExecuteSqlCommand("EXEC sp_msforeachtable 'DBCC CHECKIDENT(''?'', RESEED, 0)' "); } catch { } }
private static void OneOfftypesSetup(HammondsIBMSContext context) { #region OneOffTypes var oneOffTypes = new List <OneOffType>(); for (int i = 1; i <= Enum.GetNames(typeof(OneOffTypes)).Length; i++) { oneOffTypes.Add(new OneOffType { OneOffTypeId = i, Description = Enum.GetName(typeof(OneOffTypes), i) }); } oneOffTypes.ForEach(c => context.OneOffTypes.Add(c)); #endregion }
private static void ItemChargesSetup(HammondsIBMSContext context) { var itemCharges = new List <ItemCharge> { new ItemCharge { ItemChargeId = 1, Description = "Installation", Amount = 50, PurchaseDefault = true }, new ItemCharge { ItemChargeId = 2, Description = "Tuning", Amount = 20 }, new ItemCharge { ItemChargeId = 3, Description = "Misc.", Amount = 0 } }; itemCharges.ForEach(s => context.ItemCharges.Add(s)); }
private static void InvoiceStatusSetup(HammondsIBMSContext context) { var invStatus = new List <InvoiceStatus> { new InvoiceStatus { InvoiceStatusId = 1, StatusDescription = "Pending" }, new InvoiceStatus { InvoiceStatusId = 2, StatusDescription = "Attached" }, new InvoiceStatus { InvoiceStatusId = 3, StatusDescription = "Closed" } }; invStatus.ForEach(c => context.InvoiceStatuses.Add(c)); }
private static void EmployersSetup(HammondsIBMSContext context) { #region Employers var employers = new List <Employer>() { new Employer { EmployerName = "ACME Ltd", Address = new Address { AddressLine1 = "Mojavi Desert" } } }; employers.ForEach(e => context.Employers.Add(e)); #endregion }
public static void Populate(HammondsIBMSContext context, bool loadTestData = true) { ExchangeRangeSetup(context); var pCycles = ProductLifeCyclesSetup(context); AccountTypesChangeableProductLifeCyclesSetup(context, pCycles); InvoiceStatusSetup(context); CategoriesSetup(context); PaymentPeriodsSetup(context); ContractTypesSetup(context); var paymentSources = PaymentSourcesSetup(context); AccountTypesSetup(context); OneOfftypesSetup(context); PaymentTypesSetup(context); MiscSetup(context); if (loadTestData) { SuppliersSetup(context); var manufactures = ManufacturersSetup(context); ModelsSetup(context, manufactures); StockSetup(context); ItemChargesSetup(context); CustomersSetup(context, paymentSources); DocumentTemplatesSetup(context); EmployersSetup(context); } }
private static void ContractTypesSetup(HammondsIBMSContext context) { #region Contract Types var contractTypes = new List <ContractType> { new ContractType { ContractTypeId = 1, Description = "Manufacturer Guarantee", PeriodInMonths = 24, NormalTermAmount = 0, PurchaseDefault = true, PaymentPeriodId = 4 }, new ContractType { ContractTypeId = 2, Description = "Hammonds Free Technical Service", PeriodInMonths = 12, NormalTermAmount = 0, PurchaseDefault = true, PaymentPeriodId = 4 }, new ContractType { ContractTypeId = 3, Description = "Hammonds Technical Service", PeriodInMonths = 12, NormalTermAmount = 80, PaymentPeriodId = 4 }, new ContractType { ContractTypeId = 4, Description = "Hammonds Hardware Maintenance", PeriodInMonths = 12, NormalTermAmount = 50, PaymentPeriodId = 4 }, }; contractTypes.ForEach(s => context.ContractTypes.Add(s)); #endregion }
private static void AccountTypesSetup(HammondsIBMSContext context) { #region AccountTypes var accTypes = new List <TransactionType>(); for (int i = 1; i <= Enum.GetNames(typeof(TransactionTypes)).Length; i++) { accTypes.Add(new TransactionType { TransactionTypeId = i, Description = Enum.GetName(typeof(TransactionTypes), i) }); } accTypes.ForEach(c => context.AccountEntryTypes.Add(c)); #endregion }
private static void PaymentTypesSetup(HammondsIBMSContext context) { #region PaymentTypes var pmtTypes = new List <PaymentItemType>(); for (int i = 1; i <= Enum.GetNames(typeof(PaymentItemTypes)).Length; i++) { pmtTypes.Add(new PaymentItemType { PaymentItemTypeId = i, Description = Enum.GetName(typeof(PaymentItemTypes), i) }); } pmtTypes.ForEach(c => context.PaymentItemTypes.Add(c)); #endregion }
private static void SuppliersSetup(HammondsIBMSContext context) { var suppliers = new List <Supplier> { new Supplier { SupplierId = 1, Name = "OverClockers UK", Address = new Address { AddressLine1 = "4 Axis - Millennium Way", AddressLine2 = "High Carr Business Park", AddressLine3 = "", City = "Newcastle-under-Lyme", PostCode = "ST5 7UF", Country = "United Kingdom" }, ContactInfo = new ContactInfo { Email = "*****@*****.**", Tel = "0044 871 200 5053" }, ExchangeRateId = 1 }, new Supplier { SupplierId = 2, Name = "Inelec S.A.", Address = new Address { AddressLine1 = "C/ Bocángel, 38", AddressLine2 = "28028 Madrid", City = "Madrid", Country = "Spain" }, ContactInfo = new ContactInfo { Email = "*****@*****.**", Tel = "0034 91 726 35 00" }, ExchangeRateId = 2 } }; suppliers.ForEach(s => context.Suppliers.Add(s)); }
private static void PaymentPeriodsSetup(HammondsIBMSContext context) { #region Payment Periods var paymentPeriods = new List <PaymentPeriod> { new PaymentPeriod { PaymentPeriodId = 1, Description = "Monthly", PeriodInMonths = 1 }, new PaymentPeriod { PaymentPeriodId = 4, Description = "Yearly", PeriodInMonths = 12 }, }; paymentPeriods.ForEach(s => context.PaymentPeriods.Add(s)); #endregion }
private static List <PaymentSource> PaymentSourcesSetup(HammondsIBMSContext context) { var paymentSources = new List <PaymentSource>() { new PaymentSource { Description = "Cash" }, new PaymentSource { Description = "Credit Card" }, new PaymentSource { Description = "Standing Order" }, new PaymentSource { Description = "Cheque" } }; paymentSources.ForEach(c => context.PaymentSources.Add(c)); return(paymentSources); }
private static void CustomersSetup(HammondsIBMSContext context, List <PaymentSource> paymentSources) { #region Customers var customers = new List <Customer>(); using ( var csv = new CsvReader(new StreamReader(HttpContext.Current.Server.MapPath(MigrationFilePath + "/customer.csv")), false)) { while (csv.ReadNextRecord()) { var firstName = ""; if (csv[2].Split(' ').Length > 1) { for (int i = 1; i < csv[2].Split(' ').Length; i++) { firstName += csv[2].Split(' ')[i]; } } customers.Add(new Customer { CustomerId = int.Parse(csv[0]), Surname = csv[2].Split(' ')[0], FirstName = firstName, Address = new Address { AddressLine1 = csv[3] }, PreferredPaymentSource = paymentSources[0] }); } } customers.ForEach(s => context.Customers.Add(s)); #endregion }
private static void AccountTypesChangeableProductLifeCyclesSetup(HammondsIBMSContext context, List <ProductLifeCycle> pCycles) { var atcplc = new List <AccountTypeChangeableLifeCycle> { new AccountTypeChangeableLifeCycle { AccountType = (int)AccountType.Purchase, ProductLifeCycle = pCycles.Find(m => m.ProductLifeCycleId == (int)ProductLifeCycleStatus.Sold) }, new AccountTypeChangeableLifeCycle { AccountType = (int)AccountType.Purchase, ProductLifeCycle = pCycles.Find(m => m.ProductLifeCycleId == (int)ProductLifeCycleStatus.InStock) }, new AccountTypeChangeableLifeCycle { AccountType = (int)AccountType.Purchase, ProductLifeCycle = pCycles.Find(m => m.ProductLifeCycleId == (int)ProductLifeCycleStatus.ReRental) }, new AccountTypeChangeableLifeCycle { AccountType = (int)AccountType.Rent, ProductLifeCycle = pCycles.Find(m => m.ProductLifeCycleId == (int)ProductLifeCycleStatus.ReRental) }, new AccountTypeChangeableLifeCycle { AccountType = (int)AccountType.Rent, ProductLifeCycle = pCycles.Find(m => m.ProductLifeCycleId == (int)ProductLifeCycleStatus.Scrapped) }, }; atcplc.ForEach(c => context.AccountTypeChangeableLifeCycles.Add(c)); }
private static void DocumentTemplatesSetup(HammondsIBMSContext context) { #region Document Templates var docTemplates = new List <DocumentTemplate> { new PurchaseContractDocumentTemplate { DocumentTemplateId = (int)DocumentTemplateTypes.Sale, Title = "Sale", Body = GetDocumentTemplateText("Sale.txt") }, new RentContractDocumentTemplate { DocumentTemplateId = (int)DocumentTemplateTypes.Rent, Title = "Rent", Body = GetDocumentTemplateText("Rent.txt") }, }; docTemplates.ForEach(m => context.DocumentTemplates.Add(m)); #endregion }
private static List <ProductLifeCycle> ProductLifeCyclesSetup(HammondsIBMSContext context) { var pCycles = new List <ProductLifeCycle>() { new ProductLifeCycle { ProductLifeCycleId = 1, ContractChangeable = false, Description = "InStock", DescriptionAbbreviation = "IS", NotAttachedStatus = true, ProductLifeCycleActions = (ProductLifeCycleActions.CanBeSold | ProductLifeCycleActions.CanBeRented), }, new ProductLifeCycle { ProductLifeCycleId = 2, ContractChangeable = false, Description = "Sold", DescriptionAbbreviation = "SD", NotAttachedStatus = false, ProductLifeCycleActions = ProductLifeCycleActions.NoAction, }, new ProductLifeCycle { ProductLifeCycleId = 3, ContractChangeable = false, Description = "Rented", DescriptionAbbreviation = "RT", NotAttachedStatus = false, ProductLifeCycleActions = ProductLifeCycleActions.NoAction, }, new ProductLifeCycle { ProductLifeCycleId = 4, ContractChangeable = true, Description = "ReRental", DescriptionAbbreviation = "RR", NotAttachedStatus = true, ProductLifeCycleActions = ProductLifeCycleActions.CanBeRented, }, new ProductLifeCycle { ProductLifeCycleId = 5, ContractChangeable = false, Description = "Scrapped", DescriptionAbbreviation = "SC", NotAttachedStatus = true, ProductLifeCycleActions = ProductLifeCycleActions.NoAction, }, new ProductLifeCycle { ProductLifeCycleId = 6, ContractChangeable = false, Description = "Reserved", DescriptionAbbreviation = "RV", NotAttachedStatus = true, ProductLifeCycleActions = ProductLifeCycleActions.NoAction, }, }; pCycles.ForEach(c => context.ProductLifeCycles.Add(c)); return(pCycles); }
private static void MiscSetup(HammondsIBMSContext context) { #region Misc var miscs = new List <Misc>() { new Misc { MiscId = (int)MiscIdentifier.DefaultDutyPercentage, Identifier = "Default Duty Percentage", Value = "12", ValueRegexFilter = @"^[0-9]+(?:\.[0-9]*)?$", FormatExample = "12, 12.5, 10.12", CanEdit = true }, new Misc { MiscId = (int)MiscIdentifier.LastBillCycle, Identifier = "Last Bill Cycle", Value = "2012-02", ValueRegexFilter = @"^2[0-9]{3}-(0[1-9]|1[0-2])$", FormatExample = "2012-04 [format : yyyy-mm]", CanEdit = true }, new Misc { MiscId = (int)MiscIdentifier.MinPeriodForBillCycles, Identifier = "Minimum period(days) between Bill Cycles", Value = "27", ValueRegexFilter = @"^([0-9]{1}|[1-2][0-9]|3[0-2])$", FormatExample = "27 [Range : 0-33]", CanEdit = true }, new Misc { MiscId = (int)MiscIdentifier.ContractExpiryWarningPeriod, Identifier = "Contract Expiry Warning (days before)", Value = "30", ValueRegexFilter = @"^([1-9]{1}|[1-2][0-9]{2})$", FormatExample = "27 [Range : 1-299]", CanEdit = true }, new Misc { MiscId = (int)MiscIdentifier.DefaultDepositPerUnit, Identifier = "Default deposit per rental unit", Value = "50", ValueRegexFilter = @"^([0-9]{1}|[1][0-9]{1,3})$", FormatExample = "55 [Range : 0-1999]", CanEdit = true }, new Misc { MiscId = (int)MiscIdentifier.LastHouseKeep, Identifier = "Last House Keep Date", Value = "1/1/1970", ValueRegexFilter = @"^2[0-9]{3}-(0[1-9]|1[0-2])$", FormatExample = "1/1/1970[format : dd/mm/yy]", CanEdit = false } }; miscs.ForEach(c => context.Miscs.Add(c)); #endregion }
private static void ModelsSetup(HammondsIBMSContext context, List <Manufacturer> manufactures) { var models = new List <Model> { new Model { //ModelId = 1, ModelCode = "KDL-52HX903", Summary = "52” (132cm), Full HD 1080, 3D LCD TV with Intelligent Dynamic Full LED & Motionflow 400 PRO", Manufacturer = manufactures[0], CategoryId = 1, Size = 52, RetailPrice = 1000, RentalPrice = 100, SpainRetailPrice = 1500 }, new Model { //ModelId = 2, ModelCode = "KDL-55NX813", Summary = "139cm/55, Full HD 1080, 3D LCD TV with Dynamic Edge LED, Monolithic Design & built-in Wi-Fi® access", Manufacturer = manufactures[0], CategoryId = 1, Size = 55 }, new Model { //ModelId = 3, ModelCode = "LG 55LW650T", Summary = "55\" Cinema 3D LED TV with Smart TV, freeview HD and 200Hz", Manufacturer = manufactures[1], CategoryId = 1, Size = 55, RetailPrice = 2000, RentalPrice = 200, SpainRetailPrice = 2600 }, new Model { //ModelId = 4, ModelCode = "LG 47LW650T", Summary = "47\" Cinema 3D LED TV with Smart TV, freeview HD and 200Hz", Manufacturer = manufactures[1], CategoryId = 1, Size = 47 }, new Model { // ModelId = 5, ModelCode = "46PFL9705H/12", Summary = "46\" Full HD 1080p digital TV", Manufacturer = manufactures[2], CategoryId = 1, Size = 46, //Image = (new IbmsImage{Name="46PFL9705H/12"}).LoadFile(HttpContext.Current.Server.MapPath(@"~/DataScaffolding/PopulationData/32PFL5605H_05.jpg")) }, new Model { // ModelId = 6, ModelCode = "40PFL9705H/12", Summary = "40\" Full HD 1080p digital TV", Manufacturer = manufactures[2], CategoryId = 1, Size = 40 }, new Model { //ModelId = 2, ModelCode = "KDL-22EX553", Summary = "55cm / 22\", HD Ready TV with Edge LED, X-Reality, built-in Wi-Fi® and Sony Internet TV", Manufacturer = manufactures[0], CategoryId = 1, Size = 22 }, new Model { //ModelId = 2, ModelCode = "KDL-32EX653", Summary = "80cm / 32\", Full HD TV with Edge LED, X-Reality, built-in Wi-Fi® and Sony Internet TV", Manufacturer = manufactures[0], CategoryId = 1, Size = 32 }, new Model { //ModelId = 2, ModelCode = "KDL-40HX753", Summary = "102cm / 40\", Full HD 3D with Dynamic Edge LED, X-Reality, built-in Wi-Fi and Sony Internet TV", Manufacturer = manufactures[0], CategoryId = 1, Size = 40 }, new Model { //ModelId = 2, ModelCode = "BDP-S790", Summary = "Full HD and 3D with built-in Wi-Fi®, PC streaming, Skype™, Digital Cinema 4K, HDMI® x 2", Manufacturer = manufactures[0], CategoryId = 2, Size = 0 }, new Model { //ModelId = 2, ModelCode = "BDP-S490", Summary = "Full HD and 3D with access to the Sony Entertainment Network, PC streaming, 2 x USB and Quickstart", Manufacturer = manufactures[0], CategoryId = 2, Size = 0 }, }; models.ForEach(m => context.Models.Add(m)); }
public HammondsIBMSContext Get() { return(dataContext ?? (dataContext = new HammondsIBMSContext())); }
private static void StockSetup(HammondsIBMSContext context) { var stocks = new List <Stock>(); using ( var csv = new CsvReader(new StreamReader(HttpContext.Current.Server.MapPath(MigrationFilePath + "/stock.csv")), true)) { while (csv.ReadNextRecord()) { stocks.Add(new Stock { ModelId = int.Parse(csv[1]), SerialNumber = csv[2], Identifier = csv[3], LandedCost = decimal.Parse(csv[4]), ProductLifeCycleId = int.Parse(csv[5]), InvoiceStatusId = int.Parse(csv[6]) }); } } //var stocks = new List<Stock> // { // new Stock // { // //StockId = 1, // Model=models[3], // SerialNumber = "123456789012", // Identifier = "456-"+ models[3].ModelCode, // ProductLifeCycleId = 1, // InvoiceStatusId = 1, // //History = new List<History>{new History // //{ // // HistoryId = 1, // // ProductLifeCycle = pCycles[0], // // TimeStamp = DateTime.Now} // //} // }, // new Stock // { // // StockId = 2, // Model=models[2], // SerialNumber = "166656789012", // Identifier = "555-"+ models[3].ModelCode, // ProductLifeCycleId = 1, // InvoiceStatusId=1, // // History = new List<History>{new History // //{ // // HistoryId = 1, // // ProductLifeCycle = pCycles[0], // // TimeStamp = DateTime.Now} // //} // }, // new Stock // { // // StockId = 3, // Model=models[3], // SerialNumber = "12345679000", // Identifier = "499-"+ models[3].ModelCode, // ProductLifeCycleId = 1, // InvoiceStatusId=1, // // History = new List<History>{new History // //{ // // HistoryId = 1, // // ProductLifeCycle = pCycles[0], // // TimeStamp = DateTime.Now} // //} // }, // new Stock // { // //StockId = 4, // Model=models[3], // SerialNumber = "736520973649", // Identifier = "666-"+ models[3].ModelCode, // ProductLifeCycleId = 1, // InvoiceStatusId=1, // // History = new List<History>{new History // //{ // // HistoryId = 1, // // ProductLifeCycle = pCycles[0], // // TimeStamp = DateTime.Now} // //} // }, // new Stock // { // //StockId = 5, // Model=models[4], // SerialNumber = "720973653649", // Identifier = "667-"+ models[4].ModelCode, // ProductLifeCycleId = 1, // InvoiceStatusId=1, // //History = new List<History>{new History // //{ // // HistoryId = 1, // // ProductLifeCycle = pCycles[0], // // TimeStamp = DateTime.Now} // //} // }, // new Stock // { // // StockId = 6, // Model=models[4], // SerialNumber = "736497365209", // Identifier = "668-"+ models[4].ModelCode, // ProductLifeCycleId = 1, // InvoiceStatusId=1, // //History = new List<History> // //{ // // new History // // { // // HistoryId = 1, // // ProductLifeCycle = pCycles[0], // // TimeStamp = DateTime.Now // // }, // // new History // // { // // HistoryId = 1, // // ProductLifeCycle = pCycles[1], // // TimeStamp = DateTime.Now // // } // //} // }, // }; stocks.ForEach(s => context.Stocks.Add(s)); }