public static void SavePlayerData(string name, string pass, bool isUpdate = false)
{
DateTime dateNow = DateTime.UtcNow;
PlayerData data = new PlayerData();
data.Store(name, pass, dateNow);
players.Add(data);
var db = "GoC.sqlite";
var playerSaver = new DataSaver().DataBase(db);
var command1 = "PlayersData (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,Name TEXT NOT NULL,Password TEXT NOT NULL, `Date` TEXT NOT NULL, `LatestDate` TEXT,Kingdom TEXT, Score INTEGER DEFAULT 0);";
var command2 = String.Format("PlayersData (Name, Password, Date, LatestDate, Kingdom) VALUES ('{0}', '{1}', '{2}', '{3}', 'Default');", data.Name, data.Password, data.playDate.ToString(), data.playDate.ToString());
if (isUpdate)
{
command2 = String.Format("PlayersData SET LatestDate = '{0}' WHERE Name='{1}';", DateTime.UtcNow.ToString(), name);
}
playerSaver.Open();
playerSaver.CreateTable(command1);
if (isUpdate)
{
playerSaver.Update(command2);
}
else
{
playerSaver.Insert(command2);
}
playerSaver.Close();
}
/* Gombbal mentés
* private void Save_Data(object sender, RoutedEventArgs e)
* {
* DataSaver dsb = new DataSaver("D:\\dev\\LibraryBookManagementApp\\docs\\konyvek.txt");
* foreach (var item in books)
* {
* dsb.WriteLine($"{item.BookId};{item.BookAuthor};{item.BookTitle};{item.BookReleaseDate};{item.BookPublisher};{item.IsRentable}");
* }
* dsb.Close();
*
* DataSaver dsm = new DataSaver("D:\\dev\\LibraryBookManagementApp\\docs\\tagok.txt");
* foreach (var item in members)
* {
* dsm.WriteLine($"{item.MemberId};{item.MemberName};{item.MemberBirth};{item.MemberZip};{item.MemberCity};{item.MemberStreet}");
* }
* dsm.Close();
*
* DataSaver dsr = new DataSaver("D:\\dev\\LibraryBookManagementApp\\docs\\kolcsonzesek.txt");
* foreach (var item in rents)
* {
* dsr.WriteLine($"{item.RentId};{item.RentMemberId};{item.RentBookId};{item.RentDate};{item.RentEndDate}");
* }
* dsr.Close();
*
* DataSaver dso = new DataSaver("D:\\dev\\LibraryBookManagementApp\\docs\\lejartkolcsonzesek.txt");
* foreach (var item in outdatedRents)
* {
* dso.WriteLine($"{item.RentId};{item.RentMemberId};{item.RentBookId};{item.RentDate};{item.RentEndDate}");
* }
* dso.Close();
* }*/
private void Window_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
DataSaver dsb = new DataSaver(".\\docs\\konyvek.txt");
foreach (var item in books)
{
dsb.WriteLine($"{item.BookId};{item.BookAuthor};{item.BookTitle};{item.BookReleaseDate};{item.BookPublisher};{item.IsRentable}");
}
dsb.Close();
DataSaver dsm = new DataSaver(".\\docs\\tagok.txt");
foreach (var item in members)
{
dsm.WriteLine($"{item.MemberId};{item.MemberName};{item.MemberBirth};{item.MemberZip};{item.MemberCity};{item.MemberStreet}");
}
dsm.Close();
DataSaver dsr = new DataSaver(".\\docs\\kolcsonzesek.txt");
foreach (var item in rents)
{
dsr.WriteLine($"{item.RentId};{item.RentMemberId};{item.RentBookId};{item.RentDate};{item.RentEndDate}");
}
dsr.Close();
DataSaver dso = new DataSaver(".\\docs\\lejartkolcsonzesek.txt");
foreach (var item in outdatedRents)
{
dso.WriteLine($"{item.RentId};{item.RentMemberId};{item.RentBookId};{item.RentDate};{item.RentEndDate}");
}
dso.Close();
}
bool CheckIfNameExist()
{
var db = "GoC.sqlite";
var nameChecker = new DataSaver().DataBase(db);
var command = String.Format("* FROM PlayersData WHERE Name='{0}'", playerName);
var command1 = "PlayersData (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,Name TEXT NOT NULL,Password TEXT NOT NULL, `Date` TEXT NOT NULL, `LatestDate` TEXT,Kingdom TEXT, Score INTEGER DEFAULT 0);";
nameChecker.Open();
nameChecker.CreateTable(command1);
var reader = nameChecker.Select(command);
if (reader.Read())
{
nameChecker.Close();
return(true);
}
nameChecker.Close();
return(false);
}
public static void ChangeKingdom(string kingdom)
{
var db = "GoC.sqlite";
var playerSaver = new DataSaver().DataBase(db);
var name = GameManager.GetActivePlayer().Name;
playerSaver.Open();
var command = "PlayersData SET Kingdom='" + kingdom + "' WHERE Name='" + name + "';";
playerSaver.Update(command);
playerSaver.Close();
}
