public void ItSplitsBasedOnCasing(string @in, string expected)
{
var @out = StringExtentions.SplitNameParts(@in);
var normed = string.Join("|", @out);
Assert.AreEqual(expected, normed);
}
internal static IList <string> GetTables(TextBox SQLServer, TextBox SQLUser, CheckBox SQLUseSQLAuth, string SQLPassword, DropDown SQLDatabase, out string errorMessage)
{
errorMessage = "";
try
{
if (StringExtentions.IsNullOrWhiteSpace(SQLServer.Value, SQLUser.Value, SQLDatabase.Value) == false &&
(SQLUseSQLAuth.Value == false || String.IsNullOrWhiteSpace(SQLPassword) == false))
{
using (SqlConnection connection = new SqlConnection(GetConnectionString(SQLServer.Value, SQLUser.Value, SQLPassword, SQLUseSQLAuth.Value, SQLDatabase.Value)))
{
connection.Open();
using (SqlCommand command = new SqlCommand("SELECT [TABLE_SCHEMA] + '.' + [TABLE_NAME] FROM INFORMATION_SCHEMA.TABLES ORDER BY [TABLE_SCHEMA], [TABLE_NAME]", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
var tables = new List <string>();
while (reader.Read())
{
tables.Add(reader.GetString(0));
}
return(tables);
}
}
}
}
SQLServer.HelpText = String.Empty;
}
catch (Exception ex)
{
errorMessage = "Unable to fetch list of Tables";
}
return(new List <string>());
}
internal static IList <string> GetDatabases(TextBox SQLServer, TextBox SQLUser, CheckBox SQLUseSQLAuth, string SQLPassword, out string errorMessage)
{
errorMessage = "";
try
{
if (StringExtentions.IsNullOrWhiteSpace(SQLServer.Value, SQLUser.Value) == false &&
(SQLUseSQLAuth.Value == false || String.IsNullOrWhiteSpace(SQLPassword) == false))
{
using (SqlConnection connection = new SqlConnection(GetConnectionString(SQLServer.Value, SQLUser.Value, SQLPassword, SQLUseSQLAuth.Value, null)))
{
connection.Open();
using (SqlCommand command = new SqlCommand("select name from sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb') ORDER BY name", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
var databases = new List <string>();
while (reader.Read())
{
databases.Add(reader.GetString(0));
}
return(databases);
}
}
}
}
SQLServer.HelpText = String.Empty;
}
catch (Exception ex)
{
errorMessage = "Unable to fetch list of Databases. Check the login details or try entering the Database name manually.";
}
return(new List <string>());
}
internal static List <string> GetTableTypeCoumns(TextBox SQLServer, TextBox SQLUser, CheckBox SQLUseSQLAuth, string SQLPassword, DropDown SQLDatabase, string SQLTableTypeName, out string errorMessage)
{
errorMessage = "";
try
{
if (StringExtentions.IsNullOrWhiteSpace(SQLServer.Value, SQLUser.Value, SQLDatabase.Value) == false &&
(SQLUseSQLAuth.Value == false || String.IsNullOrWhiteSpace(SQLPassword) == false))
{
using (SqlConnection connection = new SqlConnection(GetConnectionString(SQLServer.Value, SQLUser.Value, SQLPassword, SQLUseSQLAuth.Value, SQLDatabase.Value)))
{
connection.Open();
using (SqlCommand command = new SqlCommand("select c.name as column_name from sys.table_types t inner join sys.columns c on c.object_id = t.type_table_object_id inner join sys.types y on y.user_type_id = c.user_type_id where t.is_user_defined = 1 and t.is_table_type = 1 and t.name = '" + SQLTableTypeName + "'", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
var tables = new List <string>();
while (reader.Read())
{
tables.Add(reader.GetString(0));
}
return(tables);
}
}
}
}
SQLServer.HelpText = String.Empty;
}
catch (Exception ex)
{
errorMessage = "Unable to fetch list of user defined Table Type Columns";
}
return(new List <string>());
}
internal static IList <string> GetStoredProcs(TextBox SQLServer, TextBox SQLUser, CheckBox SQLUseSQLAuth, string SQLPassword, DropDown SQLDatabase, out string errorMessage)
{
errorMessage = "";
try
{
if (StringExtentions.IsNullOrWhiteSpace(SQLServer.Value, SQLUser.Value, SQLDatabase.Value) == false &&
(SQLUseSQLAuth.Value == false || String.IsNullOrWhiteSpace(SQLPassword) == false))
{
using (SqlConnection connection = new SqlConnection(GetConnectionString(SQLServer.Value, SQLUser.Value, SQLPassword, SQLUseSQLAuth.Value, SQLDatabase.Value)))
{
connection.Open();
using (SqlCommand command = new SqlCommand("select s.name+'.'+p.name as oname from sys.procedures p inner join sys.schemas s on p.schema_id = s.schema_id order by s.name, p.name", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
var procs = new List <string>();
while (reader.Read())
{
procs.Add(reader.GetString(0));
}
return(procs);
}
}
}
}
SQLServer.HelpText = String.Empty;
}
catch (Exception ex)
{
errorMessage = "Unable to fetch list of Stored Procedures";
}
return(new List <string>());
}
internal static IList <string> GetUserDefinedTableTypes(TextBox SQLServer, TextBox SQLUser, CheckBox SQLUseSQLAuth, string SQLPassword, DropDown SQLDatabase, out string errorMessage)
{
errorMessage = "";
try
{
if (StringExtentions.IsNullOrWhiteSpace(SQLServer.Value, SQLUser.Value, SQLDatabase.Value) == false &&
(SQLUseSQLAuth.Value == false || String.IsNullOrWhiteSpace(SQLPassword) == false))
{
using (SqlConnection connection = new SqlConnection(GetConnectionString(SQLServer.Value, SQLUser.Value, SQLPassword, SQLUseSQLAuth.Value, SQLDatabase.Value)))
{
connection.Open();
using (SqlCommand command = new SqlCommand("select name from sys.types where is_user_defined = 1 and is_table_type = 1", connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
var tables = new List <string>();
while (reader.Read())
{
tables.Add(reader.GetString(0));
}
return(tables);
}
}
}
}
SQLServer.HelpText = String.Empty;
}
catch (Exception ex)
{
errorMessage = "Unable to fetch list of user defined Table Types";
}
return(new List <string>());
}
/// <inheritdoc />
public CommandResult CheckValidCommand(string input)
{
var firstSpaceIndex = input.IndexOf(" ", StringComparison.Ordinal);
var inputCommand = string.Empty;
if (firstSpaceIndex > 0)
{
inputCommand = StringExtentions.OnlyFirstToUpperCase(input.Substring(0, firstSpaceIndex));
}
else
{
inputCommand = StringExtentions.OnlyFirstToUpperCase(input);
}
switch (inputCommand)
{
case "Place":
return(PlaceCommand(input.Trim().Substring(firstSpaceIndex + 1)));;
case "Move":
case "Left":
case "Right":
case "Report":
return(GeneralCommand(inputCommand));
default:
return(CommandResult.CreateFromFailure(CommandErrors.InvalidCommand, _invalidCommand));
}
}
internal static string NormalizeMethodName(string name)
{
var parts = StringExtentions.SplitNameParts(name);
var spacings = string.Join("\\s+", parts);
return(spacings);
}
/// <summary>
/// Checks valid Place command
/// </summary>
/// <param name="input">The X,Y coordinates with the Cardinal</param>
/// <returns>Commandvalidation</returns>
private CommandResult PlaceCommand(string input)
{
var command = Commands.Place;
string[] texts = input.Split(',');
if (texts.Length != 3)
{
return(CommandResult.CreateFromFailure(CommandErrors.InvalidParameters, _invalidParameters));
}
var xStringValue = texts[0].Trim();
var yStringValue = texts[1].Trim();
var facingValue = StringExtentions.AllToUppercase(texts[2]).Trim();
if (!xStringValue.All(char.IsDigit) || !yStringValue.All(char.IsDigit))
{
return(CommandResult.CreateFromFailure(CommandErrors.InvalidCoordinates, _invalidCoordinates));
}
if (!Enum.IsDefined(typeof(Facing), facingValue))
{
return(CommandResult.CreateFromFailure(CommandErrors.InvalidCarinal, _invalidCardinal));
}
return(CommandResult.CreateFromSuccess(command, input));
}
public void RandomOfLength_WhenCalled_ShouldReturnStringOfExpectedLength()
{
// Arrange
const int expected = 10;
// Act
var actual = StringExtentions.RandomOfLength(expected);
// Assert
Assert.AreEqual(expected, actual.Length);
}
public void ToDbPromocodeNotNullTest()
{
var value = new Promocode
{
Id = Guid.Parse("dc666524-36a3-43ef-998c-7f250793d9bc"),
CreateDate = "01.01.2020 10:10:10".GetUtcDateTime(),
EndDate = "01.01.2021 10:10:10".GetUtcDateTime(),
Deleted = false,
PromocodeValue = StringExtentions.NewPromocodeValue()
}.ToDbPromocode();
value.Should().NotBeNull();
}
public void PromocodeTest()
{
var promocode = new CrazyPrice.Common.Models.Promocode.Promocode
{
Id = Guid.Parse("dc666524-36a3-43ef-998c-7f250793d9bc"),
CreateDate = "01.01.2020 10:10:10".GetUtcDateTime(),
EndDate = "01.01.2021 10:10:10".GetUtcDateTime(),
Deleted = false,
PromocodeValue = StringExtentions.NewPromocodeValue()
};
promocode.CreateDate.Should().NotBeNull();
promocode.EndDate.Should().NotBeNull();
promocode.PromocodeValue.Should().NotBeNull();
promocode.Id.Should().NotBeEmpty();
promocode.Expired.Should().BeTrue();
promocode.Deleted.Should().BeFalse();
}
internal static List <SqlParameter> GetStoredProcParams(string SQLServer, string SQLUser, bool SQLUseSQLAuth, string SQLPassword, string SQLDatabase, string storedProcName)
{
if (StringExtentions.IsNullOrWhiteSpace(SQLServer, SQLUser, SQLDatabase) == false &&
(SQLUseSQLAuth == false || String.IsNullOrWhiteSpace(SQLPassword) == false))
{
using (SqlConnection connection = new SqlConnection(GetConnectionString(SQLServer, SQLUser, SQLPassword, SQLUseSQLAuth, SQLDatabase)))
{
SqlCommand cmd = new SqlCommand(storedProcName, connection)
{
CommandType = CommandType.StoredProcedure
};
cmd.Connection.Open();
SqlCommandBuilder.DeriveParameters(cmd);
return(cmd.Parameters.Cast <SqlParameter>().ToList());
}
}
return(new List <SqlParameter>());
}
public static byte[] qr_t(byte[] qr)
{
byte[] aes_ctr_key = StringExtentions.ToByteArray("0F8E2F405EAE51504EDBA7B4E297005B");
byte[] metadata_flags = new byte[0x8];
byte[] ctr_aes = new byte[0x10];
byte[] data = new byte[0x1CE];
byte[] sha1 = new byte[0x8];
Array.Copy(qr, 0, metadata_flags, 0, 0x8);
Array.Copy(qr, 0x8, ctr_aes, 0, 0x10);
Array.Copy(qr, 0x18, data, 0, 0x1CE);
Array.Copy(qr, 0x1E6, sha1, 0, 0x8);
IBufferedCipher cipher = CipherUtilities.GetCipher("AES/CTR/NoPadding");
cipher.Init(false, new ParametersWithIV(new KeyParameter(aes_ctr_key), ctr_aes));
return(cipher.ProcessBytes(data));
}
/// <inheritdoc />
public PlayerServiceResult PlacePlayer(string parameters)
{
string[] texts = parameters.Split(',');
var xPlayerPosition = Convert.ToInt32(texts[0].Trim());
var yPlayerPosition = Convert.ToInt32(texts[1].Trim());
var playerFacing = Enum.Parse <Facing>(StringExtentions.AllToUppercase(texts[2]).Trim());
var isValid = CheckValidPlacement(xPlayerPosition, yPlayerPosition);
if (!isValid)
{
return(PlayerServiceResult.CreateFromFailure(_invalidPlacing +
$"\n({_gameConfig.MinWidth},{_gameConfig.MinHeight}) ({_gameConfig.MaxWidth},{_gameConfig.MaxHeight})"));
}
SetPlayerPlacement(xPlayerPosition, yPlayerPosition, playerFacing);
_gameConfig.IsPlayerPlaced = true;
return(PlayerServiceResult.CreateFromSuccess());
}
internal static IList <DataColumn> GetColumns(string SQLServer, string SQLUser, bool SQLUseSQLAuth, string SQLPassword, string SQLDatabase, string SQLTable)
{
if (StringExtentions.IsNullOrWhiteSpace(SQLServer, SQLUser, SQLDatabase, SQLTable) == false &&
(SQLUseSQLAuth == false || String.IsNullOrWhiteSpace(SQLPassword) == false))
{
DataTable dt = new DataTable();
using (SqlConnection connection = new SqlConnection(GetConnectionString(SQLServer, SQLUser, SQLPassword, SQLUseSQLAuth, SQLDatabase)))
{
using (SqlDataAdapter a = new SqlDataAdapter(string.Format("SELECT * FROM {0}", SQLHelpers.AddTableQuotes(SQLTable)), connection))
{
a.FillSchema(dt, SchemaType.Source);
return(dt.Columns.Cast <DataColumn>().ToList());
}
}
}
else
{
return(new List <DataColumn>());
}
}
public void UserPromocodesTest()
{
var userPromocodes = new UserPromocodes()
{
UserId = Guid.Parse("675f0949-fd50-4738-92e2-9523ecc031d1"),
Promocodes = new List <CrazyPrice.Common.Models.Promocode.Promocode>()
{
new()
{
Id = Guid.Parse("dc666524-36a3-43ef-998c-7f250793d9bc"),
CreateDate = DateTime.UtcNow,
EndDate = DateTime.UtcNow,
Deleted = false,
PromocodeValue = StringExtentions.NewPromocodeValue()
}
}
};
userPromocodes.UserId.Should().NotBeEmpty();
userPromocodes.Promocodes.Should().NotBeNull();
}
public void DbPromocodeTest()
{
var usersPromocodes = DbPromocode.New(new Guid(), DateTime.Now, 1, StringExtentions.NewPromocodeValue());
usersPromocodes.Should().NotBeNull();
}
public static ClientContext GetClientContext(string siteUrl, string user, string password)
{
SecureString securePassword = StringExtentions.GetSecureString(password);
return(GetClientContext(siteUrl, user, securePassword));
}
