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