static void Main(string[] args) { var client = new DEXWebServiceSoapClient(); if (client.ClientCredentials != null) { client.ClientCredentials.UserName.UserName = "******"; client.ClientCredentials.UserName.Password = "******"; } var solarData = client.retreiveData("SOLAR_OPERATIONS_5mAVG", DateTime.Now.AddHours(-5).ToString("yyyy-MM-dd hh:00")); //var solarData = client.retreiveData("SOLAR_OPERATIONS_5mAVG", "2014-02-28 22:00"); var db = new OntarioSolarScadaDataDataContext(); var maxTime = (from r in db.OntarioSolarScadaDatas select r.BeginDateTime).Max() ?? DateTime.Parse("1960-01-31"); var solarDataList = ( from DataRow aPiDataRow in solarData.Rows where ValidatePiDataRow(aPiDataRow) && DateTime.Parse(aPiDataRow["begin_datetime"].ToString()) > maxTime select new OntarioSolarScadaData { OntarioSolarScadaDataId = Guid.NewGuid(), Name = aPiDataRow["name"].ToString(), BeginDateTime = DateTime.Parse(aPiDataRow["begin_datetime"].ToString()), DataQualityValue = aPiDataRow["percent_good"].ToString(), //ScadaValue = Decimal.Parse(aPiDataRow["value"].ToString()), ScadaValue = Decimal.Parse(aPiDataRow["value"].ToString(), System.Globalization.NumberStyles.Float), EngineeringUnits = aPiDataRow["engineering_units"].ToString(), CreatedBy = "TCPL\\jon_gaudette", Interval = aPiDataRow["interval"].ToString(), AggregationValue = aPiDataRow["aggregation"].ToString(), CreatedDateTime = DateTime.Now }).ToList(); if (solarDataList.Any()) { Console.WriteLine("Inserting " + solarDataList.Count + " rows"); db.OntarioSolarScadaDatas.InsertAllOnSubmit(solarDataList); db.SubmitChanges(); } Console.WriteLine("Done ... press any key to exit"); //Console.ReadLine(); }
public static void Process() { var client = new DEXWebServiceSoapClient(); if (client.ClientCredentials != null) { client.ClientCredentials.UserName.UserName = "******"; client.ClientCredentials.UserName.Password = "******"; } var plantData = client.retreiveData("HHSPP_DASHBOARD_snap", null); var plantDataList = (from DataRow aPiDataRow in plantData.Rows where ValidatePiDataRow(aPiDataRow) select new PlantStatus { PlantStatusId = Guid.NewGuid(), GeneratorId = Guid.Parse("1C6CBB34-B972-4F66-926B-A8D25B1DFD49"), Name = aPiDataRow["name"].ToString(), BeginDateTime = DateTime.Parse(aPiDataRow["begin_datetime"].ToString()), DataQualityValue = aPiDataRow["data_quality"].ToString(), EngineeringUnits = aPiDataRow["engineering_units"].ToString(), CreatedBy = "TCPL\\jon_gaudette", Interval = aPiDataRow["interval"].ToString(), AggregationValue = aPiDataRow["aggregation"].ToString(), CreatedDateTime = DateTime.Now, ScadaValue = aPiDataRow["value"].ToString() }).ToList(); if (plantDataList.Any()) { Console.WriteLine("Inserting {0} rows", plantDataList.Count); var db = new TBSPEntities1(); db.PlantStatuses.AddRange(plantDataList); db.SaveChanges(); } }