public long CreateNewStudent(StudentViewModel objViewModel) { Student objStudent = new Student(); objStudent.UserId = objViewModel.UserId; objStudent.CourseId = objViewModel.CourseId; objStudent.DepartmentId = objViewModel.DepartmentId; objStudent.ClassId = objViewModel.ClassId; objStudent.SectionId = objViewModel.SectionId; objStudent.RollNo = objViewModel.RollNo; objStudent.InsertedOn = DateTime.Now; objStudent.InsertedBy = objViewModel.InsertedBy; objStudent.Email = objViewModel.Email; objStudent.OrganizationId = objViewModel.OrganizationId; objStudent.FullName = objViewModel.Profile.FirstName + " " + objViewModel.Profile.LastName; return objStudent.StudentId = this.CreateStudent(objStudent); }
public ActionResult CreateStudent(StudentViewModel objViewModel) { string token = repository.CreateToken(objViewModel, _userStatistics.UserId, _userStatistics.OrganizationId); if (!(string.IsNullOrEmpty(token))) { long userId = WebSecurity.RegisterNewUser(objViewModel.Email, "none", objViewModel.Email, false, objViewModel.Profile.FirstName, objViewModel.Profile.LastName, objViewModel.OrganizationId, token); DBConnectionString.Profile Profile = new DBConnectionString.Profile(); if (userId != -1) { Profile.UserId = userId; Profile.Title = objViewModel.Profile.Title; Profile.Address1 = "none"; Profile.Address2 = "none"; Profile.InsertedOn = DateTime.Now; Profile.EmailAddress1 = objViewModel.Email; Profile.HomeTelephoneNumber = objViewModel.Profile.HomeTelephoneNumber; Profile.SecurityQuestionId = 1; Profile.SecurityAnswer = "none"; Profile.DateOfBirth = objViewModel.Profile.DateOfBirth; Profile.ModifiedOn = null; Profile.MobileNumber = objViewModel.Profile.MobileNumber; int recAffected = Convert.ToInt32(Profile.Insert()); string roleName = UserRoles.Student.ToString(); //((UserRoles)Convert.ToInt16(Token.RoleId)).ToString(); Roles.AddUserToRole(objViewModel.Email, roleName); objViewModel.UserId = userId; objViewModel.InsertedBy = _userStatistics.UserId; objViewModel.OrganizationId = _userStatistics.OrganizationId; objViewModel.StudentId = repository.CreateNewStudent(objViewModel); if (objViewModel.StudentId != -1) { this.AssignGroup(objViewModel.GroupIds, userId); this.AssignSubject(objViewModel.SubjectIds, userId, objViewModel.StudentId); SaveFiles(token, this.GetType().Name, objViewModel.StudentId); EmailHandler.Utilities.SendRegistationEmail(token, objViewModel.Email); } return RedirectToAction("Index"); } } return View(this.LoadViewModel()); }
public string CreateToken(StudentViewModel objViewModel, long userId, long organizationId) { int recordAffected = 0; DBConnectionString.RegistrationToken registrationToken = new DBConnectionString.RegistrationToken(); registrationToken.OrganizationId = organizationId; registrationToken.CourseId = (int)objViewModel.CourseId; registrationToken.ClassId = objViewModel.ClassId; registrationToken.SectionId = objViewModel.SectionId; if (objViewModel.DepartmentId != null) { registrationToken.DepartmentId = (int)objViewModel.DepartmentId; } registrationToken.Token = UserStatistics.GenerateToken(); registrationToken.CreatedBy = userId; registrationToken.InsertedOn = DateTime.Now; registrationToken.RoleId = (int)UserRoles.Student; recordAffected = Convert.ToInt32(registrationToken.Insert()); if (recordAffected > 0) { return registrationToken.Token; } return string.Empty; }
public ActionResult Details(long id) { StudentViewModel objViewModel = new StudentViewModel(); objViewModel = this.repository.GetStudents(_userStatistics.OrganizationId, id); PetaPoco.Database db = new PetaPoco.Database("DBConnectionString"); objViewModel.GroupNames = string.Join(",", db.Query<string>("select GroupName from [Group] as G join UserGroup As UG on G.GroupId = UG.GroupId where UG.UserId = @0", objViewModel.UserId)); objViewModel.SubjectNames = string.Join(",", db.Query<string>("select SubjectName from Subjects as S join UserSubjects As US on S.SubjectId = US.SubjectId where US.UserId = @0", objViewModel.UserId)); return View(objViewModel); }
public StudentViewModel LoadViewModel() { SelectList classList = null; SelectList courseList = null; SelectList sectionList = null; SelectList departmentList = null; this.LoadSelectLists(out classList, out courseList, out sectionList, out departmentList, false); StudentViewModel objViewModel = new StudentViewModel(); objViewModel.CourseList = courseList; objViewModel.DepartmentList = departmentList; objViewModel.ClassList = classList; objViewModel.SectionList = sectionList; return objViewModel; }
public ActionResult Edit(StudentViewModel objViewModel) { if (this.repository.UpdateStudent(objViewModel)) { return RedirectToAction("Index"); } SelectList classList = null; SelectList courseList = null; SelectList sectionList = null; SelectList departmentList = null; this.LoadSelectLists(out classList, out courseList, out sectionList, out departmentList, true, objViewModel.OrganizationId, objViewModel.CourseId, objViewModel.DepartmentId, objViewModel.ClassId, objViewModel.SectionId); objViewModel.CourseList = courseList; objViewModel.DepartmentList = departmentList; objViewModel.ClassList = classList; objViewModel.SectionList = sectionList; return View(objViewModel); }
public ActionResult Edit(long id) { SelectList classList = null; SelectList courseList = null; SelectList sectionList = null; SelectList departmentList = null; StudentViewModel objViewModel = new StudentViewModel(); objViewModel = this.repository.GetStudents(_userStatistics.OrganizationId, id); this.LoadSelectLists(out classList, out courseList, out sectionList, out departmentList, true, objViewModel.OrganizationId, objViewModel.CourseId, objViewModel.DepartmentId, objViewModel.ClassId, objViewModel.SectionId); objViewModel.CourseList = courseList; objViewModel.DepartmentList = departmentList; objViewModel.ClassList = classList; objViewModel.SectionList = sectionList; return View(objViewModel); }
public bool UpdateStudent(StudentViewModel objViewModel) { PetaPoco.Database db = new PetaPoco.Database("DBConnectionString"); DBConnectionString.User user = DBConnectionString.User.SingleOrDefault(objViewModel.UserId); DBConnectionString.Student student = DBConnectionString.Student.SingleOrDefault(objViewModel.StudentId); DBConnectionString.Profile profile = db.Query<DBConnectionString.Profile>("Select * from profile where UserId = @0", student.UserId).SingleOrDefault(); db.BeginTransaction(); try { if (user != null) { user.FirstName = objViewModel.FirstName; user.LastName = objViewModel.LastName; user.Update(); } if (student != null) { student.ClassId = objViewModel.ClassId; student.CourseId = objViewModel.CourseId; student.DepartmentId = objViewModel.DepartmentId; student.Email = objViewModel.Email; student.FullName = objViewModel.FirstName + " " + objViewModel.LastName; student.ModifiedBy = objViewModel.ModifiedBy; student.ModifiedOn = objViewModel.ModifiedOn; student.SectionId = objViewModel.SectionId; student.Update(); } if (profile != null) { profile.Title = objViewModel.Title; profile.DateOfBirth = objViewModel.DateOfBirth; profile.MobileNumber = objViewModel.MobileNumber; profile.HomeTelephoneNumber = objViewModel.HomeTelephoneNumber; profile.EmailAddress1 = objViewModel.Email; profile.Update(); } //var subjectIdArray = objViewModel.SubjectIds.Split(','); //foreach (var subjectId in subjectIdArray) //{ // DBConnectionString.UserSubject userSubject = db.Query<DBConnectionString.UserSubject>("select * from UserSubjects where UserId = @0 and SubjectId = @1", objViewModel.UserId, subjectId).SingleOrDefault(); // if (userSubject == null) // { // userSubject.UserId = objViewModel.UserId.Value; // userSubject.SubjectId = Convert.ToInt64(subjectId); // userSubject.InsertedOn = DateTime.Now; // userSubject.InsertedBy = objViewModel.InsertedBy; // userSubject.Update(); // } //} db.CompleteTransaction(); return true; } catch { db.AbortTransaction(); return false; } }