private void LoadGridMappingUser() { m_FlagGrdUserLoaded = false; ExternUser externUser = new ExternUser(); grdUser.DataSource = externUser.getListMapping(m_ExternSystemID); grdUser.DataMember = "Table"; grdUser.Columns["externuserid"].Visible = false; grdUser.Columns["externuser"].HeaderText = "UserID Externe"; grdUser.Columns["externuser"].Width = 130; grdUser.Columns["emplid"].HeaderText = "UserID Messenger"; grdUser.Columns["emplid"].Width = 130; grdUser.Columns["login"].HeaderText = "Login"; grdUser.Columns["login"].Width = 130; grdUser.Columns["lname"].HeaderText = "Nom"; grdUser.Columns["lname"].Width = 130; grdUser.Columns["fname"].HeaderText = "Prénom"; grdUser.Columns["fname"].Width = 130; grdUser.Columns["externuserid"].ReadOnly = true; grdUser.Columns["emplid"].ReadOnly = true; grdUser.Columns["login"].ReadOnly = true; grdUser.Columns["lname"].ReadOnly = true; grdUser.Columns["fname"].ReadOnly = true; grdUser.Columns["externuser"].DefaultCellStyle.BackColor = Color.LightGreen; m_FlagGrdUserLoaded = true; }
private void grdUser_CellValueChanged(object sender, DataGridViewCellEventArgs e) { ExternUser externUser; int newID; if (m_FlagGrdUserLoaded) { externUser = new ExternUser(); if (grdUser[grdUser.Columns["externuser"].Index, e.RowIndex].Value.ToString() == "") { MessageBox.Show("Le mapping ne peut pas être vide", "Team Editor"); LoadGridMappingUser(); return; } // check if the externuser is already created if (grdUser[grdUser.Columns["externuserid"].Index, e.RowIndex].Value.ToString() == "") { externUser.ExternUserValue = grdUser[grdUser.Columns["externuser"].Index, e.RowIndex].Value.ToString(); externUser.ExternSystemID = m_ExternSystemID; externUser.EmplID = Convert.ToInt32(grdUser[grdUser.Columns["emplid"].Index, e.RowIndex].Value); newID = externUser.Add(); if (newID != -1) { m_FlagGrdUserLoaded = false; grdUser[grdUser.Columns["externuser"].Index, e.RowIndex].Value = externUser.ExternUserValue; grdUser[grdUser.Columns["externuserid"].Index, e.RowIndex].Value = newID; grdUser[grdUser.Columns["emplid"].Index, e.RowIndex].Value = externUser.EmplID; // update the usererable grid LoadGridMappingUser(); m_FlagGrdUserLoaded = true; } } else { // update externUser.Load(Convert.ToInt32(grdUser[grdUser.Columns["externuserid"].Index, e.RowIndex].Value)); externUser.ExternUserValue = grdUser[grdUser.Columns["externuser"].Index, e.RowIndex].Value.ToString(); externUser.Update(); } } }