private void btn1_Click(object sender, RoutedEventArgs e) { WebClient client = new WebClient(); client.Encoding = Encoding.UTF8; string result = client.DownloadString("https://apidata.mos.ru/v1/datasets/2263/rows?$top=10&api_key=c941a998bbb9e1e374fc2d7a33f61ed0"); List <ResultFromServer> resultServer = JsonConvert.DeserializeObject <List <ResultFromServer> >(result); var optionsBuilder = new DbContextOptionsBuilder <InstituteContext>(); string newPath = System.IO.Path.GetFullPath(System.IO.Path.Combine(Directory.GetCurrentDirectory(), @"..\..\..\..\")); string newnewpath = System.IO.Path.Combine(newPath, "MoscowInstitute.WebService", "MoscowInstitute.db"); optionsBuilder.UseSqlite($"Data Source={newnewpath}"); var context = new InstituteContext(options: optionsBuilder.Options); context.Database.ExecuteSqlRaw("DELETE FROM Institutes"); using (context) { foreach (var item in resultServer) { DomainObjects.Institute institute = new DomainObjects.Institute(); institute.ShortName = item.Cells.ShortName; institute.LegalAddress = item.Cells.LegalAddress; institute.WebSite = item.Cells.WebSite; institute.ChiefName = item.Cells.ChiefName; context.Entry(institute).State = EntityState.Added; context.SaveChanges(); } } }
public InstructorRepository(InstituteContext context) : base(context) { Context = context; }
public TeachersController(InstituteContext context) { _context = context; }
public StudentsController(InstituteContext context) { _Context = context; }
public DepartmentRepository(InstituteContext context) : base(context) { Context = context; }
public EnrollmentRepository(InstituteContext context) : base(context) { }
public CoursesController(InstituteContext context) { _context = context; }
public CourseRepository(InstituteContext context) : base(context) { Context = context; }
public Repository(InstituteContext context) { Context = context; }
public StudentRepository(InstituteContext context) : base(context) { Context = context; }
public CourseAssignmentRepository(InstituteContext context) : base(context) { Context = context; }