public bool UpdateParameter(LakeParameter item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Lake_Parameter efItem = context.Lake_Parameter.Where(b => b.ParameterID == item.ParameterID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.ParameterActive = item.ParameterActive; efItem.ParameterFullName = item.ParameterFullName; efItem.ParameterName = item.ParameterName; efItem.ParameterTestMethod = item.ParameterTestMethod; efItem.ParameterUnit = item.ParameterUnit; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool UpdateSpeciesGroup(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.SpeciesGroupName = item.SpeciesGroupName; efItem.SpeciesGroupActive = item.SpeciesGroupActive; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool InactivateProfile(LakeProfile item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Lake_Profile efItem = context.Lake_Profile.Where(b => b.ProfileID == item.ProfileID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.ProfileActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool InactivateSurvey(PhytoSurvey item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Phyto_Survey efItem = context.Phyto_Survey.Where(b => b.SurveyID == item.SurveyID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SurveyActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool CreateSurveyDetail(BirdSurveyDetails item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Bird_SurveyDetail efItem = new Bird_SurveyDetail() { SurveyID = item.SurveyID, SpeciesID = item.SpeciesID, SurveyDetailCount = item.SurveyDetailCount }; context.Bird_SurveyDetail.Add(efItem); if (context.SaveChanges() > 0) { return(true); } } } catch (Exception e) { throw e; } return(result); }
public bool InactivateSpecies(BirdSpecies item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Bird_Species efItem = context.Bird_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 bool InactivateGenerator(FishGenerator item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Fish_Generator efItem = context.Fish_Generator.Where(b => b.GeneratorID == item.GeneratorID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.GeneratorActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool CreateGenerator(FishGenerator item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { byte newid = context.Fish_Generator.OrderByDescending(u => u.GeneratorID).FirstOrDefault().GeneratorID; newid++; Fish_Generator efItem = new Fish_Generator() { GeneratorID = newid, GeneratorActive = true, GeneratorName = item.GeneratorName }; context.Fish_Generator.Add(efItem); if (context.SaveChanges() > 0) { result = true; } } } catch (Exception e) { throw e; } return(result); }
public bool InactivateProfileDetails(LakeProfileDetail item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Lake_ProfileDetail efItem = context.Lake_ProfileDetail.Where(u => u.ProfileID == item.ProfileID && u.DepthFeet == item.DepthFeet && u.ParameterID == item.ParameterID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.ProfileDetailActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool UpdateSpecies(PhytoSpecies item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Phyto_Species efItem = context.Phyto_Species.Where(b => b.SpeciesID == item.SpeciesID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SpeciesName = item.SpeciesName; efItem.SpeciesActive = item.SpeciesActive; efItem.DivisionID = item.DivisionID; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public int CreateSurvey(FishSurvey item) { int newid = 0; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { newid = context.Fish_Survey.OrderByDescending(u => u.SurveyID).FirstOrDefault().SurveyID; newid++; Fish_Survey efItem = new Fish_Survey() { SurveyID = newid, SamplePointAreaID = item.SamplePointAreaID, SourceID = LIMS_SOURCEID, SurveyComments = item.SurveyComments, SurveyYear = item.SurveyYear }; context.Fish_Survey.Add(efItem); if (context.SaveChanges() > 0) { return(newid); } } } catch (Exception e) { throw e; } return(newid); }
public bool CreateProfileDetails(LakeProfileDetail item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { //create 4 rows for each parameter for (byte i = 1; i < 5; i++) { Lake_ProfileDetail efItem = new Lake_ProfileDetail() { DepthFeet = item.DepthFeet, ParameterID = i, ProfileID = item.ProfileID /*ParameterValue = item.ParameterValue, * ProfileDetailNotes = item.ProfileDetailNotes, * ProfileDetailActive = item.ProfileDetailActive */ }; context.Lake_ProfileDetail.Add(efItem); if (context.SaveChanges() > 0) { result = true; } } } } catch (Exception e) { throw e; } return(result); }
public bool UpdateSurveyDetail(FishSurveyDetails item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Fish_SurveyDetail efItem = context.Fish_SurveyDetail.Where(b => b.SurveyID == item.SurveyID && b.SurveyNumber == item.SurveyNumber && b.SurveyDetailID == item.SurveyDetailID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SpeciesSizeMillimeters = item.SpeciesSizeMillimeters; efItem.SpeciesWeightOunces = item.SpeciesWeightPounds; efItem.SpeciesWeightPounds = item.SpeciesWeightPounds; efItem.SpeciesID = item.SpeciesID; efItem.SurveyDetailActive = item.SurveyDetailActive; // These other values are computed by the DB: // SpeciesWeightLbs, SpeciesSizeInches,SpeciesSizeInchGroup if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool InactivateSurveyDetail(FishSurveyDetails item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Fish_SurveyDetail efItem = context.Fish_SurveyDetail.Where(b => b.SurveyID == item.SurveyID && b.SurveyNumber == item.SurveyNumber && b.SurveyDetailID == item.SurveyDetailID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SurveyDetailActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public IEnumerable <FishSurveyDetails> GetSurveyDetails(int locationID, int surveyID) { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efList = from surveyDetails in context.Fish_SurveyDetail join species in context.Fish_Species on surveyDetails.SpeciesID equals species.SpeciesID where surveyDetails.SurveyID == surveyID && surveyDetails.SurveyNumber == locationID select new FishSurveyDetails { SpeciesID = species.SpeciesID, SpeciesName = species.SpeciesName, SpeciesSizeInches = surveyDetails.SpeciesSizeInches, SpeciesSizeInchGroup = surveyDetails.SpeciesSizeInchGroup, SpeciesSizeMillimeters = surveyDetails.SpeciesSizeMillimeters, SpeciesWeightLbs = surveyDetails.SpeciesWeightLbs, SpeciesWeightOunces = surveyDetails.SpeciesWeightOunces, SpeciesWeightPounds = surveyDetails.SpeciesWeightPounds, SurveyNumber = surveyDetails.SurveyNumber, SurveyDetailID = surveyDetails.SurveyDetailID, SurveyID = surveyDetails.SurveyID, SurveyDetailActive = surveyDetails.SurveyDetailActive }; return(efList.ToList()); } }
public bool UpdateSurveyLocation(FishSurveyLocation item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Fish_SurveyLocation efItem = context.Fish_SurveyLocation.Where(b => b.SurveyID == item.SurveyID && b.SurveyNumber == item.SurveyNumber).FirstOrDefault(); if (efItem == null) { return(result); } efItem.GeneratorID = item.GeneratorID; efItem.LocationDetails = item.LocationDetails; efItem.SurveyDate = item.SurveyDate; efItem.SurveyDurationSeconds = item.SurveyDurationSeconds; efItem.SurveyLocationComments = item.SurveyLocationComments; efItem.SurveyLocationActive = item.SurveyLocationActive; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool UpdateSurvey(FishSurvey item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Fish_Survey efItem = context.Fish_Survey.Where(b => b.SurveyID == item.SurveyID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SamplePointAreaID = item.SamplePointAreaID; efItem.SourceID = LIMS_SOURCEID; efItem.SurveyYear = item.SurveyYear; efItem.SurveyComments = item.SurveyComments; efItem.SurveyActive = item.SurveyActive; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool CreateSpecies(BirdSpecies item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { short newid = context.Bird_Species.OrderByDescending(u => u.SpeciesID).FirstOrDefault().SpeciesID; newid++; Bird_Species efItem = new Bird_Species() { SpeciesID = newid, SpeciesActive = true, SpeciesName = item.SpeciesName }; context.Bird_Species.Add(efItem); if (context.SaveChanges() > 0) { result = true; } } } catch (Exception e) { throw e; } 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); }
public int CreateSurvey(BirdSurvey item) { int newid = 0; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { newid = context.Bird_Survey.OrderByDescending(u => u.SurveyID).FirstOrDefault().SurveyID; newid++; Bird_Survey efItem = new Bird_Survey() { SurveyID = newid, ClimateID = item.ClimateID, SamplePointAreaID = item.SamplePointAreaID, SourceID = item.SourceID == 0? LIMS_SOURCEID:item.SourceID, SurveyDate = item.SurveyDate, SurveyorID = item.SurveyorID }; context.Bird_Survey.Add(efItem); if (context.SaveChanges() > 0) { return(newid); } } } catch (Exception e) { throw e; } return(newid); }
public bool UpdateSurvey(BirdSurvey item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Bird_Survey efItem = context.Bird_Survey.Where(b => b.SurveyID == item.SurveyID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.ClimateID = item.ClimateID; efItem.SamplePointAreaID = item.SamplePointAreaID; efItem.SourceID = LIMS_SOURCEID; efItem.SurveyDate = item.SurveyDate; efItem.SurveyorID = item.SurveyorID; efItem.SurveyActive = item.SurveyActive; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception e) { } return(result); }
public bool CreateSurveyor(BirdSurveyor item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { byte newid = context.Bird_Surveyor.OrderByDescending(u => u.SurveyorID).FirstOrDefault().SurveyorID; newid++; Bird_Surveyor efItem = new Bird_Surveyor() { SurveyorID = newid, SurveyorActive = true, SurveyorName = item.SurveyorName }; context.Bird_Surveyor.Add(efItem); if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool UpdateSurveyor(BirdSurveyor item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Bird_Surveyor efItem = context.Bird_Surveyor.Where(b => b.SurveyorID == item.SurveyorID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SurveyorName = item.SurveyorName; efItem.SurveyorActive = item.SurveyorActive; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public FishGenerator GetGeneratorByName(string name) { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efitem = context.Fish_Generator.Where(s => s.GeneratorName.ToUpper().Equals(name.ToUpper())).FirstOrDefault(); return(mapper.Map <Fish_Generator, FishGenerator>(efitem)); } }
public BirdSurveyor GetSurveyorByName(string name) { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efitem = context.Bird_Surveyor.Where(s => s.SurveyorName.ToUpper().Equals(name.ToUpper())).FirstOrDefault(); return(mapper.Map <Bird_Surveyor, BirdSurveyor>(efitem)); } }
public BirdSpecies GetSpeciesByName(string name) { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efitem = context.Bird_Species.Where(s => s.SpeciesName.ToUpper().Equals(name.ToUpper())).FirstOrDefault(); return(mapper.Map <Bird_Species, BirdSpecies>(efitem)); } }
public SamplePointArea GetSamplePointAreaByName(string name) { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efitem = context.Lims_SamplePointArea.Where(s => s.SamplePointAreaName.ToUpper().Equals(name.ToUpper())).Where(s => s.SourceID == LIMS_SOURCEID).FirstOrDefault(); return(Mapper.Map <Lims_SamplePointArea, SamplePointArea>(efitem)); } }
public FishSpeciesGroup GetSpeciesGroupByName(string name) { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efitem = context.Fish_SpeciesGroup.Where(s => s.SpeciesGroupName.ToUpper().Equals(name.ToUpper())).FirstOrDefault(); return(mapper.Map <Fish_SpeciesGroup, FishSpeciesGroup>(efitem)); } }
public IEnumerable <SamplePoint> GetAllSamplePoints() { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efList = context.Lims_SamplePoint.ToList(); return(Mapper.Map <List <Lims_SamplePoint>, List <SamplePoint> >(efList)); } }
public IEnumerable <WeatherClimate> GetAllClimates() { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efList = context.Weather_Climate.ToList(); return(Mapper.Map <List <Weather_Climate>, List <WeatherClimate> >(efList)); } }