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