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 <EquipmentCatalog> FindOrCreateEquipmentCatalogAsync(this CarContext carContext, int databaseId) { var query = @"EXECUTE [dbo].[FindOrCreateEquipmentCatalog] @DatabaseId"; var parDatabaseId = CarContextExtentions.ParDatabaseIdInput(databaseId); return(carContext.EquipmentCatalog.FromSqlRaw(query, parDatabaseId).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()); }
private static DataTable CreateMakesTable(params string[] names) { var dt = CarContextExtentions.CreateDataTable("Name"); foreach (var name in names) { dt.Rows.Add(name); } return(dt); }
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()); }
private static DataTable CreateModelsTable(params Tuple <string, string>[] rows) { var dt = CarContextExtentions.CreateDataTable ( "MakeName", "ModelName" ); foreach (var row in rows) { dt.Rows.Add(row.Item1, row.Item2); } return(dt); }
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()); }
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 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); }
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()); }
public static Microsoft.Data.SqlClient.SqlParameter ParDatabaseIdInput(int databaseId) { return(CarContextExtentions.CreateParInt("@DatabaseId", databaseId)); }