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(); } }