Browser.mod.DB.LoadTrendCount C# (CSharp) Method

LoadTrendCount() public static method

public static LoadTrendCount ( int callstack_uid, short fromDate, short toDate, ForEachTrendCount func ) : bool
callstack_uid int
fromDate short
toDate short
func ForEachTrendCount
return bool
        public static bool LoadTrendCount(int callstack_uid, short fromDate, short toDate, ForEachTrendCount func)
        {
            if (fromDate <= 0)
                fromDate = (short)kSampleBegin;
            if (toDate < 0)
                toDate = (short)kSampleEnd;

            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                try
                {
                    conn.Open();

                    SqlCommand cmd1 = new SqlCommand("usp_select_daily_count_per_version", conn);
                    cmd1.CommandType = CommandType.StoredProcedure;

                    cmd1.Parameters.AddWithValue("@callstack_uid", callstack_uid);
                    cmd1.Parameters.AddWithValue("@day_from", fromDate);
                    cmd1.Parameters.AddWithValue("@day_to", toDate);

                    SqlDataReader reader = cmd1.ExecuteReader();

                    while (reader.Read())
                    {
                        string version = reader.GetString(0);
                        string date = reader.GetString(1);
                        int count = reader.GetInt32(2);

                        func(version, date, count);
                    }

                    reader.Close();
                }
                catch (System.Exception)
                {
                    return false;
                }
            }

            return true;
        }