static void Delete(string customerID)
{
var db = new northwindEntities();
using (db)
{
var customerToDelete = db.Customers.Find(customerID);
db.Customers.Remove(customerToDelete);
db.SaveChanges();
}
}
static void Delete(string customerID)
{
var db = new northwindEntities();
using (db)
{
var customerToDelete = db.Customers.Find(customerID);
db.Customers.Remove(customerToDelete);
db.SaveChanges();
}
}
static void Edit(string customerID, string companyName, string city, string country)
{
var db = new northwindEntities();
using (db)
{
var customerToEdt = db.Customers.Find(customerID);
customerToEdt.CompanyName = companyName;
customerToEdt.City = city;
customerToEdt.Country = country;
db.SaveChanges();
}
}
static void Edit(string customerID, string companyName, string city, string country)
{
var db = new northwindEntities();
using (db)
{
var customerToEdt = db.Customers.Find(customerID);
customerToEdt.CompanyName = companyName;
customerToEdt.City = city;
customerToEdt.Country = country;
db.SaveChanges();
}
}
static void FindCustomersOrdersByYearAndCountry(int year, string country)
{
var db = new northwindEntities();
using (db)
{
var findedOrders = db.Orders
.Where(x => x.OrderDate.Value.Year == year)
.Where(x => x.ShipCountry == country);
foreach (var order in findedOrders)
{
Console.WriteLine("Customer Name " + order.Customer.ContactName + "Customer ID " + order.Customer.CustomerID);
}
}
}
static void FindCustomersOrdersByYearAndCountry(int year, string country)
{
var db = new northwindEntities();
using (db)
{
var findedOrders = db.Orders
.Where(x => x.OrderDate.Value.Year == year)
.Where(x => x.ShipCountry == country);
foreach (var order in findedOrders)
{
Console.WriteLine("Customer Name " + order.Customer.ContactName + "Customer ID " + order.Customer.CustomerID);
}
}
}
static void Add(string customerID, string companyName, string city, string country)
{
var db = new northwindEntities();
using(db)
{
var customer = new Customer() {
CustomerID = customerID,
CompanyName = companyName,
City = city,
Country = country
};
db.Customers.Add(customer);
db.SaveChanges();
}
}
static void Add(string customerID, string companyName, string city, string country)
{
var db = new northwindEntities();
using (db)
{
var customer = new Customer()
{
CustomerID = customerID,
CompanyName = companyName,
City = city,
Country = country
};
db.Customers.Add(customer);
db.SaveChanges();
}
}
static void NativeSql(int year, string country)
{
var db = new northwindEntities();
using (db)
{
string sqlQuery = @"SELECT c.ContactName from Customers" +
" c INNER JOIN Orders o ON o.CustomerID = c.CustomerID " +
"WHERE (YEAR(o.OrderDate) = {0} AND o.ShipCountry = {1});";
object[] parameters = { year, country };
var sqlQueryResult = db.Database.SqlQuery <string>(sqlQuery, parameters);
foreach (var order in sqlQueryResult)
{
Console.WriteLine(order);
}
}
}
static void FindSalesByDateRange(string region, DateTime startDate, DateTime endDate)
{
var db = new northwindEntities();
using (db)
{
var sales = db.Orders
.Where(x => x.ShipRegion == region &&
x.OrderDate > startDate &&
x.OrderDate < endDate)
.Select(x => new
{
ShipDate = x.ShippedDate,
Region = x.ShipRegion
});
db.SaveChanges();
foreach (var sale in sales)
{
Console.WriteLine("Ship date " + sale.ShipDate + " Ship Region " + sale.Region);
}
}
}
static void FindSalesByDateRange(string region, DateTime startDate, DateTime endDate)
{
var db = new northwindEntities();
using (db)
{
var sales = db.Orders
.Where(x => x.ShipRegion == region
&& x.OrderDate > startDate
&& x.OrderDate < endDate)
.Select(x => new
{
ShipDate = x.ShippedDate,
Region = x.ShipRegion
});
db.SaveChanges();
foreach (var sale in sales)
{
Console.WriteLine("Ship date " + sale.ShipDate + " Ship Region " + sale.Region);
}
}
}
static void NativeSql(int year, string country)
{
var db = new northwindEntities();
using (db)
{
string sqlQuery = @"SELECT c.ContactName from Customers" +
" c INNER JOIN Orders o ON o.CustomerID = c.CustomerID " +
"WHERE (YEAR(o.OrderDate) = {0} AND o.ShipCountry = {1});";
object[] parameters = { year, country };
var sqlQueryResult = db.Database.SqlQuery<string>(sqlQuery, parameters);
foreach (var order in sqlQueryResult)
{
Console.WriteLine(order);
}
}
}
