public User loginDA(User user) { PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> queryParameters = new Dictionary <string, SqlParameter>(); queryParameters["userName"] = new SqlParameter("userName", user.userName); queryParameters["password"] = new SqlParameter("password", hashedPassowrd); try { SqlDataReader reader = SqlDatabaseUtility.ExecuteQuery("[dbo].[Login]", queryParameters); while (reader.Read() == true) { if (reader.GetInt32(reader.GetOrdinal("id")) > 0) { user.id = reader.GetInt32(reader.GetOrdinal("id")); user.userName = reader.GetString(reader.GetOrdinal("userName")); user.role = reader.GetInt32(reader.GetOrdinal("role")); } else { user.userName = null; user.role = 0; } } } catch (Exception e) { Console.WriteLine("OOPs, something went wrong.\n" + e); } return(user); }
public void LoginCLI() { User user = new User(); PasswordProtection pp = new PasswordProtection(); AccountDA account = new AccountDA(); Console.WriteLine("--------- Welcome | Login the System to continue ----------"); Console.WriteLine(""); Console.WriteLine("User Name: "); user.userName = Console.ReadLine(); Console.WriteLine("Password: "******"successfully Login...!"); Console.Clear(); } else { Console.WriteLine("Invalied Login Attempt...!"); } }
public void UpdatePasswordCLI() { User user = new User(); UserDA userDA = new UserDA(); PasswordProtection pp = new PasswordProtection(); user.id = AccountCLI.currentUserID; Console.WriteLine("Enter your current password: "******"Enter Your New Password :"******"Re-Enter your new password : "******"oops, password you entered did not match- try again..."); Console.WriteLine(""); UpdatePasswordCLI(); } }
public AccountSettings(TimeSpan deleteDelay, int accountsPerIP = 1, int housesPerAccount = 2, int maxHousesPerAccount = 4, bool autoAccountCreation = true, bool restrictDeletion = true, PasswordProtection passwordProtection = PasswordProtection.NewCrypt) { this._AccountsPerIP = accountsPerIP; this._HousesPerAccount = housesPerAccount; this._MaxHousesPerAccount = maxHousesPerAccount; this._AutoAccountCreation = autoAccountCreation; this._RestrictDeletion = restrictDeletion; this._DeleteDelay = deleteDelay; this.m_PasswordProtection = passwordProtection; }
public AccountSettings(int accountsPerIP = 1, int housesPerAccount = 2, int maxHousesPerAccount = 4, bool autoAccountCreation = true, bool restrictDeletion = true, TimeSpan deleteDelay = TimeSpan.FromDays(7.0), PasswordProtection passwordProtection = PasswordProtection.NewCrypt) { this._AccountsPerIP = accountsPerIP; this._HousesPerAccount = housesPerAccount; this._MaxHousesPerAccount = maxHousesPerAccount; this._AutoAccountCreation = autoAccountCreation; this._RestrictDeletion = restrictDeletion; this._DeleteDelay = deleteDelay; this.m_PasswordProtection = passwordProtection; }
public void UpdateUserCLI() { User user = new User(); AdminDA admin = new AdminDA(); PasswordProtection pp = new PasswordProtection(); ExcuteAdminCLI excute = new ExcuteAdminCLI(); Console.WriteLine(""); Console.WriteLine("+++ Update User Details +++"); Console.WriteLine(""); ViewUserCLI(); Console.WriteLine(""); Console.WriteLine("enter user id that want to change details :"); user.id = Int32.Parse(Console.ReadLine()); Console.WriteLine("enter user name :"); user.userName = Console.ReadLine(); Console.WriteLine("enter user password :"******"enter user role :"); Console.WriteLine(""); Console.WriteLine("1 - admin"); Console.WriteLine("2 - Team Lead"); Console.WriteLine("3 - Normal Member"); Console.WriteLine(""); Console.WriteLine("Enter respective number : "); user.role = Int32.Parse(Console.ReadLine()); var msg = admin.UpdateUserDA(user); Console.WriteLine(msg); Console.Clear(); excute.HeaderInfo(); ViewUserCLI(); Console.WriteLine(""); Console.WriteLine("** press [Esc] back to menu"); var k = Console.ReadKey(true); if (k.Key == ConsoleKey.Escape) { Console.Clear(); excute.Header(); } }
public void CreateUsersCLI() { User user = new User(); AdminDA admin = new AdminDA(); PasswordProtection pp = new PasswordProtection(); ExcuteAdminCLI excute = new ExcuteAdminCLI(); Console.WriteLine(""); Console.WriteLine("+++ Add New User +++"); Console.WriteLine(""); Console.WriteLine("enter user name :"); user.userName = Console.ReadLine(); Console.WriteLine("enter user password :"******"enter user role :"); Console.WriteLine(""); Console.WriteLine("1 - admin"); Console.WriteLine("2 - Team Lead"); Console.WriteLine("3 - Normal Member"); Console.WriteLine(""); Console.WriteLine("Enter respective number : "); user.role = Int32.Parse(Console.ReadLine()); Console.WriteLine(""); Console.WriteLine("** press [Esc] to save and exit"); Console.WriteLine("** press [1] to save and add new user"); var k = Console.ReadKey(true); if (k.Key == ConsoleKey.Escape) { var msg = admin.CreateUsersDA(user); Console.WriteLine(msg); Console.Clear(); excute.Header(); } else if (k.Key == ConsoleKey.NumPad1 || k.Key == ConsoleKey.D1) { var mmsg = admin.CreateUsersDA(user); Console.WriteLine(mmsg); Console.Clear(); excute.HeaderInfo(); CreateUsersCLI(); } }
public AccountSettings( TimeSpan deleteDelay, int accountsPerIP = 1, int housesPerAccount = 2, int maxHousesPerAccount = 4, bool autoAccountCreation = true, bool restrictDeletion = true, PasswordProtection passwordProtection = PasswordProtection.NewCrypt) { AccountsPerIP = accountsPerIP; HousesPerAccount = housesPerAccount; MaxHousesPerAccount = maxHousesPerAccount; AutoAccountCreation = autoAccountCreation; RestrictDeletion = restrictDeletion; DeleteDelay = deleteDelay; PasswordProtection = passwordProtection; }
public sealed override void Deserialize(GenericReader reader) { int version = reader.ReadInt(); switch (version) { case 0: { this._AccountsPerIP = reader.ReadInt(); this._HousesPerAccount = reader.ReadInt(); this._MaxHousesPerAccount = reader.ReadInt(); this._AutoAccountCreation = reader.ReadBool(); this._RestrictDeletion = reader.ReadBool(); this._DeleteDelay = reader.ReadTimeSpan(); this.m_PasswordProtection = (PasswordProtection)reader.ReadByte(); break; } } }
public override void Deserialize(GenericReader reader) { int version = reader.ReadInt(); switch (version) { case 0: { AccountsPerIP = reader.ReadInt(); HousesPerAccount = reader.ReadInt(); MaxHousesPerAccount = reader.ReadInt(); AutoAccountCreation = reader.ReadBool(); RestrictDeletion = reader.ReadBool(); DeleteDelay = reader.ReadTimeSpan(); PasswordProtection = (PasswordProtection)reader.ReadByte(); } break; } }
public string UpdatePasswordDA(User user) { string msg = ""; PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["id"] = new SqlParameter("id", user.id); cmdParameters["password"] = new SqlParameter("password", hashedPassowrd); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[UpdateUsers]", cmdParameters); if (rc == -1) { msg = "Password updated successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }
public void DeleteUserCLI() { User user = new User(); AdminDA admin = new AdminDA(); PasswordProtection pp = new PasswordProtection(); ExcuteAdminCLI excute = new ExcuteAdminCLI(); Console.WriteLine(""); Console.WriteLine("+++ Delete User Details +++"); Console.WriteLine(""); ViewUserCLI(); Console.WriteLine(""); Console.WriteLine("enter user id that want to delete :"); user.id = Int32.Parse(Console.ReadLine()); var msg = admin.DeleteUserDA(user); Console.Clear(); excute.HeaderInfo(); Console.WriteLine(""); Console.WriteLine(msg); Console.WriteLine(""); ViewUserCLI(); Console.WriteLine(""); Console.WriteLine("** press [Esc] back to menu"); var k = Console.ReadKey(true); if (k.Key == ConsoleKey.Escape) { Console.Clear(); excute.Header(); } }
public string CreateUsersDA(User user) { string msg = ""; PasswordProtection pp = new PasswordProtection(); var hashedPassowrd = pp.GenerateSHA256(user.password); Dictionary <string, SqlParameter> cmdParameters = new Dictionary <string, SqlParameter>(); cmdParameters["userName"] = new SqlParameter("userName", user.userName); cmdParameters["password"] = new SqlParameter("password", hashedPassowrd); cmdParameters["role"] = new SqlParameter("role", user.role); int rc = SqlDatabaseUtility.ExecuteCommand("[dbo].[InsertUser]", cmdParameters); if (rc == -1) { msg = "user create successfully...!"; } else { msg = "OOPs, something went wrong...!"; } return(msg); }
public static void UpdateDBPasswords( ) { //Console.WriteLine( "Exporting New Passwords..." ); try { ArrayList ToUpdatePWFromUO = new ArrayList( ); OdbcConnection Connection = new OdbcConnection(ConnectionString); Connection.Open( ); OdbcCommand Command = Connection.CreateCommand( ); Command.CommandText = string.Format("SELECT name,password FROM {0} WHERE state='{1}'", DatabaseTable, ( int )Status.Active); OdbcDataReader reader = Command.ExecuteReader( ); QueryCount += 1; while (reader.Read( )) { string username = reader.GetString(0); string password = reader.GetString(1); Account AtoUpdate = Accounts.GetAccount(username) as Account; if (AtoUpdate != null) { PasswordProtection PWMode = AccountHandler.ProtectPasswords; string Password = ""; switch (PWMode) { case PasswordProtection.None: { Password = AtoUpdate.PlainPassword; } break; case PasswordProtection.Crypt: { Password = AtoUpdate.CryptPassword; } break; default: { Password = AtoUpdate.NewCryptPassword; } break; } if (Password == null || Password == "" || Password != password) { ToUpdatePWFromUO.Add(AtoUpdate); } } } reader.Close( ); //Console.WriteLine( "Updating Database..." ); foreach (Account a in ToUpdatePWFromUO) { PasswordProtection PWModeU = AccountHandler.ProtectPasswords; string PasswordU = ""; switch (PWModeU) { case PasswordProtection.None: { PasswordU = a.PlainPassword; } break; case PasswordProtection.Crypt: { PasswordU = a.CryptPassword; } break; default: { PasswordU = a.NewCryptPassword; } break; } QueryCount += 1; Command.CommandText = string.Format("UPDATE {0} SET state='{1}',password='******' WHERE name='{3}'", DatabaseTable, ( int )Status.Active, PasswordU, a.Username); Command.ExecuteNonQuery( ); } Connection.Close( ); Console.WriteLine("[{0} Database Passwords Changed] ", ToUpdatePWFromUO.Count); } catch (Exception e) { Console.WriteLine("[Database Password Change] Error..."); Console.WriteLine(e); } }
protected override sealed void Deserialize(GenericReader reader) { int version = reader.ReadInt(); switch (version) { case 0: { this._AccountsPerIP = reader.ReadInt(); this._HousesPerAccount = reader.ReadInt(); this._MaxHousesPerAccount = reader.ReadInt(); this._AutoAccountCreation = reader.ReadBool(); this._RestrictDeletion = reader.ReadBool(); this._DeleteDelay = reader.ReadTimeSpan(); this.m_PasswordProtection = (PasswordProtection)reader.ReadByte(); break; } } }
public static void CreateAccountsFromUO( ) { //Console.WriteLine( "Exporting New Accounts..." ); try { ArrayList ToCreateFromUO = new ArrayList( ); OdbcConnection Connection = new OdbcConnection(ConnectionString); Connection.Open( ); OdbcCommand Command = Connection.CreateCommand( ); Command.CommandText = string.Format("SELECT name FROM {0}", DatabaseTable); OdbcDataReader reader = Command.ExecuteReader( ); QueryCount += 1; while (reader.Read( )) { string username = reader.GetString(0); Account toCheck = Accounts.GetAccount(username) as Account; if (toCheck == null) { ToCreateFromUO.Add(toCheck); } } reader.Close( ); //Console.WriteLine( "Updating Database..." ); foreach (Account a in ToCreateFromUO) { int ALevel = 0; if (a.AccessLevel == AccessLevel.Player) { ALevel = 1; } else if (a.AccessLevel == AccessLevel.Counselor) { ALevel = 2; } else if (a.AccessLevel == AccessLevel.GameMaster) { ALevel = 3; } else if (a.AccessLevel == AccessLevel.Seer) { ALevel = 4; } else if (a.AccessLevel == AccessLevel.Administrator) { ALevel = 6; } PasswordProtection PWMode = AccountHandler.ProtectPasswords; string Password = ""; switch (PWMode) { case PasswordProtection.None: { Password = a.PlainPassword; } break; case PasswordProtection.Crypt: { Password = a.CryptPassword; } break; default: { Password = a.NewCryptPassword; } break; } QueryCount += 1; OdbcCommand InsertCommand = Connection.CreateCommand( ); InsertCommand.CommandText = string.Format("INSERT INTO {0} (name,password,email,access,timestamp,state) VALUES( '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", DatabaseTable, a.Username, Password, a.Email, ALevel, ToUnixTimestamp(a.Created), ( int )Status.Active); InsertCommand.ExecuteNonQuery( ); } Connection.Close( ); Console.WriteLine("[{0} Database Accounts Added] ", ToCreateFromUO.Count); } catch (Exception e) { Console.WriteLine("[Database Account Create] Error..."); Console.WriteLine(e); } }