public void SaveOpenings(List<Opening> openings) { _openings = openings; if (_openings.Count == 0) return; RemoveOldOpenings(); AddNewOpenings(); }
public void RewriteAccountsWithLastYear(int clientId, int year) { var accounts = new List<AccountDao>(); var oldAccounts = dbContext.Accounts.Where(x => x.ClientId.Equals(clientId) && x.Year.Equals(year-1)); foreach (var a in oldAccounts) accounts.Add(new AccountDao {ClientId = a.ClientId, Year = a.Year+1, Name = a.Name, Description = a.Description}); foreach (var a in accounts) dbContext.Accounts.AddOrUpdate(a); dbContext.SaveChanges(); }
private void SetAutoNumber(Document document) { if (document.AutoNumber > 0) return; _allDocs = _dbContext.Documents.Where(c => c.Year.Equals(document.Date.Year) && c.ClientId.Equals(document.ClientId)).ToList(); _autoNumber = 1; if (_allDocs.Any()) { _autoNumber = _allDocs.Max(c => c.AutoNumber); _autoNumber++; } document.AutoNumber = _autoNumber; }
public IEnumerable<Opening> GetOpeningsWithoutDoubles(int clientId, int year) { var openings = _dbContext.Openings.Where(c => c.ClientId.Equals(clientId) && c.Year.Equals(year)).ToList(); var openingsWithoutDoubles = new List<OpeningDao>(); foreach (var opening in openings) { var openingsLike = openings.Where(c => c.CleanName.StartsWith(opening.CleanName)); if (openingsLike.Count() == 1) openingsWithoutDoubles.Add(opening); } var result = Converter.ConvertList<OpeningDao, Opening>(openingsWithoutDoubles); return result; }
public void SaveItems(int clientId, BalanceItems items) { var flatenedItems = new List<BalanceReportItem>(); flatenedItems.AddRange(items.Actives); flatenedItems.AddRange(items.Passives); var result = _dbContext.BalanceReport.Where(c => c.ClientId.Equals(clientId)).ToList(); foreach (var row in result) { var newItem = flatenedItems.FirstOrDefault(c => c.Id.Equals(row.Id)); if (newItem != null) row.Formula = newItem.Formula; _dbContext.BalanceReport.AddOrUpdate(row); } _dbContext.SaveChanges(); }
public ThermometersReaderViewModel(IThermometerReadingRepository repository) { this.repository = repository; ThermometerReadings = new ObservableCollection<ThermometerReading>(repository.GetThermometerReadings()); var monthList = new List<EnumMonth>(12) { EnumMonth.Январь, EnumMonth.Февраль, EnumMonth.Март, EnumMonth.Апрель, EnumMonth.Май, EnumMonth.Июнь, EnumMonth.Июль, EnumMonth.Август, EnumMonth.Сентябрь, EnumMonth.Октябрь, EnumMonth.Ноябрь, EnumMonth.Декабрь }; Months = new ObservableCollection<EnumMonth>(monthList); view = new ThermometerReadingView(){DataContext = this}; }
private void GetRowsWithValues() { _result = new List<BalanceReportValues>(); _documents = _dbContext.Documents.Where(c => c.ClientId.Equals(_clientId) && c.Year.Equals(_year)).ToList(); AddOpeningsToDocuments(_documents, _year); _documentsOld = _dbContext.Documents.Where(c => c.ClientId.Equals(_clientId) && c.Year.Equals(_year - 1)).ToList(); AddOpeningsToDocuments(_documentsOld, _year - 1); _formulas = GetAllItems(_clientId); foreach (var formula in _formulas) { double sum = 0; double sumOld = 0; if (formula.Formula != null) { var accounts = UndressFormula(formula.Formula); foreach (var decAcc in accounts) { if (decAcc.Side == null) continue; sum += _documents.Where(c => decAcc.Side.Invoke(c).StartsWith(decAcc.Name)).Sum(c => c.Price) * decAcc.Multiplier; sumOld += _documentsOld.Where(c => decAcc.Side.Invoke(c).StartsWith(decAcc.Name)).Sum(c => c.Price) * decAcc.Multiplier; } } _result.Add(new BalanceReportValues { RowId = formula.RowId, IsBold = formula.IsBold, Number = formula.Number, Type = formula.Type, Description = formula.Description, Balance1 = sumOld, Balance2 = sum }); } }
/// <summary> /// List all files inside a folder /// </summary> /// <param name="path">a path that files need to be parsed</param> /// <returns>a list of files need to be parsed</returns> private static List<string> listAllFiles(string path) { List<string> files = new List<string>(); if (Directory.Exists(path)) { System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(path); var filesInFolder = dir.GetFiles(); foreach (System.IO.FileInfo f in filesInFolder) { files.Add(f.Name); } } return files; }
private static int findLargestFile(List<string> files, string path) { long max = 0; int index = 0; int cnt = 0; string temp; foreach (string file in files ) { temp = string.Format("{0}{1}", path, file); FileInfo f = new FileInfo(temp); if (f.Length > max) { max = f.Length; index = cnt; } cnt++; } return index; }
private IList<DecodedAccount> UndressFormula(string formula) { var result = new List<DecodedAccount>(); formula = formula.Replace(" ", ""); var items = formula.ToUpper().Split(','); foreach (var item in items) { var accFormula = item; Func<DocumentDao, string> side = null; var acc = accFormula; var multiplier = 1; if (accFormula.Contains("WN") || accFormula.Contains("MA")) { if (accFormula.StartsWith("-")) { accFormula = accFormula.Substring(1, accFormula.Length - 1); multiplier = -1; } acc = accFormula.Substring(0, accFormula.Length - 2); var s = accFormula.Substring(accFormula.Length - 2, 2); if (s.Equals("WN")) side = x => x.AccountDt; else side = x => x.AccountCt; } result.Add(new DecodedAccount { Name = acc, Side = side, Multiplier = multiplier }); } return result; }
private void GetAccountOpeningsDictionaryForAccount(AccountDao account) { _openings = _dbContext.Openings.Where(c => c.ClientId.Equals(_clientId) && c.Year.Equals(_year) && c.Name.Equals(account.Name)).ToList(); }
private void GetAccounts() { _accounts = _dbContext.Accounts.Where(c => c.ClientId.Equals(_clientId) && c.Year.Equals(_year)).OrderBy(c => c.Name).ToList(); }
private void SortRows() { _result = _result.OrderBy(c=>c.RowId).ToList(); }
private void GetOpenings() { var openingsDao = _dbContext.Openings.Where(x => x.ClientId.Equals(_clientId) && x.Year.Equals(_year)).ToList(); _openings = Converter.ConvertList<OpeningDao, Opening>(openingsDao); }
private void GetAccounts() { var accountsDao = _dbContext.Accounts.Where(c => c.ClientId.Equals(_clientId) && c.Year.Equals(_year)).ToList(); _accounts = Converter.ConvertList<AccountDao, Account>(accountsDao); }
private void PrepareReport() { _result = new List<Report>(); }
static void Main(string[] args) { Console.WriteLine("1 - Change name of microsites."); Console.WriteLine("2 - Change name of profiles."); Console.WriteLine("3 - Check emails in users"); Console.WriteLine("4 - Fix duplicates"); Console.WriteLine("5 - Fix Not exitst one with Regular"); Console.WriteLine("6 - Add fanid for each microsite"); Console.WriteLine("7 - Add dealers ranking"); Console.WriteLine("8 - Remove duplicate players"); Console.WriteLine("9 - Switch back to previous description"); Console.WriteLine("9 - Switch back to previous description"); Console.WriteLine("10 - Change the name of the microsites in taa_microsite"); Console.WriteLine("11 - Copy images to fanid"); Console.WriteLine("12 - Download microsites has been created using xml files to have logos"); Console.WriteLine("13 - Change http://dev. to http://thefanorama.com"); Console.WriteLine("14 - Insert new sizes."); string[] filesMicrosite = { "microsite.wEx-099024.0.xml", "microsite.wEx-099092.0.xml", "microsite.wEx-099120.0.xml", "microsite.wEx-099125.0.xml", "microsite.wEx-099126.0.xml", "microsite.wEx-099127.0.xml", "microsite.wEx-099128.0.xml", "microsite.wEx-099153.0.xml", "microsite.wEx-099180.0.xml", "microsite.wEx-099182.0.xml", "microsite.wEx-099183.0.xml", "microsite.wEx-099184.0.xml", "microsite.wEx-099185.0.xml", "microsite.wEx-099194.0.xml", "microsite.wEx-099210.0.xml", "microsite.wEx-099211.0.xml", "microsite.wEx-099212.0.xml", "microsite.wEx-099213.0.xml", "microsite.wEx-099214.0.xml", "microsite.wEx-099215.0.xml", "microsite.wEx-099226.0.xml", "microsite.wEx-099228.0.xml", "microsite.wEx-099235.0.xml", "microsite.wEx-099236.0.xml", "microsite.wEx-099240.0.xml", "microsite.wEx-099241.0.xml", "microsite.wEx-099265.0.xml", "microsite.wEx-099270.0.xml", "microsite.wEx-099274.0.xml", "microsite.wEx-099275.0.xml", "microsite.wEx-099276.0.xml", "microsite.wEx-099277.0.xml", "microsite.wEx-099278.0.xml", "microsite.wEx-099295.0.xml", "microsite.wEx-099307.0.xml", "microsite.wEx-099308.0.xml", "microsite.wEx-099317.0.xml", "microsite.wEx-099330.0.xml", "microsite.wEx-099338.0.xml", "microsite.wEx-099339.0.xml", "microsite.wEx-099343.0.xml", "microsite.wEx-099350.0.xml", "microsite.wEx-099353.0.xml", "microsite.wEx-099356.0.xml", "microsite.wEx-099357.0.xml", "microsite.wEx-099358.0.xml", "microsite.wEx-099359.0.xml", "microsite.wEx-099365.0.xml", "microsite.wEx-099372.0.xml", "microsite.wEx-099388.0.xml", "microsite.wEx-099489.0.xml", "microsite.wEx-099491.0.xml", "microsite.wEx-099500.0.xml", "microsite.wEx-099509.0.xml", "microsite.wEx-099518.0.xml", "microsite.wEx-099578.0.xml", "microsite.wEx-099582.0.xml", "microsite.wEx-099585.0.xml", "microsite.wEx-099595.0.xml", "microsite.wEx-099609.0.xml", "microsite.wEx-099610.0.xml", "microsite.wEx-099616.0.xml", "microsite.wEx-099619.0.xml", "microsite.wEx-099632.0.xml", "microsite.wEx-099637.0.xml", "microsite.wEx-099662.0.xml", "microsite.wEx-099684.0.xml", "microsite.wEx-099686.0.xml", "microsite.wEx-099755.0.xml", "microsite.wEx-099757.0.xml", "microsite.wEx-099770.0.xml", "microsite.wEx-099772.0.xml", "microsite.wEx-099799.0.xml", "microsite.wEx-099801.0.xml", "microsite.wEx-099823.0.xml", "microsite.wEx-099833.0.xml", "microsite.wEx-099870.0.xml", "microsite.wEx-099871.0.xml", "microsite.wEx-099872.0.xml", "microsite.wEx-099873.0.xml", "microsite.wEx-099876.0.xml", "microsite.wEx-099877.0.xml", "microsite.wEx-099880.0.xml", "microsite.wEx-099891.0.xml", "microsite.wEx-099923.0.xml", "microsite.wEx-099990.0.xml", "microsite.wEx-100003.0.xml", "microsite.wEx-100004.0.xml", "microsite.wEx-100036.0.xml", "microsite.wEx-100044.0.xml", "microsite.wEx-100045.0.xml", "microsite.wEx-100046.0.xml", "microsite.wEx-100049.0.xml", "microsite.wEx-100054.0.xml", "microsite.wEx-100060.0.xml", "microsite.wEx-100085.0.xml", "microsite.wEx-100086.0.xml", "microsite.wEx-100095.0.xml", "microsite.wEx-100102.0.xml", "microsite.wEx-100114.0.xml", "microsite.wEx-100137.0.xml", "microsite.wEx-100138.0.xml", "microsite.wEx-100165.0.xml", "microsite.wEx-100167.0.xml", "microsite.wEx-100201.0.xml", "microsite.wEx-100214.0.xml", "microsite.wEx-100232.0.xml", "microsite.wEx-100246.0.xml", "microsite.wEx-100247.0.xml", "microsite.wEx-100248.0.xml", "microsite.wEx-100251.0.xml", "microsite.wEx-100267.0.xml", "microsite.wEx-100271.0.xml", "microsite.wEx-100294.0.xml", "microsite.wEx-100295.0.xml", "microsite.wEx-100310.0.xml", "microsite.wEx-100332.0.xml", "microsite.wEx-100335.0.xml", "microsite.wEx-100339.0.xml", "microsite.wEx-100350.0.xml", "microsite.wEx-100365.0.xml", "microsite.wEx-100367.0.xml", "microsite.wEx-100380.0.xml", "microsite.wEx-100413.0.xml", "microsite.wEx-100416.0.xml", "microsite.wEx-100469.0.xml", "microsite.wEx-100487.0.xml", "microsite.wEx-100507.0.xml", "microsite.wEx-100518.0.xml", "microsite.wEx-100519.0.xml", "microsite.wEx-100525.0.xml", "microsite.wEx-100526.0.xml", "microsite.wEx-100539.0.xml", "microsite.wEx-100540.0.xml", "microsite.wEx-100543.0.xml", "microsite.wEx-100545.0.xml", "microsite.wEx-100550.0.xml", "microsite.wEx-100714.0.xml", "microsite.wEx-100723.0.xml", "microsite.wEx-100728.0.xml", "microsite.wEx-100729.0.xml", "microsite.wEx-100730.0.xml", "microsite.wEx-100733.0.xml", "microsite.wEx-100889.0.xml", "microsite.wEx-100910.0.xml", "microsite.wEx-100911.0.xml", "microsite.wEx-100912.0.xml", "microsite.wEx-100913.0.xml", "microsite.wEx-100928.0.xml", "microsite.wEx-100936.0.xml", "microsite.wEx-100937.0.xml", "microsite.wEx-100939.0.xml", "microsite.wEx-100944.0.xml", "microsite.wEx-100945.0.xml", "microsite.wEx-100950.0.xml", "microsite.wEx-100963.0.xml", "microsite.wEx-100988.0.xml", "microsite.wEx-100991.0.xml", "microsite.wEx-100992.0.xml", "microsite.wEx-101033.0.xml", "microsite.wEx-101034.0.xml", "microsite.wEx-101035.0.xml", "microsite.wEx-101036.0.xml", "microsite.wEx-101037.0.xml", "microsite.wEx-101039.0.xml", "microsite.wEx-101040.0.xml", "microsite.wEx-101042.0.xml", "microsite.wEx-101045.0.xml", "microsite.wEx-101072.0.xml", "microsite.wEx-101086.0.xml", "microsite.wEx-101087.0.xml", "microsite.wEx-101088.0.xml", "microsite.wEx-101090.0.xml", "microsite.wEx-101091.0.xml", "microsite.wEx-101093.0.xml", "microsite.wEx-101104.0.xml", "microsite.wEx-101153.0.xml", "microsite.wEx-101154.0.xml", "microsite.wEx-101155.0.xml", "microsite.wEx-101156.0.xml", "microsite.wEx-101160.0.xml", "microsite.wEx-101165.0.xml", "microsite.wEx-101172.0.xml", "microsite.wEx-101184.0.xml", "microsite.wEx-101193.0.xml", "microsite.wEx-101240.0.xml", "microsite.wEx-101263.0.xml", "microsite.wEx-101265.0.xml", "microsite.wEx-101276.0.xml", "microsite.wEx-101277.0.xml", "microsite.wEx-101279.0.xml", "microsite.wEx-101280.0.xml", "microsite.wEx-101281.0.xml", "microsite.wEx-101284.0.xml", "microsite.wEx-101285.0.xml", "microsite.wEx-101286.0.xml", "microsite.wEx-101331.0.xml", "microsite.wEx-101332.0.xml", "microsite.wEx-101333.0.xml", "microsite.wEx-101334.0.xml", "microsite.wEx-101335.0.xml", "microsite.wEx-101336.0.xml", "microsite.wEx-101337.0.xml", "microsite.wEx-101338.0.xml", "microsite.wEx-101339.0.xml", "microsite.wEx-101340.0.xml", "microsite.wEx-101341.0.xml", "microsite.wEx-101344.0.xml", "microsite.wEx-101345.0.xml", "microsite.wEx-101346.0.xml", "microsite.wEx-101347.0.xml", "microsite.wEx-101349.0.xml", "microsite.wEx-101351.0.xml", "microsite.wEx-101371.0.xml", "microsite.wEx-101379.0.xml", "microsite.wEx-101382.0.xml", "microsite.wEx-101384.0.xml", "microsite.wEx-101415.0.xml", "microsite.wEx-101462.0.xml", "microsite.wEx-101463.0.xml", "microsite.wEx-101464.0.xml", "microsite.wEx-101465.0.xml", "microsite.wEx-101470.0.xml", "microsite.wEx-101476.0.xml", "microsite.wEx-101483.0.xml", "microsite.wEx-101487.0.xml", "microsite.wEx-101488.0.xml", "microsite.wEx-101490.0.xml", "microsite.wEx-101491.0.xml", "microsite.wEx-101492.0.xml", "microsite.wEx-101493.0.xml", "microsite.wEx-101495.0.xml", "microsite.wEx-101537.0.xml", "microsite.wEx-101541.0.xml", "microsite.wEx-101543.0.xml", "microsite.wEx-101544.0.xml", "microsite.wEx-101546.0.xml", "microsite.wEx-101550.0.xml", "microsite.wEx-101551.0.xml", "microsite.wEx-101552.0.xml", "microsite.wEx-101553.0.xml", "microsite.wEx-101554.0.xml", "microsite.wEx-101670.0.xml", "microsite.wEx-101671.0.xml", "microsite.wEx-101672.0.xml", "microsite.wEx-101689.0.xml", "microsite.wEx-101740.0.xml", "microsite.wEx-101745.0.xml", "microsite.wEx-101755.0.xml", "microsite.wEx-101759.0.xml", "microsite.wEx-101762.0.xml", "microsite.wEx-101763.0.xml", "microsite.wEx-101815.0.xml", "microsite.wEx-101852.0.xml", "microsite.wEx-101859.0.xml", "microsite.wEx-101896.0.xml", "microsite.wEx-101917.0.xml", "microsite.wEx-101998.0.xml", "microsite.wEx-102012.0.xml", "microsite.wEx-102075.0.xml", "microsite.wEx-102083.0.xml", "microsite.wEx-102089.0.xml", "microsite.wEx-102106.0.xml", "microsite.wEx-102222.0.xml", "microsite.wEx-102285.0.xml", "microsite.wEx-102286.0.xml", "microsite.wEx-102294.0.xml", "microsite.wEx-102296.0.xml", "microsite.wEx-102310.0.xml", "microsite.wEx-102340.0.xml", "microsite.wEx-102344.0.xml", "microsite.wEx-102439.0.xml", "microsite.wEx-102446.0.xml", "microsite.wEx-102447.0.xml", "microsite.wEx-102448.0.xml", "microsite.wEx-102450.0.xml", "microsite.wEx-102494.0.xml", "microsite.wEx-102495.0.xml", "microsite.wEx-102496.0.xml", "microsite.wEx-102498.0.xml", "microsite.wEx-102551.0.xml", "microsite.wEx-102658.0.xml", "microsite.wEx-102659.0.xml", "microsite.wEx-102660.0.xml", "microsite.wEx-102669.0.xml", "microsite.wEx-102714.0.xml", "microsite.wEx-102764.0.xml", "microsite.wEx-102803.0.xml", "microsite.wEx-102807.0.xml", "microsite.wEx-102816.0.xml", "microsite.wEx-102853.0.xml", "microsite.wEx-102987.0.xml", "microsite.wEx-102998.0.xml", "microsite.wEx-103043.0.xml", "microsite.wEx-103044.0.xml", "microsite.wEx-103060.0.xml", "microsite.wEx-103170.0.xml", "microsite.wEx-103185.0.xml", "microsite.wEx-103323.0.xml", "microsite.wEx-103389.0.xml", "microsite.wEx-103450.0.xml", "microsite.wEx-103619.0.xml", "microsite.wEx-103620.0.xml", "microsite.wEx-103693.0.xml", "microsite.wEx-103755.0.xml", "microsite.wEx-103757.0.xml", "microsite.wEx-103758.0.xml", "microsite.wEx-103778.0.xml", "microsite.wEx-104085.0.xml", "microsite.wEx-104095.0.xml", "microsite.wEx-104096.0.xml", "microsite.wEx-104097.0.xml", "microsite.wEx-104101.0.xml", "microsite.wEx-104146.0.xml", "microsite.wEx-104157.0.xml", "microsite.wEx-104266.0.xml", "microsite.wEx-104286.0.xml", "microsite.wEx-104307.0.xml", "microsite.wEx-104347.0.xml", "microsite.wEx-104358.0.xml", "microsite.wEx-104359.0.xml", "microsite.wEx-104489.0.xml", "microsite.wEx-104529.0.xml", "microsite.wEx-104592.0.xml", "microsite.wEx-104594.0.xml", "microsite.wEx-104645.0.xml", "microsite.wEx-104763.0.xml", "microsite.wEx-104809.0.xml", "microsite.wEx-104813.0.xml", "microsite.wEx-104814.0.xml", "microsite.wEx-104815.0.xml", "microsite.wEx-104816.0.xml", "microsite.wEx-104821.0.xml", "microsite.wEx-104823.0.xml", "microsite.wEx-104831.0.xml", "microsite.wEx-104834.0.xml", "microsite.wEx-104838.0.xml", "microsite.wEx-104845.0.xml", "microsite.wEx-104846.0.xml", "microsite.wEx-104851.0.xml", "microsite.wEx-104852.0.xml", "microsite.wEx-104853.0.xml", "microsite.wEx-104856.0.xml", "microsite.wEx-104858.0.xml", "microsite.wEx-104866.0.xml", "microsite.wEx-104873.0.xml", "microsite.wEx-104878.0.xml", "microsite.wEx-104889.0.xml", "microsite.wEx-104890.0.xml", "microsite.wEx-104892.0.xml", "microsite.wEx-104994.0.xml", "microsite.wEx-104998.0.xml", "microsite.wEx-105008.0.xml", "microsite.wEx-105011.0.xml", "microsite.wEx-105012.0.xml", "microsite.wEx-105013.0.xml", "microsite.wEx-105024.0.xml", "microsite.wEx-105029.0.xml", "microsite.wEx-105032.0.xml", "microsite.wEx-105156.0.xml", "microsite.wEx-105208.0.xml", "microsite.wEx-105219.0.xml", "microsite.wEx-105221.0.xml", "microsite.wEx-105262.0.xml", "microsite.wEx-105299.0.xml", "microsite.wEx-105300.0.xml", "microsite.wEx-105301.0.xml", "microsite.wEx-105331.0.xml", "microsite.wEx-105334.0.xml", "microsite.wEx-105335.0.xml", "microsite.wEx-105336.0.xml", "microsite.wEx-105337.0.xml", "microsite.wEx-105338.0.xml", "microsite.wEx-105339.0.xml", "microsite.wEx-105366.0.xml", "microsite.wEx-105371.0.xml", "microsite.wEx-105374.0.xml", "microsite.wEx-105378.0.xml", "microsite.wEx-105484.0.xml", "microsite.wEx-105489.0.xml", "microsite.wEx-105492.0.xml", "microsite.wEx-105504.0.xml", "microsite.wEx-105509.0.xml", "microsite.wEx-105510.0.xml", "microsite.wEx-105511.0.xml", "microsite.wEx-105520.0.xml", "microsite.wEx-105540.0.xml", "microsite.wEx-105541.0.xml", "microsite.wEx-105542.0.xml", "microsite.wEx-105543.0.xml", "microsite.wEx-105544.0.xml", "microsite.wEx-105547.0.xml", "microsite.wEx-105556.0.xml", "microsite.wEx-105558.0.xml", "microsite.wEx-105596.0.xml", "microsite.wEx-105597.0.xml", "microsite.wEx-105598.0.xml", "microsite.wEx-105615.0.xml", "microsite.wEx-105616.0.xml", "microsite.wEx-105620.0.xml", "microsite.wEx-105625.0.xml", "microsite.wEx-105629.0.xml", "microsite.wEx-105680.0.xml", "microsite.wEx-105736.0.xml", "microsite.wEx-105770.0.xml", "microsite.wEx-105776.0.xml", "microsite.wEx-105778.0.xml", "microsite.wEx-105828.0.xml", "microsite.wEx-105831.0.xml", "microsite.wEx-105832.0.xml", "microsite.wEx-105836.0.xml", "microsite.wEx-105838.0.xml", "microsite.wEx-105839.0.xml", "microsite.wEx-105840.0.xml", "microsite.wEx-105846.0.xml", "microsite.wEx-105847.0.xml", "microsite.wEx-105850.0.xml", "microsite.wEx-105852.0.xml", "microsite.wEx-105863.0.xml", "microsite.wEx-105880.0.xml", "microsite.wEx-105885.0.xml", "microsite.wEx-105887.0.xml", "microsite.wEx-105889.0.xml", "microsite.wEx-105910.0.xml", "microsite.wEx-105953.0.xml", "microsite.wEx-105997.0.xml", "microsite.wEx-105998.0.xml", "microsite.wEx-106003.0.xml", "microsite.wEx-106017.0.xml", "microsite.wEx-106023.0.xml", "microsite.wEx-106030.0.xml", "microsite.wEx-106048.0.xml", "microsite.wEx-106050.0.xml", "microsite.wEx-106051.0.xml", "microsite.wEx-106052.0.xml", "microsite.wEx-106053.0.xml", "microsite.wEx-106054.0.xml", "microsite.wEx-106055.0.xml", "microsite.wEx-106056.0.xml", "microsite.wEx-106058.0.xml", "microsite.wEx-106061.0.xml", "microsite.wEx-106062.0.xml", "microsite.wEx-106130.0.xml", "microsite.wEx-106138.0.xml", "microsite.wEx-106139.0.xml", "microsite.wEx-106140.0.xml", "microsite.wEx-106144.0.xml", "microsite.wEx-106147.0.xml", "microsite.wEx-106151.0.xml", "microsite.wEx-106154.0.xml", "microsite.wEx-106216.0.xml", "microsite.wEx-106224.0.xml", "microsite.wEx-106249.0.xml", "microsite.wEx-106275.0.xml", "microsite.wEx-106279.0.xml", "microsite.wEx-106280.0.xml", "microsite.wEx-106307.0.xml", "microsite.wEx-106313.0.xml", "microsite.wEx-106321.0.xml", "microsite.wEx-106322.0.xml", "microsite.wEx-106342.0.xml", "microsite.wEx-106344.0.xml", "microsite.wEx-106345.0.xml", "microsite.wEx-106348.0.xml", "microsite.wEx-106351.0.xml", "microsite.wEx-106358.0.xml", "microsite.wEx-106359.0.xml", "microsite.wEx-106360.0.xml", "microsite.wEx-106418.0.xml", "microsite.wEx-106454.0.xml", "microsite.wEx-106460.0.xml", "microsite.wEx-106528.0.xml", "microsite.wEx-106548.0.xml", "microsite.wEx-106565.0.xml", "microsite.wEx-106584.0.xml", "microsite.wEx-106586.0.xml", "microsite.wEx-106588.0.xml", "microsite.wEx-106642.0.xml", "microsite.wEx-106644.0.xml", "microsite.wEx-106661.0.xml", "microsite.wEx-106676.0.xml", "microsite.wEx-106682.0.xml", "microsite.wEx-106685.0.xml", "microsite.wEx-106690.0.xml", "microsite.wEx-106691.0.xml", "microsite.wEx-106692.0.xml", "microsite.wEx-106703.0.xml", "microsite.wEx-106704.0.xml", "microsite.wEx-106712.0.xml", "microsite.wEx-106718.0.xml", "microsite.wEx-106721.0.xml", "microsite.wEx-106765.0.xml", "microsite.wEx-106789.0.xml", "microsite.wEx-106795.0.xml", "microsite.wEx-106798.0.xml", "microsite.wEx-106817.0.xml", "microsite.wEx-106820.0.xml", "microsite.wEx-106825.0.xml", "microsite.wEx-106830.0.xml", "microsite.wEx-106864.0.xml", "microsite.wEx-106882.0.xml", "microsite.wEx-106892.0.xml", "microsite.wEx-106906.0.xml", "microsite.wEx-106948.0.xml", "microsite.wEx-106967.0.xml", "microsite.wEx-106985.0.xml", "microsite.wEx-106991.0.xml", "microsite.wEx-107029.0.xml", "microsite.wEx-107030.0.xml", "microsite.wEx-107063.0.xml", "microsite.wEx-107064.0.xml", "microsite.wEx-107073.0.xml", "microsite.wEx-107081.0.xml", "microsite.wEx-107126.0.xml", "microsite.wEx-107201.0.xml", "microsite.wEx-107215.0.xml", "microsite.wEx-107226.0.xml", "microsite.wEx-107258.0.xml", "microsite.wEx-107259.0.xml", "microsite.wEx-107260.0.xml", "microsite.wEx-107296.0.xml", "microsite.wEx-107328.0.xml", "microsite.wEx-107358.0.xml", "microsite.wEx-107359.0.xml", "microsite.wEx-107361.0.xml", "microsite.wEx-107376.0.xml", "microsite.wEx-107413.0.xml", "microsite.wEx-107414.0.xml", "microsite.wEx-107415.0.xml", "microsite.wEx-107450.0.xml", "microsite.wEx-107453.0.xml", "microsite.wEx-107485.0.xml", "microsite.wEx-107511.0.xml", "microsite.wEx-107512.0.xml", "microsite.wEx-107524.0.xml", "microsite.wEx-107541.0.xml", "microsite.wEx-107542.0.xml", "microsite.wEx-107544.0.xml", "microsite.wEx-107545.0.xml", "microsite.wEx-107557.0.xml", "microsite.wEx-107564.0.xml", "microsite.wEx-107566.0.xml", "microsite.wEx-107571.0.xml", "microsite.wEx-107590.0.xml", "microsite.wEx-107646.0.xml", "microsite.wEx-107654.0.xml", "microsite.wEx-107657.0.xml", "microsite.wEx-107679.0.xml", "microsite.wEx-107747.0.xml", "microsite.wEx-107803.0.xml", "microsite.wEx-107804.0.xml", "microsite.wEx-107805.0.xml", "microsite.wEx-107862.0.xml", "microsite.wEx-107868.0.xml", "microsite.wEx-107910.0.xml", "microsite.wEx-107913.0.xml", "microsite.wEx-107953.0.xml", "microsite.wEx-107965.0.xml", "microsite.wEx-107966.0.xml", "microsite.wEx-107968.0.xml", "microsite.wEx-107972.0.xml", "microsite.wEx-107981.0.xml", "microsite.wEx-107994.0.xml", "microsite.wEx-108000.0.xml", "microsite.wEx-108014.0.xml", "microsite.wEx-108018.0.xml", "microsite.wEx-108079.0.xml", "microsite.wEx-108096.0.xml", "microsite.wEx-108098.0.xml", "microsite.wEx-108102.0.xml", "microsite.wEx-108130.0.xml", "microsite.wEx-108186.0.xml", "microsite.wEx-108187.0.xml", "microsite.wEx-108188.0.xml", "microsite.wEx-108191.0.xml", "microsite.wEx-108192.0.xml", "microsite.wEx-108195.0.xml", "microsite.wEx-108245.0.xml", "microsite.wEx-108251.0.xml", "microsite.wEx-108252.0.xml", "microsite.wEx-108255.0.xml", "microsite.wEx-108258.0.xml", "microsite.wEx-108261.0.xml", "microsite.wEx-108364.0.xml", "microsite.wEx-108367.0.xml", "microsite.wEx-108368.0.xml", "microsite.wEx-108420.0.xml", "microsite.wEx-108426.0.xml", "microsite.wEx-108427.0.xml", "microsite.wEx-108428.0.xml", "microsite.wEx-108445.0.xml", "microsite.wEx-108454.0.xml", "microsite.wEx-108455.0.xml", "microsite.wEx-108456.0.xml", "microsite.wEx-108527.0.xml", "microsite.wEx-108570.0.xml", "microsite.wEx-108574.0.xml", "microsite.wEx-108575.0.xml", "microsite.wEx-108576.0.xml", "microsite.wEx-108580.0.xml", "microsite.wEx-108586.0.xml", "microsite.wEx-108651.0.xml", "microsite.wEx-108654.0.xml", "microsite.wEx-108656.0.xml", "microsite.wEx-108684.0.xml", "microsite.wEx-108719.0.xml", "microsite.wEx-108721.0.xml", "microsite.wEx-108738.0.xml", "microsite.wEx-108742.0.xml", "microsite.wEx-108744.0.xml", "microsite.wEx-108847.0.xml", "microsite.wEx-108894.0.xml", "microsite.wEx-108919.0.xml", "microsite.wEx-108945.0.xml", "microsite.wEx-108983.0.xml", "microsite.wEx-108984.0.xml", "microsite.wEx-108988.0.xml", "microsite.wEx-108994.0.xml", "microsite.wEx-109011.0.xml", "microsite.wEx-109012.0.xml", "microsite.wEx-109053.0.xml", "microsite.wEx-109056.0.xml", "microsite.wEx-109085.0.xml", "microsite.wEx-109086.0.xml", "microsite.wEx-109090.0.xml", "microsite.wEx-109094.0.xml", "microsite.wEx-109095.0.xml", "microsite.wEx-109096.0.xml", "microsite.wEx-109128.0.xml", "microsite.wEx-109134.0.xml", "microsite.wEx-109156.0.xml", "microsite.wEx-109183.0.xml", "microsite.wEx-109190.0.xml", "microsite.wEx-109218.0.xml", "microsite.wEx-109233.0.xml", "microsite.wEx-109266.0.xml", "microsite.wEx-109268.0.xml", "microsite.wEx-109278.0.xml", "microsite.wEx-109294.0.xml", "microsite.wEx-109300.0.xml", "microsite.wEx-109529.0.xml", "microsite.wEx-109539.0.xml", "microsite.wEx-109605.0.xml", "microsite.wEx-109635.0.xml", "microsite.wEx-109644.0.xml", "microsite.wEx-109655.0.xml", "microsite.wEx-109696.0.xml", "microsite.wEx-109703.0.xml", "microsite.wEx-109724.0.xml", "microsite.wEx-109737.0.xml", "microsite.wEx-109787.0.xml", "microsite.wEx-109797.0.xml", "microsite.wEx-109800.0.xml", "microsite.wEx-109836.0.xml", "microsite.wEx-109909.0.xml", "microsite.wEx-109910.0.xml", "microsite.wEx-109915.0.xml", "microsite.wEx-109986.0.xml", "microsite.wEx-110043.0.xml", "microsite.wEx-110075.0.xml", "microsite.wEx-110172.0.xml", "microsite.wEx-110179.0.xml", "microsite.wEx-110192.0.xml", "microsite.wEx-110258.0.xml", "microsite.wEx-110260.0.xml", "microsite.wEx-110284.0.xml", "microsite.wEx-110287.0.xml", "microsite.wEx-110304.0.xml", "microsite.wEx-110356.0.xml", "microsite.wEx-110358.0.xml", "microsite.wEx-110359.0.xml", "microsite.wEx-110361.0.xml", "microsite.wEx-110362.0.xml", "microsite.wEx-110370.0.xml", "microsite.wEx-110371.0.xml", "microsite.wEx-110400.0.xml", "microsite.wEx-110402.0.xml", "microsite.wEx-110551.0.xml", "microsite.wEx-110590.0.xml", "microsite.wEx-110592.0.xml", "microsite.wEx-110649.0.xml", "microsite.wEx-110718.0.xml", "microsite.wEx-110738.0.xml", "microsite.wEx-110749.0.xml", "microsite.wEx-110768.0.xml", "microsite.wEx-110834.0.xml", "microsite.wEx-110835.0.xml", "microsite.wEx-110860.0.xml", "microsite.wEx-110865.0.xml", "microsite.wEx-110867.0.xml", "microsite.wEx-110879.0.xml", "microsite.wEx-110890.0.xml", "microsite.wEx-110902.0.xml", "microsite.wEx-110915.0.xml", "microsite.wEx-110916.0.xml", "microsite.wEx-111022.0.xml", "microsite.wEx-111040.0.xml", "microsite.wEx-111046.0.xml", "microsite.wEx-111047.0.xml", "microsite.wEx-111048.0.xml", "microsite.wEx-111056.0.xml", "microsite.wEx-111073.0.xml", "microsite.wEx-111130.0.xml", "microsite.wEx-111153.0.xml", "microsite.wEx-111154.0.xml", "microsite.wEx-111167.0.xml", "microsite.wEx-111177.0.xml", "microsite.wEx-111179.0.xml", "microsite.wEx-111180.0.xml", "microsite.wEx-111186.0.xml", "microsite.wEx-111188.0.xml", "microsite.wEx-111194.0.xml", "microsite.wEx-111195.0.xml", "microsite.wEx-111204.0.xml", "microsite.wEx-111211.0.xml", "microsite.wEx-111258.0.xml", "microsite.wEx-111272.0.xml", "microsite.wEx-111273.0.xml", "microsite.wEx-111274.0.xml", "microsite.wEx-111368.0.xml", "microsite.wEx-111372.0.xml", "microsite.wEx-111377.0.xml", "microsite.wEx-111383.0.xml", "microsite.wEx-111448.0.xml", "microsite.wEx-111460.0.xml", "microsite.wEx-111463.0.xml", "microsite.wEx-111466.0.xml", "microsite.wEx-111469.0.xml", "microsite.wEx-111471.0.xml", "microsite.wEx-111480.0.xml", "microsite.wEx-111535.0.xml", "microsite.wEx-111538.0.xml", "microsite.wEx-111567.0.xml", "microsite.wEx-111612.0.xml", "microsite.wEx-111614.0.xml", "microsite.wEx-111696.0.xml", "microsite.wEx-111706.0.xml", "microsite.wEx-111713.0.xml", "microsite.wEx-111727.0.xml", "microsite.wEx-111732.0.xml", "microsite.wEx-111734.0.xml", "microsite.wEx-111736.0.xml", "microsite.wEx-111821.0.xml", "microsite.wEx-111823.0.xml", "microsite.wEx-111891.0.xml", "microsite.wEx-111900.0.xml", "microsite.wEx-111922.0.xml", "microsite.wEx-111938.0.xml", "microsite.wEx-112094.0.xml", "microsite.wEx-112098.0.xml", "microsite.wEx-112108.0.xml", "microsite.wEx-112109.0.xml", "microsite.wEx-112110.0.xml", "microsite.wEx-112149.0.xml", "microsite.wEx-112150.0.xml", "microsite.wEx-112173.0.xml", "microsite.wEx-112197.0.xml", "microsite.wEx-112301.0.xml", "microsite.wEx-112303.0.xml", "microsite.wEx-112304.0.xml", "microsite.wEx-112306.0.xml", "microsite.wEx-112313.0.xml", "microsite.wEx-112333.0.xml", "microsite.wEx-112343.0.xml", "microsite.wEx-112394.0.xml", "microsite.wEx-112395.0.xml", "microsite.wEx-112398.0.xml", "microsite.wEx-112414.0.xml", "microsite.wEx-112418.0.xml", "microsite.wEx-112426.0.xml", "microsite.wEx-112496.0.xml", "microsite.wEx-112498.0.xml", "microsite.wEx-112500.0.xml", "microsite.wEx-112671.0.xml", "microsite.wEx-112674.0.xml", "microsite.wEx-112691.0.xml", "microsite.wEx-112757.0.xml", "microsite.wEx-112785.0.xml", "microsite.wEx-112786.0.xml", "microsite.wEx-112795.0.xml", "microsite.wEx-112796.0.xml", "microsite.wEx-112875.0.xml", "microsite.wEx-112921.0.xml", "microsite.wEx-112960.0.xml", "microsite.wEx-113001.0.xml", "microsite.wEx-113002.0.xml", "microsite.wEx-113003.0.xml", "microsite.wEx-113021.0.xml", "microsite.wEx-113022.0.xml", "microsite.wEx-113029.0.xml", "microsite.wEx-113032.0.xml", "microsite.wEx-113036.0.xml", "microsite.wEx-113038.0.xml", "microsite.wEx-113063.0.xml", "microsite.wEx-113064.0.xml", "microsite.wEx-113131.0.xml", "microsite.wEx-113133.0.xml", "microsite.wEx-113164.0.xml", "microsite.wEx-113167.0.xml", "microsite.wEx-113226.0.xml", "microsite.wEx-113228.0.xml", "microsite.wEx-113232.0.xml", "microsite.wEx-113263.0.xml", "microsite.wEx-113274.0.xml", "microsite.wEx-113275.0.xml", "microsite.wEx-113360.0.xml", "microsite.wEx-113363.0.xml", "microsite.wEx-113367.0.xml", "microsite.wEx-113368.0.xml", "microsite.wEx-113380.0.xml", "microsite.wEx-113384.0.xml", "microsite.wEx-113440.0.xml", "microsite.wEx-113444.0.xml", "microsite.wEx-113498.0.xml", "microsite.wEx-113507.0.xml", "microsite.wEx-113508.0.xml", "microsite.wEx-113512.0.xml", "microsite.wEx-113521.0.xml", "microsite.wEx-113535.0.xml", "microsite.wEx-113616.0.xml", "microsite.wEx-113618.0.xml", "microsite.wEx-113620.0.xml", "microsite.wEx-113638.0.xml", "microsite.wEx-113639.0.xml", "microsite.wEx-113713.0.xml", "microsite.wEx-113724.0.xml", "microsite.wEx-113728.0.xml", "microsite.wEx-113736.0.xml", "microsite.wEx-113737.0.xml", "microsite.wEx-113748.0.xml", "microsite.wEx-113750.0.xml", "microsite.wEx-113893.0.xml", "microsite.wEx-113896.0.xml", "microsite.wEx-113907.0.xml", "microsite.wEx-113922.0.xml", "microsite.wEx-113924.0.xml", "microsite.wEx-113937.0.xml", "microsite.wEx-113965.0.xml", "microsite.wEx-114002.0.xml", "microsite.wEx-114003.0.xml", "microsite.wEx-114009.0.xml", "microsite.wEx-114075.0.xml", "microsite.wEx-114076.0.xml", "microsite.wEx-114079.0.xml", "microsite.wEx-114084.0.xml", "microsite.wEx-114172.0.xml", "microsite.wEx-114218.0.xml", "microsite.wEx-114226.0.xml", "microsite.wEx-114232.0.xml", "microsite.wEx-114234.0.xml", "microsite.wEx-114259.0.xml", "microsite.wEx-114274.0.xml", "microsite.wEx-114295.0.xml", "microsite.wEx-114297.0.xml", "microsite.wEx-114307.0.xml", "microsite.wEx-114309.0.xml", "microsite.wEx-114315.0.xml", "microsite.wEx-114320.0.xml", "microsite.wEx-114326.0.xml", "microsite.wEx-114333.0.xml", "microsite.wEx-114338.0.xml", "microsite.wEx-114351.0.xml", "microsite.wEx-114355.0.xml", "microsite.wEx-114363.0.xml", "microsite.wEx-114365.0.xml", "microsite.wEx-114366.0.xml", "microsite.wEx-114374.0.xml", "microsite.wEx-114378.0.xml", "microsite.wEx-114385.0.xml", "microsite.wEx-114386.0.xml", "microsite.wEx-114387.0.xml", "microsite.wEx-114388.0.xml", "microsite.wEx-114393.0.xml", "microsite.wEx-114395.0.xml", "microsite.wEx-114399.0.xml", "microsite.wEx-114403.0.xml", "microsite.wEx-114410.0.xml", "microsite.wEx-114411.0.xml", "microsite.wEx-114415.0.xml", "microsite.wEx-114418.0.xml", "microsite.wEx-114437.0.xml", "microsite.wEx-114438.0.xml", "microsite.wEx-114441.0.xml", "microsite.wEx-114443.0.xml", "microsite.wEx-114446.0.xml", "microsite.wEx-114453.0.xml", "microsite.wEx-114456.0.xml", "microsite.wEx-114458.0.xml", "microsite.wEx-114460.0.xml", "microsite.wEx-114465.0.xml", "microsite.wEx-114480.0.xml", "microsite.wEx-114481.0.xml", "microsite.wEx-114483.0.xml", "microsite.wEx-114485.0.xml", "microsite.wEx-114486.0.xml", "microsite.wEx-114489.0.xml", "microsite.wEx-114501.0.xml", "microsite.wEx-114502.0.xml", "microsite.wEx-114503.0.xml", "microsite.wEx-114506.0.xml", "microsite.wEx-114507.0.xml", "microsite.wEx-114513.0.xml", "microsite.wEx-114524.0.xml", "microsite.wEx-114526.0.xml", "microsite.wEx-114527.0.xml", "microsite.wEx-114533.0.xml", "microsite.wEx-114552.0.xml", "microsite.wEx-114554.0.xml", "microsite.wEx-114555.0.xml", "microsite.wEx-114557.0.xml", "microsite.wEx-114558.0.xml", "microsite.wEx-114566.0.xml", "microsite.wEx-114568.0.xml", "microsite.wEx-114575.0.xml", "microsite.wEx-114576.0.xml", "microsite.wEx-114591.0.xml", "microsite.wEx-114595.0.xml", "microsite.wEx-114613.0.xml", "microsite.wEx-114619.0.xml", "microsite.wEx-114627.0.xml", "microsite.wEx-114630.0.xml", "microsite.wEx-114639.0.xml", "microsite.wEx-114640.0.xml", "microsite.wEx-114644.0.xml", "microsite.wEx-114646.0.xml", "microsite.wEx-114704.0.xml", "microsite.wEx-114800.0.xml", "microsite.wEx-114813.0.xml", "microsite.wEx-114815.0.xml", "microsite.wEx-114816.0.xml", "microsite.wEx-114834.0.xml", "microsite.wEx-114845.0.xml", "microsite.wEx-114847.0.xml", "microsite.wEx-114873.0.xml", "microsite.wEx-114944.0.xml", "microsite.wEx-114958.0.xml", "microsite.wEx-114963.0.xml", "microsite.wEx-114965.0.xml", "microsite.wEx-114971.0.xml", "microsite.wEx-114984.0.xml", "microsite.wEx-114995.0.xml", "microsite.wEx-114998.0.xml", "microsite.wEx-114999.0.xml", "microsite.wEx-115010.0.xml", "microsite.wEx-115022.0.xml", "microsite.wEx-115032.0.xml", "microsite.wEx-115044.0.xml", "microsite.wEx-115045.0.xml", "microsite.wEx-115108.0.xml", "microsite.wEx-115131.0.xml", "microsite.wEx-115132.0.xml", "microsite.wEx-115135.0.xml", "microsite.wEx-115151.0.xml", "microsite.wEx-115152.0.xml", "microsite.wEx-115154.0.xml", "microsite.wEx-115190.0.xml", "microsite.wEx-115195.0.xml", "microsite.wEx-115215.0.xml", "microsite.wEx-115221.0.xml", "microsite.wEx-115222.0.xml", "microsite.wEx-115226.0.xml", "microsite.wEx-115232.0.xml", "microsite.wEx-115233.0.xml", "microsite.wEx-115234.0.xml", "microsite.wEx-115235.0.xml", "microsite.wEx-115236.0.xml", "microsite.wEx-115251.0.xml", "microsite.wEx-115266.0.xml", "microsite.wEx-115279.0.xml", "microsite.wEx-115283.0.xml", "microsite.wEx-115284.0.xml", "microsite.wEx-115290.0.xml", "microsite.wEx-115292.0.xml", "microsite.wEx-115298.0.xml", "microsite.wEx-115299.0.xml", "microsite.wEx-115300.0.xml", "microsite.wEx-115301.0.xml", "microsite.wEx-115307.0.xml", "microsite.wEx-115309.0.xml", "microsite.wEx-115323.0.xml", "microsite.wEx-115328.0.xml", "microsite.wEx-115334.0.xml", "microsite.wEx-115346.0.xml", "microsite.wEx-115347.0.xml", "microsite.wEx-115349.0.xml", "microsite.wEx-115350.0.xml", "microsite.wEx-115352.0.xml", "microsite.wEx-115354.0.xml", "microsite.wEx-115357.0.xml", "microsite.wEx-115358.0.xml", "microsite.wEx-115360.0.xml", "microsite.wEx-115378.0.xml", "microsite.wEx-115379.0.xml", "microsite.wEx-115383.0.xml", "microsite.wEx-115393.0.xml", "microsite.wEx-115410.0.xml", "microsite.wEx-115414.0.xml", "microsite.wEx-115415.0.xml", "microsite.wEx-115417.0.xml", "microsite.wEx-115419.0.xml", "microsite.wEx-115420.0.xml", "microsite.wEx-115422.0.xml", "microsite.wEx-115423.0.xml", "microsite.wEx-115425.0.xml", "microsite.wEx-115431.0.xml", "microsite.wEx-115452.0.xml", "microsite.wEx-115489.0.xml", "microsite.wEx-115490.0.xml", "microsite.wEx-115491.0.xml", "microsite.wEx-115492.0.xml", "microsite.wEx-115493.0.xml", "microsite.wEx-115495.0.xml", "microsite.wEx-115497.0.xml", "microsite.wEx-115498.0.xml", "microsite.wEx-115513.0.xml", "microsite.wEx-115515.0.xml", "microsite.wEx-115519.0.xml", "microsite.wEx-115520.0.xml", "microsite.wEx-115528.0.xml", "microsite.wEx-115529.0.xml", "microsite.wEx-115535.0.xml", "microsite.wEx-115536.0.xml", "microsite.wEx-115538.0.xml", "microsite.wEx-115540.0.xml", "microsite.wEx-115547.0.xml", "microsite.wEx-115548.0.xml", "microsite.wEx-115549.0.xml", "microsite.wEx-115552.0.xml", "microsite.wEx-115555.0.xml", "microsite.wEx-115557.0.xml", "microsite.wEx-115562.0.xml", "microsite.wEx-115563.0.xml", "microsite.wEx-115566.0.xml", "microsite.wEx-115572.0.xml", "microsite.wEx-115573.0.xml", "microsite.wEx-115574.0.xml", "microsite.wEx-115590.0.xml", "microsite.wEx-115592.0.xml", "microsite.wEx-115593.0.xml", "microsite.wEx-115599.0.xml", "microsite.wEx-115601.0.xml", "microsite.wEx-115606.0.xml", "microsite.wEx-115609.0.xml", "microsite.wEx-115612.0.xml", "microsite.wEx-115616.0.xml", "microsite.wEx-115621.0.xml", "microsite.wEx-115625.0.xml", "microsite.wEx-115631.0.xml", "microsite.wEx-115632.0.xml", "microsite.wEx-115638.0.xml", "microsite.wEx-115639.0.xml", "microsite.wEx-115641.0.xml", "microsite.wEx-115642.0.xml", "microsite.wEx-115652.0.xml", "microsite.wEx-115654.0.xml", "microsite.wEx-115660.0.xml", "microsite.wEx-115661.0.xml", "microsite.wEx-115664.0.xml", "microsite.wEx-115666.0.xml", "microsite.wEx-115667.0.xml", "microsite.wEx-115672.0.xml", "microsite.wEx-115674.0.xml", "microsite.wEx-115675.0.xml", "microsite.wEx-115676.0.xml", "microsite.wEx-115677.0.xml", "microsite.wEx-115680.0.xml", "microsite.wEx-115681.0.xml", "microsite.wEx-115682.0.xml", "microsite.wEx-115687.0.xml", "microsite.wEx-115688.0.xml", "microsite.wEx-115707.0.xml", "microsite.wEx-115708.0.xml", "microsite.wEx-115726.0.xml", "microsite.wEx-115729.0.xml", "microsite.wEx-115730.0.xml", "microsite.wEx-115753.0.xml", "microsite.wEx-115778.0.xml", "microsite.wEx-115780.0.xml", "microsite.wEx-115781.0.xml", "microsite.wEx-115783.0.xml", "microsite.wEx-115784.0.xml", "microsite.wEx-115804.0.xml", "microsite.wEx-115805.0.xml", "microsite.wEx-115806.0.xml", "microsite.wEx-115813.0.xml", "microsite.wEx-115816.0.xml", "microsite.wEx-115817.0.xml", "microsite.wEx-115820.0.xml", "microsite.wEx-115849.0.xml", "microsite.wEx-115850.0.xml", "microsite.wEx-115852.0.xml", "microsite.wEx-115854.0.xml", "microsite.wEx-115856.0.xml", "microsite.wEx-115862.0.xml", "microsite.wEx-115864.0.xml", "microsite.wEx-115869.0.xml", "microsite.wEx-115872.0.xml", "microsite.wEx-115874.0.xml", "microsite.wEx-115880.0.xml", "microsite.wEx-115883.0.xml", "microsite.wEx-115887.0.xml", "microsite.wEx-115890.0.xml", "microsite.wEx-115894.0.xml", "microsite.wEx-115895.0.xml", "microsite.wEx-115899.0.xml", "microsite.wEx-115900.0.xml", "microsite.wEx-115902.0.xml", "microsite.wEx-115903.0.xml", "microsite.wEx-115904.0.xml", "microsite.wEx-115905.0.xml", "microsite.wEx-115907.0.xml", "microsite.wEx-115908.0.xml", "microsite.wEx-115915.0.xml", "microsite.wEx-115916.0.xml", "microsite.wEx-115918.0.xml", "microsite.wEx-115922.0.xml", "microsite.wEx-115923.0.xml", "microsite.wEx-115926.0.xml", "microsite.wEx-115935.0.xml", "microsite.wEx-115937.0.xml", "microsite.wEx-115940.0.xml", "microsite.wEx-115949.0.xml", "microsite.wEx-115962.0.xml", "microsite.wEx-115963.0.xml", "microsite.wEx-115966.0.xml", "microsite.wEx-115967.0.xml", "microsite.wEx-115969.0.xml", "microsite.wEx-115970.0.xml", "microsite.wEx-115971.0.xml", "microsite.wEx-115972.0.xml", "microsite.wEx-115980.0.xml", "microsite.wEx-115981.0.xml", "microsite.wEx-115984.0.xml", "microsite.wEx-115986.0.xml", "microsite.wEx-115987.0.xml", "microsite.wEx-115988.0.xml", "microsite.wEx-115989.0.xml", "microsite.wEx-116020.0.xml", "microsite.wEx-116027.0.xml", "microsite.wEx-116028.0.xml", "microsite.wEx-116029.0.xml", "microsite.wEx-116030.0.xml", "microsite.wEx-116041.0.xml", "microsite.wEx-116046.0.xml", "microsite.wEx-116060.0.xml", "microsite.wEx-116069.0.xml", "microsite.wEx-116070.0.xml", "microsite.wEx-116076.0.xml", "microsite.wEx-116089.0.xml", "microsite.wEx-116090.0.xml", "microsite.wEx-116111.0.xml", "microsite.wEx-116115.0.xml", "microsite.wEx-116118.0.xml", "microsite.wEx-116119.0.xml", "microsite.wEx-116125.0.xml", "microsite.wEx-116128.0.xml", "microsite.wEx-116129.0.xml", "microsite.wEx-116153.0.xml", "microsite.wEx-116161.0.xml", "microsite.wEx-116164.0.xml", "microsite.wEx-116166.0.xml", "microsite.wEx-116199.0.xml", "microsite.wEx-116202.0.xml", "microsite.wEx-116203.0.xml", "microsite.wEx-116208.0.xml", "microsite.wEx-116212.0.xml", "microsite.wEx-116213.0.xml", "microsite.wEx-116214.0.xml", "microsite.wEx-116215.0.xml", "microsite.wEx-116220.0.xml", "microsite.wEx-116222.0.xml", "microsite.wEx-116248.0.xml", "microsite.wEx-116249.0.xml", "microsite.wEx-116250.0.xml", "microsite.wEx-116254.0.xml", "microsite.wEx-116255.0.xml", "microsite.wEx-116256.0.xml", "microsite.wEx-116257.0.xml", "microsite.wEx-116258.0.xml", "microsite.wEx-116259.0.xml", "microsite.wEx-116261.0.xml", "microsite.wEx-116262.0.xml", "microsite.wEx-116263.0.xml", "microsite.wEx-116264.0.xml", "microsite.wEx-116265.0.xml", "microsite.wEx-116266.0.xml", "microsite.wEx-116267.0.xml", "microsite.wEx-116268.0.xml", "microsite.wEx-116269.0.xml", "microsite.wEx-116270.0.xml", "microsite.wEx-116271.0.xml", "microsite.wEx-116272.0.xml", "microsite.wEx-116274.0.xml", "microsite.wEx-116281.0.xml", "microsite.wEx-116282.0.xml", "microsite.wEx-116283.0.xml", "microsite.wEx-116284.0.xml", "microsite.wEx-116285.0.xml", "microsite.wEx-116286.0.xml", "microsite.wEx-116287.0.xml", "microsite.wEx-116297.0.xml", "microsite.wEx-116298.0.xml", "microsite.wEx-116300.0.xml", "microsite.wEx-116302.0.xml", "microsite.wEx-116308.0.xml", "microsite.wEx-116310.0.xml", "microsite.wEx-116315.0.xml", "microsite.wEx-116316.0.xml", "microsite.wEx-116325.0.xml", "microsite.wEx-116332.0.xml", "microsite.wEx-116334.0.xml", "microsite.wEx-116335.0.xml", "microsite.wEx-116336.0.xml", "microsite.wEx-116337.0.xml", "microsite.wEx-116338.0.xml", "microsite.wEx-116340.0.xml", "microsite.wEx-116342.0.xml", "microsite.wEx-116349.0.xml", "microsite.wEx-116359.0.xml", "microsite.wEx-116360.0.xml", "microsite.wEx-116369.0.xml", "microsite.wEx-116407.0.xml", "microsite.wEx-116412.0.xml", "microsite.wEx-116414.0.xml", "microsite.wEx-116420.0.xml", "microsite.wEx-116421.0.xml", "microsite.wEx-116425.0.xml", "microsite.wEx-116427.0.xml", "microsite.wEx-116432.0.xml", "microsite.wEx-116433.0.xml", "microsite.wEx-116435.0.xml", "microsite.wEx-116436.0.xml", "microsite.wEx-116439.0.xml", "microsite.wEx-116444.0.xml", "microsite.wEx-116445.0.xml", "microsite.wEx-116446.0.xml", "microsite.wEx-116447.0.xml", "microsite.wEx-116448.0.xml", "microsite.wEx-116449.0.xml", "microsite.wEx-116450.0.xml", "microsite.wEx-116451.0.xml", "microsite.wEx-116464.0.xml", "microsite.wEx-116475.0.xml", "microsite.wEx-116480.0.xml", "microsite.wEx-116483.0.xml", "microsite.wEx-116486.0.xml", "microsite.wEx-116487.0.xml", "microsite.wEx-116488.0.xml", "microsite.wEx-116492.0.xml", "microsite.wEx-116530.0.xml", "microsite.wEx-116534.0.xml", "microsite.wEx-116544.0.xml", "microsite.wEx-116550.0.xml", "microsite.wEx-116553.0.xml", "microsite.wEx-116554.0.xml", "microsite.wEx-116564.0.xml", "microsite.wEx-116569.0.xml", "microsite.wEx-116574.0.xml", "microsite.wEx-116577.0.xml", "microsite.wEx-116580.0.xml", "microsite.wEx-116583.0.xml", "microsite.wEx-116585.0.xml", "microsite.wEx-116591.0.xml", "microsite.wEx-116592.0.xml", "microsite.wEx-116593.0.xml", "microsite.wEx-116597.0.xml", "microsite.wEx-116603.0.xml", "microsite.wEx-116607.0.xml", "microsite.wEx-116617.0.xml", "microsite.wEx-116632.0.xml", "microsite.wEx-116634.0.xml", "microsite.wEx-116636.0.xml", "microsite.wEx-116637.0.xml", "microsite.wEx-116638.0.xml", "microsite.wEx-116639.0.xml", "microsite.wEx-116641.0.xml", "microsite.wEx-116646.0.xml", "microsite.wEx-116648.0.xml", "microsite.wEx-116680.0.xml", "microsite.wEx-116681.0.xml", "microsite.wEx-116684.0.xml", "microsite.wEx-116685.0.xml", "microsite.wEx-116687.0.xml", "microsite.wEx-116694.0.xml", "microsite.wEx-116695.0.xml", "microsite.wEx-116697.0.xml", "microsite.wEx-116701.0.xml", "microsite.wEx-116715.0.xml", "microsite.wEx-116716.0.xml", "microsite.wEx-116719.0.xml", "microsite.wEx-116722.0.xml", "microsite.wEx-116727.0.xml", "microsite.wEx-116728.0.xml", "microsite.wEx-116733.0.xml", "microsite.wEx-116737.0.xml", "microsite.wEx-116739.0.xml", "microsite.wEx-116741.0.xml", "microsite.wEx-116746.0.xml", "microsite.wEx-116748.0.xml", "microsite.wEx-116749.0.xml", "microsite.wEx-116751.0.xml", "microsite.wEx-116755.0.xml", "microsite.wEx-116756.0.xml", "microsite.wEx-116762.0.xml", "microsite.wEx-116764.0.xml", "microsite.wEx-116765.0.xml", "microsite.wEx-116768.0.xml", "microsite.wEx-116771.0.xml", "microsite.wEx-116780.0.xml", "microsite.wEx-116788.0.xml", "microsite.wEx-116807.0.xml", "microsite.wEx-116824.0.xml", "microsite.wEx-116827.0.xml", "microsite.wEx-116828.0.xml", "microsite.wEx-116829.0.xml", "microsite.wEx-116831.0.xml", "microsite.wEx-116832.0.xml", "microsite.wEx-116836.0.xml", "microsite.wEx-116837.0.xml", "microsite.wEx-116838.0.xml", "microsite.wEx-116839.0.xml", "microsite.wEx-116840.0.xml", "microsite.wEx-116841.0.xml", "microsite.wEx-116842.0.xml", "microsite.wEx-116843.0.xml", "microsite.wEx-116844.0.xml", "microsite.wEx-116847.0.xml", "microsite.wEx-116849.0.xml", "microsite.wEx-116850.0.xml", "microsite.wEx-116851.0.xml", "microsite.wEx-116852.0.xml", "microsite.wEx-116854.0.xml", "microsite.wEx-116855.0.xml", "microsite.wEx-116860.0.xml", "microsite.wEx-116866.0.xml", "microsite.wEx-116918.0.xml", "microsite.wEx-116923.0.xml", "microsite.wEx-116924.0.xml", "microsite.wEx-116929.0.xml", "microsite.wEx-116932.0.xml", "microsite.wEx-116934.0.xml", "microsite.wEx-116935.0.xml", "microsite.wEx-116941.0.xml", "microsite.wEx-116942.0.xml", "microsite.wEx-116946.0.xml", "microsite.wEx-116948.0.xml", "microsite.wEx-116950.0.xml", "microsite.wEx-116951.0.xml", "microsite.wEx-116952.0.xml", "microsite.wEx-116955.0.xml", "microsite.wEx-116963.0.xml", "microsite.wEx-116972.0.xml", "microsite.wEx-116983.0.xml", "microsite.wEx-117001.0.xml", "microsite.wEx-117012.0.xml", "microsite.wEx-117013.0.xml", "microsite.wEx-117016.0.xml", "microsite.wEx-117017.0.xml", "microsite.wEx-117019.0.xml", "microsite.wEx-117021.0.xml", "microsite.wEx-117024.0.xml", "microsite.wEx-117026.0.xml", "microsite.wEx-117038.0.xml", "microsite.wEx-117039.0.xml", "microsite.wEx-117043.0.xml", "microsite.wEx-117044.0.xml", "microsite.wEx-117046.0.xml" }; Console.Write("Option:"); string option = Console.ReadLine(); if (option.Equals("1")) { string path = @"C:\inetpub\integratorxmlfiles\uploaded\archives\microsite"; System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(path); var filesInFolder = dir.GetFiles(); foreach (System.IO.FileInfo f in filesInFolder) { if (filesMicrosite.Any(d => f.Name.Contains(d))) { string[] newname = Regex.Split(f.Name, "microsite"); f.CopyTo( string.Format("C:/inetpub/integratorxmlfiles/uploaded/archives/microsite{0}", newname[1]), true); Console.WriteLine(newname[1]); } } } else if (option.Equals("2")) { string path = @"C:\inetpub\integratorxmlfiles\uploaded\archives\profile"; System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(path); var filesInFolder = dir.GetFiles(); foreach (System.IO.FileInfo f in filesInFolder) { try { string[] newname = Regex.Split(f.Name, "fan"); f.CopyTo(string.Format("c:/inetpub/integratorxmlfiles/uploaded/profiles/fan{0}", newname[1]), true); Console.WriteLine(newname[1]); } catch (Exception) { Console.WriteLine("couldn't copy {0}", f.Name); } } } else if (option.Equals("3")) { //FanoramaStagingEntities entity = new FanoramaStagingEntities(); //foreach (User user in entity.Users) //{ // if (!IsValid(user.Email) ) // { // BadUser baduser = new BadUser(); // entity.BadUsers.AddObject(baduser); // } //} } else if (option.Equals("4")) { FanoramaStagingEntities entity = new FanoramaStagingEntities(); string pricelist = ConfigurationManager.AppSettings["duplicatedPricelist"].ToString(); var duplicates = (from d in entity.UserProfiles where d.PropertyDefinitionID == 69 && d.PropertyValue.Equals(pricelist) select d).DefaultIfEmpty(); var duplicateTable = (from dc in duplicates group dc by dc.UserID into g let c = g.Count() where c > 1 select new { g.Key, c }).DefaultIfEmpty(); foreach (var dup in duplicateTable) { if (dup != null) { //find the userid inside duplicates var repeated = from d in duplicates where dup.Key == d.UserID select d; int counter = 0; // loop through all of them if (repeated != null) { foreach (var rep in repeated) { if (rep != null && counter > 0) { entity.UserProfiles.Remove(rep); Console.WriteLine(rep.UserID); } counter++; } } } } entity.SaveChanges(); } else if (option.Equals("5")) { FanoramaStagingEntities entity = new FanoramaStagingEntities(); string path = string.Format(@"c:\kianoush\profile\"); string fullpath; List<string> result = new List<string>(); List<string> profileFiles = listAllFiles(path); foreach (string profileFile in profileFiles) { fullpath = string.Format("{0}{1}", path, profileFile); try { if (System.IO.File.Exists(fullpath)) { using (XmlTextReader xmlreader = new XmlTextReader(fullpath)) { InsertIntoDB(xmlreader, entity); } } else { Console.WriteLine(string.Format("{0} hasn't been uploaded", profileFile)); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } } else if (option.Equals("6")) { FanoramaStagingEntities entity = new FanoramaStagingEntities(); var createdmicrosites = from m in entity.TAA_Microsite where m.IntegratorRetrievalCode != null select m; foreach (var microsite in createdmicrosites) { TAA_FanID newfan = new TAA_FanID(); newfan.Accent = microsite.Accent; newfan.PrimaryColor = microsite.PrimaryColour; newfan.SecondaryColor = microsite.SecondaryColour; newfan.City = microsite.City; newfan.TeamName = microsite.TeamName; newfan.CreatedByUserID = -1; newfan.CreatedOnDate = DateTime.Now; newfan.Deleted = false; newfan.School = microsite.School; newfan.City = microsite.City; newfan.DesignName = microsite.TeamName; newfan.MicrositeID = microsite.MicrositeID; newfan.PrimaryColorID = microsite.PrimaryColorID; newfan.SecondaryColorID = microsite.SecondaryColorID; newfan.AccentColorID = microsite.AccentColorID; int sportid = -1; if (microsite.SportID == null) sportid = -1; else sportid = (int)microsite.SportID; newfan.TAASportID = sportid; string sport; sport = newfan.Sport; if (newfan.Sport == null) sport = "-1"; newfan.Sport = sport; entity.TAA_FanID.Add(newfan); } entity.SaveChanges(); } else if (option.Equals("7")) { string path = string.Format(@"d:\kianoush\dealers\dealer.xml"); XmlSerializer serializer = new XmlSerializer(typeof(Table)); StreamReader reader = new StreamReader(path); Table dealers = (Table)serializer.Deserialize(reader); reader.Close(); string customerid; FanoramaStagingEntities entity = new FanoramaStagingEntities(); StreamWriter writer = new StreamWriter(@"d:\kianoush\dealers\notimported.csv"); foreach (var dealer in dealers.Items) { customerid = dealer.Cell[0].Data.Trim(); var userprofile = (from f in entity.UserProfiles where f.PropertyValue.Trim().Equals(customerid) select f).FirstOrDefault(); if (userprofile != null) { UserProfile newuserprofile = new UserProfile(); newuserprofile.UserID = userprofile.UserID; newuserprofile.Visibility = 2; newuserprofile.PropertyDefinitionID = 68; newuserprofile.PropertyValue = "True"; newuserprofile.LastUpdatedDate = DateTime.Now; entity.UserProfiles.Add(newuserprofile); newuserprofile = new UserProfile(); newuserprofile.UserID = userprofile.UserID; newuserprofile.Visibility = 2; newuserprofile.PropertyDefinitionID = 67; newuserprofile.PropertyValue = dealer.Cell[4].Data; newuserprofile.LastUpdatedDate = DateTime.Now; entity.UserProfiles.Add(newuserprofile); Console.WriteLine(customerid); } else { writer.WriteLine(customerid); } } writer.Close(); entity.SaveChanges(); } else if (option.Equals("8")) { FanoramaStagingEntities entity = new FanoramaStagingEntities(); string path = string.Format(@"c:\kianoush\microsite\"); var players = from p in entity.TAA_RoleCards select p; string fullpath; List<string> result = new List<string>(); List<string> profileFiles = listAllFiles(path); foreach (string profileFile in profileFiles) { fullpath = string.Format("{0}{1}", path, profileFile); try { if (System.IO.File.Exists(fullpath)) { using (XmlTextReader xmlreader = new XmlTextReader(fullpath)) { } } else { Console.WriteLine(string.Format("{0} hasn't been uploaded", profileFile)); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } } else if (option.Equals("9")) { FanoramaStagingEntities entity = new FanoramaStagingEntities(); DateTime yesterday = DateTime.Now.AddDays(-2); InsertNewProduct(entity, yesterday, "D0008", 13); InsertNewProduct(entity, yesterday, "D0010", 8); InsertNewProduct(entity, yesterday, "D0012", 2); } else if (option.Equals("10")) { FanoramaStagingEntities entity = new FanoramaStagingEntities(); foreach (var microsite in entity.TAA_Microsite) { if (microsite.URL != null) if (microsite.URL.Contains("thefanorama.com")) { //string temp = microsite.URL.Replace("slp.", string.Empty); //if (microsite.URL.Contains("blondgorilla")) // temp = temp.Replace("blondgorilla.", string.Empty);4 string temp = microsite.URL.Replace("thefanorama.com", "dev.thefanorama.blondgorilla.com"); microsite.URL = temp; Console.WriteLine(temp); } } entity.SaveChanges(); } else if (option.Equals("11")) { FanoramaStagingEntities entity = new FanoramaStagingEntities(); var microsites = entity.TAA_Microsite.Where(p => p.CreatedFromSLP == false).DefaultIfEmpty(); string path = string.Empty; string target = string.Empty; string fileName = string.Empty; string fileExtention = string.Empty; foreach (var microsite in microsites) { string mainpath = @"c:/temp/microimages/"; path = string.Format(@"{0}MicrositeImages/{1}/", mainpath, microsite.MicrositeID); var fanid = entity.TAA_FanID.Where(p => p.MicrositeID == microsite.MicrositeID).FirstOrDefault(); fileName = Guid.NewGuid().ToString(); var micrositeId=microsite.MicrositeID; var firstOrDefault = integratorEntity.ImageUpdates.FirstOrDefault(i => i.MicrositeId == micrositeId); if (firstOrDefault != null) { string oldpath =firstOrDefault.ImagePath; fileExtention = Path.GetExtension(oldpath); string targetBasePath = string.Format(@"{0}/FanIdImages/{1}/", mainpath, fanid.FanID); if (!Directory.Exists(targetBasePath)) Directory.CreateDirectory(targetBasePath); target = string.Format(@"{0}/FanIdImages/{1}/{2}{3}", mainpath, fanid.FanID, fileName, fileExtention); System.IO.File.Copy(oldpath, target, true); fanid.UserUploadedGraphic = target.Replace(mainpath, "http://staging.thefanorama.blondgorilla.com"); target = string.Format(@"{0}/FanIdImages/{1}/{2}.tif", mainpath, fanid.FanID, fileName); if (!System.IO.File.Exists(target)) System.IO.File.Copy(oldpath, target); } fanid.GAUploadedGraphic = target.Replace(mainpath, "http://staging.thefanorama.blondgorilla.com"); Console.WriteLine(target); } entity.SaveChanges(); } else if (option.Equals("12")) { var webClient = new WebClient(); var fanImagesPath = @"D:\inetpub\wwwroot\FanoramaStaging\MicrositeImages\"; //var fanImagesPath = @"C:\temp\MicrositeImages\"; var filepath = string.Empty; var sceneSevenUrl = "http://216.23.175.26/is/image/TeamworkAthletic/customerUploads/"; string sceneFilePath; var microsites = entity.TAA_Microsite.Where(p => p.CreatedFromSLP == false).DefaultIfEmpty(); foreach (var microsite in microsites) { if (!string.IsNullOrEmpty(microsite.TeamLogo)) { if (microsite.MicrositeID == 15114) filepath = filepath; filepath = string.Format("{0}{1}", fanImagesPath, microsite.MicrositeID); if (!Directory.Exists(filepath)) { Directory.CreateDirectory(filepath); } sceneFilePath = string.Format("{0}{1}?fmt=tif-alpha", sceneSevenUrl, ConvertExtensionToTif(microsite.TeamLogo)); SaveLogo(sceneFilePath, microsite, fanImagesPath); } } entity.SaveChanges(); } else if (option.Equals("13")) { var fans = entity.TAA_FanID.Where(e => e.UserUploadedGraphic.Contains("dev.")); foreach (var fan in fans) { fan.UserUploadedGraphic = fan.UserUploadedGraphic.Replace( "http://dev.thefanorama.blondgorilla.com", "http://thefanorama.com"); fan.GAUploadedGraphic = fan.GAUploadedGraphic.Replace("http://dev.thefanorama.blondgorilla.com", "http://thefanorama.com"); } entity.SaveChanges(); } else if (option.Equals("13")) { var fans = entity.TAA_FanID.Where(e => e.UserUploadedGraphic.Contains("dev.")); foreach (var fan in fans) { fan.UserUploadedGraphic = fan.UserUploadedGraphic.Replace( "http://dev.thefanorama.blondgorilla.com", "http://thefanorama.com"); fan.GAUploadedGraphic = fan.GAUploadedGraphic.Replace("http://dev.thefanorama.blondgorilla.com", "http://thefanorama.com"); } entity.SaveChanges(); } else if (option.Equals("14")) { InsertSize("D0011", 1100); InsertSize("D0012", 1100); InsertSize("D0009", 1100); InsertSize("D0011", 1090); InsertSize("D0012", 1090); InsertSize("D0009", 1090); entity.SaveChanges(); } //else if (option.Equals("9")) //{ // NewTweaker.dnnolddescriptionEntities oldentities = new NewTweaker.dnnolddescriptionEntities(); // FanoramaStagingEntities newentity = new FanoramaStagingEntities(); // string temp; // foreach (NewTweaker.CAT_Products oldproduct in oldentities.CAT_Products) // { // var newproduct = newentity.CAT_Products.Where(o => o.ProductID.Equals(oldproduct.ProductID)).FirstOrDefault(); // temp = newproduct.Free1; // if(newproduct!=null) // { // newproduct.Free1 = oldproduct.Free1; // newproduct.Free2 = oldproduct.Free2; // newproduct.Free3 = oldproduct.Free3; // } // Console.WriteLine(string.Format("Product number {0} has been changed description1 {1} to {2}",newproduct.ProductID,temp, newproduct.Free1)); // } // newentity.AcceptAllChanges(); // newentity.SaveChanges(); //} //else if (option.Equals("9")) //{ // FanoramaStagingEntities entity = new FanoramaStagingEntities(); // var products = from c in entity.CAT_Products where c.CMSProductID>193 && c.ProductName.Contains("Youth") select c; // foreach (var product in products) // { // CAT_AdvCatProducts adv = new CAT_AdvCatProducts(); // adv.ProductID = product.ProductID; // adv.AdvCatID = 12; // entity.CAT_AdvCatProducts.AddObject(adv); // } // entity.SaveChanges(); //} //else if (option.Equals("10")) //{ // FanoramaStagingEntities entity = new FanoramaStagingEntities(); // var products = from c in entity.CAT_Products where c.CMSProductID > 193 && c.ProductName.Contains("Adult") select c; // foreach (var product in products) // { // CAT_AdvCatProducts adv = new CAT_AdvCatProducts(); // adv.ProductID = product.ProductID; // adv.AdvCatID = 0; // entity.CAT_AdvCatProducts.AddObject(adv); // } // entity.SaveChanges(); //} Console.WriteLine("Done!"); Console.ReadLine(); }
private void SortRows() { _result = _result.OrderBy(c=>c.Type).ThenBy(x=>x.RowId).ToList(); }
private void AddOpeningsToDocuments(List<DocumentDao> documents, int year) { var openingsWithoutDoubles = _factory.GetOpeningsService().GetOpeningsWithoutDoubles(_clientId, year); foreach (var opening in openingsWithoutDoubles) { documents.Add(new DocumentDao {AccountDt = opening.Name, AccountCt = "", Price = opening.Dt}); documents.Add(new DocumentDao {AccountCt = opening.Name, AccountDt = "", Price = opening.Ct}); } }
private void GetAccountDocumentsForAccountSide(AccountDao account, Func<Report, IList<ReportDocument>> reportLambda, Func<OpeningDao, double> openingsFunction, Func<DocumentDao, string> documentProperty ) { reportLambda.Invoke(_report).Add(new ReportDocument { Id = 0, AutoNumber = "BO", Number = "BO", Price = _openings.Sum(openingsFunction) }); var allDocuments = _dbContext.Documents.Where(c => c.ClientId.Equals(_clientId) && c.Year.Equals(_year)).ToList(); _documents = allDocuments.Where(c => documentProperty.Invoke(c).StartsWith(account.Name)).OrderBy(x => x.AutoNumber).ToList(); foreach (var item in _documents) reportLambda.Invoke(_report).Add(new ReportDocument { Id = item.Id, AutoNumber = item.AutoNumber.ToString(), Number = item.Number, Price = item.Price }); }