/// <summary>
        /// Function to Delete SystemMessages details
        /// </summary>
        /// <param name="SystemMessagesID"></param>
        /// <returns></returns>
        public Response <SystemMessages> Delete(int SystemMessagesID)
        {
            try
            {
                var res = BAL_SysMessages.RemoveSystemMessage(SystemMessagesID);
                if (res > 0)
                {
                    return new Response <SystemMessages> {
                               Status = true, MessageType = MessageTypes.Success, SystemMessages = lstMsgs[1]
                    }
                }
                ;
                else
                {
                    return new Response <SystemMessages> {
                               Status = false, MessageType = MessageTypes.Failure, SystemMessages = lstMsgs[0]
                    }
                };
            }
            catch (SqlException ex)
            {
                if (ex.Errors.Count > 0)
                {
                    switch (ex.Errors[0].Number)
                    {
                    case 547:     // Foreign Key violation
                        return(new Response <SystemMessages> {
                            Status = false, MessageType = MessageTypes.ForeignKeyIssue
                        });

                    default:
                        return(new Response <SystemMessages> {
                            Status = false, MessageType = MessageTypes.Exception, Message = ex.Message
                        });
                    }
                }
                else
                {
                    return new Response <SystemMessages> {
                               Status = false, MessageType = MessageTypes.Exception, Message = ex.Message
                    }
                };
            }
            catch (Exception ex)
            {
                return(new Response <SystemMessages> {
                    Status = false, MessageType = MessageTypes.Exception, Message = ex.Message
                });
            }
        }