protected void Update_Month_Aggregation(long Element_ID)
{
try
{
InnonAnalyticsWarehouseEntities db_datawarehouse_context = new InnonAnalyticsWarehouseEntities();
//Get last inserted record in the table Point_Agg_Hour
int months = int.Parse(ConfigurationManagerHelper.AppSettings["aggregate_months"].ToString());
DateTime datetime = DateTime.Now.AddMonths(-months);
long MonthID = Helper.Get_Month_ID(datetime.Year, datetime.Month);
IList <Point_Agg_Month> tbl_point_Agg_Months = db_datawarehouse_context.Point_Agg_Month.Where(point_Months => point_Months.Point_ID == Element_ID && point_Months.Month_ID >= MonthID).ToList();
if (tbl_point_Agg_Months.Count() > 0)
{
List <Aggregate_Raw_Data> _list_aggregation = new List <Aggregate_Raw_Data>();
_list_aggregation = Get_Aggregate_Raw_Data(Element_ID, Helper.Get_Last_Day_Of_Month(MonthID), AggerationType.Month);
//Compare the raw data and aggregate data
_list_aggregation = _list_aggregation.Where(aggregate => tbl_point_Agg_Months.Any(aggr_Months =>
Helper.Get_Month_ID(aggregate.Month_Year_ID, aggregate.Month_ID) == aggr_Months.Month_ID &&
(aggregate.TotalCount != aggr_Months.Month_Count || aggregate.SumValue != aggr_Months.Sum_Value))).ToList();
if (_list_aggregation.Count() > 0)
{
tbl_point_Agg_Months = Point_Agg_Month_Convert.Convert_List_Aggregate_Raw_Data_To_Point_Agg_Month_List(_list_aggregation);
db_datawarehouse_context = new InnonAnalyticsWarehouseEntities();
foreach (Point_Agg_Month tbl_point_Agg_Month in tbl_point_Agg_Months)
{
db_datawarehouse_context.Point_Agg_Month.Attach(tbl_point_Agg_Month);
db_datawarehouse_context.Entry(tbl_point_Agg_Month).State = System.Data.Entity.EntityState.Modified;
}
db_datawarehouse_context.SaveChanges();
}
}
}
catch (Exception ex)
{
File_Log.SaveLog_ToFile(ex, Common.Enums.LoggingActions.Error, "Update_Month_Aggregation passing parameter element_id:- " + Element_ID);
}
}
protected void Update_Day_Aggregation(long Element_ID)
{
try
{
InnonAnalyticsWarehouseEntities db_datawarehouse_context = new InnonAnalyticsWarehouseEntities();
//Get last inserted record in the table Point_Agg_Hour
double days = double.Parse(ConfigurationManagerHelper.AppSettings["aggregate_days"].ToString());
DateTime datetime = DateTime.Now.AddDays(-(days + 1)); // add 1 because Date_ID in Point_Agg_Day 00:00:00 time
IList <Point_Agg_Day> tbl_point_Agg_Days = db_datawarehouse_context.Point_Agg_Day.Where(point_Days => point_Days.Point_ID == Element_ID && point_Days.Date_ID >= datetime).ToList();
if (tbl_point_Agg_Days.Count() > 0)
{
List <Aggregate_Raw_Data> _list_aggregation = new List <Aggregate_Raw_Data>();
_list_aggregation = Get_Aggregate_Raw_Data(Element_ID, Helper.Get_Last_Day(datetime), AggerationType.Day);
//Compare the raw data and aggregate data
_list_aggregation = _list_aggregation.Where(aggregate => tbl_point_Agg_Days.Any(aggr_Days =>
aggregate.Date_ID == aggr_Days.Date_ID &&
(aggregate.TotalCount != aggr_Days.Day_Count || aggregate.SumValue != aggr_Days.Sum_Value))).ToList();
if (_list_aggregation.Count() > 0)
{
tbl_point_Agg_Days = Point_Agg_Day_Convert.Convert_List_Aggregate_Raw_Data_To_Point_Agg_Day_List(_list_aggregation);
db_datawarehouse_context = new InnonAnalyticsWarehouseEntities();
foreach (Point_Agg_Day tbl_point_Agg_Day in tbl_point_Agg_Days)
{
db_datawarehouse_context.Point_Agg_Day.Attach(tbl_point_Agg_Day);
db_datawarehouse_context.Entry(tbl_point_Agg_Day).State = System.Data.Entity.EntityState.Modified;
}
db_datawarehouse_context.SaveChanges();
}
}
}
catch (Exception ex)
{
File_Log.SaveLog_ToFile(ex, Common.Enums.LoggingActions.Error, "Update_Day_Aggregation passing parameter element_id:- " + Element_ID);
}
}
