public ActionResult oneTimePin(OneTimePin model) { if (ModelState.IsValid) { var newStudent = (Registered_Person)Session["newStudent"]; var personRole = new Person_Role(); personRole.Person_ID = newStudent.Person_ID; personRole.Role_ID = (from r in db.Roles where r.Role_Name == "Student" select r.Role_ID).FirstOrDefault(); db.Registered_Person.Add(newStudent); db.Person_Role.Add(personRole); db.SaveChanges(); //record action global.addAudit("Students", "Students: Registration", "Create", newStudent.Person_ID); Session.Remove("newStudent"); Session.Remove("OTP"); TempData["Message"] = "Succesfully created an account!"; TempData["classStyle"] = "success"; return(RedirectToAction("Login", "Account")); } else { return(View()); } }
public ActionResult Create(MemberCreateVM viewModel) { //Role id has been hardcoded to represent student (4) TempData["Show"] = false; if (db.Registered_Person.Any(x => x.Person_ID == viewModel.person_id)) { ModelState.AddModelError("person_id", "Username is already registered"); } if (!db.Registered_Person.Any(x => x.Person_ID.StartsWith("p"))) { ModelState.AddModelError("person_id", "Username must start with a 'p' and follow with 8 digits"); } if (ModelState.IsValid) { string password = Membership.GeneratePassword(5, 1); var hashed = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "MD5"); var mem = new Registered_Person(); mem.Person_ID = viewModel.person_id; mem.Person_Name = viewModel.person_name; mem.Person_Surname = viewModel.person_surname; mem.Person_Type = "Student"; mem.Person_Password = hashed; mem.Person_Registration_DateTime = DateTime.Now; mem.Person_Email = viewModel.person_email; db.Registered_Person.Add(mem); var pRole = new Person_Role(); pRole.Person_ID = viewModel.person_id; pRole.Role_ID = 4; db.Person_Role.Add(pRole); //Email start MailMessage message = new MailMessage(); SmtpClient client = new SmtpClient(); client.Host = "smtp.gmail.com"; client.Port = 587; message.From = new MailAddress("*****@*****.**"); message.To.Add(viewModel.person_email); message.Subject = "Member Registerstration"; message.Body = "Hi, " + viewModel.person_id + " you have been registered to UP Library Assistant by an Admin, use your UP username to login, your password is: " + password; message.IsBodyHtml = true; client.EnableSsl = true; client.UseDefaultCredentials = true; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "tester123#"); client.Send(message); //Email end db.SaveChanges(); TempData["Msg"] = "New member created successfully."; TempData["Show"] = true; TempData["color"] = "alert-success"; return(RedirectToAction("Index")); } TempData["Show"] = true; TempData["color"] = "alert-warning"; TempData["Msg"] = "Something went wrong."; return(View(viewModel)); }
public ActionResult Edit(string id, EmployeeEditModel viewModel) { var topicchecks = (List <TopicCheck>)Session["TopicChecked"]; //TODO: validate to make sure at least one role is selected if (ModelState.IsValid) { Registered_Person rp = db.Registered_Person.Find(id); rp.Person_ID = id; rp.Person_Name = viewModel.person_name; rp.Person_Surname = viewModel.person_surname; rp.Person_Email = viewModel.person_email; rp.Person_Type = "Employee"; db.Entry(rp).State = EntityState.Modified; var roleRemove = db.Person_Role.Where(x => x.Person_ID == id); foreach (var item in roleRemove) { db.Person_Role.Remove(item); } foreach (var item in viewModel.emprolecheckeditlist) { if (item.role_ind == true) { var pRole = new Person_Role(); pRole.Person_ID = id; pRole.Role_ID = item.role_id; db.Person_Role.Add(pRole); } } var trainerRemove = db.Trainer_Topic.Where(x => x.Person_ID == id); foreach (var item in trainerRemove) { db.Trainer_Topic.Remove(item); } if (viewModel.emprolecheckeditlist.Where(x => x.role_id == 7).Where(y => y.role_ind == true).Any()) { foreach (var item in topicchecks) { if (item.topic_ind == true) { var tTopic = new Trainer_Topic(); tTopic.Person_ID = id; tTopic.Topic_Seq = item.topic_seq; db.Trainer_Topic.Add(tTopic); } } } db.SaveChanges(); } TempData["Check2"] = false; ViewBag.Person_Type = new SelectList(db.Person_Type, "Person_Type1", "Person_Type1", 2); return(RedirectToAction("Index")); }
public void person_roleTEST() { Person_Role person_role = person_roleRepo.getById(new Person_Role { Person_Role_ID = 1 } ); Assert.AreNotEqual(null, person_role, ""); IQueryable <Person_Role> p_roles = person_roleRepo.query(a => a.Person_Role_ID == 1); Assert.AreEqual(1, p_roles.Count()); }
public void Profile_TEST() { Song song = songrepo.getById(new Song { Song_ID = 11111 } ); Assert.AreNotEqual(null, song, ""); Playlist playlist = playlistrepo.getById(new Playlist { Playlist_ID = 4 } ); Assert.AreNotEqual(null, playlist, ""); Party party = partyrepo.getById(new Party { Party_ID = 4 } ); Assert.AreNotEqual(null, party, ""); Role_Permission role_permission = role_permissionrepo.getById(new Role_Permission { Role_Permission_Combo_ID = 4 } ); Assert.AreNotEqual(null, role_permission, ""); Person_Role person_role = personrolerepo.getById(new Person_Role { Person_Role_ID = 4 } ); Assert.AreNotEqual(null, person_role, ""); Person person = personrepo.getById(new Person { Person_ID = 4 } ); Assert.AreNotEqual(null, person, ""); Profile profile = profilerepo.getById(new Profile { Profile_ID = 4 }); IQueryable <Song> songs = songrepo.query(a => a.Song_ID == 11111); Assert.AreEqual(1, songs.Count()); IQueryable <Playlist> playlists = playlistrepo.query(a => a.Playlist_ID == 4); Assert.AreEqual(1, playlists.Count()); IQueryable <Party> parties = partyrepo.query(a => a.Party_ID == 4); Assert.AreEqual(1, parties.Count()); IQueryable <Role_Permission> roles = role_permissionrepo.query(a => a.Role_Permission_Combo_ID == 4); Assert.AreEqual(1, roles.Count()); IQueryable <Person_Role> p_roles = personrolerepo.query(a => a.Person_Role_ID == 4); Assert.AreEqual(1, p_roles.Count()); IQueryable <Person> persons = personrepo.query(a => a.Person_ID == 4); Assert.AreEqual(1, persons.Count()); IQueryable <Profile> profiles = profilerepo.query(a => a.Profile_ID == 4); Assert.AreEqual(1, profiles.Count()); }
public ActionResult Create(EmployeeAddModel viewModel) { TempData["Show"] = false; var topicchecklist = (List <TopicCheck>)Session["Topic_Checked"]; if (db.Registered_Person.Any(x => x.Person_ID == viewModel.person_id)) { ModelState.AddModelError("person_id", "Username is already registered"); } if (!db.Registered_Person.Any(x => x.Person_ID.StartsWith("p"))) { ModelState.AddModelError("person_id", "Username must start with a 'p' and follow with 8 digits"); } if (ModelState.IsValid) { string password = Membership.GeneratePassword(5, 1); var hashed = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "MD5"); var emp = new Registered_Person(); emp.Person_ID = viewModel.person_id; emp.Person_Name = viewModel.person_name; emp.Person_Surname = viewModel.person_surname; emp.Person_Type = "Employee"; emp.Person_Password = hashed; emp.Person_Registration_DateTime = DateTime.Now; emp.Person_Email = viewModel.person_email; db.Registered_Person.Add(emp); foreach (var item in viewModel.role_check) { var prole = new Person_Role(); if (item.role_ind) { prole.Role_ID = item.role_id; prole.Person_ID = emp.Person_ID; db.Person_Role.Add(prole); } } try { foreach (var item in topicchecklist) { var trainertopic = new Trainer_Topic(); if (item.topic_ind) { trainertopic.Person_ID = emp.Person_ID; trainertopic.Topic_Seq = item.topic_seq; db.Trainer_Topic.Add(trainertopic); } } } catch { } //Email start MailMessage message = new MailMessage(); SmtpClient client = new SmtpClient(); client.Host = "smtp.gmail.com"; client.Port = 587; message.From = new MailAddress("*****@*****.**"); message.To.Add(viewModel.person_email); message.Subject = "Employee Registration"; message.Body = "Hi, " + viewModel.person_id + " you have been registered to UP Library Assistant by an Admin, use your UP username to login, your password is: " + password; message.IsBodyHtml = true; client.EnableSsl = true; client.UseDefaultCredentials = true; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "tester123#"); client.Send(message); //Email end db.SaveChanges(); TempData["Msg"] = "New employee created successfully."; TempData["Show"] = true; TempData["color"] = "alert-success"; return(RedirectToAction("Index")); } ViewBag.Check1 = true; ViewBag.Check2 = true; viewModel.role = (db.Roles .Include(i => i.Role_Action.Select(x => x.Action))).ToList(); var rolechecklist = new List <RoleCheck>(); for (int i = 0; i < viewModel.role.Count(); i++) { var roleCheck = new RoleCheck(); roleCheck.role_id = viewModel.role[i].Role_ID; rolechecklist.Add(roleCheck); } viewModel.role_check = rolechecklist; ViewBag.Person_Type = new SelectList(db.Person_Type, "Person_Type1", "Person_Type1", 2); TempData["Msg"] = "Something went wrong."; TempData["Show"] = true; TempData["color"] = "alert-success"; return(View(viewModel)); }