public static int createDiscipline(
string name,
Measure measure,
Category category
)
{
executeSql(""
+ "INSERT INTO `" + tableName + "` "
+ "("
+ "`" + field_name + "`, "
+ "`" + field_measureId + "`, "
+ "`" + field_categoryId + "`"
+ ") VALUES ("
+ "'" + name + "', "
+ (measure == null ? "NULL" : measure.MeasureId.ToString()) + ", "
+ category.CategoryId
+ ")"
);
Dictionary<string, object> result = querySingleSql("SELECT MAX(`" + field_disciplineId + "`) AS `insertionId` FROM `" + tableName + "`");
int insertionId = Convert.ToInt32(result["insertionId"]);
return insertionId;
}
public static void deleteCategory(Category category)
{
executeSql(""
+ "DELETE FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_categoryId + " = " + category.CategoryId + " "
+ "LIMIT 1"
);
}
public Discipline(
int disciplineId,
string name,
Measure measure,
Category category
)
{
this.disciplineId = disciplineId;
this.name = name;
this.measure = measure;
this.category = category;
}
public Discipline(
int disciplineId,
string name,
Measure measure,
Category category,
List<DisciplineSetDisciplineMapping> disciplineSetDisciplineMappings,
List<Variant> variants
)
{
this.disciplineId = disciplineId;
this.name = name;
this.measure = measure;
this.category = category;
this.disciplineSetDisciplineMappings = disciplineSetDisciplineMappings;
this.variants = variants;
}
public static void updateCategory(Category category)
{
executeSql(""
+ "UPDATE "
+ "`" + tableName + "` "
+ "SET "
+ "`" + field_categoryName + "` = " + category.CategoryName + " "
+ "WHERE "
+ "`" + field_categoryId + " = " + category.CategoryId
);
}
public static Category getCategoryById(int categoryId)
{
Dictionary<string, object> result = querySingleSql(""
+ "SELECT "
+ "`" + field_categoryId + "`, "
+ "`" + field_categoryName + "` "
+ "FROM "
+ "`" + tableName + "` "
+ "WHERE "
+ "`" + field_categoryId + "` = " + categoryId
);
if (result == null)
{
return null;
}
Category category = new Category(
Convert.ToInt32(result[field_categoryId]),
Convert.ToString(result[field_categoryName])
);
return category;
}
