private void StartPhase(ApplicationPhases phase, int idTestNumber,string email)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MonitorConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO TESTTRACKING(TESTNUMBER,IDPHASE,START,SESSIONID,EMAIL) VALUES (@TESTNUMBER,@IDPHASE,GETDATE(),@SESSIONID,@EMAIL);", conn))
{
System.Collections.ObjectModel.ReadOnlyCollection<Cookie> cookies = driver.Manage().Cookies.AllCookies;
cmd.Parameters.Add(new SqlParameter("IDPHASE", (int)phase));
cmd.Parameters.Add(new SqlParameter("SESSIONID", cookies[0].Value));
cmd.Parameters.Add(new SqlParameter("TESTNUMBER", idTestNumber));
cmd.Parameters.Add(new SqlParameter("EMAIL", email));
conn.Open();
cmd.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
Log(String.Format("THERE WAS A DATABASE ERROR:{0}", e.Message));
}
}
private int StartTracking(ApplicationPhases phase, string email)
{
int idTestTracking=0;
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MonitorConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("DECLARE @TESTNUMBER BIGINT;SELECT @TESTNUMBER=ISNULL(MAX(TestNumber),0)+1 from TestTracking; INSERT INTO TESTTRACKING(TESTNUMBER,IDPHASE,START,SESSIONID,EMAIL) VALUES (@TESTNUMBER,@IDPHASE,GETDATE(),@SESSIONID,@EMAIL);SELECT @TESTNUMBER;", conn))
{
System.Collections.ObjectModel.ReadOnlyCollection<Cookie> cookies = driver.Manage().Cookies.AllCookies;
cmd.Parameters.Add(new SqlParameter("IDPHASE", (int)phase));
cmd.Parameters.Add(new SqlParameter("SESSIONID", cookies[0].Value));
cmd.Parameters.Add(new SqlParameter("EMAIL", email));
conn.Open();
idTestTracking = Convert.ToInt32(cmd.ExecuteScalar());
}
}
}
catch(Exception e)
{
Log(String.Format("THERE WAS A DATABASE ERROR:{0}",e.Message));
}
return idTestTracking;
}
private void EndTracking(ApplicationPhases phase, int idTestNumber,string LoanNumber)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MonitorConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("UPDATE TESTTRACKING SET FINISH=GETDATE() WHERE TESTNUMBER=@TESTNUMBER AND IDPHASE=@IDPHASE;UPDATE TESTTRACKING SET LoanNumber=@LoanNumber WHERE TESTNUMBER=@TESTNUMBER", conn))
{
System.Collections.ObjectModel.ReadOnlyCollection<Cookie> cookies = driver.Manage().Cookies.AllCookies;
cmd.Parameters.Add(new SqlParameter("TESTNUMBER", idTestNumber));
cmd.Parameters.Add(new SqlParameter("IDPHASE", (int)phase));
cmd.Parameters.Add(new SqlParameter("LoanNumber", LoanNumber));
conn.Open();
cmd.ExecuteNonQuery();
}
};
}
catch (Exception e)
{
Log(String.Format("THERE WAS A DATABASE ERROR:{0}", e.Message));
}
}
