//internal static void SupplierProc(IDataReader dr, FieldDictionary Fields, object Param)
//{
// SupplierCollection coll = Param as SupplierCollection;
// Supplier item = Mapper.ReadSupplier(dr, Fields);
// coll.Add(item);
//}
public CustomerCollection GetAllCustomers()
{
string str = @"select CustomerID, CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax from Customers" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
CustomerCollection cc = new CustomerCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(CustomerProc), cc);
cc.AcceptChanges();
return(cc);
}
public OrderDetailCollection GetAllOrderDetails()
{
string str = @"select OrderID, ProductID, UnitPrice, Quantity, Discount
from [Order Details]" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
OrderDetailCollection cc = new OrderDetailCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(OrderDetailProc), cc);
cc.AcceptChanges();
return(cc);
}
public OrderCollection GetAllOrders()
{
string str = @"select OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate,
ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry
from Orders" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
OrderCollection cc = new OrderCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(OrderProc), cc);
cc.AcceptChanges();
return(cc);
}
public ProductCollection GetAllProducts()
{
string str = @"select ProductID, ProductName, SupplierID, CategoryID,
QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder,
ReorderLevel, Discontinued
from Products" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
ProductCollection cc = new ProductCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(ProductProc), cc);
cc.AcceptChanges();
return(cc);
}
public CustomerCollection GetCustomerByCustomerId(string CustomerId)
{
string str = @"select CustomerID, CompanyName, ContactName, ContactTitle, Address, City,
Region, PostalCode, Country, Phone, Fax from Customers where CustomerID = @CustomerId" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
cmd.Parameters.Add("@CustomerId", SqlDbType.NChar, 0, "CustomerId");
cmd.Parameters[0].Value = CustomerId;
CustomerCollection cc = new CustomerCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(CustomerProc), cc);
cc.AcceptChanges();
return(cc);
}
public OrderDetailCollection GetOrderDetailsByOrderId(int OrderId)
{
string str = @"select OrderID, ProductID, UnitPrice, Quantity, Discount
from [Order Details] where OrderId = @OrderId" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
cmd.Parameters.Add("@OrderId", SqlDbType.Int, 0, "OrderId");
cmd.Parameters[0].Value = OrderId;
OrderDetailCollection cc = new OrderDetailCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(OrderDetailProc), cc);
cc.AcceptChanges();
return(cc);
}
public ProductCollection GetProductByProductId(int ProductId)
{
string str = @"select ProductID, ProductName, SupplierID, CategoryID,
QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder,
ReorderLevel, Discontinued
from Products where ProductId=@ProductId" ;
SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn));
cmd.Parameters.Add("@ProductId", SqlDbType.Int, 0, "ProductId");
cmd.Parameters[0].Value = ProductId;
ProductCollection cc = new ProductCollection();
DataRead.RunQuery(cmd, new DataRead.ProcessRow(ProductProc), cc);
cc.AcceptChanges();
return(cc);
}