private void button6_Click(object sender, EventArgs e)
{
try
{
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders";
SqlCommand cmd = new SqlCommand(selectQuery, connection);
connection.Open();
List <Order> orders = new List <Order>();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string bookName = reader[0].ToString();
string writerName = reader[1].ToString();
string edition = reader[2].ToString();
string qu = reader[3].ToString();
int quantity = Convert.ToInt16(qu);
Order anOrder = new Order();
anOrder.BookName = bookName;
anOrder.WriterName = writerName;
anOrder.Edition = edition;
anOrder.Quantity = quantity;
orders.Add(anOrder);
}
QuantitySelect aQuantitySelect = new QuantitySelect(orders);
aQuantitySelect.ShowDialog();
}
catch (SqlException exception)
{
MessageBox.Show(exception.Message);
}
}
private void button6_Click_1(object sender, EventArgs e)
{
try
{
DBManager manager = new DBManager();
SqlConnection connection = manager.Connection();
string selectQuery = "SELECT Book_Name,Writer,Edition,Quantity from Orders";
SqlCommand cmd = new SqlCommand(selectQuery, connection);
connection.Open();
List<Order> orders = new List<Order>();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string bookName = reader[0].ToString();
string writerName = reader[1].ToString();
string edition = reader[2].ToString();
string qu = reader[3].ToString();
int quantity = Convert.ToInt16(qu);
Order anOrder = new Order();
anOrder.BookName = bookName;
anOrder.WriterName = writerName;
anOrder.Edition = edition;
anOrder.Quantity = quantity;
orders.Add(anOrder);
}
QuantitySelect aQuantitySelect = new QuantitySelect(orders);
aQuantitySelect.ShowDialog();
}
catch (SqlException exception)
{
MessageBox.Show(exception.Message);
}
}