using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace _30kSQL
{
    public partial class FrmMain : Form
    {

       private DataBase db = new DataBase();
       private SqlDataReader myReader;

        public FrmMain()
        {
            InitializeComponent();
        }


        private void button1_Click(object sender, EventArgs e)
        {

            db.ReadDB("Select * from monsterset where ssid >=30000", out myReader);

            while (myReader.Read())
            {
                db.WrtieDB("INSERT INTO monsterset([sSid],[sZone],[sMinX],[sMinY],[sMaxX],[sMaxY],[sNum],[sTableNum],[sRegenType],[sRegenTime],[sRegenEvent],[sGroup],[sGuild],[sGuildOpt],[sChat01],[sChat02],[sChat03],[sMaxItemNum],[sItem01],[sItem01Rand],[sItem02],[sItem02Rand],[sItem03],[sItem03Rand],[sItem04],[sItem04Rand],[sItem05],[sItem05Rand],[sItem06],[sItem06Rand],[sItem07],[sItem07Rand],[sItem08],[sItem08Rand],[sItem09],[sItem09Rand],[sItem10],[sItem10Rand],[sItem11],[sItem11Rand],[sItem12],[sItem12Rand],[sItem13],[sItem13Rand],[sItem14],[sItem14Rand],[sItem15],[sItem15Rand],[sEventNum],[sMoneyType],[sMoneyMin],[sMoneyMax]) VALUES ( " + myReader[GetFreeID(1,9999)] + "," + myReader["sZone"] + "," + myReader["sMinX"] + "," + myReader["sMinY"] + "," + myReader["sMaxX"] + "," + myReader["sMaxY"] + "," + myReader["sNum"] + "," + myReader["sTableNum"] + "," + myReader["sRegenType"] + "," + myReader["sRegenTime"] + "," + myReader["sRegenEvent"] + "," + myReader["sGroup"] + "," + myReader["sGuild"] + "," + myReader["sGuildOpt"] + "," + myReader["sChat01"] + "," + myReader["sChat02"] + "," + myReader["sChat03"] + "," + myReader["sMaxItemNum"] + "," + myReader["sItem01"] + "," + myReader["sItem01Rand"] + "," + myReader["sItem02"] + "," + myReader["sItem02Rand"] + "," + myReader["sItem03"] + "," + myReader["sItem03Rand"] + "," + myReader["sItem04"] + "," + myReader["sItem04Rand"] + "," + myReader["sItem05"] + "," + myReader["sItem05Rand"] + "," + myReader["sItem06"] + "," + myReader["sItem06Rand"] + "," + myReader["sItem07"] + "," + myReader["sItem07Rand"] + "," + myReader["sItem08"] + "," + myReader["sItem08Rand"] + "," + myReader["sItem09"] + "," + myReader["sItem09Rand"] + "," + myReader["sItem10"] + "," + myReader["sItem10Rand"] + "," + myReader["sItem11"] + "," + myReader["sItem11Rand"] + "," + myReader["sItem12"] + "," + myReader["sItem12Rand"] + "," + myReader["sItem13"] + "," + myReader["sItem13Rand"] + "," + myReader["sItem14"] + "," + myReader["sItem14Rand"] + "," + myReader["sItem15"] + "," + myReader["sItem15Rand"] + "," + myReader["sEventNum"] + "," + myReader["sMoneyType"] + "," + myReader["sMoneyMin"] + "," + myReader["sMoneyMax"] + ")", @"REMIX-5F7E6ACC\SQL", "soma", "soma", "soma");
                db.WrtieDB("delete from monsterset where ssid = " + myReader["sSid"], @"REMIX-5F7E6ACC\SQL", "soma", "soma", "soma");
             }
            this.Text = LB.Items.Count.ToString();
        }

        private int GetFreeID(int gStart,int gEnd)
        {
            List<int> MonsterID = new List<int>();
            bool FoundId =false;

            db.ReadDB("Select ssid from monsterset", out myReader);

            while (myReader.Read()){MonsterID.Add(Convert.ToInt32(myReader["sSID"]));}

            for (int a = gStart; a <= gEnd; a++)
            {
                for (int b = 0; b < MonsterID.Count; b++) {if (a == MonsterID[b]) { FoundId = true; break;}}
                if (FoundId == true) {FoundId = false;}else{return a;}
            }

            return 0;
        }

        private void FrmMain_Load(object sender, EventArgs e)
        {
            db.Connect(@"REMIX-5F7E6ACC\SQL", "soma", "soma", "soma");
        }

        private void button2_Click(object sender, EventArgs e)
        {
            System.Windows.Forms.MessageBox.Show(GetFreeID(600,9999).ToString());
        }
    }
}