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" }));
}
}
}
