Never stop learning, approaching the AI
  • 😄About
  • 🅰️AI-Candy on YouTube
    • 🎬YouTube 视频列表
    • 💠AI项目本地部署
      • 1️⃣安装 Pytorch 运行环境
      • 2️⃣在Python虚拟环境下使用 VS Code or PyCharm
        • VS Code Python format
      • 3️⃣Create python virtual environment in Linux
    • 👽AI 入门系列课程
      • 0️向量及向量运算
        • Reshape array code
      • 1️人工智能,机器学习,深度学习 和神经网络的区别
      • 2️卷积神经网络(CNN)
        • 3D CNN sample code
      • 3️Transformer 原理
      • 4️前馈神经网络 (FNN)
  • 🎭Artificial intelligence
    • 1️⃣Deep learning / machine learning
      • 👉Deep Learning Resources
      • 👉Deep learning notes
    • 2️⃣Python
      • Youtube音乐下载
      • Pytorch 安装环境配置 (old)
        • TorchEEG
      • Anaconda3 Python path
      • Data
      • IEEE-754 Floating Point Converter
        • ieee 754 conversion function
      • 文件读写
      • 文本清理
      • Python 下载在线视频
      • 修改Jupyter Notebook 默认工作目录
    • 3️⃣AI Websites
  • 🪤Programming
    • SQL
      • Delete data and reset auto-increment ID
    • Angular
      • Angular-datatables, dd/MM/yyyy, sorting (no paged list)
      • Datatables save state using localStorage
      • Variable storage method
      • Colour picker
      • Error fix for click columns on Datatable
      • Auto address use Google place
      • Auto address use Azure Maps
      • Upload file to Server
      • Validators.required OnChange input
      • Date, Time field
      • VS Code: Auto add missing imports when save
      • Datatable setting
      • Date time format
      • sticky <th> and <td> content
      • Filter booked time
      • Dropdown time selection with interval
      • Angular date online test
      • Updating data without refreshing the page
      • Object array sort and sum
      • Multi-type of columns use in one column
      • Select button for datatables
      • Switch button and event
      • Delete column from Array
      • Three-layer structure
      • Remove shadow when print mat-dialog content
      • JSON Parse && Object Array
      • Detect unused import in Typescript
      • Change location using radio button
      • display multi line message in the Toastr
      • Custom LOCALE_ID
      • Batch add data from csv to API server
        • Angular read csv and upload to Server
      • USB Port reader Web solution
      • Debug Angular app using JavaScript Debugger in VS Code
      • Skills
        • FormData & FormGroup to JSON
        • Dropdown list (customer)
        • Get current datetime
        • Get first day of year, month, and date
        • Call a function in a forEach loop
        • disable and readonly
        • Form element value
        • HTML input type
        • Input pattern (validation)
      • Display pipe (UI format)
        • Input upper case and button checked
        • Icons (Bootstrap and CoreUI)
        • Page Refresh
        • Selection list (two ways)
        • onChange Selection event
        • Random Password and Toggle
        • Password match
        • Select checkbox disable
      • Print and save to PDF
      • Import JS into Angular
      • LocalStorage
      • Angular DataTable
        • Data sort
        • A sample usage
        • Angular DataTable server side big data query
      • Change chart.js chart type
      • Angular UI - .NET API - .NET Auth
      • Angular - .NET API
      • *ngIf else && change to @if
      • Angular add reCAPTCHA v3 (Google)
      • Angular update
        • Update from v13 to v15
        • Update from v15 to v18
      • Angular application version central
      • Face detection
        • Face-api.js
      • Angular, Node version compatibility matrix
      • Clear cache
      • Angular oauth2 OIDC
      • Angular add header
    • .NET Skills
      • Add ID manually
      • Auto Mapping
        • Ignore Nesting
        • Startup setting
        • Datetime processing in AutoMapping
        • AutoMapper example
      • Validation filter
      • BaseController
      • Group by many
      • Database first, scaffold to class
      • Log setting and exception handler
      • Update appsetting.json value
      • Azure service bus message (queue)
      • Read appsetting.json value
      • Auth get user info by email
      • Azure Time zone
      • .NET API Add Service
      • Object comparison
      • Coravel Schedule
        • Read appsettings.json
      • .Net Core RDLC Report, Coravel and Email
      • Check Network and SQL server connections.
      • Datatime custom format
      • Many to Many EF
        • Many to Many CheckBox
      • PDFpig: Send Email with PDF attachment
      • .NET Core Middleware order
      • .NET API add Worker Service
      • .NET Router
      • Partial columns update
      • Add and Delete
      • 图片自适应宽度
      • ASP.NET Identity
      • Upload file to Azure
        • Upload file to Blob
      • Developer Guide
      • Code first one-many
      • ASP.NET MVC 5 Custom Error Page
      • VS can't debug
      • 通过邮编查 NSW COVID-19 感染人数
      • Jquery File Upload
      • Jquery Datepicker
      • ajax delete file from server
      • Autofac in MVC
      • Autofac in .NET Core
      • .NET Core
      • HTTP Return code
      • IdentityServer4
    • Power BI
      • Add parameter to PowerBI report
      • Convert UTC to Local time
      • Python in PowerBI
        • IEEE-754 conversion
      • PowerBI embed app - Server
      • PowerBI embed app - Client
        • Setting on portal
    • Azure service
      • Key Vault
      • Service bus - queue
      • Power Automate
      • Kusto Query Language
      • Azure Data Explorer
      • Reserved keyword on Azure Error
      • SQL Azure time convert
    • Azure blob
      • Azure blob setting
      • Display image from Blob
      • Upload image to Blob through .NET API
    • Html Bootstrap Icon, colour, size
      • Html spacing
      • Html text alignment
    • Video stream - JsMpeg
      • SSL - generate key
      • Client (SSL)
      • Websocket-Server (SSL)
      • Play RTSP video stream
    • ⏰Time Zone
      • datetime-local set date range
      • 🕐Get data by local time (UI, API)
      • 🕑Add offset hours for local UI and report
      • 🕒UTC time and Datetime convert
      • 🕓Angular - Timezone selection
      • 🕔Angular - Convert UTC to local time
      • 🕕C# Time Zone
  • >>>>>>>>>>>>>>>>>>>>>>>>>>>>
  • 🪜Apps and Skills
    • 1️Windows system app skills
      • Brother HL-2130 打印机 Toner 报警
      • VS Code 快捷键
      • Check SHA256 on windows
      • blob 视频下载
      • Photoshop 制作证件照片
      • 获取 Windows Key
      • 10进制36进制互转
      • Error when publish to Azure
      • Disable windows automatic update
      • Outlook setup for Yahoo Email
      • IIS setting
      • Windows 8/10, IIS Service
      • 安装程序出错 2052,2053 报警
      • 6 Yao Chinese UI
    • 2️Linux command
    • 3️Git command
    • 4️Bitbucket
    • 5️Gitbook Skills
    • 6️GitHub Desktop
    • 7️⃣EndNote
      • EndNote V21
      • Endnote使用技巧
      • 批量删除/修改Endnote 中 notes 栏内容
  • Android mobile connect PC
  • 💎USEFUL LINKS
    • 1️Coding websites
      • Website links
    • 2️Windows 平台工具,网站
    • 3️PotPlayer 设置
  • >>>>>>>>>>>>>>>>>>>>>>>>>>>>
  • 🚩Research >>EEG
    • 1️EEG基本知识的理论介绍
      • EEG 简介
      • EEG 的节律信号
      • EEG电极帽
      • EEG 伪迹
      • ERP 介绍
      • ERP 成分
      • EEG 数据分析软件
    • 2️LSL 应用
    • 3️EEG公开数据集汇总整理
    • 4️REDCap
      • Migration (Export & Import)
    • 5️⃣ScaneR
  • ☕Buy me a coffee
