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 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 short CreateSurveyDetail(FishSurveyDetails item) { short newid = 0; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { var lastItem = context.Fish_SurveyDetail.Where(s => s.SurveyID == item.SurveyID && s.SurveyNumber == item.SurveyNumber) .OrderByDescending(u => u.SurveyDetailID).FirstOrDefault(); if (lastItem != null) { newid = lastItem.SurveyDetailID; newid++; } Fish_SurveyDetail efItem = new Fish_SurveyDetail() { SurveyDetailID = newid, SurveyID = item.SurveyID, SurveyNumber = item.SurveyNumber, SpeciesSizeMillimeters = item.SpeciesSizeMillimeters, SpeciesWeightOunces = item.SpeciesWeightOunces, SpeciesWeightPounds = item.SpeciesWeightPounds, SpeciesID = item.SpeciesID, SurveyDetailActive = item.SurveyDetailActive }; // These other values are computed by the DB: // SpeciesWeightLbs, SpeciesSizeInches,SpeciesSizeInchGroup context.Fish_SurveyDetail.Add(efItem); if (context.SaveChanges() > 0) { return(newid); } } } catch (Exception e) { throw e; } return(newid); }
public string DeleteSurveyDetail(FishSurveyDetails item) { string msg = string.Empty; try { if (ModelState.IsValid) { _fishSvc.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(FishSurveyDetails item) { return(_fishRepo.InactivateSurveyDetail(item)); }
public bool CreateSurveyDetail(FishSurveyDetails item) { return(_fishRepo.CreateSurveyDetail(item) > 0); }
public bool UpdateSurveyDetail(FishSurveyDetails item) { return(_fishRepo.UpdateSurveyDetail(item)); }