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); }