/// <summary>
/// Deletes all the message type to point systems from the point system.
/// </summary>
/// <param name="pointSystemId">The point system identifier.</param>
public static void DeleteAllFrom(int pointSystemId)
{
using (TerministratorContext context = new TerministratorContext(true))
{
context.MessageTypeToPointSystem.RemoveRange(
context.MessageTypeToPointSystem.Where(x => x.PointSystemId == pointSystemId));
context.SaveChanges();
}
}
/// <summary>
/// Creates the specified message type.
/// </summary>
/// <param name="messageType">Type of the message.</param>
/// <returns>The same message type with an updated ID.</returns>
public static Entites.MessageType Create(Entites.MessageType messageType)
{
using (TerministratorContext context = new TerministratorContext(true))
{
messageType.MessageTypeId = context.MessageType.Add(messageType).MessageTypeId;
context.SaveChanges();
return(messageType);
}
}
/// <summary>
/// Creates the specified blocked word.
/// </summary>
/// <param name="blockedWord">The blocked word.</param>
/// <returns>The same blocked word with an updated ID.</returns>
public static Entites.BlockedWord Create(Entites.BlockedWord blockedWord)
{
using (TerministratorContext context = new TerministratorContext(true))
{
blockedWord.BlockedWordId = context.BlockedWord.Add(blockedWord).BlockedWordId;
context.SaveChanges();
return(blockedWord);
}
}
/// <summary>
/// Creates the specified application.
/// </summary>
/// <param name="application">The application.</param>
/// <returns>The same application with an updated ID.</returns>
public static Entites.Application Create(Entites.Application application)
{
using (TerministratorContext context = new TerministratorContext(true))
{
application = context.Application.Add(application);
context.SaveChanges();
return(application);
}
}
/// <summary>
/// Creates the specified user.
/// </summary>
/// <param name="user">The user.</param>
/// <returns>The same user with an updated id.</returns>
public static Entites.User Create(Entites.User user)
{
Entites.User reference = ClearReferences(user);
using (TerministratorContext context = new TerministratorContext(true))
{
user.NamableId = context.User.Add(user).NamableId;
context.SaveChanges();
}
return(AddReferences(user, reference));
}
/// <summary>
/// Creates the specified text.
/// </summary>
/// <param name="text">The text.</param>
/// <returns>The same text with an updated id.</returns>
public static Entites.Text Create(Entites.Text text)
{
Entites.Text reference = ClearReferences(text);
using (TerministratorContext context = new TerministratorContext(true))
{
text.MessageContentId = context.Text.Add(text).MessageContentId;
context.SaveChanges();
}
return(AddReferences(text, reference));
}
/// <summary>
/// Creates the specified message.
/// </summary>
/// <param name="message">The message.</param>
/// <returns>The same message with an updated ID.</returns>
public static Entites.Message Create(Entites.Message message)
{
Entites.Message reference = ClearReferences(message);
using (TerministratorContext context = new TerministratorContext(true))
{
message.MessageId = context.Message.Add(message).MessageId;
context.SaveChanges();
}
return(AddReferences(message, reference));
}
/// <summary>
/// Creates the specified user to channel in the database.
/// </summary>
/// <param name="userToChannel">The user to channel.</param>
/// <returns>The user to channel witn an updated ID.</returns>
public static Entites.UserToChannel Create(Entites.UserToChannel userToChannel)
{
Entites.UserToChannel reference = ClearReferences(userToChannel);
using (TerministratorContext context = new TerministratorContext(true))
{
userToChannel.UserToChannelId = context.UserToChannel.Add(userToChannel).UserToChannelId;
context.SaveChanges();
}
return(AddReferences(userToChannel, reference));
}
/// <summary>
/// Creates the specified ad system.
/// </summary>
/// <param name="adSystem">The ad system.</param>
/// <returns></returns>
public static Entites.AdSystem Create(Entites.AdSystem adSystem)
{
Entites.AdSystem reference = ClearReferences(adSystem);
using (TerministratorContext context = new TerministratorContext(true))
{
context.AdSystem.Add(adSystem);
context.SaveChanges();
}
return(AddReferences(adSystem, reference));
}
/// <summary>
/// Creates the specified rules.
/// </summary>
/// <param name="rules">The rules.</param>
/// <returns>The same rules with the updated ID.</returns>
public static Entites.Rules Create(Entites.Rules rules)
{
Entites.Rules reference = ClearReferences(rules);
using (TerministratorContext context = new TerministratorContext(true))
{
rules.RulesId = context.Rules.Add(rules).RulesId;
context.SaveChanges();
}
return(AddReferences(rules, reference));
}
/// <summary>
/// Creates the specified user name.
/// </summary>
/// <param name="userName">The user name.</param>
/// <returns>The same user name with the id updated.</returns>
public static Entites.UserName Create(Entites.UserName userName)
{
Entites.UserName reference = ClearReferences(userName);
using (TerministratorContext context = new TerministratorContext(true))
{
userName.UserNameId = context.UserName.Add(userName).UserNameId;
context.SaveChanges();
}
return(AddReferences(userName, reference));
}
/// <summary>
/// Creates the specified ad.
/// </summary>
/// <param name="ad">The ad.</param>
/// <returns>The same ad with an updated ID.</returns>
public static Entites.Ad Create(Entites.Ad ad)
{
Entites.Ad reference = ClearReferences(ad);
using (TerministratorContext context = new TerministratorContext(true))
{
ad.AdId = context.Ad.Add(ad).AdId;
context.SaveChanges();
}
return(AddReferences(ad, reference));
}
/// <summary>
/// Creates the specified message type to point system.
/// </summary>
/// <param name="messageTypeToPointSystem">The message type to point system.</param>
/// <returns>The same message type to point system.</returns>
public static Entites.MessageTypeToPointSystem Create(Entites.MessageTypeToPointSystem messageTypeToPointSystem)
{
Entites.MessageTypeToPointSystem reference = ClearReferences(messageTypeToPointSystem);
using (TerministratorContext context = new TerministratorContext(true))
{
context.MessageTypeToPointSystem.Add(messageTypeToPointSystem);
context.SaveChanges();
}
return(AddReferences(messageTypeToPointSystem, reference));
}
/// <summary>
/// Creates the specified channel.
/// </summary>
/// <param name="channel">The channel.</param>
/// <returns>The same channel with the updated ID.</returns>
public static Entites.Channel Create(Entites.Channel channel)
{
Entites.Channel reference = ClearReferences(channel);
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.Channel newChannel = context.Channel.Add(channel);
channel.NamableId = newChannel.NamableId;
context.SaveChanges();
}
return(AddReferences(channel, reference));
}
/// <summary>
/// Switch the user name to a non-current state.
/// </summary>
/// <param name="ownedById">The user identifier.</param>
public static void UpdateUserName(int ownedById)
{
using (TerministratorContext context = new TerministratorContext(true))
{
(from c in context.UserName
where c.OwnedById == ownedById &&
c.Current
select c).First().Current = false;
context.SaveChanges();
}
}
/// <summary>
/// Updates the blocked words.
/// </summary>
/// <param name="rules">The rules.</param>
/// <returns></returns>
public static Entites.Rules UpdateBlockedWords(Entites.Rules rules)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.Rules old = context.Rules.Find(rules.RulesId);
if (old != null)
{
old.BlockedWords = rules.BlockedWords;
context.SaveChanges();
}
}
return(rules);
}
/// <summary>
/// Updates the name of the specified message type.
/// </summary>
/// <param name="messageType">Type of the message.</param>
/// <returns>The same message type.</returns>
public static Entites.MessageType Update(Entites.MessageType messageType)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.MessageType original = context.MessageType.Find(messageType.MessageTypeId);
if (original != null)
{
original.Name = messageType.Name;
context.SaveChanges();
}
return(original);
}
}
/// <summary>
/// Updates the specified ad system.
/// </summary>
/// <param name="adSystem">The ad system.</param>
/// <returns>The same ad system.</returns>
public static Entites.AdSystem Update(Entites.AdSystem adSystem)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.AdSystem original = context.AdSystem.Find(adSystem.ChannelId);
if (original != null)
{
original.BothConditions = adSystem.BothConditions;
original.MinNbOfMessage = adSystem.MinNbOfMessage;
original.MinTime = adSystem.MinTime;
context.SaveChanges();
}
return(original);
}
}
/// <summary>
/// Updates the specified application.
/// </summary>
/// <param name="application">The application.</param>
/// <returns>The same application</returns>
public static Entites.Application Update(Entites.Application application)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.Application original = context.Application.Find(application.ApplicationName);
if (original != null)
{
original.CommandSymbols = application.CommandSymbols;
original.UserSymbols = application.UserSymbols;
original.Token = original.Token;
context.SaveChanges();
}
}
return(application);
}
/// <summary>
/// Updates the specified text.
/// </summary>
/// <param name="text">The text.</param>
/// <returns>The same text given in arguement.</returns>
public static Entites.Text Update(Entites.Text text)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.Text old = context.Text.Find(text.MessageContentId);
if (old != null)
{
old.SimilarContentId = text.SimilarContentId;
context.SaveChanges();
context.Entry(old).Reference(x => x.SimilarContent);
}
text.SimilarContent = old?.SimilarContent;
}
return(text);
}
/// <summary>
/// Updates the specified privileges.
/// </summary>
/// <param name="privileges">The privileges.</param>
/// <returns>The same privileges.</returns>
public static Entites.Privileges Update(Entites.Privileges privileges)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.Privileges old = context.Privileges.Find(privileges.PrivilegesId);
if (old != null)
{
old.Name = privileges.Name;
old.RulesId = privileges.RulesId;
old.Default = privileges.Default;
context.SaveChanges();
}
}
return(privileges);
}
/// <summary>
/// Updates the specified ad.
/// </summary>
/// <param name="ad">The ad.</param>
/// <returns>The same ad.</returns>
public static Entites.Ad Update(Entites.Ad ad)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.Ad old = context.Ad.Find(ad.AdId);
if (old != null)
{
old.MaxShow = ad.MaxShow;
old.Name = ad.Name;
old.LastSent = ad.LastSent;
context.SaveChanges();
}
}
return(ad);
}
/// <summary>
/// Updates the specified user to channel in the database.
/// </summary>
/// <param name="userToChannel">The user to channel.</param>
/// <returns>The same user to channel that was given in entry.</returns>
public static Entites.UserToChannel Update(Entites.UserToChannel userToChannel)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.UserToChannel original = context.UserToChannel.Find(userToChannel.UserToChannelId);
if (original != null)
{
original.Points = userToChannel.Points;
original.PrivilegesId = userToChannel.PrivilegesId;
original.NbSilences = userToChannel.NbSilences;
original.SilencedTo = userToChannel.SilencedTo;
context.SaveChanges();
}
}
return(userToChannel);
}
/// <summary>
/// Updates the specified rules.
/// </summary>
/// <param name="rules">The rules.</param>
/// <returns>The same rules.</returns>
public static Entites.Rules Update(Entites.Rules rules)
{
using (TerministratorContext context = new TerministratorContext(true))
{
Entites.Rules old = context.Rules.Find(rules.RulesId);
if (old != null)
{
old.SpamDelay = rules.SpamDelay;
old.BlockedWordsEnabled = rules.BlockedWordsEnabled;
old.DomainBlocked = rules.DomainBlocked;
old.ExtensionBlocked = rules.ExtensionBlocked;
old.MessageTypeBlocked = rules.MessageTypeBlocked;
old.R9KEnabled = rules.R9KEnabled;
context.SaveChanges();
}
}
return(rules);
}