public void UpdateForumSession(string username, string sessionhash, int loggedin) { int forumUserId = 0; using (NtxfcDbContext db = new NtxfcDbContext()) { Login login = db.Logins.FirstOrDefault(x => x.Username == username); if (login != null) { forumUserId = login.ForumUserId; } } if (forumUserId != 0) { using (ExternalDbContext db = new ExternalDbContext()) { var session = db.Sessions.FirstOrDefault(x => x.sessionhash == sessionhash); if (session != null) { session.loggedin = loggedin; session.userid = forumUserId; db.Sessions.Attach(session); db.Entry(session).Property(u => u.loggedin).IsModified = true; db.Entry(session).Property(u => u.userid).IsModified = true; db.SaveChanges(); } } } }
public void DeleteForumCpSession(string hash) { using (ExternalDbContext db = new ExternalDbContext()) { var session = db.CpSessions.FirstOrDefault(x => x.hash == hash); if (session != null) { db.CpSessions.Remove(session); db.SaveChanges(); } } }
public bool IsExistingForumSession(string sessionhash) { using (ExternalDbContext db = new ExternalDbContext()) { var session = db.Sessions.FirstOrDefault(x => x.sessionhash == sessionhash); if (session != null) { return(true); } } return(false); }
public bool IsValidAuthenticationCode(string username, string activiationId) { using (ExternalDbContext db = new ExternalDbContext()) { var activation = db.Database.SqlQuery <UserActivation>("SELECT vb3_useractivation.* FROM vb3_useractivation, vb3_user WHERE vb3_user.username = @username AND vb3_useractivation.activationid = @activiationId", new MySqlParameter("username", username), new MySqlParameter("activiationId", activiationId)); if (activation.Any()) { return(true); } } return(false); }
private void CreateExternalSampleDatabase(string connectionStringName, string connString) { using (var context = new ExternalDbContext(connString)) { context.Database.EnsureCreated(); context.Database.Migrate(); if (context.MyTable.Count() == 0) { var myRecord = new MyTable { Data = connectionStringName }; context.MyTable.Add(myRecord); context.SaveChanges(); } } }
public User CreateForumUser(User user, string activationid) { using (ExternalDbContext db = new ExternalDbContext()) { db.Users.Add(user); db.SaveChanges(); } using (ExternalDbContext db = new ExternalDbContext()) { db.Database.ExecuteSqlCommand("INSERT INTO `vb3_userfield` (userid) VALUES(@userid)", new MySqlParameter("userid", user.userid)); db.SaveChanges(); } using (ExternalDbContext db = new ExternalDbContext()) { db.Database.ExecuteSqlCommand("INSERT INTO `vb3_useractivation` (userid, activationid) VALUES(@userid,@activationid)", new MySqlParameter("userid", user.userid), new MySqlParameter("activationid", activationid)); db.SaveChanges(); } return(user); }
public string SaveForumSession(string username, string host, string useragent, string forwardedfor) { int forumUserId = 0; using (NtxfcDbContext db = new NtxfcDbContext()) { Login login = db.Logins.FirstOrDefault(x => x.Username == username); if (login != null) { forumUserId = login.ForumUserId; } } if (forumUserId != 0) { Session session = new Session(); session.sessionhash = Guid.NewGuid().ToString("N"); session.userid = forumUserId; session.host = host; session.idhash = CalculateMD5Hash(String.Concat(useragent, GetSubIP(GetRealIP(host, forwardedfor)))); TimeSpan ts = (DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0)); session.lastactivity = Convert.ToInt32(ts.TotalSeconds); session.location = "/login.php"; session.useragent = useragent; session.loggedin = 1; session.apiaccesstoken = string.Empty; using (ExternalDbContext db = new ExternalDbContext()) { db.Sessions.Add(session); db.SaveChanges(); } return(session.sessionhash); } return(string.Empty); }
public User ActivateUser(string username, string activationid) { User user; using (ExternalDbContext db = new ExternalDbContext()) { user = db.Users.FirstOrDefault(x => x.username == username); user.usergroupid = 2; db.Users.Attach(user); db.Entry(user).Property(u => u.usergroupid).IsModified = true; db.SaveChanges(); } if (user != null) { using (ExternalDbContext db = new ExternalDbContext()) { db.Database.ExecuteSqlCommand("DELETE FROM `vb3_useractivation` WHERE userid = @userid AND activationid = @activationid", new MySqlParameter("userid", user.userid), new MySqlParameter("activationid", activationid)); db.SaveChanges(); } } return(user); }
public ExternalDbService(ExternalDbContext context) { this.context = context; }
public SellOrderController(ExternalDbContext context) { this._context = context; }