Exemplo n.º 1
0
        public static bool AddNewLog(LogModel log)
        {
            string dateStr = Convert.ToDateTime(log.Date).ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);

            String query = "INSERT IGNORE INTO " + TblLogs;
            query += " (`UserID`, `Date`, `MsgType`, `Symbol`, `Group`, `Status`,`Timeframe`,`Application`) VALUES";
            query += "(";
            query += log.UserId + ",";
            query += "'" + dateStr + "',";
            query += "'" + log.MsgType + "',";
            query += "'" + log.Symbol + "',";
            query += "'" + log.Group + "',";
            query += "'" + log.Status + "',";
            query += "'" + log.Timeframe + "',";
            query += "'" + log.Application + "'" + ");COMMIT;";

            return DoSql(query);
        }
Exemplo n.º 2
0
        public static List<LogModel> GetLogBetweenDates(DateTime startDate, DateTime endDate, bool desc = true)
        {
            string dateStart = Convert.ToDateTime(startDate).ToString("yyyy/MM/dd HH:mm:ss",
                                                                      CultureInfo.InvariantCulture);
            string dateEnd = Convert.ToDateTime(endDate).ToString("yyyy/MM/dd HH:mm:ss", CultureInfo.InvariantCulture);

            var resultList = new List<LogModel>();

            string sql = "SELECT * FROM " + TblLogs + " WHERE Date BETWEEN '" + dateStart + "' AND '" + dateEnd +
                         "' ORDER BY `Date` " + (desc ? "DESC" : " ") + " , `ID` ASC;";
            lock (LockReader)
            {
                var reader = GetReader(sql);
                if (reader != null)
                {
                    while (reader.Read())
                    {
                        var log = new LogModel
                                      {
                                          LogId = reader.GetInt32(0),
                                          UserId = reader.GetInt32(1),
                                          Date = reader.GetDateTime(2),
                                          MsgType = reader.GetInt32(3),
                                          Symbol = reader.GetString(4),
                                          Group = reader.GetString(5),
                                          Status = reader.GetInt32(6),
                                          Timeframe = reader.GetString(7),
                                          Application = reader.GetString(8),
                                      };

                        resultList.Add(log);
                    }

                    reader.Close();
                }
            }
            return resultList;
        }