private void button1_Click(object sender, EventArgs e)
        {
            foreach (CDCDS.CDC_BRANDSRow riga in _DS.CDC_BRANDS.Rows)
            {
                if (riga.RowState == DataRowState.Added || riga.RowState == DataRowState.Modified)
                {
                    riga.UTENTE          = Contesto.Utente.FULLNAMEUSER;
                    riga.DATARIFERIMENTO = DateTime.Now;
                }
            }

            CDCBLL bll = new CDCBLL();

            bll.SalvaDatiBrands(_DS);
            _DS.AcceptChanges();

            _DS.CDC_BRANDS.Clear();
            bll.CaricaBrands(_DS);

            DataTable listBrands = _DS.CDC_BRANDS.Clone();

            listBrands = _DS.CDC_BRANDS.Copy();

            DataGridViewComboBoxColumn comboCol = (DataGridViewComboBoxColumn)dgvEnti.Columns["BRAND"];

            comboCol.DataSource = listBrands;
        }
        private void ExcelCaricaNuovoDocumentoFrm_Load(object sender, EventArgs e)
        {
            CDCBLL bll = new CDCBLL();

            bll.CaricaBrands(_DS);

            CaricaDropDownListBrands();
        }
        public CreaGestioneBrandFrm()
        {
            InitializeComponent();


            CDCBLL bll = new CDCBLL();

            bll.CaricaBrands(_DS);
            bll.CaricaEnti(_DS);//JACOPO

            DataTable listBrands = _DS.CDC_BRANDS.Clone();

            listBrands = _DS.CDC_BRANDS.Copy();


            dgvBrands.ReadOnly            = false;
            dgvBrands.AutoGenerateColumns = true;
            dgvBrands.DataSource          = _DS;
            dgvBrands.DataMember          = _DS.CDC_BRANDS.TableName;

            dgvBrands.Columns["IDBRAND"].Visible         = true;
            dgvBrands.Columns["UTENTE"].Visible          = false;
            dgvBrands.Columns["DATARIFERIMENTO"].Visible = false;

            //dgvExcelCaricato.Columns["IDDETTAGLIO"].Visible = false;
            //dgvExcelCaricato.Columns["IDEXCEL"].Visible = false;
            //dgvExcelCaricato.Columns["IDBRAND"].Visible = false;

            dgvEnti.ReadOnly                           = false;
            dgvEnti.AutoGenerateColumns                = true;
            dgvEnti.DataSource                         = _DS;
            dgvEnti.DataMember                         = _DS.CDC_ENTI.TableName;
            dgvEnti.Columns["IDENTE"].Visible          = false;
            dgvEnti.Columns["UTENTE"].Visible          = false;
            dgvEnti.Columns["DATARIFERIMENTO"].Visible = false;
            dgvEnti.Columns["IDBRAND"].Visible         = false;

            var comboCol = new DataGridViewComboBoxColumn();

            comboCol.HeaderText       = "BRAND";
            comboCol.Name             = "BRAND";
            comboCol.DataPropertyName = "IDBRAND";
            comboCol.AutoComplete     = true;
            comboCol.Width            = 100;
            comboCol.DropDownWidth    = 100;
            comboCol.DataSource       = listBrands; // _DS.CDC_BRANDS.Where(x => x.IDBRAND >0);
            comboCol.DisplayMember    = "CODICE";
            comboCol.ValueMember      = "IDBRAND";
            comboCol.DisplayIndex     = 5;
            dgvEnti.Columns.Add(comboCol);
        }
        private void btnLeggiDati_Click(object sender, EventArgs e)
        {
            lblMessaggio.Text = string.Empty;
            if (ddlDataCollaudo.SelectedIndex == -1)
            {
                lblMessaggio.Text = "Selezionare una data";
                return;
            }
            if (ddlBrand.SelectedIndex == -1 || ddlBrand.SelectedItem.ToString() == "")
            {
                lblMessaggio.Text = "Selezionare un brand";
                return;
            }

            DataCollaudoSTR dataSelezionata = new DataCollaudoSTR(ddlBrand.SelectedItem.ToString(), ddlDataCollaudo.SelectedItem.ToString());
            CDCBLL          bll             = new CDCBLL();

            _DS = new Entities.CDCDS();
            bll.LeggiCollaudoDaDataSTR(_DS, dataSelezionata);
            bll.CaricaBrands(_DS);
            bll.CaricaArticoli(_DS);
            bll.CaricaArticoliDimensioni(_DS);
            bll.CaricaArticoliSpessori(_DS);

            if (_DS.CDC_DETTAGLIO.Count > 0)
            {
                //List<decimal> IDDETTAGLIO = _DS.CDC_DETTAGLIO.Select(x => x.IDDETTAGLIO).Distinct().ToList();
                //bll.FillCDC_CONFORMITA(_DS, IDDETTAGLIO);
                //bll.CDC_PDF(_DS, IDDETTAGLIO);
            }
            else
            {
                lblMessaggio.Text = "Nessuna riga trovata per questa data";
            }

            CreaDsPerDettaglio();



            dgvDettaglio.ReadOnly = true;
            dgvDettaglio.AllowUserToDeleteRows           = false;
            dgvDettaglio.AllowUserToAddRows              = false;
            dgvDettaglio.AutoGenerateColumns             = true;
            dgvDettaglio.DataSource                      = _dsServizio;
            dgvDettaglio.DataMember                      = tableName;
            dgvDettaglio.Columns["ACCESSORISTA"].Visible = false;

            foreach (DataGridViewRow riga in dgvDettaglio.Rows)
            {
                string parte  = (string)riga.Cells["PARTE"].Value;
                string colore = (string)riga.Cells["COLORE"].Value;

                CDCDS.CDC_ARTICOLIRow arow = _DS.CDC_ARTICOLI.Where(x => x.PARTE == parte && x.COLORE == colore).FirstOrDefault();
                if (arow == null)
                {
                    riga.Cells[1].Style.BackColor = Color.Yellow;
                    riga.Cells[2].Style.BackColor = Color.Yellow;
                }
                else
                {
                    List <CDCDS.CDC_ARTICOLI_DIMENSIONIRow> artdimensioni = _DS.CDC_ARTICOLI_DIMENSIONI.Where(x => x.IDARTICOLO == arow.IDARTICOLO).OrderBy(x => x.IDDIMENSIONE).ToList();
                    List <CDCDS.CDC_ARTICOLI_SPESSORIRow>   artspessori   = _DS.CDC_ARTICOLI_SPESSORI.Where(x => x.IDARTICOLO == arow.IDARTICOLO).OrderBy(x => x.IDSPESSORE).ToList();
                    if (artspessori.Count == 0 || artdimensioni.Count == 0)
                    {
                        riga.Cells[1].Style.BackColor = Color.Orange;
                        riga.Cells[2].Style.BackColor = Color.Orange;
                    }
                    else
                    {
                        riga.Cells[1].Style.BackColor = Color.White;
                        riga.Cells[2].Style.BackColor = Color.White;
                    }
                }
            }

            dgvArticoli.DataSource = null;
            dgvArticoli.DataMember = "";

            dgvDimensioni.DataSource = null;
            dgvDimensioni.DataMember = "";

            dgvSpessori.DataSource = null;
            dgvSpessori.DataMember = "";
        }