public List <OrderBLL> GetAllOrders()
{
adpOrder.Fill(tblOrders);
listOrders = null;
if (tblOrders.Count > 0)
{
//this list will be used to fill data in the grid view of cart
listOrders = new List <OrderBLL>();
foreach (var row in tblOrders)
{
OrderBLL order = new OrderBLL();
order.OrderId = row.OrderID;
order.ItemId = row.ItemID;
//order.CustomerId = row.CustID;
order.shippedAddr = row.ShippingAddress;
order.Price = row.Price;
order.Shipped = row.Shipped;
listOrders.Add(order);
}
}
return(listOrders);
}
private void Report_Load(object sender, EventArgs e)
{
productsTableAdapter.Fill(NorthwindDataSet.Products);
employeesTableAdapter.Fill(NorthwindDataSet.Employees);
customersTableAdapter.Fill(NorthwindDataSet.Customers);
OrdersTableAdapter.Fill(NorthwindDataSet.Orders);
var q = from em in NorthwindDataSet.Employees
where em.EmployeeID == Convert.ToInt32(id)
select new
{
firstName = em.FirstName,
lastName = em.LastName
};
foreach (var i in q)
{
employee.Add(i.firstName);
employee.Add(i.lastName);
}
ReportParameterCollection reportParameters = new ReportParameterCollection();
reportParameters.Add(new ReportParameter("parameterFirstName", employee[0]));
reportParameters.Add(new ReportParameter("parameterLastName", employee[1]));
reportViewer1.LocalReport.SetParameters(reportParameters);
da.Fill(ds.Tables["Orders"]);
cb_OrderDetails.DataSource = bs;
cb_OrderDetails.DisplayMember = "OrderID";
Order_DetailsTableAdapter.Fill(NorthwindDataSet.Order_Details);
Order_Details_fill_name();
}
private void WindowLoaded(object sender, RoutedEventArgs e)
{
// Fill the Customers table adapter with data.
_customersTableAdapter.ClearBeforeFill = true;
_customersTableAdapter.Fill(_nwDataSet.Customers);
// Fill the Orders table adapter with data.
_ordersTableAdapter.Fill(_nwDataSet.Orders);
// Assign the BindingSource to
// the data context of the main grid.
mainGrid.DataContext = _nwBindingSource;
// Assign the BindingSource to
// the data source of the list box.
listBox1.ItemsSource = _nwBindingSource;
// Because this is a master/details form, the DataGridView
// requires the foreign key relating the tables.
dataGridView1.DataSource = _nwBindingSource;
dataGridView1.DataMember = "FK_Orders_Customers";
// Handle the currency management aspect of the data models.
// Attach an event handler to detect when the current item
// changes via the WPF ListBox. This event handler synchronizes
// the list collection with the BindingSource.
//
var cv = CollectionViewSource.GetDefaultView(
_nwBindingSource) as BindingListCollectionView;
cv.CurrentChanged += WPF_CurrentChanged;
}
public DatabaseOps()
{
InitializeComponent();
custAdap.Fill(aset.Customers);
ordAdap.Fill(aset.Orders);
ord_det_extAdap.Fill(aset.Order_Details_Extended);
Grid1.DataContext = aset.Customers;
}
public StronglyTypedDataSetWindowsFormsDesignerMainForm()
{
InitializeComponent();
// fill the datatables from the database
inventoryTableAdapter.Fill(inventoryTable);
customersTableAdapter.Fill(customersTable);
ordersTableAdapter.Fill(ordersTable);
// initialize the controls
InitializeDataGridView(dataGridViewInventory, inventoryTable);
InitializeDataGridView(dataGridViewCustomers, customersTable);
InitializeDataGridView(dataGridViewOrders, ordersTable);
// set the button event handler
buttonUpdate.Click += ButtonUpdate_Click;
}
void InitializeDataSources()
{
var dataSource = new DataSet1();
var connection = new OleDbConnection();
connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\nwind.mdb";
EmployeesTableAdapter employees = new EmployeesTableAdapter();
employees.Connection = connection;
employees.Fill(dataSource.Employees);
CustomersTableAdapter customers = new CustomersTableAdapter();
customers.Connection = connection;
customers.Fill(dataSource.Customers);
EmployeeCustomersTableAdapter employeeCustomers = new EmployeeCustomersTableAdapter();
employeeCustomers.Connection = connection;
employeeCustomers.Fill(dataSource.EmployeeCustomers);
OrdersTableAdapter orders = new OrdersTableAdapter();
orders.Connection = connection;
orders.Fill(dataSource.Orders);
Order_DetailsTableAdapter orderDetails = new Order_DetailsTableAdapter();
orderDetails.Connection = connection;
orderDetails.Fill(dataSource.Order_Details);
SnapDocument document = snapControl1.Document;
document.BeginUpdateDataSource();
var employeesBinding = new BindingSource()
{
DataSource = dataSource, DataMember = employeeDataSourceName
};
document.DataSources.Add(new DataSourceInfo(employeeDataSourceName, employeesBinding));
var customersBinding = new BindingSource()
{
DataSource = dataSource, DataMember = customerDataSourceName
};
document.DataSources.Add(new DataSourceInfo(customerDataSourceName, customersBinding));
document.EndUpdateDataSource();
}
private void downloadData(string customerID)
{
DataSet1 myData = new DataSet1();
CustomersTableAdapter customersTableAdapter = new CustomersTableAdapter();
OrdersTableAdapter ordersTableAdapter = new OrdersTableAdapter();
customersTableAdapter.Fill(myData.Customers, customerID);
ordersTableAdapter.Fill(myData.Orders, customerID);
dataGridView1.DataSource = myData.Tables["Customers"];
dataGridView2.DataSource = myData.Tables["Orders"];
}
public DatabaseOps()
{
InitializeComponent();
custAdap.Fill(aset.Customers);
ordAdap.Fill(aset.Orders);
ord_det_extAdap.Fill(aset.Order_Details_Extended);
Grid1.DataContext = aset.Customers;
ICollectionView aView;
aView = CollectionViewSource.GetDefaultView(aset.Customers);
aView.GroupDescriptions.Add(new PropertyGroupDescription("Country", new CountryGrouper()));
aView.SortDescriptions.Add(new SortDescription("Country", ListSortDirection.Ascending));
}
protected void PobierzDaneZamowienia(string idKlienta)
{
DataSet mojZbiorDanych = new DataSet();
CustomersTableAdapter klientDA = new CustomersTableAdapter();
OrdersTableAdapter zamowieniaDA = new OrdersTableAdapter();
klientDA.Fill(mojZbiorDanych.Customers, idKlienta);
zamowieniaDA.Fill(mojZbiorDanych.Orders, idKlienta);
GridView1.DataSource = mojZbiorDanych.Tables["Customers"];
GridView1.DataBind();
GridView2.DataSource = mojZbiorDanych.Tables["Orders"];
GridView2.DataBind();
}
public MainForm()
{
InitializeComponent();
// Get Adapters.
invTableAdapter = new InventoryTableAdapter();
custTableAdapter = new CustomersTableAdapter();
ordersTableAdapter = new OrdersTableAdapter();
// Add tables to DS.
invTableAdapter.Fill(autoLotDS.Inventory);
custTableAdapter.Fill(autoLotDS.Customers);
ordersTableAdapter.Fill(autoLotDS.Orders);
// Bind to grids
dataGridViewInventory.DataSource = autoLotDS.Inventory;
dataGridViewCustomers.DataSource = autoLotDS.Customers;
dataGridViewOrders.DataSource = autoLotDS.Orders;
}
//</Snippet5>
//<Snippet6>
private void PopulateSalesOrderInfo()
{
String[] tempArray = comboBox1.Text.Split(new Char[] { '|' });
menu1.Items.Clear();
orderTable = nwDataSet.Orders;
orderDetailsTable = nwDataSet.Order_Details;
productsTable = nwDataSet.Products;
ordersTableAdapter.Fill(orderTable);
detailsTableAdapter.Fill(orderDetailsTable);
productsTableAdapter.Fill(productsTable);
var orderQuery = from orders in orderTable.AsEnumerable()
where orders.Field <string>("Customer ID") == tempArray[1]
select new { OrderID = orders.Field <int>("Order ID") };
foreach (var orderItem in orderQuery)
{
menu1.Items.Add(CreateRibbonMenu());
RibbonMenu orderMenu = (RibbonMenu)menu1.Items.Last();
orderMenu.Dynamic = true;
orderMenu.Label = orderItem.OrderID.ToString();
orderMenu.Tag = orderItem.OrderID;
var productQuery = from orderDetail in orderDetailsTable.AsEnumerable()
join product in productsTable.AsEnumerable() on
orderDetail.Field <int>("Product ID")
equals product.Field <int>("Product ID")
where orderDetail.Field <int>("Order ID") ==
orderItem.OrderID
select new { ProductName = product.Field <string>("Product Name") };
foreach (var productItem in productQuery)
{
RibbonButton button = CreateRibbonButton();
button.Label = productItem.ProductName;
orderMenu.Items.Add(button);
}
}
}
protected void SubmitOrder()
{
if (IsNotNull(txtBoxStreetName.Text) == true &&
IsNotNull(TxtBoxUnit.Text) == true &&
IsNotNull(TxtBoxPostal.Text) == true)
{
string spiceOption = "";
foreach (ListItem o in CheckBoxSpice.Items)
{
if (o.Selected)
{
spiceOption += " " + o.Value.ToString();
}
}
OrdersTableAdapter orderta = new OrdersTableAdapter();
orderta.Fill(ds.Orders);
try
{
DataRow dr = ds.Orders.NewRow();
dr["orderUser"] = userName;
dr["orderDate"] = DateTime.Now;
dr["orderDish"] = DdlFoodChoice.SelectedItem.ToString();
dr["orderSize"] = DddlSizeOption.SelectedItem.ToString();
dr["orderSpices"] = spiceOption;
dr["deliveryLocation"] = txtBoxStreetName.Text + " " + TxtBoxUnit.Text + " Postal Code " + TxtBoxPostal.Text;
dr["orderStatus"] = "Pending";
ds.Tables["Orders"].Rows.Add(dr);
orderta.Update(ds.Orders);
LabelStatus.Text = "Order Submitted Successfully";
ClearForm();
}
catch (Exception ex)
{
LabelStatus.Text = ex.ToString();
}
}
else
{
LabelStatus.Text = "Error! Please enter the information for all fields.";
}
}
/*
* Function get_data()
* Fills database tables using DataSet.
*/
private void get_data()
{
ds = new DataSet1();
mt = new MenuTableAdapter();
it = new InventoryTableAdapter();
et = new EmployeesTableAdapter();
ot = new OrdersTableAdapter();
olt = new OrderlineTableAdapter();
st = new SuppliersTableAdapter();
pot = new PurchaseOrdersTableAdapter();
polt = new PurchaseOrderlineTableAdapter();
mt.Fill(ds.Menu);
it.Fill(ds.Inventory);
et.Fill(ds.Employees);
ot.Fill(ds.Orders);
olt.Fill(ds.Orderline);
st.Fill(ds.Suppliers);
pot.Fill(ds.PurchaseOrders);
polt.Fill(ds.PurchaseOrderline);
}
private static object CreateDataSource()
{
var dataSource = new nwindDataSet();
var connection = new OleDbConnection();
connection.ConnectionString = Properties.Settings.Default.nwindConnectionString;
CustomersTableAdapter customers = new CustomersTableAdapter();
customers.Connection = connection;
customers.Fill(dataSource.Customers);
OrdersTableAdapter orders = new OrdersTableAdapter();
orders.Connection = connection;
orders.Fill(dataSource.Orders);
var bindingSource = new BindingSource();
bindingSource.DataSource = dataSource;
bindingSource.DataMember = "Customers";
return(bindingSource);
}
public Example()
{
InitializeComponent();
NWindDataSet dataSet = new
NWindDataSet();
OrdersTableAdapter ordersAdapter =
new OrdersTableAdapter();
ordersAdapter.Fill(dataSet.Orders);
Order_DetailsTableAdapter detailAdapter
= new Order_DetailsTableAdapter();
detailAdapter.Fill(dataSet.Order_Details);
radGridView1.AutoGenerateHierarchyFromDataSet = true;
radGridView1.DataMember = dataSet.Tables["Orders"].TableName;
radGridView1.ItemsSource = dataSet;
}
public OrdersDataProvider()
{
NorthwindDataSet dataset = NorthWindDataProvider.NorthwindDataSet;
adapter = new OrdersTableAdapter();
adapter.Fill(dataset.Orders);
AddRowChangeHandlers();
}
/// <summary>
/// Display inventory, customers, and orders report.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OutputForm_Load(object sender, EventArgs e)
{
// Create new strongly typed datatables, and associated table adapters.
var inventoryTable = new AutoLotDataSet.InventoryDataTable();
var ordersTable = new AutoLotDataSet.OrdersDataTable();
var customersTable = new AutoLotDataSet.CustomersDataTable();
InventoryTableAdapter inventoryAdapter = new InventoryTableAdapter();
CustomersTableAdapter customersAdapter = new CustomersTableAdapter();
OrdersTableAdapter ordersAdapter = new OrdersTableAdapter();
// now fill the tables with data
inventoryAdapter.Fill(inventoryTable);
customersAdapter.Fill(customersTable);
ordersAdapter.Fill(ordersTable);
// display all of the cars from inventory
textBoxOutput.AppendText($"Inventory Count = {inventoryTable.Count()}{Environment.NewLine}");
foreach (var car in inventoryTable)
{
textBoxOutput.AppendText($"{car.CarId} {car.Make} {car.Color} {car.Name}{Environment.NewLine}");
}
// display only cars with Id < 5
var carsQuery =
from car in inventoryTable
where car.CarId < 5
select car;
textBoxOutput.AppendText($"{Environment.NewLine}LINQ result CarId < 5{Environment.NewLine}");
foreach (var car in carsQuery)
{
textBoxOutput.AppendText($"{car.CarId} {car.Make} {car.Color} {car.Name}{Environment.NewLine}");
}
// display all orders, and show customer first and last name
var ordersQuery =
from order in ordersTable
from car in inventoryTable
from customer in customersTable
where order.CustId == customer.CustId
where order.CarId == car.CarId
select new
{
order.OrderId,
car.CarId, // note use of implicit names for new anon object
car.Name,
car.Make,
CustomerId = customer.CustId,
CustomerName = customer.FirstName + " " + customer.LastName,
};
textBoxOutput.AppendText($"{Environment.NewLine}Orders Count = {ordersQuery.Count()}{Environment.NewLine}");
foreach (var order in ordersQuery)
{
textBoxOutput.AppendText($"#{order.OrderId} {order.CarId} {order.Make} {order.Name} by {order.CustomerId} {order.CustomerName}{Environment.NewLine}");
}
}
