private void LoadUserInList()
{
UserDBHelper dbVals = new UserDBHelper(this);
if (txtSearch.Text.Trim().Length < 1)
{
listItems = dbVals.GetAllUsers();
}
else
{
listItems = dbVals.GetUsersByName(txtSearch.Text.Trim());
}
lv.Adapter = new UserListBaseAdapter(this, listItems);
lv.ItemLongClick += lv_ItemLongClick;
}
private static void TestUserDB()
{
Console.WriteLine("It works!");
var db = new UserDBHelper();
{
bool run = true;
while (run)
{
Console.WriteLine(
"1. Add user\n" +
"2. Remove user by id\n" +
"3. Add to friends\n" +
"4. Remove from friends\n" +
"5. Print users\n" +
"6. Print relations\n" +
"7. Print user info");
var key = Console.ReadKey().Key;
Console.WriteLine();
switch (key)
{
case ConsoleKey.D1:
{
Console.WriteLine();
RandomUserRegistration(db.RegisterUserToTable,
db.RemoveUserByIdFromTable,
db.FindUserByNickname);
break;
}
case ConsoleKey.D2:
{
Console.WriteLine();
System.Int32 id;
Console.Write("Write id to delete: ");
var idStr = Console.ReadLine();
if (Int32.TryParse(idStr, out id))
{
db.RemoveUserByIdFromTable(id);
}
break;
}
case ConsoleKey.D3:
{
Int32 thisIdInt;
Int32 idToAddInt;
Console.Write("Write userid [who want to add]: ");
string thisIdString = Console.ReadLine();
if (thisIdString.Length > 0)
{
if (Int32.TryParse(thisIdString, out thisIdInt))
{
Console.Write("Write userid [whom want to add]: ");
string idToAddString = Console.ReadLine();
if (idToAddString.Length > 0)
{
if (Int32.TryParse(idToAddString, out idToAddInt))
{
if (thisIdInt != 0 && idToAddInt != 0)
{
db.AddUserToFriends(thisIdInt, idToAddInt);
}
}
else
{
Console.WriteLine($"Can't pasrse idToAddString: {idToAddString}");
}
}
}
else
{
Console.WriteLine($"Can't pasrse thisIdString: {thisIdString}");
}
}
break;
}
case ConsoleKey.D4:
{
Int32 thisIdInt;
Int32 idToRemoveInt;
Console.Write("Write userid [who want to remove]: ");
string thisIdString = Console.ReadLine();
if (thisIdString.Length > 0)
{
if (Int32.TryParse(thisIdString, out thisIdInt))
{
Console.Write("Write userid [whom want to remove]: ");
string idToRemoveString = Console.ReadLine();
if (idToRemoveString.Length > 0)
{
if (Int32.TryParse(idToRemoveString, out idToRemoveInt))
{
if (thisIdInt != 0 && idToRemoveInt != 0)
{
db.RemoveUserFromFriends(thisIdInt, idToRemoveInt);
}
}
else
{
Console.WriteLine($"Can't pasrse idToAddString: {idToRemoveString}");
}
}
}
else
{
Console.WriteLine($"Can't pasrse thisIdString: {thisIdString}");
}
}
break;
}
case ConsoleKey.D5:
{
Console.Clear();
Console.WriteLine("Users:");
var usersList = db.GetAllUsers();
foreach (var el in usersList)
{
Console.WriteLine($"{el.UserId} {el.FullName} {el.Nickname} {el.Email}");
}
break;
}
case ConsoleKey.D6:
{
Console.Clear();
Console.WriteLine("\nRelations:");
var friends = db.GetUsersFriendsTable(1);
Console.WriteLine("Frineds: ");
foreach (var friend in friends)
{
Console.WriteLine($"{friend.UserId} - {friend.FriendId}");
}
var followers = db.GetUsersFollowersTable(1);
Console.WriteLine("Followers: ");
foreach (var follower in followers)
{
Console.WriteLine($"{follower.UserId} - {follower.FollowerId}");
}
var followings = db.GetUsersFollowingsTable(1);
Console.WriteLine("Followings: ");
foreach (var following in followings)
{
Console.WriteLine($"{following.UserId} - {following.FollowingId}");
}
Console.WriteLine();
break;
}
case ConsoleKey.D7:
{
var usersInfo = db.GetAllUsersInfo();
//foreach (var user in usersInfo)
//{
// Console.WriteLine($"{user.Nickname} {user.UserId} {user.CoreId}");
//}
break;
}
case ConsoleKey.C: { Console.Clear(); break; }
case ConsoleKey.Escape: { run = false; break; }
default: { break; }
}
}
}
}
private static void TestGameDB()
{
var db = new UserDBHelper();
using (var gamedb = new GameDBHelper())
{
List <GameUnitsTable> GetCoreArmy(int coreId)
{
var result = new List <GameUnitsTable>();
var warriorUnit = gamedb.GetUnitProperty("Warrior");
var attackAircraftUnit = gamedb.GetUnitProperty("AttackAircraft");
var numberWarriors = gamedb.CasernGetNumberOfWarriors(coreId);
var numberAttackAircraft = gamedb.CasernGetNumberOfAttackAircraft(coreId);
for (int i = 0; i < numberWarriors; i++)
{
result.Add(
new GameUnitsTable()
{
GameUnitId = warriorUnit.GameUnitId,
GameUnitType = warriorUnit.GameUnitType,
GameUnitName = warriorUnit.GameUnitName,
GameUnitHP = warriorUnit.GameUnitHP,
GameUnitAttack = warriorUnit.GameUnitAttack,
GameUnitDefence = warriorUnit.GameUnitDefence,
GameUnitGoldIncome = warriorUnit.GameUnitGoldIncome,
GameUnitGoldOutcome = warriorUnit.GameUnitGoldOutcome
});
}
for (int i = 0; i < numberAttackAircraft; i++)
{
result.Add(new GameUnitsTable()
{
GameUnitId = attackAircraftUnit.GameUnitId,
GameUnitType = attackAircraftUnit.GameUnitType,
GameUnitName = attackAircraftUnit.GameUnitName,
GameUnitHP = attackAircraftUnit.GameUnitHP,
GameUnitAttack = attackAircraftUnit.GameUnitAttack,
GameUnitDefence = attackAircraftUnit.GameUnitDefence,
GameUnitGoldIncome = attackAircraftUnit.GameUnitGoldIncome,
GameUnitGoldOutcome = attackAircraftUnit.GameUnitGoldOutcome
});
}
return(result);
}
bool run = true;
while (run)
{
Console.WriteLine(
"1. Show all\n" +
"2. Show battle\n" +
"3. Random registration\n" +
"4. Show all cores\n" +
"5. Build casern test\n" +
"6. Core info\n"
);
var key = Console.ReadKey().Key;
Console.WriteLine();
switch (key)
{
case ConsoleKey.D1:
{
break;
}
case ConsoleKey.D2:
{
Console.WriteLine();
Console.WriteLine("Battle begins");
List <GameUnitsTable> attackers = GetCoreArmy(1);
List <GameUnitsTable> defenders = GetCoreArmy(2);
var result = 0; // GameEngine.Battle(attackers, defenders);
Console.WriteLine(result == 0 ?
"Attackers won the battle!" :
"Defenders won the battle!");
break;
}
case ConsoleKey.D3:
{
Console.WriteLine();
RandomUserRegistration(
db.RegisterUserToTable,
db.RemoveUserByIdFromTable,
db.FindUserByNickname);
break;
}
case ConsoleKey.D4:
{
Console.WriteLine();
Console.WriteLine("Cores: ");
var coreList = gamedb.GetAllCores()
.FromJson <List <SessionCoresTable> >();
foreach (var el in coreList)
{
var elmap = gamedb
.FindCoreMapByMapIdAsNoTracking(el.CoreMapId)
.FromJson <SessionMapTable>();
Console.WriteLine(
$"userid: {el.UserId} " +
$"mapid: {el.CoreMapId} "
+ $"map [{elmap.XCoord}, {elmap.YCoord}]"
);
}
break;
}
case ConsoleKey.D5:
{
Console.Clear();
Console.WriteLine("Build casern");
gamedb.CoreBuildCasern(1);
Console.Read();
break;
}
case ConsoleKey.D6:
{
Console.Clear();
Console.WriteLine("Core info");
var list = db.GetAllUsers();
foreach (var el in list)
{
var coreId = UserDBHelper.GetCoreIdByUserId(el.UserId);
if (coreId != -1)
{
var coreInfo = gamedb
.GetCoreInfoById(coreId)
.FromJson <CoreInfo>();
//var coreMap = gamedb
// .FindCoreMapByMapIdAsNoTracking(coreInfo.CoreMapId)
// .FromJson<SessionMapTable>();
//
//Console.WriteLine($"Core info [UserId={el.UserId}]");
//Console.WriteLine($"coreid: {coreInfo.CoreId} " +
// $"money: {coreInfo.Money} " +
// $"base capacity: {coreInfo.BaseCapacity}"+
// $"map[{coreMap.XCoord}, {coreMap.YCoord}]");
}
else
{
Console
.WriteLine($"Can not find core id for userid: {el.UserId}");
}
}
Console.WriteLine();
break;
}
case ConsoleKey.C: { Console.Clear(); break; }
case ConsoleKey.Escape: { run = false; break; }
default: { break; }
}
}
}
}