Exemple #1
0
        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));
        }
Exemple #2
0
        public static void Delete(int categoryId)
        {
            var db = SelectionCategoryDetail.GetDatabase();

            db.ExecuteNonQuery("DELETE FROM SelectionCategoryDetails WHERE SelectionCategoryId = " + categoryId);
        }
Exemple #3
0
        public static void DeleteByEquipmentId(int equipmentId)
        {
            var db = SelectionCategoryDetail.GetDatabase();

            db.ExecuteNonQuery("DELETE FROM SelectionCategoryDetails WHERE EquipmentId = " + equipmentId);
        }