private static IQueryable <Search> GetIntervalSysid(string text)
{
var first = HelpersFunction.GetIntFromStringByDefis(text)[0];
var second = HelpersFunction.GetIntFromStringByDefis(text)[1];
return(Context.Search.Where(s => s.sysid >= first & s.sysid <= second));
}
public void GetStringsBySpace()
{
string text = "ИВАНОВ ИВАН";
string[] arrText = new[] { "ИВАНОВ", "ИВАН" };
var result = HelpersFunction.GetStringsBySpace(text);
Assert.AreEqual(arrText[0], result[0]);
Assert.AreEqual(arrText[1], result[1]);
}
public void GetIntFromStringByComma()
{
string text = "100,101,102,110";
int[] arrText = new[] { 100, 101, 102, 110 };
var result = HelpersFunction.GetIntFromStringByComma(text);
Assert.AreEqual(arrText[0], result[0]);
Assert.AreEqual(arrText[3], result[3]);
}
public void TestGetIntFromStringByDefis()
{
string text = "100-1000";
int[] arrText = new[] { 100, 1000 };
var result = HelpersFunction.GetIntFromStringByDefis(text);
Assert.AreEqual(arrText[0], result[0]);
Assert.AreEqual(arrText[1], result[1]);
}
private static IEnumerable <Search> GetByNames(string text, FindModel param)
{
var name0 = HelpersFunction.GetStringsBySpace(text)[0];
var name1 = HelpersFunction.GetStringsBySpace(text)[1];
IQueryable <Search> result;
if (param.MatchEndings)
{
result = Context.Search.Where(x => (x.firstname.Contains(name0) & x.lastname.Contains(name1))
| (x.firstname.Contains(name1) & x.lastname.Contains(name0)));
}
else
{
result = Context.Search.
Where(x => (x.firstname == name0 & x.lastname == name1) | (x.firstname == name1 & x.lastname == name0));
}
return(result);
}
private static IQueryable <Search> GetListSysid(string text)
{
var sysids = HelpersFunction.GetIntFromStringByComma(text);
return(Context.Search.Where(s => sysids.Contains(s.sysid)));
}
