public static void ShowAllRooms(DataGridView a)
{
MyDatabase myDatabase = MyDatabase.GetInstance();
var data = myDatabase.rooms;
a.DataSource = data;
}
public static void ShowAllAddresses(DataGridView a)
{
MyDatabase myDatabase = MyDatabase.GetInstance();
var data = myDatabase.addresses;
a.DataSource = data;
}
public static void ShowAlPatientsPerRoom(DataGridView a)
{
MyDatabase myDatabase = MyDatabase.GetInstance();
var data = myDatabase.patients;
a.DataSource = data;
}
public static void ShowAllDoctors(DataGridView a)
{
MyDatabase myDatabase = MyDatabase.GetInstance();
var data = myDatabase.doctors;
a.DataSource = data;
a.Columns["address"].Visible = false;
}
public static void ShowAllPatients(DataGridView a)
{
MyDatabase myDatabase = MyDatabase.GetInstance();
var data = myDatabase.patients;
a.DataSource = data;
a.Columns["address"].Visible = false;
a.Columns["doctor"].Visible = false;
a.Columns["room"].Visible = false;
a.Columns["disease"].Visible = false;
}
public static void PrintAllDiseases()
{
MyDatabase a = MyDatabase.GetInstance();
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Console.WriteLine("{0,-30}{1}", "Disease", "Duration");
Console.ResetColor();
foreach (var item in a.diseases)
{
Console.WriteLine("{0,-30}{1}", item.Title, item.Duration);
}
}
public static void PrintAllRooms()
{
MyDatabase a = MyDatabase.GetInstance();
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Console.WriteLine("{0}", "Title");
Console.ResetColor();
foreach (var item in a.rooms)
{
Console.WriteLine("{0}", item.Title);
}
}
public static void PrintAllPatients()
{
MyDatabase a = MyDatabase.GetInstance();
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Console.WriteLine("{0,-12}{1,-12}{2,-5}{3,-25}{4}", "FirstName", "LastName", "Age", "EntryDate", "ExitDate");
Console.ResetColor();
foreach (var item in a.patients)
{
Console.WriteLine("{0,-12}{1,-12}{2,-5}{3,-25}{4}", item.FirstName, item.LastName, item.Age, item.EntryDate, item.ExitDate);
}
}
public static void PrintAllAddresses()
{
MyDatabase a = MyDatabase.GetInstance();
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Console.WriteLine("{0,-30}{1,-10}{2,-15}{3}", "Street", "Country", "City", "PostalCode");
Console.ResetColor();
foreach (var item in a.addresses)
{
Console.WriteLine("{0,-30}{1,-10}{2,-19}{3}", item.Name, item.Country, item.City, item.PostalCode);
}
}
public static void PrintAllDocs()
{
MyDatabase a = MyDatabase.GetInstance();
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Console.WriteLine("{0,-10}{1,-15}{2,-18}{3,-20}", "FirstΝame", "LastΝame", "Age", "Salary(Euro)");
Console.ResetColor();
foreach (var item in a.doctors)
{
Console.WriteLine("{0,-10}{1,-15}{2,-18}{3,-20}", item.FirstΝame, item.LastΝame, item.Age, item.Salary);
}
}
public static void PrintAllAddresses(string id = "", string name = "", string lastname = "", string age = "", string salary = "")
{
MyDatabase a = MyDatabase.GetInstance();
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Console.WriteLine("{0,-30}{1,-10}{2,-15}{3}", "Street", "Country", "City", "PostalCode");
Console.ResetColor();
foreach (var item in a.addresses)
{
if (item.Name == name || item.Id.ToString() == id || item.Country == lastname || item.PostalCode.ToString() == salary || item.City.ToString() == age)
{
Console.WriteLine("{0,-30}{1,-10}{2,-19}{3}", item.Name, item.Country, item.City, item.PostalCode);
}
}
}
public static void PrintAllDocs(string id = "", string name = "", string lastname = "", string age = "", string salary = "")
{
MyDatabase a = MyDatabase.GetInstance();
Console.ForegroundColor = ConsoleColor.DarkMagenta;
Console.WriteLine("{0,-10}{1,-15}{2,-18}{3,-20}", "FirstΝame", "LastΝame", "Age", "Salary(Euro)");
Console.ResetColor();
foreach (var item in a.doctors)
{
if (item.FirstΝame == name || item.Id.ToString() == id || item.LastΝame == lastname || item.Salary.ToString() == salary || item.Age.ToString() == age)
{
Console.WriteLine("{0,-10}{1,-15}{2,-18}{3,-20}", item.FirstΝame, item.LastΝame, item.Age, item.Salary);
}
}
}
public static void AllAddressesPerPatients()
{
MyDatabase a = MyDatabase.GetInstance();
Console.WriteLine("------------------------------");
foreach (var item in a.patients)
{
Console.WriteLine("------------------------------");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(item.FirstName);
Console.ResetColor();
Console.WriteLine("------------------------------\n");
Console.WriteLine(item.address.Name);
Console.WriteLine("------------------------------");
}
}
public static void PatientsPerDoctor()
{
MyDatabase a = MyDatabase.GetInstance();
Console.WriteLine("------------------------------");
foreach (var doc in a.doctors)
{
Console.WriteLine("------------------------------");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("{0}{1,-10}{2}", "Dr. ", doc.FirstΝame, doc.LastΝame);
Console.ResetColor();
Console.WriteLine("------------------------------");
Console.WriteLine();
foreach (var item in doc.Patients)
{
Console.WriteLine("{0,-10}{1}", item.FirstName, item.LastName);
Console.WriteLine();
}
Console.WriteLine("------------------------------");
}
}
public static void PatientsPerDisease()
{
MyDatabase a = MyDatabase.GetInstance();
Console.WriteLine("------------------------------");
foreach (var dis in a.diseases)
{
Console.WriteLine("------------------------------");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(dis.Title);
Console.ResetColor();
Console.WriteLine("------------------------------");
Console.WriteLine();
foreach (var item in dis.patients)
{
Console.WriteLine("{0,-10}{1}", item.FirstName, item.LastName);
Console.WriteLine();
}
Console.WriteLine("------------------------------");
}
}
public static void DoctorsPerAdress()
{
MyDatabase a = MyDatabase.GetInstance();
Console.WriteLine("------------------------------");
foreach (var add in a.addresses)
{
Console.WriteLine("------------------------------");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(add.Name);
Console.ResetColor();
Console.WriteLine("------------------------------");
Console.WriteLine();
foreach (var item in add.doctors)
{
Console.WriteLine("{0,-10}{1}", item.FirstΝame, item.LastΝame);
Console.WriteLine();
}
Console.WriteLine("------------------------------");
}
}
public static void PatientsPerRoom()
{
MyDatabase a = MyDatabase.GetInstance();
Console.WriteLine("------------------------------");
foreach (var room in a.rooms)
{
Console.WriteLine("------------------------------");
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(room.Title);
Console.ResetColor();
Console.WriteLine("------------------------------");
Console.WriteLine();
foreach (var item in room.Patients)
{
Console.WriteLine("{0,-10}{1}", item.FirstName, item.LastName);
Console.WriteLine();
}
Console.WriteLine("------------------------------");
}
}
