/// <summary> /// Get NotesDataInfo for a Notes_Data_nid /// </summary> /// <param name="notesDataNid"></param> /// <returns></returns> public NotesDataInfo GetNotesDataInfo(int notesDataNid) { NotesDataInfo RetVal = null; string SqlQuery = string.Empty; DbDataReader DBReader = null; try { SqlQuery = this.DBQueries.Notes.GetNoteData(notesDataNid.ToString()); DBReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery); if (DBReader.HasRows) { RetVal = new NotesDataInfo(); while (DBReader.Read()) { RetVal.Notes_Data_NId = (int)DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Data.NotesDataNId]; RetVal.Notes_NId = Convert.ToInt32(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Data.NotesNId]); RetVal.Data_NId = Convert.ToInt32(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Data.DataNId]); break; } } } catch (Exception ex) { ExceptionFacade.ThrowException(ex); } finally { if (!DBReader.IsClosed) { DBReader.Close(); } } return(RetVal); }
/// <summary> /// Update Notes data /// </summary> /// <param name="notesDataInfo"></param> public int UpdateNotesData(NotesDataInfo notesDataInfo) { int RetVal = 0; string SqlQuery = string.Empty; try { SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotesData(this.DBQueries.TablesName.NotesData, notesDataInfo.Notes_Data_NId, notesDataInfo.Notes_NId, notesDataInfo.Data_NId); RetVal = this.DBConnection.ExecuteNonQuery(SqlQuery); } catch (Exception ex) { ExceptionFacade.ThrowException(ex); } return(RetVal); }
/// <summary> /// Get NotesDataInfo for a Notes_Data_nid /// </summary> /// <param name="notesDataNid"></param> /// <returns></returns> public NotesDataInfo GetNotesDataInfo(int notesDataNid) { NotesDataInfo RetVal = null; string SqlQuery = string.Empty; DbDataReader DBReader = null; try { SqlQuery = this.DBQueries.Notes.GetNoteData(notesDataNid.ToString()); DBReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery); if (DBReader.HasRows) { RetVal = new NotesDataInfo(); while (DBReader.Read()) { RetVal.Notes_Data_NId = (int)DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Data.NotesDataNId]; RetVal.Notes_NId = Convert.ToInt32(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Data.NotesNId]); RetVal.Data_NId = Convert.ToInt32(DBReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes_Data.DataNId]); break; } } } catch (Exception ex) { ExceptionFacade.ThrowException(ex); } finally { if (!DBReader.IsClosed) { DBReader.Close(); } } return RetVal; }
/// <summary> /// Update Notes data /// </summary> /// <param name="notesDataInfo"></param> public int UpdateNotesData(NotesDataInfo notesDataInfo) { int RetVal = 0; string SqlQuery = string.Empty; try { SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotesData(this.DBQueries.TablesName.NotesData, notesDataInfo.Notes_Data_NId, notesDataInfo.Notes_NId, notesDataInfo.Data_NId); RetVal = this.DBConnection.ExecuteNonQuery(SqlQuery); } catch (Exception ex) { ExceptionFacade.ThrowException(ex); } return RetVal; }