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(); }