public static List <SelectionCategoryDetail> GetSelect(int equipmentId)
{
var db = SelectionCategoryDetail.GetDatabase();
string sql = @"
SELECT * FROM SelectionCategoryDetails
WHERE
EquipmentId = '" + equipmentId + @"'
ORDER BY
SelectionCategoryId,
EquipmentId";
return(db.ExecuteQuery <SelectionCategoryDetail>(sql));
}
public static void Delete(int categoryId)
{
var db = SelectionCategoryDetail.GetDatabase();
db.ExecuteNonQuery("DELETE FROM SelectionCategoryDetails WHERE SelectionCategoryId = " + categoryId);
}
public static void DeleteByEquipmentId(int equipmentId)
{
var db = SelectionCategoryDetail.GetDatabase();
db.ExecuteNonQuery("DELETE FROM SelectionCategoryDetails WHERE EquipmentId = " + equipmentId);
}