public bool InsertMonster(Models.Monster monster) { var genderid = new SqlParameter("genderid", monster.GenderId); var titleid = new SqlParameter("titleid", monster.TitleId); var typeid = new SqlParameter("typeid", monster.TypeId); var name = new SqlParameter("name", monster.Name); var picturepath = new SqlParameter("picturepath", monster.PicturePath); var query = "insert into Monster.Monster(GenderId, TitleId, TypeId, Name, PicturePath, Active) values (@genderid, @titleid, @typeid, @name, @picturepath, 1)"; return(InsertData(query, genderid, titleid, typeid, name, picturepath) == 1); }
public bool DeleteMonster(Models.Monster monster) { var query = "delete Monster.Monster where MonsterId = @id"; 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.Add(id); result = cmd.ExecuteNonQuery(); } return(result >= 0); }
public AdoDataTests() { gender = new Models.Gender() { Name = "TestGender" }; monsterType = new Models.MonsterType() { Name = "TestType" }; title = new Models.Title() { Name = "TestType" }; monster = new Models.Monster() { GenderId = 1, TitleId = 1, TypeId = 1, Name = "TestMonster", PicturePath = "TestPath" }; }
public bool UpdateMonster(Models.Monster monster) { var query = "update Monster.Monster set GenderId = @genderid, TitleId = @titleid, TypeId = @typeid, Name = @name, PicturePath = @picturepath, Active = @active where MonsterId = @id"; var genderid = new SqlParameter("genderid", monster.GenderId); var titleid = new SqlParameter("titleid", monster.TitleId); var typeid = new SqlParameter("typeid", monster.TypeId); var name = new SqlParameter("name", monster.Name); var picturepath = new SqlParameter("picturepath", monster.PicturePath); var active = new SqlParameter("active", monster.Active ? 1 : 0); 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, genderid, titleid, typeid, name, picturepath, active }); result = cmd.ExecuteNonQuery(); } return(result >= 0); }