public static ActionCount[] GetData(DateTime start, DateTime end) { List <ActionCount> result = new List <ActionCount>(); SqlCommand commandCreated = new SqlCommand(@"SELECT CONVERT(VARCHAR,dt.dtime,1) AS 'Date', COUNT(a.DateCreated) AS 'ActionsAdded' FROM dbo.udfDateTimes(@StartDate,@EndDate,1,'day') AS dt LEFT JOIN (SELECT a.DateCreated, u.OrganizationID FROM Actions a INNER JOIN Users u ON a.CreatorID = u.UserID) a ON CAST(FLOOR(CAST(dt.dtime AS FLOAT)) AS DATETIME) = CAST(FLOOR(CAST(a.DateCreated AS FLOAT)) AS DATETIME) AND a.OrganizationID = @organizationID GROUP BY dt.dtime ORDER BY dt.dtime"); commandCreated.Parameters.AddWithValue("@organizationid", UserSession.LoginUser.OrganizationID); commandCreated.Parameters.AddWithValue("@StartDate", start); commandCreated.Parameters.AddWithValue("@EndDate", end); DataTable actionsAdded = SqlExecutor.ExecuteQuery(UserSession.LoginUser, commandCreated); foreach (DataRow thisRow in actionsAdded.Rows) { ActionCount counts = new ActionCount(); counts.ActionDate = (string)thisRow["Date"]; counts.Count = (int)thisRow["ActionsAdded"]; result.Add(counts); } return(result.ToArray()); }
private void Timer_Elapsed(object sender, ElapsedEventArgs e) { lock (sync) { ActionCount?.Invoke(actionCount); actionCount = 0; } }
public override int GetHashCode() { int hash = 1; if (ActionCount != 0) { hash ^= ActionCount.GetHashCode(); } if (AnotherActionCount != 0) { hash ^= AnotherActionCount.GetHashCode(); } if (ServerId.Length != 0) { hash ^= ServerId.GetHashCode(); } return(hash); }