public static void SaveToFile(UserLocalDB model) { string filePath = Utility.DataPathWithDirectory("LocalDB") + "/UserInfo." + ServerConstants.FILE_FORMAT; string rawData = JsonUtility.ToJson(model); File.WriteAllText(filePath, rawData); }
public bool pushUser(UserLocalDB userLocalDb) { conn.ConnectionString = conns; using (conn) { conn.Open(); SqlCommand cmd = new SqlCommand("sp_PushAccout", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@user", userLocalDb.username); cmd.Parameters.AddWithValue("@pass", userLocalDb.password); if (cmd.ExecuteNonQuery() == 1) { return(true); } } return(false); }
public bool updateUser(UserLocalDB userLocalDb, string oldUser) { conn.ConnectionString = conns; using (conn) { conn.Open(); SqlCommand cmd = new SqlCommand("sp_editData", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@oldUser", oldUser); cmd.Parameters.AddWithValue("@newUser", userLocalDb.username); cmd.Parameters.AddWithValue("@password", userLocalDb.password); if (cmd.ExecuteNonQuery() > 0) { return(true); } } return(false); }
bool ValidateCredetialsFromLocalDB(string _userName, string _passWord) { UserLocalDB localDB = ServerAPIHandler.Instance.userLocalDB; if (localDB.userInfoList != null) { for (int i = 0; i < localDB.userInfoList.Count; i++) { if (localDB.userInfoList[i].userName.Equals(_userName) && localDB.userInfoList[i].password.Equals(_passWord)) { return(true); } } } return(false); }
public static UserLocalDB LoadFromFile() { UserLocalDB _result = null; string filePath = Utility.DataPathWithDirectory("LocalDB") + "/UserInfo." + ServerConstants.FILE_FORMAT; if (File.Exists(filePath)) { string rawData = File.ReadAllText(filePath); _result = JsonUtility.FromJson <UserLocalDB> (rawData); } if (_result == null) { _result = new UserLocalDB(); } return(_result); }
void Init() { webRequestHandler = gameObject.AddComponent <webRequestHandler>(); serverStateManager = gameObject.AddComponent <ServerStateManager>(); userLocalDB = UserLocalDB.LoadFromFile(); }
static void Main(string[] args) { mulai: CRUDLocalDB crudLocalDb = new CRUDLocalDB(); UserLocalDB userLocalDb = new UserLocalDB(); Console.WriteLine("===== Menu CRUD with Console :v ====="); Console.WriteLine("============= CMD = Laki ============"); Console.WriteLine("Silahkan Pilih Menu :"); Console.WriteLine("1. select data"); Console.WriteLine("2. Insert"); Console.WriteLine("3. Update"); Console.WriteLine("4. Detele"); Console.Write("masukan pilihan : "); string pil = Console.ReadLine(); int a = 0; if (int.TryParse(pil, out a)) { switch (Int16.Parse(pil)) { case 1: Console.WriteLine("+++ Menu Insert +++"); crudLocalDb.showData(); break; case 2: Console.WriteLine("+++ Menu Select +++"); Console.Write("masukan Username : "******"masukan Password : "******"Insert Sukses"); } else { Console.WriteLine("Insert Sukses"); } crudLocalDb.pushUser(userLocalDb); break; case 3: Console.WriteLine("+++ Menu Update +++"); crudLocalDb.showData(); Console.Write("masukan username yang ingin di update : "); string oldUser = Console.ReadLine(); Console.Write("masukan username baru : "); userLocalDb.username = Console.ReadLine(); Console.Write("masukan password : "******"Account di update"); } else { Console.WriteLine("tidak ada account yang di update"); } break; case 4: Console.WriteLine("+++ Menu Hapus +++"); crudLocalDb.showData(); Console.Write("masukan username yang akan di hapus : "); string user = Console.ReadLine(); if (crudLocalDb.delUser(user)) { Console.WriteLine("user dihapus"); } else { Console.WriteLine("tidak ada user yang dihapus"); } break; default: Console.WriteLine(" --- anda tidak memasukan input dengan benar ---"); break; } } else { Console.WriteLine("anda tidak memasukan input dengan benar"); } Console.ReadLine(); Console.Clear(); goto mulai; }
public void Register() { // Regstration_API(); UserLocalDB localDB = ServerAPIHandler.Instance.userLocalDB; UserInfo userInfo = new UserInfo(); userInfo.userName = userName_reg.text; userInfo.password = password_reg.text; userInfo.firName = firName.text; userInfo.lastName = lastName.text; userInfo.SchoolName = SchoolName.text; if (password_reg.text.Equals(confirmPwd.text)) { if (localDB.userInfoList == null) { localDB.userInfoList = new List <UserInfo>(); } bool isUserAlreadyAvailable = false; for (int i = 0; i < localDB.userInfoList.Count; i++) { if (localDB.userInfoList[i].userName.Equals(userInfo.userName)) { isUserAlreadyAvailable = true; continue; } } if (!isUserAlreadyAvailable) { localDB.userInfoList.Add(userInfo); UserLocalDB.SaveToFile(localDB); signUpContent.SetActive(false); congratsContent.SetActive(true); userName_reg.text = string.Empty; password_reg.text = string.Empty; confirmPwd.text = string.Empty; firName.text = string.Empty; lastName.text = string.Empty;; SchoolName.text = string.Empty;; Debug.Log("registration successfull"); } else { reg_stutus.text = "User Available"; Debug.Log("user already available"); } } else { reg_stutus.text = "Password not matching"; Debug.Log("password missMatch"); } }