Exemplo n.º 1
0
        public string test()
        {
            var reading = new PowerAvg()
            {
                P1 = 120,                       //model.Power1,
                P2 = 120,                       //model.Power2,
                P3 = 120,                       //model.Power3,
                primarySourceId  = 5,           //model.PrimarySourceId,
                secondrySourceId = null,        // model.SecondarySourceId,
                readingDate      = DateTime.Now //model.TimeStamp
            };

            Context.PowerAvg.Add(reading);
            Context.SaveChanges();

            return($"Ok,");
        }
Exemplo n.º 2
0
        public void peakPower(SourceReading model)
        {
            var count = Context.PowerAvg.ToList();

            if (count.Count() != 0)
            {
                PowerAvg firstModel = Context.PowerAvg.First();


                if (firstModel != null && firstModel.readingDate.AddHours(1) < model.TimeStamp)
                {
                    var primaries  = Context.PrimarySource.ToList();
                    var secondries = Context.secondarySource.ToList();
                    var avgs       = Context.PowerAvg.ToList();

                    foreach (var primary in primaries)
                    {
                        decimal totalp1 = 0;
                        decimal totalp2 = 0;
                        decimal totalp3 = 0;
                        decimal avgp1   = 0;
                        decimal avgp2   = 0;
                        decimal avgp3   = 0;


                        var pavg = count.Where(a => a.primarySourceId == Convert.ToInt32(primary.Code)).ToList();

                        if (pavg.Count != 0)
                        {
                            foreach (var avg in pavg)
                            {
                                totalp1 += avg.P1;
                                totalp2 += avg.P2;
                                totalp3 += avg.P3;
                            }
                            avgp1 = (totalp1) / (pavg.Count);
                            avgp2 = (totalp2) / (pavg.Count);
                            avgp3 = (totalp3) / (pavg.Count);

                            var peak = Context.powerPeak.DefaultIfEmpty().FirstOrDefault(p => p.primarySourceId == Convert.ToInt32(primary.Code));
                            if (peak != null)
                            {
                                if (peak.peakP1 < avgp1 || peak.peakP1 == avgp1)
                                {
                                    peak.peakP1 = avgp1;
                                    peak.dateP1 = firstModel.readingDate;
                                }
                                if (peak.peakP2 < avgp2 || peak.peakP2 == avgp2)
                                {
                                    peak.peakP2 = avgp2;
                                    peak.dateP2 = firstModel.readingDate;
                                }
                                if (peak.peakP3 < avgp3 || peak.peakP3 == avgp3)
                                {
                                    peak.peakP3 = avgp3;
                                    peak.dateP3 = firstModel.readingDate;
                                }
                                Context.powerPeak.Update(peak);
                                Context.SaveChanges();
                            }
                        }
                    }

                    foreach (var secondry in secondries)
                    {
                        decimal totalp1 = 0;
                        decimal totalp2 = 0;
                        decimal totalp3 = 0;
                        decimal avgp1   = 0;
                        decimal avgp2   = 0;
                        decimal avgp3   = 0;


                        var savg = avgs.Where(a => a.secondrySourceId == Convert.ToInt32(secondry.Code)).ToList();
                        if (savg.Count != 0)
                        {
                            foreach (var avg in savg)
                            {
                                totalp1 += avg.P1;
                                totalp2 += avg.P2;
                                totalp3 += avg.P3;
                            }

                            avgp1 = (totalp1) / (savg.Count);
                            avgp2 = (totalp2) / (savg.Count);
                            avgp3 = (totalp3) / (savg.Count);

                            var peak = Context.powerPeak.FirstOrDefault(p => p.secondrySourceId == Convert.ToInt32(secondry.Code));
                            if (peak.peakP1 < avgp1 || peak.peakP1 == avgp1)
                            {
                                peak.peakP1 = avgp1;
                                peak.dateP1 = firstModel.readingDate;
                            }
                            if (peak.peakP2 < avgp2 || peak.peakP2 == avgp2)
                            {
                                peak.peakP2 = avgp2;
                                peak.dateP2 = firstModel.readingDate;
                            }
                            if (peak.peakP3 < avgp3 || peak.peakP3 == avgp3)
                            {
                                peak.peakP3 = avgp3;
                                peak.dateP3 = firstModel.readingDate;
                            }
                            Context.powerPeak.Update(peak);
                            Context.SaveChanges();
                        }
                    }
                    // clear table
                    Context.Database.ExecuteSqlCommand("Delete From PowerAvg");

                    var reading = new PowerAvg()
                    {
                        P1 = model.Power1,
                        P2 = model.Power2,
                        P3 = model.Power3,
                        primarySourceId  = model.PrimarySourceId,
                        secondrySourceId = model.SecondarySourceId,
                        readingDate      = model.TimeStamp
                    };
                    Context.PowerAvg.Add(reading);
                    Context.SaveChanges();
                }
                else
                {
                    var reading = new PowerAvg()
                    {
                        P1 = model.Power1,
                        P2 = model.Power2,
                        P3 = model.Power3,
                        primarySourceId  = model.PrimarySourceId,
                        secondrySourceId = model.SecondarySourceId,
                        readingDate      = model.TimeStamp
                    };
                    Context.PowerAvg.Add(reading);
                    Context.SaveChanges();
                }
            }
            else
            {
                var reading = new PowerAvg()
                {
                    P1 = model.Power1,
                    P2 = model.Power2,
                    P3 = model.Power3,
                    primarySourceId  = model.PrimarySourceId,
                    secondrySourceId = model.SecondarySourceId,
                    readingDate      = model.TimeStamp
                };
                Context.PowerAvg.Add(reading);
                Context.SaveChanges();
            }



            // return $"Ok," + DateTimeOffset.UtcNow.ToUnixTimeSeconds();
        }