public string Save(NPCPresenceData item)
{
string query = "";
using (SqlCommand command = new SqlCommand())
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append(@"UPDATE [dbo].[npcpresence]
SET [name] = @name,[topx] = @topx,[topy] = @topy,[bottomx] = @bottomx,[bottomy] = @bottomy,[note] = @note,[spawnid] = @spawnid,[enabled] = @enabled,[roaming] = @roaming
,[roamingrespawnseconds] = @roamingrespawnseconds,[presencetype] = @presencetype,[maxrandomflock] = @maxrandomflock,[randomcenterx] = @randomcenterx,[randomcentery] = @randomcentery
,[randomradius] = @randomradius,[dynamiclifetime] = @dynamiclifetime ,[isbodypull] = @isbodypull,[isrespawnallowed] = @isrespawnallowed,[safebodypull] = @safebodypull
WHERE id=@presenceID;");
command.CommandText = sqlCommand.ToString();
command.Parameters.AddWithValue("@presenceID", item.id);
command.Parameters.AddWithValue("@name", item.name);
command.Parameters.AddWithValue("@note", item.note);
command.Parameters.AddWithValue("@topx", item.topx);
command.Parameters.AddWithValue("@topy", item.topy);
command.Parameters.AddWithValue("@bottomx", item.bottomx);
command.Parameters.AddWithValue("@bottomy", item.bottomy);
command.Parameters.AddWithValue("@spawnid", item.getNullableInt(item.spawnid));
command.Parameters.AddWithValue("@enabled", item.enabled);
command.Parameters.AddWithValue("@roamingrespawnseconds", item.roamingrespawnseconds);
command.Parameters.AddWithValue("@roaming", item.roaming);
command.Parameters.AddWithValue("@presencetype", item.presencetype);
command.Parameters.AddWithValue("@maxrandomflock", item.getNullableInt(item.maxrandomflock));
command.Parameters.AddWithValue("@randomcenterx", item.getNullableInt(item.randomcenterx));
command.Parameters.AddWithValue("@randomcentery", item.getNullableInt(item.randomcentery));
command.Parameters.AddWithValue("@randomradius", item.getNullableInt(item.randomradius));
command.Parameters.AddWithValue("@dynamiclifetime", item.getNullableInt(item.dynamiclifetime));
command.Parameters.AddWithValue("@isbodypull", item.isbodypull);
command.Parameters.AddWithValue("@isrespawnallowed", item.isrespawnallowed);
command.Parameters.AddWithValue("@safebodypull", item.safebodypull);
SqlConnection conn = new SqlConnection(this.ConnString);
conn.Open();
command.Connection = conn;
command.ExecuteNonQuery();
conn.Close();
query = command.CommandText;
foreach (SqlParameter p in command.Parameters)
{
if (p.ParameterName != "@presenceID")
{
if (SqlDbType.NVarChar.Equals(p.SqlDbType) || SqlDbType.VarChar.Equals(p.SqlDbType))
{
query = query.Replace(p.ParameterName, "'" + p.Value.ToString() + "'");
}
else
{
query = query.Replace(p.ParameterName, p.Value.ToString());
}
}
}
}
return(query);
}
public List <NPCPresenceData> getAll()
{
List <NPCPresenceData> list = new List <NPCPresenceData>();
using (SqlConnection conn = new SqlConnection(this.ConnString))
{
using (SqlCommand command = new SqlCommand())
{
StringBuilder sqlCommand = new StringBuilder();
sqlCommand.Append(@"SELECT DISTINCT * FROM [perpetuumsa].[dbo].[npcpresence]");
command.CommandText = sqlCommand.ToString();
command.Connection = conn;
conn.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
NPCPresenceData pres = new NPCPresenceData();
pres.id = Convert.ToInt32(reader["id"]);
pres.isbodypull = Convert.ToInt32(reader["isbodypull"]);
pres.isrespawnallowed = Convert.ToInt32(reader["isrespawnallowed"]);
pres.maxrandomflock = handleNullableInt(reader["maxrandomflock"]);
pres.name = Convert.ToString(reader["name"]);
pres.note = Convert.ToString(reader["note"]);
pres.presencetype = Convert.ToInt32(reader["presencetype"]);
pres.randomcenterx = handleNullableInt(reader["randomcenterx"]);
pres.randomcentery = handleNullableInt(reader["randomcentery"]);
pres.randomradius = handleNullableInt(reader["randomradius"]);
pres.roaming = Convert.ToInt32(reader["roaming"]);
pres.roamingrespawnseconds = Convert.ToInt32(reader["roamingrespawnseconds"]);
pres.safebodypull = Convert.ToInt32(reader["safebodypull"]);
pres.spawnid = handleNullableInt(reader["spawnid"]);
pres.topx = Convert.ToInt32(reader["topx"]);
pres.topy = Convert.ToInt32(reader["topy"]);
pres.bottomx = Convert.ToInt32(reader["bottomx"]);
pres.bottomy = Convert.ToInt32(reader["bottomy"]);
pres.dynamiclifetime = handleNullableInt(reader["dynamiclifetime"]);
pres.enabled = Convert.ToInt32(reader["enabled"]);
list.Add(pres);
}
}
}
}
return(list);
}
