public Group(DBDriver db, int id, string name, string registrationDate) { this.db = db; this.id = id; this.name = name; this.registrationDate = registrationDate; }
public User( DBDriver db, int id, string name, string passwd, string realName, string email, AdditionalContacts additionalContacts, string lastLoginDate, string registrationDate, string lastEditDate, int roleId, int groupId ) { this.db = db; this.id = id; this.name = name; this.passwd = passwd; this.realName = realName; this.email = email; this.additionalContacts = additionalContacts; this.registrationDate = registrationDate; this.lastEditDate = lastEditDate; this.lastLoginDate = lastLoginDate; this.roleId = roleId; this.groupId = groupId; }
public Answer(DBDriver db, int id, string answerText, bool rightAnswer, int parentId, int questionId, bool training) { this.db = db; this.id = id; this.answerText = answerText; this.rightAnswer = rightAnswer; this.parentId = parentId; this.questionId = questionId; this.training = training; }
public Test(DBDriver db, int id, string name, string lastEditDate, string creationDate, int subjectId, int questionNum) { this.db = db; this.id = id; this.name = name; this.lastEditDate = lastEditDate; this.creationDate = creationDate; this.subjectId = subjectId; this.questionNum = questionNum; }
public Question(DBDriver db, int id, string questionText, bool active, int questionTypeId, int testId, int answerNum, int categoryId) { this.db = db; this.id = id; this.questionText = questionText; this.active = active; this.questionTypeId = questionTypeId; this.testId = testId; this.answerNum = answerNum; this.categoryId = categoryId; }
public static DataTable GetSubjectsDataTable(DBDriver db) { try { return db.ExecuteQuery(String.Format(@"SELECT * FROM subjects order by id")); } catch(Exception e) { MessageBox.Show(e.Message); return null; } }
static public DataTable GetGroupsDataTable(DBDriver db) { try { return(db.ExecuteQuery(String.Format(@"SELECT * FROM groups order by id"))); } catch (Exception e) { MessageBox.Show(e.Message); return(null); } }
public User_test(DBDriver db, int id_user, int id_test, int numberOfTries, float mark, bool ifAvailable, DateTime testTime, bool canSkip, bool canBack, int testContinuesTime) { this.db = db; this.id_user = id_user; this.id_test = id_test; this.numberOfTries = numberOfTries; this.mark = mark; this.ifAvailable = ifAvailable; this.testTime = testTime; this.canSkip = canSkip; this.canBack = canBack; this.testContinuesTime = testContinuesTime; }
static void Main(string[] args) { DBDriver db = new DBDriver(@"SQL5016.Smarterasp.net", @"DB_9D003D_cts1_admin", @"cts1CoolDbUser", @"db_9d003d_cts1"); Console.WriteLine("Created Object DBDriver with Connection String: " + db.ConnString); User user = new User(db); try { Console.WriteLine("New Empty User instance: \n" + user); user.Name = "my_new_user_vasya"; user.Password = "******"; user.RealName = "Василий Пупкин"; user.RoleId = 1; user.GroupId = 1; user.Email = "*****@*****.**"; Console.WriteLine("User Created: \n" + (user = user.Create())); Console.WriteLine("Check if User 'my_new_user_vasya' with password '123456' exists: " + user.CheckIfExists()); Console.WriteLine("Login Under User 'my_new_user_vasya' with password '123456'" + user.SignIn()); Console.WriteLine("Get user with this id from database: \n" + (user = user.Get(user.Id))); user.RealName = "Не Василий Не Пупкин"; user.AddContact("skype", "vasya_pupkin"); user.AddContact("twitter", "vasya_twitter"); user.Update(); Console.WriteLine("Update user with current id: \n" + (user = user.Update())); user.ChangePassword("123456789"); Console.WriteLine("Changed Paddword for user with current id: \n" + (user = user.Get(user.Id))); user.Delete(); } catch (Exception e) { throw e; } finally { user.Delete(); } }
public User( DBDriver db, string name, string passwd, string realName, string email, AdditionalContacts additionalContacts, int roleId, int groupId ) { this.db = db; this.name = name; this.passwd = passwd; this.realName = realName; this.email = email; this.additionalContacts = additionalContacts; this.roleId = roleId; this.groupId = groupId; }
static public DataTable GetQuestionsDataTableByTestId(DBDriver db, int testId) { return(db.ExecuteQuery(String.Format(@"SELECT * FROM questions WHERE test_id = {0}", testId))); }
static public DataTable GetTestsDataTable(DBDriver db) { return(db.ExecuteQuery(String.Format(@"SELECT * FROM tests"))); }
public Test(DBDriver db) { this.db = db; }
public Group(DBDriver db, int id, string name) { this.db = db; this.id = id; this.name = name; }
public Group(DBDriver db) { this.db = db; }
public Subject(DBDriver db, int id, string name) { this.db = db; this.id = id; this.name = name; }
public Subject(DBDriver db) { this.db = db; }
public User(DBDriver db) { this.db = db; }
static public DataTable GetTutorsDataTable(DBDriver db) { //return db.ExecuteQuery(String.Format(@"SELECT users.id, users.real_name, users.name, users.passwd, users.email, users.additional_contats, users.last_login_date, users.registration_date, users.last_edit_date, groups.name as 'group_name' FROM users, groups WHERE users.role_id = 2")); return(db.ExecuteQuery(String.Format(@"SELECT users.id, users.real_name, users.name, users.passwd, users.email, users.additional_contacts, users.last_login_date, users.registration_date, users.last_edit_date, users.group_id FROM users WHERE users.role_id = 2"))); }
public User_test(DBDriver db) { this.db = db; }
static public DataTable GetAppointedTestForUser(DBDriver db, int userId) { return(db.ExecuteQuery(String.Format(@"SELECT test_id, mark, test_time FROM users_tests WHERE user_id = {0}", userId))); }
public static DataTable GetAnswersDataTableByQuestionId(DBDriver db, int questionId) { return db.ExecuteQuery(String.Format(@"SELECT * FROM answers WHERE question_id = {0}", questionId)); }
public static DataTable GetTestsDataTableBySubjectId(DBDriver db, int subjectId) { return db.ExecuteQuery(String.Format(@"SELECT * FROM tests WHERE subject_id = {0}", subjectId)); }
public Question(DBDriver db) { this.db = db; }
public Subject(DBDriver db, string name) { this.db = db; this.name = name; }
public Group(DBDriver db, string name) { this.db = db; this.name = name; }
static public DataTable GetAnswersDataTableByQuestionId(DBDriver db, int questionId) { return(db.ExecuteQuery(String.Format(@"SELECT * FROM answers WHERE question_id = {0}", questionId))); }
public Answer(DBDriver db) { this.db = db; }
static public DataTable GetTestsDataTableBySubjectId(DBDriver db, int subjectId) { return(db.ExecuteQuery(String.Format(@"SELECT * FROM tests WHERE subject_id = {0}", subjectId))); }
public static DataTable GetTutorsDataTable(DBDriver db) { //return db.ExecuteQuery(String.Format(@"SELECT users.id, users.real_name, users.name, users.passwd, users.email, users.additional_contats, users.last_login_date, users.registration_date, users.last_edit_date, groups.name as 'group_name' FROM users, groups WHERE users.role_id = 2")); return db.ExecuteQuery(String.Format(@"SELECT users.id, users.real_name, users.name, users.passwd, users.email, users.additional_contacts, users.last_login_date, users.registration_date, users.last_edit_date, users.group_id FROM users WHERE users.role_id = 2")); }
public static DataTable GetUsersDataTable(DBDriver db) { return db.ExecuteQuery(String.Format(@"SELECT * FROM users")); }
public static DataTable GetAppointedTestForUser(DBDriver db, int userId) { return db.ExecuteQuery(String.Format(@"SELECT test_id, mark, test_time FROM users_tests WHERE user_id = {0}", userId)); }
public static DataTable GetQuestionsDataTableByTestId(DBDriver db, int testId) { return db.ExecuteQuery(String.Format(@"SELECT * FROM questions WHERE test_id = {0}", testId)); }