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 point4
{
    public partial class Frm_stock : Form
    {
        public Frm_stock()
        {
            InitializeComponent();
        }
        private void Frm_stock_Load(object sender, EventArgs e)
        {
            using (point4Entities3 db = new point4Entities3())
            {
                cbo_articul.DataSource = db.articuls.ToList();
                cbo_articul.DisplayMember = "articul";
                cbo_articul.ValueMember = "articul_id";
            }
            
        }
        private void Populate_dgv_stock()
        {
            using(point4Entities3 db = new point4Entities3())
            {
                var f_data = db.view_goods_stocks.ToList()
                     .Where(x => x.articul.Equals(cbo_articul.Text));
                dgv_stock.DataSource = f_data.ToList();
            }
        }
        private void Populate_dgv_stock_ImageCount()
        {
            using (point4Entities3 db = new point4Entities3())
            {
                var f_data = db.sp_Dgv().ToList()
                    .Where(x => x.articul.Equals(cbo_articul.Text));
                dgv_stock.DataSource = f_data.ToList();
            }
        }
        private void btn_search_equals_Click(object sender, EventArgs e)
        {
            Populate_dgv_stock();
        }
        private void btnImageCount_Click(object sender, EventArgs e)
        {
            Populate_dgv_stock_ImageCount();
        }

        private void btnImage_Click(object sender, EventArgs e)
        {

        }

        private void btnDownloadImages_Click(object sender, EventArgs e)
        {
            int nomId = (int)dgv_stock.CurrentRow.Cells["nomencl_id"].Value;
            string articul = dgv_stock.CurrentRow.Cells["articul"].Value.ToString();
            string widht = dgv_stock.CurrentRow.Cells["widht"].Value.ToString();
            string lenght_id = dgv_stock.CurrentRow.Cells["lenght_id"].Value.ToString();

            FrmEditImages frmImages = new FrmEditImages();
            frmImages.Filename = articul + widht + lenght_id;
            frmImages.NomID = nomId;
            
            frmImages.ShowDialog();
        }

        private void cbo_articul_SelectedIndexChanged(object sender, EventArgs e)
        {
            Populate_dgv_stock_ImageCount();
        }

        private void btnDownloadImagesArt_Click(object sender, EventArgs e)
        {
            FrmArticulImages frmArticulImages = new FrmArticulImages();
            frmArticulImages.Filename = cbo_articul.Text;
            frmArticulImages.ArtID = (int)cbo_articul.SelectedValue;
            frmArticulImages.ShowDialog();
        }
    }
}

public  async Task Populate_dgv_stock()
        {
            using(point4Entities3 db = new point4Entities3())
            {
                var f_data = await db.view_goods_stocks.ToListAsync()
                     .Where(x => x.articul.Equals(cbo_articul.Text));
                dgv_stock.DataSource = f_data.ToListAsync();
               
            }
        }

 public async Task Populate_dgv_stock()
        {
            using (point4Entities3 db = new point4Entities3())
            {
                var f_data = await db.view_goods_stocks
                     .Where(x => x.articul.Equals(cbo_articul.Text));
                dgv_stock.DataSource = f_data.ToList();

            }
        }

 var f_data = await db.view_goods_stocks.Where(x => x.articul.Equals(cbo_articul.Text)).ToListAsync();

cbo_articul_SelectedIndexChanged(object sender, EventArgs e)