// Subject specialities list. public async Task <ActionResult> SubjectSpecialities(int?id) { // Check id. if (!int.TryParse(id.ToString(), out int intId)) { return(RedirectToAction("Index")); } // Get SubjectDTO. SubjectDTO subjectDTO = await SubjectService.GetAsync(intId); if (subjectDTO == null) { return(RedirectToAction("Index")); } // Set ViewBag properties. ViewBag.ParentId = intId; ViewBag.SubjectName = subjectDTO.SubjectName; // AutoMapper Setup. var config = new MapperConfiguration(cfg => { cfg.CreateMap <SpecialityDTO, SpecialityViewModel>() .ForMember("Id", opt => opt.MapFrom(obj => obj.SpecialityId)) .ForMember("Name", opt => opt.MapFrom(obj => obj.SpecialityName)); }); IMapper iMapper = config.CreateMapper(); List <SpecialityDTO> source = SpecialityService.Find(dto => dto.SubjectId == intId).OrderBy(o => o.SpecialityName).OrderBy(o => o.IsApproved).ToList(); IEnumerable <SpecialityViewModel> specialityOrderedList = iMapper.Map <IEnumerable <SpecialityDTO>, IEnumerable <SpecialityViewModel> >(source); return(View(specialityOrderedList)); }
static int SpecialScript0() { var teacher = TeacherService.Read(new Teacher() { Name = "Random Teacher", PassportData = 555190 }, 1, 0).First(); var speciality = SpecialityService.Read(new Speciality() { Name = "Random Speciality" }, 1, 0).First(); DateTime startTime = DateTime.Now; Timetable model = new Timetable() { TeacherId = teacher.Id, SpecialityId = speciality.Id }; var models = TimetableService.Read(model); foreach (var timetable in models) { Console.WriteLine("{0}: {1} {2} {3} {4}", timetable.Id, timetable.ExamDate.Value.ToString("dd.MM.yyyy"), timetable.Lesson, timetable.TeacherId, timetable.SpecialityId); } DateTime finishTime = DateTime.Now; return((int)(finishTime - startTime).TotalMilliseconds); }
// Delete a speciality. public async Task <ActionResult> DeleteSpeciality(int?id) { // Check id. if (!int.TryParse(id.ToString(), out int intId)) { return(RedirectToAction("Index")); } // Get SpecialityDTO object. SpecialityDTO specialityDTO = await SpecialityService.GetAsync(intId); if (specialityDTO == null) { return(RedirectToAction("Index")); } ViewBag.SubjectName = specialityDTO.Subject.SubjectName; ViewBag.ParentId = specialityDTO.SubjectId; // AutoMapper Setup. var config = new MapperConfiguration(cfg => { cfg.CreateMap <SpecialityDTO, SpecialityViewModel>() .ForMember("Id", opt => opt.MapFrom(obj => obj.SpecialityId)) .ForMember("Name", opt => opt.MapFrom(obj => obj.SpecialityName)); }); IMapper iMapper = config.CreateMapper(); SpecialityViewModel speciality = iMapper.Map <SpecialityDTO, SpecialityViewModel>(specialityDTO); return(PartialView("~/Views/Admin/Speciality/DeleteSpeciality.cshtml", speciality)); }
public async Task <ActionResult> CreateSpeciality(SpecialityViewModel speciality) { string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (currentUserId == null) { return(new HttpUnauthorizedResult()); } ViewBag.SubjectName = (await SubjectService.GetAsync(speciality.SubjectId)).SubjectName; ViewBag.ParentId = speciality.SubjectId; ViewBag.Action = "SubjectSpecialities"; if (ModelState.IsValid) { SpecialityDTO specialityDTO = new SpecialityDTO { SubjectId = speciality.SubjectId, SpecialityName = speciality.Name, Description = speciality.Description, IsApproved = speciality.IsApproved }; OperationDetails operationDetails = await SpecialityService.CreateAsync(specialityDTO, currentUserId); if (operationDetails.Succedeed) { return(PartialView("Report", operationDetails)); } else { ModelState.AddModelError(operationDetails.Property, operationDetails.Message); return(PartialView("Report", operationDetails)); } } ViewBag.Message = "Non valid"; return(PartialView("~/Views/Admin/Speciality/CreateSpeciality.cshtml", speciality)); }
private void SearchSpeciality(int code, string value) { if (code == 13 && cmBox_search.SelectedIndex == 0 && value != "" && EntitiesIndex == 3) { var specialityService = new SpecialityService(_unit, _unit); var speciality = specialityService.GetSpecialityById(Convert.ToInt32(_tBox_searchValue)); specialityGV.DataSource = new List <Speciality>() { speciality }; } if (code == 13 && cmBox_search.SelectedIndex == 1 && value != "") { var specialityService = new SpecialityService(_unit, _unit); var speciality = specialityService.GetSpecialitiesByName(_tBox_searchValue); specialityGV.DataSource = speciality.ToList(); } if (code == 13 && cmBox_search.SelectedIndex == 2 && value != "") { var specialityService = new SpecialityService(_unit, _unit); var formEducationService = new FormEducationService(_unit, _unit); var formEducation = formEducationService.GetFormEducationByName(_tBox_searchValue); var speciality = specialityService.GetSpecialitiesByFormEducation(formEducation.Id); specialityGV.DataSource = speciality.ToList(); } }
public async Task <ActionResult> DeleteSpeciality(int id) { string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (currentUserId == null) { return(new HttpUnauthorizedResult()); } SpecialityDTO specialityDTO = await SpecialityService.GetAsync(id); ViewBag.SubjectName = specialityDTO.Subject.SubjectName; ViewBag.ParentId = specialityDTO.SubjectId; ViewBag.Action = "SubjectSpecialities"; if (specialityDTO != null) { OperationDetails operationDetails = await SpecialityService.DeleteAsync(id, currentUserId); if (operationDetails.Succedeed) { return(PartialView("Report", operationDetails)); } else { ModelState.AddModelError(operationDetails.Property, operationDetails.Message); return(PartialView("Report", operationDetails)); } } ViewBag.Message = "Non valid"; return(PartialView("~/Views/Admin/Speciality/DeleteSpeciality.cshtml", specialityDTO)); }
private void GetSpecialityFromDb() { var specialityService = new SpecialityService(_unit, _unit); var speciality = specialityService.GetAllSpeciality(); cmBox_speciality.DataSource = speciality.ToList(); }
public async Task <ActionResult> CreateCourse(int?specialityId) { try { // I. Checks. // Check id. if (!int.TryParse(specialityId.ToString(), out int intSpecialityId)) { return(RedirectToAction("Index")); } // Get a SpecialityDTO object. SpecialityDTO speciality = await SpecialityService.GetAsync(intSpecialityId); if (speciality == null) { return(RedirectToAction("Index")); } // II. Set ViewBag properties. ViewBag.ParentId = intSpecialityId; ViewBag.SpecialityName = speciality.SpecialityName; // III. return(PartialView()); } catch (Exception ex) { throw new Exception(ex.Message); } }
static int UpdateScript2() { var teacher = TeacherService.Read(new Teacher() { Name = "Random Teacher", PassportData = 555190 }, 1, 0).First(); var speciality = SpecialityService.Read(new Speciality() { Name = "Random Speciality" }, 1, 0).First(); // Предполагается, что действия до создания модели - это моделирование выбора пользователя var models = TimetableService.Read(new Timetable() { TeacherId = teacher.Id, SpecialityId = speciality.Id }); DateTime startTime = DateTime.Now; foreach (var model in models) { model.ClassroomId = 1; TimetableService.Update(model); } DateTime finishTime = DateTime.Now; return((int)(finishTime - startTime).TotalMilliseconds); }
static int AddScript2() { var teacher = TeacherService.Read(new Teacher() { Name = "Random Teacher", PassportData = 456278 }, 1, 0).First(); var speciality = SpecialityService.Read(new Speciality() { Name = "Random Speciality" }, 1, 0).First(); Timetable[] models = new Timetable[30]; for (int i = 0; i < models.Length; i++) { models[i] = new Timetable() { Lesson = 5, ExamDate = DateTime.Now.AddDays(i), TeacherId = teacher.Id, SpecialityId = speciality.Id, ClassroomId = 5, DisciplineId = 5 }; } DateTime startTime = DateTime.Now; foreach (var model in models) { TimetableService.Create(model); } DateTime finishTime = DateTime.Now; return((int)(finishTime - startTime).TotalMilliseconds); }
private void DeleteSpeciality(object sender, EventArgs e) { var specialityService = new SpecialityService(_unit, _unit); specialityService.RemoveSpeciality((Speciality)specialityGV.CurrentRow.DataBoundItem); _unit.Commit(); _unit = new UnitOfWork(_context); this.SearchSpeciality(13, _tBox_searchValue); }
// Subject specialities list. public async Task <ActionResult> SubjectSpecialities(int?id) { try { // I. Checks. // Get Id for the current user. string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (currentUserId == null) { return(RedirectToAction("Login", "Account")); } // Check id. if (!int.TryParse(id.ToString(), out int intId)) { return(RedirectToAction("Index")); } // Get SubjectDTO. SubjectDTO subjectDTO = await SubjectService.GetAsync(intId); if (subjectDTO == null) { return(RedirectToAction("Index")); } // II. Set ViewBag properties. PLRepository.SetViewBagProperiesForModeratorSubscription(UserService, currentUserId, SubscriptionForModeratorService, out bool?viewBagIsAllowedToSuggest, out bool?viewBagGoToTrialSubscription, out bool?viewBagGoToSubscription); ViewBag.IsAllowedToSuggest = viewBagIsAllowedToSuggest; ViewBag.GoToTrialSubscription = viewBagGoToTrialSubscription; ViewBag.GoToSubscription = viewBagGoToSubscription; ViewBag.ParentId = intId; ViewBag.SubjectName = subjectDTO.SubjectName; // III. AutoMapper Setup. var config = new MapperConfiguration(cfg => { cfg.CreateMap <SpecialityDTO, SpecialityViewModel>() .ForMember("Id", opt => opt.MapFrom(obj => obj.SpecialityId)) .ForMember("Name", opt => opt.MapFrom(obj => obj.SpecialityName)); }); IMapper iMapper = config.CreateMapper(); // IV. Get data for a view. List <SpecialityDTO> source = SpecialityService.Find(dto => dto.SubjectId == intId && dto.IsApproved).OrderBy(o => o.SpecialityName).ToList(); IEnumerable <SpecialityViewModel> specialityOrderedList = iMapper.Map <IEnumerable <SpecialityDTO>, IEnumerable <SpecialityViewModel> >(source); // V. return(View(specialityOrderedList)); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void btn_add_Click(object sender, EventArgs e) { var specialityService = new SpecialityService(_unit, _unit); var speciality = specialityService.CreateSpeciality(NameText, TermNumberText, (FormEducation)comboBox1.SelectedItem); _unit.Commit(); _context.Dispose(); this.Close(); }
public async Task <ActionResult> CreateCourse(CourseViewModel course) { try { // I. Checks. string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (currentUserId == null) { return(new HttpUnauthorizedResult()); } // II. Set ViewBag properties. ViewBag.SpecialityName = (await SpecialityService.GetAsync(course.SpecialityId)).SpecialityName; ViewBag.ParentId = course.SpecialityId; ViewBag.Action = "SpecialityCourses"; // III. Create a new course. if (ModelState.IsValid) { CourseDTO courseDTO = new CourseDTO { UserProfileId = currentUserId, SpecialityId = course.SpecialityId, CourseTitle = course.Name, Description = course.Description, CourseTestQuestionsNumber = course.CourseTestQuestionsNumber, TopicTestQuestionsNumber = course.TopicTestQuestionsNumber, TimeToAnswerOneQuestion = course.TimeToAnswerOneQuestion, AttemptsNumber = course.AttemptsNumber, PassingScore = course.PassingScore, IsApproved = course.IsApproved, IsFree = course.IsFree }; OperationDetails operationDetails = await CourseService.CreateAsync(courseDTO, currentUserId); if (operationDetails.Succedeed) { return(PartialView("Report", operationDetails)); } else { ModelState.AddModelError(operationDetails.Property, operationDetails.Message); return(PartialView("Report", operationDetails)); } } // IV. ViewBag.Message = "Non valid"; return(PartialView(course)); } catch (Exception ex) { throw new Exception(ex.Message); } }
private void GetAllDataFromDb() { var specialityService = new SpecialityService(_unit, _unit); var speciality = specialityService.GetSpecialityById(_entityId); IdText = speciality.Id.ToString(); NameText = speciality.Name; TermNumberText = speciality.TermNumber; this.GetFormEducationFromDb(); comboBox1.Text = speciality.FormEducation.Name; }
public async Task <List <SpecialityInfoDto> > GetAllSpecialitys(string departmentId) { using (IDAL.ISpecialityService specialityService = new SpecialityService()) { return(await specialityService.GetAllAsync().Where(m => m.DepartmentId == departmentId).Select(m => new Dto.SpecialityInfoDto() { SpecialityId = m.SpecialityId, SpecialityName = m.SpecialityName }).ToListAsync()); } }
/// <summary> /// Метод инициализации сервисов данных /// </summary> private void InitializeDataAccessServices() { // Получение строки подключения logger.Info("Получение строки подключения к источнику данных."); string connectionString = ConfigurationManager.ConnectionStrings["EnrolleeContext"].ConnectionString; // Инициализации сервисов данных logger.Info("Инициализация сервисов получения данных."); facultyService = new FacultyService(connectionString); formOfStudyService = new FormOfStudyService(connectionString); specialityService = new SpecialityService(connectionString); }
private void btn_update_Click(object sender, EventArgs e) { var specialityService = new SpecialityService(_unit, _unit); var speciality = specialityService.GetSpecialityById(_entityId); speciality.Name = NameText; speciality.TermNumber = TermNumberText; specialityService.SetFormEducationOfSpeciality((FormEducation)comboBox1.SelectedItem, speciality); specialityService.UpdateSpeciality(speciality); _unit.Commit(); _context.Dispose(); this.Close(); }
static int AddScript1() { Speciality model = new Speciality() { Name = "Random Speciality" }; DateTime startTime = DateTime.Now; SpecialityService.Create(model); DateTime finishTime = DateTime.Now; return((int)(finishTime - startTime).TotalMilliseconds); }
static int ReadScript0() { Speciality model = new Speciality() { Name = "Random Speciality" }; DateTime startTime = DateTime.Now; Speciality mod = SpecialityService.Read(model, 1, 0).First(); DateTime finishTime = DateTime.Now; Console.WriteLine("{0}: {1}", mod.Id, mod.Name); return((int)(finishTime - startTime).TotalMilliseconds); }
/// <summary> /// Метод инициализации сервисов доступа к данным /// </summary> private void InitializeDataAccessServices() { // Получение строки подключения logger.Info($"Получаем строку подключения к источнику данных"); connectionString = ConfigurationManager.ConnectionStrings["EnrolleeContext"].ConnectionString; // Инициализация сервисов получения данных logger.Info($"Инициализация сервисов получения данных"); facultyService = new FacultyService(connectionString); formOfStudyService = new FormOfStudyService(connectionString); specialityService = new SpecialityService(connectionString); priorityOfSpecialityService = new PriorityOfSpecialityService(connectionString); decreeService = new DecreeService(connectionString); enrolleeService = new EnrolleeService(connectionString); viewService = new ViewService(connectionString); }
public async Task <ActionResult> SuggestSpeciality(SpecialityViewModel speciality) { try { // I. Checks. string currentUserId = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (currentUserId == null) { return(new HttpUnauthorizedResult()); } // II. Set ViewBag properties. ViewBag.SubjectName = (await SubjectService.GetAsync(speciality.SubjectId)).SubjectName; ViewBag.ParentId = speciality.SubjectId; ViewBag.Action = "SubjectSpecialities"; // III. Create a new speciality. if (ModelState.IsValid) { SpecialityDTO specialityDTO = new SpecialityDTO { SubjectId = speciality.SubjectId, SpecialityName = speciality.Name, Description = speciality.Description, IsApproved = false }; OperationDetails operationDetails = await SpecialityService.CreateAsync(specialityDTO, currentUserId); if (operationDetails.Succedeed) { return(PartialView("Report", operationDetails)); } else { ModelState.AddModelError(operationDetails.Property, operationDetails.Message); return(PartialView("Report", operationDetails)); } } // IV. ViewBag.Message = "Non valid"; return(PartialView(speciality)); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// Инициализация сервисов доступа данных /// </summary> private void InitializeDataAccessServices() { // Инициализация строки подключения данных logger.Info($"Получение строки подключения к источнику данных"); string connectionString = ConfigurationManager.ConnectionStrings["EnrolleeContext"].ConnectionString; // Инициализация сервисов доступа данных assessmentService = new AssessmentService(connectionString); enrolleeService = new EnrolleeService(connectionString); examSchemaService = new ExamSchemaService(connectionString); disciplineService = new DisciplineService(connectionString); facultyService = new FacultyService(connectionString); formOfStudyService = new FormOfStudyService(connectionString); specialityService = new SpecialityService(connectionString); viewService = new ViewService(connectionString); }
// Create a course. public async Task <ActionResult> CreateCourse(int?specialityId) { // Check id. if (!int.TryParse(specialityId.ToString(), out int intId)) { return(RedirectToAction("Index")); } // Get SpecialityDTO object. SpecialityDTO speciality = await SpecialityService.GetAsync(intId); if (speciality == null) { return(RedirectToAction("Index")); } ViewBag.ParentId = intId; ViewBag.SpecialityName = speciality.SpecialityName; return(PartialView("~/Views/Admin/Course/CreateCourse.cshtml")); }
static int UpdateScript1() { Speciality speciality = SpecialityService.Read(new Speciality() { Name = "Random Speciality" }, 1, 0).First(); Timetable mod = new Timetable() { Id = speciality.Id, Lesson = 6 }; DateTime startTime = DateTime.Now; TimetableService.Update(mod); DateTime finishTime = DateTime.Now; return((int)(finishTime - startTime).TotalMilliseconds); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1. Columns[e.ColumnIndex]. HeaderText. ToLower() == "delete") { if (MessageBox.Show ("Are you sure you want to delete this record?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes) { int specialityId = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value); ISpecialityService specialityService = new SpecialityService(); specialityService.DeleteSpeciality(specialityId); this.specialityTableAdapter.Fill(this.finalAppWebDataSet.speciality); } } }
// Speciality courses list. public async Task <ActionResult> SpecialityCourses(int?id) { // I. Checks. // Check id. if (!int.TryParse(id.ToString(), out int intId)) { return(RedirectToAction("Index")); } // Get SpecialityDTO object. SpecialityDTO specialityDTO = await SpecialityService.GetAsync(intId); if (specialityDTO == null) { return(RedirectToAction("Index")); } // II. Set ViewBag properties and Session[ParentParentIdForAdminController]. ViewBag.ParentId = intId; ViewBag.SpecialityName = specialityDTO.SpecialityName; ViewBag.ParentParentId = specialityDTO.SubjectId; // Set Session[ParentParentIdForAdminController]. Session["ParentParentIdForAdminController"] = intId; // III. Get data for a view. // AutoMapper Setup. var config = new MapperConfiguration(cfg => { cfg.CreateMap <CourseDTO, CourseViewModel>() .ForMember("Id", opt => opt.MapFrom(obj => obj.CourseId)) .ForMember("Name", opt => opt.MapFrom(obj => obj.CourseTitle)); }); IMapper iMapper = config.CreateMapper(); List <CourseDTO> source = CourseService.Find(dto => dto.SpecialityId == intId) .OrderBy(o => o.CourseTitle) .OrderBy(o => o.IsApproved).ToList(); IEnumerable <CourseViewModel> courseOrderedList = iMapper.Map <IEnumerable <CourseDTO>, IEnumerable <CourseViewModel> >(source); return(View(courseOrderedList)); }
private void btnAdd_Click(object sender, EventArgs e) { ISpecialityService specialityService = new SpecialityService(); String description = txtSpeciality.Text.ToString().Trim(); speciality objSpeciality = new speciality(); objSpeciality.description = description; if (description.Length == 0) { MessageBox.Show("Type an speciality"); } else if (specialityService.GetSpecialityByDescription(description) != null) { MessageBox.Show("This speciality is already saved. Try another"); } else { specialityService.CreateSpeciality(objSpeciality); MessageBox.Show("Speciality saved"); } this.specialityTableAdapter.Fill(this.finalAppWebDataSet.speciality); }
static int ReadScript1() { Speciality speciality = SpecialityService.Read(new Speciality() { Name = "Random Speciality" }, 1, 0).First(); // Предполагается, что действия до создания модели - это моделирование выбора пользователя Timetable time = new Timetable() { SpecialityId = speciality.Id }; DateTime startTime = DateTime.Now; Timetable model = TimetableService.Read(time, 1, 0).First(); var count = DB.Timetables.Count(t => model.SpecialityId == speciality.Id); DateTime finishTime = DateTime.Now; Console.WriteLine("{0}: {1}", model.SpecialityId, count); return((int)(finishTime - startTime).TotalMilliseconds); }
private void AdditionalForSpeciality(object sender, EventArgs e) { if (specialityGV.CurrentRow != null) { var speciality = (Speciality)specialityGV.CurrentRow.DataBoundItem; var form = new Form4(1, speciality.Id, 3, this); form.ShowDialog(); if (DeccisionIndex == 0) { var form1 = new Form11(speciality); form1.ShowDialog(); } if (DeccisionIndex == 1) { this.groupAGV.Visible = true; this.specialityAGV.Visible = false; this.groupAGV.DataSource = speciality.Groups.ToList(); } } else { var form = new Form4(2, 0, 3, this); form.ShowDialog(); var specialityService = new SpecialityService(_unit, _unit); if (DeccisionIndex == 0) { this.specialityAGV.Visible = true; var allSpeciality = specialityService.GetAllSpeciality(); specialityAGV.DataSource = allSpeciality.ToList(); } if (DeccisionIndex == 1) { MessageBox.Show(@"dsgsdgs"); } } DeccisionIndex = -1; }