public UniversityInfo(int course, Specialty spec, University uni, Faculty fac)
 {
     this.Course = course;
     this.Specialty = spec;
     this.University = uni;
     this.Faculty = fac;
 }
 public Student(string email, Course course, string firstName, string middleName, string lastName,
     University university, Major major, string phone)
     : this(email, course, firstName, middleName, lastName, university, major)
 {
     this.Phone = phone;
     count++;
 }
Example #3
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "application/json";

            string Name = context.Request.QueryString["Name"].ToString();
            int ProvinceId = Convert.ToInt32(context.Request.QueryString["ProvinceId"].ToString());
            string LibServicesAddress = context.Request.QueryString["LibServicesAddress"].ToString();

            if (Name.Length >= 1 && ProvinceId != 0)
            {
                try
                {
                    University university = new University();
                    university.Name = Name;//学校名称
                    university.ProvinceId = ProvinceId;//省份
                    university.DateCreated = DateTime.Now;//创建时间为系统当前时间
                    university.LibServicesAddress = LibServicesAddress;//接口地址
                    university.Save();
                    context.Response.Write("{success:true,msg:'新增成功。',DateCreated:'" + DateTime.Now.ToShortDateString() + "',universityId:'" + university.Id + "'}");
                }
                catch (Exception)
                {
                    context.Response.Write("{success:false,msg:'新增失败,请稍候重试。'}");
                }
            }
            else
            {
                context.Response.Write("{success:false,msg:'名称和省份为必填项。'}");
            }
        }
 public Student(string email, Course course, string firstName, string middleName, string lastName,
     University university, Major major)
     : this(email, course, firstName, middleName, lastName)
 {
     this.University = university;
     this.Major = major;
     count++;
 }
Example #5
0
 public Student(string firstName, string middleName, string familyName, string ssn, Speciality speciality, Faculty faculty, University university,
    string course, string addres, string email)
     : this(firstName, middleName, familyName, ssn, speciality, faculty, university)
 {
     this.Course = course;
     this.Adress = addres;
     this.Email = email;
 }
Example #6
0
 //every person to be a student must have this
 public Student(string firstName, string middleName, string familyName, string ssn,
     Speciality speciality, Faculty faculty, University university)
     : base(firstName, middleName, familyName, ssn)
 {
     this.Speciality = speciality;
     this.Faculty = faculty;
     this.University = university;
 }
 public Student(string firstName, string middleName, string lastName, string ssn, string address, string phoneNumber,
     string email, int? course, Specialty specialtyName, Faculty facultyName, University universityName)
     : this(firstName, middleName, lastName, ssn)
 {
     this.Address = address;
     this.PhoneNumber = phoneNumber;
     this.Email = email;
     this.Course = course;
     this.SpecialtyName = specialtyName;
     this.FacultyName = facultyName;
     this.UniversityName = universityName;
 }
        public void Create(string directorId, string name, int tuitionFee, int countryId)
        {
            var university = new University()
            {
                CountryId = countryId,
                DirectorId = directorId,
                Name = name,
                TuitionFee = tuitionFee,
                CreatedOn = DateTime.UtcNow
            };

            this.universities.Add(university);
            this.universities.Save();
        }
 public Student(string firstName, string middleName, string lastName, string address, uint phone, byte course, int ssn, 
     Specialty specialty, University university, Faculty faculty)
 {
     this.FirstName = firstName;
     this.MiddleName = middleName;
     this.LastName = lastName;
     this.Address = address;
     this.Phone = phone;
     this.Course = course;
     this.SSN = ssn;
     this.Specialty = specialty;
     this.University = university;
     this.Faculty = faculty;
 }
Example #10
0
        public NodeModel()
        {
            Region = new Region();

            City = new City();

            University = new University();

            Faculty = new Faculty();

            Speciality = new Speciality();

            FacultyToSpeciality = new FacultyToSpeciality();
        }
 public Student(string firstName, char middleName, string lastName, long ssn, string adress, long phoneNumber, string email, string course, Specialty specialty, University university, Facylty faculty)
 {
     this.Specialty = specialty;
     this.University = university;
     this.Faculty = faculty;
     this.FirstName = firstName;
     this.MiddleName = middleName;
     this.LastName = lastName;
     this.Ssn = ssn;
     this.Adress = adress;
     this.PhoneNumber = phoneNumber;
     this.Email = email;
     this.Course = course;
 }
 public Student(string firstName, string middleName, string lastName, string ssn, string permanentAddress, string mobilePhone,
     string email, int course, Specialty specialty, University university, Faculty faculty)
 {
     this.FirstName = firstName;
     this.MiddleName = middleName;
     this.LastName = lastName;
     this.SSN = ssn;
     this.PermanentAddress = permanentAddress;
     this.MobilePhone = mobilePhone;
     this.Email = email;
     this.Course = course;
     this.Specialty = specialty;
     this.University = university;
     this.Faculty = faculty;
 }
 public Student(string firstName, string secondName, string lastName, string permanentAddress, int SSN, int mobilePhone,
                 string email, string course, Specialty spec, University uni, Faculty fac)
 {
     this.firstName = firstName;
     this.secondName = secondName;
     this.lastName = lastName;
     this.SSN = SSN;
     this.mobilePhone = mobilePhone;
     this.permanentAddress = permanentAddress;
     this.email = email;
     this.course = course;
     this.spec = spec;
     this.uni = uni;
     this.fac = fac;
 }
        public void DoSelectBuildingForBuild_True()
        {
            var status = new PlayerStatus(1, "Test");
            status.ReceiveDoubloons(10);
            var mainBoardController = new MainBoardController(4);
            var playerController = new PlayerController(mainBoardController, status);

            var university = new University();
            university.ReceiveColonist();

            status.Board.BuildBuilding(university);

            var result = playerController.DoSelectBuildingToBuild(mainBoardController.Status.Buildings.First().Key, true);

            Assert.IsTrue(result);
        }
Example #15
0
        public Student(string firstName, string lastName, int ssn, Specialty SpecialtyStudent, University UniversityStudent, Faculty FacultyStudent,
            string course = null, string addres = null, string mobilePhone = null,
            string email = null, string middleName = null)
        {
            this.FirstName = firstName;
            this.MiddleName = middleName;
            this.LastName = lastName;
            this.SSN = ssn;
            this.Address = addres;
            this.MobilePhone = mobilePhone;
            this.Email = email;
            this.Course = course;

            this.SpecialtyStudent = SpecialtyStudent;
            this.UniversityStudent = UniversityStudent;
            this.FacultyStudent = FacultyStudent;
        }
