public MessagesEntity GetMessagesObject(int messageID, UsersTypes viewerType, Guid OwnerID) { MessagesEntity msg = null; using (SqlConnection myConnection = GetSqlConnection()) { SqlCommand myCommand = new SqlCommand("Messages_GetOneByID", myConnection); myCommand.CommandType = CommandType.StoredProcedure; // Set the parameters myCommand.Parameters.Add("@ViewerType ", SqlDbType.Int, 4).Value = (int)viewerType; myCommand.Parameters.Add("@MessageID", SqlDbType.Int, 4).Value = messageID; //--------------------------------------------------------------------- myCommand.Parameters.Add("@OwnerID", SqlDbType.UniqueIdentifier).Value = OwnerID; //--------------------------------------------------------------------- // Execute the command myConnection.Open(); using (SqlDataReader dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { if (dr.Read()) { //msg = PopulateEntity(dr); msg = (MessagesEntity)GetEntity(dr, typeof(MessagesEntity)); } dr.Close(); } myConnection.Close(); return(msg); } }
//------------------------------------------ #endregion #region --------------GetMessagesObject-------------- public static MessagesEntity GetMessagesObject(int messageID, UsersTypes viewerType, Guid OwnerID) { MessagesEntity msg = MessagesSqlDataPrvider.Instance.GetMessagesObject(messageID, viewerType, OwnerID); //return the object return(msg); }
//--------------------------------------------------------------------------- //--------------------------------------------------------------------------- public static bool IsSubSubSiteOwner(UsersTypes userType) { if (userType == UsersTypes.SiteOwner) { return(true); } else { return(false); } }
private void DoFilterUsersByType(String typeName) { UsersTypes newFilter; if (Enum.TryParse(typeName, out newFilter)) { _currentFilter = newFilter; FilterUsersByType(newFilter); } else { FilterUsersByType(null); } }