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();
}
