public int Insert(LectureCategoryItem item) { string query = "Insert into LectureCategory(name) VALUES(@Name)"; IDbParameters param = CreateDbParameters(); param.AddWithValue("Name", item.Name).DbType = DbType.String; return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param)); }
public int Update(LectureCategoryItem item) { string query = "UPDATE LectureCategory SET name = @Name where id = @Id"; IDbParameters param = CreateDbParameters(); param.AddWithValue("Id", item.Id).DbType = DbType.Int32; param.AddWithValue("Name", item.Name).DbType = DbType.String; return(AdoTemplate.ExecuteNonQuery(CommandType.Text, query, param)); }