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); }