bool IEstateExperienceServiceInterface.TryGetValue(uint estateID, UEI experienceID, out EstateExperienceInfo info)
{
using (var conn = new NpgsqlConnection(m_ConnectionString))
{
conn.Open();
using (var cmd = new NpgsqlCommand("SELECT * FROM estateexperiences WHERE \"EstateID\" = @estateid AND \"ExperienceID\" = @experienceid LIMIT 1", conn))
{
cmd.Parameters.AddParameter("@estateid", estateID);
cmd.Parameters.AddParameter("@experienceid", experienceID.ID);
using (NpgsqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
info = new EstateExperienceInfo
{
EstateID = estateID,
ExperienceID = new UEI(experienceID),
IsAllowed = (bool)reader["IsAllowed"]
};
return(true);
}
}
}
}
info = default(EstateExperienceInfo);
return(false);
}
bool IEstateExperienceServiceInterface.TryGetValue(uint estateID, UUID experienceID, out EstateExperienceInfo info)
{
using (var conn = new MySqlConnection(m_ConnectionString))
{
conn.Open();
using (var cmd = new MySqlCommand("SELECT * FROM estateexperiences WHERE EstateID = @estateid AND ExperienceID = @experienceid", conn))
{
cmd.Parameters.AddParameter("@estateid", estateID);
cmd.Parameters.AddParameter("@experienceid", experienceID);
using (MySqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
info = new EstateExperienceInfo
{
EstateID = estateID,
ExperienceID = experienceID,
IsAllowed = reader.GetBool("IsAllowed")
};
return(true);
}
}
}
}
info = default(EstateExperienceInfo);
return(false);
}
bool IEstateExperienceServiceInterface.TryGetValue(uint estateID, UEI experienceID, out EstateExperienceInfo info)
{
RwLockedDictionary <UUID, EstateExperienceInfo> experiences;
if (m_Experiences.TryGetValue(estateID, out experiences) && experiences.TryGetValue(experienceID.ID, out info))
{
info = new EstateExperienceInfo(info);
return(true);
}
info = default(EstateExperienceInfo);
return(false);
}
void IEstateExperienceServiceInterface.Store(EstateExperienceInfo info)
{
var vals = new Dictionary <string, object>
{
["EstateID"] = info.EstateID,
["ExperienceID"] = info.ExperienceID,
["IsAllowed"] = info.IsAllowed
};
using (var conn = new NpgsqlConnection(m_ConnectionString))
{
conn.Open();
conn.ReplaceInto("estateexperiences", vals, StoreEstateExperiencesKey, m_EnableOnConflict);
}
}
void IEstateExperienceServiceInterface.Store(EstateExperienceInfo info)
{
var vals = new Dictionary <string, object>
{
["EstateID"] = info.EstateID,
["ExperienceID"] = info.ExperienceID.ID,
["IsAllowed"] = info.IsAllowed
};
using (var conn = new SqlConnection(m_ConnectionString))
{
conn.Open();
conn.ReplaceInto("estateexperiences", vals, new string[] { "EstateID", "ExperienceID" });
}
}
void IEstateExperienceServiceInterface.Store(EstateExperienceInfo info)
{
m_Experiences[info.EstateID][info.ExperienceID.ID] = new EstateExperienceInfo(info);
}
public EstateExperienceInfo(EstateExperienceInfo info)
{
EstateID = info.EstateID;
ExperienceID = new UEI(info.ExperienceID);
IsAllowed = info.IsAllowed;
}
