private void ExcelCaricaNuovoDocumentoFrm_Load(object sender, EventArgs e)
{
CDCBLL bll = new CDCBLL();
bll.CaricaBrands(_DS);
bll.CaricaEnti(_DS);//JACOPO
// 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 button2_Click(object sender, EventArgs e)
{
foreach (CDCDS.CDC_ENTIRow riga in _DS.CDC_ENTI.Rows)
{
if (riga.RowState == DataRowState.Added || riga.RowState == DataRowState.Modified)
{
riga.UTENTE = Contesto.Utente.FULLNAMEUSER;
riga.DATARIFERIMENTO = DateTime.Now;
}
}
CDCBLL bll = new CDCBLL();
bll.SalvaDatiEnti(_DS);
_DS.AcceptChanges();
_DS.CDC_ENTI.Clear();
bll.CaricaEnti(_DS);
}