sqldlyaDenisa

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 Npgsql;
using Microsoft.VisualBasic;
namespace Zadanie2BD
{
    public partial class Form1 : Form
    {
        private string connstring = String.Format("Server={0};Port={1};" +
            "User Id={2};Password={3};Database={4};",
            "localhost", 5432, "postgres",
            "Kuzmaiva20025", "Zadanie1");
        private NpgsqlConnection conn;
        private string sql;
        private NpgsqlCommand cmd;
        private DataTable dt;
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: данная строка кода позволяет загрузить данные в таблицу "zadanie1DataSet.shipment_accounting". При необходимости она может быть перемещена или удалена.
            this.shipment_accountingTableAdapter.Fill(this.zadanie1DataSet.shipment_accounting);
            availability_detailsTableAdapter.Fill(this.zadanie1DataSet.availability_details);
            shipment_accountingTableAdapter.Fill(this.zadanie1DataSet1.shipment_accounting);
            detailsTableAdapter.Fill(this.zadanie1DataSet1.details);
        }

        private void dgvAvailabilityDetails_Click(object sender, EventArgs e)
        {
            bindingNavigator1.BindingSource = availabilitydetailsBindingSource;
            lblTable.Text = "Наличие деталей";
            dgvShipmentAccounting.DataSource = availabilitydetailsshipmentaccountingBindingSource;
        }

        private void dgvShipmentAccounting_Click(object sender, EventArgs e)
        {
            bindingNavigator1.BindingSource = shipmentaccountingBindingSource;
            lblTable.Text = "Учет отгрузки";
            dgvShipmentAccounting.DataSource = shipmentaccountingBindingSource;

        }
        private void dgvDetails_Click(object sender, EventArgs e)
        {
            lblTable.Text = "Детали";
            dgvShipmentAccounting.DataSource = detailsshipmentaccountingBindingSource;
        }
        private void btnNext_Click(object sender, EventArgs e)
        {
            int col = dgvDetails.CurrentCell.ColumnIndex;
            int row = dgvDetails.CurrentCell.RowIndex;

            if(row<dgvDetails.RowCount - 1)
            {
                dgvDetails.CurrentCell = dgvDetails[col, row + 1];
            }
        }

        private void btnPrev_Click(object sender, EventArgs e)
        {
            int col = dgvDetails.CurrentCell.ColumnIndex;
            int row = dgvDetails.CurrentCell.RowIndex;
            if(row>0)
            {
                dgvDetails.CurrentCell = dgvDetails[col, row - 1];
            }
        }

        private void btnFirst_Click(object sender, EventArgs e)
        {
            int col = dgvDetails.CurrentCell.ColumnIndex;
            dgvDetails.CurrentCell = dgvDetails[col, 0];
        }

        private void btnLast_Click(object sender, EventArgs e)
        {
            int col = dgvDetails.CurrentCell.ColumnIndex;
            dgvDetails.CurrentCell = dgvDetails[col, dgvDetails.RowCount-1];
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                MessageBox.Show("Данные сохранены.");
                availability_detailsTableAdapter.Update(this.zadanie1DataSet.availability_details);
                shipment_accountingTableAdapter.Update(this.zadanie1DataSet1.shipment_accounting);
                detailsTableAdapter.Update(this.zadanie1DataSet1.details);
            }
            catch(Exception ex)
            {
                MessageBox.Show("Не удалось сохранить. Ошибка: \n" + ex.Message);
            }
        }

        private void btnRefresh_Click(object sender, EventArgs e)
        {
            availability_detailsTableAdapter.Fill(this.zadanie1DataSet1.availability_details);
            shipment_accountingTableAdapter.Fill(this.zadanie1DataSet1.shipment_accounting);
            detailsTableAdapter.Fill(this.zadanie1DataSet1.details);
        }

        private void performProcedure_Click(object sender, EventArgs e)
        {

            labelResult.Visible = true;
            conn = new NpgsqlConnection(connstring);
            conn.Open();
            int id_cust =Int32.Parse(dgvShipmentAccounting.CurrentRow.Cells["idcustomerDataGridViewTextBoxColumn"].Value.ToString());
            sql = @"CALL get_quantity_orders_and_details(:id_cust, :quantity_orders, :quantity_details)";
            cmd = new NpgsqlCommand(sql, conn);
            cmd.Parameters.AddWithValue("id_cust", id_cust);
            cmd.Parameters.AddWithValue("quantity_orders", 0);
            cmd.Parameters.AddWithValue("quantity_details", 0);
            dt = new DataTable();
            dt.Load(cmd.ExecuteReader());

            conn.Close();
            DataRow[] rows = dt.Select();
            labelResult.Text = "Количество заказов = " + rows[0][0].ToString() + "\n и деталей = " + rows[0][1].ToString();
            conn.Close();
        }
    }
}