public int updateCustomerBalance(Customer customer)
{
SSGetService getService = new SSGetService();
SSAddService addService = new SSAddService();
Customer existingCustomer = getService.getCustomerById(customer.id);
if (existingCustomer.name != null)
{
using (SqlCommand command = new SqlCommand("UPDATE ss_customers SET account_balance=@balance, last_modified_date=getdate() WHERE id=" + existingCustomer.id + ""))
{
command.Parameters.AddWithValue("@balance", customer.account_balance);
int response = service.execute(command);
if (response > 0)
{
addService.addLog(new Log()
{
type = "Updated customer balance",
statement = command.CommandText,
description = "Updated [" + existingCustomer.id + "] Customer",
});
}
return(response);
}
}
else
{
return(-404);
}
}
