public void INSERTQuery()
{
if (ShowDialog() == DialogResult.OK)
{
string query = $"INSERT INTO category (name) VALUES ('{categoryName}') ";
DBQueries.ExecuteNonQuery(query, new MySqlConnection(Settings.Default.connectionString));
}
}
public void UPDATEQuery(int id)
{
if (ShowDialog() == DialogResult.OK)
{
string query = $"UPDATE category SET name = '{categoryName}' " +
$"WHERE id = {id} ";
DBQueries.ExecuteNonQuery(query, new MySqlConnection(Settings.Default.connectionString));
}
}
public void INSERTQuery()
{
if (ShowDialog() == DialogResult.OK)
{
string query = "INSERT INTO manufacturer (name, country, address, phone_number, site) " +
$"VALUES ('{manufacturerName}'," +
$" '{manufacturerCountry}', " +
$" '{manufacturerAddress}', " +
$" '{manufacturerPhoneNumber}', " +
$" '{manufacturerSite}') ";
DBQueries.ExecuteNonQuery(query, new MySqlConnection(Settings.Default.connectionString));
}
}
public void UPDATEQuery(int id)
{
if (ShowDialog() == DialogResult.OK)
{
string query = "UPDATE manufacturer " +
$"SET name = '{manufacturerName}', " +
$" country = '{manufacturerCountry}', " +
$" address = '{manufacturerAddress}', " +
$" phone_number = '{manufacturerPhoneNumber}', " +
$" site = '{manufacturerSite}' " +
$"WHERE id = {id} ";
DBQueries.ExecuteNonQuery(query, new MySqlConnection(Settings.Default.connectionString));
}
}
public void INSERTQuery()
{
if (ShowDialog() == DialogResult.OK)
{
string query = $"INSERT INTO drug (name, quantity, price, manufacture_date, expiration_date, description, manufacturer_id, category_id) " +
$"VALUES ('{drugName}', " +
$" {drugQuantity}, " +
$" {drugPrice}, " +
$" '{drugManufactureDate.Year}.{drugManufactureDate.Month}.{drugManufactureDate.Day}', " +
$" '{drugExpirationDate.Year}.{drugExpirationDate.Month}.{drugExpirationDate.Day}', " +
$" '{drugDescription}', " +
$" {drugManufacurerID}, " +
$" {drugCategoryID}) ";
DBQueries.ExecuteNonQuery(query, new MySqlConnection(Settings.Default.connectionString));
}
}
public void UPDATEQuery(int id)
{
if (ShowDialog() == DialogResult.OK)
{
string query = $"UPDATE drug " +
$"SET name = '{drugName}', " +
$" quantity = {drugQuantity}, " +
$" price = {drugPrice}, " +
$" manufacture_date = '{drugManufactureDate.Year}.{drugManufactureDate.Month}.{drugManufactureDate.Day}', " +
$" expiration_date = '{drugExpirationDate.Year}.{drugExpirationDate.Month}.{drugExpirationDate.Day}', " +
$" description = '{drugDescription}', " +
$" manufacturer_id = {drugManufacurerID}, " +
$" category_id = {drugCategoryID} " +
$"WHERE id = {id} ";
DBQueries.ExecuteNonQuery(query, new MySqlConnection(Settings.Default.connectionString));
}
}
public static void DELETEQuery(int id)
{
string query = $"DELETE FROM category WHERE id = {id} ";
DBQueries.ExecuteNonQuery(query, new MySqlConnection(Settings.Default.connectionString));
}
