public async static void DeleteLector(DisciplineContext db, Lector spam) { if (spam != null) { db.Lectors.Remove(spam); await db.SaveChangesAsync(); } }
public static void DeleteDiscipline(DisciplineContext db, Discipline spam) { if (spam != null) { db.Disciplines.Remove(spam); db.SaveChanges(); } }
public async static void ReadactLector(DisciplineContext db, Lector spam, int auditorium) { if (spam != null) { spam.Auditorium = auditorium; await db.SaveChangesAsync(); } }
public static void ReadactDiscipline(DisciplineContext db, Discipline spam, string name, int CountOfLabs) { if (spam != null) { spam.NameOfTheDiscipline = name; spam.CountOfLabs = CountOfLabs; db.SaveChanges(); } }
public static void ShowLector(DisciplineContext db) { var users = db.Lectors; Console.WriteLine("\n\n\nСписок Лекторов:\n"); foreach (Lector u in users) { Console.WriteLine("{0} {1} {2} {3} ", u.LectorId, u.Name, u.Dist, u.Department, u.Auditorium); } }
public static void Search2(DisciplineContext db, string name, int countoflabs) { Console.WriteLine("\n\nРезультат поиска по имени и количеству лаб"); var Disciplines = db.Disciplines.Where(p => p.NameOfTheDiscipline == name).Where(p => p.CountOfLabs == countoflabs); foreach (var t in Disciplines) { Console.WriteLine("{0} {1} {2} {3} {4} {5} {6} {7}", t.DisciplineId, t.NameOfTheDiscipline, t.Semestr, t.Course, t.Specialty, t.TypeOfControl, t.CountOfLabs, t.CountOfLections); } }
public static void Sort(DisciplineContext db) { var Disciplines = db.Disciplines.OrderBy(pp => pp.NameOfTheDiscipline).Select(p => p); Console.WriteLine("\n\nРезультат сортировки"); foreach (var t in Disciplines) { Console.WriteLine("{0} {1} {2} {3} {4} {5} {6} {7}", t.DisciplineId, t.NameOfTheDiscipline, t.Semestr, t.Course, t.Specialty, t.TypeOfControl, t.CountOfLabs, t.CountOfLections); } }
public static void SqlCommand(DisciplineContext db, int countOfLabs) { string str = countOfLabs.ToString(); System.Data.SqlClient.SqlParameter param = new System.Data.SqlClient.SqlParameter("@CountOfLabs", str); var disciplines = db.Database.SqlQuery <Discipline>("SELECT * FROM Disciplines WHERE CountOfLabs = @CountOfLabs", param); Console.WriteLine(String.Format("\n\n\nСписок Дисциплин с количеством лаб {0}:\n", str)); foreach (var phone in disciplines) { Console.WriteLine(phone.NameOfTheDiscipline); } }
public static void ShowDisciplines(DisciplineContext db) { var users = db.Disciplines; Console.WriteLine("\n\n\nСписок Дисциплин:\n"); var Disciplines = db.Disciplines.Include(a => a.Lectors).ToList(); foreach (var t in Disciplines) { Console.WriteLine("{0} {1} {2} {3} {4} {5} {6} {7}", t.DisciplineId, t.NameOfTheDiscipline, t.Semestr, t.Course, t.Specialty, t.TypeOfControl, t.CountOfLabs, t.CountOfLections); foreach (var p in t.Lectors) { Console.WriteLine($"{p.Name}"); } } }
public async static void AddLector(DisciplineContext db, Lector spam) { db.Lectors.Add(spam); await db.SaveChangesAsync(); }
public static void AddDiscipline(DisciplineContext db, Discipline spam) { db.Disciplines.Add(spam); db.SaveChanges(); }