public void CanMigrateTitles() { Dictionary<int, int> contactMap = new Dictionary<int, int>(); Dictionary<int, int> titleMap = new Dictionary<int, int>(); WavePoetry.DataAccess.TitleData titles = new WavePoetry.DataAccess.TitleData(); WavePoetry.DataAccess.ReviewData reviews = new WavePoetry.DataAccess.ReviewData(); WavePoetry.DataAccess.ShipmentData shipments = new WavePoetry.DataAccess.ShipmentData(); WavePoetry.DataAccess.ContactData contacts = new WavePoetry.DataAccess.ContactData(); WavePoetry.DataAccess.AdminData adminData = new WavePoetry.DataAccess.AdminData(); WavePoetry.OldDataAccess.waveoldEntities dbContext = new WavePoetry.OldDataAccess.waveoldEntities(); //////////// /// TITLES /// ////// var oldTitles = dbContext.titles.ToList(); foreach (title t in oldTitles) { var savedT = titles.Search(new TitleSearch { Title = t.title1 }).FirstOrDefault(); titleMap.Add(t.id, savedT.TitleId); } //////////// /// CONTACTS /// ////// /// var oldContacts = dbContext.contacts.ToList(); foreach (contact c in oldContacts) { var savedContact = contacts.Search(c.city, c.fname, c.lname, c.organization).FirstOrDefault(); if(savedContact != null) contactMap.Add(c.id, savedContact.Id); else contactMap.Add(c.id, 2); } var oldCompsSent = dbContext.contactfinals.ToList(); List<Shipment> ships = new List<Shipment>(); foreach (var ship in oldCompsSent) { int outValue; int quant = int.TryParse(ship.number, out outValue) ? outValue : 0; string status = "Pending"; if (ship.contactfinal1.Trim().ToLower() == "shipped") status = "Sent"; int contactId = 2; int titleId = 268; if (contactMap.ContainsKey(ship.contact_id)) contactId = contactMap[ship.contact_id]; if (titleMap.ContainsKey(ship.title_id)) titleId = titleMap[ship.title_id]; Shipment shipment = new Shipment { ContactId = contactId, TitleId = titleId, Status = status, Quantity = quant, DateSent = ship.modified_on, Type = "Comp" }; ships.Add(shipment); } shipments.Insert(ships, 1); }
public void CanMigrateCats() { WavePoetry.DataAccess.ContactData contacts = new WavePoetry.DataAccess.ContactData(); contacts.updateCats(); }