public CustomerPointAccount GetCustomerPointAccount(int CustomerID, int PointAccountID)
{
var result = new CustomerPointAccount();
using (var reader = GetContext().GetReader(@"
SELECT
PointAccountID,
CustomerID,
PointBalance
FROM CustomerPointAccounts
WHERE
CustomerID = {0}
AND PointAccountID = {1}
", CustomerID, PointAccountID))
{
if (!reader.Read())
{
return(null);
}
result.CustomerID = reader.GetInt32("CustomerID");
result.PointAccountID = reader.GetInt32("PointAccountID");
result.Balance = reader.GetDecimal("PointBalance");
}
return(result);
}
public CustomerPointAccount GetCustomerPointAccount(int CustomerID, int PointAccountID)
{
var result = new CustomerPointAccount();
var response = GetContext().CustomerPointAccounts
.Where(c => c.CustomerID == CustomerID)
.Where(c => c.PointAccountID == PointAccountID)
.FirstOrDefault();
if (response == null)
{
return(null);
}
result.CustomerID = CustomerID;
result.PointAccountID = PointAccountID;
result.Balance = response.PointBalance;
return(result);
}
public CustomerPointAccount GetCustomerPointAccount(int CustomerID, int PointAccountID)
{
var result = new CustomerPointAccount();
var response = GetContext().GetPointAccount(new GetPointAccountRequest()
{
CustomerID = CustomerID,
PointAccountID = PointAccountID
});
if (response == null)
{
return(null);
}
result.CustomerID = CustomerID;
result.PointAccountID = PointAccountID;
result.Balance = response.Balance;
return(result);
}