public static async Task <Models.ModelCatalog> FindOrCreateModelCatalogAsync ( this CarContext carContext, string makeName, string modelName) { var query = @"EXECUTE [dbo].[FindOrCreateModelCatalog] @MakeName ,@ModelName ,@Id OUTPUT"; var parMakeName = CarContextExtentions.CreateParNVarchar("@MakeName", makeName, 255); var parModelName = CarContextExtentions.CreateParNVarchar("@ModelName", modelName, 255); var parId = CarContextExtentions.ParIdOutput(); carContext.Database.ExecuteSqlRaw( query, parMakeName, parModelName, parId); var model = new Models.ModelCatalog { Id = (Guid)parId.Value, Name = modelName }; return(model); }
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 <ModificationCatalog> FindOrCreateModificationCatalogAsync ( this CarContext carContext, string makeName, string modelName, string StartProductionYear) { var query = @"EXECUTE [dbo].[FindOrCreateModificationCatalog] @MakeName ,@ModelName ,@StartProductionYearT"; var parMakeName = CarContextExtentions.CreateParNVarchar("@MakeName", makeName, 255); var parModelName = CarContextExtentions.CreateParNVarchar("@ModelName", modelName, 255); var parStartProductionYear = CarContextExtentions.CreateParNVarchar("@StartProductionYear", StartProductionYear, 10); return(carContext.ModificationCatalog.FromSqlRaw(query, parMakeName, parModelName, parStartProductionYear).AsEnumerable().First()); }
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()); }
public static async Task <VersionCatalog> FindOrCreateVersionCatalog ( this CarContext carContext, string makeName, string modelName, string versionName, string startProductionYear, string picture ) { var query = @"EXECUTE [dbo].[FindOrCreateVersionCatalog] @MakeName ,@ModelName ,@VersionName ,@StartProductionYear ,@Picture"; var makeNamePar = CarContextExtentions.CreateParNVarchar ("@MakeName", makeName, 250); var modelNamePar = CarContextExtentions.CreateParNVarchar ("@ModelName", modelName, 250); var versionNamePar = CarContextExtentions.CreateParNVarchar ("@VersionName", versionName, 250); var startProductionYearPar = CarContextExtentions.CreateParNVarchar ("@StartProductionYear", startProductionYear, 4); var picturePar = CarContextExtentions.CreateParNVarchar ("@Picture", picture, 250); return(carContext.VersionCatalog.FromSqlRaw(query, makeNamePar, modelNamePar, versionNamePar, startProductionYearPar, picturePar).AsEnumerable().First()); }