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 System.Data.SqlClient;

namespace ARM_spec_otdelenia
{
    public partial class AddEditContact : Form
    {
        SqlConnection connection;
        SqlCommand command;
        SqlDataAdapter adapter;
        public AddEditContact()
        {
            InitializeComponent();
            connection = new SqlConnection("Server=DESKTOP-2UUHBK8\\SQLEXPRESS; Database=Спец_отделение; Trusted_connection=true;");
            command = new SqlCommand();
            command.Connection = connection;
            command.CommandType = CommandType.Text;
            adapter = new SqlDataAdapter(command);
        }
        private void saveBtn_MouseMove(object sender, MouseEventArgs e)
        {
            saveBtn.ForeColor = Color.FromArgb(24, 186, 96);
            saveBtn.FlatAppearance.BorderColor = Color.FromArgb(24, 186, 96);
        }
        private void backBtn_MouseMove(object sender, MouseEventArgs e)
        {
            backBtn.ForeColor = Color.FromArgb(24, 186, 96);
            backBtn.FlatAppearance.BorderColor = Color.FromArgb(24, 186, 96);
        }
        private void backBtn_MouseLeave(object sender, EventArgs e)
        {
            backBtn.ForeColor = Color.Black;
            backBtn.FlatAppearance.BorderColor = Color.Black;
        }
        private void saveBtn_MouseLeave(object sender, EventArgs e)
        {
            saveBtn.ForeColor = Color.Black;
            saveBtn.FlatAppearance.BorderColor = Color.Black;
        }
        private void saveBtn_Click(object sender, EventArgs e)
        {
            if (ContactiClass.add == true)
            {
                if (string.IsNullOrEmpty(gorodText.Text) || string.IsNullOrEmpty(ulicaText.Text) || string.IsNullOrEmpty(domText.Text) || string.IsNullOrEmpty(kvartiraText.Text) || string.IsNullOrEmpty(teleText.Text))
                {
                    MessageBox.Show("Не все поля заполнены!");
                    return;
                }
                else
                {
                    if (MessageBox.Show("Вы действительно хотите добавить запись?", "Внимание", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        try
                        {
                            connection.Open();
                            command.CommandText = "INSERT INTO Контакты(Город, Улица, Дом, Квартира, Телефон) VALUES(@gor, @ul, @dom, @kvar, @tel)";
                            command.Parameters.AddWithValue("@gor", gorodText.Text);
                            command.Parameters.AddWithValue("@ul", ulicaText.Text);
                            command.Parameters.AddWithValue("@dom", domText.Text);
                            command.Parameters.AddWithValue("@kvar", kvartiraText.Text);
                            command.Parameters.AddWithValue("@tel", teleText.Text);
                            command.ExecuteReader();
                            command.Parameters.Clear();
                            connection.Close();
                            this.Close();
                            MessageBox.Show("Запись успешно добавлена!");
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                            command.Parameters.Clear();
                            connection.Close();
                        }
                    }
                    else
                    {

                    }
                }
            }
            if (ContactiClass.change == true)
            {
                if (string.IsNullOrEmpty(gorodText.Text) || string.IsNullOrEmpty(ulicaText.Text) || string.IsNullOrEmpty(domText.Text) || string.IsNullOrEmpty(kvartiraText.Text) || string.IsNullOrEmpty(teleText.Text))
                {
                    MessageBox.Show("Не все поля заполнены!");
                    return;
                }
                else
                {
                    if (MessageBox.Show("Вы действительно хотите изменить запись?", "Внимание", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        try
                        {
                            connection.Open();
                            command.CommandText = "UPDATE Контакты SET Город=@gor, Улица=@ul, Дом=@dom, Квартира=@kvar, Телефон=@tel WHERE ID=@id";
                            command.Parameters.AddWithValue("@gor", gorodText.Text);
                            command.Parameters.AddWithValue("@ul", ulicaText.Text);
                            command.Parameters.AddWithValue("@dom", domText.Text);
                            command.Parameters.AddWithValue("@kvar", kvartiraText.Text);
                            command.Parameters.AddWithValue("@tel", teleText.Text);
                            command.Parameters.AddWithValue("@id", ContactiClass.id);
                            command.ExecuteReader();
                            command.Parameters.Clear();
                            connection.Close();
                            this.Close();
                            MessageBox.Show("Запись успешно изменена!");
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                            command.Parameters.Clear();
                            connection.Close();
                        }
                    }
                    else
                    {

                    }
                }
            }
        }
    }
}