private void saveButton_Click(object sender, EventArgs e) { Purchase purchase = new Purchase(); purchase.PurchaseDate = purchasedateTimePicker.Text; purchase.Quantity = int.Parse(quantityTextBox.Text); purchase.MedicineName = medicineNameTextBox.Text; MessageBox.Show("Saved successfully"); }
public List<Purchase> ShowAll() { List<Purchase> purchases = new List<Purchase>(); SqlConnection sqlConnection = new SqlConnection(connectionString); string query = "SELECT p.id id,m.m_name name,p.qty qty,p.p_date date1,p.price price FROM purchase p, medicine m"; SqlCommand command = new SqlCommand(query, sqlConnection); sqlConnection.Open(); SqlDataReader myReader = command.ExecuteReader(); while (myReader.Read()) { Purchase purchase = new Purchase(); purchase.PurchaseId = Convert.ToInt32(myReader["id"].ToString()); purchase.PurchaseDate = myReader["date1"].ToString(); purchase.MedicineName = myReader["name"].ToString(); purchase.Quantity = Convert.ToInt32(myReader["qty"].ToString()); purchase.price = Convert.ToInt32(myReader["price"].ToString()); purchases.Add(purchase); } return purchases; }