Form1.cs

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 WebCam;
using ImageFilters;
using NpgsqlAltPool;
using DynamicPg;
using Npgsql;
using System.IO;

namespace RamaSignup
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }


        enum Language
        {
            Finnish = 0,
            English = 1,
        }
        Language currentLanguage = Language.English;
        Image img;
        Pen RetanglePen = new Pen(Color.Blue);
        int RetangleHeight = 410;
        int RetangleWidth = 280;

        void changed()
        {
            if (!pictureTaken && wc != null)
            {
                if (currentLanguage == Language.English)
                {
                    this.lblMessage.Text = "Take a picture first by pressing 'Use this picture' button";
                }
                else
                {
                    this.lblMessage.Text = "Ota kuva ensin painamalla 'Käytä tätä kuvaa' nappia";
                }
                this.lblMessage.ForeColor = Color.Red;
                this.btnSave.Enabled = false;
                return;
            }
            string errorType = checkFields();
            if (errorType != null)
            {
                if (currentLanguage == Language.English)
                {
                    this.lblMessage.Text = errorType + " is missing or invalid. Fill the required fields with correct information.";
                }
                else
                {
                    this.lblMessage.Text = errorType + " puuttuu tai on virheellinen. Täytä puuttuvat kentät oikeilla tiedoilla.";
                }
                this.lblMessage.ForeColor = Color.Red;
                this.btnSave.Enabled = false;
                return;
            }

            this.lblMessage.ForeColor = Color.Green;
            if (currentLanguage == Language.English)
            {
                this.lblMessage.Text = "OK, verify information and click save";
            }
            else
            {
                this.lblMessage.Text = "OK, varmista tietojen oikeellisuus ja tallenna";
            }
            this.btnSave.Enabled = true;
        }

        string checkFields()
        {
            int tmp;
            //checking validity
            if (this.txtName.Text.Trim().Length < 5)
            {
                if (currentLanguage == Language.English)
                    return "Name";
                else
                    return "Nimi";
            }
            else if (this.txtNick.Text.Trim().Length < 2)
            {
                if (currentLanguage == Language.English)
                    return "Nick";
                else
                    return "Nick (nimimerkki)";
            }
            else if (this.txtAge.Text.Trim().Length < 1 || (!int.TryParse(this.txtAge.Text.Trim(), out tmp)))
            {
                if (currentLanguage == Language.English)
                    return "Age";
                else
                    return "Ikä";
            }
            else if (this.cmbGender.SelectedIndex == 0)
            {
                if (currentLanguage == Language.English)
                    return "Gender";
                else
                    return "Sukupuoli";
            }
            else if (this.txtPhone.Text.Length < 2)
            {
                if (currentLanguage == Language.English)
                    return "Phone number";
                else
                    return "Puhelinnumero";
            }
            else if (this.txtEmail.Text.Trim().Length < 5)
            {
                if (currentLanguage == Language.English)
                    return "Email";
                else
                    return "Sähköposti";
            }
            else if (this.txtAdress.Text.Trim().Length < 2)
            {
                if (currentLanguage == Language.English)
                    return "Address";
                else
                    return "Lähiosoite";
            }
            else if (this.txtZip.Text.Trim().Length != 5 || (!int.TryParse(this.txtZip.Text.Trim(), out tmp)))
            {
                if (currentLanguage == Language.English)
                    return "Zip code";
                else
                    return "Postinumero";
            }
            else if (this.txtCity.Text.Trim().Length < 2)
            {
                if (currentLanguage == Language.English)
                    return "City";
                else
                    return "Paikkakunta";
            }
                /*
            else if (this.cbTicketType.SelectedIndex == 0)
            {
                if (currentLanguage == Language.English)
                    return "Ticket type";
                else
                    return "Lipun tyyppi";
            }*/
            else
            {
                return null;
            }
        }

        void wc_RecievedFrame(object sender, WebCameraEventArgs e)
        {
            if (freeze)
            {
                this.pbIncoming.Refresh();
                return;
            }
            img = (Image)e.Bitmap;
            img.RotateFlip(RotateFlipType.RotateNoneFlipY);
            this.pbIncoming.Image = BitmapFilter.Crop(img, RetangleWidth, RetangleHeight, ImageFilters.BitmapFilter.AnchorPosition.Free, 220, 220);
        }

        int groupId;

        private void Form1_Load(object sender, EventArgs e)
        {
            if (AutoUpdateLib.AutoUpdateCore.CheckForUpdates(null))
            {
                Application.ExitThread();		//program is required to close by autoupdate (probably updated)
                return;
            }
            this.cmbGender.SelectedIndex = 0;
            MessageBox.Show("Ohjelman saa sammutettua ikkunan tyhjästä kohdasta hiiren kakkosnapilla", "Tiedoksi", MessageBoxButtons.OK, MessageBoxIcon.Information);
            

            //getTicketTypes();

            /*
            object orid = Objects.Pool.ExecScalar("SELECT id FROM ryhmat WHERE nimi = 'Vectorama' LIMIT 1");
            if (orid == null || orid is DBNull)
            {
                MessageBox.Show("Oletusryhmää nimellä Vectorama ei löydy. Luo sellainen esim. seuraavalla queryllä:" + @"
                    insert into ryhmat (tunnus, deleted, pass, type, state, liput_alku, liput_loppu, toimitus, luotu, otettu, nimi, tietoja)
                    values ('99998', 0, '123451234512345123451234512345ab', 0, 3, null, null, 0, 1207561742, null, 'Vectorama', '');", "Oletusryhmä puuttuu", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            groupId = Convert.ToInt32(orid);
            if (groupId < 1)
            {
                MessageBox.Show("Vectorama-ryhmällä on virheellinen ID-numero " + groupId, "Virheellinen ID oletusryhmällä", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
             */
            
            
                this.wc = new WebCamera(this.panel1.Handle, 800, 600); // TODO viimeiseen kenttään conffista kameran numero
                wc.RecievedFrame += new WebCamera.RecievedFrameEventHandler(wc_RecievedFrame);
            
            if (!this.wc.StartWebCam())
            {
                MessageBox.Show("Error in connection with camera", "Error in connection with camera", MessageBoxButtons.OK, MessageBoxIcon.Error);
                wc = null;
                btnTakePic.Visible = false;
            }
        }
/*
        void getTicketTypes()
        {
            SelectCreator sc = new SelectCreator("cardtypes");
            sc.Fields.Add("id");
            sc.Fields.Add("description");
            sc.Where.AddTerm("active = true");
            sc.Orderby.Add("id");
            NpgsqlDataReader dr = Objects.Pool.ExecReader(sc.CreateSQL());
            this.cbTicketType.Items.Clear();

            this.cbTicketType.Items.Add(new TicketType(0, "-"));
            while (dr.Read())
            {
                this.cbTicketType.Items.Add(new TicketType((int) dr["id"], (string) dr["description"]));
            }
            this.cbTicketType.SelectedIndex = 1;
            dr.Close();
            Objects.Pool.ReleaseConn(dr);
            
        }*/

        bool pictureTaken;

        private void btnFinnish_Click(object sender, EventArgs e)
        {
            currentLanguage = Language.Finnish;
            label1.Text = "Nimi:";
            label2.Text = "Lempinimi / Nick:";
            //label3.Text = "Lipun tyyppi:";
            label4.Text = "Sähköpostiosoite:";
            label5.Text = "Lähiosoite:";
            label6.Text = "Postinumero:";
            label7.Text = "Ikä:";
            label8.Text = "Paikkakunta:";
            label9.Text = "Puhelin:";
            label10.Text = "Sukupuoli:";
            label11.Text = "Sukunimi";
            btnClear.Text = "Tyhjennä";
            label12.Text = "Käyttäjänimi";
            label13.Text = "Salasana";
            label14.Text = "Salasana uudelleen";
            
            this.cmbGender.Items.Clear();
            this.cmbGender.Items.Add("En tiedä");
            this.cmbGender.Items.Add("Mies");
            this.cmbGender.Items.Add("Nainen");
            this.cmbGender.SelectedIndex = 0;
            if (freeze)
            {
                btnTakePic.Text = "Ota uusi kuva";
            }
            else
            {
                btnTakePic.Text = "Käytä tätä kuvaa";
            }
            btnSave.Text = "Tallenna";
            this.cmbGender.Items[0] = "En tiedä";
        }

        private void btnEnglish_Click(object sender, EventArgs e)
        {
            currentLanguage = Language.English;
            label1.Text = "First name:";
            label2.Text = "Nickname:";
            //label3.Text = "Ticket type:";
            label4.Text = "E-Mail:";
            label5.Text = "Address:";
            label6.Text = "Zip:";
            label7.Text = "Age:";
            label8.Text = "City:";
            label9.Text = "Phone:";
            label10.Text = "Gender:";
            label11.Text = "Last name:";
            label12.Text = "Käyttäjänimi:";
            label13.Text = "Passowrd:";
            label14.Text = "Password again";
            btnClear.Text = "Clear";
            this.cmbGender.Items.Clear();
            this.cmbGender.Items.Add("I don't know");
            this.cmbGender.Items.Add("Male");
            this.cmbGender.Items.Add("Female");
            this.cmbGender.SelectedIndex = 0;
            if (freeze)
            {
                btnTakePic.Text = "Take a new picture";
            }
            else
            {
                btnTakePic.Text = "Use current picture";
            }
            btnSave.Text = "Save";
            this.cmbGender.Items[0] = "I don't know";
        }

        private void btnClear_Click(object sender, EventArgs e)
        {
            string msg, caption;
            if (currentLanguage == Language.English)
            {
                msg = "Are you sure you want to clear the fields?";
                caption = "Confirmation";
            }
            else
            {
                msg = "Haluatko varmasti nollata kentät?";
                caption = "Varmistus";
            }
            DialogResult r = MessageBox.Show(msg, caption, MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
            if (r != DialogResult.OK)
                return;
            clear();
        }

        void clear()
        {
            this.cmbGender.SelectedIndex = 0;
            txtAdress.Text = "";
            txtAge.Text = "";
            txtCity.Text = "";
            txtEmail.Text = "";
            txtName.Text = "";
            txtNick.Text = "";
            txtPhone.Text = "";
            txtZip.Text = "";
            btnSave.Enabled = false;
            this.pbIncoming.Image = null;
            //this.cbTicketType.SelectedIndex = 1;
            pictureTaken = false;
            changed();
        }
        
        bool checkSaveSafety()
        {
            //check nickname usage
            
            if (false)
            {
                if (currentLanguage == Language.English)
                {
                    MessageBox.Show("Nickname '"+this.txtNick.Text+"' already in use. Please choose another one.", "Nickname in use",  MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    this.lblMessage.Text = "Choose another nickname";
                }
                else
                {
                    MessageBox.Show("Nimimerkki '"+this.txtNick.Text+"' on jo käytössä. Valitsetko toisen nimimerkin.", "Nick käytössä",  MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    this.lblMessage.Text = "Valitse toinen nick";
                }
                return false;
            }
            return true;
        }
         

        private void btnSave_Click(object sender, EventArgs e)
        {
            if (!checkSaveSafety())
            {
                this.btnSave.Enabled = false;
                return;
            }

            this.Cursor = Cursors.WaitCursor;
            this.btnSave.Enabled = false;
            this.Enabled = false;
            this.btnSave.Refresh();

            
            //savePicture(pid);

            if (currentLanguage == Language.English)
            {
                MessageBox.Show("Save successful.\r\nNow, to to the infodesk and tell them this number and they will tell you what to do.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                MessageBox.Show("Tallennus onnistui.\r\nMene infotiskille, ja kerro heille tämä numero, niin he opastavat sinut eteenpäin.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            clear();
            this.Enabled = true;
            this.Cursor = Cursors.Default;
        }

        void savePicture(int pid)
        {
            
			
			MemoryStream imageStream = new MemoryStream();
			this.pbIncoming.Image.Save(imageStream, System.Drawing.Imaging.ImageFormat.Png);
			imageStream.Position = 0;
			byte[] imageContent = new Byte[imageStream.Length];
			imageStream.Read(imageContent, 0, (int)imageStream.Length);
            //Objects.Pool.ExecNonQuery("UPDATE kortit SET kuva = :bytesData WHERE id=" + pid, new Npgsql.NpgsqlParameter(":bytesData", imageContent));
            return;
        }

        bool allowShutdown;
        private void txtName_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (!allowShutdown)
            {
                e.Cancel = true;
            }
            else
            {
                if (wc != null)
                    this.wc.CloseWebcam();
            }
        }

        private void Form1_Deactivate(object sender, EventArgs e)
        {
            if (!allowShutdown)
                this.Activate();
        }

        private void Form1_KeyUp(object sender, KeyEventArgs e)
        {
            if (e.Alt && e.Control && e.KeyCode == Keys.S)
            {
                allowShutdown = true;
                Application.Exit();
                return;
            }
        }

        private void Form1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.Alt && e.Control && e.KeyCode == Keys.S)
            {
                allowShutdown = true;
                this.Close();
                return;
            }
        }

        public WebCamera wc;
        bool freeze;
        private void btnTakePic_Click(object sender, EventArgs e)
        {
            this.btnTakePic.Enabled = false;
            this.Cursor = Cursors.WaitCursor;
            this.btnTakePic.Refresh();
            if (freeze)
            {
                freeze = false;
                this.wc.StartWebCam();
                if (currentLanguage == Language.English)
                {
                    this.btnTakePic.Text = "Use current picture";
                }
                else
                {
                    this.btnTakePic.Text = "Käytä tätä kuvaa";
                }
                pictureTaken = false;
                changed();
            }
            else
            {
                freeze = true;
                this.wc.CloseWebcam();
                if (currentLanguage == Language.English)
                {
                    this.btnTakePic.Text = "Take a new picture";
                }
                else
                {
                    this.btnTakePic.Text = "Ota uusi kuva";
                }
                pictureTaken = true;
                changed();
            }
            this.Cursor = Cursors.Default;
            this.btnTakePic.Enabled = true;
        }

        private void Form1_MouseClick(object sender, MouseEventArgs e)
        {
         /*   if (e.Button == MouseButtons.Right)
            {
                allowShutdown = true;
                Application.Exit();
                return;
            }*/
        }

        private void txtNick_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void txtAge_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void cmbGender_SelectedIndexChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void txtPhone_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void txtEmail_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void txtAdress_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void txtZip_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void txtCity_TextChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void cbTicketType_SelectedIndexChanged(object sender, EventArgs e)
        {
            changed();
        }

        private void lbMessage_Click(object sender, EventArgs e)
        {

        }

        private void label13_Click(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            allowShutdown = true;
            Application.Exit();
        }
    }
}