Compare text

Find the difference between two text files

Real-time diff

Unified diff

Collapse lines

Highlight change

Syntax highlighting

Tools

Untitled diff

Created 9 years agoDiff never expires

using System;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using Microsoft.Practices.EnterpriseLibrary.ExceptionHandling;

using Agathos.FlexAnswer.BL.BusinessClasses;

using Agathos.FlexAnswer.BL.BusinessClasses.Collections;

using Agathos.FlexAnswer.BL.Interfaces;

using Agathos.FlexAnswer.BL.Logic.Exceptions;

using Agathos.FlexAnswer.BL.Logic.Utils;

namespace Agathos.FlexAnswer.BL.Logic

{

public class FrequentMessageGroups : IFrequentMessageGroups

{

// Class: Frequent Message Groups (FMG) - Wraps the logical entity of Frequent

// Message Groups

// The Frequent Message Groups are groups of messages which are logically

// similar, and therefore have the same response

// An FMG consists of:

// MessageText - a typical message summarising all the messages within the group

// ResponseTag - a convient reference to a response

// ResponseText - the full text of a response

// Folder - an FMG sits somewhere inside a folder hierarchy

// Internals:

// Internally an FMG is split across a number of tables: MesGroups being the

// primary one, but also MesGroupInstances, Messages and Responses

public int AddFrequentMessageGroup(int SessionId, int ProjectId, string MessageText, string ResponseTag, string ResponseText, int ResponseType, int FolderId, bool AddInstance, int ApprovalId)

{

int functionReturnValue = 0;

// Adds a new FMG to the project optionally places it in a folder specified by

// FolderId (defaults to top level folder, and will also put it in the top level

// folder if the FolderId is not valid)

// Returns a Long, which is the MesGroupId of the new FMG

// Also adds an instance with text of MessageText and trains the response

// server on this new instance

// Declaration

Messages objMess = default(Messages);

int lngMesId = 0;

Responses objResp = default(Responses);

MesGroups objMesGroup = new MesGroups();

MesGroupInstances objMGI = default(MesGroupInstances);

bool blnCreatingOk = false;

int lngRespId = 0;

// Error trapping begins

try

{

// Log entry

Logging.log.Info("FrequentMessageGroups:" + "AddFrequentMessageGroup");

Logging.log.Info("SessionId:" + SessionId.ToString());

Logging.log.Info("ProjectId:" + ProjectId.ToString());

Logging.log.Info("MessageText:" + MessageText.ToString());

Logging.log.Info("ResponseTag:" + ResponseTag.ToString());

Logging.log.Info("ResponseText:" + ResponseText.ToString());

Logging.log.Info("ResponseType:" + ResponseType.ToString());

Logging.log.Info("FolderId:" + FolderId.ToString());

Logging.log.Info("AddInstance:" + AddInstance.ToString());

// Main code

blnCreatingOk = true;

//' Check that the folder exists

objResp = new Responses();

if (!objResp.FolderExists(SessionId, ProjectId, FolderId))

{

FolderId = 0;

}

functionReturnValue = objResp.LookForSameAnswerName(ProjectId, ResponseTag, 0, ApprovalId);

if (functionReturnValue == 0)

{

functionReturnValue = objResp.LookForSameQuestionText(ProjectId, MessageText, 0, ApprovalId);

}

if (functionReturnValue > 0)

{

functionReturnValue = 0;

return functionReturnValue;

}

//' Add the message to the messages table

objMess = new Messages();

lngMesId = objMess.AddMessage(SessionId, ProjectId, MessageText, "FMG", 0);

functionReturnValue = lngMesId;

Logging.log.Info("Added message");

//' Add the response to the responses table

lngRespId = objResp.AddResponse(SessionId, ProjectId, ResponseTag, ResponseText, false, FolderId, ResponseType);

if (lngRespId == 0) blnCreatingOk = false;

objResp = null;

Logging.log.Info("Added response");

if (blnCreatingOk) {

//' Update TopMesGroupId and TopRespId

objMess.UpdateMessageTopMesGroupAndResp(SessionId, ProjectId, lngMesId, lngMesId, lngRespId);

objMess = null;

Logging.log.Info("Updated TopMesGroupId and TopRespId");

}

if (blnCreatingOk)

{

//' Add to the message groups table

objMesGroup = new MesGroups();

objMesGroup.AddMessageGroup(SessionId, ProjectId, lngMesId, lngRespId);

Logging.log.Info("Added message group");

}

if (blnCreatingOk)

{

//' Add to the message group instances table

objMGI = new MesGroupInstances();

if (!objMGI.AddMessageGroupInstance(SessionId, ProjectId, lngMesId, lngMesId, true))

{

blnCreatingOk = false;

}

Logging.log.Info("Added message group instance");

objMGI = null;

}

if (blnCreatingOk & AddInstance)

{

//' Add a matching user message

objMesGroup.AddUserMessageToGroup(SessionId, ProjectId, MessageText, lngMesId);

Logging.log.Info("Added matching user message");

objMesGroup = null;

}

// Commit transaction and release context object reference

if (blnCreatingOk)

{

Logging.log.Info("Transaction Complete");

}

else

{

functionReturnValue = 0;

Logging.log.Info("Transaction Aborted");

}

catch (Exception ex)

{

HandleException("App Layer Error:", ex);

}

return functionReturnValue;

}

public bool GetFrequentMessageGroupFromID(int SessionId, int ProjectId, int MesGroupId, ref string MessageText, ref string ResponseTag, ref string ResponseText, ref string FolderTag, ref int FolderId, ref int ResponseType, ref string CreatedBy,

ref int CreatedByUserId, ref string DateCreated, ref string EditedBy, ref string DateEdited, ref string ApprovedBy, ref string DateApproved)

{

// Returns the details of an FMG specified by MesGroupId

// MessageText (String)

// ResponseTag (String)

// ResponseText (String)

// FolderTag (String)

// FolderId (Long)

// Return value - false if the group could not be found

// Declaration

// Error trapping begins

try

{

// Log entry

Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroupFromID");

Logging.log.Info("SessionId:" + SessionId.ToString());

Logging.log.Info("ProjectId:" + ProjectId.ToString());

Logging.log.Info("MesGroupId:" + MesGroupId.ToString());

DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

return helper.GetFrequentMessageGroupFromID(SessionId, ProjectId, MesGroupId, ref MessageText, ref ResponseTag,

ref ResponseText, ref FolderTag, ref FolderId, ref ResponseType, ref CreatedBy, ref CreatedByUserId,

ref DateCreated, ref EditedBy, ref DateEdited, ref ApprovedBy, ref DateApproved);

}

catch (Exception ex)

{

// Main code

//' Get message group information given a message id

HandleException("App Layer Error:", ex);

}

return false;

}

public bool UpdateFrequentMessageGroup(int SessionId, int ProjectId, int MesGroupId, string MessageText, string ResponseTag, string ResponseText, int ResponseType)

{

bool functionReturnValue = false;

// Updates all of the fields of an FMG identified by MesGroupId

// all values must be specified and valid

// Returns false if the FMG doesn't exist

// Declaration

Messages objMess = default(Messages);

Responses objResp = default(Responses);

int lngRespId = 0;

MesGroups objMesGrp = default(MesGroups);

// Error trapping begins

try

{

// Log entry

Logging.log.Info("FrequentMessageGroups:" + "UpdateFrequentMessageGroup");

Logging.log.Info("SessionId:" + SessionId.ToString());

Logging.log.Info("ProjectId:" + ProjectId.ToString());

Logging.log.Info("MesGroupId:" + MesGroupId.ToString());

Logging.log.Info("MessageText:" + MessageText.ToString());

Logging.log.Info("ResponseTag:" + ResponseTag.ToString());

Logging.log.Info("ResponseText:" + ResponseText.ToString());

Logging.log.Info("ResponseType:" + ResponseType.ToString());

// Main code

// Could check that this is a FMG and the response is actually response

// for this group

//' Find the RespId

int SimilarText = 0;

SimilarText = 0;

objResp = new Responses();

SimilarText = objResp.LookForSameAnswerName(ProjectId, ResponseTag, MesGroupId, 0);

if (SimilarText == 0)

{

SimilarText = objResp.LookForSameQuestionText(ProjectId, MessageText, MesGroupId, 0);

}

if (SimilarText > 0)

{

functionReturnValue = false;

return false;

}

functionReturnValue = true;

lngRespId = GetRespID(MesGroupId);

Logging.log.Info("Got response id (" + lngRespId + ")");

if (lngRespId != 0)

{

//' Try to update responses table

functionReturnValue = objResp.UpdateResponse(SessionId, ProjectId, lngRespId, ResponseTag, ResponseText, ResponseType);

objResp = null;

if (!functionReturnValue)

{

Logging.log.Info("Unable to update response");

}

else

{

Logging.log.Info("Updated responses table");

//' Update data in messages table

objMess = new Messages();

objMess.UpdateMessageText(SessionId, ProjectId, MesGroupId, MessageText);

objMess = null;

Logging.log.Info("Updated messages table");

//'Update Message Group Table

objMesGrp = new MesGroups();

objMesGrp.UpdateEditInformation(SessionId, ProjectId, MesGroupId);

objMesGrp = null;

Logging.log.Info("Updated messages groups table");

}

Csr objCsr = default(Csr);

objCsr = new Csr();

bool IsApproveMQA = false;

IsApproveMQA = objCsr.GetCsrApproveMqa(SessionId, ProjectId);

//string strSQL = "";

bool FMGExist = false;

string FolderTag = "";

int FolderId = 0;

string CreatedBy = "";

int CreatedByUserId = 0;

string DateCreated = "";

string EditedBy = "";

string DateEdited = "";

string ApprovedBy = "";

string DateApproved = "";

if (!IsApproveMQA)

{

FMGExist = GetFrequentMessageGroupFromID(SessionId, ProjectId, MesGroupId, ref MessageText, ref ResponseTag,

ref ResponseText, ref FolderTag, ref FolderId, ref ResponseType, ref CreatedBy, ref CreatedByUserId,

ref DateCreated, ref EditedBy, ref DateEdited, ref ApprovedBy, ref DateApproved);

if (FMGExist == true) //commented for test on 31 Aug 12 //uncommented on 3 Sep 12 //commented again

{

DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

helper.UpdateFrequentMessageGroup(SessionId, ProjectId, MesGroupId, MessageText, ResponseTag, ResponseText, ResponseType, FolderId, lngRespId);

}

catch (Exception ex)

{

HandleException("App Layer Error:", ex);

}

return functionReturnValue;

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs)

{

int publishStatus = 0;

int folderId = 0;

string dateCondition = "";

int createdBy = 0;

int editedBy = 0;

int approvedBy = 0;

ViewType currentViewType = ViewType.LiveMqa;

return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,

int publishStatus)

{

int folderId = 0;

string dateCondition = "";

int createdBy = 0;

int editedBy = 0;

int approvedBy = 0;

ViewType currentViewType = ViewType.LiveMqa;

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,

int publishStatus, int folderId)

{

string dateCondition = "";

int createdBy = 0;

int editedBy = 0;

int approvedBy = 0;

ViewType currentViewType = ViewType.LiveMqa;

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,

int publishStatus, int folderId, string dateCondition)

{

int createdBy = 0;

int editedBy = 0;

int approvedBy = 0;

ViewType currentViewType = ViewType.LiveMqa;

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,

int publishStatus, int folderId, string dateCondition, int createdBy)

{

int editedBy = 0;

int approvedBy = 0;

ViewType currentViewType = ViewType.LiveMqa;

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,

int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy)

{

int approvedBy = 0;

ViewType currentViewType = ViewType.LiveMqa;

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,

int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, int approvedBy)

{

ViewType currentViewType = ViewType.LiveMqa;

}

public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,

int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,

int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, int approvedBy, ViewType currentViewType)

{

// Returns a StdResults structure which is a count of the total number of

// FMGs in the project and a recordset which represents the current

// view of the total set given the view settings

// Recordset consists of columns:

// Freq - Number of instances in the group

// MesGroupId - The MesGroupId of the group

// also MessageText

// and, if the following boolean inputs are true then the specified field

// will also be returned

// DispAnswer Then ResponseText

// DispTag Then AnswerTag

// Declaration

// Error trapping begins

try

{

// Log entry

//Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups");

//Logging.log.Info("SessionId:" + sessionId.ToString());

//Logging.log.Info("ProjectId:" + projectId.ToString());

////Logging.log.Info("UserId:" + userId.ToString())

//Logging.log.Info("Filter:" + filter_Renamed.ToString());

//Logging.log.Info("Order:" + order.ToString());

//Logging.log.Info("Dir:" + dir_Renamed.ToString());

//Logging.log.Info("DispTag:" + dispTag.ToString());

//Logging.log.Info("DispAnswer:" + dispAnswer.ToString());

//Logging.log.Info("Page:" + intPage.ToString());

//Logging.log.Info("PageSize:" + intPageSize.ToString());

//Logging.log.Info("PublishStatus:" + publishStatus.ToString());

//Logging.log.Info("FolderId:" + folderId.ToString());

//Logging.log.Info("DateCondition:" + dateCondition.ToString());

//Logging.log.Info("CreatedBy:" + createdBy.ToString());

//Logging.log.Info("EditedBy:" + editedBy.ToString());

//Logging.log.Info("ApprovedBy:" + approvedBy.ToString());

//Logging.log.Info("Special:" + currentViewType.ToString());

// Main code

//' Get count and recordset and build StdResults with it

// Remarked by CP on 2008-06-16 as it should be properly prased at the very Front-End

// Since it is more flexible.

//dateCondition = Trim(dateCondition)

//If dateCondition <> "" Then

//dateCondition = Right(dateCondition, Len(dateCondition) - 4)

//dateCondition = Replace(dateCondition, "'", "''")

//End If

// End of remarked by CP on 2008-06-16

//If page = 0 Then

//page = 1

//End If

// Count = GetFrequentMessagesInFolderCount(SessionId, ProjectId, Filter_Renamed, DispTag, DispAnswer, PublishStatus, FolderId, DateCondition)

//Dim helper As New Folders

//Dim strFolderList As String = helper.ChkFolder_RetrieveAllFoldersForUser(projectId, userId)

//helper = Nothing

// Get User Type

//Dim userHelper As New DataAccess.User

//Dim userTypeText As String = userHelper.GetUserType(userId)

//Dim currentUserType As Integer = GetUserLevelFromTypeText(userTypeText)

//Dim strFolders As String = ""

//If strFolderList <> "" And currentUserType < 3 Then

//strFolders = Mid(strFolderList, 2)

//End If

Logging.log.Info("Built std results");

return GetFrequentMessagesInFolderRecordset(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs,

publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);

}

catch (Exception ex)

{

HandleException("App Layer Error:", ex);

}

return new Collection<FrequentMessage>();

}

//Added by Priya on Sep 29, 2011

public int GetFrequentMessageGroupsMQA(int sessionId, int projectId, string filter,

int order, int dir, int page, int pageSize, int dispTag, int dispAnswer, int publishStatus,

int folderId = -1, string dateCondition = "", int createdBy = 0, int editedBy = 0, int approvedBy = 0, ViewType special = ViewType.LiveMqa, string strFolderList = "")

{

// Error trapping begins

int fmgCount = 0;

Collection<FrequentMessage> fmgCnt = new Collection<FrequentMessage>();

try {

// Log entry

//Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups for Status: Knowledge Report");

//Logging.log.Info("SessionId:" + sessionId.ToString());

//L

Saved diffs

Original text

Open file

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using Microsoft.Practices.EnterpriseLibrary.ExceptionHandling;
using Agathos.FlexAnswer.BL.BusinessClasses;
using Agathos.FlexAnswer.BL.BusinessClasses.Collections;
using Agathos.FlexAnswer.BL.Interfaces;
using Agathos.FlexAnswer.BL.Logic.Exceptions;
using Agathos.FlexAnswer.BL.Logic.Utils;

namespace Agathos.FlexAnswer.BL.Logic
{
    public class FrequentMessageGroups : IFrequentMessageGroups
    {
        // Class: Frequent Message Groups (FMG) - Wraps the logical entity of Frequent
        // Message Groups
        // The Frequent Message Groups are groups of messages which are logically
        // similar, and therefore have the same response
        // An FMG consists of:
        // MessageText - a typical message summarising all the messages within the group
        // ResponseTag - a convient reference to a response
        // ResponseText - the full text of a response
        // Folder - an FMG sits somewhere inside a folder hierarchy
        
        // Internals:
        // Internally an FMG is split across a number of tables:  MesGroups being the
        // primary one, but also MesGroupInstances, Messages and Responses
        
        public int AddFrequentMessageGroup(int SessionId, int ProjectId, string MessageText, string ResponseTag, string ResponseText, int ResponseType, int FolderId, bool AddInstance, int ApprovalId)
        {
            int functionReturnValue = 0;
            // Adds a new FMG to the project optionally places it in a folder specified by
            // FolderId (defaults to top level folder, and will also put it in the top level
            // folder if the FolderId is not valid)
            // Returns a Long, which is the MesGroupId of the new FMG
            // Also adds an instance with text of MessageText and trains the response
            // server on this new instance
            // Declaration
            
            Messages objMess = default(Messages);
            int lngMesId = 0;
            Responses objResp = default(Responses);
            MesGroups objMesGroup = new MesGroups();
            MesGroupInstances objMGI = default(MesGroupInstances);
            bool blnCreatingOk = false;
            int lngRespId = 0;
            
            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "AddFrequentMessageGroup");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MessageText:" + MessageText.ToString());
                Logging.log.Info("ResponseTag:" + ResponseTag.ToString());
                Logging.log.Info("ResponseText:" + ResponseText.ToString());
                Logging.log.Info("ResponseType:" + ResponseType.ToString());
                Logging.log.Info("FolderId:" + FolderId.ToString());
                Logging.log.Info("AddInstance:" + AddInstance.ToString());
                
                // Main code
                blnCreatingOk = true;
                //' Check that the folder exists
                objResp = new Responses();
                
                if (!objResp.FolderExists(SessionId, ProjectId, FolderId))
                {
                    FolderId = 0;
                }
                
                functionReturnValue = objResp.LookForSameAnswerName(ProjectId, ResponseTag, 0, ApprovalId);
                
                if (functionReturnValue == 0)
                {
                    functionReturnValue = objResp.LookForSameQuestionText(ProjectId, MessageText, 0, ApprovalId);
                }
                
                if (functionReturnValue > 0)
                {
                    functionReturnValue = 0;

                    return functionReturnValue;
                }
                
                //' Add the message to the messages table
                objMess = new Messages();
                lngMesId = objMess.AddMessage(SessionId, ProjectId, MessageText, "FMG", 0);
                functionReturnValue = lngMesId;
                Logging.log.Info("Added message");
                
                //' Add the response to the responses table
                lngRespId = objResp.AddResponse(SessionId, ProjectId, ResponseTag, ResponseText, false, FolderId, ResponseType);
                if (lngRespId == 0) blnCreatingOk = false; 
                objResp = null;
                Logging.log.Info("Added response");
                
                if (blnCreatingOk) {
                    //' Update TopMesGroupId and TopRespId
                    objMess.UpdateMessageTopMesGroupAndResp(SessionId, ProjectId, lngMesId, lngMesId, lngRespId);
                    objMess = null;
                    Logging.log.Info("Updated TopMesGroupId and TopRespId");
                }
                
                if (blnCreatingOk)
                {
                    //' Add to the message groups table
                    objMesGroup = new MesGroups();
                    objMesGroup.AddMessageGroup(SessionId, ProjectId, lngMesId, lngRespId);
                    Logging.log.Info("Added message group");
                }
                
                if (blnCreatingOk)
                {
                    //' Add to the message group instances table
                    objMGI = new MesGroupInstances();
                    if (!objMGI.AddMessageGroupInstance(SessionId, ProjectId, lngMesId, lngMesId, true))
                    {
                        blnCreatingOk = false;
                    }

                    Logging.log.Info("Added message group instance");
                    objMGI = null;
                }
                
                if (blnCreatingOk & AddInstance)
                {
                    //' Add a matching user message
                    objMesGroup.AddUserMessageToGroup(SessionId, ProjectId, MessageText, lngMesId);
                    Logging.log.Info("Added matching user message");
                    objMesGroup = null;
                }
                
                // Commit transaction and release context object reference
                if (blnCreatingOk)
                {
                    Logging.log.Info("Transaction Complete");
                }
                else
                {
                    functionReturnValue = 0;
                    Logging.log.Info("Transaction Aborted");
                }
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return functionReturnValue;
        }

        public bool GetFrequentMessageGroupFromID(int SessionId, int ProjectId, int MesGroupId, ref string MessageText, ref string ResponseTag, ref string ResponseText, ref string FolderTag, ref int FolderId, ref int ResponseType, ref string CreatedBy, 
            ref int CreatedByUserId, ref string DateCreated, ref string EditedBy, ref string DateEdited, ref string ApprovedBy, ref string DateApproved)
        {
            // Returns the details of an FMG specified by MesGroupId
            // MessageText (String)
            // ResponseTag (String)
            // ResponseText (String)
            // FolderTag (String)
            // FolderId (Long)
            // Return value - false if the group could not be found
            // Declaration
                        
            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroupFromID");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MesGroupId:" + MesGroupId.ToString());
                
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                return helper.GetFrequentMessageGroupFromID(SessionId, ProjectId, MesGroupId, ref MessageText, ref ResponseTag, 
                    ref ResponseText, ref FolderTag, ref FolderId, ref ResponseType, ref CreatedBy, ref CreatedByUserId, 
                    ref DateCreated, ref EditedBy, ref DateEdited, ref ApprovedBy, ref DateApproved);
            }
            catch (Exception ex)
            {
                // Main code
                //' Get message group information given a message id
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool UpdateFrequentMessageGroup(int SessionId, int ProjectId, int MesGroupId, string MessageText, string ResponseTag, string ResponseText, int ResponseType)
        {
            bool functionReturnValue = false;
            // Updates all of the fields of an FMG identified by MesGroupId
            // all values must be specified and valid
            // Returns false if the FMG doesn't exist
            // Declaration
            
            Messages objMess = default(Messages);
            Responses objResp = default(Responses);
            int lngRespId = 0;
            MesGroups objMesGrp = default(MesGroups);

            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "UpdateFrequentMessageGroup");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MesGroupId:" + MesGroupId.ToString());
                Logging.log.Info("MessageText:" + MessageText.ToString());
                Logging.log.Info("ResponseTag:" + ResponseTag.ToString());
                Logging.log.Info("ResponseText:" + ResponseText.ToString());
                Logging.log.Info("ResponseType:" + ResponseType.ToString());
                
                // Main code
                // Could check that this is a FMG and the response is actually response
                // for this group
                //' Find the RespId
                int SimilarText = 0;
                SimilarText = 0;
                
                objResp = new Responses();
                SimilarText = objResp.LookForSameAnswerName(ProjectId, ResponseTag, MesGroupId, 0);
                
                if (SimilarText == 0)
                {
                    SimilarText = objResp.LookForSameQuestionText(ProjectId, MessageText, MesGroupId, 0);
                }
                
                if (SimilarText > 0)
                {
                    functionReturnValue = false;
                    return false;
                }
                
                functionReturnValue = true;
                lngRespId = GetRespID(MesGroupId);
                Logging.log.Info("Got response id (" + lngRespId + ")");
                
                if (lngRespId != 0)
                {
                    //' Try to update responses table
                    
                    functionReturnValue = objResp.UpdateResponse(SessionId, ProjectId, lngRespId, ResponseTag, ResponseText, ResponseType);
                    objResp = null;
                    if (!functionReturnValue)
                    {
                        Logging.log.Info("Unable to update response");
                    }
                    else
                    {
                        Logging.log.Info("Updated responses table");
                        //' Update data in messages table
                        objMess = new Messages();
                        objMess.UpdateMessageText(SessionId, ProjectId, MesGroupId, MessageText);
                        objMess = null;
                        Logging.log.Info("Updated messages table");
                        //'Update Message Group Table
                        objMesGrp = new MesGroups();
                        objMesGrp.UpdateEditInformation(SessionId, ProjectId, MesGroupId);
                        objMesGrp = null;
                        Logging.log.Info("Updated messages groups table");
                    }
                }
                
                Csr objCsr = default(Csr);
                objCsr = new Csr();
                
                bool IsApproveMQA = false;
                IsApproveMQA = objCsr.GetCsrApproveMqa(SessionId, ProjectId);
                
                //string strSQL = "";
                bool FMGExist = false;
                string FolderTag = "";
                int FolderId = 0;
                string CreatedBy = "";
                int CreatedByUserId = 0;
                string DateCreated = "";
                string EditedBy = "";
                string DateEdited = "";
                string ApprovedBy = "";
                string DateApproved = "";
                
                if (!IsApproveMQA)
                {
                    FMGExist = GetFrequentMessageGroupFromID(SessionId, ProjectId, MesGroupId, ref MessageText, ref ResponseTag, 
                        ref ResponseText, ref FolderTag, ref FolderId, ref ResponseType, ref CreatedBy, ref CreatedByUserId, 
                        ref DateCreated, ref EditedBy, ref DateEdited, ref ApprovedBy, ref DateApproved);
                    
                    if (FMGExist == true) //commented for test on 31 Aug 12 //uncommented on 3 Sep 12 //commented again
                    {
                        DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                        helper.UpdateFrequentMessageGroup(SessionId, ProjectId, MesGroupId, MessageText, ResponseTag, ResponseText, ResponseType, FolderId, lngRespId);
                    }
                }
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return functionReturnValue;
        }
        
        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs)
        {
            int publishStatus = 0;
            int folderId = 0;
            string dateCondition = "";
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus)
        {
            int folderId = 0;
            string dateCondition = "";
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId)
        {
            string dateCondition = "";
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition)
        {
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition, int createdBy)
        {
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy)
        {
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, int approvedBy)
        {
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,
            int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, int approvedBy, ViewType currentViewType)
        {
            // Returns a StdResults structure which is a count of the total number of
            // FMGs in the project and a recordset which represents the current
            // view of the total set given the view settings
            // Recordset consists of columns:
            // Freq - Number of instances in the group
            // MesGroupId - The MesGroupId of the group
            // also MessageText
            // and, if the following boolean inputs are true then the specified field
            // will also be returned
            // DispAnswer Then ResponseText
            // DispTag Then AnswerTag
            // Declaration

            // Error trapping begins
            try
            {
                // Log entry
                //Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups");
                //Logging.log.Info("SessionId:" + sessionId.ToString());
                //Logging.log.Info("ProjectId:" + projectId.ToString());
                ////Logging.log.Info("UserId:" + userId.ToString())
                //Logging.log.Info("Filter:" + filter_Renamed.ToString());
                //Logging.log.Info("Order:" + order.ToString());
                //Logging.log.Info("Dir:" + dir_Renamed.ToString());
                //Logging.log.Info("DispTag:" + dispTag.ToString());
                //Logging.log.Info("DispAnswer:" + dispAnswer.ToString());
                //Logging.log.Info("Page:" + intPage.ToString());
                //Logging.log.Info("PageSize:" + intPageSize.ToString());
                //Logging.log.Info("PublishStatus:" + publishStatus.ToString());
                //Logging.log.Info("FolderId:" + folderId.ToString());
                //Logging.log.Info("DateCondition:" + dateCondition.ToString());
                //Logging.log.Info("CreatedBy:" + createdBy.ToString());
                //Logging.log.Info("EditedBy:" + editedBy.ToString());
                //Logging.log.Info("ApprovedBy:" + approvedBy.ToString());
                //Logging.log.Info("Special:" + currentViewType.ToString());

                // Main code
                //' Get count and recordset and build StdResults with it
                // Remarked by CP on 2008-06-16 as it should be properly prased at the very Front-End
                // Since it is more flexible.
                //dateCondition = Trim(dateCondition)
                //If dateCondition <> "" Then
                //dateCondition = Right(dateCondition, Len(dateCondition) - 4)
                //dateCondition = Replace(dateCondition, "'", "''")
                //End If
                // End of remarked by CP on 2008-06-16

                //If page = 0 Then
                //page = 1
                //End If

                // Count = GetFrequentMessagesInFolderCount(SessionId, ProjectId, Filter_Renamed, DispTag, DispAnswer, PublishStatus, FolderId, DateCondition)

                //Dim helper As New Folders
                //Dim strFolderList As String = helper.ChkFolder_RetrieveAllFoldersForUser(projectId, userId)
                //helper = Nothing

                // Get User Type
                //Dim userHelper As New DataAccess.User
                //Dim userTypeText As String = userHelper.GetUserType(userId)
                //Dim currentUserType As Integer = GetUserLevelFromTypeText(userTypeText)

                //Dim strFolders As String = ""
                //If strFolderList <> "" And currentUserType < 3 Then
                //strFolders = Mid(strFolderList, 2)
                //End If

                Logging.log.Info("Built std results");
             

                return GetFrequentMessagesInFolderRecordset(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs,
                    publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
           
            return new Collection<FrequentMessage>();
        }

        //Added by Priya on Sep 29, 2011
        public int GetFrequentMessageGroupsMQA(int sessionId, int projectId, string filter,
          int order, int dir, int page, int pageSize, int dispTag, int dispAnswer, int publishStatus,
          int folderId = -1, string dateCondition = "", int createdBy = 0, int editedBy = 0, int approvedBy = 0, ViewType special = ViewType.LiveMqa, string strFolderList = "")
        {
           // Error trapping begins
            int fmgCount = 0;
            Collection<FrequentMessage> fmgCnt = new Collection<FrequentMessage>();
            try {
                // Log entry
                
                //Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups for Status: Knowledge Report");
                //Logging.log.Info("SessionId:" + sessionId.ToString());
                //Logging.log.Info("ProjectId:" + projectId.ToString());
                ////Logging.log.Info("UserId:" + userId.ToString())
                //Logging.log.Info("Filter:" + filter.ToString());
                //Logging.log.Info("Order:" + order.ToString());
                //Logging.log.Info("Dir:" + dir.ToString());
                //Logging.log.Info("DispTag:" + dispTag.ToString());
                //Logging.log.Info("DispAnswer:" + dispAnswer.ToString());
                //Logging.log.Info("Page:" + page.ToString());
                //Logging.log.Info("PageSize:" + pageSize.ToString());
                //Logging.log.Info("PublishStatus:" + publishStatus.ToString());
                //Logging.log.Info("FolderId:" + folderId.ToString());
                //Logging.log.Info("DateCondition:" + dateCondition.ToString());
                //Logging.log.Info("CreatedBy:" + createdBy.ToString());
                //Logging.log.Info("EditedBy:" + editedBy.ToString());
                //Logging.log.Info("ApprovedBy:" + approvedBy.ToString());
                //Logging.log.Info("Special:" + special.ToString());
                            
                //Logging.log.Info("Live/NonLive/Rejected Count");

                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                fmgCnt = helper.GetFrequentMessagesInFolderRecordsetMQA(sessionId, projectId, filter, order, dir, page, pageSize, dispTag, dispAnswer, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, special, strFolderList);
                fmgCount = fmgCnt.Count; 
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return fmgCount;
     
        }


        //Public Function GetFrequentMessageGroups_test(ByVal SessionId As Integer, ByVal ProjectId As Integer, ByVal Filter_Renamed As String, ByVal Order As Integer, ByVal Dir_Renamed As Integer, ByVal Page As Integer, ByVal PageSize As Integer, ByVal DispTag As Integer, ByVal DispAnswer As Integer, ByVal PublishStatus As Integer, Optional ByVal FolderId As Integer = -1, Optional ByVal DateCondition As String = "") As String
        //    ' Returns a StdResults structure which is a count of the total number of
        //    ' FMGs in the project and a recordset which represents the current
        //    ' view of the total set given the view settings
        //    ' Recordset consists of columns:
        //    ' Freq - Number of instances in the group
        //    ' MesGroupId - The MesGroupId of the group
        //    ' also MessageText
        //    ' and, if the following boolean inputs are true then the specified field
        //    ' will also be returned
        //    ' DispAnswer Then ResponseText
        //    ' DispTag Then AnswerTag
        //    ' Declaration
        
        
        //    Dim Count As Integer
        
        
        
        //    ' Error trapping begins
        //    Try
        
        //        ' Log entry
        //        Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups_test")
        //        Logging.log.Info("SessionId:" + SessionId.ToString())
        //        Logging.log.Info("ProjectId:" + ProjectId.ToString())
        //        Logging.log.Info("Filter:" + Filter_Renamed.ToString())
        //        Logging.log.Info("Order:" + Order.ToString())
        //        Logging.log.Info("Dir:" + Dir_Renamed.ToString())
        //        Logging.log.Info("Page:" + Page.ToString())
        //        Logging.log.Info("PageSize:" + PageSize.ToString())
        //        Logging.log.Info("DispTag:" + DispTag.ToString())
        //        Logging.log.Info("DispAnswer:" + DispAnswer.ToString())
        //        Logging.log.Info("FolderId:" + FolderId.ToString())
        //        ' Main code
        //        '' Get count and recordset and build StdResults with it
        //        DateCondition = Trim(DateCondition)
        //        If DateCondition <> "" Then
        //            DateCondition = Right(DateCondition, Len(DateCondition) - 4)
        //            DateCondition = Replace(DateCondition, "'", "''")
        //        End If
        
        //        Count = GetFrequentMessagesInFolderCount(SessionId, ProjectId, Filter_Renamed, DispTag, DispAnswer, PublishStatus, FolderId, DateCondition)
        
        //        If Count < PageSize Or Page = 0 Then
        //            Page = 1
        //        End If
        
        //        GetFrequentMessageGroups_test = GetFrequentMessagesInFolderRecordset_test(SessionId, ProjectId, Filter_Renamed, Order, Dir_Renamed, Page, PageSize, DispTag, DispAnswer, PublishStatus, FolderId, DateCondition)
        //        Logging.log.Info("Built std results")
        
        
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function
        
        public bool MoveFrequentMessageGroupToFolder(int SessionId, int ProjectId, int MesGroupId, int FolderId)
        {
            bool functionReturnValue = false;
            // Moves the FMG idenified by MesGroupId to the Folder identified by FolderId
            // Returns True if the folder could be moved, otherwise False
            
            Responses objResp = default(Responses);
            int lngRespId = 0;
            
            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "MoveFrequentMessageGroupToFolder");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MesGroupId:" + MesGroupId.ToString());
                Logging.log.Info("FolderId:" + FolderId.ToString());
                
                // Main code
                functionReturnValue = false;
                //' Find the RespId
                lngRespId = GetRespID(MesGroupId);
                
                //'Get Respid if unpublished
                if (lngRespId == 0) {
                    
                    DataAccess.Approval helper = new DataAccess.Approval();
                    lngRespId = helper.GetTopRespID(ProjectId, MesGroupId);
                }
                //strSQL = "SELECT TopRespId FROM Messages WHERE ProjectId = " & ProjectId & " AND TopMesGroupId = " & MesGroupId & " "
                //RS = AdoGetRecordset(strSQL)
                
                //If Not RS.EOF Then
                //    lngRespId = RS.Fields("TopRespId").Value
                //End If
                                
                Logging.log.Info("Got response id (" + lngRespId + ")");
                //If lngRespId <> 0 Then
                objResp = new Responses();
                functionReturnValue = objResp.MoveResponseToFolder(SessionId, ProjectId, lngRespId, FolderId);
                //objResp = Nothing
                Logging.log.Info("Moved the response");
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return functionReturnValue;
        }
        
        public string GetQuestionHistoryQuestionText(int MesId, string MessageText)
        {
            try
            {
                DataAccess.Messages helper = new DataAccess.Messages();
                return helper.GetQuestionHistoryQuestionText(MesId, MessageText);
            }
            catch
            {
            }

            return MessageText;
        }

        //Added by Priya on June 20, 2011
        //public string GetUsageActivityUsage(int MesId, string MessageText)
        //{
        //    try
        //    {
        //        DataAccess.Messages helper = new DataAccess.Messages();
        //        return helper.GetUsageActivityUsage(MesId, MessageText);
        //    }
        //    catch
        //    {
        //    }

        //    return MessageText;
        //}
        //end of addition

        //Public Function GetFolderTagFromId( _
        //'                ByVal SessionId As Long, _
        //'                ByVal ProjectId As Long, _
        //'                ByVal MesGroupId As Long) _
        //'                As String
        //' Returns the ResponseTag for an FMG identified by MesGroupId
        //' An empty string if the MesGroup can not be found
        //    Dim objContext As COMSVCSLib.ObjectContext
        //    
        //    Dim objResp As Aqua.dalResponses
        //    Dim lngRespId As Long
        //
        //' Context and logging creation
        //    Set objContext = GetObjectContext()
        //    Set ")
        //
        //' Error trapping begins
        //    On Error GoTo ErrorHandler
        //
        //' Log entry
        //    objLog.Entry "FrequentMessageGroups:"+ "GetFolderTagFromId"
        //    objLog.InParam "SessionId:"+ SessionId
        //    objLog.InParam "ProjectId:"+ ProjectId
        //    objLog.InParam "MesGroupId:"+ MesGroupId
        //
        //' Main code
        //    GetFolderTagFromId = ""
        // Find the RespId
        //    lngRespId = GetRespID(MesGroupId)
        //    objLog.Progress "Got response id (" & lngRespId & ")"
        //    If lngRespId <> 0 Then
        //        Set objResp = new Aqua.dalResponses")
        //        GetFolderTagFromId = objResp.GetResponseTagFromId(SessionId, ProjectId, lngRespId)
        //        Set objResp = Nothing
        //        objLog.Progress "Got the response tag"
        //    End If
        //
        //' Commit transaction and release context object reference
        //    objContext.SetComplete
        //    Set objContext = Nothing
        //
        //' Log exit and release logging object reference
        //    objLog.OutParam "RetVal:"+ GetFolderTagFromId
        //    objLog.Exit
        //    Set objLog = Nothing
        //' Exit
        //    Exit Function
        //' Error handler - abort transaction, cleanup, rethrow
        //ErrorHandler:
        //    objContext.SetAbort
        //    Set objResp = Nothing
        //    Set objContext = Nothing
        //    Set objLog = Nothing
        //    Rethrow "FrequentMessageGroups:"+ "GetFolderTagFromId"
        //End Function

        private string GetResponseCols(ref bool GetTag, ref bool GetAnswer, ref bool InSelect)
        {
            string functionReturnValue = null;
            functionReturnValue = "";
            if (GetTag) {
                functionReturnValue = functionReturnValue + ", RES.Name ";
            }
            if (GetAnswer) {
                functionReturnValue = functionReturnValue + ", CAST(RES.Text As nvarchar(3000))";
                if (InSelect) {
                    functionReturnValue = functionReturnValue + " As Text ";
                }
            }
            return functionReturnValue;
        }

        private string GetTextFilter(ref string Filter_Renamed, ref bool GetTag, ref bool GetAnswer)
        {
            string functionReturnValue = null;
            functionReturnValue = "";
            if (!string.IsNullOrEmpty(Filter_Renamed))
            {
                functionReturnValue = functionReturnValue + "AND (";
                functionReturnValue = functionReturnValue + "MES.MessageText LIKE " + General.FormatFilter(Filter_Renamed);
                
                if (GetTag)
                {
                    functionReturnValue = functionReturnValue + " OR RES.Name LIKE " + General.FormatFilter(Filter_Renamed);
                }

                if (GetAnswer)
                {
                    functionReturnValue = functionReturnValue + " OR RES.Text LIKE " + General.FormatFilter(Filter_Renamed);
                }

                functionReturnValue = functionReturnValue + " ) ";
            }
            return functionReturnValue;
        }

        private string GetFolderFilter(ref int FolderId)
        {
            string functionReturnValue = null;
            // Add a filter for top level or subfolders
            // Default is -1 i.e. get them all
            functionReturnValue = "";
            
            if (FolderId == 0)
            {
                // top level case
                functionReturnValue = functionReturnValue + "AND NOT EXISTS (SELECT ChildAnswerId FROM ResponseHierachy As REH " + "WHERE REH.ChildAnswerId = RES.RespId) ";
            }
            else if (FolderId > 0)
            {
                // subfolder case
                functionReturnValue = functionReturnValue + "AND EXISTS (SELECT ChildAnswerId FROM ResponseHierachy As REH " + "WHERE REH.ChildAnswerId = RES.RespId " + "AND REH.ParentAnswerId = " + FolderId + ") ";
            }

            return functionReturnValue;
        }

        //Private Function GetFrequentMessagesInFolderCount(ByVal SessionId As Integer, ByVal ProjectId As Integer, ByVal Filter_Renamed As String, ByVal DispTag As Integer, ByVal DispAnswer As Integer, ByVal PublishStatus As Integer, ByVal FolderId As Integer, Optional ByRef DateCondition As String = "") As Integer
        
        //    Dim strSQL As String
        
        //    'strSQL = "SELECT Count(*) As Val " & _
        //    ''         "FROM Responses As RES WITH (REPEATABLEREAD) " & _
        //    ''         "INNER JOIN MesGroups As MGS WITH (REPEATABLEREAD) ON MGS.RespId = RES.RespId " & _
        //    ''         "INNER JOIN Messages As MES WITH (REPEATABLEREAD) ON MES.MesId = MGS.MesGroupId " & _
        //    ''         "WHERE RES.ProjectId = " & ProjectId & " "
        
        //    'If DateCondition <> "" Then
        //    '    strSQL = strSQL & DateCondition
        //    'End If
        
        //    '    strSQL = strSQL & "AND MES.Status='FMG' " & _
        //    ''                        GetTextFilter(Filter, DispTag, DispAnswer)
        //    Try
        //        Dim FilterFormat As String
        
        //        FilterFormat = Replace(Filter_Renamed, "'", "''")
        
        //        strSQL = "EXEC MasterQAsWithFolders " & ProjectId & ", NULL, NULL, '" & DateCondition & "', " & DispTag & ", " & DispAnswer & ", '" & FilterFormat & "'" & ", NULL, NULL, " & PublishStatus & "," & FolderId & ", 1"
        
        //        GetFrequentMessagesInFolderCount = AdoGetSingleValueNeverEmpty(strSQL)
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function
    
        private Collection<FrequentMessage> GetFrequentMessagesInFolderRecordset(int sessionId, int projectId, 
            string filter_Renamed, int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, 
            ref int totalRecs, int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, 
            int approvedBy, ViewType currentViewType)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset
            int userID = 0;

            //' Get the CSRId
            Csr objCsr = new Csr();
            userID = objCsr.GetCsrID(sessionId, projectId);
            objCsr = null;
            Logging.log.Info("Got UserId");

            //dateCondition = dateCondition.Trim(); //this line commented to avoid error joining page size and date condition variable causing SQL error

            //if (dateCondition != "")
            //{
            //    //dateCondition = General.Right(dateCondition, dateCondition.Length - 4); - commented to avoid error: Invalid column name, on 5 July 2012
            //    dateCondition = dateCondition.Replace("'", "''");
            //}

            if (intPage == 0)
            {
                intPage = 1;
            }

            Folders folderHelper = new Folders();
            string folders = folderHelper.CheckFolderRetrieveAllFoldersForUser(projectId, userID);
            folderHelper = null;

            //Get User Type
            DataAccess.User userHelper = new DataAccess.User();
            string userTypeText = userHelper.GetUserType(userID);
            int currentUserType = Convert.ToInt32(General.GetUserLevelFromTypeText(userTypeText));

            string folderList = "";

            if (currentUserType < 3)
            {
                if (folders != "")
                {
                    folderList = General.Mid(folders, 2);
                }
                else
                {
                    if (folderId == -2)
                    {
                        folderList = "-1,0";
                    }
                    else
                    {
                        if ((int)currentViewType == 1)
                        {
                            folderList = "-1,0";
                        }
                    }
                }
            }

            Collection<FrequentMessage> freqMsgs = new Collection<FrequentMessage>();

            try
            {
 DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                
                freqMsgs = helper.GetFrequentMessagesInFolderRecordset(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs,
                publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType, folderList);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return freqMsgs;
        }
        
        //Private Function GetRespID(ByVal MesGroupId As Object) As Integer
        //    ' Gets the response id corresponding to the MesGroupId
        //    ' 0 is returned if the MesGroupId does not exist
        //    Dim strSQL As String
        //    Try
        //        strSQL = "SELECT RespId As Val FROM MesGroups WHERE MesGroupId=" & MesGroupId
        //        GetRespID = AdoGetSingleValueWithDefault(strSQL, 0)
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function

        //Public Function IsPublished(ByVal MesId As Integer) As Boolean
        //    Dim strSQL As String
        //    Dim mqaresRS As ADODB.Recordset
        //    Try
        //        strSQL = "SELECT RespId FROM MasterQAResponse WHERE MesGroupId = " & MesId
        //        mqaresRS = AdoGetRecordset(strSQL)

        //        If mqaresRS.EOF Or mqaresRS.EOF Then
        //            IsPublished = True
        //        Else
        //            IsPublished = False
        //        End If
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function

        public void Publish(int MesId)
        {
            // Updates all of the fields of an FMG identified by MesGroupId
            // all values must be specified and valid
            // Returns false if the FMG doesn't exist
            // Declaration

            string pStatus = null;
            pStatus = "P";

            // Error trapping begins
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                helper.Publish(MesId, pStatus);
            }
            catch (Exception ex)
            {

                HandleException("App Layer Error:", ex);
            }
        }

        public void Unpublish(int MesId)
        {
            // Declaration
            string pStatus = null;
            pStatus = "P";
            
            // Error trapping begins
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                helper.UnPublish(MesId, pStatus);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
        }

        public bool CheckExpiryDate(int lngMessageId)
        {
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                return helper.CheckExpiryDate(lngMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public string CheckExpiryStatusPublished(int lngMesId)
        {
            ViewType currentViewType = ViewType.LiveMqa;
            return CheckExpiryStatusPublished(lngMesId, currentViewType);
        }

        public string CheckExpiryStatusPublished(int lngMesId, ViewType currentViewType)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            return helper.CheckExpiryStatusPublished(lngMesId, currentViewType);
        }

        public string CheckExpiryStatusExpired(int lngMesId)
        {
            ViewType currentViewType = ViewType.LiveMqa;
            return CheckExpiryStatusExpired(lngMesId, currentViewType);
        }

        public string CheckExpiryStatusExpired(int lngMesId, ViewType currentViewType)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            return helper.CheckExpiryStatusExpired(lngMesId, currentViewType);
        }

        public string CheckInternalStatus(int lngMesId)
        {   
            ViewType currentViewType = ViewType.LiveMqa;
            return CheckInternalStatus(lngMesId, currentViewType);
        }

        public string CheckInternalStatus(int lngMesId, ViewType currentViewType)
        {   
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            return helper.CheckInternalStatus(lngMesId, currentViewType);
        }
        
        public Collection<QuestionHistory> QuestionHistory(int SessionId, int ProjectId, string Filter, int Order, int Dir_Renamed, string DateCondition, string SQLFaces)
        {                      
            Collection<QuestionHistory> questions = new Collection<QuestionHistory>();
            try {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();                
                questions = helper.QuestionHistory(SessionId, ProjectId, Filter, Order, Dir_Renamed, DateCondition, SQLFaces);
            }
            catch (Exception ex) {
                HandleException("App Layer Error:", ex);
            }
            return questions;
        }

        public int QuestionHistoryCount(int SessionId, int ProjectId, int Page, int PageSize, string Filter, int Order, int Dir_Renamed, string DateCondition, string SQLFaces)
        {
            int questionscount = 0;
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                questionscount = helper.QuestionHistoryCount(SessionId, ProjectId, Page, PageSize, Filter, Order, Dir_Renamed, DateCondition, SQLFaces);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return questionscount;
        }

        public Collection<QuestionHistory> QuestionHistory(int SessionId, int ProjectId, int Page, int PageSize, string Filter, int Order, int Dir_Renamed, string DateCondition, string SQLFaces)
        {
            Collection<QuestionHistory> questions = new Collection<QuestionHistory>();
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                questions = helper.QuestionHistory(SessionId, ProjectId, Page, PageSize, Filter, Order, Dir_Renamed, DateCondition, SQLFaces);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return questions;
        }

        public Collection<QuestionClickedHistory> QuestionClickedHistory(string DateCondition)
        {
            Collection<QuestionClickedHistory> questions = new Collection<QuestionClickedHistory>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                questions = helper.QuestionClickedHistory(DateCondition);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return questions;
        }

        //Added by Priya on June 20, 2011
        //updated on 8 Oct 12 to match v7.0 
        public Collection<UsageActivity> UsageActivity(int SessionId, int ProjectId, string Period, string StartDate, string EndDate, int src)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset

            Collection<UsageActivity> usage = new Collection<UsageActivity>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();


                usage = helper.UsageActivity(SessionId, ProjectId, Period, StartDate, EndDate, src);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return usage;
        }


        //Added by Priya on July 11, 2011
        public Collection<AnalysisActivity> AnalysisActivity(int SessionId, int ProjectId, string Period, DateTime StartDate, DateTime EndDate)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset

            Collection<AnalysisActivity> analysis = new Collection<AnalysisActivity>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();


                analysis = helper.AnalysisActivity(SessionId, ProjectId, Period, StartDate, EndDate);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return analysis;
        }


        //Added by Priya on July 14, 2011
        public Collection<AfterHours> AfterHours(int SessionId, int ProjectId, string Period, DateTime StartDate, DateTime EndDate)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset

            Collection<AfterHours> hours = new Collection<AfterHours>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();


                hours  = helper.AfterHours(SessionId, ProjectId, Period, StartDate, EndDate);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return hours;
        }


        public int GetRespID(int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetRespID(lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        //Added by Priya on Sep 28, 2011
        public int GetKnowledgeDraftCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeDraftCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeApprovalCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeApprovalCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeDeletedCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeDeletedCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeInternalCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeInternalCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeHighlightedCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeHighlightedCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }
        //end of addition by Priya on Sep 28, 2011
        
        public bool UpdateMesApproval(int lngNewMessageId, int published, int pRespId, int lngApprovalId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateMesApproval(lngNewMessageId, published, pRespId, lngApprovalId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);

                return false;
            }
        }
        
        public bool UpdateMesGroupsRespID(int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            
            try
            {
                return helper.UpdateMesGroupsRespID(lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public bool AddMqaTrack(int lngNewMessageId, string strMessageTextFormat, string strResponseTextFormat, string strResponseTextNotesFormat, string strResponseTagFormat, bool blnPub, bool blnInt, bool blnExpiryDate, System.DateTime DtStartDate, System.DateTime DtEndDate, 
        bool blnReminder, string strAlertTo, int intBefEndDate, int intReminderFreq, string FolderPath, string ActionDone, int lngCsrId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            
            try
            {
                return helper.AddMqaTrack(lngNewMessageId, strMessageTextFormat, strResponseTextFormat, strResponseTextNotesFormat, strResponseTagFormat, blnPub, blnInt, blnExpiryDate, DtStartDate, DtEndDate, 
                blnReminder, strAlertTo, intBefEndDate, intReminderFreq, FolderPath, ActionDone, lngCsrId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public int GetTopRespID(int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetTopRespID(lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public bool UpdateMessageInternalMqa(int lngNewMessageId, int lngProjectId, int IntMQA)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateMessageInternalMqa(lngNewMessageId, lngProjectId, IntMQA);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool UpdateMesGroupApproved(int lngCsrId, int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateMesGroupApproved(lngCsrId, lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool SetResponseNotes(int RespId, int lngProjectId, string strResponseText, string strResponseTextNotes)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try 
            {
                return helper.SetResponseNotes(RespId, lngProjectId, strResponseText, strResponseTextNotes);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public bool InsertExpiryDate(int lngMesId, string strExpiryDate, string strStartDate, string strEndDate, string strReminder, string strAlertTo, int intBefEndDate, int intReminderFreq)
        {
            int intExpiryDate = 0;
            int intReminder = 0;
            int intReminderCount = 0;
            int intCurReminder = 0;
            
            intCurReminder = 0;
            
            if (strExpiryDate.ToLower() == "true")
            {
                intExpiryDate = 1;
            }
            else
            {
                intExpiryDate = 0;
            }
            
            if (strReminder.ToLower() == "true")
            {
                intReminder = 1;
            }
            else
            {
                intReminder = 0;
            }
            
            if (intReminderFreq > 0)
            {
                intReminderCount = (24 / intReminderFreq);

                if (intReminderCount < 0)
                {
                    intReminderCount = 1;
                }
            }
            else
            {
                if (!string.IsNullOrEmpty(strAlertTo))
                {
                    intReminderCount = 1;
                }
                else
                {
                    intReminderCount = 0;
                }
            }
            
            if (!string.IsNullOrEmpty(strStartDate) | !string.IsNullOrEmpty(strEndDate))
            {
                //strSQL = "INSERT INTO ExpiryDate ( " & _
                //      " MesId, ExpiryDate, StartDate, EndDate, " &_
                //      " Reminder, AlertTo, DaysBeforeEndDate, ReminderFreq, DateCreated, " &_
                //      " ReminderCount, CurReminder ) " &_
                //      " VALUES ( "&lngMesId&", "&intExpiryDate&", '"&strStartDate&"', '"&strEndDate&"', " &_
                //      " "&intReminder&", '"&strAlertTo&"', "&intBefEndDate&", "&intReminderFreq&"," &_
                //      " '"&now&"' , "&intReminderCount&", "&intCurReminder&" ) "
                
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

                try
                {
                    return helper.InsertExpiryDate(lngMesId, Convert.ToString(intExpiryDate), strStartDate, strEndDate, Convert.ToString(intReminder), Convert.ToString(strAlertTo), intBefEndDate, intReminderFreq, intReminderCount, intCurReminder);
                }
                catch (Exception ex)
                {
                    //response.write "<br>" & strSQL
                    //response.end
                    
                    //objConn.Execute(strSQL)
                    HandleException("App Layer Error:", ex);
                }
            }

            return false;
        }
        
        public bool UpdateExpiryDate(int lngMesId, string strExpiryDate, string strStartDate, string strEndDate, string strReminder, string strAlertTo, int intBefEndDate, int intReminderFreq)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateExpiryDate(lngMesId, strExpiryDate, strStartDate, strEndDate, strReminder, strAlertTo, intBefEndDate, intReminderFreq);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool DeleteExpiryDate(int lngMesId, string strModule)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.DeleteExpiryDate(lngMesId, strModule);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public int GetMasterQaRespID(int pMesId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetMasterQaRespID(pMesId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }
        
        public bool DeleteMasterQaResponses(int pMesId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.DeleteMasterQaResponses(pMesId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public string GetResponseNotes(int TRespId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            try {
                return helper.GetResponseNotes(TRespId);
            }
            catch (Exception ex) {
                HandleException("App Layer Error:", ex);
            }
            return "";
        }
        
        
        public int GetPublishedCount(int MesId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetPublishedCount(MesId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public string GetSourceOfRejectedQuestion(int mesID)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetSourceOfRejectedQuestion(mesID);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return "";
        }

        public void HandleException(string message, Exception ex)
        {
            LogicException wrap = new LogicException(message, ex);
            bool rethrow = ExceptionPolicy.HandleException(wrap, "Application Layer Policy");

            if (rethrow)
            {
                throw wrap;
            }
        }
       
    }
}

Changed text

Open file

using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using Microsoft.Practices.EnterpriseLibrary.ExceptionHandling;
using Agathos.FlexAnswer.BL.BusinessClasses;
using Agathos.FlexAnswer.BL.BusinessClasses.Collections;
using Agathos.FlexAnswer.BL.Interfaces;
using Agathos.FlexAnswer.BL.Logic.Exceptions;
using Agathos.FlexAnswer.BL.Logic.Utils;

namespace Agathos.FlexAnswer.BL.Logic
{
    public class FrequentMessageGroups : IFrequentMessageGroups
    {
        // Class: Frequent Message Groups (FMG) - Wraps the logical entity of Frequent
        // Message Groups
        // The Frequent Message Groups are groups of messages which are logically
        // similar, and therefore have the same response
        // An FMG consists of:
        // MessageText - a typical message summarising all the messages within the group
        // ResponseTag - a convient reference to a response
        // ResponseText - the full text of a response
        // Folder - an FMG sits somewhere inside a folder hierarchy
        
        // Internals:
        // Internally an FMG is split across a number of tables:  MesGroups being the
        // primary one, but also MesGroupInstances, Messages and Responses
        
        public int AddFrequentMessageGroup(int SessionId, int ProjectId, string MessageText, string ResponseTag, string ResponseText, int ResponseType, int FolderId, bool AddInstance, int ApprovalId)
        {
            int functionReturnValue = 0;
            // Adds a new FMG to the project optionally places it in a folder specified by
            // FolderId (defaults to top level folder, and will also put it in the top level
            // folder if the FolderId is not valid)
            // Returns a Long, which is the MesGroupId of the new FMG
            // Also adds an instance with text of MessageText and trains the response
            // server on this new instance
            // Declaration
            
            Messages objMess = default(Messages);
            int lngMesId = 0;
            Responses objResp = default(Responses);
            MesGroups objMesGroup = new MesGroups();
            MesGroupInstances objMGI = default(MesGroupInstances);
            bool blnCreatingOk = false;
            int lngRespId = 0;
            
            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "AddFrequentMessageGroup");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MessageText:" + MessageText.ToString());
                Logging.log.Info("ResponseTag:" + ResponseTag.ToString());
                Logging.log.Info("ResponseText:" + ResponseText.ToString());
                Logging.log.Info("ResponseType:" + ResponseType.ToString());
                Logging.log.Info("FolderId:" + FolderId.ToString());
                Logging.log.Info("AddInstance:" + AddInstance.ToString());
                
                // Main code
                blnCreatingOk = true;
                //' Check that the folder exists
                objResp = new Responses();
                
                if (!objResp.FolderExists(SessionId, ProjectId, FolderId))
                {
                    FolderId = 0;
                }
                
                functionReturnValue = objResp.LookForSameAnswerName(ProjectId, ResponseTag, 0, ApprovalId);
                
                if (functionReturnValue == 0)
                {
                    functionReturnValue = objResp.LookForSameQuestionText(ProjectId, MessageText, 0, ApprovalId);
                }
                
                if (functionReturnValue > 0)
                {
                    functionReturnValue = 0;

                    return functionReturnValue;
                }
                
                //' Add the message to the messages table
                objMess = new Messages();
                lngMesId = objMess.AddMessage(SessionId, ProjectId, MessageText, "FMG", 0);
                functionReturnValue = lngMesId;
                Logging.log.Info("Added message");
                
                //' Add the response to the responses table
                lngRespId = objResp.AddResponse(SessionId, ProjectId, ResponseTag, ResponseText, false, FolderId, ResponseType);
                if (lngRespId == 0) blnCreatingOk = false; 
                objResp = null;
                Logging.log.Info("Added response");
                
                if (blnCreatingOk) {
                    //' Update TopMesGroupId and TopRespId
                    objMess.UpdateMessageTopMesGroupAndResp(SessionId, ProjectId, lngMesId, lngMesId, lngRespId);
                    objMess = null;
                    Logging.log.Info("Updated TopMesGroupId and TopRespId");
                }
                
                if (blnCreatingOk)
                {
                    //' Add to the message groups table
                    objMesGroup = new MesGroups();
                    objMesGroup.AddMessageGroup(SessionId, ProjectId, lngMesId, lngRespId);
                    Logging.log.Info("Added message group");
                }
                
                if (blnCreatingOk)
                {
                    //' Add to the message group instances table
                    objMGI = new MesGroupInstances();
                    if (!objMGI.AddMessageGroupInstance(SessionId, ProjectId, lngMesId, lngMesId, true))
                    {
                        blnCreatingOk = false;
                    }

                    Logging.log.Info("Added message group instance");
                    objMGI = null;
                }
                
                if (blnCreatingOk & AddInstance)
                {
                    //' Add a matching user message
                    objMesGroup.AddUserMessageToGroup(SessionId, ProjectId, MessageText, lngMesId);
                    Logging.log.Info("Added matching user message");
                    objMesGroup = null;
                }
                
                // Commit transaction and release context object reference
                if (blnCreatingOk)
                {
                    Logging.log.Info("Transaction Complete");
                }
                else
                {
                    functionReturnValue = 0;
                    Logging.log.Info("Transaction Aborted");
                }
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return functionReturnValue;
        }

        public bool GetFrequentMessageGroupFromID(int SessionId, int ProjectId, int MesGroupId, ref string MessageText, ref string ResponseTag, ref string ResponseText, ref string FolderTag, ref int FolderId, ref int ResponseType, ref string CreatedBy, 
            ref int CreatedByUserId, ref string DateCreated, ref string EditedBy, ref string DateEdited, ref string ApprovedBy, ref string DateApproved)
        {
            // Returns the details of an FMG specified by MesGroupId
            // MessageText (String)
            // ResponseTag (String)
            // ResponseText (String)
            // FolderTag (String)
            // FolderId (Long)
            // Return value - false if the group could not be found
            // Declaration
                        
            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroupFromID");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MesGroupId:" + MesGroupId.ToString());
                
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                return helper.GetFrequentMessageGroupFromID(SessionId, ProjectId, MesGroupId, ref MessageText, ref ResponseTag, 
                    ref ResponseText, ref FolderTag, ref FolderId, ref ResponseType, ref CreatedBy, ref CreatedByUserId, 
                    ref DateCreated, ref EditedBy, ref DateEdited, ref ApprovedBy, ref DateApproved);
            }
            catch (Exception ex)
            {
                // Main code
                //' Get message group information given a message id
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool UpdateFrequentMessageGroup(int SessionId, int ProjectId, int MesGroupId, string MessageText, string ResponseTag, string ResponseText, int ResponseType)
        {
            bool functionReturnValue = false;
            // Updates all of the fields of an FMG identified by MesGroupId
            // all values must be specified and valid
            // Returns false if the FMG doesn't exist
            // Declaration
            
            Messages objMess = default(Messages);
            Responses objResp = default(Responses);
            int lngRespId = 0;
            MesGroups objMesGrp = default(MesGroups);

            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "UpdateFrequentMessageGroup");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MesGroupId:" + MesGroupId.ToString());
                Logging.log.Info("MessageText:" + MessageText.ToString());
                Logging.log.Info("ResponseTag:" + ResponseTag.ToString());
                Logging.log.Info("ResponseText:" + ResponseText.ToString());
                Logging.log.Info("ResponseType:" + ResponseType.ToString());
                
                // Main code
                // Could check that this is a FMG and the response is actually response
                // for this group
                //' Find the RespId
                int SimilarText = 0;
                SimilarText = 0;
                
                objResp = new Responses();
                SimilarText = objResp.LookForSameAnswerName(ProjectId, ResponseTag, MesGroupId, 0);
                
                if (SimilarText == 0)
                {
                    SimilarText = objResp.LookForSameQuestionText(ProjectId, MessageText, MesGroupId, 0);
                }
                
                if (SimilarText > 0)
                {
                    functionReturnValue = false;
                    return false;
                }
                
                functionReturnValue = true;
                lngRespId = GetRespID(MesGroupId);
                Logging.log.Info("Got response id (" + lngRespId + ")");
                
                if (lngRespId != 0)
                {
                    //' Try to update responses table
                    
                    functionReturnValue = objResp.UpdateResponse(SessionId, ProjectId, lngRespId, ResponseTag, ResponseText, ResponseType);
                    objResp = null;
                    if (!functionReturnValue)
                    {
                        Logging.log.Info("Unable to update response");
                    }
                    else
                    {
                        Logging.log.Info("Updated responses table");
                        //' Update data in messages table
                        objMess = new Messages();
                        objMess.UpdateMessageText(SessionId, ProjectId, MesGroupId, MessageText);
                        objMess = null;
                        Logging.log.Info("Updated messages table");
                        //'Update Message Group Table
                        objMesGrp = new MesGroups();
                        objMesGrp.UpdateEditInformation(SessionId, ProjectId, MesGroupId);
                        objMesGrp = null;
                        Logging.log.Info("Updated messages groups table");
                    }
                }
                
                Csr objCsr = default(Csr);
                objCsr = new Csr();
                
                bool IsApproveMQA = false;
                IsApproveMQA = objCsr.GetCsrApproveMqa(SessionId, ProjectId);
                
                //string strSQL = "";
                bool FMGExist = false;
                string FolderTag = "";
                int FolderId = 0;
                string CreatedBy = "";
                int CreatedByUserId = 0;
                string DateCreated = "";
                string EditedBy = "";
                string DateEdited = "";
                string ApprovedBy = "";
                string DateApproved = "";
                
                if (!IsApproveMQA)
                {
                    FMGExist = GetFrequentMessageGroupFromID(SessionId, ProjectId, MesGroupId, ref MessageText, ref ResponseTag, 
                        ref ResponseText, ref FolderTag, ref FolderId, ref ResponseType, ref CreatedBy, ref CreatedByUserId, 
                        ref DateCreated, ref EditedBy, ref DateEdited, ref ApprovedBy, ref DateApproved);
                    
                    if (FMGExist == true) //commented for test on 31 Aug 12 //uncommented on 3 Sep 12 //commented again
                    {
                        DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                        helper.UpdateFrequentMessageGroup(SessionId, ProjectId, MesGroupId, MessageText, ResponseTag, ResponseText, ResponseType, FolderId, lngRespId);
                    }
                }
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return functionReturnValue;
        }
        
        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs)
        {
            int publishStatus = 0;
            int folderId = 0;
            string dateCondition = "";
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus)
        {
            int folderId = 0;
            string dateCondition = "";
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId)
        {
            string dateCondition = "";
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition)
        {
            int createdBy = 0;
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition, int createdBy)
        {
            int editedBy = 0;
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy)
        {
            int approvedBy = 0;
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed, 
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs, 
            int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, int approvedBy)
        {
            ViewType currentViewType = ViewType.LiveMqa;

            return GetFrequentMessageGroups(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
        }

        public Collection<FrequentMessage> GetFrequentMessageGroups(int sessionId, int projectId, string filter_Renamed,
            int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, ref int totalRecs,
            int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, int approvedBy, ViewType currentViewType)
        {
            // Returns a StdResults structure which is a count of the total number of
            // FMGs in the project and a recordset which represents the current
            // view of the total set given the view settings
            // Recordset consists of columns:
            // Freq - Number of instances in the group
            // MesGroupId - The MesGroupId of the group
            // also MessageText
            // and, if the following boolean inputs are true then the specified field
            // will also be returned
            // DispAnswer Then ResponseText
            // DispTag Then AnswerTag
            // Declaration

            // Error trapping begins
            try
            {
                // Log entry
                //Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups");
                //Logging.log.Info("SessionId:" + sessionId.ToString());
                //Logging.log.Info("ProjectId:" + projectId.ToString());
                ////Logging.log.Info("UserId:" + userId.ToString())
                //Logging.log.Info("Filter:" + filter_Renamed.ToString());
                //Logging.log.Info("Order:" + order.ToString());
                //Logging.log.Info("Dir:" + dir_Renamed.ToString());
                //Logging.log.Info("DispTag:" + dispTag.ToString());
                //Logging.log.Info("DispAnswer:" + dispAnswer.ToString());
                //Logging.log.Info("Page:" + intPage.ToString());
                //Logging.log.Info("PageSize:" + intPageSize.ToString());
                //Logging.log.Info("PublishStatus:" + publishStatus.ToString());
                //Logging.log.Info("FolderId:" + folderId.ToString());
                //Logging.log.Info("DateCondition:" + dateCondition.ToString());
                //Logging.log.Info("CreatedBy:" + createdBy.ToString());
                //Logging.log.Info("EditedBy:" + editedBy.ToString());
                //Logging.log.Info("ApprovedBy:" + approvedBy.ToString());
                //Logging.log.Info("Special:" + currentViewType.ToString());

                // Main code
                //' Get count and recordset and build StdResults with it
                // Remarked by CP on 2008-06-16 as it should be properly prased at the very Front-End
                // Since it is more flexible.
                //dateCondition = Trim(dateCondition)
                //If dateCondition <> "" Then
                //dateCondition = Right(dateCondition, Len(dateCondition) - 4)
                //dateCondition = Replace(dateCondition, "'", "''")
                //End If
                // End of remarked by CP on 2008-06-16

                //If page = 0 Then
                //page = 1
                //End If

                // Count = GetFrequentMessagesInFolderCount(SessionId, ProjectId, Filter_Renamed, DispTag, DispAnswer, PublishStatus, FolderId, DateCondition)

                //Dim helper As New Folders
                //Dim strFolderList As String = helper.ChkFolder_RetrieveAllFoldersForUser(projectId, userId)
                //helper = Nothing

                // Get User Type
                //Dim userHelper As New DataAccess.User
                //Dim userTypeText As String = userHelper.GetUserType(userId)
                //Dim currentUserType As Integer = GetUserLevelFromTypeText(userTypeText)

                //Dim strFolders As String = ""
                //If strFolderList <> "" And currentUserType < 3 Then
                //strFolders = Mid(strFolderList, 2)
                //End If

                Logging.log.Info("Built std results");
             

                return GetFrequentMessagesInFolderRecordset(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs,
                    publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
           
            return new Collection<FrequentMessage>();
        }

        //Added by Priya on Sep 29, 2011
        public int GetFrequentMessageGroupsMQA(int sessionId, int projectId, string filter,
          int order, int dir, int page, int pageSize, int dispTag, int dispAnswer, int publishStatus,
          int folderId = -1, string dateCondition = "", int createdBy = 0, int editedBy = 0, int approvedBy = 0, ViewType special = ViewType.LiveMqa, string strFolderList = "")
        {
           // Error trapping begins
            int fmgCount = 0;
            Collection<FrequentMessage> fmgCnt = new Collection<FrequentMessage>();
            try {
                // Log entry
                
                //Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups for Status: Knowledge Report");
                //Logging.log.Info("SessionId:" + sessionId.ToString());
                //Logging.log.Info("ProjectId:" + projectId.ToString());
                ////Logging.log.Info("UserId:" + userId.ToString())
                //Logging.log.Info("Filter:" + filter.ToString());
                //Logging.log.Info("Order:" + order.ToString());
                //Logging.log.Info("Dir:" + dir.ToString());
                //Logging.log.Info("DispTag:" + dispTag.ToString());
                //Logging.log.Info("DispAnswer:" + dispAnswer.ToString());
                //Logging.log.Info("Page:" + page.ToString());
                //Logging.log.Info("PageSize:" + pageSize.ToString());
                //Logging.log.Info("PublishStatus:" + publishStatus.ToString());
                //Logging.log.Info("FolderId:" + folderId.ToString());
                //Logging.log.Info("DateCondition:" + dateCondition.ToString());
                //Logging.log.Info("CreatedBy:" + createdBy.ToString());
                //Logging.log.Info("EditedBy:" + editedBy.ToString());
                //Logging.log.Info("ApprovedBy:" + approvedBy.ToString());
                //Logging.log.Info("Special:" + special.ToString());
                            
                //Logging.log.Info("Live/NonLive/Rejected Count");

                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                fmgCnt = helper.GetFrequentMessagesInFolderRecordsetMQA(sessionId, projectId, filter, order, dir, page, pageSize, dispTag, dispAnswer, publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, special, strFolderList);
                fmgCount = fmgCnt.Count; 
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return fmgCount;
     
        }


        //Public Function GetFrequentMessageGroups_test(ByVal SessionId As Integer, ByVal ProjectId As Integer, ByVal Filter_Renamed As String, ByVal Order As Integer, ByVal Dir_Renamed As Integer, ByVal Page As Integer, ByVal PageSize As Integer, ByVal DispTag As Integer, ByVal DispAnswer As Integer, ByVal PublishStatus As Integer, Optional ByVal FolderId As Integer = -1, Optional ByVal DateCondition As String = "") As String
        //    ' Returns a StdResults structure which is a count of the total number of
        //    ' FMGs in the project and a recordset which represents the current
        //    ' view of the total set given the view settings
        //    ' Recordset consists of columns:
        //    ' Freq - Number of instances in the group
        //    ' MesGroupId - The MesGroupId of the group
        //    ' also MessageText
        //    ' and, if the following boolean inputs are true then the specified field
        //    ' will also be returned
        //    ' DispAnswer Then ResponseText
        //    ' DispTag Then AnswerTag
        //    ' Declaration
        
        
        //    Dim Count As Integer
        
        
        
        //    ' Error trapping begins
        //    Try
        
        //        ' Log entry
        //        Logging.log.Info("FrequentMessageGroups:" + "GetFrequentMessageGroups_test")
        //        Logging.log.Info("SessionId:" + SessionId.ToString())
        //        Logging.log.Info("ProjectId:" + ProjectId.ToString())
        //        Logging.log.Info("Filter:" + Filter_Renamed.ToString())
        //        Logging.log.Info("Order:" + Order.ToString())
        //        Logging.log.Info("Dir:" + Dir_Renamed.ToString())
        //        Logging.log.Info("Page:" + Page.ToString())
        //        Logging.log.Info("PageSize:" + PageSize.ToString())
        //        Logging.log.Info("DispTag:" + DispTag.ToString())
        //        Logging.log.Info("DispAnswer:" + DispAnswer.ToString())
        //        Logging.log.Info("FolderId:" + FolderId.ToString())
        //        ' Main code
        //        '' Get count and recordset and build StdResults with it
        //        DateCondition = Trim(DateCondition)
        //        If DateCondition <> "" Then
        //            DateCondition = Right(DateCondition, Len(DateCondition) - 4)
        //            DateCondition = Replace(DateCondition, "'", "''")
        //        End If
        
        //        Count = GetFrequentMessagesInFolderCount(SessionId, ProjectId, Filter_Renamed, DispTag, DispAnswer, PublishStatus, FolderId, DateCondition)
        
        //        If Count < PageSize Or Page = 0 Then
        //            Page = 1
        //        End If
        
        //        GetFrequentMessageGroups_test = GetFrequentMessagesInFolderRecordset_test(SessionId, ProjectId, Filter_Renamed, Order, Dir_Renamed, Page, PageSize, DispTag, DispAnswer, PublishStatus, FolderId, DateCondition)
        //        Logging.log.Info("Built std results")
        
        
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function
        
        public bool MoveFrequentMessageGroupToFolder(int SessionId, int ProjectId, int MesGroupId, int FolderId)
        {
            bool functionReturnValue = false;
            // Moves the FMG idenified by MesGroupId to the Folder identified by FolderId
            // Returns True if the folder could be moved, otherwise False
            
            Responses objResp = default(Responses);
            int lngRespId = 0;
            
            // Error trapping begins
            try
            {
                // Log entry
                Logging.log.Info("FrequentMessageGroups:" + "MoveFrequentMessageGroupToFolder");
                Logging.log.Info("SessionId:" + SessionId.ToString());
                Logging.log.Info("ProjectId:" + ProjectId.ToString());
                Logging.log.Info("MesGroupId:" + MesGroupId.ToString());
                Logging.log.Info("FolderId:" + FolderId.ToString());
                
                // Main code
                functionReturnValue = false;
                //' Find the RespId
                lngRespId = GetRespID(MesGroupId);
                
                //'Get Respid if unpublished
                if (lngRespId == 0) {
                    
                    DataAccess.Approval helper = new DataAccess.Approval();
                    lngRespId = helper.GetTopRespID(ProjectId, MesGroupId);
                }
                //strSQL = "SELECT TopRespId FROM Messages WHERE ProjectId = " & ProjectId & " AND TopMesGroupId = " & MesGroupId & " "
                //RS = AdoGetRecordset(strSQL)
                
                //If Not RS.EOF Then
                //    lngRespId = RS.Fields("TopRespId").Value
                //End If
                                
                Logging.log.Info("Got response id (" + lngRespId + ")");
                //If lngRespId <> 0 Then
                objResp = new Responses();
                functionReturnValue = objResp.MoveResponseToFolder(SessionId, ProjectId, lngRespId, FolderId);
                //objResp = Nothing
                Logging.log.Info("Moved the response");
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return functionReturnValue;
        }
        
        public string GetQuestionHistoryQuestionText(int MesId, string MessageText)
        {
            try
            {
                DataAccess.Messages helper = new DataAccess.Messages();
                return helper.GetQuestionHistoryQuestionText(MesId, MessageText);
            }
            catch
            {
            }

            return MessageText;
        }

        //Added by Priya on June 20, 2011
        //public string GetUsageActivityUsage(int MesId, string MessageText)
        //{
        //    try
        //    {
        //        DataAccess.Messages helper = new DataAccess.Messages();
        //        return helper.GetUsageActivityUsage(MesId, MessageText);
        //    }
        //    catch
        //    {
        //    }

        //    return MessageText;
        //}
        //end of addition

        //Public Function GetFolderTagFromId( _
        //'                ByVal SessionId As Long, _
        //'                ByVal ProjectId As Long, _
        //'                ByVal MesGroupId As Long) _
        //'                As String
        //' Returns the ResponseTag for an FMG identified by MesGroupId
        //' An empty string if the MesGroup can not be found
        //    Dim objContext As COMSVCSLib.ObjectContext
        //    
        //    Dim objResp As Aqua.dalResponses
        //    Dim lngRespId As Long
        //
        //' Context and logging creation
        //    Set objContext = GetObjectContext()
        //    Set ")
        //
        //' Error trapping begins
        //    On Error GoTo ErrorHandler
        //
        //' Log entry
        //    objLog.Entry "FrequentMessageGroups:"+ "GetFolderTagFromId"
        //    objLog.InParam "SessionId:"+ SessionId
        //    objLog.InParam "ProjectId:"+ ProjectId
        //    objLog.InParam "MesGroupId:"+ MesGroupId
        //
        //' Main code
        //    GetFolderTagFromId = ""
        // Find the RespId
        //    lngRespId = GetRespID(MesGroupId)
        //    objLog.Progress "Got response id (" & lngRespId & ")"
        //    If lngRespId <> 0 Then
        //        Set objResp = new Aqua.dalResponses")
        //        GetFolderTagFromId = objResp.GetResponseTagFromId(SessionId, ProjectId, lngRespId)
        //        Set objResp = Nothing
        //        objLog.Progress "Got the response tag"
        //    End If
        //
        //' Commit transaction and release context object reference
        //    objContext.SetComplete
        //    Set objContext = Nothing
        //
        //' Log exit and release logging object reference
        //    objLog.OutParam "RetVal:"+ GetFolderTagFromId
        //    objLog.Exit
        //    Set objLog = Nothing
        //' Exit
        //    Exit Function
        //' Error handler - abort transaction, cleanup, rethrow
        //ErrorHandler:
        //    objContext.SetAbort
        //    Set objResp = Nothing
        //    Set objContext = Nothing
        //    Set objLog = Nothing
        //    Rethrow "FrequentMessageGroups:"+ "GetFolderTagFromId"
        //End Function

        private string GetResponseCols(ref bool GetTag, ref bool GetAnswer, ref bool InSelect)
        {
            string functionReturnValue = null;
            functionReturnValue = "";
            if (GetTag) {
                functionReturnValue = functionReturnValue + ", RES.Name ";
            }
            if (GetAnswer) {
                functionReturnValue = functionReturnValue + ", CAST(RES.Text As nvarchar(3000))";
                if (InSelect) {
                    functionReturnValue = functionReturnValue + " As Text ";
                }
            }
            return functionReturnValue;
        }

        private string GetTextFilter(ref string Filter_Renamed, ref bool GetTag, ref bool GetAnswer)
        {
            string functionReturnValue = null;
            functionReturnValue = "";
            if (!string.IsNullOrEmpty(Filter_Renamed))
            {
                functionReturnValue = functionReturnValue + "AND (";
                functionReturnValue = functionReturnValue + "MES.MessageText LIKE " + General.FormatFilter(Filter_Renamed);
                
                if (GetTag)
                {
                    functionReturnValue = functionReturnValue + " OR RES.Name LIKE " + General.FormatFilter(Filter_Renamed);
                }

                if (GetAnswer)
                {
                    functionReturnValue = functionReturnValue + " OR RES.Text LIKE " + General.FormatFilter(Filter_Renamed);
                }

                functionReturnValue = functionReturnValue + " ) ";
            }
            return functionReturnValue;
        }

        private string GetFolderFilter(ref int FolderId)
        {
            string functionReturnValue = null;
            // Add a filter for top level or subfolders
            // Default is -1 i.e. get them all
            functionReturnValue = "";
            
            if (FolderId == 0)
            {
                // top level case
                functionReturnValue = functionReturnValue + "AND NOT EXISTS (SELECT ChildAnswerId FROM ResponseHierachy As REH " + "WHERE REH.ChildAnswerId = RES.RespId) ";
            }
            else if (FolderId > 0)
            {
                // subfolder case
                functionReturnValue = functionReturnValue + "AND EXISTS (SELECT ChildAnswerId FROM ResponseHierachy As REH " + "WHERE REH.ChildAnswerId = RES.RespId " + "AND REH.ParentAnswerId = " + FolderId + ") ";
            }

            return functionReturnValue;
        }

        //Private Function GetFrequentMessagesInFolderCount(ByVal SessionId As Integer, ByVal ProjectId As Integer, ByVal Filter_Renamed As String, ByVal DispTag As Integer, ByVal DispAnswer As Integer, ByVal PublishStatus As Integer, ByVal FolderId As Integer, Optional ByRef DateCondition As String = "") As Integer
        
        //    Dim strSQL As String
        
        //    'strSQL = "SELECT Count(*) As Val " & _
        //    ''         "FROM Responses As RES WITH (REPEATABLEREAD) " & _
        //    ''         "INNER JOIN MesGroups As MGS WITH (REPEATABLEREAD) ON MGS.RespId = RES.RespId " & _
        //    ''         "INNER JOIN Messages As MES WITH (REPEATABLEREAD) ON MES.MesId = MGS.MesGroupId " & _
        //    ''         "WHERE RES.ProjectId = " & ProjectId & " "
        
        //    'If DateCondition <> "" Then
        //    '    strSQL = strSQL & DateCondition
        //    'End If
        
        //    '    strSQL = strSQL & "AND MES.Status='FMG' " & _
        //    ''                        GetTextFilter(Filter, DispTag, DispAnswer)
        //    Try
        //        Dim FilterFormat As String
        
        //        FilterFormat = Replace(Filter_Renamed, "'", "''")
        
        //        strSQL = "EXEC MasterQAsWithFolders " & ProjectId & ", NULL, NULL, '" & DateCondition & "', " & DispTag & ", " & DispAnswer & ", '" & FilterFormat & "'" & ", NULL, NULL, " & PublishStatus & "," & FolderId & ", 1"
        
        //        GetFrequentMessagesInFolderCount = AdoGetSingleValueNeverEmpty(strSQL)
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function
    
        private Collection<FrequentMessage> GetFrequentMessagesInFolderRecordset(int sessionId, int projectId, 
            string filter_Renamed, int order, int dir_Renamed, int dispTag, int dispAnswer, int intPage, int intPageSize, 
            ref int totalRecs, int publishStatus, int folderId, string dateCondition, int createdBy, int editedBy, 
            int approvedBy, ViewType currentViewType)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset
            int userID = 0;

            //' Get the CSRId
            Csr objCsr = new Csr();
            userID = objCsr.GetCsrID(sessionId, projectId);
            objCsr = null;
            Logging.log.Info("Got UserId");

            //dateCondition = dateCondition.Trim(); //this line commented to avoid error joining page size and date condition variable causing SQL error

            //if (dateCondition != "")
            //{
            //    //dateCondition = General.Right(dateCondition, dateCondition.Length - 4); - commented to avoid error: Invalid column name, on 5 July 2012
            //    dateCondition = dateCondition.Replace("'", "''");
            //}

            if (intPage == 0)
            {
                intPage = 1;
            }

            Folders folderHelper = new Folders();
            string folders = folderHelper.CheckFolderRetrieveAllFoldersForUser(projectId, userID);
            folderHelper = null;

            //Get User Type
            DataAccess.User userHelper = new DataAccess.User();
            string userTypeText = userHelper.GetUserType(userID);
            int currentUserType = Convert.ToInt32(General.GetUserLevelFromTypeText(userTypeText));

            string folderList = "";

            if (currentUserType < 3)
            {
                if (folders != "")
                {
                    folderList = General.Mid(folders, 2);
                }
                else
                {
                    if (folderId == -2)
                    {
                        folderList = "-1,0";
                    }
                    else
                    {
                        if ((int)currentViewType == 1)
                        {
                            folderList = "-1,0";
                        }
                    }
                }
            }

            Collection<FrequentMessage> freqMsgs = new Collection<FrequentMessage>();

            try
            {
 DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                
                freqMsgs = helper.GetFrequentMessagesInFolderRecordset(sessionId, projectId, filter_Renamed, order, dir_Renamed, dispTag, dispAnswer, intPage, intPageSize, ref totalRecs,
                publishStatus, folderId, dateCondition, createdBy, editedBy, approvedBy, currentViewType, folderList);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return freqMsgs;
        }
        
        //Private Function GetRespID(ByVal MesGroupId As Object) As Integer
        //    ' Gets the response id corresponding to the MesGroupId
        //    ' 0 is returned if the MesGroupId does not exist
        //    Dim strSQL As String
        //    Try
        //        strSQL = "SELECT RespId As Val FROM MesGroups WHERE MesGroupId=" & MesGroupId
        //        GetRespID = AdoGetSingleValueWithDefault(strSQL, 0)
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function

        //Public Function IsPublished(ByVal MesId As Integer) As Boolean
        //    Dim strSQL As String
        //    Dim mqaresRS As ADODB.Recordset
        //    Try
        //        strSQL = "SELECT RespId FROM MasterQAResponse WHERE MesGroupId = " & MesId
        //        mqaresRS = AdoGetRecordset(strSQL)

        //        If mqaresRS.EOF Or mqaresRS.EOF Then
        //            IsPublished = True
        //        Else
        //            IsPublished = False
        //        End If
        //    Catch ex As Exception
        //        HandleException("App Layer Error:", ex)
        //    End Try
        //End Function

        public void Publish(int MesId)
        {
            // Updates all of the fields of an FMG identified by MesGroupId
            // all values must be specified and valid
            // Returns false if the FMG doesn't exist
            // Declaration

            string pStatus = null;
            pStatus = "P";

            // Error trapping begins
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                helper.Publish(MesId, pStatus);
            }
            catch (Exception ex)
            {

                HandleException("App Layer Error:", ex);
            }
        }

        public void Unpublish(int MesId)
        {
            // Declaration
            string pStatus = null;
            pStatus = "P";
            
            // Error trapping begins
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                helper.UnPublish(MesId, pStatus);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
        }

        public bool CheckExpiryDate(int lngMessageId)
        {
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                return helper.CheckExpiryDate(lngMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public string CheckExpiryStatusPublished(int lngMesId)
        {
            ViewType currentViewType = ViewType.LiveMqa;
            return CheckExpiryStatusPublished(lngMesId, currentViewType);
        }

        public string CheckExpiryStatusPublished(int lngMesId, ViewType currentViewType)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            return helper.CheckExpiryStatusPublished(lngMesId, currentViewType);
        }

        public string CheckExpiryStatusExpired(int lngMesId)
        {
            ViewType currentViewType = ViewType.LiveMqa;
            return CheckExpiryStatusExpired(lngMesId, currentViewType);
        }

        public string CheckExpiryStatusExpired(int lngMesId, ViewType currentViewType)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            return helper.CheckExpiryStatusExpired(lngMesId, currentViewType);
        }

        public string CheckInternalStatus(int lngMesId)
        {   
            ViewType currentViewType = ViewType.LiveMqa;
            return CheckInternalStatus(lngMesId, currentViewType);
        }

        public string CheckInternalStatus(int lngMesId, ViewType currentViewType)
        {   
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            return helper.CheckInternalStatus(lngMesId, currentViewType);
        }
        
        public Collection<QuestionHistory> QuestionHistory(int SessionId, int ProjectId, string Filter, int Order, int Dir_Renamed, string DateCondition, string SQLFaces)
        {                      
            Collection<QuestionHistory> questions = new Collection<QuestionHistory>();
            try {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();                
                questions = helper.QuestionHistory(SessionId, ProjectId, Filter, Order, Dir_Renamed, DateCondition, SQLFaces);
            }
            catch (Exception ex) {
                HandleException("App Layer Error:", ex);
            }
            return questions;
        }

        public int QuestionHistoryCount(int SessionId, int ProjectId, int Page, int PageSize, string Filter, int Order, int Dir_Renamed, string DateCondition, string SQLFaces)
        {
            int questionscount = 0;
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                questionscount = helper.QuestionHistoryCount(SessionId, ProjectId, Page, PageSize, Filter, Order, Dir_Renamed, DateCondition, SQLFaces);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return questionscount;
        }

        public Collection<QuestionHistory> QuestionHistory(int SessionId, int ProjectId, int Page, int PageSize, string Filter, int Order, int Dir_Renamed, string DateCondition, string SQLFaces)
        {
            Collection<QuestionHistory> questions = new Collection<QuestionHistory>();
            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                questions = helper.QuestionHistory(SessionId, ProjectId, Page, PageSize, Filter, Order, Dir_Renamed, DateCondition, SQLFaces);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return questions;
        }

        public Collection<QuestionClickedHistory> QuestionClickedHistory(string DateCondition)
        {
            Collection<QuestionClickedHistory> questions = new Collection<QuestionClickedHistory>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
                questions = helper.QuestionClickedHistory(DateCondition);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return questions;
        }

        //Added by Priya on June 20, 2011
        //updated on 8 Oct 12 to match v7.0 
        public Collection<UsageActivity> UsageActivity(int SessionId, int ProjectId, string Period, string StartDate, string EndDate, int src)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset

            Collection<UsageActivity> usage = new Collection<UsageActivity>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();


                usage = helper.UsageActivity(SessionId, ProjectId, Period, StartDate, EndDate, src);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return usage;
        }


        //Added by Priya on July 11, 2011
        public Collection<AnalysisActivity> AnalysisActivity(int SessionId, int ProjectId, string Period, DateTime StartDate, DateTime EndDate)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset

            Collection<AnalysisActivity> analysis = new Collection<AnalysisActivity>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();


                analysis = helper.AnalysisActivity(SessionId, ProjectId, Period, StartDate, EndDate);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return analysis;
        }


        //Added by Priya on July 14, 2011
        public Collection<AfterHours> AfterHours(int SessionId, int ProjectId, string Period, DateTime StartDate, DateTime EndDate)
        {
            // Gets a paged, filtered and ordered list of frequent messages
            // The FolderId should be -1 if all FMGs are required
            // Returns: Recordset

            Collection<AfterHours> hours = new Collection<AfterHours>();

            try
            {
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();


                hours  = helper.AfterHours(SessionId, ProjectId, Period, StartDate, EndDate);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }
            return hours;
        }


        public int GetRespID(int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetRespID(lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        //Added by Priya on Sep 28, 2011
        public int GetKnowledgeDraftCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeDraftCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeApprovalCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeApprovalCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeDeletedCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeDeletedCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeInternalCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeInternalCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public int GetKnowledgeHighlightedCount(int projectId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetKnowledgeHighlightedCount(projectId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }
        //end of addition by Priya on Sep 28, 2011
        
        public bool UpdateMesApproval(int lngNewMessageId, int published, int pRespId, int lngApprovalId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateMesApproval(lngNewMessageId, published, pRespId, lngApprovalId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);

                return false;
            }
        }
        
        public bool UpdateMesGroupsRespID(int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            
            try
            {
                return helper.UpdateMesGroupsRespID(lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public bool AddMqaTrack(int lngNewMessageId, string strMessageTextFormat, string strResponseTextFormat, string strResponseTextNotesFormat, string strResponseTagFormat, bool blnPub, bool blnInt, bool blnExpiryDate, System.DateTime DtStartDate, System.DateTime DtEndDate, 
        bool blnReminder, string strAlertTo, int intBefEndDate, int intReminderFreq, string FolderPath, string ActionDone, int lngCsrId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            
            try
            {
                return helper.AddMqaTrack(lngNewMessageId, strMessageTextFormat, strResponseTextFormat, strResponseTextNotesFormat, strResponseTagFormat, blnPub, blnInt, blnExpiryDate, DtStartDate, DtEndDate, 
                blnReminder, strAlertTo, intBefEndDate, intReminderFreq, FolderPath, ActionDone, lngCsrId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public int GetTopRespID(int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetTopRespID(lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public bool UpdateMessageInternalMqa(int lngNewMessageId, int lngProjectId, int IntMQA)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateMessageInternalMqa(lngNewMessageId, lngProjectId, IntMQA);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool UpdateMesGroupApproved(int lngCsrId, int lngNewMessageId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateMesGroupApproved(lngCsrId, lngNewMessageId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool SetResponseNotes(int RespId, int lngProjectId, string strResponseText, string strResponseTextNotes)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try 
            {
                return helper.SetResponseNotes(RespId, lngProjectId, strResponseText, strResponseTextNotes);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public bool InsertExpiryDate(int lngMesId, string strExpiryDate, string strStartDate, string strEndDate, string strReminder, string strAlertTo, int intBefEndDate, int intReminderFreq)
        {
            int intExpiryDate = 0;
            int intReminder = 0;
            int intReminderCount = 0;
            int intCurReminder = 0;
            
            intCurReminder = 0;
            
            if (strExpiryDate.ToLower() == "true")
            {
                intExpiryDate = 1;
            }
            else
            {
                intExpiryDate = 0;
            }
            
            if (strReminder.ToLower() == "true")
            {
                intReminder = 1;
            }
            else
            {
                intReminder = 0;
            }
            
            if (intReminderFreq > 0)
            {
                intReminderCount = (24 / intReminderFreq);

                if (intReminderCount < 0)
                {
                    intReminderCount = 1;
                }
            }
            else
            {
                if (!string.IsNullOrEmpty(strAlertTo))
                {
                    intReminderCount = 1;
                }
                else
                {
                    intReminderCount = 0;
                }
            }
            
            if (!string.IsNullOrEmpty(strStartDate) | !string.IsNullOrEmpty(strEndDate))
            {
                //strSQL = "INSERT INTO ExpiryDate ( " & _
                //	" MesId, ExpiryDate, StartDate, EndDate, " &_
                //	" Reminder, AlertTo, DaysBeforeEndDate, ReminderFreq, DateCreated, " &_
                //	" ReminderCount, CurReminder ) " &_
                //	" VALUES ( "&lngMesId&", "&intExpiryDate&", '"&strStartDate&"', '"&strEndDate&"', " &_
                //	" "&intReminder&", '"&strAlertTo&"', "&intBefEndDate&", "&intReminderFreq&"," &_
                //	" '"&now&"' , "&intReminderCount&", "&intCurReminder&" ) "
                
                DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

                try
                {
                    return helper.InsertExpiryDate(lngMesId, Convert.ToString(intExpiryDate), strStartDate, strEndDate, Convert.ToString(intReminder), Convert.ToString(strAlertTo), intBefEndDate, intReminderFreq, intReminderCount, intCurReminder);
                }
                catch (Exception ex)
                {
                    //response.write "<br>" & strSQL
                    //response.end
                    
                    //objConn.Execute(strSQL)
                    HandleException("App Layer Error:", ex);
                }
            }

            return false;
        }
        
        public bool UpdateExpiryDate(int lngMesId, string strExpiryDate, string strStartDate, string strEndDate, string strReminder, string strAlertTo, int intBefEndDate, int intReminderFreq)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.UpdateExpiryDate(lngMesId, strExpiryDate, strStartDate, strEndDate, strReminder, strAlertTo, intBefEndDate, intReminderFreq);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }

        public bool DeleteExpiryDate(int lngMesId, string strModule)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.DeleteExpiryDate(lngMesId, strModule);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public int GetMasterQaRespID(int pMesId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetMasterQaRespID(pMesId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }
        
        public bool DeleteMasterQaResponses(int pMesId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.DeleteMasterQaResponses(pMesId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return false;
        }
        
        public string GetResponseNotes(int TRespId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();
            try {
                return helper.GetResponseNotes(TRespId);
            }
            catch (Exception ex) {
                HandleException("App Layer Error:", ex);
            }
            return "";
        }
        
        
        public int GetPublishedCount(int MesId)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetPublishedCount(MesId);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return 0;
        }

        public string GetSourceOfRejectedQuestion(int mesID)
        {
            DataAccess.FrequentMessageGroups helper = new DataAccess.FrequentMessageGroups();

            try
            {
                return helper.GetSourceOfRejectedQuestion(mesID);
            }
            catch (Exception ex)
            {
                HandleException("App Layer Error:", ex);
            }

            return "";
        }

        public void HandleException(string message, Exception ex)
        {
            LogicException wrap = new LogicException(message, ex);
            bool rethrow = ExceptionPolicy.HandleException(wrap, "Application Layer Policy");

            if (rethrow)
            {
                throw wrap;
            }
        }
       
    }
}