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;
}
}
}