Example #16
0
 public Student(string firstName, string middleName, string lastName,
     string address = null, int? mobilePhone = null, string email = null,
     int? course = null, int? number = null, University? university = null,
     Faculty? faculty = null, Specialties? specialties = null)
 {
     this.FirstName = firstName;
     this.MiddleName = middleName;
     this.LastName = lastName;
     this.Address = address;
     this.MobilePhone = mobilePhone;
     this.Email = email;
     this.Course = course;
     this.Number = number;
     this.University = university;
     this.Faculty = faculty;
     this.Specialties = specialties;
 }
 public ApplicationResponse UpdateUniversity(University model, UserContextModel objUser)
 {
     try
     {
         var validationResponse = _universityValidation.Validate(UniversityValidation.ValidateAll_key, model, "Course title model can not be empty.");
         if (validationResponse.Messages != null && validationResponse.Messages.Count != 0)
         {
             throw new ValidationException(validationResponse);
         }
         model.CreatedBy = objUser.UserID;
         var data = _qualificationRepository.UpdateCourseUniversity(model, objUser.CompanyCode);
         return(data);
     }
     catch (Exception ex)
     {
         var helper = new BusinessException(ex);
         throw helper.GetException();
     }
 }
        public void UniversityRule_Is_Not_Satisfied__When_Ratio_Universities_Per_Schools_Is_Greater_Than_1_To_5()
        {
            IRoad road = _settlement.Roads.First();

            var schools = new List <School>(4)
            {
                new School()
                {
                    Position = new Point(50, 51)
                },
                new School()
                {
                    Position = new Point(55, 51)
                },
                new School()
                {
                    Position = new Point(60, 51)
                },
                new School()
                {
                    Position = new Point(65, 51)
                }
            };

            schools.ForEach(s =>
            {
                s.Road = road;
                _settlement.AddBuildingToRoad(road, s);
            });

            var university = new University()
            {
                Position = new Point(50, 49)
            };

            Assert.AreEqual(0, university.CalculateFitness(new BuildingRule()
            {
                BuildingRoad     = road,
                Fields           = _settlement.Fields,
                Roads            = _settlement.Roads,
                SettlementCenter = _settlement.SettlementCenter
            }));
        }
Example #19
0
        // GET: Universities/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            University university = db.Universities.Find(id);

            if (university == null)
            {
                return(HttpNotFound());
            }
            else
            {
                university.Views = university.Views + 1;
                db.SaveChanges();
            }
            return(View(university));
        }
Example #20
0
 public Student(
     string firstName,
     string middleName,
     string lastName,
     int socialSecurityNumber,
     string permanentAdress,
     string mobilePhone,
     string email,
     string course,
     Specialty specialty,
     Faculty faculty,
     University university)
     : this(firstName, middleName, lastName, socialSecurityNumber, permanentAdress, mobilePhone, email)
 {
     this.Course     = course;
     this.Specialty  = specialty;
     this.Faculty    = faculty;
     this.University = university;
 }
Example #21
0
        public static bool IsGroupExist(string university, string faculty, string course, string group)
        {
            University universitym = db.Universities.Where(m => m.Name == university).FirstOrDefault();

            Faculty facultym = db.Faculties.Where(l => l.University == universitym).Where(t => t.Name == faculty).FirstOrDefault();

            Course coursem = db.Courses.Where(o => o.Facultie == facultym).Where(t => t.Name == course).FirstOrDefault();

            Group groupm = db.Groups.Where(n => n.Course == coursem).Where(t => t.Name == group).FirstOrDefault();

            bool result = false;

            if (groupm != null)
            {
                result = true;
            }

            return(result);
        }
Example #22
0
        public void WriteDataToFile(string form)
        {
            University university = new University()
            {
                createdAt      = DateTime.Now.ToString("h:mm:ss tt"),
                author         = "Dominik Suchner",
                listOfStudents = students
            };

            if (dataForm.Equals("xml"))
            {
                new XMLWriter().WriteData(urlTarget, university);
            }

            if (dataForm.Equals("json"))
            {
                new JSONWriter().WriteData(urlTarget, university);
            }
        }
Example #23
0
        public void ShowInfoAboutFutureEducation()
        {
            //string Message = educationalInstitutionObject.GetInfoAboutFutureEducation(this);
            // Console.WriteLine(Message);
            string message;

            if (Institution == "College")
            {
                message = new College().GetInfoAboutFutureEducation(this);
            }
            else if (Institution == "School")
            {
                message = new School().GetInfoAboutFutureEducation(this);
            }
            else if (Institution == "University")
            {
                message = new University().GetInfoAboutFutureEducation(this);
            }
        }
Example #24
0
        public void Save(University data)
        {
            var now = DateTime.Now;

            if (data.UniversityId != 0)
            {
                data.UpgradeDate = now;
                _context.University.Update(data);
            }

            else
            {
                data.CreationDate = now;
                data.StatusId     = StatusValues.Activo;
                _context.Add(data);
            }

            _context.SaveChanges();
        }
Example #25
0
 public ApplicationResponse UpdateCourseUniversity(University model, string DbName)
 {
     try
     {
         var       parameters    = new string[] { "Id", "UniversityName", "CountryId", "StateId", "CityId", "IsActive", "IsBlacklist", "CreatedBy" };
         var       sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters);
         DataTable dt            = _dbHelper.GetDataTable(DbName, "[Common].[Master_EditUniversity]", sqlParameterd);
         return(new ApplicationResponse
         {
             Code = Convert.ToInt32(dt.Rows[0][0]),
             Message = Convert.ToString(dt.Rows[0][1]),
         });
     }
     catch (Exception ex)
     {
         var helper = new Helpers.ExceptionHelper.DataException(ex);
         throw helper.GetException();
     }
 }
 public LessonMenuItemsFactory([NotNull] ICommandFactory commandFactory, [NotNull] University university,
                               [NotNull] OptionsMonitor optionsMonitor)
 {
     if (commandFactory == null)
     {
         throw new ArgumentNullException("commandFactory");
     }
     if (university == null)
     {
         throw new ArgumentNullException("university");
     }
     if (optionsMonitor == null)
     {
         throw new ArgumentNullException("optionsMonitor");
     }
     _commandFactory = commandFactory;
     _university     = university;
     _optionsMonitor = optionsMonitor;
 }
Example #27
0
        public async Task <IActionResult> Upsert(int?id)
        {
            string     token = HttpContext.Session.GetString("JWToken");
            University obj   = new University();

            // Insert
            if (id == null)
            {
                return(View(obj));
            }
            // Update
            obj = await _db.GetAsync(_url, id.GetValueOrDefault(), token);

            if (obj == null)
            {
                return(NotFound());
            }
            return(View(obj));
        }
Example #28
0
 // delete
 public bool DeleteUniversity(int id)
 {
     using (AttenderEntities ef = new AttenderEntities())
     {
         University deletedUniversity = ef.Universities.FirstOrDefault(a => a.Id == id);
         if (deletedUniversity == null)
         {
             return(false);
         }
         ef.Universities.Remove(deletedUniversity);
         try{
             ef.SaveChanges();
         }
         catch {
             return(false);
         }
     }
     return(true);
 }
    static void Main(string[] args)
    {
        var university = new University()
        {
            Student  = 1,
            Subjects = new List <Subject>()
            {
                new Subject()
                {
                    Id = 1, Text = "Math"
                },

                new Subject()
                {
                    Id = 2, Text = "English"
                },
            },
        };
    }
        public void IndexFilteredWithActions()
        {
            var mockApproveUser = University.GetUser("o101");

            ApproveController controller = new ApproveController();

            controller.ControllerContext = new ControllerContext(MockAuthContext(mockApproveUser).Object, new RouteData(), controller);

            ViewResult result = controller.Index("", "", "Test Student11", 1) as ViewResult;

            Assert.IsNotNull(result);
            Assert.IsInstanceOfType(result.Model, typeof(PagedList <StickerApplication>));

            PagedList <StickerApplication> model = result.Model as PagedList <StickerApplication>;

            Assert.AreEqual(0, model.Where(a => a.Status != StickerApplicationStatus.WaitingForApproval).Count());
            Assert.AreEqual(1, model.Count);
            Assert.AreEqual(2, model.FirstOrDefault().GetApprovementOptions().Count);
        }
