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 <DescriptionCatalog> FindOrCreateDescriptionCatalogAsync(this CarContext carContext, string name)
{
var query = @"EXECUTE [dbo].[FindOrCreateDescriptionCatalog]
@Name";
var parName = CarContextExtentions.ParNameInput(name);
return(carContext.DescriptionCatalog.FromSqlRaw(query, parName).AsEnumerable().First());
}
public static Models.MakeCatalog FindOrCreateMakeCatalogAsync(this CarContext carContext, string name)
{
var query = @"EXECUTE [dbo].[FindOrCreateMakeCatalog]
@Name
,@Id OUTPUT";
var parName = CarContextExtentions.ParNameInput(name);
var parId = CarContextExtentions.ParIdOutput();
carContext.Database.ExecuteSqlRaw(
query,
parName,
parId);
var mark = new Models.MakeCatalog
{
Id = (Guid)parId.Value,
Name = name
};
return(mark);
}
