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