public void checkIfMeanOfItemsWorks()
{
SqlCommandDemo scd = new SqlCommandDemo();
int meanOfItems = scd.GetmeanOfItems();
int expectedResult = 80;
Assert.AreEqual(meanOfItems, expectedResult);
}
public void checkIfCountRecordsWorks()
{
SqlCommandDemo scd = new SqlCommandDemo();
int numberOfRecords = scd.GetNumberOfRecords();
int expectedResult = 11;
Assert.AreEqual(numberOfRecords, expectedResult);
}
public void TestTotalOrders()
{
SqlCommandDemo scd = new SqlCommandDemo();
int totalOrders = scd.GetTotalOrders();
int expectedResult = 11;
Assert.AreEqual(totalOrders, expectedResult);
}
public void TestMinPrice()
{
SqlCommandDemo scd = new SqlCommandDemo();
int minPrice = scd.GetMinPrice();
int expectedResult = 2;
Assert.AreEqual(minPrice, expectedResult);
}
public void TestNumProducts()
{
SqlCommandDemo scd = new SqlCommandDemo();
int numProducts = scd.GetNumProducts();
int expectedResult = 3;
Assert.AreEqual(numProducts, expectedResult);
}
// call methods that demo SqlCommand capabilities
static void Main()
{
SqlCommandDemo scd = new SqlCommandDemo();
Console.WriteLine();
Console.WriteLine("Categories Before Insert");
Console.WriteLine("------------------------");
// use ExecuteReader method
scd.ReadData();
// use ExecuteNonQuery method for Insert
scd.Insertdata();
Console.WriteLine();
Console.WriteLine("Categories After Insert");
Console.WriteLine("------------------------------");
scd.ReadData();
// use ExecuteNonQuery method for Update
scd.UpdateData();
Console.WriteLine();
Console.WriteLine("Categories After Update");
Console.WriteLine("------------------------------");
scd.ReadData();
// use ExecuteNonQuery method for Delete
scd.DeleteData();
Console.WriteLine();
Console.WriteLine("Categories After Delete");
Console.WriteLine("------------------------------");
scd.ReadData();
// use ExecuteScalar method
int numberOfRecords = scd.GetNumberOfRecords();
Console.WriteLine();
Console.WriteLine("Number of Records: {0}", numberOfRecords);
}
public void checkInsertRecordsWorks()
{
SqlCommandDemo scd = new SqlCommandDemo();
{
SqlConnection conn;
conn =
new SqlConnection(
"Data Source = lugh4.it.nuigalway.ie; Initial Catalog = msdb2782; Persist Security Info = True; UID=msdb2782; Password = msdb2782JO");
try
{
// Open the connection
conn.Open();
// prepare command string
string insertString = @"
insert into Customers
(ID,Name, PhoneNo)
values (123234345,'John', 034535382)";
// 1. Instantiate a new command with a query and connection
SqlCommand cmd = new SqlCommand(insertString, conn);
// 2. Call ExecuteNonQuery to send command
cmd.ExecuteNonQuery();
}
finally
{
// Close the connection
if (conn != null)
{
conn.Close();
Assert.Pass();
}
}
}
}
public void checkReadRecordsWorks()
{
SqlCommandDemo scd = new SqlCommandDemo();
{
SqlDataReader rdr = null;
SqlConnection conn;
conn = new SqlConnection("Data Source = lugh4.it.nuigalway.ie; Initial Catalog = msdb2782; Persist Security Info = True; UID=msdb2782; Password = msdb2782JO");
try
{
// Open the connection
conn.Open();
// 1. Instantiate a new command with a query and connection
SqlCommand cmd = new SqlCommand("select * from Customers", conn);
// 2. Call Execute reader to get query results
rdr = cmd.ExecuteReader();
}
finally
{
// close the reader
if (rdr != null)
{
rdr.Close();
}
// Close the connection
if (conn != null)
{
conn.Close();
Assert.Pass();
}
}
}
}
// call methods that demo SqlCommand capabilities
static void Main()
{
SqlCommandDemo scd = new SqlCommandDemo();
Console.WriteLine();
Console.WriteLine("Customers Before Insert");
Console.WriteLine("------------------------");
Console.ReadKey();
// use ExecuteReader method
scd.ReadData();
//Insert method
scd.Insertdata();
Console.WriteLine();
Console.WriteLine("Customers After Insert");
Console.WriteLine("------------------------------");
Console.ReadKey();
scd.ReadData();
// Update method
scd.UpdateData();
Console.WriteLine();
Console.WriteLine("Customers After Update");
Console.WriteLine("------------------------------");
Console.ReadKey();
scd.ReadData();
//Delete method
scd.DeleteData();
Console.WriteLine();
Console.WriteLine("Customers After Delete");
Console.WriteLine("------------------------------");
Console.ReadKey();
scd.ReadData();
// use Count method
int numberOfRecords = scd.GetNumberOfRecords();
Console.ReadKey();
Console.WriteLine();
Console.WriteLine("Number of Records: {0}", numberOfRecords);
Console.ReadKey();
// use Count method
int meanOfItems = scd.GetmeanOfItems();
Console.ReadKey();
Console.WriteLine();
Console.WriteLine("Mean Of Shopping Basket: {0}c", meanOfItems);
Console.ReadKey();
// use Min method
int minOfItems = scd.GetMinOfItems();
Console.ReadKey();
Console.WriteLine();
Console.WriteLine("Minimum Price Of Shopping Basket: {0}c", minOfItems);
Console.ReadKey();
// use Max method
int maxOfItems = scd.GetMaxOfItems();
Console.ReadKey();
Console.WriteLine();
Console.WriteLine("Maximum Price Of Shopping Basket: {0}c", maxOfItems);
Console.ReadKey();
}
