public static PrivateMessageInfo[] GetPrivateMessages(int userId)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return db.PrivateMessageInfos.Where(x =>
x.FromID == userId ||
x.ToID == userId)
.ToArray();
}
public static bool AddNewSuggestion(string username, string text)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
SuggestionTable suggestion = new SuggestionTable()
{
Suggestion = text,
Username = username
};
db.SuggestionTables.InsertOnSubmit(suggestion);
db.SubmitChanges();
return(db.SuggestionTables.Contains(suggestion));
}
public static bool AddNewSuggestion(string username, string text)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
SuggestionTable suggestion = new SuggestionTable()
{
Suggestion = text,
Username = username
};
db.SuggestionTables.InsertOnSubmit(suggestion);
db.SubmitChanges();
return db.SuggestionTables.Contains(suggestion);
}
public static bool UpdateRank(string username, int points, byte rank)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
User user = db.Users.FirstOrDefault(x => x.Username.ToLower() == username.ToLower());
if (user != null)
{
user.Points = points;
user.Rank = rank;
db.SubmitChanges();
return(true);
}
return(false);
}
public static bool AddPrivateMessage(int fromId, int toId, string subject, string message)
{
PrivateMessageInfo pm = new PrivateMessageInfo()
{
FromID = fromId,
ToID = toId,
Subject = subject,
TimeSent = DateTime.UtcNow,
Message = message,
TimeRead = DateTime.FromOADate(0)
};
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
db.PrivateMessageInfos.InsertOnSubmit(pm);
db.SubmitChanges();
return db.PrivateMessageInfos.Contains(pm);
}
public static bool AddPrivateMessage(int fromId, int toId, string subject, string message)
{
PrivateMessageInfo pm = new PrivateMessageInfo()
{
FromID = fromId,
ToID = toId,
Subject = subject,
TimeSent = DateTime.UtcNow,
Message = message,
TimeRead = DateTime.FromOADate(0)
};
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
db.PrivateMessageInfos.InsertOnSubmit(pm);
db.SubmitChanges();
return(db.PrivateMessageInfos.Contains(pm));
}
public static bool InsertUser(string username, string password, string email)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
bool exists = db.Users.Any(x => x.Username == username.ToLower() || x.Email == email.ToLower());
if (exists)
{
return(false);
}
User user = new User()
{
Id = 0,
Username = username,
Password = password.ToLower(),
Email = email.ToLower(),
};
db.Users.InsertOnSubmit(user);
db.SubmitChanges();
return(db.Users.Contains(user));
}
public static User GetUser(string username)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return db.Users.FirstOrDefault(x => x.Username.ToLower() == username.ToLower());
}
public static User GetUser(int id)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return db.Users.FirstOrDefault(x => x.Id == id);
}
public static Channel[] GetChannels()
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return db.Channels.ToArray();
}
public static User GetUser(int id)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return(db.Users.FirstOrDefault(x => x.Id == id));
}
public static bool InsertUser(string username, string password, string email)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
bool exists = db.Users.Any(x => x.Username == username.ToLower() || x.Email == email.ToLower());
if (exists)
return false;
User user = new User()
{
Id = 0,
Username = username,
Password = password.ToLower(),
Email = email.ToLower(),
};
db.Users.InsertOnSubmit(user);
db.SubmitChanges();
return db.Users.Contains(user);
}
public static Channel[] GetChannels()
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return(db.Channels.ToArray());
}
public static User[] GetUserFromPartialName(string partialName)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return(db.Users.Where(x => x.Username.Contains(partialName.ToLower())).ToArray());
}
public static User GetUser(string username)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return(db.Users.FirstOrDefault(x => x.Username.ToLower() == username.ToLower()));
}
public static User GetUser(string username, string password)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return db.Users.FirstOrDefault(x =>
(x.Username.ToLower() == username.ToLower() || x.Email == username.ToLower())
&& x.Password == password.ToLower());
}
public static User[] GetUserFromPartialName(string partialName)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
return db.Users.Where(x => x.Username.Contains(partialName.ToLower())).ToArray();
}
public static bool UpdateRank(string username, int points, byte rank)
{
DatabaseDataContext db = new DatabaseDataContext(ConnectionString);
User user = db.Users.FirstOrDefault(x => x.Username.ToLower() == username.ToLower());
if (user != null)
{
user.Points = points;
user.Rank = rank;
db.SubmitChanges();
return true;
}
return false;
}
