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