public bool InactivateSamplePoint(SamplePoint item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { Lims_SamplePoint efItem = context.Lims_SamplePoint.Where(b => b.SamplePointID == item.SamplePointID).FirstOrDefault(); if (efItem == null) { return(result); } efItem.SamplePointActive = false; if (context.SaveChanges() > 0) { result = true; } } } catch (Exception) { } return(result); }
public bool CreateSamplePoint(SamplePoint item) { bool result = false; try { using (RCID_DWHEntities context = new RCID_DWHEntities()) { int newid = context.Lims_SamplePoint.OrderByDescending(u => u.SamplePointID).FirstOrDefault().SamplePointID; newid++; Lims_SamplePoint efItem = new Lims_SamplePoint() { SamplePointID = newid, SamplePointActive = true, SamplePointName = item.SamplePointName, SourceID = item.SourceID }; context.Lims_SamplePoint.Add(efItem); if (context.SaveChanges() > 0) { result = true; } } } catch (Exception e) { throw e; } return(result); }