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(); }