public static void PostReply(int messagebase, string subject, bool anon, int userid, string message, int threadid) { try { BBSDataContext bbs = GetContext(); MessageHeader header = new MessageHeader() { MessageBaseId = messagebase, Anonymous = anon, Posted = DateTime.Now, Subject = subject, UserId = userid, MessageThreadId = threadid }; bbs.MessageHeaders.Add(header); bbs.SaveChanges(); MessageBody body = new MessageBody() { Body = message, MessageHeaderId = header.MessageHeaderId }; bbs.MessageBodies.Add(body); bbs.SaveChanges(); } catch (Exception e) { LoggingAPI.LogEntry("Exception in DataInterface.PostMessage: " + e.ToString()); } }
public static bool InitializeDatabase() { bool b = true; BBSDataContext bbs = BBSDataContext.GetContext(); SysConfig config = null; try { config = bbs.SysConfigs.First(p => true); } catch (Exception e) { //nada LoggingAPI.LogEntry("Exception in DBUpdater.InitializeDatabase (Initial config check): " + e.Message); } if (config == null) { //Create base config config = new SysConfig() { DatabaseVersion = 0 }; bbs.SysConfigs.Add(config); bbs.SaveChanges(); //Create Sysop User User u = new User() { Username = "******", HashedPassword = "******", LastConnection = DateTime.Now, LastConnectionIP = "127.0.0.1", LastDisconnection = DateTime.Now }; bbs.Users.Add(u); bbs.SaveChanges(); //Reload to get id in case it didn't autofill u = bbs.Users.FirstOrDefault(p => p.Username.Equals("Six")); //Create base bbsconfig BBSConfig bconfig = new BBSConfig() { SysOpUserId = u.UserId, BBS_Name = "The Darkside BBS" }; bbs.BBSConfigs.Add(bconfig); bbs.SaveChanges(); } return(b); }
public static bool SaveNewUser(string un, string pw, string rn, string em, string co) { bool b = false; try { string Un = Utils.ToSQL(un); string Pw = Utils.ToSQL(pw); string Rn = Utils.ToSQL(rn); string Em = Utils.ToSQL(em); string Co = Utils.ToSQL(co); User u = new User() { Username = Un, HashedPassword = Pw, RealName = Rn, Email = Em, ComputerType = Co, AccessLevel = 0 }; u.LastConnection = DateTime.Now; u.LastDisconnection = DateTime.Now; BBSDataContext bbs = GetContext(); bbs.Users.Add(u); bbs.SaveChanges(); b = true; } catch (Exception e) { LoggingAPI.LogEntry("Exception in DataInterface.SaveNewUser: " + e.ToString()); b = false; } return(b); }
public static void RecordDisconnection(int callLogId) { BBSDataContext bbs = GetContext(); CallLog cl = bbs.CallLogs.FirstOrDefault(p => p.CallLogId.Equals(callLogId)); if (cl != null) { cl.Disconnected = DateTime.Now; bbs.SaveChanges(); } }
public static void UpdateCallLog(int callLogId, int userid) //Used after new user reg { BBSDataContext bbs = GetContext(); CallLog cl = bbs.CallLogs.FirstOrDefault(p => p.CallLogId.Equals(callLogId)); if (cl != null) { cl.UserId = userid; bbs.SaveChanges(); } }
public static int RecordConnection(int userid) { int i = -1; BBSDataContext bbs = GetContext(); CallLog cl = new CallLog() { Connected = DateTime.Now, Disconnected = DateTime.Now, UserId = userid }; bbs.CallLogs.Add(cl); bbs.SaveChanges(); return(i); }
public static void AddGraffiti(string graffiti, int userid) { try { BBSDataContext bbs = GetContext(); Graffiti g = new Graffiti() { Content = graffiti, Posted = DateTime.Now, UserId = userid }; bbs.Graffitis.Add(g); bbs.SaveChanges(); } catch (Exception e) { LoggingAPI.LogEntry("Exception in DataInterface.AddGraffiti: " + e.ToString()); } }
public static void NewFeedback(string subject, string body, int fromuser) { try { BBSDataContext bbs = GetContext(); Feedback f = new Feedback() { Subject = subject, Body = body, FromUser = fromuser, Sent = DateTime.Now }; bbs.Feedbacks.Add(f); bbs.SaveChanges(); } catch (Exception e) { LoggingAPI.LogEntry("Exception in DataInterface.NewFeedback: " + e.ToString()); } }
public static void MarkRead(int userid, int messageid) { try { if (!HasRead(userid, messageid)) { BBSDataContext bbs = GetContext(); UserRead ur = new UserRead() { UserId = userid, MessageHeaderId = messageid }; bbs.UserReads.Add(ur); bbs.SaveChanges(); } } catch (Exception e) { LoggingAPI.LogEntry("Exception in DataInterface.MarkRead(" + userid.ToString() + "," + messageid.ToString() + "):" + e.ToString()); } }
public static void SaveUserDefinedField(int userid, string key, string value) { BBSDataContext bbs = GetContext(); UserDefinedField udf = bbs.UserDefinedFields.FirstOrDefault(p => p.UserId.Equals(userid) && p.Key.ToUpper().Equals(key.ToUpper())); if (udf != null) { //Modify udf.FieldValue = value; } else { //New udf = new UserDefinedField() { Key = key, FieldValue = value, UserId = userid }; bbs.UserDefinedFields.Add(udf); } bbs.SaveChanges(); }