public RowSet InsertTagDataCentral(SignalsInfo signal)
        {
            try
            {
                var insertBS = cassandraSessionMgr.
                               centralPreparedStmt.Bind(signal.ID, Convert.ToInt32(signal.MYear), signal.FTime, signal.TTime, signal.Max, signal.Min, signal.Avg, signal.Data, signal.CTime);

                if (ConnectionState)
                {
                    return(cassandraSessionMgr.currentSession.Execute(insertBS));
                }
                else
                {
                    cassandraSessionMgr.StopCassandraSession();
                    return(null);
                }
            }
            catch (Cassandra.NoHostAvailableException ex)
            {
                cassandraSessionMgr.StopCassandraSession();
                log.Error("M:- InsertTagDataCentral | V:- cassandra db no host available | Ex:- ", ex);
                return(null);
            }
            catch (Exception ex)
            {
                log.Error("M:- InsertTagDataCentral | V:- error while inserting central records | Ex:- ", ex);
                return(null);
            }
        }
        public void InsertTagDataFailed(SignalsInfo signal)
        {
            try
            {
                var insertBS = cassandraSessionMgr.
                               failedPreparedStmt.Bind(signal.ID, Convert.ToInt32(signal.MYear), signal.FTime, signal.TTime, signal.Avg, signal.Max, signal.Min, signal.Data, signal.CTime);

                if (ConnectionState)
                {
                    cassandraSessionMgr.currentSession.Execute(insertBS);
                }
                else
                {
                    cassandraSessionMgr.StopCassandraSession();
                    throw new Exception("M:-InsertTagDataFailed | V:- Cassandra Session Down");
                }
            }
            catch (Cassandra.NoHostAvailableException ex)
            {
                cassandraSessionMgr.StopCassandraSession();
                log.Error("M:- InsertTagDataFailed | V:- cassandra db no host available | Ex:- ", ex);
            }
            catch (Exception ex)
            {
                log.Error("M:- InsertTagDataFailed | V:- error while inserting failed records | Ex:- ", ex);
            }
        }
        public bool RemoveFailedTagData(SignalsInfo signal)
        {
            RowSet rs = null;

            try
            {
                BoundStatement insertBS = cassandraSessionMgr.deletePreparedStmt.Bind(signal.ID, Convert.ToInt32(signal.MYear), signal.FTime);

                if (ConnectionState)
                {
                    rs = cassandraSessionMgr.currentSession.Execute(insertBS);
                }
                else
                {
                    cassandraSessionMgr.StopCassandraSession();
                    throw new Exception("M:- RemoveFailedTagData | V:- Cassandra Session Down");
                }
            }
            catch (Cassandra.NoHostAvailableException ex)
            {
                cassandraSessionMgr.StopCassandraSession();
                log.Error("M:- RemoveFailedTagData | V:- cassandra db no host available | Ex:- ", ex);
                return(false);
            }
            catch (Exception ex)
            {
                log.Error("M:- RemoveFailedTagData | V:- error deleting batch [failed data] | Ex:- ", ex);
                return(false);
            }

            if (rs != null)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }