NewResident.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Emgu.CV;
using Emgu.CV.Structure;
using connect = System.Data.SqlClient.SqlConnection;
using command = System.Data.SqlClient.SqlCommand;


namespace frameworks
{
    public partial class NewResident :MetroFramework.Forms.MetroForm
    {
        VideoCapture capture;   
        public NewResident()
        {
            InitializeComponent();
            Run();
        }
        private void Run()
        {
            try
            {
                capture = new VideoCapture();
            }
            catch (Exception Ex)
            {
                MessageBox.Show(Ex.Message);
                return;
            }
            Application.Idle += ProcessFrame;
        }

        private void ProcessFrame(object sender, EventArgs e)
        {
            imageBox1.Image = capture.QuerySmallFrame();
            imageBox3.Image = capture.QuerySmallFrame();
            
        }

        private void NewResident_Load(object sender, EventArgs e)
        {
            panel1.Enabled = false;
            imageBox1.Visible = false;
            imageBox2.Visible = false;
            imageBox3.Visible = false;
            imageBox4.Visible = false;

        }

        private void button3_Click(object sender, EventArgs e)
        {
            main ma = new main();
            ma.ShowDialog();
        }

        private void button10_Click(object sender, EventArgs e)
        {
            main ma = new main();
            ma.ShowDialog();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            ClearTextbox(textBox1, textBox2, textBox3, textBox4, textBox5, textBox6);
        }
        public void ClearTextbox(params TextBox[] textBoxes)
        {
            for (int i = 0; i < textBoxes.Length; i++)
            {
                textBoxes[i].Clear();
            }
        }

        private void button8_Click(object sender, EventArgs e)
        {
            ClearTextbox(textBox11,textBox7, textBox8, textBox9, textBox10);
        }

        private void radioButton1_CheckedChanged(object sender, EventArgs e)
        {
            if(radioButton1.Checked == true)
            {
                panel1.Enabled = true;
                
            }
        }

        private void button4_Click(object sender, EventArgs e)
        {
            imageBox1.Visible = true;
            imageBox2.Visible = false;
        }
        string imagelocation = "";
        private void button5_Click(object sender, EventArgs e)
        {           
            imageBox2.Image = imageBox1.Image;
            imageBox2.Image.Save(@"C:\Users\User\Desktop\New folder\" + textBox1.Text + ".png");
            imagelocation = @"C:\Users\User\Desktop\New folder\" + textBox1.Text + ".png";
            imageBox1.Visible = false;
            imageBox2.Visible = true;
        }

        private void button2_Click(object sender, EventArgs e)
        {
            connect con = new connect("Data Source=(local);Initial Catalog=appartment;Integrated Security=True");
            string query = "insert into resident values(@f,@m,@n,@p,@ni,@r,@i)";
            command com = new command(query, con);
            com.Parameters.AddWithValue("@f", textBox1.Text);
            com.Parameters.AddWithValue("@m", textBox2.Text);
            com.Parameters.AddWithValue("@n", textBox3.Text);
            com.Parameters.AddWithValue("@p", textBox4.Text);
            com.Parameters.AddWithValue("@ni", textBox5.Text);
            com.Parameters.AddWithValue("@r", textBox6.Text);
            com.Parameters.AddWithValue("@i", imagelocation);
            con.Open();
            com.ExecuteNonQuery();
            con.Close();
            textBox1.Text = "";
            textBox2.Text = "";
            textBox3.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
            textBox6.Text = "";
            MessageBox.Show("Successfully inserted");
        }

        private void button6_Click(object sender, EventArgs e)
        {
            imageBox3.Visible = true;
            imageBox4.Visible = false;

        }

        private void button7_Click(object sender, EventArgs e)
        {
            imageBox4.Image = imageBox3.Image;
            imageBox4.Image.Save(@"C:\Users\User\Desktop\New folder\Tenant" + textBox11.Text + ".png");
            imagelocation = @"C:\Users\User\Desktop\New folder\Tenant" + textBox11.Text + ".png";
            imageBox3.Visible = false;
            imageBox4.Visible = true;
        }

        private void button9_Click(object sender, EventArgs e)
        {
            connect con = new connect("Data Source=(local);Initial Catalog=appartment;Integrated Security=True");
            string query = "insert into tenant values(@f,@n,@m,@ni,@p,@i)";
            command com = new command(query, con);
            com.Parameters.AddWithValue("@f", textBox11.Text);
            com.Parameters.AddWithValue("@n", textBox7.Text);
            com.Parameters.AddWithValue("@m", textBox8.Text);
            com.Parameters.AddWithValue("@ni", textBox9.Text);
            com.Parameters.AddWithValue("@p", textBox10.Text);
            com.Parameters.AddWithValue("@i", imagelocation);
            con.Open();
            com.ExecuteNonQuery();
            con.Close();
            textBox11.Text = "";
            textBox7.Text = "";
            textBox8.Text = "";
            textBox9.Text = "";
            textBox10.Text = "";
            MessageBox.Show("Successfully inserted");

        }

        private void imageBox2_Click(object sender, EventArgs e)
        {

        }
    }
}