public static bool GetAccountByMobile(string mobile, int role) { string sql = "select COUNT(0) from Account (nolock) where IsDeleted=0 and Mobile=@mobile and Role=@role;"; return(DBAccess.ExecuteSql <int>(sql, new { mobile = mobile, role = role }) > 0); }
public static bool GetAccountByEmail(string email, int role) { string sql = "select COUNT(0) from Account (nolock) where IsDeleted=0 and Email=@email and Role=@role;"; return(DBAccess.ExecuteSql <int>(sql, new { email = email, role = role }) > 0); }