public async Task <IActionResult> LogIn(UserSelect2 user) { if (ModelState.IsValid) { var result = await signInManager.PasswordSignInAsync(user.UserName, user.Password, true, false); var isInRole = await userManager.IsInRoleAsync( await userManager.FindByNameAsync( user.UserName), "ActiveUser"); if (result.Succeeded && isInRole) { return(RedirectToAction("Index", "Home")); } if (result.Succeeded && !isInRole) { ModelState.AddModelError("", "Jesteś zablokowany!"); } else { ModelState.AddModelError("", "Nie można się zalogować!"); } } AccountLogIn accountLogIn = new AccountLogIn() { User = user }; return(View(accountLogIn)); }
public bool InitialAccount(AccountLogIn account) { try { OleDbConnection connect = new OleDbConnection(); connect.ConnectionString = conn; connect.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = connect; cmd.CommandText = "Insert INTO Account VALUES (?,?)"; OleDbParameter para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = account.ID; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = account.Password; cmd.ExecuteNonQuery(); connect.Close(); return(true); } catch { return(false); } }
public bool LogIn(string ID, string Password) { try { DataSetRepo dataSet = new DataSetRepo(); List_Account = dataSet.GetList_Of_Account(); InitialLogIn(); foreach (var account in List_Account) { if (ID == account.ID && Password == account.Password) { if (account.ID.Contains("giaovu")) { isStudent = false; } else { isStudent = true; } login = account; return(true); } } return(false); } catch { return(false); } }
public void LoadStudents(string pathFile) { if (List_Of_Students == null) { List_Of_Students = new List <Students>(); } if (List_Of_Account == null) { List_Of_Account = new List <AccountLogIn>(); } try { StreamReader reader = new StreamReader(pathFile); string ClassID = reader.ReadLine(); string[] splitClass = ClassID.Split(','); reader.ReadLine(); string line = ""; while ((line = reader.ReadLine()) != null) { string[] split = line.Split(','); var newStudent = new Students(); newStudent.StudentID = split[1]; newStudent.FullName = split[2]; newStudent.Gender = split[3]; newStudent.ID = split[4]; newStudent.classID = new Classes(); newStudent.classID.ClassID = splitClass[0]; var newAccount = new AccountLogIn(); newAccount.ID = newStudent.StudentID; newAccount.Password = newStudent.ID; List_Of_Students.Add(newStudent); List_Of_Account.Add(newAccount); InitialAccount(newAccount); } reader.Close(); //Import To DATABSE InitialStudentsToDatabase(splitClass[0]); return; } catch { return; } }
public void InitialLogIn() { AccountLogIn account = new AccountLogIn(); account.ID = "giaovu"; account.Password = "******"; if (List_Account == null) { List_Account = new List <AccountLogIn>(); } List_Account.Add(account); }
public bool changePassword(AccountLogIn account) { if (List_Of_Account != null) { foreach (var acc in List_Of_Account) { if (acc.ID == account.ID) { acc.Password = account.Password; try { OleDbConnection connect = new OleDbConnection(); connect.ConnectionString = conn; connect.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = connect; cmd.CommandText = "Update Account SET Pass = ? WHERE ID = ?"; OleDbParameter para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = account.Password; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = account.ID; cmd.ExecuteNonQuery(); connect.Close(); return(true); } catch { } } } return(false); } return(false); }
public bool LoadData() { try { List_Of_Classes = new List <Classes>(); List_Of_Students = new List <Students>(); List_Of_Courses = new List <Courses>(); List_Of_ClassCourses = new List <ClassCourse>(); List_Of_GradeClassCourses = new List <GradeClassCourse>(); List_Of_Account = new List <AccountLogIn>(); OleDbConnection connect = new OleDbConnection(); connect.ConnectionString = conn; connect.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = connect; cmd.CommandText = "SELECT * FROM Classes"; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var Class = new Classes(); Class.ClassID = reader.GetString(0); List_Of_Classes.Add(Class); } reader.Close(); cmd.CommandText = "SELECT * FROM Students"; reader = cmd.ExecuteReader(); while (reader.Read()) { var student = new Students(); student.StudentID = reader.GetString(0); student.FullName = reader.GetString(1); student.Gender = reader.GetString(2); student.ID = reader.GetString(3); student.classID = new Classes(); student.classID.ClassID = reader.GetString(4); List_Of_Students.Add(student); } reader.Close(); cmd.CommandText = "SELECT * FROM Courses"; reader = cmd.ExecuteReader(); while (reader.Read()) { var course = new Courses(); course.CourseID = reader.GetString(0); course.CourseName = reader.GetString(1); course.Room = reader.GetString(2); course.classID = new Classes(); course.classID.ClassID = reader.GetString(3); List_Of_Courses.Add(course); } reader.Close(); cmd.CommandText = "SELECT distinct CourseID FROM ClassCourses"; reader = cmd.ExecuteReader(); while (reader.Read()) { var classCourse = new ClassCourse(); string temp = reader.GetString(0); foreach (var course in List_Of_Courses) { if (course.CourseID == temp) { classCourse.course = course; classCourse.students = new List <Students>(); OleDbCommand cmd2 = new OleDbCommand(); cmd2.Connection = connect; cmd2.CommandText = $"SELECT StudentID FROM ClassCourses WHERE CourseID = '{course.CourseID}' "; OleDbDataReader rd = cmd2.ExecuteReader(); while (rd.Read()) { string StudentID = rd.GetString(0); foreach (var stu in List_Of_Students) { if (stu.StudentID == StudentID) { classCourse.students.Add(stu); } } } rd.Close(); List_Of_ClassCourses.Add(classCourse); } } } reader.Close(); cmd.CommandText = "SELECT distinct CourseID FROM GradeCourses"; reader = cmd.ExecuteReader(); while (reader.Read()) { var gradeClassCourse = new GradeClassCourse(); gradeClassCourse.classCourse = new ClassCourse(); string temp = reader.GetString(0); foreach (var course in List_Of_Courses) { if (course.CourseID == temp) { gradeClassCourse.classCourse.course = course; gradeClassCourse.listGrade = new List <Grade>(); OleDbCommand cmd2 = new OleDbCommand(); cmd2.Connection = connect; cmd2.CommandText = $"SELECT * FROM GradeCourses WHERE CourseID = '{course.CourseID}' "; OleDbDataReader rd = cmd2.ExecuteReader(); while (rd.Read()) { Grade newGrade = new Grade(); newGrade.StudentID = rd.GetString(1); newGrade.GradeGK = rd.GetDouble(2); newGrade.GradeCK = rd.GetDouble(3); newGrade.GradeE = rd.GetDouble(4); newGrade.TotalGrade = rd.GetDouble(5); gradeClassCourse.listGrade.Add(newGrade); } rd.Close(); List_Of_GradeClassCourses.Add(gradeClassCourse); } } } reader.Close(); cmd.CommandText = "SELECT * FROM Account"; reader = cmd.ExecuteReader(); while (reader.Read()) { var account = new AccountLogIn(); account.ID = reader.GetString(0); account.Password = reader.GetString(1); List_Of_Account.Add(account); } reader.Close(); connect.Close(); return(true); } catch { return(false); } }
public bool AddStudent(Students newStudent) { if (List_Of_Students != null) { List_Of_Students.Add(newStudent); var newAccount = new AccountLogIn(); newAccount.ID = newStudent.StudentID; newAccount.Password = newStudent.ID; if (List_Of_Account == null) { List_Of_Account = new List <AccountLogIn>(); } List_Of_Account.Add(newAccount); InitialAccount(newAccount); try { OleDbConnection connect = new OleDbConnection(); connect.ConnectionString = conn; connect.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = connect; cmd.CommandText = "INSERT INTO Students VALUES (?,?,?,?,?)"; OleDbParameter para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = newStudent.StudentID; para = cmd.Parameters.Add("", OleDbType.LongVarChar); para.Value = newStudent.FullName; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = newStudent.Gender; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = newStudent.ID; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = newStudent.classID.ClassID; cmd.ExecuteNonQuery(); if (List_Of_ClassCourses != null) { foreach (var classCourse in List_Of_ClassCourses) { if (classCourse.course.classID.ClassID == newStudent.classID.ClassID) { classCourse.students.Add(newStudent); } } foreach (var classCourse in List_Of_ClassCourses) { if (classCourse.course.classID.ClassID == newStudent.classID.ClassID) { cmd.CommandText = "INSERT INTO ClassCourses VALUES (?,?)"; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = classCourse.course.CourseID; para = cmd.Parameters.Add("", OleDbType.VarChar); para.Value = newStudent.StudentID; cmd.ExecuteNonQuery(); } } } connect.Close(); return(true); } catch { return(false); } } return(false); }