public double Insert(Department department, Stopwatch stopwatch)
{
double execTime;
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = sqlConnection;
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO [dbo].[Department] (Id, Name, DateAdded) VALUES (@id, @name, @dateAdd)";
command.Parameters.AddWithValue("@id", department.Id);
command.Parameters.AddWithValue("@name", department.Name);
command.Parameters.AddWithValue("@dateAdd", department.DateAdded);
stopwatch.Restart();
command.ExecuteNonQuery();
stopwatch.Stop();
execTime = ((double)stopwatch.ElapsedTicks / (double)System.Diagnostics.Stopwatch.Frequency) * 1000;
}
sqlConnection.Close();
}
return execTime;
}
public double SelectDepartmentByName(string name, Stopwatch stopwatch)
{
double execTime;
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
sqlConnection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = sqlConnection;
command.CommandType = CommandType.Text;
command.CommandText = "SELECT Id, Name, DateAdded FROM [dbo].[Department] WHERE Name LIKE @name";
command.Parameters.AddWithValue("@name", name);
stopwatch.Restart();
using (SqlDataReader rdr = command.ExecuteReader())
{
if (rdr.HasRows)
{
while (rdr.Read())
{
Department department = new Department
{
Id = rdr.GetInt32(0),
Name = rdr.GetString(1),
DateAdded = rdr.GetDateTime(2),
};
}
}
stopwatch.Stop();
execTime = ((double)stopwatch.ElapsedTicks / (double)System.Diagnostics.Stopwatch.Frequency) * 1000;
rdr.Close();
}
}
sqlConnection.Close();
}
return execTime;
}
