public static Medicines GetMedicine(int id)
{
_command.Parameters.Clear();
_command.CommandText = "SELECT ID, Name, Price, Manufacturer, Amount, WithPrescription FROM Medicines WHERE ID = @id;";
_command.Parameters.Add(new SqlParameter("@id", SqlDbType.Int)
{
Value = id
});
_command.Connection = _connection;
_connection.Open();
var reader = _command.ExecuteReader();
if (reader.Read())
{
var m = new Medicines(reader["Name"].ToString(), reader["Manufacturer"].ToString(), Convert.ToDecimal(reader["Price"]), Convert.ToInt32(reader["Amount"]), Convert.ToByte(reader["WithPrescription"]), Convert.ToInt32(reader["ID"]));
_connection.Close();
return(m);
}
else
{
Console.WriteLine("Brak produktu z podanym ID w bazie.");
_connection.Close();
return(null);
}
}
static void Main(string[] args)
{
int option = -1;
while (true)
{
Console.ForegroundColor = ConsoleColor.White;
Console.WriteLine("\n*** MAGAZYN ***");
Console.WriteLine("0. Szukaj leku");
Console.WriteLine("1. Dodaj Lek");
Console.WriteLine("2. Pokaż listę leków");
Console.WriteLine("3. Aktualizuj lek");
Console.WriteLine("4. Usuń lek");
Console.WriteLine("*** SPRZEDAŻ ***");
Console.WriteLine("5. Sprzedaj lek");
Console.WriteLine("*** PACJENCI ***");
Console.WriteLine("6. Lista pacjentów i recept");
Console.WriteLine("*** RAPORTY ***");
Console.WriteLine("7. Leki - mały stan magazynowy");
Console.WriteLine("8. Sprzedaż - Top 10 leków");
Console.WriteLine("9. Sprzedaż - Top 10 pacjentów");
Console.WriteLine("*** INNE ***");
Console.WriteLine("10. Wyjście");
Console.Write("Wybierasz: ");
try
{
option = Convert.ToInt32(Console.ReadLine());
}
catch (FormatException)
{
Console.WriteLine("Błędna opcja.");
}
if (option == 10)
{
break;
}
switch (option)
{
case 0:
Console.ForegroundColor = ConsoleColor.DarkCyan;
Console.Write("Szukana nazwa: ");
string searchName = Console.ReadLine();
Show.SearchMedicines(searchName);
break;
case 1:
Console.ForegroundColor = ConsoleColor.Blue;
Medicines.AddMedicine();
break;
case 2:
Console.ForegroundColor = ConsoleColor.Cyan;
Show.ShowMedicines("SELECT ID, Name, Manufacturer, Price, Amount, WithPrescription FROM Medicines;");
break;
case 3:
Console.ForegroundColor = ConsoleColor.Blue;
Medicines.UpdateMedicine();
break;
case 4:
Console.ForegroundColor = ConsoleColor.Red;
Medicines.DeleteMedicine();
break;
case 5:
Console.ForegroundColor = ConsoleColor.Green;
Sales.Sell();
break;
case 6:
Console.ForegroundColor = ConsoleColor.Cyan;
Show.ShowPrescriptionsAndPatients();
break;
case 7:
Console.ForegroundColor = ConsoleColor.Yellow;
Show.ShowMedicines("SELECT ID, Name, Manufacturer, Price, Amount, WithPrescription FROM Medicines WHERE Amount <= 20 ORDER BY Amount ASC;");
break;
case 8:
Console.ForegroundColor = ConsoleColor.Magenta;
Show.ShowMedicineBestsellers();
break;
case 9:
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Show.ShowTopBuyers();
break;
default:
continue;
}
}
}