public void login(SubscribedUser user) { loggedInUser[user.getUsername()] = user; string username = user.getUsername(); string password = user.getPassword(); try { lock (connection) { connection.Open(); //SqlConnection connection = Connector.getInstance().getSQLConnection(); var c = connection.Query("SELECT username, password FROM [dbo].[Register] WHERE username=@username ", new { username = username }); //connection.Close(); if (Enumerable.Count(c) == 0) { throw new LoginException("Username " + user.getUsername() + "does not exist"); } connection.Close(); } } catch (Exception e) { if (e is ClientException) { throw e; } else { connection.Close(); SystemLogger.getErrorLog().Error("Connection error in function login in db subscribed user, user name: " + user.getUsername()); throw new ConnectionException(); } } }
public void login(String username, String password, Session session) { String encrypted = DBSubscribedUser.getInstance().encryptPassword(password); SubscribedUser sub = DBSubscribedUser.getInstance().getSubscribedUser(username); if (sub == null) { throw new LoginException("Username does not exist"); } SubscribedUser loggedIn = DBSubscribedUser.getInstance().getloggedInUser(username); if (loggedIn != null) { throw new LoginException("Username already logged in"); } if (!Equals(sub.getPassword(), encrypted)) { throw new LoginException("Incorrect password"); } session.setSubscribedUser(sub); if (Equals(username, "admin")) { session.setState(new Admin()); } else { session.setState(new LoggedIn()); } session.setShoppingBasket(sub.getShoppingBasket()); DBSubscribedUser.getInstance().login(sub); }
public void register(SubscribedUser user) { users.Add(user.getUsername(), user); string username = user.getUsername(); string password = user.getPassword(); try { lock (connection) { connection.Open(); //SqlConnection connection = Connector.getInstance().getSQLConnection(); var c = connection.Query("SELECT username, password FROM [dbo].[Register] WHERE username=@username ", new { username = username }); //connection.Close(); if (Enumerable.Count(c) == 0) { string sql = "INSERT INTO [dbo].[Register] (username, password)" + " VALUES (@username, @password)"; connection.Execute(sql, new { username, password }); } connection.Close(); } } catch (Exception e) { connection.Close(); SystemLogger.getErrorLog().Error("Connection error in function register in db subscribed user, user name: " + user.getUsername()); throw new ConnectionException(); } }
public void loginAfterRegister(String username, String password, Session session) { String encrypted = password; SubscribedUser sub = DBSubscribedUser.getInstance().getSubscribedUser(username); if (sub == null) { throw new LoginException("Error: Username does not exist"); } DBSubscribedUser.getInstance().updateStoreRole(sub); //SubscribedUser loggedIn = DBSubscribedUser.getInstance().getloggedInUser(username); //if( loggedIn != null) // throw new LoginException("Error: Username already logged in"); if (!Equals(sub.getPassword(), encrypted)) { throw new LoginException("Error: Incorrect password"); } ////////////erase // Store st = new Store("bb", "cc"); //DBStore.getInstance().addStore(st); ////////erase session.setSubscribedUser(sub); if (Equals(username, "u1")) { session.setState(new Admin()); } else { session.setState(new LoggedIn()); } session.setShoppingBasket(new ShoppingBasket(sub.getUsername())); session.setShoppingBasket(sub.getShoppingBasket()); DBSubscribedUser.getInstance().login(sub); }