Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public bool CreateLogin(string login, string pass, int quota)
- {
- NpgsqlConnectionStringBuilder builder = new NpgsqlConnectionStringBuilder(conn.ConnectionString);
- Byte[] array = builder.PasswordAsByteArray;
- String usernameFromBuilder = builder.UserName;
- String passwordFromBuilder = String.Empty;
- foreach (Byte b in array)
- {
- passwordFromBuilder = passwordFromBuilder + Convert.ToChar(b).ToString();
- }
- try
- {
- NpgsqlCommand loginCommand = new NpgsqlCommand("SELECT CreateUser (@login,@pass,@dbUser,@dbPassword)", conn);
- NpgsqlParameter loginPar = new NpgsqlParameter("@login", login);
- NpgsqlParameter passPar = new NpgsqlParameter("@pass", pass);
- NpgsqlParameter dbUserPar = new NpgsqlParameter("@dbUser", usernameFromBuilder);
- NpgsqlParameter dbPasswordPar = new NpgsqlParameter("@dbPassword", passwordFromBuilder);
- loginCommand.Parameters.Add(loginPar);
- loginCommand.Parameters.Add(passPar);
- loginCommand.Parameters.Add(dbUserPar);
- loginCommand.Parameters.Add(dbPasswordPar);
- loginCommand.ExecuteNonQuery();
- return true;
- }
- catch (NpgsqlException e)
- {
- new XML_Action().InsertAction(DateTime.Now, this.GetType().Name + "_" + MethodBase.GetCurrentMethod().Name, e.ToString(), "SERVER_ERROR");
- return false;
- }
- }
- public bool DeleteLogin(string login)
- {
- NpgsqlConnectionStringBuilder builder = new NpgsqlConnectionStringBuilder(conn.ConnectionString);
- Byte[] array = builder.PasswordAsByteArray;
- String usernameFromBuilder = builder.UserName;
- String passwordFromBuilder = String.Empty;
- foreach (Byte b in array)
- {
- passwordFromBuilder = passwordFromBuilder + Convert.ToChar(b).ToString();
- }
- try
- {
- NpgsqlCommand loginCommand = new NpgsqlCommand("SELECT DropUser (@login,@dbUser,@dbPassword)", conn);
- NpgsqlParameter loginPar = new NpgsqlParameter("@login", login);
- NpgsqlParameter dbUserPar = new NpgsqlParameter("@dbUser", usernameFromBuilder);
- NpgsqlParameter dbPasswordPar = new NpgsqlParameter("@dbPassword", passwordFromBuilder);
- loginCommand.Parameters.Add(loginPar);
- loginCommand.Parameters.Add(dbUserPar);
- loginCommand.Parameters.Add(dbPasswordPar);
- loginCommand.ExecuteNonQuery();
- return true;
- }
- catch (NpgsqlException e)
- {
- new XML_Action().InsertAction(DateTime.Now, this.GetType().Name + "_" + MethodBase.GetCurrentMethod().Name, e.ToString(), "SERVER_ERROR");
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement