up/Учебная практика 47 гр. 2 сем. - 5/СУБД_Кадры/SUBD_Kadry/fAddClient.cs

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

namespace СУБД_Кадры
{
    public partial class fAddClient : Form
    {
        public fAddClient()
        {
            InitializeComponent();
        }

        private void BtnSave_Click(object sender, EventArgs e)
        {
            if (tbSurname.Text.Trim() == "" || TbxPhone.Text.Trim() == ""|| TbxEmail.Text.Trim() == "")
            {
                MessageBox.Show("Вы заполнили не все поля", "Внимание!!!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }


            SqlConnection con = new SqlConnection(fMain.TxtCon);
            con.Open();
            SqlCommand comm = new SqlCommand($"Insert into Client (Surname,Name,Pathronymic,Phone,Email,Gender) values ('{tbSurname.Text.Trim()}','{tbName.Text.Trim()}','{tbPathronymic.Text.Trim()}','{TbxPhone.Text.Trim()}','{TbxEmail.Text.Trim()}','{LblGenderCode.Text.Trim()}')", con);
            comm.ExecuteNonQuery();
            con.Close();
            this.Close();
        }

        private void RbtMale_CheckedChanged(object sender, EventArgs e)
        {
            LblGenderCode.Text = "мужской";
        }

        private void RbtFemale_CheckedChanged(object sender, EventArgs e)
        {
            LblGenderCode.Text = "женский";
        }

        private void BtnCancel_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void fAddClient_Load(object sender, EventArgs e)
        {

        }
    }
}