public void UpdateTdLoad(TdLoad curLoad) { using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { context.TdLoad.Update(curLoad); context.SaveChanges(); }); } }
public TdLoad AddTdLoad(TdLoad newLoad) { using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { context.TdLoad.Add(newLoad); context.SaveChanges(); }); } return(newLoad); }
public TcRefPeriod GetRefPeriodByCode(string refPeriodCode) { TcRefPeriod rp = null; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { rp = context.TcRefPeriod.Include(r => r.RefPeriodType).FirstOrDefault(r => r.Code == refPeriodCode); }); } return(rp); }
public int GetRefPeriodId(string refPeriodCode) { int id = 0; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { id = context.TcRefPeriod.FirstOrDefault(r => r.Code == refPeriodCode).Id; }); } return(id); }
public TlLoadStatus GetLoadStatusByCode(string loadStatusCode) { TlLoadStatus ls = null; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { ls = context.TlLoadStatus.FirstOrDefault(l => l.Code == loadStatusCode); }); } return(ls); }
public int GetLoadStatusId(string loadStatusCode) { int id = 0; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { id = context.TlLoadStatus.FirstOrDefault(l => l.Code == loadStatusCode).Id; }); } return(id); }
public TlEstimeFileType GetEstimeFileTypeByCode(string estimeFileTypeCode) { TlEstimeFileType eft = null; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { eft = context.TlEstimeFileType.Include(e => e.FileType).FirstOrDefault(e => e.Code == estimeFileTypeCode); }); } return(eft); }
public int GetEstimeFileTypeId(string estimeFileTypeCode) { int id = 0; using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { id = context.TlEstimeFileType.FirstOrDefault(eft => eft.Code == estimeFileTypeCode).Id; }); } return(id); }
public IEnumerable <CodeSet> GetCodeSetList() { IQueryable <CodeSet> codesets = null; var options = new DbContextOptions <EstimeContext>(); List <CodeSet> myList = new List <CodeSet>(); using (var context = new EstimeContext(options, connString)) { //codesets = context.CodeSet.Include(cs => cs.CodeSetType).Include(cs => cs.CodeMember); EFHelper.CallEF(() => { //codesets = context.CodeSet.Include(cs => cs.CodeMember); codesets = context.CodeSet.Include(cs => cs.CodeSetType).Include(cs => cs.CodeMember); }); myList = codesets.ToList(); } return(myList); }
public IEnumerable <TlInputCoordinate> GetInputCoordinateListByEstimeFileType(int estFileTypeId) { IQueryable <TlInputCoordinate> coors = null; List <TlInputCoordinate> myList = new List <TlInputCoordinate>(); using (var context = new EstimeContext(options, connString)) { EFHelper.CallEF(() => { coors = (from ic in context.TlInputCoordinate.Include(ic => ic.InputVariable).ThenInclude(iv => iv.Variable) join iv in context.TlInputVariable on ic.InputVariableId equals iv.Id where iv.EstimeFileTypeId == estFileTypeId select ic); }); myList = coors.ToList(); } return(myList); }