public static void InsertFUTItemProfit(FUTItemProfit item)
{
using (var context = new FUTLogsDatabase())
{
var dbItem = context.FUTItemProfits.FirstOrDefault(x => x.ItemID == item.ItemID);
if (dbItem == null)
{
context.FUTItemProfits.Add(item);
context.SaveChanges();
}
else
{
context.Entry(dbItem).CurrentValues.SetValues(item);
context.SaveChanges();
}
}
}
public static void InsertFUTBotStatistics(FUTBotStatistics log)
{
using (var context = new FUTLogsDatabase())
{
context.FUTBotStatistics.Add(log);
context.SaveChanges();
}
}
public static void ResetFUTBuys()
{
using (var context = new FUTLogsDatabase())
{
context.FUTBuys.RemoveRange(context.FUTBuys);
context.SaveChanges();
}
}
public static void InsertFUTPriceCheck(FUTPriceCheck priceCheck)
{
using (var context = new FUTLogsDatabase())
{
context.FUTPriceChecks.Add(priceCheck);
context.SaveChanges();
}
}
public static void InsertFUTExceptionLog(FUTExceptionLog log)
{
using (var context = new FUTLogsDatabase())
{
context.FUTExceptionLogs.Add(log);
context.SaveChanges();
}
}
public static void InsertFUTSell(FUTSell sell)
{
using (var context = new FUTLogsDatabase())
{
context.FUTSells.Add(sell);
context.SaveChanges();
}
}
public static void InsertFUTBuy(FUTBuy buy)
{
using (var context = new FUTLogsDatabase())
{
context.FUTBuys.Add(buy);
context.SaveChanges();
}
}
public static void AddFUTNotification(string from, string data)
{
var logData = new FUTNotification(from, data);
using (var context = new FUTLogsDatabase())
{
context.FUTNotifications.Add(logData);
context.SaveChanges();
}
}
public static void RemoveFUTSell(long id)
{
using (var context = new FUTLogsDatabase())
{
var entity = context.FUTSells.FirstOrDefault(x => x.ID == id);
if (entity != null)
{
context.FUTSells.Remove(entity);
context.SaveChanges();
}
}
}
public static void UpdateFUTItemProfitByItemID(long itemID, int sellPrice)
{
using (var context = new FUTLogsDatabase())
{
var dbItem = context.FUTItemProfits.FirstOrDefault(x => x.ItemID == itemID);
if (dbItem == null)
{
return;
}
dbItem.SellPrice = sellPrice;
dbItem.Profit = (int)(sellPrice * 0.95) - dbItem.BuyPrice;
dbItem.SellTimestamp = Helper.CreateTimestamp();
context.SaveChanges();
}
}
public static void RemoveFUTNotification(int id)
{
lock (_removeFUTNotificationLock)
{
using (var context = new FUTLogsDatabase())
{
var data = context.FUTNotifications.FirstOrDefault(x => x.ID == id);
if (data != null)
{
context.FUTNotifications.Remove(data);
context.SaveChanges();
}
}
}
}
public static void UpdateCoinsByFUTAccount(FUTAccount account, int coins)
{
using (var context = new FUTLogsDatabase())
{
var lastSession = context.FUTCoins.FirstOrDefault(x => x.EMail.ToLower() == account.EMail.ToLower());
if (lastSession != null)
{
lastSession.Coins = coins;
}
else
{
var coinsNew = new FUTCoins
{
EMail = account.EMail,
Coins = coins
};
context.FUTCoins.Add(coinsNew);
}
context.SaveChanges();
}
}
public static void DeleteOldLogs()
{
#region FUTBotLogs
try
{
var twoDays = 172800000;
var now = Helper.CreateTimestamp();
using (var context = new FUTLogsDatabase())
{
var oldLogs = context.FUTBotLogs.OrderByDescending(x => x.ID).Where(x => (now - x.Timestamp) >= twoDays).ToList();
if (oldLogs.Any())
{
context.FUTBotLogs.RemoveRange(oldLogs);
context.SaveChanges();
}
}
}
catch (Exception e)
{
}
#endregion
#region FUTBotStatistics
try
{
var twoDays = 172800000;
var now = Helper.CreateTimestamp();
using (var context = new FUTLogsDatabase())
{
var oldLogs = context.FUTBotStatistics.OrderByDescending(x => x.ID).Where(x => (now - x.Timestamp) >= twoDays).ToList();
if (oldLogs.Any())
{
context.FUTBotStatistics.RemoveRange(oldLogs);
context.SaveChanges();
}
}
}
catch (Exception e)
{
}
#endregion
#region FUTBuys
try
{
var twoDays = 345600000;
var now = Helper.CreateTimestamp();
using (var context = new FUTLogsDatabase())
{
var oldLogs = context.FUTBuys.OrderByDescending(x => x.ID).Where(x => (now - x.Timestamp) >= twoDays).ToList();
if (oldLogs.Any())
{
context.FUTBuys.RemoveRange(oldLogs);
context.SaveChanges();
}
}
}
catch (Exception e)
{
}
#endregion
#region FUTSells
try
{
var twoDays = 172800000;
var now = Helper.CreateTimestamp();
using (var context = new FUTLogsDatabase())
{
var oldLogs = context.FUTSells.OrderByDescending(x => x.ID).Where(x => (now - x.Timestamp) >= twoDays).ToList();
if (oldLogs.Any())
{
context.FUTSells.RemoveRange(oldLogs);
context.SaveChanges();
}
}
}
catch (Exception e)
{
}
#endregion
#region FUTExceptionLogs
try
{
var twoDays = 172800000;
var now = Helper.CreateTimestamp();
using (var context = new FUTLogsDatabase())
{
var oldLogs = context.FUTExceptionLogs.OrderByDescending(x => x.ID).Where(x => (now - x.Timestamp) >= twoDays).ToList();
if (oldLogs.Any())
{
context.FUTExceptionLogs.RemoveRange(oldLogs);
context.SaveChanges();
}
}
}
catch (Exception e)
{
}
#endregion
}
