public bool UpdateMonster(Models.Monster monster) { var query = "update Monster.Monster set Name = @name, GenderId = @genderid, TitleId = @titleid, TypeId = @typeid, PicturePath = @picture, Active = @active where MonsterId = @id"; var name = new SqlParameter("name", monster.Name); var genderid = new SqlParameter("genderid", monster.GenderId); var titleid = new SqlParameter("titleid", monster.TitleId); var monstertypeid = new SqlParameter("typeid", monster.TypeId); var picture = new SqlParameter("picture", monster.PicturePath); var active = new SqlParameter("active", 1); var id = new SqlParameter("id", monster.MonsterId); int result; using (var connection = new SqlConnection(connectionString)) { var cmd = new SqlCommand(query, connection); connection.Open(); cmd.Parameters.AddRange(new SqlParameter[] { id, name, genderid, titleid, monstertypeid, picture, active }); result = cmd.ExecuteNonQuery(); } return(result >= 0); }
public bool InsertMonster(Models.Monster monster) { var name = new SqlParameter("name", monster.Name); var genderid = new SqlParameter("genderid", monster.GenderId); var titleid = new SqlParameter("titleid", monster.TitleId); var typeid = new SqlParameter("typeid", monster.TypeId); var picture = new SqlParameter("picture", monster.PicturePath); var active = new SqlParameter("active", 1); var query = "insert into Monster.Monster(Name, GenderId, TitleId, TypeId, PicturePath, Active) values (@name, @genderid, @titleid, @typeid, @picture, 1)"; return(InsertData(query, name, genderid, titleid, typeid, picture, active) == 1);; }