public static void DeleteUserFromSmsList(int UserID)
{
var dc = new AlsiWebDataContext();
var user = dc.tblSMs.Where(z => z.SMS_ID == UserID).First();
dc.tblSMs.DeleteOnSubmit(user);
dc.SubmitChanges();
GetSmsList();
}
private static void Set_ENABLE_SMS(bool Triggered)
{
AlsiWebDataContext dc = new AlsiWebDataContext();
var setting = dc.tblSettings.Where(z => z.SettingName == "ENABLE_SMS").First();
setting.ValueString = Triggered.ToString();
dc.SubmitChanges();
}
public static void CheckUncheckSmsListUser(int UserID)
{
var dc = new AlsiWebDataContext();
var user = dc.tblSMs.Where(z => z.SMS_ID == UserID).First();
user.Active = !user.Active;
dc.SubmitChanges();
GetSmsList();
}
private static void SetMANUAL_CLOSE_TRIGGER(bool Triggered)
{
AlsiWebDataContext dc = new AlsiWebDataContext();
var setting = dc.tblSettings.Where(z => z.SettingName == "MANUAL_CLOSE_TRIGGER").First();
setting.ValueString = Triggered.ToString();
dc.SubmitChanges();
}
public static bool InsertNewUsertoEmailList(tblEmail user)
{
var dc = new AlsiWebDataContext();
var insert = (!dc.tblEmails.Any(z => z.Email == user.Email));
if (insert)
{
user.Active = true;
dc.tblEmails.InsertOnSubmit(user);
dc.SubmitChanges();
GetEmailList();
}
return insert;
}
private static void Set_ENABLE_SMS(bool Triggered)
{
AlsiWebDataContext dc = new AlsiWebDataContext();
var setting = dc.tblSettings.Where(z => z.SettingName == "ENABLE_SMS").First();
setting.ValueString = Triggered.ToString();
dc.SubmitChanges();
}
private static void SetMANUAL_CLOSE_TRIGGER(bool Triggered)
{
AlsiWebDataContext dc = new AlsiWebDataContext();
var setting = dc.tblSettings.Where(z => z.SettingName == "MANUAL_CLOSE_TRIGGER").First();
setting.ValueString = Triggered.ToString();
dc.SubmitChanges();
}
public static bool InsertNewUsertoSmsList(tblSM user)
{
var dc = new AlsiWebDataContext();
var insert = (!dc.tblSMs.Any(z => z.TelNr == user.TelNr));
if (insert)
{
user.Active = true;
dc.tblSMs.InsertOnSubmit(user);
dc.SubmitChanges();
GetSmsList();
}
return insert;
}
public static void ClearTradeLog()
{
var dc = new AlsiWebDataContext();
var delall = dc.WebTradeLogs;
dc.WebTradeLogs.DeleteAllOnSubmit(delall);
dc.SubmitChanges();
}
public static void ClearEmailList()
{
var dc = new AlsiWebDataContext();
var delall = dc.tblEmails;
dc.tblEmails.DeleteAllOnSubmit(delall);
dc.SubmitChanges();
}
private static bool CheckDbCount(AlsiWebDataContext dc, Trade trade)
{
int c = dc.WebTradeLogs.Count();
if (c > 0)
{
//var last = dc.WebTradeLogs.Skip(c - 10).Take(10);
}
else
{//create new if db is empty
WebTradeLog wtl = new WebTradeLog()
{
Time = trade.TimeStamp,
BuySell = trade.BuyorSell.ToString(),
Price = (int)trade.TradedPrice,
Reason = trade.Reason.ToString(),
Volume = trade.TradeVolume,
PriceMatched = (int)trade.TradedPrice,
Matched = false,
};
dc.WebTradeLogs.InsertOnSubmit(wtl);
dc.SubmitChanges();
return false;
}
return true;
}
public static void SendOrderToWebDB(Trade trade)
{
var dc = new AlsiWebDataContext();
string bs = "none";
if (trade.BuyorSell == Trade.BuySell.Buy) bs = "Buy";
if (trade.BuyorSell == Trade.BuySell.Sell) bs = "Sell";
if (!CheckDbCount(dc, trade)) return;
if (!trade.xlMatched)
{
WebTradeLog wtl = new WebTradeLog()
{
Time = trade.TimeStamp,
BuySell = trade.BuyorSell.ToString(),
Price = (int)trade.TradedPrice,
Reason = trade.Reason.ToString(),
Volume = trade.TradeVolume,
PriceMatched = 0,
Matched = false,
};
// dc.WebTradeLogs.InsertOnSubmit(wtl);
//dc.SubmitChanges();
}
else
{
int c = dc.WebTradeLogs.Count();
var last = dc.WebTradeLogs.Skip(c - 1).Take(1).Single();
last.Time = trade.TimeStamp;
last.Matched = true;
dc.SubmitChanges();
}
}