Exemplo n.º 1
0
 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);
 }
Exemplo n.º 2
0
        public long CreateStudent(Student objStudent)
        {
            var parameters = new
            {
                UserId = objStudent.UserId,
                CourseId = objStudent.CourseId,
                DepartmentId = objStudent.DepartmentId,
                ClassId = objStudent.ClassId,
                SectionId = objStudent.SectionId,
                RollNo = objStudent.RollNo,
                InsertedOn = objStudent.InsertedOn,
                InsertedBy = objStudent.InsertedBy,
                Email = objStudent.Email,
                OrganizationId = objStudent.OrganizationId,
                FullName = objStudent.FullName,
            };

            using (IDbConnection connection = OpenConnection())
            {
                const string storedProcedure = "usp_AddStudent";
                int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure);
                SetIdentity<int>(connection, id => objStudent.StudentId = id);
                if (rowsAffected > 0)
                {
                    return objStudent.StudentId;
                }
                return -1;
            }
        }
Exemplo n.º 3
0
        public ActionResult RegisterUserStep3(Profile objProfile)
        {
            RegistrationToken Token = repository.GetRegistrationCode(objProfile.RegistrationToken);
            // RegistrationToken objToken = repository.GetRegistrationCode(objProfile.RegistrationToken);
            StudentContext context = new StudentContext();
            Student student = new Student();
            Staff staff = new Staff();
            if (Token.StaffId != null)
            {
                staff = context.Staff.Find(Token.StaffId);
            }

            if (Token.StudentId != null)
            {
                student = context.Students.Find(Token.StudentId);
            }
            //objProfile.RegistrationToken=Toke
            long userId = WebSecurity.RegisterNewUser(objProfile.UserName, "none", "none", false, objProfile.FirstName, objProfile.LastName, Token.OrganizationId, Token.Token);
            if (student != null)
            {
                student.UserId = userId;

            }

            if (staff != null)
            {
                staff.UserId = userId;
            }

            context.SaveChanges();
            DBConnectionString.Profile Profile = new DBConnectionString.Profile();
            if (userId != -1)
            {
                Profile.UserId = userId;
                Profile.Title = objProfile.Title;
                Profile.Address1 = "none";
                Profile.Address2 = "none";
                Profile.InsertedOn = DateTime.Now;
                Profile.EmailAddress1 = "*****@*****.**";
                Profile.HomeTelephoneNumber = DateTime.Now.Ticks.ToString();
                Profile.SecurityQuestionId = 1;
                Profile.SecurityAnswer = "none";
                Profile.DateOfBirth = objProfile.DateOfBirth;
                Profile.ModifiedOn = null;
                Profile.MobileNumber = "none";

                int recAffected = Convert.ToInt32(Profile.Insert());

                string roleName = ((UserRoles)Convert.ToInt16(Token.RoleId)).ToString();
                Roles.AddUserToRole(objProfile.UserName, roleName);

                return RedirectToAction("RegisterUserStep4", new { userId });
            }
            return View("RegisterUserStep3", new { token = Token.Token });
        }