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