/// <summary>
/// Получение информации о recstate записи
/// </summary>
/// <param name="recid"></param>
public int CheckRecstateInDb(string recid)
{
RdevDB db = new RdevDB(ConnectionString);
Guid id = Guid.Parse(recid);
int recstate = db.Types.Where(x => x.Recid == id).Select(x => x.Recstate).FirstOrDefault();
return(recstate);
}
/// <summary>
/// получаем первый найденный в БД id тестируемого типа
/// </summary>
/// <param name="type"></param>
public string GetRecidForTestingType(string type)
{
RdevDB db = new RdevDB(ConnectionString);
Guid id = new Guid();
if (type == "sysstring")
{
id = db.Types.Where(x => x.Sysstring != null).Select(x => x.Recid).FirstOrDefault();
}
return(id.ToString());
}
/// <summary>
/// получение текста колонки тестируемого типа
/// </summary>
/// <param name="recid"></param>
/// <returns></returns>
public string GetInfoTypesForTestingType(string recid, string type)
{
RdevDB db = new RdevDB(ConnectionString);
Guid id = Guid.Parse(recid);
string textTypes = "";
if (type == "sysstring")
{
textTypes = db.Types.Where(x => x.Recid == id).Select(x => x.Sysstring).FirstOrDefault().ToString();
return(textTypes);
}
return(textTypes);
}
/// <summary>
/// проверка наличия записи в БД
/// </summary>
/// <param name="recid"></param>
/// <returns></returns>
public bool CheckingRecord(string recid)
{
RdevDB db = new RdevDB(ConnectionString);
Guid id = Guid.Parse(recid);
int records = db.Types.Where(x => x.Recid == id).Count();
if (records > 0)
{
return(true);
}
else
{
return(false);
}
}
public string SearchingInDb(string value)
{
RdevDB db = new RdevDB(ConnectionString);
if (value == "Equal")
{
var count = db.Types.Where(s => s.Sysstring == ("0123456789")).Select(s => s.Sysstring).Count();
return(count.ToString());
}
if (value == "Not Equal")
{
var count = db.Types.Where(s => (s.Sysstring != "0123456789") && (s.Recstate == 1)).Select(s => s.Sysstring).Count();
return(count.ToString());
}
if (value == "Contains")
{
var count = db.Types.Where(s => (s.Sysstring.Contains("456")) && (s.Recstate == 1)).Select(s => s.Sysstring).Count();
return(count.ToString());
}
if (value == "Starts with")
{
var count = db.Types.Where(s => (s.Sysstring.StartsWith("01")) && (s.Recstate == 1)).Select(s => s.Sysstring).Count();
return(count.ToString());
}
if (value == "Ends with")
{
var count = db.Types.Where(s => (s.Sysstring.EndsWith("789")) && (s.Recstate == 1)).Select(s => s.Sysstring).Count();
return(count.ToString());
}
if (value == "Not contains")
{
var count = db.Types.Where(s => !(s.Sysstring.Contains("456")) && (s.Recstate == 1)).Select(s => s.Sysstring).Count();
return(count.ToString());
}
return(ToString());
}
