public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { 客戶資料Entities db = new 客戶資料Entities(); var data = db.客戶聯絡人.Where(p => p.客戶Id == 客戶Id && p.Id != Id).ToList(); if (data.Any(p => p.Email.ToLower() == Email.ToLower())) { yield return(new ValidationResult("同一個客戶下的聯絡人,其 Email 不能重複", new[] { "Email" })); } }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { 客戶資料Entities db = new 客戶資料Entities(); var userName = HttpContext.Current.User.Identity.Name; string strPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(PassWord + userName.ToLower(), "SHA1"); if (!db.客戶資料.Where(p => p.帳號 == userName).Any(p => p.密碼 == strPassword)) { yield return(new ValidationResult("密碼輸入錯誤!!", new[] { "PassWord" })); } }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { 客戶資料Entities db = new 客戶資料Entities(); if (db.客戶資料.Any(p => p.帳號.ToLower() == Account.ToLower()) || Account.ToLower().Contains("admin")) { yield return(new ValidationResult("已有相同的帳號存在!!", new[] { "Account" })); } if (!db.客戶資料.Any(p => p.統一編號 == CompanyNo)) { yield return(new ValidationResult("客戶資料不存在!!", new[] { "CompanyNo" })); } }
public IEnumerable <ValidationResult> Validate(ValidationContext validationContext) { 客戶資料Entities db = new 客戶資料Entities(); var data = db.客戶資料.Where(p => p.Id != Id).ToList(); if (!string.IsNullOrEmpty(帳號) && data.Where(p => !string.IsNullOrEmpty(p.帳號)).Any(p => p.帳號.ToLower() == 帳號.ToLower())) { yield return(new ValidationResult("已有相同的帳號存在", new[] { "帳號" })); } if (data.Any(p => p.統一編號 == 統一編號)) { yield return(new ValidationResult("已有相同的客戶資料存在", new[] { "統一編號" })); } }