public SecureGateLog FillSecureGateLogByID(long ID) { SecureGateLog secureGateLog = new SecureGateLog(); try { using (NpgsqlConnection npgsqlConnection = AppConfig.GetConnection()) { if (npgsqlConnection.State == ConnectionState.Closed) { npgsqlConnection.Open(); } string query = "SELECT securegatelogid,dtm1,loc1,logcat,logremark,refid FROM securegatelog WHERE securegatelogid=@id "; using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(query, npgsqlConnection)) { npgsqlCommand.Parameters.AddWithValue("@id", ID); using (NpgsqlDataReader npgsqlDataReader = npgsqlCommand.ExecuteReader()) { if (npgsqlDataReader.Read()) { MappingDataReaderToSecureGateLog(npgsqlDataReader, secureGateLog); } } } } } catch (Exception ex) { throw ex; } return(secureGateLog); }
public bool DeleteSecureGateLog(SecureGateLog secureGateLog) { bool result = false; try { using (NpgsqlConnection npgsqlConnection = AppConfig.GetConnection()) { if (npgsqlConnection.State == ConnectionState.Closed) { npgsqlConnection.Open(); } string query = "Delete from SecureGateLog where SecureGateLogID =@SecureGateLogID "; //secureGateLog.SecureGateLogID = CtsCounter.NextValCtsCounter("SecureGateLog_SecureGateLogID_SEQ"); //secureGateLog.Dtm1 = DateTime.Now; using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(query, npgsqlConnection)) { npgsqlCommand.Parameters.AddWithValue("@SecureGateLogID", secureGateLog.SecureGateLogID); npgsqlCommand.ExecuteNonQuery(); result = true; } } } catch (Exception) { throw; } return(result); }
public bool UpdateSecureGateLog(SecureGateLog secureGateLog) { bool result = false; try { using (NpgsqlConnection npgsqlConnection = AppConfig.GetConnection()) { if (npgsqlConnection.State == ConnectionState.Closed) { npgsqlConnection.Open(); } string query = "UPDATE securegatelog SET dtm1=@Dtm1, loc1=@Loc1, logcat=@LogCat, logremark=@LogRemark, refid=@RefID WHERE securegatelogid=@SecureGateLogID "; //secureGateLog.SecureGateLogID = CtsCounter.NextValCtsCounter("SecureGateLog_SecureGateLogID_SEQ"); //secureGateLog.Dtm1 = DateTime.Now; using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(query, npgsqlConnection)) { npgsqlCommand.Parameters.AddWithValue("@SecureGateLogID", secureGateLog.SecureGateLogID); npgsqlCommand.Parameters.AddWithValue("@Dtm1", secureGateLog.Dtm1); npgsqlCommand.Parameters.AddWithValue("@Loc1", secureGateLog.Loc1); npgsqlCommand.Parameters.AddWithValue("@LogCat", secureGateLog.LogCat); npgsqlCommand.Parameters.AddWithValue("@LogRemark", secureGateLog.LogRemark); npgsqlCommand.Parameters.AddWithValue("@RefID", secureGateLog.RefID); npgsqlCommand.ExecuteNonQuery(); result = true; } } } catch (Exception ex) { throw ex; } return(result); }
public bool InsertSecureGateLog(SecureGateLog secureGateLog) { bool result = false; try { using (NpgsqlConnection npgsqlConnection = AppConfig.GetConnection()) { if (npgsqlConnection.State == ConnectionState.Closed) { npgsqlConnection.Open(); } string query = "INSERT INTO securegatelog(securegatelogid,dtm1,loc1,logcat,logremark,refid) VALUES(@SecureGateLogID,@Dtm1,@Loc1,@LogCat,@LogRemark,@RefID)"; secureGateLog.SecureGateLogID = CtsCounter.NextValCtsCounter("SecureGateLog_SecureGateLogID_SEQ"); secureGateLog.Dtm1 = DateTime.Now; using (NpgsqlCommand npgsqlCommand = new NpgsqlCommand(query, npgsqlConnection)) { npgsqlCommand.Parameters.AddWithValue("@SecureGateLogID", secureGateLog.SecureGateLogID); npgsqlCommand.Parameters.AddWithValue("@Dtm1", secureGateLog.Dtm1); npgsqlCommand.Parameters.AddWithValue("@Loc1", secureGateLog.Loc1); npgsqlCommand.Parameters.AddWithValue("@LogCat", secureGateLog.LogCat); npgsqlCommand.Parameters.AddWithValue("@LogRemark", secureGateLog.LogRemark); npgsqlCommand.Parameters.AddWithValue("@RefID", secureGateLog.RefID); npgsqlCommand.ExecuteNonQuery(); result = true; } } } catch (Exception) { throw; } return(result); }
public void MappingDataReaderToSecureGateLog(NpgsqlDataReader npgsqlDataReader, SecureGateLog secureGateLog) { secureGateLog.SecureGateLogID = npgsqlDataReader.GetInt64(npgsqlDataReader.GetOrdinal("SecureGateLogID")); if (npgsqlDataReader["dtm1"] != DBNull.Value) { secureGateLog.Dtm1 = npgsqlDataReader.GetDateTime(npgsqlDataReader.GetOrdinal("dtm1")); } secureGateLog.Loc1 = npgsqlDataReader.GetString(npgsqlDataReader.GetOrdinal("Loc1")); secureGateLog.LogCat = npgsqlDataReader.GetString(npgsqlDataReader.GetOrdinal("LogCat")); secureGateLog.LogCat = npgsqlDataReader.GetString(npgsqlDataReader.GetOrdinal("LogRemark")); secureGateLog.RefID = npgsqlDataReader.GetInt64(npgsqlDataReader.GetOrdinal("RefID")); }