public bool InactivateSurveyDetail(PhytoSurveyDetails item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Phyto_SurveyDetail efItem = context.Phyto_SurveyDetail.Where(b => b.SurveyID == item.SurveyID && b.SpeciesID == item.SpeciesID ).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SurveyDetailActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool CreateSurveyDetail(PhytoSurveyDetails item) { try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var efitem = context.Phyto_SurveyDetail.Where(s => s.SurveyID == item.SurveyID && s.SpeciesID == item.SpeciesID).FirstOrDefault(); //item already exists if (efitem != null) { return(false); } Phyto_SurveyDetail efItem = new Phyto_SurveyDetail() { SpeciesID = item.SpeciesID, SurveyCount = item.SurveyCount, SurveyID = item.SurveyID, SurveyDetailActive = item.SurveyDetailActive }; context.Phyto_SurveyDetail.Add(efItem); if (context.SaveChanges() > 0) { return(true); } } } catch (Exception e) { throw e; } return(false); }
public string DeleteSurveyDetail(PhytoSurveyDetails item) { string msg = string.Empty; try { if (ModelState.IsValid) { _PhytoSvc.InactivateSurveyDetail(item); msg = "Survey Detail inactivated succesfully"; } else { msg = "Data validation not successfull"; } } catch (Exception e) { msg = "Delete Survey Detail. An error has ocurred"; } return(msg); }
public bool InactivateSurveyDetail(PhytoSurveyDetails item) { return(_PhytoRepo.InactivateSurveyDetail(item)); }
public bool CreateSurveyDetail(PhytoSurveyDetails item) { return(_PhytoRepo.CreateSurveyDetail(item)); }