internal void AssignToClinic(Clinic clinic)
{
this.myClinic = clinic;
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE))
{
cmd.Update("users")
.Set("ClinicId", myClinic.ClinicName1)
.Where("Username", UserId1);
cmd.Execute();
}
}
/// <summary>
/// Console commands that makes user do stuff
/// </summary>
/// <param name="command">the command</param>
public static void CommandsAI(string command)
{
if (command == null)
{
return;
}
GSLog += command;
if (command.StartsWith("#"))
{
string[] data = command.Split(' ');
IniFile file = new IniFile(Paths.SetupConfigPath);
if (AccountsTable.IsAdmin())
{
switch (data[0])
{
//TODO add more and more and more commands for admins
#region Add new account
case "#addacc":
{
try
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT);
cmd.Insert("accounts")
.Insert("Username", data[1])
.Insert("Password", Core.GetSHAHashData(data[2]))
.Insert("State", data[3])
.Insert("Phone", data[4])
.Execute();
WriteLine("You add a new user " + data[1]);
}
catch (Exception e)
{
WriteLine("There is something wrong maybe the username is already used.");
Core.SaveException(e);
}
break;
}
#endregion
#region Add new drug
case "#adddrug":
{
try
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT);
cmd.Insert("medics")
.Insert("Name", data[1])
.Insert("Barcode", data[2])
.Insert("ScientificName", data[3])
.Insert("Supplier", data[4])
.Insert("ExpirationDate", data[5])
.Insert("Type", data[6])
.Insert("Total", Convert.ToDecimal(data[7]))
.Insert("BPrice", Convert.ToDecimal(data[8]))
.Insert("SPrice", Convert.ToDecimal(data[9]))
.Insert("Notes", data[10]).Execute();
WriteLine(AccountsTable.UserName + " add " + data[6] + " " + data[1] + " which each cost " + data[7]);
}
catch (Exception e)
{
WriteLine("There is something wrong maybe the drug is already exist.");
Core.SaveException(e);
}
break;
}
#endregion
#region Delete table or database
case "#Drop":
{
if (data[1] == "db")
{
string Ddb = "DROP DATABASE IF EXISTS `" +
Core.INIDecrypt(file.ReadString("MySql", "Database")) + "`;";
using (var conn = DataHolder.MySqlConnection)
{
using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand())
{
cmd.Connection = conn;
conn.Open();
string db = MySql.Data.MySqlClient.QueryExpress.ExecuteScalarStr(cmd, Ddb);
if (string.IsNullOrEmpty(db))
{
return;
}
conn.Dispose();
conn.Close();
File.Delete(Paths.SetupConfigPath);
}
}
}
else if (data[1] == "table")
{
string Dtab = "DROP TABLE `" + data[2] + "`;";
try
{
using (var conn = DataHolder.MySqlConnection)
{
using (MySql.Data.MySqlClient.MySqlCommand mCmd = new MySql.Data.MySqlClient.MySqlCommand(Dtab, conn))
{
mCmd.ExecuteNonQuery();
}
conn.Close();
}
}
catch (Exception e)
{
WriteLine("Maybe you entered a wrong table name");
Core.SaveException(e);
}
}
break;
}
#endregion
#region Insert medics to the table
case "#import":
{
try
{
Thread th = new Thread(() =>
{
var newPath = data[1].Contains("~") ? data[1].Replace("~", " ") : data[1];
Write("Importing [----------] " + progress + "%");
IsProgressing = true;
var lines = File.ReadAllLines(newPath).Count();
var currentLine = 0;
using (StreamReader sr = File.OpenText(newPath))
{
StringBuilder sb = new StringBuilder();
while (sb.Append(sr.ReadLine()).Length > 0)
{
retry:
try
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT)
{
Command = sb.ToString()
};
cmd.Execute();
}
catch
{
sb.Replace("INSERT INTO `medics`", "INSERT IGNORE INTO `medics`");
goto retry;
}
finally
{
progress = (currentLine * 100) / lines;
currentLine++;
sb.Clear();
}
}
sr.Dispose();
sr.Close();
}
WriteLine("The file is well imported");
});
th.Start();
}
catch (Exception e)
{
WriteLine("Are you 100% sure that is a MySQL file/n" + e);
}
IsProgressing = false;
break;
}
#endregion
#region Delete config folder
case "#deltemp":
{
if (data.Length >= 2)
{
if (data[1] == "-all")
{
try
{
if (
Directory.Exists(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW"))
{
Directory.Delete(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW");
WriteLine("You just deleted everything the program stand for \nI hope you are happy");
}
}
catch (Exception e)
{
WriteLine("Maybe the folder isn't there so stop trying to delete it");
Core.SaveException(e);
}
}
}
else
{
try
{
if (
File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\BackupConfig.ini"))
{
File.Delete(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\BackupConfig.ini");
}
if (
File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\Configuration.ini"))
{
File.Delete(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\Configuration.ini");
}
WriteLine("You just deleted the config files");
}
catch (Exception e)
{
WriteLine("Maybe the files are not there so stop trying to delete them");
Core.SaveException(e);
}
}
break;
}
#endregion
case "#help":
{
WriteLine("Here is some Commands\r#addacc Username Password State(type 2 for admin - 1 for employee) PhoneNumber(could be empty -type null-)\r#adddrug Name Barcode(Could be empty -type null-) ScientificName(Could be empty -type null-) Supplier(Could be empty -type null-) ExpirationDate(should be yyyy/mm/dd) Type(type 1 for syrup - 2 for tab - 3 Injection - 4 for Cream/Ointments - 0 for other) Total(must be numbers) BPrice(must be numbers) SPrice(must be numbers) Notes(Could be empty -type null-)\r#Drop db (to delete your database good luck with that)\r#Drop table tablename (delete a spacific table to ruin the database)\r#import path (type the full path for the sql file to import it like c:\\meds.sql)\r#deltemp (type '-all' to delete the config folder with backups files like #deltemp -all)");
break;
}
default:
{
WriteLine("This command shall not execute");
break;
}
}
}
else
{
switch (data[0])
{
//TODO add more and more and more commands for the rest
#region Delete config folder
case "#deltemp":
{
try
{
if (File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\BackupConfig.ini"))
{
File.Delete(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\BackupConfig.ini");
}
if (File.Exists(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\Configuration.ini"))
{
File.Delete(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\PPHMW\\Configuration.ini");
}
WriteLine("You just deleted the config files");
}
catch (Exception e)
{
WriteLine("Maybe the files are not there so stop trying to delete them");
Core.SaveException(e);
}
break;
}
#endregion
case "#help":
{
WriteLine("Here is some Commands\r#deltemp delete the config files");
break;
}
default:
{
WriteLine("This command shall not execute");
break;
}
}
}
}
else
{
WriteLine("You must start your command with # like #help .");
}
}
public static bool SaveEntity(Client.GameClient c, MySql.Data.MySqlClient.MySqlConnection conn)
{
try
{
if (c == null)
{
return(false);
}
var e = c.Entity;
if (e == null)
{
return(false);
}
#region Battles
if (e.Battles != null)
{
System.IO.MemoryStream stream = new System.IO.MemoryStream();
System.IO.BinaryWriter writer = new System.IO.BinaryWriter(stream);
writer.Write(e.Battles.Count);
foreach (var battle in e.Battles)
{
writer.Write((byte)battle.GameMode);
writer.Write(battle.Won);
writer.Write(battle.Kills);
writer.Write(battle.Deaths);
}
string SQL = "UPDATE `characters` SET Battles=@battles where UID = " + e.UID + " ;";
byte[] rawData = stream.ToArray();
using (var con = Program.MySqlConnection)
{
con.Open();
using (var cmd = new MySql.Data.MySqlClient.MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@battles", rawData);
cmd.ExecuteNonQuery();
}
}
}
#endregion
#region Settings
{
string SQL = "UPDATE `characters` SET Settings=@settings where UID = " + e.UID + " ;";
using (var con = Program.MySqlConnection)
{
con.Open();
using (var cmd = new MySql.Data.MySqlClient.MySqlCommand())
{
cmd.Connection = con;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@settings", e.Settings);
cmd.ExecuteNonQuery();
}
}
}
#endregion
using (var cmd = new MySqlCommand(MySqlCommandType.UPDATE).Update("characters"))
{
cmd.Set("Experience", e.Experience);
cmd.Set("Name", e.Name);
cmd.Set("Clan", e.Clan);
cmd.Set("HeadshotKills", e.HeadshotKills);
cmd.Set("GeneradeKills", e.GeneradeKills);
cmd.Set("KnifeKills", e.KnifeKills);
cmd.Set("TeamKills", e.TeamKills);
cmd.Set("VIP", e.VIP);
cmd.Set("Deserion", e.Deserion);
cmd.Set("GP", e.GP);
cmd.Set("ZP", e.ZP);
cmd.Set("MP", e.MP);
cmd.Where("UID", e.UID);
cmd.Execute();
}
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}