public ServiceSourceTypeObject Search(SourceTypeSearchFilter sourceTypeSearchFilter,DataShaping shaper, SourceTypeSearchValidator validator =null) { if (!_security.IsvalidSelect()) return new ServiceSourceTypeObject(); if (validator != null && !validator.ValidEntry()) return new ServiceSourceTypeObject(); return _sourceTypesDal.GetSourceTypeByFilter(sourceTypeSearchFilter).ToServiceSourceTypeObject(shaper.Column, shaper.RecordPageSize, shaper.RecordStart); }
public List<ServiceSourceType> GetSourceTypeByFilter(SourceTypeSearchFilter sourceTypeSearchFilter) { using (var context = new GeneralModelContainer()) { List<ServiceSourceType> sourceTypesDataTable; if (sourceTypeSearchFilter.Description.Trim() == "%") { sourceTypesDataTable = context.SourceTypes.OrderBy(s => s.SourceTypeOrder).Select(p => new ServiceSourceType { Description = p.SourceTypeDesc, TypeId = p.SourceTypeId, Order = p.SourceTypeOrder, UserId = 0 //p.SourceUserAdded.GetValueOrDefault() }).ToList(); } else { if (sourceTypeSearchFilter.SourceTypeIds.Count > 0) { sourceTypesDataTable = context.SourceTypes.Where( s => sourceTypeSearchFilter.SourceTypeIds.Contains(s.SourceTypeId)) .OrderBy(s => s.SourceTypeOrder) .Select(p => new ServiceSourceType { Description = p.SourceTypeDesc, TypeId = p.SourceTypeId, Order = p.SourceTypeOrder, UserId = 0 //p.SourceUserAdded }).ToList(); } else { sourceTypesDataTable = context.SourceTypes.Where( o => o.SourceTypeDesc.Contains(sourceTypeSearchFilter.Description)) .OrderBy(s => s.SourceTypeOrder) .Select(p => new ServiceSourceType { Description = p.SourceTypeDesc, TypeId = p.SourceTypeId, Order = p.SourceTypeOrder, UserId = 0 //p.SourceUserAdded }).ToList(); } } return sourceTypesDataTable; } }
public void DeleteRecords(SourceTypeSearchFilter sourceTypeSearchFilter) { if (!_security.IsValidDelete()) return; _sourceTypesDal.DeleteSourceTypes(sourceTypeSearchFilter.SourceTypeIds); }
public SourceTypeSearchValidator(SourceTypeSearchFilter sourceTypeSearchFilter) { _sourceTypeSearchFilter = sourceTypeSearchFilter; }
public ServiceSourceTypeObject GetSourceTypes(string description, string page_number, string page_size, string sort_col) { string retVal = ""; var serviceSourceTypeObject = new ServiceSourceTypeObject(); var sourceTypeSearchFilter = new SourceTypeSearchFilter() { Description = description == "" ? "%" : description }; var validator = new SourceTypeSearchValidator(sourceTypeSearchFilter); try { serviceSourceTypeObject = _sourceTypeSearch.Search(sourceTypeSearchFilter, new DataShaping() { RecordPageSize = page_size.ToInt32(), RecordStart = page_number.ToInt32() }, validator); } catch (Exception ex1) { retVal = "Exception: " + ex1.Message; } finally { if (retVal != "") retVal += Environment.NewLine; retVal += validator.GetErrors(); } return serviceSourceTypeObject; }
public List<string> GetSourceTypeNames(string typeIds) { var sourceTypeSearchFilter = new SourceTypeSearchFilter() { SourceTypeIds = typeIds.ParseToIntList() }; return _sourceTypeSearch.Search(sourceTypeSearchFilter, new DataShaping(), new SourceTypeSearchValidator(sourceTypeSearchFilter)).serviceSources.Select(p => p.Description).ToList(); }