Example #31
0
        static void Main(string[] args)
        {
            Student student1 = new Student();

            student1.Filling("Koshuba", 25, "ПОИТ", 07); //полный метод
            double pay = student1.Payment();             //можно получить если поставить public в методе класса

            student1.Info();

            Student student2 = new Student();

            student2.Filling("\tВМСиС", 02);   //Сокращенный перегруженный метод
            student2.Info();
            Console.WriteLine();

            Student student3 = new Student();

            student3.Filling("ИиТП", 06); // Сокращенный перегруженный метод
            student3.name = "Novikov";    // + свойства
            student3.age  = 17;
            student3.Info();
            Console.WriteLine();

            Console.WriteLine("Всего работников: {0}", Student.Counter.ToString());

            Сertificate cert1 = new Сertificate {
                Number = "12"
            };

            cert1.Display();
            cert1 = new University {
                Number = "120"
            };
            cert1.Display();
            Сertificate univ1 = (University)cert1;

            cert1.Nice();
            cert1.Filling("YA", 15, 7, 6);
            cert1.Inf();

            Console.WriteLine();
            Console.ReadKey();
        }
        public void CreateUniversitySystemNamespaces()
        {
            // 1. Create namespace for classes describing university-related areas such as:
            // - University
            // - Dormitory
            // - Campus
            // 2. Create namespace for classes describing university-related people such as:
            // - Teacher
            // - Student
            // - OfficeWorker
            // 3. Replace below objects with proper class types

            var student    = new Student();
            var teacher    = new Teacher();
            var university = new University();

            student.Should().NotBeNull();
            university.Should().NotBeNull();
        }
        static void Main(string[] args)
        {
            University univ = University.GetRandomFilledUniversity();

            Console.WriteLine(univ.ToString());
            using (FileStream output = new FileStream("MyFile.xml", FileMode.Create, FileAccess.Write))
            {
                XmlSerializer serializer = new XmlSerializer(typeof(University), new Type[] { typeof(Human), typeof(Professor), typeof(Dept) });
                serializer.Serialize(output, univ);
            }
            Console.WriteLine("-----------------------------");
            Console.WriteLine("-----------------------------");
            using (FileStream input = new FileStream("MyFile.xml", FileMode.Open, FileAccess.Read))
            {
                XmlSerializer newSerializer = new XmlSerializer(typeof(University), new Type[] { typeof(Human), typeof(Professor), typeof(Dept) });
                University    newUniv       = newSerializer.Deserialize(input) as University;
                Console.WriteLine(newUniv);
            }
        }
        public void IndexSorted()
        {
            var mockDeliverUser = University.GetUser("o102");

            DeliverController controller = new DeliverController();

            controller.ControllerContext = new ControllerContext(MockAuthContext(mockDeliverUser).Object, new RouteData(), controller);

            ViewResult result = controller.Index("name_desc", "", "", 1) as ViewResult;

            Assert.IsNotNull(result);
            Assert.IsInstanceOfType(result.Model, typeof(PagedList <StickerApplication>));

            PagedList <StickerApplication> model = result.Model as PagedList <StickerApplication>;

            Assert.AreNotEqual(0, model.Count);
            Assert.AreEqual(0, model.Where(a => a.Status != StickerApplicationStatus.WaitingForDelivery).Count());
            Assert.AreEqual("Test Student3", model.FirstOrDefault().Owner.Name);
        }
Example #35
0
        public static List <University> GenerateData(int noOfUniversities, int noOfStudents, int noOfGrades)
        {
            var universities = new List <University>();

            for (var i = 0; i <= noOfUniversities; i++)
            {
                var university = new University
                {
                    City     = $"City_{i}",
                    Country  = $"Country_{i}",
                    Name     = $"University_{i}",
                    Students = new List <Student>()
                };

                for (var j = 0; j < noOfStudents; j++)
                {
                    var student = new Student
                    {
                        FirstName = $"FirstName_{i}_{j}",
                        LastName  = $"LastName{i}_{j}",
                        Grades    = new List <Grade>()
                    };

                    university.Students.Add(student);

                    for (var k = 0; k < noOfGrades; k++)
                    {
                        var grade = new Grade
                        {
                            Course = $"Course_{i}_{j}_{k}",
                            Points = new Random().Next(0, 10)
                        };

                        student.Grades.Add(grade);
                    }
                }

                universities.Add(university);
            }

            return(universities);
        }
Example #36
0
        public async Task Put_University_Success()
        {
            var uni = new University
            {
                Name   = "UIUC",
                Domain = "illinois.edu"
            };

            _context.Universities.Add(uni);
            _context.SaveChanges();

            uni.Name   = "Stanford";
            uni.Domain = "stanford.edu";

            var result = await _controller.PutUniversity(uni.Id, uni);

            Assert.IsType <NoContentResult>(result);

            Assert.Equal(uni, _context.Universities.Find(uni.Id));
        }
Example #37
0
        public Student(string fullName, int socialSecurityNumber, int course, University uni, Faculty faculty, Specialty specialty)
        {
            string[] fullNameSplit = fullName.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
            try
            {
                this.FirstName  = fullNameSplit[0];
                this.MiddleName = fullNameSplit[1];
                this.LastName   = fullNameSplit[2];
            }
            catch (IndexOutOfRangeException)
            {
                throw new ArgumentException("Invalid name passed! You must pass all three names of the student.");
            }

            this.SocialSecurityNumber = socialSecurityNumber;
            this.Course     = course;
            this.University = uni;
            this.Faculty    = faculty;
            this.Specialty  = specialty;
        }
Example #38
0
        //Add applicant method

        public void AddUniversity(University university)
        {
            var uni = GetUniversity(university.UniversityName.Trim());

            if (uni != null)
            {
                throw new ApplicationException("University with same name already exist.");
            }

            University dataUniversity = (from universities
                                         in _context.University
                                         where universities.UniversityName == university.UniversityName
                                         select universities).ToList <University>().FirstOrDefault();

            if (dataUniversity == null)
            {
                _context.University.Add(university);
                _context.SaveChanges();
            }
        }
Example #39
0
        public override int GetHashCode()
        {
            int hash           = 29;
            int hashMultiplier = 11;

            unchecked
            {
                hash = hash * hashMultiplier + string.Format("{0} {1} {2}", FirstName, MiddleName, LastName).GetHashCode();
                hash = hash * hashMultiplier + Adress.GetHashCode();
                hash = hash * hashMultiplier + Course.GetHashCode();
                hash = hash * hashMultiplier + Email.GetHashCode();
                hash = hash * hashMultiplier + Faculty.GetHashCode();
                hash = hash * hashMultiplier + Phone.GetHashCode();
                hash = hash * hashMultiplier + SSN.GetHashCode();
                hash = hash * hashMultiplier + University.GetHashCode();
                hash = hash * hashMultiplier + Specialty.GetHashCode();
            }

            return(hash);
        }
