Beispiel #1
0
        /// <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);
        }
Beispiel #2
0
        /// <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;
        }