public MySqlDataReader executarConsulta(MySqlCommand cmm)
 {
     conectar();
     cmm.Connection = conn;
     try
     {
         dr = cmm.ExecuteReader();
     }
     catch (MySqlException ex)
     {
         dr.Dispose();
         throw ex;
     }
     return dr;
 }
示例#2
0
 private void updateData()
 {
     try
     {
         db.sql = $"select `date_create`, `transaction_name`,`cash`,`comment` from `income_transaction` where `income_id` = '{month + year}'";
         db.addCMD();
         MySql.Data.MySqlClient.MySqlDataReader r = db.cmd.ExecuteReader();
         bool flag = false;
         while (r.Read())
         {
             flag = true;
             int          cash = r.GetInt32(2);
             ListViewItem item = new ListViewItem(r.GetString(0));
             for (int i = 1; i < r.FieldCount; i++)
             {
                 item.SubItems.Add(r.GetValue(i).ToString());
             }
             cashDetailListView.Items.Add(item);
             if (r.GetString(1) == "member payment")
             {
                 memberIncome += cash;
             }
             else
             {
                 otherIncome += cash;
             }
             allIncome += cash;
             tt++;
         }
         if (!flag)
         {
             MessageBox.Show("NO ITEM HERE");
         }
         r.Dispose();
         db.disposeCmd();
         cashDetailTotalTbox.Text        = allIncome.ToString("N");
         cashDetailMemberIncomeTbox.Text = memberIncome.ToString("N");
         cashDetailTransTbox.Text        = tt.ToString();
         cashDetailOtherTbox.Text        = otherIncome.ToString("N");
         monthTbox.Text = $"{month} {year}";
     }
     catch (MySqlException err)
     {
         MessageBox.Show(err.Message, err.Number.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
        public void JsonSend(string[] jSon)
        {
            if (DataToConnect == null || !_isEnabled) return;
            try
            {

                if (jSon.Length != 4) throw new Exception("This is not property jSon data.");
                //Prepare a new _connection
                _connection = new MySqlConnection(DataToConnect);

                //open mysql client
                _connection.Open();

                string latin1Command1 = UTF8toLatin
                    ($"insert into dane(IDUrzadzenia, dane, czas, data) values('{jSon[0]}','{jSon[1]}','{jSon[2]}','{jSon[3]}');");
                _categoriesCommand = new MySqlCommand(latin1Command1, _connection);

                _reader = _categoriesCommand.ExecuteReader();
                while (_reader.Read())
                {
                }
                _reader.Dispose();

                SendMessage("Log sent to Remote database.");
            }
            catch
            {
                SendMessage("Can't connect to remote database! Check all.");
            }
        }
示例#4
0
    public static string ReadTotal(string query,string row,string morequery = null)
    {
        try{
            if (con.State.ToString() != "Open")
                con.Open();
            using(con){
                using(cmd = new MySqlCommand(query, con)){
                    rdr = cmd.ExecuteReader();

                    if(rdr.HasRows)
                        while (rdr.Read())
                            Debug.Log(rdr[row].ToString());
                    rdr.Dispose();
                }
            }
        }
        catch (Exception ex){
            return ex.ToString();
        }
        return "";
    }
示例#5
0
	// Read all entries from the table
	void ReadEntries()
	{
		string query = string.Empty;
		if (_GameItems == null)
			_GameItems = new List<data>();
		if (_GameItems.Count > 0)
			_GameItems.Clear();
		// Error trapping in the simplest form
		try
		{
			query = "SELECT * FROM view_demo";
			if (con.State.ToString() != "Open")
				con.Open();
			using (con)
			{
				using (cmd = new MySqlCommand(query, con))
				{
					rdr = cmd.ExecuteReader();
					if (rdr.HasRows)
						while (rdr.Read())
					{
						data itm = new data();
						itm.UID = int.Parse(rdr["iddemo_table"].ToString());
						itm.ID = rdr["ID"].ToString();
						itm.levelname = rdr["levelname"].ToString();
						itm.Name = rdr["Name"].ToString();
						itm.objectType = rdr["objectType"].ToString();
						itm.posx = float.Parse(rdr["posx"].ToString());
						itm.posy = float.Parse(rdr["posy"].ToString());
						itm.posz = float.Parse(rdr["posz"].ToString());
						itm.tranx = float.Parse(rdr["tranx"].ToString());
						itm.trany = float.Parse(rdr["trany"].ToString());
						itm.tranz = float.Parse(rdr["tranz"].ToString());
						_GameItems.Add(itm);
					}
					rdr.Dispose();
				}
			}
		}
		catch (Exception ex)
		{
			Debug.Log(ex.ToString());
		}
		finally
		{
		}
	}
示例#6
0
    void LogIn(NetworkMessage netMsg, InfoMessage msg)
    {
        bool loggedIn = false;
        string query = "SELECT * FROM shogi.players WHERE players_email = \"" + msg.email + "\"";
        if (con.State.ToString () != "Open")
            con.Open ();

        using (con) {

            using (cmd = new MySqlCommand (query, con)) {
                rdr = cmd.ExecuteReader();
                if (rdr.HasRows) {
                    rdr.Read ();
                    if (msg.password == rdr["players_password"].ToString ()) {
                        incomeMessages.text += netMsg.conn.address + " logged in as " + msg.email + "\n";
                        loggedIn = true;
                    }
                    else
                        incomeMessages.text += netMsg.conn.address + " failed logging in for wrong password " + msg.password + "\n";
                }
                else
                    incomeMessages.text += netMsg.conn.address + " failed logging in for no entry " + msg.email + "\n";
                rdr.Dispose ();
            }

            string queryIP = "UPDATE shogi.players SET players_ip = \"" + netMsg.conn.address + "\" WHERE players_email = \"" + msg.email + "\"";
            if (loggedIn) {
                using (cmd = new MySqlCommand (queryIP, con))
                    cmd.ExecuteNonQuery ();
                msg.goal = "loggedin";
                NetworkServer.SendToClient(netMsg.conn.connectionId, MyMsgType.Info, msg);
            }
        }
    }
示例#7
0
        public MySqlDataReader executarConsulta(string pSql)
        {
            conectarDB();
            cmm = new MySqlCommand(pSql, conn);

            try
            {
                dr = cmm.ExecuteReader();
            }
            catch (MySqlException ex)
            {
                dr.Dispose();
                throw ex;
            }

            return dr;
        }
示例#8
0
        /// <summary>
        /// Load gamestate from current player
        /// </summary>
        /// <param name="result"></param>
        public void LoadGameState(MySqlDataReader result)
        {
            result.Read();

            player.Gold = result.GetInt32(1);
            this.turn = result.GetInt32(2);
            List<Cargo> clist = player.GetPlayersCargoList();
            int i = 3;
            foreach (Cargo cargo in player.GetPlayersCargoList())
            {
                cargo.Amount = result.GetInt32(i);
                i++;
            }

            foreach (Port port in portList)
            {
                i=12;
                foreach (Cargo cargo in port.GetPortsCargoList())
                {
                    cargo.Price = result.GetInt32(i);
                    i++;
                }
            }

            result.Dispose();
        }