Search This Blog

Wednesday, March 23, 2011

Main.cs

#region Full Table Requests

private void employeesToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table emp = Accessor.GetEmployeeTable();
dataGridView1.DataSource = emp;
}

private void shippersToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table ship = Accessor.GetShipperTable();
dataGridView1.DataSource = ship;
}

private void ordersToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table orders = Accessor.GetOrderTable();
dataGridView1.DataSource = orders;
}

private void employeeTerritoryToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table empTerrs = Accessor.GetEmployeeTerritoryTable();
dataGridView1.DataSource = empTerrs;
}

private void territoryToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table terrs = Accessor.GetTerritoryTable();
dataGridView1.DataSource = terrs;
}

private void regionToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table regs = Accessor.GetRegionTable();
dataGridView1.DataSource = regs;
}

private void customerToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table cust = Accessor.GetCustomerTable();
dataGridView1.DataSource = cust;
}

private void customerDemoToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table custdemo = Accessor.GetCustomerDemoTable();
dataGridView1.DataSource = custdemo;
}

private void customerDemographicToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table custdemograph = Accessor.GetCustomerDemographicTable();
dataGridView1.DataSource = custdemograph;
}


private void orderDetailsToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table ordDetails = Accessor.GetOrderDetailsTable();
dataGridView1.DataSource = ordDetails;
}

private void productToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table prods = Accessor.GetProductTable();
dataGridView1.DataSource = prods;
}

private void supplierProductToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table prods = Accessor.GetSupplierTable();
dataGridView1.DataSource = prods;
}

private void categoToolStripMenuItem_Click(object sender, EventArgs e)
{
System.Data.Linq.Table cats = Accessor.GetCategoryTable();
dataGridView1.DataSource = cats;
}

#endregion



#region Queries


///
/// Find and display an employee by
/// the employee's ID
///

///
///
private void employeeByIDToolStripMenuItem_Click(object sender, EventArgs e)
{

Employee emp = Accessor.GetEmployeeById(1);

StringBuilder sb = new StringBuilder();
sb.Append("Employee 1: " + Environment.NewLine);
sb.Append("Name: " + emp.FirstName + " " + emp.LastName + Environment.NewLine);
sb.Append("Hire Date: " + emp.HireDate + Environment.NewLine);
sb.Append("Home Phone: " + emp.HomePhone + Environment.NewLine);

MessageBox.Show(sb.ToString(), "Employee ID Search");
}


///
/// Gets an Order by the order ID and
/// displays information about the first
/// single matching order.
///

///
///
private void orderByIDToolStripMenuItem_Click(object sender, EventArgs e)
{
Order ord = Accessor.GetOrderById(10248);

StringBuilder sb = new StringBuilder();
sb.Append("Order: " + Environment.NewLine);
sb.Append("Order ID: " + ord.OrderID + Environment.NewLine);
sb.Append("Date Shipped: " + ord.ShippedDate + Environment.NewLine);
sb.Append("Shipping Address: " + ord.ShipAddress + Environment.NewLine);
sb.Append(" City: " + ord.ShipCity + Environment.NewLine);
sb.Append(" Region: " + ord.ShipRegion + Environment.NewLine);
sb.Append(" Country: " + ord.ShipCountry + Environment.NewLine);
sb.Append(" Postal Code: " + ord.ShipPostalCode + Environment.NewLine);
sb.Append("Shipping Name: " + ord.ShipName + Environment.NewLine);

MessageBox.Show(sb.ToString(), "Shipping Information");
}



///
/// Displays a list of employeess ordered by
/// their dates of hire
///

///
///
private void employeesByHireDateToolStripMenuItem_Click(object sender, EventArgs e)
{
List emps = Accessor.GetEmployeesByHireDate();
dataGridView1.DataSource = emps;
}


///
/// Displays all orders that match
/// on Order ID
///

