internal static void DeleteMessage(Guid authorId, Guid messageId)
{
using (Data.WiseManEntities db = new Data.WiseManEntities())
{
db.DeleteMessage(messageId, authorId);
}
}
internal static void DownvoteMessage(Guid messageId, Guid userId)
{
using (Data.WiseManEntities db = new Data.WiseManEntities())
{
db.DownvoteMessage(messageId, userId);
}
}
internal static List <Message> GetMessagesByAuthorId(Guid authorId)
{
List <Message> messages = new List <Message>();
using (Data.WiseManEntities db = new Data.WiseManEntities())
{
var results = db.GetMessagesByAuthor(authorId).ToList();
foreach (var item in results)
{
List <Tag> tags = new List <Tag>();
List <string> tagNames = item.TagArray.Split(',').ToList();
foreach (var tag in tagNames)
{
tags.Add(new Tag()
{
Name = tag
});
}
messages.Add(new Message()
{
Body = item.Body,
Downvotes = item.Downvotes,
Id = item.MessageId,
Upvotes = item.Upvotes,
Tags = tags
});
}
}
return(messages);
}
/// <summary>
/// Gets a message by id
/// </summary>
/// <param name="messageId"></param>
/// <returns></returns>
internal static Message GetMessageById(Guid messageId)
{
Message message;
using (Data.WiseManEntities db = new Data.WiseManEntities())
{
message = new Message(db.GetMessageById(messageId).FirstOrDefault());
}
return(message);
}
internal static User GetUserByUsername(string username)
{
GetUserByUsername_Result resultSet = new GetUserByUsername_Result();
using (Data.WiseManEntities db = new Data.WiseManEntities())
{
resultSet = db.GetUserByUsername(username).FirstOrDefault();
}
return(new User(resultSet));
}
/// <summary>
/// Creates a new message
/// </summary>
/// <param name="body"></param>
/// <param name="authorId"></param>
/// <param name="tags"></param>
public static void CreateMessage(string messageBody, Guid authorId, List <string> tags)
{
string tagString = "";
foreach (var item in tags)
{
tagString += item + ",";
}
using (Data.WiseManEntities db = new Data.WiseManEntities())
{
db.CreateMessage(messageBody, tagString, authorId);
}
}
internal static void RegisterNewAccount(string username, string password, string email)
{
int size = new Random().Next(10, 20);
string salt = CreateSalt(size);
string hashedPass = GenerateSHA256Hash(password, salt);
try
{
using (Data.WiseManEntities db = new Data.WiseManEntities())
{
db.RegisterNewAccount(username, hashedPass, salt, email);
};
}
catch (Exception ex)
{
throw;
}
}
