public AdoDataTests() { gender = new Models.Gender() { Name = "TestGender" }; }
/// <summary> /// /// </summary> /// <param name="gender"></param> /// <returns></returns> public bool InsertGender(Models.Gender gender) { var n = new SqlParameter("name", gender.Name); var query = "insert into Monster.Gender(GenderName, Active) values (@name, 1)"; return(InsertData(query, n) == 1); }
//[Theory(gender = new Models.Gender() { Name = "blah", Active = true})] //[Theory(gender = new Models.Gender() { Name = "blah", Active = true })] //[Theory(gender = new Models.Gender() { Name = "blah", Active = true })] public void Theory_InsertGender(Models.Gender gender) { var data = new AdoData(); var actual = data.InsertGender(gender); Assert.True(actual); }
public static GenderDAO MapToGenderDAO(DA.Gender gender) { var g = new GenderDAO(); g.Id = gender.GenderId; g.Name = gender.GenderName; return(g); }
public bool UpdateGender(Models.Gender gender) { var query = "update Monster.Gender set Name = @name, Active = @active where GenderId = @id"; var name = new SqlParameter("name", gender.GenderName); var active = new SqlParameter("active", gender.Active ? 1 : 0); var id = new SqlParameter("id", gender.GenderId); int result; using (var connection = new SqlConnection(connectionString)) { var cmd = new SqlCommand(query, connection); connection.Open(); cmd.Parameters.AddRange(new SqlParameter[] { id, name, active }); result = cmd.ExecuteNonQuery(); } return(result >= 0); }