private void MyOrders_Load(object sender, EventArgs e)
{
Entities.UserDetails orderDetails = new Entities.UserDetails();
SqlConnection connection = null;
DataTable table = new DataTable();
try
{
DaoLayer.CustomerDBLayer dbLayer = new DaoLayer.CustomerDBLayer();
connection = dbLayer.GetConnection();
string name = UserDetailsForm.loginID_Myorders;
string sql = "SELECT * FROM CUSTOMER_ORDER WHERE Login_ID = @loginId";
SqlDataReader reader = dbLayer.GetAllCustOrders(sql, name);
// SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
table.Load(reader);
reader.Close();
dataGridView1.DataSource = table;
dataGridView1.ReadOnly = true;
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
connection.Close();
}
}
//Load all the order details placed - with Order ID
private void OrderDetails_Load(object sender, EventArgs e)
{
SqlConnection connection = null;
DataTable table = new DataTable();
try
{
DaoLayer.CustomerDBLayer dbLayer = new DaoLayer.CustomerDBLayer();
connection = dbLayer.GetConnection();
string sql = "SELECT * FROM CUSTOMER_ORDER WHERE Order_ID = @orderID";
SqlDataReader reader = dbLayer.GetUserDetails(sql, orderID);
// SqlDataAdapter adapter = new SqlDataAdapter(sql, connection);
table.Load(reader);
reader.Close();
// Append details to summary grid
SummaryGridView.DataSource = table;
SummaryGridView.ReadOnly = true;
}
catch (Exception exception) {
MessageBox.Show(exception.Message);
}
finally
{
//close connection
connection.Close();
}
}
