public bool InactivateSpeciesGroup(FishSpeciesGroup item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Fish_SpeciesGroup efItem = context.Fish_SpeciesGroup.Where(b => b.SpeciesGroupID == item.SpeciesGroupID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SpeciesGroupActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool CreateSpeciesGroup(FishSpeciesGroup item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { byte newid = context.Fish_SpeciesGroup.OrderByDescending(u => u.SpeciesGroupID).FirstOrDefault().SpeciesGroupID; newid++; Fish_SpeciesGroup efItem = new Fish_SpeciesGroup() { SpeciesGroupID = newid, SpeciesGroupActive = true, SpeciesGroupName = item.SpeciesGroupName }; context.Fish_SpeciesGroup.Add(efItem); if (context.SaveChanges() > 0) { result = true; } } } catch (Exception e) { throw e; } return(result); }