public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { var db = new 客戶資料Entities(); if (this.Id == 0) { //Create //相同客戶不能重複email if (db.客戶聯絡人.Where(p => p.客戶Id == this.客戶Id && p.Email == this.Email).Any()) { //綁訂欄位顯示錯誤訊息 yield return(new ValidationResult("Email已存在", new string[] { "Email" })); } } else { //Update //相同客戶不能重複email if (db.客戶聯絡人.Where(p => p.客戶Id != this.客戶Id && p.Email == this.Email).Any()) { yield return(new ValidationResult("Email已存在", new string[] { "Email" })); } } yield return(ValidationResult.Success); }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { var db = new 客戶資料Entities(); if (this.Id == 0) { //crate if (db.客戶聯絡人.Where(p => p.客戶Id == this.客戶Id && p.Email == this.Email).Any()) { yield return(new ValidationResult("Email已存在", new string[] { "Email" })); } } else { //upate if (db.客戶聯絡人.Where(p => p.客戶Id == this.客戶Id && p.Id != this.Id && p.Email == this.Email).Any()) { yield return(new ValidationResult("Email已存在", new string[] { "Email" })); } } }