Powered by GitBook
On this page

Was this helpful?

  1. Programming
  2. .NET Skills
  3. Many to Many EF

Many to Many CheckBox

Company 1--* CompanyWastetype *--1 WasteType

// Angular Html

    <div class="form-group mb-2">
      <label>Waste Type</label> <span style="color: red;"> *</span>
    </div>

    <div class="form-group mb-2">
      <section
        style="height: 200px; overflow:hidden; overflow-y:scroll;background-color: rgb(245 245 245); padding: 10px 0 10px 0; border: 1px solid rgb(197 187 187);border-radius: 0.25rem;">
        <span style="padding-left: 10px;">
          <mat-checkbox [checked]="allComplete" [color]="WasteTypeCheckBox.color" [indeterminate]="someComplete()"
            (change)="setAll($event.checked)">
            {{WasteTypeCheckBox.name}}
          </mat-checkbox>
        </span>

        <div *ngFor="let item of WasteTypeCheckBox.wastetypes let i=index"
          style="list-style-type: none; margin-top: 6px; margin-left: 20px; " >
          <input type="checkbox" formArrayName="selectedWasteTypes" [value]="item.wastetypeid" [checked]="item.selected"
            (change)="onCheckboxChange(item.wastetypeid, $event)" style="cursor: pointer;" />
          {{item.wastetypeid}} - {{item.wastetypename | titlecase}}
        </div>
      </section>
    </div>
	

// API View Model
   public class CompanyViewModel
    {
        public long Companyid { get; set; }
        public long[] SelectedWasteTypes { get; set; }
        public ICollection<CompanyWastetype> CompanyWastetypes { get; set; }
    }
       

await insertCompanyWastetype(company, companyVM.SelectedWasteTypes);

// add record in CompanyWasteType
private async Task<IActionResult> insertCompanyWastetype(Company company, long[] selectedWasteTypes)
{
    foreach (int wastetypeid in selectedWasteTypes)
    {
        CompanyWastetype companyWastetype = new CompanyWastetype();
        companyWastetype.Companyid = company.Companyid;
        companyWastetype.Wastetypeid = wastetypeid;
        await _companyWasteTypeRepository.AddAsync(companyWastetype);

        if (await _unitOfWork.SaveAsyc() < 0)

            return BadRequest("Could not create CompanyWastetype");

    }

    return Ok();  //company
}

