public bool UpdateSurvey(PhytoSurvey item)
{
bool result = false;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
Phyto_Survey efItem = context.Phyto_Survey.Where(b => b.SurveyID == item.SurveyID).FirstOrDefault();
if (efItem == null)
{
return(result);
}
efItem.SamplePointAreaID = item.SamplePointAreaID;
efItem.SourceID = LIMS_SOURCEID;
efItem.SurveyDate = item.SurveyDate;
efItem.LocationDetails = item.LocationDetails;
efItem.SurveyActive = item.SurveyActive;
if (context.SaveChanges() > 0)
{
result = true;
}
}
}
catch (Exception) { }
return(result);
}
public int CreateSurvey(PhytoSurvey item)
{
int newid = 0;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
newid = context.Phyto_Survey.OrderByDescending(u => u.SurveyID).FirstOrDefault().SurveyID;
newid++;
Phyto_Survey efItem = new Phyto_Survey()
{
SurveyID = newid,
SamplePointAreaID = item.SamplePointAreaID,
SourceID = LIMS_SOURCEID,
LocationDetails = item.LocationDetails,
SurveyDate = item.SurveyDate,
SurveyActive = item.SurveyActive
};
context.Phyto_Survey.Add(efItem);
if (context.SaveChanges() > 0)
{
return(newid);
}
}
}
catch (Exception e) { throw e; }
return(newid);
}
public bool InactivateSurvey(PhytoSurvey item)
{
bool result = false;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
Phyto_Survey efItem = context.Phyto_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);
}