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); }
private void deleteButton_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; string matchedSt = ""; if (_selectedLog.Matched) { matchedSt = "Matched @ " + _selectedLog.PriceMatched; } else { matchedSt = "Not Macthed"; } string dial = _selectedLog.Time.ToString() + " " + _selectedLog.BuySell + " " + _selectedLog.Volume + " @ " + _selectedLog.Price + " " + matchedSt; DialogResult dr = MessageBox.Show("Delete :\n" + dial, "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.No) { Cursor = Cursors.Default; return; } dc.WebTradeLogs.DeleteOnSubmit(_selectedLog); dc.SubmitChanges(); LoadListview(); Cursor = Cursors.Default; }
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(); }
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(); }
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(); }
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 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); }
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(); } }
private void saveButton_Click(object sender, EventArgs e) { if (EX == null) { dc.WebTradeLogs.InsertOnSubmit(tl); } else { EX.BuySell = tl.BuySell; EX.Matched = tl.Matched; EX.Price = tl.Price; EX.PriceMatched = tl.PriceMatched; EX.Price = tl.Price; EX.Reason = tl.Reason; EX.Time = tl.Time; EX.Volume = tl.Volume; } dc.SubmitChanges(); _onSaved(); saveButton.Enabled = false; }