public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { 客戶資料Entities db = new 客戶資料Entities(); var data = db.客戶聯絡人; foreach (var item in data) { if ((item.Email.Trim().ToString() == this.Email.Trim()) && (item.客戶Id == this.客戶Id)) { yield return(new ValidationResult("Email重覆", new string[] { "Email" })); } yield break; } }
/// <summary> /// 加入模型驗證IValidatableObject /// </summary> public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { var db = new 客戶資料Entities(); if (this.Id == 0) { //Create if (db.客戶聯絡人.Where(p => p.客戶Id == this.客戶Id && p.Email == this.Email).Any()) { yield return(new ValidationResult("Email 已存在", new string[] { "Email" })); } } else { //Update 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" })); } } yield return(ValidationResult.Success); }
public EFUnitOfWork() { Context = new 客戶資料Entities(); }