public static string GetDocLocation(string engNum, double docNum) { using (new TransactionScope( TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted })) { using (var db = new IMDBContext()) { var docLoc = db.Set<DOCMASTER>(). Where(x => x.C2ALIAS.Equals(engNum, StringComparison.OrdinalIgnoreCase) && x.DOCNUM == docNum && x.VERSION == 1 ).Select(y => y.DOCLOC).ToList().FirstOrDefault(); var sp_docLoc = docLoc.Split(':'); var p1 = sp_docLoc[0].Trim(); var srvLoc = db.Set<DOCSERVER>(). Where(x => x.DOCSERVER1.Equals(p1, StringComparison.OrdinalIgnoreCase) ).Select(y => y.LOCATION).ToList().FirstOrDefault(); var result = string.Format("{0}{1}", srvLoc, sp_docLoc[1]); return result; } } }
public IQueryable <T> All() { return(context.Set <T>()); }
public static double? GetPrjIdForEng(string num) { using (new TransactionScope( TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadUncommitted })) { using (var db = new IMDBContext()) { var result = db.Set<PROJECT>().Include("DOCMASTER") .Where(x => x.DOCMASTER.C2ALIAS.Equals(num, StringComparison.OrdinalIgnoreCase) && x.DOCMASTER.C_ALIAS.Equals("WEBDOC", StringComparison.OrdinalIgnoreCase) && x.DOCMASTER.DOCNAME.Equals(string.Empty, StringComparison.OrdinalIgnoreCase) ).FirstOrDefault(); if (result == null) return null; else return result.PRJ_ID; } } }
public IMDBRepository(IMDBContext context) { _context = context; _dbSet = _context.Set <TEntity>(); }