private void CmdAddUser_OnClick(object sender, RoutedEventArgs e)
{
// check exist user if update
TemplateMyUsersDataBase u = MainWindow.SqliteSource.GetUserEdit(TxtUser.Text);
// existe usuario update
if (TxtUser.Text != string.Empty && TxtPw.Password != string.Empty &&
MainWindow.SqliteSource.CheckUserExist(TxtUser.Text))
{
if (TxtUser.Text != u.User || TxtPw.Password != u.Password || TxtOwner.Text != u.Owner)
{
// update algum valor alterado
MainWindow.SqliteSource.UpdateUserIn(TxtUser.Text, TxtPw.Password, TxtOwner.Text, u.User);
}
}
// cria novo usuario
if (TxtUser.Text != string.Empty && TxtPw.Password != string.Empty && !MainWindow.SqliteSource.CheckUserExist(TxtUser.Text))
{
MainWindow.SqliteSource.CreatUser(TxtUser.Text, TxtPw.Password, TxtOwner.Text);
this.ShowMessageAsync(@"Sucess", @"User created");
}
// refresh list user
ListUserInDataBase();
// clear txt
TxtUser.Text = string.Empty;
TxtPw.Password = string.Empty;
TxtOwner.Text = string.Empty;
TxtUser.Focus();
}
private void CmdRemoveUser_OnClick(object sender, RoutedEventArgs e)
{
TemplateMyUsersDataBase u = MainWindow.SqliteSource.GetUserEdit(TxtUser.Text);
if (u == null)
{
return;
}
// check password
if (TxtPw.Password != u.Password || TxtUser.Text != u.User || TxtOwner.Text != u.Owner && MainWindow.SqliteSource.CheckUserExist(TxtUser.Text))
{
return;
}
MainWindow.SqliteSource.DeleteUser(TxtUser.Text);
// refresh list user
ListUserInDataBase();
// clear txt
TxtUser.Text = string.Empty;
TxtPw.Password = string.Empty;
TxtOwner.Text = string.Empty;
TxtUser.Focus();
this.ShowMessageAsync(@"Sucess", @"User deleted");
}
private void ListUser_OnMouseDoubleClick(object sender, MouseButtonEventArgs e)
{
if (ListUser.SelectedItem != null)
{
TemplateMyUsersDataBase user = MainWindow.SqliteSource.GetUserEdit(ListUser.SelectedItem.ToString());
// load
TxtUser.Text = user.User;
TxtPw.Password = user.Password;
TxtOwner.Text = user.Owner;
}
}
/// <summary>
/// list all users in database
/// </summary>
/// <returns></returns>
public List <TemplateMyUsersDataBase> GetListMyUsersDataBase()
{
List <TemplateMyUsersDataBase> myUsersDataBases = new List <TemplateMyUsersDataBase>();
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed)
{
Connection.Close();
}
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = @"SELECT user , password , owner FROM myusers";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
TemplateMyUsersDataBase t = new TemplateMyUsersDataBase()
{
User = DataReader["user"].ToString(),
Password = DataReader["password"].ToString(),
Owner = DataReader["owner"].ToString()
};
myUsersDataBases.Add(t);
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
}
finally
{
if (Connection.State != ConnectionState.Closed)
{
Connection.Close();
}
}
return(myUsersDataBases);
}
/// <summary>
/// retorna o usuario para ser editado ou deletado
/// </summary>
/// <returns></returns>
/// <param name="user">user nick</param>
internal TemplateMyUsersDataBase GetUserEdit(string user)
{
TemplateMyUsersDataBase t = new TemplateMyUsersDataBase();
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed)
{
Connection.Close();
}
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = @"SELECT user, password , owner FROM myusers WHERE user ='******'";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
t.User = DataReader["user"].ToString();
t.Password = DataReader["password"].ToString();
t.Owner = DataReader["owner"].ToString();
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
return(null);
}
finally
{
if (Connection.State != ConnectionState.Closed)
{
Connection.Close();
}
}
return(t);
}
/// <summary>
/// retorna o usuario para ser editado ou deletado
/// </summary>
/// <returns></returns>
/// <param name="user">user nick</param>
internal TemplateMyUsersDataBase GetUserEdit(string user)
{
TemplateMyUsersDataBase t = new TemplateMyUsersDataBase();
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = @"SELECT user, password , owner FROM myusers WHERE user ='******'";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
t.User = DataReader["user"].ToString();
t.Password = DataReader["password"].ToString();
t.Owner = DataReader["owner"].ToString();
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
return null;
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
return t;
}
/// <summary>
/// list all users in database
/// </summary>
/// <returns></returns>
public List<TemplateMyUsersDataBase> GetListMyUsersDataBase()
{
List<TemplateMyUsersDataBase> myUsersDataBases = new List<TemplateMyUsersDataBase>();
string file = AppDomain.CurrentDomain.BaseDirectory +
"Database\\Shamia.db";
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
Connection = new SQLiteConnection("Data Source=" + file + ";Version=3" +
";New=False;Compress=True");
try
{
Connection.Open();
C = Connection.CreateCommand();
C.CommandText = @"SELECT user , password , owner FROM myusers";
DataReader = C.ExecuteReader();
while (DataReader.Read())
{
TemplateMyUsersDataBase t = new TemplateMyUsersDataBase()
{
User = DataReader["user"].ToString(),
Password = DataReader["password"].ToString(),
Owner = DataReader["owner"].ToString()
};
myUsersDataBases.Add(t);
}
}
catch (Exception ex)
{
MyDelegates.OnDebugMessageCallBack(ex.StackTrace);
}
finally
{
if (Connection.State != ConnectionState.Closed) { Connection.Close(); }
}
return myUsersDataBases;
}
