How to read a Temperature for August and get the total Aveg

Abdalla Omran

Hi there

How to read a Temperature for August and get the total Aveg just for 29 day instead 31 day ?

i want to get the Aveg Temperature of August which has 31 day but sometime there is a data of temp just for 29 or 27 however how could i get the Avag based on how many days has been read and saved as data that could be (29,27,26 or 10 days) ?

here is the code :

public static TheWeather GetAverageForMonth(List entries, int year, int month)
{
if (entries == null || entries.Count < 1)
return null;
int days = 0;
int index = entries.Count();
double total = 0.0;
double Aveg = 0.0;
for (index = 0; index < entries.Count; index++)
{
if (entries[index].dateTime.Year == year && entries[index].dateTime.Month == month)
{
total += entries[index].Actual_mean_temp;
days = entries[index].dateTime.Day;
}
}
Aveg = total / days;
return entries[index];

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gajendra Jangid7y ago
hello abdalla

use following code:
public static Tuple, double> GetAverageForMonth(List entries, int year, int month)
       {
           if (entries == null || entries.Count < 1)
               return null;
           double Aveg = 0.0;
           var lst = entries.Where(s => s.dateTime.Year == year && s.dateTime.Month == year).ToList();
           Aveg = lst.Sum(s=>s.Actual_mean_temp) / DateTime.DaysInMonth(year, month);
           return new Tuple
       }
+1
Abdalla Omran7y ago
i have already tried but the problem here if there is only temperature for 29 day it will get the aveg for 31 day and thats wrong . i need the aveg based on how many days alread have it could be in August 29 or 23 days has been read
0
Suraj Kumar7y ago
There are two logic to get the number of days in any month and year.

1. No. of days = Row Count available in the table for that month and year
2. You can also get the number of days as shown below in C#

int month;

int year;

int totalDays = DateTime.DaysInMonth(year, month);
+1