private static int SaveOrganisationsToDb(OrganisationsInput organisations, CategoriesInput categories)
{
var changes = 0;
using (var context = new CdcsContext()) {
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Organisations.AddRange(organisations.Organisations);
context.Accreditors.AddRange(organisations.Accreditors);
context.Accreditations.AddRange(organisations.Accreditations);
context.ContactModes.AddRange(organisations.ContactModes);
context.GeographicalZones.AddRange(organisations.GeographicalZones);
context.OrganisationLanguages.AddRange(organisations.OrganisationLanguages);
context.OrganisationLegalStatuses.AddRange(organisations.OrganisationLegalStatuses);
context.Languages.AddRange(organisations.Languages);
context.Sectors.AddRange(categories.Sectors);
context.Topics.AddRange(categories.Topics);
context.Categories.AddRange(categories.Categories);
context.SectorCategoriesHierarchies.AddRange(categories.SectorCategoriesHierarchies);
changes = context.SaveChanges();
}
return(changes);
}
// get all menu items
public List <SearchAvitoPictureOutput> GetCategoryItems(CategoriesInput input)
{
var categoryList = new List <SearchAvitoPictureOutput>();
using (IDbConnection db = new SqlConnection(Global.Connection))
{
categoryList = db.Query <SearchAvitoPictureOutput>("sp_SearchAvitoPictureAll",
input, commandType: CommandType.StoredProcedure).ToList();
}
return(categoryList);
}
public IActionResult GetCategories([FromBody] CategoriesInput model)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var catRecursion = new CategoryRecursion();
var outputCategories = repo.GetCategoryItems(model);
return(Ok(catRecursion.GenerateCategories(outputCategories)));
}
