public void TestRepository()
{
var target = new SebRepository();
var actual = target.RetrieveEntities().ToList();
Assert.AreEqual(true, actual.Any());
var first = actual.First();
Assert.AreEqual(EntityType.Atm, first.EntityType);
Assert.AreEqual(CashDirection.Out, first.CashDirection & CashDirection.Out);
}
public void Export_Test()
{
var target = new SebRepository();
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/y1p5_YspPNoGAtTPJ-2nRfewaaE0l482ZKz1tYcBg62O2c31rAYY7NMedeoQquUp3o9lAQ3OIdrA4VzpxRbrwrTTg/seb-details.png'
,'https://public.sn2.livefilestore.com/y1pwxXFOcT0JPfDoU5qzYfW6vK4Sn2lHa3dcQKRjzbSXw1yp306f1x9pErty2Y1lek5LZf4B1Er0ikdSl4tfOePYg/seb-list.png'
,'https://public.sn2.livefilestore.com/y1p5_YspPNoGAucTgeioIPa1vYjUa5ofpGLj8CunW-9mTtdQF1yUXC9_HAWpL5DX0MpRZEW2Mxz8W8spWyDQuQyzg/seb-map.png')");
}
}
