public void SaveUserStatePolicy(int userID, StatePolicy policy)
{
dbConnection.CheckInput(policy.GetStateString());
string [] valuesNames = { "@idParam", "@stateParam" };
object[] values = { userID, policy.GetStateString() };
dbConnection.InsertTable("StatePolicy", "SystemID,State", valuesNames, values);
}
private StatePolicy[] LoadUserStatePolicy(int userID)
{
List <StatePolicy> loadedStatesPolicies = new List <StatePolicy>();
using (var dbReader = dbConnection.SelectFromTableWithCondition("StatePolicy", "State", "SystemID = " + userID))
{
while (dbReader.Read())
{
StatePolicy.State state = StatePolicy.GetStateFromString(dbReader.GetString(0));
loadedStatesPolicies.Add(new StatePolicy(state));
}
}
return(loadedStatesPolicies.ToArray());
}