private void UpdateMinMaxLogs(decimal priceUsd)
{
var minMaxLogDb = new SqlRepository <MinMaxLog>(new BitstampTraderEntities());
// get the record of the current day
var currentDay = DateTime.Now.Date;
var dateDb = minMaxLogDb.ToList().FirstOrDefault(l => l.Day == currentDay);
// if the day record do not exist then add, otherwise update the min and max values if necessary
if (dateDb == null)
{
minMaxLogDb.Add(new MinMaxLog {
Day = currentDay, Minimum = priceUsd, Maximum = priceUsd
});
}
else
{
if (dateDb.Minimum > priceUsd)
{
dateDb.Minimum = priceUsd;
}
if (dateDb.Maximum < priceUsd)
{
dateDb.Maximum = priceUsd;
}
}
// save changes to database
minMaxLogDb.Save();
}
public void NotificationWithId_IsAddedToTheRepository(Guid id)
{
var notification = NotificationEventBuilder.From(new NotificationEventHealthCheck())
.Build();
notification.Id = id;
_sut.Add(notification);
}
private void SaveBuyLimitOrderInDb(BitstampOrder order)
{
try
{
LastBuyTimestamp = DateTime.Now;
var bitstampOrdersDb = new SqlRepository <Order>(new BitstampTraderEntities());
bitstampOrdersDb.Add(new Order {
BuyAmount = order.Amount, BuyPrice = order.Price, BuyId = order.Id, Currency = "btc"
});
bitstampOrdersDb.Save();
}
catch (Exception e)
{
throw new Exception("BitstampExchange.SaveBuyLimitOrderInDb() : " + e.Message);
}
}
static async Task Main(string[] args)
{
string input = "";
Dictionary <string, Category> categoryLookup = new Dictionary <string, Category>()
{
{ "wishlist", Category.Wishlist },
{ "collection", Category.Collection }
};
IFileAccess azureFileAccess = new AzureFileAccess(Constants.AzureFileConnectionString, Constants.AzureFileShareName);
IFileAccess localFileAccess = new LocalFileAccess();
IAlbumRepository repository = new SqlRepository(Constants.DbConnectionString);
// IAlbumRepository repository = new JsonRepository(Constants.AzureFileFilepath, azureFileAccess);
//IAlbumRepository repository = new JsonRepository(Constants.LocalFilePath, localFileAccess);
//IAlbumRepository repository = new CosmosRepository(Constants.CosmosEndpointUri, Constants.CosmosPrimaryKey, Constants.CosmosDatabaseId, Constants.CosmosContainerId);
while (input != "9")
{
Console.WriteLine("Main Menu");
Console.WriteLine("1. Enter new Album");
Console.WriteLine("2. Edit Album");
Console.WriteLine("3. Display All");
Console.WriteLine("4. Display Wishlist");
Console.WriteLine("5. Display Collection");
Console.WriteLine("6. Display filtered albums");
Console.WriteLine("7. Display Totals");
Console.WriteLine("8. Delete Album");
Console.WriteLine("9. Exit");
input = Console.ReadLine();
if (input == "1")
{
Console.Write("Artist: ");
string artist = Console.ReadLine();
Console.Write("Title: ");
string title = Console.ReadLine();
Console.Write("Year: ");
int year = 0;
int.TryParse(Console.ReadLine(), out year);
Console.Write("Format: ");
string format = Console.ReadLine();
Console.Write("Store: ");
string store = Console.ReadLine();
decimal price = 0;
Console.Write("Price: ");
decimal.TryParse(Console.ReadLine(), out price);
Console.Write("Symbol: ");
string symbol = Console.ReadLine();
Console.Write("Location: ");
string location = Console.ReadLine();
Category c = Category.Wishlist;
categoryLookup.TryGetValue(location.ToLower(), out c);
await repository.Add(new Album()
{
Id = 0,
Artist = artist,
Title = title,
Year = year == 0 ? "" : year.ToString(),
Format = format,
Store = store,
Price = price,
Symbol = symbol,
Location = c
});
}
else if (input == "2")
{
int id = 0;
Console.WriteLine("Edit Album");
Console.Write("Id to edit: ");
int.TryParse(Console.ReadLine(), out id);
Album e = await repository.GetBy(id);
if (e != null)
{
string artist = e.Artist;
string title = e.Title;
string year = e.Year;
string format = e.Format;
string store = e.Store;
decimal price = e.Price;
string symbol = e.Symbol;
Category location = e.Location;
Console.Write("Artist (" + artist + "): ");
string artistIn = Console.ReadLine();
if (!string.IsNullOrEmpty(artistIn))
{
e.Artist = artistIn;
}
Console.Write("Title (" + title + "): ");
string titleIn = Console.ReadLine();
if (!string.IsNullOrEmpty(titleIn))
{
e.Title = titleIn;
}
Console.Write("Year (" + year + "): ");
string yearIn = Console.ReadLine();
if (!string.IsNullOrEmpty(yearIn))
{
int y = 0;
int.TryParse(yearIn, out y);
e.Year = y == 0 ? "" : y.ToString();
}
Console.Write("Format (" + format + "): ");
string formatIn = Console.ReadLine();
if (!string.IsNullOrEmpty(formatIn))
{
e.Format = formatIn;
}
Console.Write("Store (" + store + "): ");
string storeIn = Console.ReadLine();
if (!string.IsNullOrEmpty(storeIn))
{
e.Store = storeIn;
}
Console.Write("Price (" + price + "): ");
string priceIn = Console.ReadLine();
if (!string.IsNullOrEmpty(priceIn))
{
decimal p = 0;
decimal.TryParse(priceIn, out p);
e.Price = p;
}
Console.Write("Symbol (" + symbol + "): ");
string symbolIn = Console.ReadLine();
if (!string.IsNullOrEmpty(symbolIn))
{
e.Symbol = symbolIn;
}
Console.Write("Location (" + location + "): ");
string locationIn = Console.ReadLine();
if (!string.IsNullOrEmpty(locationIn))
{
Category c = Category.Wishlist;
categoryLookup.TryGetValue(locationIn.ToLower(), out c);
e.Location = c;
}
await repository.Edit(e);
}
else
{
Console.WriteLine("Could not find album with id = " + id);
}
}
else if (input == "3")
{
printAlbums(await repository.GetAll());
}
else if (input == "4")
{
printAlbums(repository.GetAll().Result.Where(a => a.Location == Category.Wishlist));
}
else if (input == "5")
{
printAlbums(repository.GetAll().Result.Where(a => a.Location == Category.Collection));
}
else if (input == "6")
{
Console.Write("Filter Expression: ");
string filter = Console.ReadLine();
// var result = repository.GetFilteredAlbums(filter);
var result = GetFilteredAlbums(filter, repository.GetAll().Result);
printAlbums(result);
}
else if (input == "7")
{
decimal wishListTotal = repository.GetAll().Result.Where(a => a.Location == Category.Wishlist).Sum(a => a.Price);
decimal collectionTotal = repository.GetAll().Result.Where(a => a.Location == Category.Collection).Sum(a => a.Price);
Console.WriteLine("Wishlist total: " + wishListTotal.ToString("C", CultureInfo.CurrentCulture));
Console.WriteLine("Collection total: " + collectionTotal.ToString("C", CultureInfo.CurrentCulture));
}
else if (input == "8")
{
Console.WriteLine("Delete album");
Console.Write("Id to delete: ");
string id = Console.ReadLine();
int parsedId = 0;
if (!int.TryParse(id, out parsedId))
{
Console.WriteLine("Id must be a number");
continue;
}
var a = await repository.GetBy(parsedId);
if (a != null)
{
Console.WriteLine("*** WARNING *** This operation cannot be undone. Please type the name of the album to delete below");
string titleToDelete = Console.ReadLine();
if (a.Title == titleToDelete)
{
await repository.Delete(a.Id);
}
else
{
Console.WriteLine("Album not found, nothing deleted");
}
}
}
else if (input == "9")
{
Console.WriteLine("Bye");
}
}
}
