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); } }