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 <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());
}
public static async Task <InclusionCatalog> FindOrCreateInclusionCatalogAsync(
this CarContext carContext,
bool?standart,
string description)
{
var query = @"EXECUTE [dbo].[FindOrCreateInclusionCatalog]
@Standart,
@Description";
var parStandart = CarContextExtentions.CreateParBit("@Standart", standart);
var parDesc = CarContextExtentions.CreateParNVarchar("@Description", description, 255);
return(carContext.InclusionCatalog.FromSqlRaw(
query,
parStandart,
parDesc
).AsEnumerable().First());
}
