예제 #1
0
        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();
            }
        }
예제 #2
0
        /// <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 .");
            }
        }
예제 #3
0
 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);
     }
 }