#pragma warning restore 0649 public static void LoadSuppliers() { using (NorthwindDataContext db = new NorthwindDataContext()) { List<SupplierFaxCSV> faxes = Csv.ReadFile<SupplierFaxCSV>("SupplierFaxes.csv", culture: CultureInfo.GetCultureInfo("es")); var faxDic = faxes.ToDictionary(r => r.SupplierID, r => r.Fax); Administrator.SaveListDisableIdentity(db.Suppliers.Select(s => new SupplierEntity { CompanyName = s.CompanyName, ContactName = s.ContactName, ContactTitle = s.ContactTitle, Phone = s.Phone.Replace(".", " "), Fax = faxDic[s.SupplierID].Replace(".", " "), Address = new AddressEntity { Address = s.Address, City = s.City, Region = s.Region, PostalCode = s.PostalCode, Country = s.Country }, }.SetId(s.SupplierID))); } }
public static void LoadPersons() { using (NorthwindDataContext db = new NorthwindDataContext()) { db.Customers.Where(c => c.ContactTitle.Contains("Owner")).Select(c => new PersonEntity { FirstName = c.ContactName.Substring(0, c.ContactName.LastIndexOf(' ')), LastName = c.ContactName.Substring(c.ContactName.LastIndexOf(' ') + 1), DateOfBirth = null, Title = null, Address = new AddressEntity { Address = c.Address, City = c.City, Region = c.Region, PostalCode = c.PostalCode, Country = c.Country, }, Phone = c.Phone.Replace(".", " "), Fax = c.Fax.Replace(".", " "), Corrupt = true, }).SaveList(); } }
public static void LoadPersons() { using (NorthwindDataContext db = new NorthwindDataContext()) { db.Customers.Where(c => c.ContactTitle.Contains("Owner")).Select(c => new PersonEntity { FirstName = c.ContactName.Substring(0, c.ContactName.LastIndexOf(' ')), LastName = c.ContactName.Substring(c.ContactName.LastIndexOf(' ') + 1), DateOfBirth = null, Title = null, Address = new AddressEntity { Address = c.Address, City = c.City, Region = c.Region, PostalCode = c.PostalCode, Country = c.Country, }, Phone = c.Phone.Replace(".", " "), Fax = c.Fax.Replace(".", " "), Corrupt = true, }).SaveList(); } }
public static void LoadOrders() { using (NorthwindDataContext db = new NorthwindDataContext()) { var northwind = db.Customers.Select(a => new { a.CustomerID, a.ContactName }).ToList(); var companies = Database.Query<CompanyEntity>().Select(c => new { Lite = c.ToLite<CustomerEntity>(), c.ContactName }).ToList(); var persons = Database.Query<PersonEntity>().Select(p => new { Lite = p.ToLite<CustomerEntity>(), ContactName = p.FirstName + " " + p.LastName }).ToList(); Dictionary<string, Lite<CustomerEntity>> customerMapping = (from n in northwind join s in companies.Concat(persons) on n.ContactName equals s.ContactName select new KeyValuePair<string, Lite<CustomerEntity>>(n.CustomerID, s.Lite)).ToDictionary(); db.Orders.GroupsOf(10).ProgressForeachDisableIdentity(typeof(OrderEntity), l => l.ToInterval(a => a.OrderID).ToString(), null, (orders, writer) => { using (OperationLogic.AllowSave<OrderEntity>()) orders.Select(o => new OrderEntity { Employee = Lite.Create<EmployeeEntity>(o.EmployeeID.Value), OrderDate = o.OrderDate.Value, RequiredDate = o.RequiredDate.Value, ShippedDate = o.ShippedDate, State = o.ShippedDate.HasValue ? OrderState.Shipped : OrderState.Ordered, ShipVia = Lite.Create<ShipperEntity>(o.ShipVia.Value), ShipName = o.ShipName, ShipAddress = new AddressEntity { Address = o.ShipAddress, City = o.ShipCity, Region = o.ShipRegion, PostalCode = o.ShipPostalCode, Country = o.ShipCountry, }, Freight = o.Freight.Value, Details = o.Order_Details.Select(od => new OrderDetailsEntity { Discount = (decimal)od.Discount, Product = Lite.Create<ProductEntity>(od.ProductID), Quantity = od.Quantity, UnitPrice = od.UnitPrice, }).ToMList(), Customer = customerMapping[o.CustomerID].RetrieveAndForget(), IsLegacy = true, }.SetId(o.OrderID)).SaveList(); }); } }
public static void LoadOrders() { using (NorthwindDataContext db = new NorthwindDataContext()) { var northwind = db.Customers.Select(a => new { a.CustomerID, a.ContactName }).ToList(); var companies = Database.Query <CompanyEntity>().Select(c => new { Lite = c.ToLite <CustomerEntity>(), c.ContactName }).ToList(); var persons = Database.Query <PersonEntity>().Select(p => new { Lite = p.ToLite <CustomerEntity>(), ContactName = p.FirstName + " " + p.LastName }).ToList(); Dictionary <string, Lite <CustomerEntity> > customerMapping = (from n in northwind join s in companies.Concat(persons) on n.ContactName equals s.ContactName select new KeyValuePair <string, Lite <CustomerEntity> >(n.CustomerID, s.Lite)).ToDictionary(); db.Orders.GroupsOf(10).ProgressForeachDisableIdentity(typeof(OrderEntity), l => l.ToInterval(a => a.OrderID).ToString(), null, (orders, writer) => { using (OperationLogic.AllowSave <OrderEntity>()) orders.Select(o => new OrderEntity { Employee = Lite.Create <EmployeeEntity>(o.EmployeeID.Value), OrderDate = o.OrderDate.Value, RequiredDate = o.RequiredDate.Value, ShippedDate = o.ShippedDate, State = o.ShippedDate.HasValue ? OrderState.Shipped : OrderState.Ordered, ShipVia = Lite.Create <ShipperEntity>(o.ShipVia.Value), ShipName = o.ShipName, ShipAddress = new AddressEntity { Address = o.ShipAddress, City = o.ShipCity, Region = o.ShipRegion, PostalCode = o.ShipPostalCode, Country = o.ShipCountry, }, Freight = o.Freight.Value, Details = o.Order_Details.Select(od => new OrderDetailsEntity { Discount = (decimal)od.Discount, Product = Lite.Create <ProductEntity>(od.ProductID), Quantity = od.Quantity, UnitPrice = od.UnitPrice, }).ToMList(), Customer = customerMapping[o.CustomerID].RetrieveAndForget(), IsLegacy = true, }.SetId(o.OrderID)).SaveList(); }); } }
public static void LoadRegions() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Regions.Select(r => new RegionEntity { Description = r.RegionDescription.Trim() }.SetId(r.RegionID))); } }
public static void LoadRegions() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Regions.Select(r => new RegionEntity { Description = r.RegionDescription.Trim() }.SetId(r.RegionID))); } }
public static void LoadShippers() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Shippers.Select(s => new ShipperEntity { CompanyName = s.CompanyName, Phone = s.Phone, }.SetId(s.ShipperID))); } }
public static void LoadShippers() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Shippers.Select(s => new ShipperEntity { CompanyName = s.CompanyName, Phone = s.Phone, }.SetId(s.ShipperID))); } }
public static void LoadCategories() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Categories.Select(s => new CategoryEntity { CategoryName = s.CategoryName, Description = s.Description, Picture = new EmbeddedFileEntity { FileName = s.CategoryName + ".jpg", BinaryFile = EmployeeLoader.RemoveOlePrefix(s.Picture.ToArray()) }, }.SetId(s.CategoryID))); } }
public static void LoadCategories() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Categories.Select(s => new CategoryEntity { CategoryName = s.CategoryName, Description = s.Description, Picture = new EmbeddedFileEntity { FileName = s.CategoryName + ".jpg", BinaryFile = EmployeeLoader.RemoveOlePrefix(s.Picture.ToArray()) }, }.SetId(s.CategoryID))); } }
public static void LoadProducts() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Products.Select(s => new ProductEntity { ProductName = s.ProductName, Supplier = Lite.Create<SupplierEntity>(s.SupplierID.Value), Category = Lite.Create<CategoryEntity>(s.CategoryID.Value), QuantityPerUnit = s.QuantityPerUnit, UnitPrice = s.UnitPrice.Value, UnitsInStock = s.UnitsInStock.Value, ReorderLevel = s.ReorderLevel.Value, Discontinued = s.Discontinued, }.SetId(s.ProductID))); } }
public static void LoadProducts() { using (NorthwindDataContext db = new NorthwindDataContext()) { Administrator.SaveListDisableIdentity(db.Products.Select(s => new ProductEntity { ProductName = s.ProductName, Supplier = Lite.Create <SupplierEntity>(s.SupplierID.Value), Category = Lite.Create <CategoryEntity>(s.CategoryID.Value), QuantityPerUnit = s.QuantityPerUnit, UnitPrice = s.UnitPrice.Value, UnitsInStock = s.UnitsInStock.Value, ReorderLevel = s.ReorderLevel.Value, Discontinued = s.Discontinued, }.SetId(s.ProductID))); } }
public static void LoadCompanies() { using (NorthwindDataContext db = new NorthwindDataContext()) { db.Customers.Where(c => !c.ContactTitle.Contains("Owner")).Select(c => new CompanyEntity { CompanyName = c.CompanyName, ContactName = c.ContactName, ContactTitle = c.ContactTitle, Address = new AddressEntity { Address = c.Address, City = c.City, Region = c.Region, PostalCode = c.PostalCode, Country = c.Country, }, Phone = c.Phone.Replace(".", " "), Fax = c.Fax.Replace(".", " "), }).SaveList(); } }
public static void LoadTerritories() { using (NorthwindDataContext db = new NorthwindDataContext()) { var regionDic = Database.RetrieveAll <RegionEntity>().ToDictionary(a => a.Id); var territories = (from t in db.Territories.ToList() group t by t.TerritoryDescription into g select new { Description = g.Key.Trim(), Id = g.Select(t => t.TerritoryID).OrderBy().First(), RegionID = g.Select(r => r.RegionID).Distinct().Single(), }).ToList(); Administrator.SaveListDisableIdentity(territories.Select(t => new TerritoryEntity { Description = t.Description.Trim(), Region = regionDic[t.RegionID] }.SetId(int.Parse(t.Id)))); } }
public static void LoadTerritories() { using (NorthwindDataContext db = new NorthwindDataContext()) { var regionDic = Database.RetrieveAll<RegionEntity>().ToDictionary(a => a.Id); var territories = (from t in db.Territories.ToList() group t by t.TerritoryDescription into g select new { Description = g.Key.Trim(), Id = g.Select(t => t.TerritoryID).OrderBy().First(), RegionID = g.Select(r => r.RegionID).Distinct().Single(), }).ToList(); Administrator.SaveListDisableIdentity(territories.Select(t => new TerritoryEntity { Description = t.Description.Trim(), Region = regionDic[t.RegionID] }.SetId(int.Parse(t.Id)))); } }
public static void LoadCompanies() { using (NorthwindDataContext db = new NorthwindDataContext()) { db.Customers.Where(c => !c.ContactTitle.Contains("Owner")).Select(c => new CompanyEntity { CompanyName = c.CompanyName, ContactName = c.ContactName, ContactTitle = c.ContactTitle, Address = new AddressEntity { Address = c.Address, City = c.City, Region = c.Region, PostalCode = c.PostalCode, Country = c.Country, }, Phone = c.Phone.Replace(".", " "), Fax = c.Fax.Replace(".", " "), }).SaveList(); } }
public static void LoadEmployees() { using (NorthwindDataContext db = new NorthwindDataContext()) { var duplicateMapping = (from t in db.Territories.ToList() group int.Parse(t.TerritoryID) by t.TerritoryDescription into g where g.Count() > 1 let min = g.Min() from item in g.Except(new[] { min }) select new { Min = min, Item = item }).ToDictionary(a => a.Item, a => a.Min); var territoriesDic = Database.RetrieveAll <TerritoryEntity>().ToDictionary(a => a.Id); var exmployeeTerritories = (from e in db.Employees from t in e.EmployeeTerritories select new { e.EmployeeID, t.TerritoryID }).ToList() .AgGroupToDictionary(a => a.EmployeeID, gr => gr.Select(a => int.Parse(a.TerritoryID)) .Select(id => duplicateMapping.TryGet(id, id)) .Select(id => territoriesDic[id]) .Distinct().ToMList()); Administrator.SaveListDisableIdentity( from e in db.Employees select new EmployeeEntity { BirthDate = e.BirthDate, FirstName = e.FirstName, LastName = e.LastName, TitleOfCourtesy = e.TitleOfCourtesy, HomePhone = e.HomePhone, Extension = e.Extension, HireDate = e.HireDate, Photo = new FileEntity { FileName = e.PhotoPath.AfterLast('/'), BinaryFile = RemoveOlePrefix(e.Photo.ToArray()) }.ToLiteFat(), PhotoPath = e.PhotoPath, Address = new AddressEntity { Address = e.Address, City = e.City, Country = e.Country, Region = e.Region, PostalCode = e.PostalCode, }, Notes = e.Notes, Territories = exmployeeTerritories[e.EmployeeID], }.SetId(e.EmployeeID)); var pairs = (from e in db.Employees where e.ReportsTo != null select new { e.EmployeeID, e.ReportsTo }); foreach (var pair in pairs) { EmployeeEntity employee = Database.Retrieve <EmployeeEntity>(pair.EmployeeID); employee.ReportsTo = Lite.Create <EmployeeEntity>(pair.ReportsTo.Value); employee.Save(); } } }
public static void LoadEmployees() { using (NorthwindDataContext db = new NorthwindDataContext()) { var duplicateMapping = (from t in db.Territories.ToList() group int.Parse(t.TerritoryID) by t.TerritoryDescription into g where g.Count() > 1 let min = g.Min() from item in g.Except(new[] { min }) select new { Min = min, Item = item }).ToDictionary(a => a.Item, a => a.Min); var territoriesDic = Database.RetrieveAll<TerritoryEntity>().ToDictionary(a => a.Id); var exmployeeTerritories = (from e in db.Employees from t in e.EmployeeTerritories select new { e.EmployeeID, t.TerritoryID }).ToList() .AgGroupToDictionary(a => a.EmployeeID, gr => gr.Select(a => int.Parse(a.TerritoryID)) .Select(id => duplicateMapping.TryGet(id, id)) .Select(id => territoriesDic[id]) .Distinct().ToMList()); Administrator.SaveListDisableIdentity( from e in db.Employees select new EmployeeEntity { BirthDate = e.BirthDate, FirstName = e.FirstName, LastName = e.LastName, TitleOfCourtesy = e.TitleOfCourtesy, HomePhone = e.HomePhone, Extension = e.Extension, HireDate = e.HireDate, Photo = new FileEntity { FileName = e.PhotoPath.AfterLast('/'), BinaryFile = RemoveOlePrefix(e.Photo.ToArray()) }.ToLiteFat(), PhotoPath = e.PhotoPath, Address = new AddressEntity { Address = e.Address, City = e.City, Country = e.Country, Region = e.Region, PostalCode = e.PostalCode, }, Notes = e.Notes, Territories = exmployeeTerritories[e.EmployeeID], }.SetId(e.EmployeeID)); var pairs = (from e in db.Employees where e.ReportsTo != null select new { e.EmployeeID, e.ReportsTo }); foreach (var pair in pairs) { EmployeeEntity employee = Database.Retrieve<EmployeeEntity>(pair.EmployeeID); employee.ReportsTo = Lite.Create<EmployeeEntity>(pair.ReportsTo.Value); employee.Save(); } } }