public bool SignIn()
{
DataTable result = null;
bool res = false;
try
{
result = db.ExecuteQuery(String.Format("EXECUTE dbo.users_sign_in {0}, {1}", this.name, this.passwd));
}
catch (SqlException e)
{
throw e;
}
catch (Exception e)
{
throw e;
}
finally
{
if (result != null)
{
if (result.Rows.Count == 1)
{
if ((int)result.Rows[0]["RESULT"] == 1)
res = true;
result.Dispose();
}
}
}
return res;
}
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();
}
}
