public DrugForm(string _drugName, int _drugQuantity, float _drugPrice, string _drugDescription, DateTime _drugManufactureDate,
DateTime _drugExpirationDate, int _drugManufacurerID, int _drugCategoryID)
{
InitializeComponent();
drugName = _drugName;
drugQuantity = _drugQuantity;
drugPrice = _drugPrice;
drugDescription = _drugDescription;
drugManufactureDate = _drugManufactureDate;
drugExpirationDate = _drugExpirationDate;
drugManufacurerID = _drugManufacurerID;
drugCategoryID = _drugCategoryID;
// заповнюємо manufacturerTable
string query = "SELECT id, name FROM manufacturer";
manufacturerTable = DBQueries.ExecuteQuery(query, new MySqlConnection(Settings.Default.connectionString));
foreach (DataRow dr in manufacturerTable.Rows)
{
CB_Drug_Manufacturer.Items.Add(dr["name"]);
}
// заповнюємо categoryTable
query = "SELECT id, name FROM category";
categoryTable = DBQueries.ExecuteQuery(query, new MySqlConnection(Settings.Default.connectionString));
foreach (DataRow dr in categoryTable.Rows)
{
CB_Drug_Category.Items.Add(dr["name"]);
}
FillInputBoxes();
}
public static DataTable SELECTQuery()
{
string query = "SELECT drug.*, category.name AS cname FROM drug " +
"LEFT JOIN category ON drug.category_id = category.id ";
return(DBQueries.ExecuteQuery(query, new MySqlConnection(Settings.Default.connectionString)));
}
public static DataTable SELECTQuery()
{
string query = "SELECT * FROM category";
return(DBQueries.ExecuteQuery(query, new MySqlConnection(Settings.Default.connectionString)));
}