FabrikaLDA/СУБД Швейная фабрика/FormStorekeeper.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 FormStorekeeper : Form
    {
        public FormStorekeeper()
        {
            InitializeComponent();
        }

        private void FormStorekeeper_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'fabrikaLDADataSet.Furnitura' table. You can move, or remove it, as needed.
            this.furnituraTableAdapter.Fill(this.fabrikaLDADataSet.Furnitura);
            // TODO: This line of code loads data into the 'fabrikaLDADataSet.Cloth' table. You can move, or remove it, as needed.
            this.clothTableAdapter.Fill(this.fabrikaLDADataSet.Cloth);
            SqlConnection con = new SqlConnection(FormAuthorization.StrCon);

            con.Open();
            SqlCommand cmd = new SqlCommand($@"select Fam,Name,Otch from Users where IdUser = {FormAuthorization.IdUser}", con);
            SqlDataReader res = cmd.ExecuteReader();
            res.Read();
            lblFIO.Text = $"{res["Fam"]} {res["Name"]} {res["Otch"]}";
            res.Close();
            con.Close();

            GetOrdersFromDB();
        }

        private void btnEdit_Click(object sender, EventArgs e)
        {
            FormEditUser frm = new FormEditUser();
            this.Hide();
            frm.ShowDialog();
            this.Show();
        }

        void GetOrdersFromDB()
        {
            SqlConnection con = new SqlConnection(FormAuthorization.StrCon);

            con.Open();
            SqlCommand cmd = new SqlCommand($@"Select  Orders.IdOrder,Products.TitleProduct,Products.Lenght,Products.Width,Orders.IdClient,Cloth.Title as ClothTitle, Colors.Title as 
ColorTitle,
Furnitura.namefur,Orders.CountFurnitura,
Orders.CountProduct
from Orders join Users on Users.IdUser = Orders.IdClient join Products on 
Products.IdProduct = Orders.IdProduct join Cloth on Cloth.IdCloth = Orders.IdCloth  join Furnitura on 
Furnitura.idfur = Orders.IdFur join Colors on Cloth.IdColor = Colors.IdColor", con);
            SqlDataReader res = cmd.ExecuteReader();
            while (res.Read())
            {

         //       dgvOrders.Rows.Add(res["Products.TitleProduct"], res["Orders.CountProduct"], res["Cloth.Title"], res["Furnitura.namefur"], res["Orders.CountFurnitura"]);
            }
            res.Close();
            con.Close();
        }

        void GetClothFromDB()
        {

            SqlConnection con = new SqlConnection(FormAuthorization.StrCon); // Возможны ошибки с названием цвета
            SqlCommand cmd = new SqlCommand(@"SELECT        Cloth.IdCloth, Cloth.Title, Cloth.IdColor, Cloth.Weight, Cloth.Height, Cloth.Note, Cloth.Photo,
Colors.IdColor AS Expr1, Colors.Title AS  ColorTitle
FROM            Cloth INNER JOIN
                         Colors ON Cloth.IdColor = Colors.IdColor", con);
            con.Open();
            SqlDataReader res = cmd.ExecuteReader();
            while (res.Read())
            {
                ListViewItem lv = new ListViewItem();
                
               // lvCloth.Items.Add(lv);
            }
            res.Close();
            con.Close();
        }

        private void btnDoc_Click(object sender, EventArgs e)
        {
            FormAddTovar frm = new FormAddTovar();
            this.Hide();
            frm.ShowDialog();
            this.Show();
        }
    }
}