public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
        {
            var db = new 客戶資料Entities();

            if (this.Id == 0)
            {
                if (db.客戶聯絡人.Where(s => s.客戶Id == this.客戶Id && s.Email == this.Email).Any())
                {
                    yield return(new ValidationResult("Email 已存在", new string[] { "Email" }));
                }
            }
            else
            {
                if (db.客戶聯絡人.Where(s => s.Id != this.Id && s.客戶Id == this.客戶Id && s.Email == this.Email).Any())
                {
                    yield return(new ValidationResult("Email 已存在", new string[] { "Email" }));
                }
            }

            yield return(ValidationResult.Success);
        }
Пример #2
0
        public IEnumerable <ValidationResult> Validate(ValidationContext validationContext)
        {
            客戶資料Entities db    = new 客戶資料Entities();
            var          客戶聯絡人 = db.客戶聯絡人.AsQueryable();

            bool checkExistingEmail = false;

            if (this.Id == 0)
            {
                checkExistingEmail = 客戶聯絡人.Any(x => x.是否已刪除 == false && x.客戶Id == 客戶Id && x.Email == Email);
            }
            else
            {
                checkExistingEmail = 客戶聯絡人.Any(x => x.是否已刪除 == false && x.客戶Id == 客戶Id && x.Email == Email && x.Id != this.Id);
            }

            if (checkExistingEmail)
            {
                yield return(new ValidationResult("已經存在相同的 Email", new string[] { "Email" })); //一個label只能有一個錯誤訊息
            }

            yield break;
        }