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 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 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 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;
}
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 Subject(DBDriver db, int id, string name)
{
this.db = db;
this.id = id;
this.name = name;
}
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 User_test(DBDriver db)
{
this.db = db;
}
public Subject(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;
}
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;
}
static public DataTable GetAnswersDataTableByQuestionId(DBDriver db, int questionId)
{
return(db.ExecuteQuery(String.Format(@"SELECT * FROM answers WHERE question_id = {0}", questionId)));
}
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;
}
public Answer(DBDriver db)
{
this.db = db;
}
public User(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 Question(DBDriver db)
{
this.db = db;
}
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 Test(DBDriver db)
{
this.db = db;
}
public static DataTable GetQuestionsDataTableByTestId(DBDriver db, int testId)
{
return db.ExecuteQuery(String.Format(@"SELECT * FROM questions WHERE test_id = {0}", testId));
}
public Answer(DBDriver db)
{
this.db = db;
}
