public bool CheckMailChanged(int id, string eMail) { bool resultValue = false; using (CustomEntities db = new CustomEntities()) { resultValue = db.客戶聯絡人.Any(c => c.Id == id && c.Email != Email.Trim()); } return(resultValue); }
public bool CheckEmailIsUnique(int CustID, string eMail) { bool resultValue = false; using (CustomEntities db = new CustomEntities()) { resultValue = db.客戶聯絡人.Any(c => c.客戶Id == CustID && c.Email == Email); } return(resultValue); }
/// <summary> /// 驗證銀行資訊是否重複 /// </summary> /// <param name="CustID"></param> /// <param name="BankNo"></param> /// <param name="SubNo"></param> /// <param name="AccountNo"></param> /// <returns></returns> public bool CheckBankNoIsExists(int CustID, int BankNo, int?SubNo, string AccountNo) { bool resultValue = false; using (CustomEntities db = new CustomEntities()) { resultValue = db.客戶銀行資訊.Any(b => b.客戶Id == CustID && b.銀行代碼 == BankNo && b.分行代碼 == SubNo && b.帳戶號碼 == AccountNo); } return(resultValue); }