namespace IntroSpace.Формы_проекта
{
    public partial class Planet_Form : Form
    {
        //Переменные формы
        protected Planet planet;

        //Конструкторы
        public Planet_Form()
        {
            InitializeComponent();
            this.comboBox1.Items.AddRange(new object[] {
                "Органическая углеродно-кислородная",
                "Органическая фосфор-азотная",
                "Неорганическая"});
        }

        public Planet_Form(Planet aPlanet) {
            InitializeComponent();
            this.comboBox1.Items.AddRange(new object[] {
                "Органическая углеродно-кислородная",
                "Органическая фосфор-азотная",
                "Неорганическая"});
            this.planet = aPlanet;
            this.FillControlsWithObjectData();
        }

        private void FillControlsWithObjectData() {
            this.textBoxID.Text = this.planet.GetGUID();
            this.textBoxName.Text = this.planet.GetName();
            this.comboBox1.SelectedIndex = this.comboBox1.FindString(this.planet.GetLifeForm());
            this.textBoxGravity.Text = this.planet.GetGravity().ToString();
            this.textBoxDayDur.Text = this.planet.GetDayDuration().ToString();
            this.textBoxYearDur.Text = this.planet.GetYearDuration().ToString();
            this.textBoxDistFromStar.Text = this.planet.GetDistanceFromStar().ToString();
            this.Show();
        }

        //Методы
        private void buttonSAVE_Click(object sender, EventArgs e)
        {
            if (this.planet.Save()) this.Dispose();
            else MessageBox.Show("Не удалось сохранить");
        }
    }
}

namespace IntroSpace{
    public class Planet{
        //Константы класса
        public struct LifeForms{
            public const string LIFE_FORM_CARBON_OXYGEN = "Органическая углеродно-кислородная";
            public const string LIFE_FORM_PHOSPHORUS_NITROGEN = "Органическая фосфор-азотная";
            public const string LIFE_FORM_NON_ORGANICAL = "Неорганическая";
        }

        //Переменные класса
        protected bool isNew;
        protected string guid;
	protected string name;
        protected string lifeForm;
	protected int gravityG;
	protected int dayDurationHours;
	protected int yearDurationDays;
	protected int distanceFromStarKm;

	    //Конструкторы класса
	    public Planet() {
            this.AssumeGUID();
	    }

        public Planet(string aName, string aLifeForm) {
            this.AssumeGUID();
            this.name = aName;
		    this.lifeForm = aLifeForm;
            this.isNew = true;
	    }

        //Методы класса
        private void AssumeGUID() {
            this.guid = System.Guid.NewGuid().ToString().ToUpper();
        }
        
        public string GetGUID() { return this.guid; }
        public string GetName() { return this.name; }
        public string GetLifeForm() { return this.lifeForm; }
        public int GetGravity() { return this.gravityG; }
        public int GetDayDuration() { return this.dayDurationHours; }
        public int GetYearDuration() { return this.yearDurationDays; }
        public int GetDistanceFromStar() { return this.distanceFromStarKm; }

        public void GetGUID(string a) { this.guid = a; }
        public void GetName(string a) { this.name = a; }
        public void GetLifeForm(string a) { this.lifeForm = a; }
        public void GetGravity(int a) { this.gravityG = a; }
        public void GetDayDuration(int a) { this.dayDurationHours = a; }
        public void GetYearDuration(int a) { this.yearDurationDays = a; }
        public void GetDistanceFromStar(int a) { this.distanceFromStarKm = a; }
        
        public Boolean Save() {
            if (this.isNew) {
                string sql;
                sql = "INSERT INTO PLANETS(ID_PLANETS, NAME_PLANETS, LIFEFORM_PLANETS, GRAVITY_PLANETS, DAYDURATION_PLANETS, YEARDURATION_PLANETS, DISTANCEFROMSTAR_PLANETS) "
                    + "VALUES('" + this.guid + "', "
                    + "'" + this.name + "', "
                    + "'" + this.lifeForm + "', "
                    + "" + this.gravityG.ToString() + ", "
                    + "" + this.dayDurationHours.ToString() + ", "
                    + "" + this.yearDurationDays.ToString() + ", "
                    + "" + this.distanceFromStarKm.ToString() + ")";
                
                if (Globals.DATABASE.Execute(sql)) return true;
                else return false;
            }
            else {
                return false;
            }
            return false;
        }
    }
}

namespace IntroSpace {
    class FBDB {
        protected FbConnection fbDB;
        protected FbDataReader recordSet;

        public FBDB() {
            string connectionString = @"character set=WIN1251;data source=localhost;initial catalog=d:\SysFolder\Documents\Visual Studio 2012\Projects\Космос\IntroSpace\bin\Debug\db.fdb;user id=SYSDBA;password=masterkey";
            try {
                this.fbDB = new FbConnection(connectionString.ToString());
                this.fbDB.Open();
            }
            catch (Exception ex) {
                MessageBox.Show("Ошибка подключения к базе данных: " + ex.Message.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }

        ~FBDB() {
            try { this.fbDB.Close(); RAM.Clear(); }
            catch (Exception ex) { };
        }

.......

        public bool Execute(string sql) {
            // Здесь fbBD - объект типа FbConnection
            try {
                FbTransaction transact = this.fbDB.BeginTransaction();
                FbCommand sqlReqest = new FbCommand(sql, this.fbDB, transact);
                transact.Commit();
                return true;
            }
            catch (Exception ex) {
                MessageBox.Show(ex.Message);
                return false;
            }
        }
    }
}

        private void buttonSAVE_Click(object sender, EventArgs e)
        {
            if (this.planet.Save()) this.Dispose();
            else MessageBox.Show("Не удалось сохранить");
        }

        public Boolean Save() {
            if (this.isNew) {
                string sql;
                sql = "INSERT INTO PLANETS(ID_PLANETS, NAME_PLANETS, LIFEFORM_PLANETS, GRAVITY_PLANETS, DAYDURATION_PLANETS, YEARDURATION_PLANETS, DISTANCEFROMSTAR_PLANETS) "
                    + "VALUES('" + this.guid + "', "
                    + "'" + this.name + "', "
                    + "'" + this.lifeForm + "', "
                    + "" + this.gravityG.ToString() + ", "
                    + "" + this.dayDurationHours.ToString() + ", "
                    + "" + this.yearDurationDays.ToString() + ", "
                    + "" + this.distanceFromStarKm.ToString() + ")";
                
                if (Globals.DATABASE.Execute(sql)) return true;
                else return false;
            }
            else {
                return false;
            }
            return false;
        }

  public bool Execute(string sql) {
            // Здесь fbBD - объект типа FbConnection
            try {
                FbTransaction transact = this.fbDB.BeginTransaction();
                FbCommand sqlReqest = new FbCommand(sql, this.fbDB, transact);
                transact.Commit();
                return true;
            }