public List <report> GetReport(decimal createdate = 0) { List <report> list = new List <report>(); try { using (var db = new CoinTradeContext(connectionString)) { var orders = db.report.Where(a => a.id >= createdate).OrderByDescending(a => a.id).ToList(); if (orders != null && orders.Count() > 0) { var first = orders.FirstOrDefault(); string m = first.date?.Remove(0, 11)?.Remove(1, 2); var orders10 = orders.Where(a => a.date?.Remove(0, 11)?.Remove(1, 2) == m).ToList(); list = orders.Take(10).ToList(); list.AddRange(orders10); list = list.Distinct().ToList(); } } } catch (Exception e) { throw (e); } return(list); }
public List <report> GetReportHours() { List <report> list = new List <report>(); try { using (var db = new CoinTradeContext(connectionString)) { //long NowTicks = DateTime.Parse(DateTime.UtcNow.AddDays(-1).ToString("yyyy-MM-dd")).Ticks; //var createdate = (NowTicks - new DateTime(1970, 1, 1).Ticks) / 10000; var createdate = (DateTime.UtcNow.AddHours(-24).Ticks - new DateTime(1970, 1, 1).Ticks) / 10000; var orders = db.report.Where(a => a.id >= createdate).OrderByDescending(a => a.id).ToList(); if (orders != null && orders.Count() > 0) { orders = orders.Where(a => a.date?.Remove(0, 10)?.Remove(2, 2) == "00").ToList(); if (orders != null && orders.Count() > 0) { list = orders; } } } } catch (Exception e) { throw (e); } return(list); }
public List <report> GetReportDaily() { List <report> list = new List <report>(); try { using (var db = new CoinTradeContext(connectionString)) { var createdate = (DateTime.UtcNow.AddDays(-14).Ticks - new DateTime(1970, 1, 1).Ticks) / 10000; var orders = db.report.Where(a => a.id >= createdate).OrderByDescending(a => a.id).ToList(); if (orders != null && orders.Count() > 0) { orders = orders.Where(a => a.date?.Remove(0, 8)?.Remove(4, 2) == "0000").ToList(); if (orders != null && orders.Count() > 0) { list = orders; } } } } catch (Exception e) { throw (e); } return(list); }
public report GetReportById(decimal id) { try { using (var db = new CoinTradeContext(connectionString)) { if (id == -1) { return(db.report.LastOrDefault()); } var report = db.report.FirstOrDefault(a => a.id == id); return(report); } } catch (Exception e) { throw (e); } }
public List <error> GetError(decimal createdate = 0) { List <error> list = new List <error>(); try { using (var db = new CoinTradeContext(connectionString)) { var orders = db.error.Where(a => a.id >= createdate).ToList(); if (orders != null && orders.Count() > 0) { list = orders; } } } catch (Exception e) { throw (e); } return(list); }
public List <order> GetDBOrders(DateTime opendate) { List <order> list = new List <order>(); try { string str = opendate.ToString("yyyyMMddHHmmss"); using (var db = new CoinTradeContext(connectionString)) { var orders = db.order.Where(a => str.CompareTo(a.date) <= 0).ToList(); if (orders != null && orders.Count() > 0) { list = orders; } } } catch (Exception e) { throw (e); } return(list); }
public List <report> GetReports(DateTime startdate) { List <report> list = new List <report>(); try { long ticks = (startdate.Ticks - new DateTime(1970, 1, 1).Ticks) / 10000;; using (var db = new CoinTradeContext(connectionString)) { var orders = db.report.Where(a => a.id >= ticks).OrderByDescending(a => a.id).ToList(); if (orders != null && orders.Count() > 0) { list = orders; } } } catch (Exception e) { throw (e); } return(list); }