public void TestRepository() { var target = new SwedbankRepository(); var actual = target.RetrieveEntities().ToList(); Assert.AreEqual(true, actual.Any()); var first = actual.First(); Assert.AreEqual(EntityType.Branch, first.EntityType); }
public void Export_Test() { var target = new SwedbankRepository(); var list = target.RetrieveEntities().ToList(); foreach (var entity in list) { Console.WriteLine( @" INSERT INTO [dbo].[Entity] ([Id] ,[Title] ,[Address] ,[City] ,[Country] ,[Latitude] ,[Longitude] ,[Description] ,[Branch] ,[CashOut] ,[CashIn] ,[Chain] ,[Icon] ,[IconSmall] ,[IconMap]) VALUES ('" + entity.Id.ToString() + @"' ,N'" + entity.Title + @"' ,N'" + entity.Address + @"' ,N'" + entity.City + @"' ,N'" + entity.Country + @"' ," + entity.Latitude + @" ," + entity.Longitude + @" ,N'" + entity.Description + @"' ,'" + (entity.EntityType == EntityType.Branch ? "True" : "False") + @"' ,'" + ((entity.CashDirection & CashDirection.Out) == CashDirection.Out ? "True" : "False") + @"' ,'" + ((entity.CashDirection & CashDirection.In) == CashDirection.In ? "True" : "False") + @"' ,'" + entity.ChainCode + @"'" + @" ,'https://public.sn2.livefilestore.com/y1pKOlQfZIviShgTJZQ1WsivFhOqlRtgVgP1sMNRnzRKTYi6vV1bK17nubHaLCpv9QEJDTYhvnQxyr1aJyhS-EyUQ/swedbank-details.png' ,'https://public.sn2.livefilestore.com/y1pKOlQfZIviSiKIebSOvBNvwrHsTYGlpd7IPRKkiGkFxsVKgJZo96K-sjLFhlyh031vNYZpR5ZedUvgH5WM4yTbQ/swedbank-list.png' ,'https://public.sn2.livefilestore.com/y1pDfD1fyeUX4qqF2S1W3MQfST3Jnz-sHNCXrC08CE10RahJS1DzYQweIbokavH3CkPyBwsFo-hs2ZV8LZoqjp4bw/swedbank-map.png')"); } }