Exemplos de Condominium_Management_System tblUserRole em C# (CSharp)

Exemplo n.º 1

Arquivo: frmUserRole.cs Projeto: ProgrammingCamp/c_sharp_desktop_ccondominium_ms_project

        private void btnDelete_Click(object sender, EventArgs e)
        {
            CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
            int userRoleID = int.Parse(listViewUserRole.Items[listViewUserRole.SelectedIndices[0]].SubItems[0].Text);

            tblUserRole oldUserRole = entity.tblUserRoles.Where(x => x.ID == userRoleID).FirstOrDefault();

            entity.tblUserRoles.Remove(oldUserRole);
            entity.SaveChanges();

            MessageBox.Show("User Role Deleted");
        }

Exemplo n.º 2

Arquivo: frmUserRole.cs Projeto: ProgrammingCamp/c_sharp_desktop_ccondominium_ms_project

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
            int userRoleID = int.Parse(listViewUserRole.Items[listViewUserRole.SelectedIndices[0]].SubItems[0].Text);

            tblUserRole oldUserRole = entity.tblUserRoles.Where(x => x.ID == userRoleID).FirstOrDefault();

            tblUserRole newUserRole = new Condominium_Management_System.tblUserRole();

            newUserRole.ID     = userRoleID;
            newUserRole.UserID = int.Parse(cboUser.SelectedValue.ToString());
            newUserRole.RoleID = int.Parse(cboRole.SelectedValue.ToString());

            entity.Entry(oldUserRole).CurrentValues.SetValues(newUserRole);
            entity.SaveChanges();

            MessageBox.Show("User Role Updated");
        }