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