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