///
///
private void ordersByIdToolStripMenuItem_Click(object sender, EventArgs e)
{
List orders = Accessor.GetOrdersById(10248);
dataGridView1.DataSource = orders;
}

///
/// Returns values based on joining the Order and
/// Order_Details tables
///

///
///
private void ordersAndDetailsToolStripMenuItem_Click(object sender, EventArgs e)
{
List oad = Accessor.OrdersAndDetails();
dataGridView1.DataSource = oad;
}


///
/// Query across entity set
/// This example collections information from the orders table
/// and the order_details table through the orders table
/// entity reference to orders_details.
///

///
///
private void ordersAndDetailsEntityRefToolStripMenuItem_Click(object sender, EventArgs e)
{
List opr = Accessor.GetOrderAndPricingInformation();
dataGridView1.DataSource = opr;
}



///
/// Retrieves values across an entity set to
/// display both order and pricing information
/// by filtering for an order ID
///

///
///
private void ordersAndDetailsByOrderIDEntityRefToolStripMenuItem_Click(object sender, EventArgs e)
{
List opr = Accessor.GetOrderAndPricingInformationByOrderId(10248);
dataGridView1.DataSource = opr;
}



///
/// Displays to total dollar value of the selected order
/// by multiplying each order product's unit cost by
/// the units ordered, and then summing the total of each
/// individual cost.
///

///
///
private void orderValueByOrderIDToolStripMenuItem_Click(object sender, EventArgs e)
{
// get the dollar value
decimal? d = Accessor.GetOrderValueByOrderId(10248);

// convert the decimal value to currency
string dollarValue = string.Format("{0:c}", d);

// display the dollar value
MessageBox.Show("The total dollar value of order 10248 is " +
dollarValue, "Order 10248 Value");
}



///
/// Displays the top five orders in the order table
/// on first selection and then increments up by
/// five orders to show the list five orders
/// at a time
///

///
///
private void getTopFiveOrdersToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
// get the top five orders starting at the current position
List ords = Accessor.GetTopFiveOrdersById(OrderPosition);
dataGridView1.DataSource = ords;

// increment the formwide variable used to
// keep track of the position within the
// list of orders
OrderPosition += 5;

// change the text in the menu strip item
// to show that it will retrieve the next
// five values after the current position
// of th last value shown in the grid
getTopFiveOrdersToolStripMenuItem.Text = "Get Next Five Orders";
}
catch
{
MessageBox.Show("Cannot increment an higher, starting list over.");
OrderPosition = 0;
}
}

#endregion



#region Insert Update Delete


private void insertOrUpdateCustomerToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
Accessor.InsertOrUpdateCustomer("AAAAA", "BXSW", "Mookie Carbunkle", "Chieftain",
"122 North Main Street", "Wamucka", "DC", "78888", "USA", "244-233-8977",
"244-438-2933");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}

private void deleteCustomerToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
Accessor.DeleteCustomer("AAAAA");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}


#endregion



#region Stored Procedures

///
/// Execute stored procedure: Sales By Year
///

///
///
private void salesByYearToolStripMenuItem_Click(object sender, EventArgs e)
{
DateTime start = new DateTime(1990, 1, 1);
DateTime end = new DateTime(2000, 1, 1);

List result = Accessor.SalesByYear(start, end);
dataGridView1.DataSource = result;
}



///
/// Execute stored procedure: Ten Most Expensive Products
///

///
///
private void tenMostExpensiveProductsToolStripMenuItem_Click(object sender, EventArgs e)
{
List result = Accessor.TenMostExpensiveProducts();
dataGridView1.DataSource = result;
}


#endregion


#region Housekeeping

private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}

#endregion

1 comment:

  1. I must thank you for the efforts you have put in writing this blog.
    I am hoping to view the same high-grade blog posts from
    you in the future as well. In truth, your creative
    writing abilities has inspired me to get my own, personal site now ;)

    My page: discount coupon

    ReplyDelete