public static async Task <FeatureCatalog> FindOrCreateFeatureCatalogAsync( this CarContext carContext, Guid descriptionCatalogId, string name, bool?standart, string value) { var query = @"EXECUTE [dbo].[FindOrCreateFeatureCatalog] @DescriptionCatalogId, @Name, @Standart, @Value"; var parDescId = CarContextExtentions.CreateParGuid("@DescriptionCatalogId", descriptionCatalogId); var parName = CarContextExtentions.ParNameInput(name); var parStandart = CarContextExtentions.CreateParBit("@Standart", standart); var parValue = CarContextExtentions.CreateParNVarchar("@Value", value, 250); return(carContext.FeatureCatalog.FromSqlRaw( query, parDescId, parName, parStandart, parValue ).AsEnumerable().First()); }
public static async Task ActivateNewSpecificationCatalogAsync( this CarContext carContext, Guid equipmentCatalogId ) { var query = @"EXECUTE [dbo].[ActivateNewSpecificationCatalog] @EquipmentCatalogId"; var parEqId = CarContextExtentions.CreateParGuid("@EquipmentCatalogId", equipmentCatalogId); carContext.Database.ExecuteSqlRaw(query, parEqId); }
public static async Task <EquipmentVersionCatalog> FindOrCreateEquipmentVersionCatalogAsync(this CarContext carContext, Guid equipmentCatalogId, Guid versionCatalogId) { var query = @"EXECUTE [dbo].[FindOrCreateEquipmentVersionCatalog] @VersionCatalogId, @EquipmentCatalogId"; var parEqId = CarContextExtentions.CreateParGuid("@EquipmentCatalogId", equipmentCatalogId); var parVerId = CarContextExtentions.CreateParGuid("@VersionCatalogId", versionCatalogId); return(carContext.EquipmentVersionCatalog.FromSqlRaw(query, parEqId, parVerId).AsEnumerable().First()); }
public static async Task <SpecificationCatalog> FindOrCreateSpecificationCatalogAsync( this CarContext carContext, Guid equipmentCatalogId, Guid featureCatalogId ) { var query = @"EXECUTE [dbo].[FindOrCreateSpecificationCatalog] @EquipmentCatalogId, @FeatureCatalogId"; var parEqId = CarContextExtentions.CreateParGuid("@EquipmentCatalogId", equipmentCatalogId); var parFeatId = CarContextExtentions.CreateParGuid("@FeatureCatalogId", featureCatalogId); return(carContext.SpecificationCatalog.FromSqlRaw(query, parEqId, parFeatId).AsEnumerable().First()); }
public static async Task <SpecificationInclusionCatalog> FindOrCreateSpecificationInclusionsCatalogAsync( this CarContext carContext, Guid inclusionCatalogId, Guid specificationCatalogId ) { var query = @"EXECUTE [dbo].[FindOrCreateSpecificationInclusionCatalog] @InclusionCatalogId, @SpecificationCatalogId"; var parIncId = CarContextExtentions.CreateParGuid("@InclusionCatalogId", inclusionCatalogId); var parSpecId = CarContextExtentions.CreateParGuid("@SpecificationCatalogId", specificationCatalogId); return(carContext.SpecificationInclusionCatalog.FromSqlRaw(query, parIncId, parSpecId).AsEnumerable().First()); }
public static async Task <PricelistCatalog> FindOrCreatePricelistCatalogAsync ( this CarContext carContext, string colorName, bool?metallic, string hue, string picture, string price, DateTime?productionFromDate, DateTime?validFromDate, Guid equipmentCatalogId ) { var query = @"EXECUTE [dbo].[FindOrCreatePricelistCatalog] @ColorName, @Metallic, @Hue, @Picture, @Price, @ProductionFromDate, @ValidFromDate, @EquipmentCatalogId"; var parColorName = CarContextExtentions.CreateParNVarchar("@ColorName", colorName, 250); var parMet = CarContextExtentions.CreateParBit("@Metallic", metallic); var parHue = CarContextExtentions.CreateParNVarchar("@Hue", hue, 250); var parPicture = CarContextExtentions.CreateParNVarchar("@Picture", picture, 250); var parPrice = CarContextExtentions.CreateParNVarchar("@Price", price, 20); var parProductFromDate = CarContextExtentions.CreateParDateTime2("@ProductionFromDate", productionFromDate); var parValidFromDate = CarContextExtentions.CreateParDateTime2("@ValidFromDate", validFromDate); var parEquipmentCatalogId = CarContextExtentions.CreateParGuid("@EquipmentCatalogId", equipmentCatalogId); return(carContext.PricelistCatalog.FromSqlRaw ( query, parColorName, parMet, parHue, parPrice, parProductFromDate, parValidFromDate, parPicture, parEquipmentCatalogId ).AsEnumerable().FirstOrDefault()); }