internal static bool Insert()
{
int gydymoNr = 0;
foreach (DataRow rows in ManualDbConnection.Select("SELECT * FROM dbo.Gydymas").Rows)
{
gydymoNr = rows.Field<int>("Gydymo_Nr");
}
gydymoNr++;
var context = new LigoninesDBEntities();
Console.Write("Įveskite gydytojo AK: ");
string gydAK = Console.ReadLine();
Console.Write("Įveskite paciento AK: ");
string pacAK = Console.ReadLine();
Console.Write("Įveskite diagnozę: ");
string diagnoze = Console.ReadLine();
Console.Write("Įveskite skirtus vaistus: ");
string vaistai = Console.ReadLine();
context.Gydymas1.Add(new Gydymas()
{
Gydymo_Nr = gydymoNr,
GydytojoAK = gydAK,
PacientoAK = pacAK,
Diagnoze = diagnoze,
Skirti_Vaistai = vaistai,
Pradeta = DateTime.Now
});
context.SaveChanges();
Console.WriteLine("Success!");
return true;
}
public static void GroupTreatments()
{
var context = new LigoninesDBEntities();
var treats =
from t in context.Gydymas1
group t by t.Baigta != null;
Console.WriteLine();
foreach (var treat in treats)
{
if (treat.Key)
Console.WriteLine("Baigti gydymai:");
else
Console.WriteLine("Nebaigti gydymai:");
foreach (var row in treat)
{
Console.Write("\t-" + row.Gydymo_Nr, row.Diagnoze);
if (treat.Key)
Console.WriteLine("{0}", row.Baigta.ToString());
else
Console.WriteLine();
}
}
}
public static void Select()
{
var context = new LigoninesDBEntities();
Console.WriteLine("{0, -10}{1, -15}{2, -10}{3, -10}","AK", "Vardas", "Pavarde", "Gimimo Metai");
foreach (Pacientas patient in context.Pacientas1)
{
Console.WriteLine("{0, -10}{1, -15}{2, -10}{3, -10}", patient.AK, patient.Vardas, patient.Pavarde, patient.Gimimo_Metai);
}
Console.WriteLine();
}
public static void Select()
{
var context = new LigoninesDBEntities();
Console.WriteLine("{0, -10}{1, -15}{2, -10}{3, -10}{4, -15}{5, -10}{6, -10}","Gydymo nr", "Pradėta", "Baigta", "Skirti vaistai", "Gydytojo AK", "Paciento AK", "Diagnozė");
foreach (Gydymas treatment in context.Gydymas1)
{
Console.WriteLine("{0, -10}{1, -15}{2, -10}{3, -10}{4, -15}{5, -10}{6, -10}",
treatment.Gydymo_Nr, treatment.Pradeta, treatment.Baigta, treatment.Skirti_Vaistai,
treatment.GydytojoAK, treatment.PacientoAK, treatment.Diagnoze);
}
Console.WriteLine();
}
internal static bool Delete()
{
var context = new LigoninesDBEntities();
Console.Write("Įveskite paciento AK");
string AK = Console.ReadLine();
foreach(Pacientas patient in context.Pacientas1.ToList())
{
if(patient.AK.ToString() == AK)
{
context.Pacientas1.Remove(patient);
context.SaveChanges();
Console.WriteLine("Success!");
return true;
}
}
Console.WriteLine("Tokio paciento nėra!");
return false;
}
internal static bool Update()
{
var context = new LigoninesDBEntities();
Console.Write("Įveskite gydymo numerį: ");
string gydymoNr = Console.ReadLine();
foreach(Gydymas treatment in context.Gydymas1.ToList())
{
if (gydymoNr.Equals(treatment.Gydymo_Nr.ToString()))
{
Console.Write("Įveskite pabaigos datą (dd/mm/yyyy): ");
DateTime date = DateTime.Parse(Console.ReadLine());
treatment.Baigta = date;
context.SaveChanges();
Console.WriteLine("Success!");
return true;
}
}
Console.WriteLine("Tokio gydymo nėra!");
return false;
}
internal static bool Insert()
{
var context = new LigoninesDBEntities();
Console.Write("Įveskite naujo paciento asmens kodą: ");
string AK = Console.ReadLine();
Console.Write("Įveskite naujo paciento vardą: ");
string vardas = Console.ReadLine();
Console.Write("Įveskite naujo paciento pavardę: ");
string pavarde = Console.ReadLine();
Console.Write("Įveskite naujo paciento gimimo datą (dd/mm/yyyy): ");
DateTime data = DateTime.Parse(Console.ReadLine());
context.Pacientas1.Add(new Pacientas()
{
AK = AK,
Vardas = vardas,
Pavarde = pavarde,
Gimimo_Metai = data
});
context.SaveChanges();
Console.WriteLine("Success!");
return true;
}
public static void Salaries()
{
int from;
int to;
var context = new LigoninesDBEntities();
Console.WriteLine("Viso elementu: " + context.Gydytojas1.Count());
Console.WriteLine();
Console.Write("Norimas pirmas elementas: ");
from = int.Parse(Console.ReadLine());
Console.Write("Norimas paskutinis elementas: ");
to = int.Parse(Console.ReadLine());
var docs = context.Gydytojas1.OrderBy(c => c.AK).Skip(from).Take(to);
Console.WriteLine(Environment.NewLine + "{0, -10}{1, -15}{2, -15}", "Vardas", "Pavarde", "Atlyginimas");
foreach (var doc in docs)
{
Console.WriteLine("{0, -10}{1, -15}{2, -15}", doc.Vardas, doc.Pavarde, doc.Atlyginimas);
}
int atlyginimuSuma = docs.ToList().Aggregate(0, (a, b) => (int)(b.Atlyginimas + a));
Console.WriteLine("Bendra suma: {0}", atlyginimuSuma);
}
public static void PatientsAndTreatments()
{
var context = new LigoninesDBEntities();
var group =
from p in context.Pacientas1
join pa in context.Gydymas1 on p.AK equals pa.PacientoAK into pacientai
from pac in pacientai
select new
{
p.Vardas,
p.Pavarde,
pac.Diagnoze
};
Console.WriteLine();
foreach (var element in group)
{
Console.WriteLine("{0, -10}{1, -15}{2}", element.Vardas, element.Pavarde, element.Diagnoze);
}
Console.WriteLine();
}
