Esempio n. 1
0
        /// <summary>
        /// Update Comments in each language
        /// </summary>
        /// <param name="commentsInfo"></param>
        public int UpdateComments(NotesInfo commentsInfo)
        {
            int      RetVal   = 0;
            string   SqlQuery = string.Empty;
            DITables TableNames;

            try
            {
                SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotes(this.DBQueries.TablesName.Notes, commentsInfo.Notes, commentsInfo.Classification_NId.ToString(), commentsInfo.Notes_Approved, commentsInfo.Notes_NId);

                RetVal = this.DBConnection.ExecuteNonQuery(SqlQuery);
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
            return(RetVal);
        }
Esempio n. 2
0
        /// <summary>
        /// Get CommentsInfo for CommentsNId
        /// </summary>
        /// <param name="notesNid"></param>
        /// <returns></returns>
        public NotesInfo GetNotesByNotesNid(string notesNid)
        {
            NotesInfo    RetVal     = null;
            DbDataReader DataReader = null;
            string       SqlQuery   = string.Empty;

            try
            {
                SqlQuery = this.DBQueries.Notes.GetNotes(String.Empty, notesNid, string.Empty, string.Empty, CheckedStatus.False, FieldSelection.Light);

                DataReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery);
                if (DataReader.HasRows)
                {
                    RetVal = new NotesInfo();
                    while (DataReader.Read())
                    {
                        RetVal.Notes_NId          = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.NotesNId];
                        RetVal.Profile_NId        = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.ProfileNId];
                        RetVal.Classification_NId = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.ClassificationNId];
                        RetVal.Notes          = Convert.ToString(DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.Note]);
                        RetVal.Notes_DateTime = Convert.ToString(DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.NotesDateTime]);
                        RetVal.Notes_Approved = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.NotesApproved];
                    }
                }
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
            finally
            {
                if (!DataReader.IsClosed)
                {
                    DataReader.Close();
                }
            }
            return(RetVal);
        }
Esempio n. 3
0
        /// <summary>
        /// Insert Commnets For Each Language
        /// </summary>
        /// <param name="commentsInfo">Object of CommentsInfo</param>
        public void InsertNotes(NotesInfo commentsInfo)
        {
            string LanguageCode        = string.Empty;
            string DefaultLanguageCode = string.Empty;
            string Comments            = string.Empty;
            string SqlQuery            = string.Empty;
            string NotesTableName      = string.Empty;

            try
            {
                DefaultLanguageCode = this.DBQueries.LanguageCode;

                foreach (DataRow languageRow in this.DBConnection.DILanguages(this.DBQueries.DataPrefix).Rows)
                {
                    LanguageCode = languageRow[Language.LanguageCode].ToString();

                    if (LanguageCode == DefaultLanguageCode.Replace("_", String.Empty))
                    {
                        Comments = commentsInfo.Notes;
                    }
                    else
                    {
                        Comments = Constants.PrefixForNewValue + commentsInfo.Notes;
                    }

                    NotesTableName = this.DBQueries.TablesName.Notes.Replace(DefaultLanguageCode, "_" + LanguageCode);

                    SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Insert.InsertNotes(NotesTableName, Comments, commentsInfo.Classification_NId.ToString(), commentsInfo.Profile_NId.ToString(), commentsInfo.Notes_DateTime, commentsInfo.Notes_Approved);

                    this.DBConnection.ExecuteNonQuery(SqlQuery);
                }
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
        }
Esempio n. 4
0
        /// <summary>
        /// Get CommentsInfo for CommentsNId
        /// </summary>
        /// <param name="notesNid"></param>
        /// <returns></returns>
        public NotesInfo GetNotesByNotesNid(string notesNid)
        {
            NotesInfo RetVal=null;
            DbDataReader DataReader=null;
            string SqlQuery = string.Empty;
            try
            {
                SqlQuery = this.DBQueries.Notes.GetNotes(String.Empty, notesNid, string.Empty, string.Empty, CheckedStatus.False, FieldSelection.Light);

                DataReader = (DbDataReader)this.DBConnection.ExecuteReader(SqlQuery);
                if (DataReader.HasRows)
                {
                    RetVal = new NotesInfo();
                    while (DataReader.Read())
                    {
                        RetVal.Notes_NId = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.NotesNId];
                        RetVal.Profile_NId = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.ProfileNId];
                        RetVal.Classification_NId = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.ClassificationNId];
                        RetVal.Notes = Convert.ToString(DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.Note]);
                        RetVal.Notes_DateTime = Convert.ToString(DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.NotesDateTime]);
                        RetVal.Notes_Approved = (int)DataReader[DevInfo.Lib.DI_LibDAL.Queries.DIColumns.Notes.NotesApproved];
                    }
                }

            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
            finally
            {
                if (!DataReader.IsClosed)
                    DataReader.Close();
            }
            return RetVal;
        }
Esempio n. 5
0
        /// <summary>
        /// Update Comments in each language
        /// </summary>
        /// <param name="commentsInfo"></param>
        public int UpdateComments(NotesInfo commentsInfo)
        {
            int RetVal=0;
            string SqlQuery = string.Empty;
            DITables TableNames;
            try
            {

                SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Update.UpdateNotes(this.DBQueries.TablesName.Notes, commentsInfo.Notes, commentsInfo.Classification_NId.ToString(), commentsInfo.Notes_Approved, commentsInfo.Notes_NId);

                RetVal = this.DBConnection.ExecuteNonQuery(SqlQuery);
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
            return RetVal;
        }
Esempio n. 6
0
        /// <summary>
        /// Insert Commnets For Each Language
        /// </summary>
        /// <param name="commentsInfo">Object of CommentsInfo</param>
        public void InsertNotes(NotesInfo commentsInfo)
        {
            string LanguageCode=string.Empty;
            string DefaultLanguageCode=string.Empty;
            string Comments=string.Empty;
            string SqlQuery = string.Empty;
            string NotesTableName=string.Empty;

            try
            {
                DefaultLanguageCode = this.DBQueries.LanguageCode;

                foreach (DataRow languageRow in this.DBConnection.DILanguages(this.DBQueries.DataPrefix).Rows)
                {

                    LanguageCode = languageRow[Language.LanguageCode].ToString();

                    if (LanguageCode == DefaultLanguageCode.Replace("_", String.Empty))
                    {
                        Comments = commentsInfo.Notes;
                    }
                    else
                    {
                        Comments = Constants.PrefixForNewValue + commentsInfo.Notes;
                    }

                    NotesTableName = this.DBQueries.TablesName.Notes.Replace(DefaultLanguageCode, "_" + LanguageCode);

                    SqlQuery = DevInfo.Lib.DI_LibDAL.Queries.Notes.Insert.InsertNotes(NotesTableName, Comments , commentsInfo.Classification_NId.ToString(), commentsInfo.Profile_NId.ToString(), commentsInfo.Notes_DateTime, commentsInfo.Notes_Approved);

                    this.DBConnection.ExecuteNonQuery(SqlQuery);
                }

            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
        }