public IList <ScopeChangeType> GetScopeChangeTypeList(ScopeChangeType scope) { IList <ScopeChangeType> fetchedScopeChangeType = new List <ScopeChangeType>(); try { //using (var Context = new Cubicle_EntityEntities()) //{ // IQueryable<ScopeChangeType> query = Context.ScopeChangeTypes; // if (scope.ScopeChangeType1 != string.Empty) // query = query.Where(p => p.ScopeChangeType1.ToUpper().Contains(scope.ScopeChangeType1.ToUpper())); // if (scope.ScopeChangeTypeCode != string.Empty) // query = query.Where(p => p.ScopeChangeTypeCode.ToUpper().Contains(scope.ScopeChangeTypeCode.ToUpper())); // fetchedScopeChangeType = query.ToList(); //} } catch (Exception ex) { //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); if (false) { throw ex; } } return(fetchedScopeChangeType); }
public Boolean CheckDuplicate(ScopeChangeType scope, Boolean IsInsert) { Boolean Result = true; try { var c = _scopeRepository.GetSingle(p => p.ScopeChangeTypeCode.ToUpper() == scope.ScopeChangeTypeCode.ToUpper() && p.ScopeChangeType1.ToUpper() == scope.ScopeChangeType1.ToUpper()); if (!IsInsert) { if (c == null) { Result = true; } else if (c.ScopeChangeTypeID == scope.ScopeChangeTypeID) { Result = true; } else { Result = false; } } else { if (c == null) { Result = true; } else { Result = false; } } } catch (Exception ex) { //bool false = BusinessLogicExceptionHandler.HandleException(ref ex); if (false) { throw ex; } } return(Result); }