public void InsertProcessedControlLoopData(ControlLoopDataCollection processedCLDataCollection, string dateId)
        {
            using (SqlConnection conn = new SqlConnection(_sqlConnection))
            {
                using (SqlCommand comm = new SqlCommand("[ThreeRates].[dbo].[INSERT_CurrentShiftControlLoopData]")
                {
                    CommandType = CommandType.StoredProcedure
                })
                {
                    comm.Connection = conn;

                    //comm.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output; //deleted from the db

                    comm.Parameters.Add("@DateID", SqlDbType.VarChar).Value    = dateId;
                    comm.Parameters.Add("@CRData", SqlDbType.Structured).Value = processedCLDataCollection;

                    try
                    {
                        conn.Open();
                        comm.ExecuteNonQuery();

                        //result = Convert.ToInt32(comm.Parameters["@Result"].Value); //no returning value

                        conn.Close();
                    }
                    catch (SqlException e) { Console.WriteLine("An errror occured during executing the SQL query: " + e.Message); }
                    if (conn.State == ConnectionState.Open)
                    {
                        conn.Close();
                    }
                }
            }
        }
Beispiel #2
0
        public void ProcessCRData(DateTime queryStart, DateTime queryEnd)
        {
            var modeTagsData              = _sqlDataAccess.GetModeTagsToProcess();
            var processedCLData           = _historianDataAccess.QueryControlLoopsTagData(modeTagsData, queryStart, queryEnd);
            var processedCLDataCollection = new ControlLoopDataCollection(processedCLData);

            string dateId = queryStart.ToString("yyyy.MM.dd. HH:mm");

            _sqlDataAccess.InsertProcessedControlLoopData(processedCLDataCollection, dateId);
        }