private void delButton_Click(object sender, RoutedEventArgs e) { if (answerID != 0) { db = new CoursesContext(); CoursesContext db1 = new CoursesContext(); if (db1.correctAnswer.Where(p => p.answer == answerID).Any()) { correctAnswer correctAnswers = new correctAnswer { answer = answerID }; db1.correctAnswer.Attach(correctAnswers); db1.correctAnswer.Remove(correctAnswers); } answer answers = new answer { answerId = answerID }; db.answer.Attach(answers); db.answer.Remove(answers); db.SaveChanges(); answerText.Clear(); GetAnswer(); } }
public CreateUserValidator(CoursesContext context) { _context = context; RuleFor(x => x.FirstName) .NotEmpty() .WithMessage("First name is required parameter."); RuleFor(x => x.LastName) .NotEmpty() .WithMessage("Last name is required parameter."); RuleFor(x => x.Username) .NotEmpty() .WithMessage("Username is required parameter") .Must(username => !context.Users.Any(u => u.Username == username)) .WithMessage(u => $"Course with the name of {u.Username} already exists in database."); RuleFor(x => x.Password) .NotEmpty() .WithMessage("Password is required") .MinimumLength(6); RuleFor(x => x.Email) .NotEmpty() .WithMessage("Email is required parameter") .EmailAddress() .Must(email => !context.Users.Any(u => u.Email == email)) .WithMessage(u => $"User with the email {u.Email} already exists in database."); }
public AddQuestion(int questionID) { InitializeComponent(); this.questionID = questionID; db = new CoursesContext(); GetAnswer(); }
public AddSubmodule(int moduleID, string stub) { InitializeComponent(); this.moduleID = moduleID; db = new CoursesContext(); addEditButton.Content = "Добавить"; }
public CoursesController(IMapper mapper, IApplicationActor actor, UseCaseExecutor executor) { _context = new CoursesContext(); _mapper = mapper; this.actor = actor; this.executor = executor; }
private void btRegistration_Click(object sender, RoutedEventArgs e) { if (tbRegLogin.Text != "" && tbRegPassword.Password != "" && tbSurname.Text != "" && tbFirstname.Text != "" && tbDob.DisplayDate != null && tbSex.SelectedItem != null) { db = new CoursesContext(); if (db.users.Where(p => p.userLogin == tbRegLogin.Text).Any()) { tbUnikUser.Visibility = Visibility.Visible; } else { users registration = new users { userLogin = tbRegLogin.Text, userPassword = PBKDF2HashHelper.CreatePasswordHash(tbRegPassword.Password, 15000), surname = tbSurname.Text, firstname = tbFirstname.Text, dob = tbDob.DisplayDate, sex = tbSex.Text }; db.users.Add(registration); db.SaveChanges(); dialogDone.IsOpen = true; } } else { tbNotNull.Visibility = Visibility.Visible; } }
public RegisterUser(CoursesContext context, CreateUserValidator validator, IEmailSender sender, IMapper mapper) { this.context = context; this.validator = validator; this.sender = sender; this.mapper = mapper; }
public CreateCourseValidator(CoursesContext context) { this.context = context; RuleFor(x => x.Name) .NotEmpty() .WithMessage("Name is required parameter.") .Must(name => !context.Courses.Any(c => c.Name == name)) .WithMessage(c => $"Course with the name of {c.Name} already exists in database."); RuleFor(x => x.Description) .NotEmpty() .WithMessage("Description is required"); RuleFor(x => x.VideoLink) .NotEmpty() .WithMessage("Video link is required"); /* RuleFor(x => x.Image) * .NotEmpty() * .WithMessage("Image is required");*/ RuleFor(x => x.Duration) .NotEmpty() .WithMessage("Duration is required"); RuleFor(x => x.CategoryId) .NotEmpty() .WithMessage("Course must have a category") .Must(CategoryExists) .WithMessage("Categorie doesn't exists"); RuleFor(x => x.TeacherId) .NotEmpty() .WithMessage("Course must have a teacher") .Must(TeacherExists) .WithMessage("Teacher doesn't exists"); }
public MainPage() { InitializeComponent(); db = new CoursesContext(); moduleID = db.module.Select(p => p.moduleId).FirstOrDefault(); StartProgramm(moduleID); }
public SubscribeCommand(CoursesContext context, SubscribeValidator validator, IMapper mapper, IApplicationActor actor) { this.context = context; this.validator = validator; _mapper = mapper; _actor = actor; }
private void buttonAddCourse_Click(object sender, EventArgs e) { if (nameTB.Text == String.Empty || surnameTB.Text == String.Empty || sexLB.SelectedIndex == -1) { MessageBox.Show(this, "Incorrect data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var lecturerToAdd = new Lecturer { Name = nameTB.Text, Surname = surnameTB.Text, Sex = sexLB.SelectedItem.ToString(), Birthday = birthdayPicker.Value, Degree = Convert.ToInt32(degreeNumeric.Value) }; try { using (CoursesContext context = new CoursesContext()) { context.Lecturers.Add(lecturerToAdd); context.SaveChanges(); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
static void Main(string[] args) { Console.WriteLine("Hello Entity Framework World!"); var optionsBuilder = new DbContextOptionsBuilder(); var config = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); optionsBuilder.UseMySql(config.GetConnectionString("DefaultConnection")); var db = new CoursesContext(optionsBuilder.Options); var teacher = new Teacher() { Name = "Aarón" }; var course = new Course() { Name = "NET Amaris", Teacher = teacher }; db.Courses.Add(course); db.SaveChanges(); }
public AddModule(int moduleID) { InitializeComponent(); this.moduleID = moduleID; db = new CoursesContext(); addEditButton.Content = "Изменить"; GetModule(); }
public CartController(IMailService mailService) { this.mailService = mailService; db = new CoursesContext(); sessionManager = new SessionManager(); cartManager = new CartManager(sessionManager, db); }
public UpdateCategoryValidator(CoursesContext context) { this.context = context; RuleFor(x => x.Name) .NotEmpty() .WithMessage("Name is required parameter.") .Must((dto, name) => !context.Categories.Any(p => p.Name == name && p.Id != dto.Id)) .WithMessage(p => $"Category with the name of {p.Name} already exists in database."); }
public CreateCategoryValidator(CoursesContext context) { this.context = context; RuleFor(x => x.Name) .NotEmpty() .WithMessage("Name is required parameter.") .Must(name => !context.Categories.Any(c => c.Name == name)) .WithMessage(c => $"Category with the name of {c.Name} already exists in database."); }
public Handler( CoursesContext context, UserManager <User> userManager, IJwtGenerator jwtGenerator, IPasswordHasher <User> passwordHasher) { _context = context; _userManager = userManager; _jwtGenerator = jwtGenerator; _passwordHasher = passwordHasher; }
private void OnStartup(object sender, StartupEventArgs e) { List <Subject> listOfSubjects; using (CoursesContext db = new CoursesContext()) { listOfSubjects = db.Subjects.ToList(); } MainWindow view = new MainWindow(); view.Show(); }
/// <summary> /// Initializes form /// </summary> public AddOrgForm() { InitializeComponent(); context = new CoursesContext(); coursesLB.Items.Clear(); foreach (var course in context.Courses.ToList()) { coursesLB.Items.Add(course.CourseName); } }
/// <summary> /// Database form constructor /// </summary> public FormDB() { context = new CoursesContext(); InitializeComponent(); organisations = dataGridViewOrganisation; lecturers = dataGridViewLecturers; courses = dataGridViewCourses; AttachCourses(); AttachLecturers(); AttachOrganisations(); }
public SubscribeValidator(CoursesContext context, IApplicationActor actor) { this.context = context; _actor = actor; RuleFor(x => x.CourseId) .NotEmpty() .WithMessage("CourseId is reqired") .Must(CourseExists) .WithMessage("Cours doesn't exists") .Must((CourseId) => !context.UserCourse.Any(dto => dto.CourseId == CourseId && dto.UserId == _actor.Id)) .WithMessage(dto => $"User already subscribed to a cours with Id {dto.CourseId} ."); }
public CreateLectureValidator(CoursesContext context) { this.context = context; RuleFor(x => x.Title) .NotEmpty() .WithMessage("Title is required parameter.") .Must(title => !context.Lectures.Any(c => c.Title == title)) .WithMessage(c => $"Lecture with the name of {c.Title} already exists in database."); RuleFor(x => x.CoursId) .NotEmpty() .WithMessage("Lecture must belong to a course") .Must(CourseExists) .WithMessage("Cours doesn't exists"); }
public CreateTeacherValidator(CoursesContext context) { this.context = context; RuleFor(x => x.FirstName) .NotEmpty() .WithMessage("First name is required parameter."); //.Must(firsName => !context.Teachers.Any(c => c.FirstName == firsName)) //.WithMessage(c => $"Teacher with the name of {c.FirstName} already exists in database."); RuleFor(x => x.LastName) .NotEmpty() .WithMessage("Last name is required parameter."); }
/// <summary> /// Initializes form and its elements /// </summary> public AddCourseForm() { InitializeComponent(); context = new CoursesContext(); foreach (var lecturer in context.Lecturers.ToList()) { _ = lecturersLB.Items.Add(lecturer.Name); } foreach (var organisation in context.Organisations.ToList()) { _ = organisationsLB.Items.Add(organisation.CourseName); } }
private void contextQuestion_Click(object sender, RoutedEventArgs e) { if (moduleID != 0) { switch ((sender as MenuItem).Name) { case "deleteQuestion": if (questionID != 0) { db = new CoursesContext(); question questions = new question { questionId = questionID }; db.question.Attach(questions); db.question.Remove(questions); db.SaveChanges(); StartProgramm(db.module.Select(p => p.moduleId).FirstOrDefault()); } break; case "editQuestion": if (questionID != 0) { addEditButton.Content = "Изменить"; questionText.Text = db.question.Where(p => p.questionId == questionID).Select(p => p.questionText).FirstOrDefault(); dialogQuestion.IsOpen = true; } break; case "addQuestion": addEditButton.Content = "Добавить"; dialogQuestion.IsOpen = true; break; case "editAnswer": if (questionID != 0) { main.Children.Clear(); main.Children.Add(new AddQuestion(questionID)); } break; default: break; } } }
private void buttonLogIn_Click(object sender, EventArgs e) { using (var ctx = new CoursesContext()) { if (ctx.Users.Any(x => x.Username.ToUpper() == textBoxUsername.Text.ToUpper() && x.Password == textBoxPassword.Text)) { FormDB formDB = new FormDB(); this.Hide(); formDB.ShowDialog(); this.Close(); } else { MessageBox.Show(this, $"Wrong username or password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public UpdateUserValidator(CoursesContext context) { this.context = context; RuleFor(x => x.Username) .NotEmpty() .WithMessage("Username is required parameter.") .Must((dto, username) => !context.Users.Any(u => u.Username == username && u.Id != dto.Id)) .WithMessage(u => $"User with the username of {u.Username} already exists in database."); RuleFor(x => x.FirstName) .NotEmpty() .WithMessage("First name is required"); RuleFor(x => x.LastName) .NotEmpty() .WithMessage("Last name is required"); RuleFor(x => x.Password) .NotEmpty() .WithMessage("Password is required"); }
private async void btLogin_Click(object sender, RoutedEventArgs e) { if (tbLogin.Text != "" && tbPassword.Password != "") { string username = tbLogin.Text; string password = tbPassword.Password; using (CoursesContext context = new CoursesContext()) { var user = await(context.users.FirstOrDefaultAsync(u => u.userLogin == username)); var userId = await(context.users.Where(u => u.userLogin == username).Select(u => u.userId).ToArrayAsync()); if (user != null) { if (PBKDF2HashHelper.VerifyPassword(tbPassword.Password, user.userPassword)) { tbLoginMain.Text = username; tbNameMain.Text = $"{context.users.Where(p => p.userLogin == username).Select(p => p.firstname).FirstOrDefault()} {context.users.Where(p => p.userLogin == username).Select(p => p.surname).FirstOrDefault()}"; if (context.users.Where(p => p.userLogin == username).Select(p => p.userPhoto).FirstOrDefault() != null) { profileIcon.ImageSource = ConvertToImage.ToImage(context.users.Where(p => p.userLogin == username).Select(p => p.userPhoto).FirstOrDefault()); noPhoto.Visibility = Visibility.Collapsed; } dialogAuth.IsOpen = false; back.Visibility = Visibility.Collapsed; userIdToTest = userId[0]; } else { tbError.Visibility = Visibility.Visible; } } else { tbNot.Visibility = Visibility.Visible; } } } else { tbNotNullLogin.Visibility = Visibility.Visible; } }
private void buttonRegisterUser_Click(object sender, EventArgs e) { string username = textBoxRegUsername.Text; string password = textBoxRegPW.Text; string confirmation = textBoxRegPWConfirm.Text; if (username == String.Empty || password == String.Empty || confirmation == String.Empty) { MessageBox.Show(this, "Fields should not be emplty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (password != confirmation) { MessageBox.Show("Passwords do not match"); return; } User user = new User { Password = password, Username = username, UserType = 1 }; using (var ctx = new CoursesContext()) { if (ctx.Users.Any(x => x.Username.ToUpper() == username.ToUpper())) { MessageBox.Show("Username already exists"); return; } ctx.Users.Add(user); ctx.SaveChanges(); } MessageBox.Show("Registered successfully"); currentPanel.Visible = false; currentPanel = panelLogIn; currentPanel.Visible = true; }
private void contextSubmodule_Click(object sender, RoutedEventArgs e) { if (moduleID != 0) { switch ((sender as MenuItem).Name) { case "deleteSubmodule": if (submoduleID != 0) { db = new CoursesContext(); submodule submodules = new submodule { submoduleId = submoduleID }; db.submodule.Attach(submodules); db.submodule.Remove(submodules); db.SaveChanges(); StartProgramm(db.module.Select(p => p.moduleId).FirstOrDefault()); } break; case "editSubmodule": if (submoduleID != 0) { main.Children.Clear(); main.Children.Add(new AddSubmodule(submoduleID)); } break; case "addSubmodule": main.Children.Clear(); main.Children.Add(new AddSubmodule(moduleID, "")); break; default: break; } } }