static void Main(string[] args)
{
DAO controller = new DAO();
//controller.InsertCustomer("Billa", "Nikolay Naidenov", "Owner", "Some address", "Kaspichan", "BG", "1000", "Bulgaria", "0881258965", "5863214585");
//controller.FindCustomer("Billa");
//controller.UpdateCustomer("Billa", "Billa2", "Nikolay Naidenov", "Owner", "Some address", "Kaspichan", "BG", "1000", "Bulgaria", "0881258965", "5863214585");
//controller.FindCustomer("Billa2");
//controller.DeleteCustomer("Billa2");
//controller.FindCustomerByYear();
//controller.FindCustomerByYearSql();
string region = "WA";
DateTime minDate = new DateTime(1997, 1, 1);
DateTime maxDate = new DateTime(1997, 12, 31);
//controller.FindSales(region, minDate, maxDate);
string companyName = "Exotic Liquids";
//controller.CalculateIncoms(companyName, minDate, maxDate);
//controller.CheckConcurrent();
Order myOrder = new Order
{
CustomerID = "VINET",
OrderDate = DateTime.Now,
ShipAddress = "Sofia"
};
Tuple<int, int, int> firstProduct = new Tuple<int, int, int>(2, 523, 25);
//Tuple<int, int, int> firstProduct = new Tuple<int, int, int>(19999999, 523, 25); //RollBack
Tuple<int, int, int> secondProduct = new Tuple<int, int, int>(3, 601, 26);
List<Tuple<int, int, int>> itemsList = new List<Tuple<int, int, int>>()
{
firstProduct,
secondProduct
};
//controller.MakeOrder(myOrder, itemsList);
}
//9.Create a method that places a new order in the Northwind database.
//The order should contain several order items. Use transaction to ensure the data consistency.
public void MakeOrder(Order myOrder, List<Tuple<int, int, int>> items)
{
var db = new NORTHWNDEntities();
using (db)
{
using(TransactionScope scope = new TransactionScope())
{
var newOrder = db.Orders.Add(myOrder);
foreach (var item in items)
{
Order_Detail myDetail = new Order_Detail
{
OrderID = newOrder.OrderID,
ProductID = item.Item1,
Quantity = (short)item.Item2,
UnitPrice = (short)item.Item3
};
db.Order_Details.Add(myDetail);
}
try
{
db.SaveChanges();
scope.Complete();
Console.WriteLine("OK");
}
catch (Exception)
{
Console.WriteLine("Rollback!!");
scope.Dispose();
}
}
}
}