private int GetContSuppStartVersionNumber() { int contSuppStartVersionNumber = 1; try { using (GoldmineEntities context = new GoldmineEntities()) { contSuppStartVersionNumber = int.Parse((from c in context.CONTSUPPChangeTracking(1) select c.SYS_CHANGE_VERSION).ToList().OrderByDescending(c => c.Value).First().Value.ToString()); } } catch (Exception) { return(contSuppStartVersionNumber); } return(contSuppStartVersionNumber); }
public List <CONTSUPPChangeTracking_Result> GetContSuppChangeTrackingResults(int _contsuppStartVersionNumber) { List <CONTSUPPChangeTracking_Result> results = new List <CONTSUPPChangeTracking_Result>(); try { using (GoldmineEntities context = new GoldmineEntities()) { results = (from c in context.CONTSUPPChangeTracking(_contsuppStartVersionNumber) select c).ToList(); } if (results.Count > 0) { _versionNumberProcess.UpdateContsuppVersionNumber(int.Parse(results.OrderByDescending(x => x.SYS_CHANGE_VERSION).FirstOrDefault().SYS_CHANGE_VERSION.Value.ToString())); } } catch (Exception ex) { _exceptionLogging.LogException(ex); } return(results); }