Technologies and methodologies QuizNet Online
|
| Although Quiznet Online was created to aid the developer community as a whole it was also created as a personal project of my own to keep up with technologies and methodologies used in the .Net today. I will list all the technologies and methodologies that are currently being and were used to create Quiznet Online. Actually many of these designs and practices are outlined in the actual quiz contained in Quiznet Online. |
| Outline of Quiznet Online: |
| Consists of SQL Database |
| ASP.NET project |
| Type Dataset project |
| Business Objects project |
| HTML Generator project |
|
Database contains:
| Profile, Role and Membership information |
| 25 Tables, 92 Stored Procedures, 2 Functions |
|
ASP.NET project contains:
| Administration section that contains various Datagrids for Data maintenance Web Class |
| Resource Files (resx) that contain various Email and Error messages |
| Address user control (ascx) that can be reused |
| ASP.NET Master Page that is used in every page of the site |
| Wizard Control is used to create a user |
|
Business Object contains:
| Business Object contains: |
| Cryptography class used for creating the URL that’s imbedded into an email that new users are sent |
| 1 x Abstract Classes and 1 x Interface |
Class members:
| public static class QuizNetSystem |
| static ReadOnlyCollection FindQuestions(String) |
| static ReadOnlyCollection LoadQuestions(String) |
| static QuizNetOnlineDataObjects.QuiznetData.GetTopRankDataTable GetRankings(string) |
| static void SendEmail(string to, string subject, string body, bool includeQuizNet) |
| static void ResendFailedEmails() |
|
| public class UserProfile : QuizObject |
| public string NickName |
| public UserProfile Load(string userName) |
|
| public class UserSetting : QuizObject |
| public bool IsTestTaken |
| public string UserName |
| public bool UnlimitedQuestions |
| public int NumberOfTestsTaken |
| public int NumberOfQuestionsCorrect |
| public int NumberOfQuestionsIncorrect |
| public DateTime DateOfLastTest |
| public UserSetting Load(string userName) |
| public void Save() |
|
| public class TableInformation |
| public static TableInformation Instance |
| public TableInformation() |
| public static QuizNetOnlineDataObjects.QuiznetData.QuestionCountDataTable GetTopicsCount() |
| public int? ContactUs |
| public int? Log |
| public int? Results |
| public int? UserQuestions |
| public int? Comments |
| public int? Errors |
|
| public class Comments |
| public static Comments Instance |
| public int QuestionId |
| public string Comment |
| public string UserName |
| public void Save() |
| public static void ClearComments() |
|
| public abstract class Info |
| public abstract Information Instance |
| public static string Version |
|
| public class Information:Info |
| public override Information Instance |
|
| public class ErrorLog |
| public static ErrorLog Instance |
| public ErrorLog(string errorUserName, string errorLog, string errorDesc, string errorSection) |
| public int ErrId |
| public string ErrUserName |
| public string ErrLog |
| public string ErrDesc |
| public string ErrSection |
| public void Save() |
| public static void ClearErrorLog() |
| public static ReadOnlyCollection LoadErros(string errorSection) |
| public static void DeleteError(int errorId) |
|
| public class Log |
| public static Log Instance |
| public Log(string logip, string logarea) |
| public string LogIP |
| public string LogArea |
| public void Save() |
| public static void ClearLog() |
|
| public class Result |
| public static Result Instance |
| public Result(int resultId) |
| public int? ResultId |
| public DateTime ResultDate |
| public IPAddress IPaddress |
| public Topic Topic |
| public int TotalQuestions |
| public int QuestionsUnanswered |
| public int QuestionsCorrect |
| public int QuestionsIncorrect |
| public int Weight |
| public int Rank |
| public string UserName |
| public string CountryCode |
| public string Location |
| public string Email |
| public void Save(bool _new) |
| public Result LoadResult(int resultId) |
| public Result LoadResult(string UserName) |
| public static void ClearResults() |
| public static int GetRank(int weight, string topicCode) |
| public void CalculateRatings(string topiccode) |
|
| public class Topic |
| public static Topic Instance |
| public string TopicCode |
| public string TopicDesc |
| public int TopicCount |
| public static QuizNetOnlineDataObjects.QuiznetData.TopicDataTable LoadTopics(string topicCode, bool includeMovie) |
| public void LoadTopic(string topicCode) |
| public Topic(string topicCode) |
|
| public class Location |
| public string Country |
| public string City |
| public string Abbrv |
| public Location(string IP) |
|
| public class Answer |
| public int QuestionId |
| public int Value |
| public string AnswerDesc |
| public ReadOnlyCollection LoadAnswers(int questionId) |
|
| public class QuestionImage |
| public int? ImageId |
| public int QuestionId |
| public byte[] Image |
| public void Load(int questionId) |
| public void Save() |
|
| public class Question : IQuestion |
| public Question Instance |
| public int QuestionId |
| public Topic Topic |
| public QuestionImage Image |
| public string QuestionDesc |
| public int Answer |
| public string Explaination |
| public bool Approved |
| public DateTime CreationDate |
| public string Link |
| public int Correct |
| public int Incorrect |
| public string QuestionCreatedBy |
| public ReadOnlyCollection Answers |
| public void Save() |
| public void LoadQuestion(int questionId) |
| public ReadOnlyCollection PopulateAnswers(int questionId) |
| public static int GetTotalQuestionsCount() |
|
|
|