// remove all record in CompanyWasteType
private async Task<IActionResult> deleteCompanyWastetype(Company company, long[] selectedWasteTypes)
{
    foreach (int wastetypeid in selectedWasteTypes)
    {

        var record = await _companyWasteTypeRepository.GetWhereAsync(a => a.Companyid == company.Companyid && a.Wastetypeid == wastetypeid);
        if (record == null)
            return NotFound();

        try
        {
            if (record.Count() > 0)
            {
                _companyWasteTypeRepository.Remove((CompanyWastetype)record);

                if (await _unitOfWork.SaveAsyc() <= 0)
                {
                    _logger.LogWarning($"Company id = {wastetypeid} has deleted ");
                    //  return NoContent();
                    return BadRequest($"Could not update company id= {company.Companyid}");
                }
            }
        }
        catch (Exception ex)
        {
            _logger.LogInformation($"Exception: " + ex.Message);
        }

    }
    return Ok();

}
// Angular .ts UI


  wastetypeList?: Wastetype[];
  allComplete: boolean = false;

  WasteTypeCheckBox: WastetypeList = {
    name: 'Select All',
    completed: false,
    color: 'primary',
    indeterminate: false,
    wastetypes: this.wastetypeList
  };

 	
  initialForm(data: any) {
    this.submitClicked = false;

    this.frm = this.fb.group({
      companyid: [{ value: 0, disabled: !this.is_edit }],
       selectedWasteTypes: new FormArray([])
    });

    if (data.action == 'Edit') {
      this.frm = this.fb.group({
        companyid: data.company.companyid,
        selectedWasteTypes: new FormArray([])
      });
    }
    this.getWastetypeList(data);
  }	
	
	
  getWastetypeList(data: any) {
    return this.wastetypeService.getAllWastetypes().subscribe({
      next: (res) => {
        this.WasteTypeCheckBox.wastetypes = res;
        if (data.action == 'Edit') {
          this.setSelectedWasteTypes(data);   《《《《《《
        }
      },
      error: (error) => {
        console.log('Error: retrive Wastetype list error - ' + error);
        this.toastr.warning(error.status + '- retrive data error', 'Fail');
      },
    });
  }


  setSelectedWasteTypes(data: any) {
    const selectedWasteTypesArray = (this.frm.controls['selectedWasteTypes'] as FormArray);
    let wasteTypeArray = data.company.selectedWasteTypes;

    for (let i = 0; i < wasteTypeArray.length; i++) {
      let wasteTypeId = wasteTypeArray[i];

      selectedWasteTypesArray.push(new FormControl(wasteTypeId));
      let wastetype = this.WasteTypeCheckBox.wastetypes?.find(x => x.wastetypeid === Number(wasteTypeId));
      if (wastetype != undefined && wastetype != null) {
        wastetype!.selected = true;
      }
    }

    if (this.WasteTypeCheckBox.wastetypes?.length != wasteTypeArray.length) {
      // this.allComplete = true;
      this.someComplete();
    }
    else {
      //  this.allComplete = false;

      let completed = false;
      if (wasteTypeArray.length > 0)
        completed = true;
      this.setAll(completed);
    }
  }

  someComplete(): boolean {
    if (this.WasteTypeCheckBox.wastetypes == null) {
      return false;
    }
    return this.WasteTypeCheckBox.wastetypes.filter(t => t.selected == true).length > 0 && !this.allComplete;
  }

  setAll(completed: boolean) {
    this.allComplete = completed;

    if (this.WasteTypeCheckBox.wastetypes == null) {
      return;
    }

    const selectedWasteTypesArray = (this.frm.controls['selectedWasteTypes'] as FormArray);
    selectedWasteTypesArray.clear();

    this.WasteTypeCheckBox.wastetypes.forEach(t => {
      t.selected = completed;
      if (completed) {
        selectedWasteTypesArray.push(new FormControl(t.wastetypeid));
      }
    })
  }

  onCheckboxChange(wastetypeid: Number, event: any) {
    const selectedWasteTypesArray = (this.frm.controls['selectedWasteTypes'] as FormArray);
    const index = selectedWasteTypesArray.controls.findIndex(x => x.value === wastetypeid);

    if (event.target.checked) {
      if (index == -1) {
        selectedWasteTypesArray.push(new FormControl(wastetypeid));
      }
    } else {
      selectedWasteTypesArray.removeAt(index);
    }

    let wastetype = this.WasteTypeCheckBox.wastetypes?.find(x => x.wastetypeid === wastetypeid);
    wastetype!.selected = event.target.checked;

    if (this.WasteTypeCheckBox.wastetypes!.filter(t => t.selected).length != this.WasteTypeCheckBox.wastetypes!.length)
      this.allComplete = false;
    else
      this.allComplete = true;
  }
PreviousMany to Many EFNextPDFpig: Send Email with PDF attachment

Last updated 1 year ago

Was this helpful?

🪤