Ejemplo n.º 1
0
        /// <summary>
        /// Инициализация таблицы "Таблица для связи EduPlan и EduVidDeyat"
        /// </summary>
        /// <param name="serviceProvider"></param>
        /// <param name="configuration"></param>
        /// <returns></returns>
        public static async Task CreateEduPlanEduVidDeyats(IServiceProvider serviceProvider, IConfiguration configuration)
        {
            using (var serviceScope = serviceProvider.GetRequiredService <IServiceScopeFactory>().CreateScope())
            {
                AppIdentityDBContext context = serviceScope.ServiceProvider.GetService <AppIdentityDBContext>();

                #region Инициализация таблицы "Таблица для связи EduPlan и EduVidDeyat"
                if (!await context.EduPlanEduVidDeyats.AnyAsync())
                {
                    EduPlanEduVidDeyat EduPlanEduVidDeyat1 = new EduPlanEduVidDeyat
                    {
                        EduPlanEduVidDeyatId = 1,
                        EduPlanId            = 1,
                        EduVidDeyatId        = 1
                    };



                    await context.EduPlanEduVidDeyats.AddRangeAsync(
                        EduPlanEduVidDeyat1

                        );

                    await context.SaveChangesAsync();
                }
                #endregion
            }
        }
Ejemplo n.º 2
0
        public async Task <IActionResult> Edit(int id, [Bind("EduPlanEduVidDeyatId,EduPlanId,EduVidDeyatId")] EduPlanEduVidDeyat eduPlanEduVidDeyat)
        {
            if (id != eduPlanEduVidDeyat.EduPlanEduVidDeyatId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(eduPlanEduVidDeyat);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!EduPlanEduVidDeyatExists(eduPlanEduVidDeyat.EduPlanEduVidDeyatId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            var EduPlans = _context.EduPlans
                           .Include(p => p.EduProfile.EduNapravl.EduUgs.EduLevel)
                           .Include(p => p.EduForm);

            ViewData["EduPlanId"]     = new SelectList(EduPlans, "EduPlanId", "EduPlanDescription", eduPlanEduVidDeyat.EduPlanId);
            ViewData["EduVidDeyatId"] = new SelectList(_context.EduVidDeyat, "EduVidDeyatId", "EduVidDeyatName", eduPlanEduVidDeyat.EduVidDeyatId);
            return(View(eduPlanEduVidDeyat));
        }
Ejemplo n.º 3
0
        public async Task <IActionResult> Create(EduPlanEduVidDeyat eduPlanEduVidDeyat)
        {
            if (ModelState.IsValid)
            {
                _context.Add(eduPlanEduVidDeyat);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            ViewData["EduPlanId"]     = new SelectList(_context.EduPlans, "EduPlanId", "EduPlanId", eduPlanEduVidDeyat.EduPlanId);
            ViewData["EduVidDeyatId"] = new SelectList(_context.EduVidDeyat, "EduVidDeyatId", "EduVidDeyatId", eduPlanEduVidDeyat.EduVidDeyatId);
            return(View(eduPlanEduVidDeyat));
        }
Ejemplo n.º 4
0
        public async Task <IActionResult> Edit(int id, EduPlan eduPlan, IFormFile uploadedFile, int[] EduVidDeyatIds, int[] EduYearBeginningTrainingIds, int[] EduPlanEduYearIds)
        {
            if (id != eduPlan.EduPlanId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                if (uploadedFile != null)
                {
                    FileModel fileModel = await KisVuzDotNetCore2.Models.Files.Files.LoadFile(_context, _appEnvironment, uploadedFile, "Учебный план", FileDataTypeEnum.UchebniyPlan);

                    await _context.SaveChangesAsync();

                    int?fileToRemoveId = eduPlan.EduPlanPdfId;
                    eduPlan.EduPlanPdfId = fileModel.Id;
                    await _context.SaveChangesAsync();

                    KisVuzDotNetCore2.Models.Files.Files.RemoveFile(_context, _appEnvironment, fileToRemoveId);
                }

                try
                {
                    _context.Update(eduPlan);
                    await _context.SaveChangesAsync();

                    if (EduVidDeyatIds != null)
                    {
                        _context.EduPlanEduVidDeyats.RemoveRange(_context.EduPlanEduVidDeyats.Where(v => v.EduPlanId == eduPlan.EduPlanId));
                        await _context.SaveChangesAsync();

                        var eduPlanEduVidDeyats = new List <EduPlanEduVidDeyat>();
                        foreach (var EduVidDeyatId in EduVidDeyatIds)
                        {
                            EduPlanEduVidDeyat eduPlanEduVidDeyat = new EduPlanEduVidDeyat();
                            eduPlanEduVidDeyat.EduPlanId     = eduPlan.EduPlanId;
                            eduPlanEduVidDeyat.EduVidDeyatId = EduVidDeyatId;
                            eduPlanEduVidDeyats.Add(eduPlanEduVidDeyat);
                        }
                        await _context.EduPlanEduVidDeyats.AddRangeAsync(eduPlanEduVidDeyats);

                        await _context.SaveChangesAsync();
                    }

                    if (EduYearBeginningTrainingIds != null)
                    {
                        _context.EduPlanEduYearBeginningTraining.RemoveRange(_context.EduPlanEduYearBeginningTraining.Where(y => y.EduPlanId == eduPlan.EduPlanId));
                        await _context.SaveChangesAsync();

                        var eduPlanEduYearBeginningTrainings = new List <EduPlanEduYearBeginningTraining>();
                        foreach (var EduYearBeginningTrainingId in EduYearBeginningTrainingIds)
                        {
                            EduPlanEduYearBeginningTraining eduPlanEduYearBeginningTraining = new EduPlanEduYearBeginningTraining();
                            eduPlanEduYearBeginningTraining.EduPlanId = eduPlan.EduPlanId;
                            eduPlanEduYearBeginningTraining.EduYearBeginningTrainingId = EduYearBeginningTrainingId;
                            eduPlanEduYearBeginningTrainings.Add(eduPlanEduYearBeginningTraining);
                        }
                        await _context.EduPlanEduYearBeginningTraining.AddRangeAsync(eduPlanEduYearBeginningTrainings);

                        await _context.SaveChangesAsync();
                    }

                    if (EduPlanEduYearIds != null)
                    {
                        _context.EduPlanEduYears.RemoveRange(_context.EduPlanEduYears.Where(y => y.EduPlanId == eduPlan.EduPlanId));
                        await _context.SaveChangesAsync();

                        var eduPlanEduYears = new List <EduPlanEduYear>();
                        foreach (var EduPlanEduYearId in EduPlanEduYearIds)
                        {
                            EduPlanEduYear eduPlanEduYear = new EduPlanEduYear();
                            eduPlanEduYear.EduPlanId = eduPlan.EduPlanId;
                            eduPlanEduYear.EduYearId = EduPlanEduYearId;
                            eduPlanEduYears.Add(eduPlanEduYear);
                        }
                        await _context.EduPlanEduYears.AddRangeAsync(eduPlanEduYears);

                        await _context.SaveChangesAsync();
                    }
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!EduPlanExists(eduPlan.EduPlanId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            ViewData["EduFormId"]        = new SelectList(_context.EduForms, "EduFormId", "EduFormId", eduPlan.EduFormId);
            ViewData["EduPlanPdfId"]     = new SelectList(_context.Files, "Id", "Id", eduPlan.EduPlanPdfId);
            ViewData["EduProfileId"]     = new SelectList(_context.EduProfiles, "EduProfileId", "EduProfileId", eduPlan.EduProfileId);
            ViewData["EduProgramPodgId"] = new SelectList(_context.EduProgramPodg, "EduProgramPodgId", "EduProgramPodgId", eduPlan.EduProgramPodgId);
            ViewData["EduSrokId"]        = new SelectList(_context.EduSrok, "EduSrokId", "EduSrokId", eduPlan.EduSrokId);
            ViewData["StructKafId"]      = new SelectList(_context.StructKafs, "StructKafId", "StructKafId", eduPlan.StructKafId);

            return(View(eduPlan));
        }
Ejemplo n.º 5
0
        public async Task <IActionResult> Create(EduPlan eduPlan, IFormFile uploadedFile, int[] EduVidDeyatIds, int[] EduYearBeginningTrainingIds, int[] EduPlanEduYearIds)
        {
            if (ModelState.IsValid && uploadedFile != null)
            {
                FileModel fileModel = await KisVuzDotNetCore2.Models.Files.Files.LoadFile(_context, _appEnvironment, uploadedFile, "Учебный план", FileDataTypeEnum.UchebniyPlan);

                eduPlan.EduPlanPdfId = fileModel.Id;
                _context.EduPlans.Add(eduPlan);
                await _context.SaveChangesAsync();

                if (EduVidDeyatIds != null)
                {
                    var eduPlanEduVidDeyats = new List <EduPlanEduVidDeyat>();
                    foreach (var EduVidDeyatId in EduVidDeyatIds)
                    {
                        EduPlanEduVidDeyat eduPlanEduVidDeyat = new EduPlanEduVidDeyat();
                        eduPlanEduVidDeyat.EduPlanId     = eduPlan.EduPlanId;
                        eduPlanEduVidDeyat.EduVidDeyatId = EduVidDeyatId;
                        eduPlanEduVidDeyats.Add(eduPlanEduVidDeyat);
                    }
                    await _context.EduPlanEduVidDeyats.AddRangeAsync(eduPlanEduVidDeyats);

                    await _context.SaveChangesAsync();
                }

                if (EduYearBeginningTrainingIds != null)
                {
                    var eduPlanEduYearBeginningTrainings = new List <EduPlanEduYearBeginningTraining>();
                    foreach (var EduYearBeginningTrainingId in EduYearBeginningTrainingIds)
                    {
                        EduPlanEduYearBeginningTraining eduPlanEduYearBeginningTraining = new EduPlanEduYearBeginningTraining();
                        eduPlanEduYearBeginningTraining.EduPlanId = eduPlan.EduPlanId;
                        eduPlanEduYearBeginningTraining.EduYearBeginningTrainingId = EduYearBeginningTrainingId;
                        eduPlanEduYearBeginningTrainings.Add(eduPlanEduYearBeginningTraining);
                    }
                    await _context.EduPlanEduYearBeginningTraining.AddRangeAsync(eduPlanEduYearBeginningTrainings);

                    await _context.SaveChangesAsync();
                }

                if (EduPlanEduYearIds != null)
                {
                    var eduPlanEduYears = new List <EduPlanEduYear>();
                    foreach (var EduPlanEduYearId in EduPlanEduYearIds)
                    {
                        EduPlanEduYear eduPlanEduYear = new EduPlanEduYear();
                        eduPlanEduYear.EduPlanId = eduPlan.EduPlanId;
                        eduPlanEduYear.EduYearId = EduPlanEduYearId;
                        eduPlanEduYears.Add(eduPlanEduYear);
                    }
                    await _context.EduPlanEduYears.AddRangeAsync(eduPlanEduYears);

                    await _context.SaveChangesAsync();
                }


                return(RedirectToAction(nameof(Index)));
            }
            ViewData["EduFormId"]        = new SelectList(_context.EduForms, "EduFormId", "EduFormName", eduPlan.EduFormId);
            ViewData["EduProfileId"]     = new SelectList(_context.EduProfiles.Include(p => p.EduNapravl.EduUgs.EduLevel), "EduProfileId", "GetEduProfileFullName", eduPlan.EduProfileId);
            ViewData["EduProgramPodgId"] = new SelectList(_context.EduProgramPodg, "EduProgramPodgId", "EduProgramPodgName", eduPlan.EduProgramPodgId);
            ViewData["EduSrokId"]        = new SelectList(_context.EduSrok, "EduSrokId", "EduSrokName", eduPlan.EduSrokId);
            ViewData["StructKafId"]      = new SelectList(_context.StructKafs.Include(k => k.StructSubvision), "StructKafId", "StructSubvision.StructSubvisionName", eduPlan.StructKafId);

            List <EduVidDeyat> eduVidDeyats = _context.EduVidDeyat.ToList();

            ViewData["EduVidDeyats"] = eduVidDeyats;

            List <EduYearBeginningTraining> eduYearBeginningTrainings = _context.EduYearBeginningTrainings.ToList();

            ViewData["EduYearBeginningTrainings"] = eduYearBeginningTrainings;

            List <EduYear> eduYears = _context.EduYears.ToList();

            ViewData["EduYears"] = eduYears;

            return(View(eduPlan));
        }