public ServiceParishObject StandardSearch(ParishSearchFilter parishSearchFilter,DataShaping shaper, IValidator validator = null)
{
if (validator != null)
_validator = validator;
var serviceParishObject = new ServiceParishObject();
string retVal = "";
try
{
serviceParishObject.serviceParishs = _parishsDal.GetParishByFilter(parishSearchFilter, shaper);
serviceParishObject.Batch = shaper.RecordStart;
serviceParishObject.BatchLength = shaper.RecordPageSize;
serviceParishObject.Total = shaper.TotalRecords;
serviceParishObject.serviceParishs = serviceParishObject.serviceParishs;
}
catch (Exception ex1)
{
retVal = "Exception: " + ex1.Message;
}
finally
{
if (retVal != "") retVal += Environment.NewLine;
serviceParishObject.ErrorStatus = retVal;
}
return serviceParishObject;
}
public List<string> GetParishNames(ParishSearchFilter parishSearchFilter, IValidator validator = null)
{
if (parishSearchFilter.ParishIds.IsNullOrBelowMinSize()) return new List<string>();
return _parishsDal.GetParishNames(parishSearchFilter.ParishIds);
}
public List<ServiceParish> GetParishByFilter(ParishSearchFilter parishSearchFilter, DataShaping dataShaping)
{
using (var context = new GeneralModelContainer())
{
IQueryable<Parish> parishDataTable;
if (parishSearchFilter.Name == "%" && parishSearchFilter.Deposited == "%" &&
parishSearchFilter.County == "%")
{
parishDataTable = context.Parishs;
}
else
{
parishSearchFilter.Name = parishSearchFilter.Name.Replace('%', ' ').Trim();
parishSearchFilter.Deposited = parishSearchFilter.Deposited.Replace('%', ' ').Trim();
parishSearchFilter.County = parishSearchFilter.County.Replace('%', ' ').Trim();
parishDataTable =
context.Parishs.Where(o => o.ParishName.Contains(parishSearchFilter.Name) &&
o.ParishRegistersDeposited.Contains(
parishSearchFilter.Deposited) &&
o.ParishCounty.Contains(parishSearchFilter.County));
}
dataShaping.TotalRecords = parishDataTable.Count();
return
parishDataTable.OrderBy(o => o.ParishName)
.Skip(dataShaping.RecordStart*dataShaping.RecordPageSize)
.Take(dataShaping.RecordPageSize)
.Select(p => new ServiceParish
{
ParishCounty = p.ParishCounty,
ParishDeposited = p.ParishRegistersDeposited,
ParishId = p.ParishId,
ParishEndYear = p.ParishEndYear,
ParishStartYear = p.ParishStartYear,
ParishName = p.ParishName,
ParishParent = p.ParentParish,
ParishNote = p.ParishNotes
}).ToList();
}
//serviceParishObject.serviceParishs.Skip(shaper.RecordStart * shaper.RecordPageSize).Take(shaper.RecordPageSize).ToList();
}
public IHttpActionResult GetParishs(string deposited, string name, string county, string pno, string psize, string sortcol)
{
//string pno, string psize, string sortcol = ""
string retVal = "";
var psf = new ParishSearchFilter
{
County = county ?? "",
Deposited = deposited?? "",
Name = name??""
};
var result = new ServiceParishObject();
try
{
result = _parishSearch.StandardSearch(psf, new DataShaping() { RecordPageSize = psize.ToInt32(), RecordStart = pno.ToInt32(), Column = sortcol });
}
catch (Exception ex1)
{
retVal = ex1.Message;
}
if (retVal != "")
{
return Content(HttpStatusCode.BadRequest, retVal);
}
return Ok(result);
}
public IHttpActionResult GetParishNames(string parishIds)
{
var parishs = new List<string>();
string retVal = "";
try
{
var psf = new ParishSearchFilter()
{
ParishIds = parishIds.ParseToGuidList()
};
parishs = _parishSearch.GetParishNames(psf);
}
catch (Exception ex1)
{
retVal = ex1.Message;
}
if (retVal != "")
{
return Content(HttpStatusCode.BadRequest, retVal);
}
return Ok(parishs);
}
// parishs
public ServiceParishObject GetParishs(string deposited, string name, string county, string page_number, string page_size, string sort_col)
{
var psf =new ParishSearchFilter
{
County = county,
Deposited = deposited,
Name = name
};
return _parishSearch.StandardSearch(psf, new DataShaping() { RecordPageSize = page_size.ToInt32(), RecordStart = page_number.ToInt32() });
}
