public bool InactivateSamplePointArea(SamplePointArea item)
{
bool result = false;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
Lims_SamplePointArea efItem = context.Lims_SamplePointArea.Where(b => b.SamplePointAreaID == item.SamplePointAreaID).FirstOrDefault();
if (efItem == null)
{
return(result);
}
efItem.SamplePointAreaActive = false;
if (context.SaveChanges() > 0)
{
result = true;
}
}
}
catch (Exception) { }
return(result);
}
public bool CreateSamplePointArea(SamplePointArea item)
{
bool result = false;
try
{
using (RCID_DWHEntities context = new RCID_DWHEntities())
{
short newid = context.Lims_SamplePointArea.OrderByDescending(u => u.SamplePointAreaID).FirstOrDefault().SamplePointAreaID;
newid++;
Lims_SamplePointArea efItem = new Lims_SamplePointArea()
{
SamplePointAreaID = newid,
SamplePointAreaActive = true,
SamplePointAreaName = item.SamplePointAreaName,
SourceID = item.SourceID
};
context.Lims_SamplePointArea.Add(efItem);
if (context.SaveChanges() > 0)
{
result = true;
}
}
}
catch (Exception e) { throw e; }
return(result);
}
