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;
 
namespace Sfera_CRM
{
    public partial class DeleteContractsFRM : Form
    {
        public DeleteContractsFRM()
        {
            InitializeComponent();
        }
 
        Mapping mp = new Mapping();
 
        private void DeleteContractsFRM_Load(object sender, EventArgs e)
        {
            // TODO: данная строка кода позволяет загрузить данные в таблицу "closed_contracts.Closed_contracts". При необходимости она может быть перемещена или удалена.
            this.closed_contractsTableAdapter.Fill(this.closed_contracts.Closed_contracts);
 
        }
 
 
        public void update_data()
        {
            dataGridView1.DataSource = null;
            dataGridView1.DataSource = mp.Show("SELECT * FROM Contracts");
        }
 
        private void back_Click_1(object sender, EventArgs e)
        {
            update_data();
            Config.forms["menuFRM"].Show();
            Hide();
        }
 
        private void Close_order_Click_1(object sender, EventArgs e)
        {
 
            string contract_id = dataGridView1.CurrentRow.Cells[0].Value.ToString();
 
            mp.CRUD("DELETE FROM Contracts WHERE Contracts_id = " + contract_id);
            MessageBox.Show("Договор успешно удалён из базы");
            update_data();
 
        }
 
        private void button1_Click_1(object sender, EventArgs e)
        {
            update_data();
        }
    }
}
 

dXNpbmcgU3lzdGVtOwp1c2luZyBTeXN0ZW0uQ29sbGVjdGlvbnMuR2VuZXJpYzsKdXNpbmcgU3lzdGVtLkNvbXBvbmVudE1vZGVsOwp1c2luZyBTeXN0ZW0uRGF0YTsKdXNpbmcgU3lzdGVtLkRyYXdpbmc7CnVzaW5nIFN5c3RlbS5MaW5xOwp1c2luZyBTeXN0ZW0uVGV4dDsKdXNpbmcgU3lzdGVtLlRocmVhZGluZy5UYXNrczsKdXNpbmcgU3lzdGVtLldpbmRvd3MuRm9ybXM7CgpuYW1lc3BhY2UgU2ZlcmFfQ1JNCnsKICAgIHB1YmxpYyBwYXJ0aWFsIGNsYXNzIERlbGV0ZUNvbnRyYWN0c0ZSTSA6IEZvcm0KICAgIHsKICAgICAgICBwdWJsaWMgRGVsZXRlQ29udHJhY3RzRlJNKCkKICAgICAgICB7CiAgICAgICAgICAgIEluaXRpYWxpemVDb21wb25lbnQoKTsKICAgICAgICB9CgogICAgICAgIE1hcHBpbmcgbXAgPSBuZXcgTWFwcGluZygpOwoKICAgICAgICBwcml2YXRlIHZvaWQgRGVsZXRlQ29udHJhY3RzRlJNX0xvYWQob2JqZWN0IHNlbmRlciwgRXZlbnRBcmdzIGUpCiAgICAgICAgewogICAgICAgICAgICAvLyBUT0RPOiDQtNCw0L3QvdCw0Y8g0YHRgtGA0L7QutCwINC60L7QtNCwINC/0L7Qt9Cy0L7Qu9GP0LXRgiDQt9Cw0LPRgNGD0LfQuNGC0Ywg0LTQsNC90L3Ri9C1INCyINGC0LDQsdC70LjRhtGDICJjbG9zZWRfY29udHJhY3RzLkNsb3NlZF9jb250cmFjdHMiLiDQn9GA0Lgg0L3QtdC+0LHRhdC+0LTQuNC80L7RgdGC0Lgg0L7QvdCwINC80L7QttC10YIg0LHRi9GC0Ywg0L/QtdGA0LXQvNC10YnQtdC90LAg0LjQu9C4INGD0LTQsNC70LXQvdCwLgogICAgICAgICAgICB0aGlzLmNsb3NlZF9jb250cmFjdHNUYWJsZUFkYXB0ZXIuRmlsbCh0aGlzLmNsb3NlZF9jb250cmFjdHMuQ2xvc2VkX2NvbnRyYWN0cyk7CgogICAgICAgIH0KCgogICAgICAgIHB1YmxpYyB2b2lkIHVwZGF0ZV9kYXRhKCkKICAgICAgICB7CiAgICAgICAgICAgIGRhdGFHcmlkVmlldzEuRGF0YVNvdXJjZSA9IG51bGw7CiAgICAgICAgICAgIGRhdGFHcmlkVmlldzEuRGF0YVNvdXJjZSA9IG1wLlNob3coIlNFTEVDVCAqIEZST00gQ29udHJhY3RzIik7CiAgICAgICAgfQoKICAgICAgICBwcml2YXRlIHZvaWQgYmFja19DbGlja18xKG9iamVjdCBzZW5kZXIsIEV2ZW50QXJncyBlKQogICAgICAgIHsKICAgICAgICAgICAgdXBkYXRlX2RhdGEoKTsKICAgICAgICAgICAgQ29uZmlnLmZvcm1zWyJtZW51RlJNIl0uU2hvdygpOwogICAgICAgICAgICBIaWRlKCk7CiAgICAgICAgfQoKICAgICAgICBwcml2YXRlIHZvaWQgQ2xvc2Vfb3JkZXJfQ2xpY2tfMShvYmplY3Qgc2VuZGVyLCBFdmVudEFyZ3MgZSkKICAgICAgICB7CgogICAgICAgICAgICBzdHJpbmcgY29udHJhY3RfaWQgPSBkYXRhR3JpZFZpZXcxLkN1cnJlbnRSb3cuQ2VsbHNbMF0uVmFsdWUuVG9TdHJpbmcoKTsKCiAgICAgICAgICAgIG1wLkNSVUQoIkRFTEVURSBGUk9NIENvbnRyYWN0cyBXSEVSRSBDb250cmFjdHNfaWQgPSAiICsgY29udHJhY3RfaWQpOwogICAgICAgICAgICBNZXNzYWdlQm94LlNob3coItCU0L7Qs9C+0LLQvtGAINGD0YHQv9C10YjQvdC+INGD0LTQsNC70ZHQvSDQuNC3INCx0LDQt9GLIik7CiAgICAgICAgICAgIHVwZGF0ZV9kYXRhKCk7CgogICAgICAgIH0KCiAgICAgICAgcHJpdmF0ZSB2b2lkIGJ1dHRvbjFfQ2xpY2tfMShvYmplY3Qgc2VuZGVyLCBFdmVudEFyZ3MgZSkKICAgICAgICB7CiAgICAgICAgICAgIHVwZGF0ZV9kYXRhKCk7CiAgICAgICAgfQogICAgfQp9Cg==