public bool InactivateSpecies(FishSpecies item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Fish_Species efItem = context.Fish_Species.Where(b => b.SpeciesID == item.SpeciesID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SpeciesActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public async Task SeedAsync(ApplicationDbContext dbContext, IServiceProvider serviceProvider) { if (dbContext.FishSpecies.Any()) { return; } var fishSpeciesJson = File.ReadAllText(@"..\..\Data\FishMap.Data\Seeding\Data\FishSpecies.json"); var deserializedFishSpecies = JsonConvert.DeserializeObject <List <FishSpeciesDto> >(fishSpeciesJson); foreach (var fishSpecies in deserializedFishSpecies) { var fishSpeciesToAdd = new FishSpecies { Name = fishSpecies.Name, Description = fishSpecies.Description, IsCarnivore = fishSpecies.IsCarnivore, MinimumLegalSize = fishSpecies.MinimumLegalSize, Image = new Image { Url = fishSpecies.Image.Uri, }, }; await dbContext.AddAsync(fishSpeciesToAdd); } await dbContext.SaveChangesAsync(); }
public bool CreateSpecies(FishSpecies item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { short newid = context.Fish_Species.OrderByDescending(u => u.SpeciesID).FirstOrDefault().SpeciesID; newid++; Fish_Species efItem = new Fish_Species() { SpeciesID = newid, SpeciesActive = true, SpeciesName = item.SpeciesName }; context.Fish_Species.Add(efItem); if (context.SaveChanges() > 0) { result = true; } } } catch (Exception e) { throw e; } return(result); }
public string DeleteSpecies(FishSpecies item) { string msg = string.Empty; item.SpeciesActive = false; try { if (ModelState.IsValid) { _fishSvc.InactivateSpecies(item); msg = "Species inactivated succesfully"; } else { msg = "Data validation not successfull"; } } catch (Exception e) { msg = "Delete Species. An error has ocurred"; } return(msg); }
public string CreateSpecies([Bind(Exclude = "SpeciesID")] FishSpecies item) { string msg = string.Empty; try { if (ModelState.IsValid) { _fishSvc.CreateSpecies(item); msg = "Species created succesfully"; } else { msg = "Data validation not successfull"; } } catch (Exception e) { msg = "Create Species. An error has ocurred"; } return(msg); }
public string EditSpecies(FishSpecies item) { string msg = "Edit Species. An error has ocurred"; try { if (!ModelState.IsValid) { msg = "Data validation not successfull"; return(msg); } if (_fishSvc.UpdateSpecies(item)) { msg = "Species saved succesfully"; } } catch (Exception e) { msg = "Edit Species. An error has ocurred"; } return(msg); }
public bool InactivateSpecies(FishSpecies item) { return(_fishRepo.InactivateSpecies(item)); }
public bool CreateSpecies(FishSpecies item) { return(_fishRepo.CreateSpecies(item)); }
public bool UpdateSpecies(FishSpecies item) { return(_fishRepo.UpdateSpecies(item)); }
public ImageButtonsViewModel(IMyNavigationService navService) : base(navService) { _availableFish = FishSpecies.GetFishList(); }