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