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();
}
