public static Authenticates GetData(CriteriaInfo criteriaInfo)
{
Authenticates obj = new Authenticates();
obj.DataFetch(new Criteria(criteriaInfo));
return(obj);
}
public static int UpdateData(CriteriaInfo criteriaInfo, bool isNew)
{
var criteria = new Criteria(criteriaInfo);
using (SqlConnection con = new SqlConnection(DatabaseManager.GetConnectionString("WWConString")))
{
con.Open();
TestTemplate newItem = new TestTemplate();
newItem.IdTest = criteria.CriteriaInfo.IdTest;
newItem.TestName = criteria.CriteriaInfo.TestName;
if (isNew)
{
newItem.Insert(con);
return(newItem.IdTest);
}
else
{
newItem.IdTest = criteria.CriteriaInfo.IdTest;
newItem.Update(con);
return(0);
}
}
}
public static TestTemplates GetData(CriteriaInfo criteriaInfo)
{
TestTemplates obj = new TestTemplates();
obj.DataFetch(new Criteria(criteriaInfo));
return(obj);
}
/// <summary>
/// Parses the given phrase into CriteriaInfo struct(s). Will recurse for
/// chained FlipFlop criteria.
/// </summary>
/// <param name="phrase">Phrase to parse</param>
/// <returns>List of generated CriteriaInfo structs</returns>
private List <CriteriaInfo> ParsePhrase(string phrase)
{
List <CriteriaInfo> resultCriteria = new List <CriteriaInfo>();
CriteriaInfo resultCriterion;
string parsePhrase = phrase.Trim();
if (parsePhrase.Contains(FLIPFLOP_CHAR))
{
// Parse chained FlipFlop criteria
string[] flipFlops = phrase.Split(FLIPFLOP_CHAR);
foreach (string s in flipFlops)
{
resultCriteria.AddRange(ParsePhrase(s));
}
// FlipFlop may include an Exclude in it, such criteria will
// have both attributes set.
string tmpKeyphrase;
CriteriaType tmpType;
for (int i = 0; i < resultCriteria.Count; ++i)
{
tmpKeyphrase = resultCriteria[i].keyphrase;
tmpType = resultCriteria[i].type;
if (tmpType == CriteriaType.EXCLUDE)
{
tmpType |= CriteriaType.FLIPFLOP;
}
else
{
tmpType = CriteriaType.FLIPFLOP;
}
resultCriteria[i] = new CriteriaInfo {
keyphrase = tmpKeyphrase,
type = tmpType
};
}
return(resultCriteria);
}
if (parsePhrase.StartsWith(EXCLUDE_CHAR))
{
resultCriterion.type = CriteriaType.EXCLUDE;
resultCriterion.keyphrase = parsePhrase.TrimStart(EXCLUDE_CHAR);
}
else
{
resultCriterion.type = CriteriaType.SINGLE;
resultCriterion.keyphrase = parsePhrase;
}
resultCriteria.Add(resultCriterion);
return(resultCriteria);
}
public static void DeleteData(CriteriaInfo criteriaInfo)
{
TestTemplates obj = new TestTemplates();
var criteria = new Criteria(criteriaInfo);
using (SqlConnection con = new SqlConnection(DatabaseManager.GetConnectionString("")))
{
con.Open();
TestTemplate itemToDelete = new TestTemplate();
itemToDelete.IdTest = criteria.CriteriaInfo.IdTest;
itemToDelete.Delete(con);
}
}
public Criteria(CriteriaInfo criteriaInfo)
{
CriteriaInfo = criteriaInfo;
}
