public bool InactivateSurvey(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.SurveyActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
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 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); }