public static void CheckResultRecordExists(String sTestName, String sStatus)
{
try
{
using (SQLCompactDBEntities entity = new SQLCompactDBEntities())
{
string runName = conf.get("RunName");
var recordCount = entity.Test_Results.Count(a => a.Test_Name.Equals(sTestName) && a.Run_Name.Equals(runName) && a.Execution_Date.Equals(DateTime.Today) && a.Test_Result.Equals(sStatus));
if (recordCount != 0)
{
entity.Test_Results.SqlQuery("delete from Test_Results where TEST_NAME like '" + sTestName + "' and EXECUTION_DATE like " + DateTime.Today + " and TEST_RESULT like '" + sStatus + "' and RUN_Name like '" + conf.get("RunName") + "'");
DbSqlQuery<Test_Results> db = entity.Test_Results.SqlQuery("delete from Test_Results where TEST_NAME like '" + sTestName + "' and TEST_RESULT like '" + sStatus + "' and RUN_Name like '" + conf.get("RunName") + "'");
foreach (Test_Results check in db)
{
}
IEnumerator<Test_Results> enu = db.GetEnumerator();
var c = enu.Current;
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static void UpdateResult(String query)
{
try
{
using (SQLCompactDBEntities entity = new SQLCompactDBEntities())
{
DbSqlQuery<Test_Results> db = entity.Test_Results.SqlQuery(query);
foreach (Test_Results check in db)
{
}
IEnumerator<Test_Results> enu = db.GetEnumerator();
var c = enu.Current;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static void UpdateRecord(String query)
{
try
{
using (SQLCompactDBEntities entity = new SQLCompactDBEntities())
{
DbSqlQuery<Siebel_TestData> db = entity.Siebel_TestData.SqlQuery(query);
foreach (Siebel_TestData check in db)
{
}
IEnumerator<Siebel_TestData> enu = db.GetEnumerator();
var c = enu.Current;
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
