public NewOrderInput(newLogSaved Updatedeleagte, AlsiWebDataContext _dc, bool AdminRights)
{
InitializeComponent();
_onSaved = Updatedeleagte;
dc = _dc;
admin = AdminRights;
}
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 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 NewOrderInput(newLogSaved Updatedeleagte, WebTradeLog Log, AlsiWebDataContext _dc, bool AdminRights)
{
InitializeComponent();
_onSaved = Updatedeleagte;
loadExisting = true;
EX = Log;
dc = _dc;
admin = AdminRights;
}
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);
}
static void BW_DoWork(object sender, DoWorkEventArgs e)
{
var dc = new AlsiWebDataContext();
bool smsON = WebSettings.General.ENABLE_SMS;
List <string> sms = WebUpdate._SMSList.Where(z => z.Active == true).Select(z => z.TelNr).ToList();
foreach (var s in sms)
{
if (smsON)
{
Communicator.SMS.sendSMS(s, _Msg.text + "\n" + _SMSTrade);
}
}
}
static void BW_DoWork(object sender, DoWorkEventArgs e)
{
var dc = new AlsiWebDataContext();
// List<string> emails = dc.EmailLists.Where(z=>z.Active==true).Select(z => z.Email).ToList();
List <string> emails = WebUpdate._EmailList.Where(z => z.Active == true).Select(z => z.Email).ToList();
if (_Admin)
{
Communicator.Gmail.SendEmail(emails[0], _Msg.Title, _Msg.Body, null, "*****@*****.**", "1rachelle", "Alsi Trade System", false);
}
else
{
Communicator.Gmail.SendEmail(emails, _Msg.Title, _Msg.Body, null, "*****@*****.**", "1rachelle", "Alsi Trade System", false);
}
}
private void LoadListview()
{
dc = new AlsiWebDataContext();
tradeListView.Items.Clear();
var log = dc.WebTradeLogs.OrderByDescending(z => z.Time).Take(25);
foreach (var t in log)
{
ListViewItem lvi = new ListViewItem(t.Time.ToString());
lvi.Tag = t;
lvi.SubItems.Add(t.BuySell);
lvi.SubItems.Add(t.Price.ToString());
lvi.SubItems.Add(t.Reason);
lvi.SubItems.Add(t.Volume.ToString());
lvi.SubItems.Add(t.Matched.ToString());
lvi.SubItems.Add(t.PriceMatched.ToString());
tradeListView.Items.Add(lvi);
}
}
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();
}
}
public static void GetSmsList()
{
var dc = new AlsiWebDataContext();
_SMSList = dc.tblSMs.OrderBy(z => z.SMS_ID).ToList();
}
public static void GetEmailList()
{
var dc = new AlsiWebDataContext();
_EmailList = dc.tblEmails.OrderBy(z => z.Email_ID).ToList();
}