Example #40
0
        public ActionResult Index(string sortOrder, string currentFilter, string searchString, int?page)
        {
            Trace.WriteLine("GET /Invalidate/Index");

            ViewBag.CurrentSort   = sortOrder;
            ViewBag.NameSortParm  = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewBag.DateSortParm  = sortOrder == "Date" ? "date_desc" : "Date";
            ViewBag.PlateSortParm = sortOrder == "Plate" ? "plate_desc" : "Plate";

            if (searchString == null)
            {
                searchString = currentFilter;
            }

            ViewBag.CurrentFilter = searchString;

            var res = University.GetStickerApplicationsByKeyword(sortOrder, currentFilter, searchString, page, StickerApplicationStatus.Active);

            return(View(res));
        }
Example #41
0
        public ActionResult Approve(int Id, int QuotaID)
        {
            Trace.WriteLine("GET /Approve/Approve");
            using (DatabaseContext db = GetNewDBContext())
            {
                var application = db.StickerApplications
                                  .Include(a => a.User.Division)
                                  .Include(a => a.User.Category)
                                  .Include(a => a.Vehicle)
                                  .Where(a => a.ID == Id)
                                  .FirstOrDefault();

                if (application == null)
                {
                    throw new HttpAntiForgeryException("Application not found");
                }

                if (application.User.Division.ID != ((METUPrincipal)User).User.Division.ID)
                {
                    throw new HttpAntiForgeryException();
                }

                ApprovementOption approvementOption = application.GetApprovementOptions().FirstOrDefault(a => a.QuotaID == QuotaID);
                if (approvementOption == null)
                {
                    throw new HttpAntiForgeryException();
                }

                Quota quota = University.GetQuota(approvementOption.QuotaID);
                if (quota.RemainingQuota == 0)
                {
                    return(RedirectToAction("Index"));
                }
                db.Quotas.Attach(quota);
                application.Status      = StickerApplicationStatus.WaitingForPayment;
                application.ApproveDate = DateTime.Now;
                application.Quota       = quota;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
        }
Example #42
0
        public override void SaveData(University university)
        {
            XmlWriterSettings settings = new XmlWriterSettings();

            settings.Async = false;

            using (XmlWriter writer = XmlWriter.Create(FileName))
            {
                writer.WriteStartElement("University");

                foreach (var uMember in university)
                {
                    if (uMember is Group)
                    {
                        writer.WriteStartElement("Group");
                        writer.WriteAttributeString("Name", (uMember as Group).Name);
                        foreach (var gMember in (uMember as Group))
                        {
                            WritePerson(gMember);
                        }
                        writer.WriteEndElement();
                    }
                    else
                    {
                        WritePerson(uMember as IPerson);
                    }
                }

                void WritePerson(IPerson person)
                {
                    writer.WriteStartElement(person.GetType().Name);
                    foreach (var pAttribute in person)
                    {
                        writer.WriteElementString(pAttribute.Name, pAttribute.Value.ToString());
                    }
                    writer.WriteEndElement();
                }

                writer.WriteEndElement();
            }
        }
Example #43
0
        public void PublishGroupSelected([NotNull] Group selectedGroup, [NotNull] Faculty faculty,
                                         [NotNull] University university, Reason reason)
        {
            if (selectedGroup == null)
            {
                throw new ArgumentNullException("selectedGroup");
            }
            if (faculty == null)
            {
                throw new ArgumentNullException("faculty");
            }
            if (university == null)
            {
                throw new ArgumentNullException("university");
            }

            var parameters = new[]
            {
                new EventParameter("University_name", university.Name),
                new EventParameter("University_id", university.Id.ToString(CultureInfo.InvariantCulture)),
                new EventParameter("Faculty_id", faculty.Id.ToString(CultureInfo.InvariantCulture)),
                new EventParameter("Faculty_name", faculty.Title),
                new EventParameter("Group_name", selectedGroup.GroupName),
                new EventParameter("Group_id", selectedGroup.Id.ToString(CultureInfo.InvariantCulture))
            };

            switch (reason)
            {
            case Reason.Registration:
                PublishEvent(FlurryEvents.ChooseGroup, parameters);
                break;

            case Reason.AddingFavorites:
                PublishEvent(FlurryEvents.FavoriteGroup, parameters);
                break;

            case Reason.ChangeDefault:
                PublishEvent(FlurryEvents.ChangeGroup, parameters);
                break;
            }
        }
Example #44
0
        public async Task <University> GetUniversity(string mailId)
        {
            if (string.IsNullOrEmpty(mailId))
            {
                return(await _context.Universities.FindAsync("0000"));
            }

            string domain = mailId.Split('@')[1];

            // Some GSVU emails can have "mail." prefix
            // If we come across many more of these, me should consider a comprehensive database / regex solution
            domain = domain.Replace("mail.gvsu.edu", "gvsu.edu");

            University university;

            if (_context.Universities.Where(u => u.Domain == domain).Any())
            {
                university = _context.Universities.Where(u => u.Domain == domain).Single();
            }
            else
            {
                string universityName = GetUniversityName(domain);
                if (string.IsNullOrEmpty(universityName))
                {
                    // If domain is unknown return Special University as Unknown
                    university = await _context.Universities.FindAsync("0000");
                }
                else
                {
                    university = new University
                    {
                        Name   = universityName,
                        Domain = domain
                    };
                    await _context.Universities.AddAsync(university);

                    await _context.SaveChangesAsync();
                }
            }
            return(university);
        }
Example #45
0
 //load data array from "Statuses" data
 private void LoadUniversityData()
 {
     using (StudentuConteiner db = new StudentuConteiner())
     {
         try
         {
             var list = db.Universities.ToList();
             foreach (var item in list)
             {
                 UniversityRecords.Add(
                     new University
                 {
                     UniversityId   = item.UniversityId,
                     UniversityName = item.UniversityName,
                     City           = item.City
                 });
             }
             University = UniversityRecords[0];
         }
         catch (ArgumentNullException ex)
         {
             dialogService.ShowMessage(ex.Message);
         }
         catch (OverflowException ex)
         {
             dialogService.ShowMessage(ex.Message);
         }
         catch (System.Data.SqlClient.SqlException ex)
         {
             dialogService.ShowMessage(ex.Message);
         }
         catch (System.Data.Entity.Core.EntityCommandExecutionException ex)
         {
             dialogService.ShowMessage(ex.Message);
         }
         catch (System.Data.Entity.Core.EntityException ex)
         {
             dialogService.ShowMessage(ex.Message);
         }
     }
 }
Example #46
0
        public void Update(University university)
        {
            var orgUniversity = this.universities
                .All()
                .Where(u => u.Id == university.Id)
                .FirstOrDefault();

            if (orgUniversity != null)
            {
                orgUniversity.Name = university.Name;
                orgUniversity.RequiredCambridgeLevel = university.RequiredCambridgeLevel;
                orgUniversity.RequiredCambridgeScore = university.RequiredCambridgeScore;
                orgUniversity.RequiredIBTToefl = university.RequiredIBTToefl;
                orgUniversity.RequiredPBTToefl = university.RequiredPBTToefl;
                orgUniversity.RequiredSAT = university.RequiredSAT;
                orgUniversity.TuitionFee = university.TuitionFee;
                orgUniversity.CountryId = university.CountryId;

                this.universities.Save();
            }
        }
Example #47
0
        public static University AddNewStudent(University university)
        {
            Student student = CreateNewStudent();



            var de  = new Department();
            var cls = new Class();

            cls.Students = new List <Student>();
            cls.Students.Add(student);

            de.Classes = new List <Class>();

            de.Classes.Add(cls);


            university.
            Departments.Add(de);
            return(university);
        }
Example #48
0
        public List<Account> GetAccounts(
            string name,
            int gender,
            string bloodType,
            int birthYear,
            int birthMonth,
            int birthDate,
            City hometownCity,
            Province homwtownProvince,
            City resideCity,
            Province resideProvince,
            ClassInfo classInfo,
            Grade grade,
            Major major,
            College college,
            University university,
            string code,
            bool? hasAvatar,
            string nickName,
            bool? isProtected,
            int minViewCount,
            int maxViewCount,
            bool? isPublic,
            int minYear,
            int maxYear,
            string interest,
            PagingInfo pagingInfo)
        {
            List<Account> accounts = new List<Account>();
            System.Text.StringBuilder sbFilter = new StringBuilder();

            #region Build filter

            sbFilter.Append("1=1 ");

            if (!string.IsNullOrEmpty(name))
            {
                sbFilter.Append(" And [Name] like '%");
                sbFilter.Append(name.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("%'");
            }

            if (gender == 1 || gender == 0)
            {
                sbFilter.Append(" And [Gender] = ");
                sbFilter.Append(gender);
            }

            if (!string.IsNullOrEmpty(bloodType))
            {
                sbFilter.Append(" And BloodType = '");
                sbFilter.Append(bloodType.Replace("'", "").Replace("\"", ""));
                sbFilter.Append(" '");
            }

            if (birthYear > 0)
            {
                sbFilter.Append(" And BirthYear = ");
                sbFilter.Append(birthYear);
            }

            if (birthMonth > 0 && birthMonth < 13)
            {
                sbFilter.Append(" And BirthMonth = ");
                sbFilter.Append(birthMonth);
            }

            if (birthDate > 0 && birthDate < 32)
            {
                sbFilter.Append(" And BirthDate = ");
                sbFilter.Append(birthDate);
            }

            if (hometownCity != null)
            {
                if (hometownCity.Id > 0)
                {
                    sbFilter.Append(" And HometownCityId = ");
                    sbFilter.Append(hometownCity.Id);
                }
            }
            else
            {
                if (homwtownProvince != null && homwtownProvince.Id > 0)
                {
                    sbFilter.Append(" And HometownProvinceId = ");
                    sbFilter.Append(homwtownProvince.Id);
                }
            }

            if (resideCity != null)
            {
                if (resideCity.Id > 0)
                {
                    sbFilter.Append(" And ResideCityId = ");
                    sbFilter.Append(resideCity.Id);
                }
            }
            else
            {
                if (resideProvince != null && resideProvince.Id > 0)
                {
                    sbFilter.Append(" And ResideProvinceId = ");
                    sbFilter.Append(resideProvince.Id);
                }
            }

            if (classInfo != null)
            {
                if (classInfo.Id > 0)
                {
                    sbFilter.Append(" And ClassInfoId = ");
                    sbFilter.Append(classInfo.Id);
                }
            }
            else
            {
                if (grade != null && grade.Id > 0)
                {
                    sbFilter.Append(" And GradeId = ");
                    sbFilter.Append(grade.Id);
                }

                if (major != null)
                {
                    if (major.Id > 0)
                    {
                        sbFilter.Append(" And MajorId = ");
                        sbFilter.Append(major.Id);
                    }
                }
                else
                {
                    if (college != null)
                    {
                        if (college.Id > 0)
                        {
                            sbFilter.Append(" And CollegeId = ");
                            sbFilter.Append(college.Id);
                        }
                    }
                    else
                    {
                        if (university != null && university.Id > 0)
                        {
                            sbFilter.Append(" And UniversityID = ");
                            sbFilter.Append(university.Id);
                        }
                    }
                }
            }

            if (!string.IsNullOrEmpty(code))
            {
                sbFilter.Append(" And Code = '");
                sbFilter.Append(code.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("'");
            }

            if (hasAvatar.HasValue)
            {
                sbFilter.Append(string.Format(" And HasAvatar = '{0}'", hasAvatar.Value ? "1" : "0"));
            }

            if (!string.IsNullOrEmpty(nickName))
            {
                sbFilter.Append(" And NickName = '");
                sbFilter.Append(nickName.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("'");
            }

            if (isProtected.HasValue)
            {
                sbFilter.Append(string.Format(" And IsProtected = '{0}'", isProtected.Value ? "1" : "0"));
            }

            if ((minViewCount > 0) &&
                (maxViewCount > 0) &&
                (minViewCount < maxViewCount))
            {
                sbFilter.Append(string.Format(" And ViewNumber Between {0} and {1} ", minViewCount, maxViewCount));
            }

            if (isPublic.HasValue)
            {
                sbFilter.Append(" And IsPublic = '");
                sbFilter.Append(isPublic.Value ? "1" : "0");
                sbFilter.Append("'");
            }
            if (minYear != 0 && maxYear != 0)
            {
                sbFilter.Append(string.Format(" And BirthYear Between {0} and {1} ", minYear, maxYear));
            }
            if (interest != string.Empty)
            {
                sbFilter.Append(string.Format(" And Interest like '%{0}%' ", interest));
            }
            //ͨ��������֤�����û�
            sbFilter.Append(" And IsEmailChecked='1'");//�߼����� AND [IsShow] = 0
            #endregion

            int pageSize = int.MaxValue;
            int pageNumber = 1;
            if (pagingInfo != null)
            {
                pageSize = pagingInfo.PageSize;
                pageNumber = pagingInfo.CurrentPage;
            }

            SqlServerUtility sql = new SqlServerUtility(connectionString);

            sql.AddParameter("@Tables", SqlDbType.VarChar, "view_account_all");
            sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
            sql.AddParameter("@Fields", SqlDbType.VarChar, "Id");
            sql.AddParameter("@sort", SqlDbType.NVarChar, "Id DESC");
            sql.AddParameter("@Filter", SqlDbType.VarChar, sbFilter.ToString());
            sql.AddParameter("@PageNumber", SqlDbType.Int, pageNumber);
            sql.AddParameter("@PageSize", SqlDbType.Int, pageSize);

            SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");

            if (reader != null)
            {
                while (reader.Read())
                {
                    long id = reader.GetInt64(0);
                    Account account = Account.Load(id);

                    accounts.Add(account);
                }
                reader.Close();
            }

            return accounts;
        }
Example #49
0
 public void Create(University model)
 {
     ClearCache();
     provider.Create(model);
 }
Example #50
0
        public int GetAccountsCount(
            string name,
            int gender,
            string bloodType,
            int birthYear,
            int birthMonth,
            int birthDate,
            City hometownCity,
            Province homwtownProvince,
            City resideCity,
            Province resideProvince,
            ClassInfo classInfo,
            Grade grade,
            Major major,
            College college,
            University university,
            string code,
            bool? hasAvatar,
            string nickName,
            bool? isProtected,
            int minViewCount,
            int maxViewCount,
            bool? isPublic,
            int minYear,
            int maxYear,
            string interest
            )
        {
            System.Text.StringBuilder sbFilter = new StringBuilder();

            #region Build filter

            sbFilter.Append("Where 1=1 ");

            if (!string.IsNullOrEmpty(name))
            {
                sbFilter.Append(" And [Name] like '%");
                sbFilter.Append(name.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("%'");
            }

            if (gender == 1 || gender == 0)
            {
                sbFilter.Append(" And [Gender] = ");
                sbFilter.Append(gender);
            }

            if (!string.IsNullOrEmpty(bloodType))
            {
                sbFilter.Append(" And BloodType = '");
                sbFilter.Append(bloodType.Replace("'", "").Replace("\"", ""));
                sbFilter.Append(" '");
            }

            if (birthYear > 0)
            {
                sbFilter.Append(" And BirthYear = ");
                sbFilter.Append(birthYear);
            }

            if (birthMonth > 0 && birthMonth < 13)
            {
                sbFilter.Append(" And BirthMonth = ");
                sbFilter.Append(birthMonth);
            }

            if (birthDate > 0 && birthDate < 32)
            {
                sbFilter.Append(" And BirthDate = ");
                sbFilter.Append(birthDate);
            }

            if (hometownCity != null)
            {
                if (hometownCity.Id > 0)
                {
                    sbFilter.Append(" And HometownCityId = ");
                    sbFilter.Append(hometownCity.Id);
                }
            }
            else
            {
                if (homwtownProvince != null && homwtownProvince.Id > 0)
                {
                    sbFilter.Append(" And HometownProvinceId = ");
                    sbFilter.Append(homwtownProvince.Id);
                }
            }

            if (resideCity != null)
            {
                if (resideCity.Id > 0)
                {
                    sbFilter.Append(" And ResideCityId = ");
                    sbFilter.Append(resideCity.Id);
                }
            }
            else
            {
                if (resideProvince != null && resideProvince.Id > 0)
                {
                    sbFilter.Append(" And ResideProvinceId = ");
                    sbFilter.Append(resideProvince.Id);
                }
            }

            if (classInfo != null)
            {
                if (classInfo.Id > 0)
                {
                    sbFilter.Append(" And ClassInfoId = ");
                    sbFilter.Append(classInfo.Id);
                }
            }
            else
            {
                if (grade != null && grade.Id > 0)
                {
                    sbFilter.Append(" And GradeId = ");
                    sbFilter.Append(grade.Id);
                }

                if (major != null)
                {
                    if (major.Id > 0)
                    {
                        sbFilter.Append(" And MajorId = ");
                        sbFilter.Append(major.Id);
                    }
                }
                else
                {
                    if (college != null)
                    {
                        if (college.Id > 0)
                        {
                            sbFilter.Append(" And CollegeId = ");
                            sbFilter.Append(college.Id);
                        }
                    }
                    else
                    {
                        if (university != null && university.Id > 0)
                        {
                            sbFilter.Append(" And UniversityID = ");
                            sbFilter.Append(university.Id);
                        }
                    }
                }
            }

            if (!string.IsNullOrEmpty(code))
            {
                sbFilter.Append(" And Code = '");
                sbFilter.Append(code.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("'");
            }

            if (hasAvatar.HasValue)
            {
                sbFilter.Append(string.Format(" And HasAvatar = '{0}'", hasAvatar.Value ? "1" : "0"));
            }

            if (!string.IsNullOrEmpty(nickName))
            {
                sbFilter.Append(" And NickName = '");
                sbFilter.Append(nickName.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("'");
            }

            if (isProtected.HasValue)
            {
                sbFilter.Append(string.Format(" And IsProtected = '{0}'", isProtected.Value ? "1" : "0"));
            }

            if ((minViewCount > 0) &&
                (maxViewCount > 0) &&
                (minViewCount < maxViewCount))
            {
                sbFilter.Append(string.Format(" And ViewNumber Between {0} and {1} ", minViewCount, maxViewCount));
            }

            if (isPublic.HasValue)
            {
                sbFilter.Append(" And IsPublic = '");
                sbFilter.Append(isPublic.Value ? "1" : "0");
                sbFilter.Append("'");
            }
            if (minYear != 0 && maxYear != 0)
            {
                sbFilter.Append(string.Format(" And BirthYear Between {0} and {1} ", minYear, maxYear));
            }
            if (interest != string.Empty)
            {
                sbFilter.Append(string.Format(" And Interest like '{0}' ", interest));
            }
            //ͨ��������֤�����û�
            sbFilter.Append(" And IsEmailChecked='1'");// �߼����� AND [IsShow] = 0
            #endregion

            SqlServerUtility sql = new SqlServerUtility(connectionString);
            String strSql = "Select count(Id) From [view_account_all] " + sbFilter.ToString();
            SqlDataReader reader = sql.ExecuteSqlReader(strSql);

            if (reader != null && !reader.IsClosed && reader.Read())
            {
                int count = 0;

                if (!reader.IsDBNull(0)) count = reader.GetInt32(0);

                reader.Close();
                return count;
            }
            else
            {
                if (reader != null && !reader.IsClosed)
                    reader.Close();

                return 0;
            }
        }
        public List<NodeModel> Parse()
        {
            if (!OpenDataFile(filePath))
                return null;

            var results = new List<NodeModel>();

            foreach(XElement region in document.Root.Elements())
            {
                if (String.IsNullOrEmpty(region.Attribute("name").Value) || regionList.Contains(region.Attribute("name").Value))
                    continue;

                var regionModel = new Region();

                regionList.Add(region.Attribute("name").Value);

                regionModel.Name = region.Attribute("name").Value;

                regionModel.Fields.Add(GetKey(), translator.Translate(regionModel.Name, Translator.Languages.Uk, Translator.Languages.En));

                foreach(XElement city in region.Elements())
                {
                    if (String.IsNullOrEmpty(city.Attribute("name").Value) || cityList.Contains(city.Attribute("name").Value))
                        continue;

                    var cityModel = new City();

                    cityList.Add(city.Attribute("name").Value);

                    cityModel.Name = city.Attribute("name").Value;

                    cityModel.Region = regionModel;

                    cityModel.Fields.Add(GetKey(), translator.Translate(cityModel.Name, Translator.Languages.Uk, Translator.Languages.En));

                    foreach (XElement university in city.Elements())
                    {
                        if (String.IsNullOrEmpty(university.Attribute("name").Value) || universityList.Contains(university.Attribute("name").Value))
                            continue;

                        var universityModel = new University();

                        universityList.Add(university.Attribute("name").Value);

                        universityModel.Name = university.Attribute("name").Value;

                        universityModel.City = cityModel;

                        universityModel.Fields.Add(GetKey(), translator.Translate(universityModel.Name, Translator.Languages.Uk, Translator.Languages.En));

                        foreach (XElement faculty in university.Elements())
                        {
                            if (String.IsNullOrEmpty(faculty.Attribute("name").Value))
                                continue;

                            var facultyModel = new Faculty();

                            facultyModel.University = universityModel;

                            facultyModel.Name = faculty.Attribute("name").Value;

                            facultyModel.Fields.Add(GetKey(), translator.Translate(facultyModel.Name, Translator.Languages.Uk, Translator.Languages.En));

                            foreach(XElement speciality in faculty.Elements())
                            {

                                if (String.IsNullOrEmpty(speciality.Attribute("name").Value))
                                    continue;

                                var specialityModel = new Speciality();

                                var facultyToSpecialityModel = new FacultyToSpeciality();

                                specialityModel.Name = speciality.Attribute("name").Value;

                                specialityModel.Fields.Add(GetKey(), translator.Translate(specialityModel.Name, Translator.Languages.Uk, Translator.Languages.En));

                                facultyToSpecialityModel.Speciality = specialityModel;

                                facultyToSpecialityModel.Faculty = facultyModel;

                                var node = new NodeModel
                                {
                                    Region = regionModel,
                                    City = cityModel,
                                    University = universityModel,
                                    Faculty = facultyModel,
                                    Speciality = specialityModel,
                                    FacultyToSpeciality = facultyToSpecialityModel
                                };

                                results.Add(node);
                            }
                        }
                    }
                }
            }

            return results;
        }
Example #52
0
 public static List<Account> GetAccounts(
     string name,
     int gender,
     string bloodType,
     int birthYear,
     int birthMonth,
     int birthDate,
     City hometownCity,
     Province homwtownProvince,
     City resideCity,
     Province resideProvince,
     ClassInfo classInfo,
     Grade grade,
     Major major,
     College college,
     University university,
     string code,
     bool? hasAvatar,
     string nickName,
     bool? isProtected,
     int minViewCount,
     int maxViewCount,
     bool? isPublic,
     int minYear,
     int maxYear,
     string interest,
     PagingInfo pagingInfo)
 {
     return provider.GetAccounts(
         name,
         gender,
         bloodType,
         birthYear,
         birthMonth,
         birthDate,
         hometownCity,
         homwtownProvince,
         resideCity,
         resideProvince,
         classInfo,
         grade,
         major,
         college,
         university,
         code,
         hasAvatar,
         nickName,
         isProtected,
         minViewCount,
         maxViewCount,
         isPublic,
         minYear,
         maxYear,
         interest,
         pagingInfo);
 }
Example #53
0
        // ��̨����
        public List<Account> GetAccounts(
            string name,
            int gender,
            string bloodType,
            int birthYear,
            int birthMonth,
            int birthDate,
            City hometownCity,
            Province homwtownProvince,
            City resideCity,
            Province resideProvince,
            ClassInfo classInfo,
            Grade grade,
            Major major,
            College college,
            University university,
            string code,
            bool? hasAvatar,
            string nickName,
            bool? isProtected,
            int minViewCount,
            int maxViewCount,
            bool? isPublic,
            string Sort,
            PagingInfo pagingInfo)
        {
            List<Account> accountlist = new List<Account>();
            SqlServerUtility sql = new SqlServerUtility(connectionString);
            System.Text.StringBuilder sbFilter = new StringBuilder();

            #region Build filter

            sbFilter.Append("1=1 ");

            if (!string.IsNullOrEmpty(name))
            {
                sbFilter.Append(" And [Name] like '%");
                sbFilter.Append(name.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("%'");
            }

            if (gender == 1 || gender == 0)
            {
                sbFilter.Append(" And [Gender] = ");
                sbFilter.Append(gender);
            }

            if (!string.IsNullOrEmpty(bloodType))
            {
                sbFilter.Append(" And BloodType = '");
                sbFilter.Append(bloodType.Replace("'", "").Replace("\"", ""));
                sbFilter.Append(" '");
            }

            if (birthYear > 0)
            {
                sbFilter.Append(" And BirthYear = ");
                sbFilter.Append(birthYear);
            }

            if (birthMonth > 0 && birthMonth < 13)
            {
                sbFilter.Append(" And BirthMonth = ");
                sbFilter.Append(birthMonth);
            }

            if (birthDate > 0 && birthDate < 32)
            {
                sbFilter.Append(" And BirthDate = ");
                sbFilter.Append(birthDate);
            }

            if (hometownCity != null)
            {
                if (hometownCity.Id > 0)
                {
                    sbFilter.Append(" And HometownCityId = ");
                    sbFilter.Append(hometownCity.Id);
                }
            }
            else
            {
                if (homwtownProvince != null && homwtownProvince.Id > 0)
                {
                    sbFilter.Append(" And HometownProvinceId = ");
                    sbFilter.Append(homwtownProvince.Id);
                }
            }

            if (resideCity != null)
            {
                if (resideCity.Id > 0)
                {
                    sbFilter.Append(" And ResideCityId = ");
                    sbFilter.Append(resideCity.Id);
                }
            }
            else
            {
                if (resideProvince != null && resideProvince.Id > 0)
                {
                    sbFilter.Append(" And ResideProvinceId = ");
                    sbFilter.Append(resideProvince.Id);
                }
            }

            if (classInfo != null)
            {
                if (classInfo.Id > 0)
                {
                    sbFilter.Append(" And ClassInfoId = ");
                    sbFilter.Append(classInfo.Id);
                }
            }
            else
            {
                if (grade != null && grade.Id > 0)
                {
                    sbFilter.Append(" And GradeId = ");
                    sbFilter.Append(grade.Id);
                }

                if (major != null)
                {
                    if (major.Id > 0)
                    {
                        sbFilter.Append(" And MajorId = ");
                        sbFilter.Append(major.Id);
                    }
                }
                else
                {
                    if (college != null)
                    {
                        if (college.Id > 0)
                        {
                            sbFilter.Append(" And CollegeId = ");
                            sbFilter.Append(college.Id);
                        }
                    }
                    else
                    {
                        if (university != null && university.Id > 0)
                        {
                            sbFilter.Append(" And UniversityID = ");
                            sbFilter.Append(university.Id);
                        }
                    }
                }
            }

            if (!string.IsNullOrEmpty(code))
            {
                sbFilter.Append(" And Code = '");
                sbFilter.Append(code.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("'");
            }

            if (hasAvatar.HasValue)
            {
                sbFilter.Append(string.Format(" And HasAvatar = '{0}'", hasAvatar.Value ? "1" : "0"));
            }

            if (!string.IsNullOrEmpty(nickName))
            {
                sbFilter.Append(" And NickName = '");
                sbFilter.Append(nickName.Replace("'", "").Replace("\"", ""));
                sbFilter.Append("'");
            }

            if (isProtected.HasValue)
            {
                sbFilter.Append(string.Format(" And IsProtected = '{0}'", isProtected.Value ? "1" : "0"));
            }

            if ((minViewCount > 0) &&
                (maxViewCount > 0) &&
                (minViewCount < maxViewCount))
            {
                sbFilter.Append(string.Format(" And ViewNumber Between {0} and {1} ", minViewCount, maxViewCount));
            }

            if (isPublic.HasValue)
            {
                sbFilter.Append(" And IsPublic = '");
                sbFilter.Append(isPublic.Value ? "1" : "0");
                sbFilter.Append("'");
            }
            //ͨ��������֤�����û�
            sbFilter.Append(" And IsEmailChecked='1'");
            #endregion

            #region BackCode
            /*
            int pageSize = int.MaxValue;
            int pageNumber = 1;
            if (pagingInfo != null)
            {
                pageSize = pagingInfo.PageSize;
                pageNumber = pagingInfo.CurrentPage;
            }

            String Fields1 = "Id,ViewNumber,DateCreated,IsProtected,HasAvatar,IsTeacher,Name,NickName,Code,Credit,IsPublic,BirthYear,BirthMonth," +
                            "BirthDate,Gender,LoveState,HometownProvinceId,HometownCityId,ResideProvinceId,ResideCityId,Birthday,IsEmailChecked," +
                            "Telephone,Email,QQ,MSN,BloodType,Theme,LibUserId,Password,Interest,MajorId,MajorName,CollegeId,CollegeName,UniversityID,UniversityName,GradeId,GradeYear," +
                            "HometownProvinceName,HometownCityName,ResideProvinceName,ResideCityName,IsShow,FriendCount";

            String Fields2 = "Id,Credit,DateCreated,IsProtected,HasAvatar,IsTeacher,IsPublic,ViewNumber,Name,NickName,Code,FriendCount";

            sql.AddParameter("@Tables", SqlDbType.VarChar, "view_account_all");
            sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
            sql.AddParameter("@Fields", SqlDbType.VarChar, Fields2);//"Id"
            sql.AddParameter("@sort", SqlDbType.NVarChar, Sort + " DESC");
            sql.AddParameter("@Filter", SqlDbType.VarChar, sbFilter.ToString());
            sql.AddParameter("@PageNumber", SqlDbType.Int, pageNumber);
            sql.AddParameter("@PageSize", SqlDbType.Int, pageSize);

            SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
            */
            #endregion

            int pageSize = int.MaxValue;
            int pageNumber = 1;
            if (pagingInfo != null)
            {
                pageSize = pagingInfo.PageSize;
                pageNumber = pagingInfo.CurrentPage;
            }

            sql.AddParameter("@PageNum", SqlDbType.Int, pageSize);
            sql.AddParameter("@Num", SqlDbType.Int, pageSize * (pageNumber - 1));

            String Column = "Id,Credit,DateCreated,IsProtected,HasAvatar,IsTeacher,IsPublic,ViewNumber,Name,NickName,Code,(SELECT COUNT(Friendship.Id) FROM Friendship WHERE (Friendship.AccountId = view_account_all.Id) AND (Friendship.IsChecked = 1)) AS FriendCount";
            StringBuilder sbSQL = new StringBuilder();
            sbSQL.Append("SELECT TOP (@PageNum) " + Column + " FROM view_account_all WHERE " + sbFilter.ToString() + " AND [Id] NOT IN ");
            sbSQL.Append("(SELECT TOP (@Num) [Id] FROM view_account_all WHERE " + sbFilter.ToString() + " ORDER BY " + Sort + " DESC) ORDER BY " + Sort + " DESC");

            SqlDataReader reader = sql.ExecuteSqlReader(sbSQL.ToString());

            if (reader != null)
            {
                while (reader.Read())
                {
                    Core.Business.Account account = new Core.Business.Account();

                    if (!reader.IsDBNull(0)) account.Id = reader.GetInt64(0);
                    if (!reader.IsDBNull(1)) account.Credit = reader.GetInt32(1);
                    if (!reader.IsDBNull(2)) account.DateCreated = reader.GetDateTime(2);
                    if (!reader.IsDBNull(3)) account.IsProtected = reader.GetBoolean(3);
                    if (!reader.IsDBNull(4)) account.HasAvatar = reader.GetBoolean(4);
                    if (!reader.IsDBNull(5)) account.IsTeacher = reader.GetBoolean(5);
                    if (!reader.IsDBNull(6)) account.IsPublic = reader.GetBoolean(6);
                    if (!reader.IsDBNull(7)) account.ViewNumber = reader.GetInt64(7);
                    if (!reader.IsDBNull(8)) account.Name = reader.GetString(8);
                    if (!reader.IsDBNull(9)) account.NickName = reader.GetString(9);
                    if (!reader.IsDBNull(10)) account.Code = reader.GetString(10);
                    if (!reader.IsDBNull(11)) account.FriendCount = reader.GetInt32(11);

                    account.MarkOld();
                    accountlist.Add(account);
                }
                reader.Close();
            }

            return accountlist;
        }
Example #54
0
        public ApplicationEligibility IsEligibleToApply(StudentInfo student, University university)
        {
            var eligibilityResult = new ApplicationEligibility();

            if (student.Scores == null)
            {
                eligibilityResult.Message = "You must fill in your scores.";
                return eligibilityResult;
            }

            if (student.Essay == null)
            {
                eligibilityResult.Message = "You must write your essay.";
                return eligibilityResult;
            }

            var totalSat = student.Scores.SatCRResult + student.Scores.SatMathResult + student.Scores.SatWritingResult;

            if (totalSat < university.RequiredSAT)
            {
                eligibilityResult.Message = "You don't meet the SAT score requirement.";
                return eligibilityResult;
            }

            if (student.Scores.CambridgeLevel < university.RequiredCambridgeLevel)
            {
                eligibilityResult.Message = "You don't have the necessary Cambridge Certificate level.";
                return eligibilityResult;
            }
            else if (student.Scores.CambridgeLevel == university.RequiredCambridgeLevel)
            {
                if (student.Scores.CambridgeResult < university.RequiredCambridgeScore)
                {
                    eligibilityResult.Message = "You don't have the necessary Cambridge Certificate result.";
                    return eligibilityResult;
                }
            }

            if (student.Scores.ToeflType == Interapp.Common.Enums.ToeflType.IBT)
            {
                if (student.Scores.ToeflResult < university.RequiredIBTToefl)
                {
                    eligibilityResult.Message = "You don't meet the TOEFL IBT score requirement.";
                    return eligibilityResult;
                }
            }
            else
            {
                if (student.Scores.ToeflResult < university.RequiredPBTToefl)
                {
                    eligibilityResult.Message = "You don't meet the TOEFL PBT score requirement.";
                    return eligibilityResult;
                }
            }

            foreach (var document in university.DocumentRequirements)
            {
                if (!student.Documents.Any(d => d.Name == document.Name))
                {
                    eligibilityResult.Message = "You don't have all the necessary documents.";
                    return eligibilityResult;
                }
            }

            eligibilityResult.Message = "You are eligible to apply for the university.";
            eligibilityResult.IsEligible = true;
            return eligibilityResult;
        }
Example #55
0
 /// <summary>
 /// Create a new University object.
 /// </summary>
 /// <param name="ID">Initial value of Id.</param>
 /// <param name="name">Initial value of Name.</param>
 /// <param name="city">Initial value of City.</param>
 /// <param name="state">Initial value of State.</param>
 public static University CreateUniversity(int ID, string name, string city, string state)
 {
     University university = new University();
     university.Id = ID;
     university.Name = name;
     university.City = city;
     university.State = state;
     return university;
 }