private void CreateAccountButton_Click(object sender, RoutedEventArgs e)
{
if (CheckInputs() == true)
{
if (AccountType.SelectedIndex == 4)
{
priv = "6";
if (Priv1.IsChecked == true)
{
priv += "2";
}
if (Priv2.IsChecked == true)
{
priv += "3";
}
if (Priv3.IsChecked == true)
{
priv += "4";
}
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string uid = Application.Current.Resources["uid"].ToString();
string[] dt = pmsutil.GetServerDateTime().Split(null);
DateTime cDate = Convert.ToDateTime(dt[0]);
DateTime cTime = DateTime.Parse(dt[1] + " " + dt[2]);
string curDate = cDate.ToString("yyyy-MM-dd");
string curTime = cTime.ToString("HH:mm:ss");
string accID = pmsutil.GenAccountID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts(account_id, user_name, pass_key, account_type)" +
"VALUES(@account_id, @user_name, @pass_key, @account_type)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@pass_key", SecurePasswordHasher.Hash(Password.Text));
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(priv));
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts_info(account_id, name, date_created, time_created, creator)" +
"VALUES(@account_id, @emp_name, @date_created, @time_created, @creator)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@emp_name", Username.Text);
cmd.Parameters.AddWithValue("@date_created", curDate);
cmd.Parameters.AddWithValue("@time_created", curTime);
cmd.Parameters.AddWithValue("@creator", uid);
stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
_caller.SyncAccounts();
MsgSuccess();
pmsutil.LogAccount("Created an account - Username: "******" Type: " + Convert.ToInt32(priv));
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
else
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string uid = Application.Current.Resources["uid"].ToString();
string[] dt = pmsutil.GetServerDateTime().Split(null);
DateTime cDate = Convert.ToDateTime(dt[0]);
DateTime cTime = DateTime.Parse(dt[1] + " " + dt[2]);
string curDate = cDate.ToString("yyyy-MM-dd");
string curTime = cTime.ToString("HH:mm:ss");
string accID = pmsutil.GenAccountID();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts(account_id, user_name, pass_key, account_type)" +
"VALUES(@account_id, @user_name, @pass_key, @account_type)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@user_name", Username.Text);
cmd.Parameters.AddWithValue("@pass_key", SecurePasswordHasher.Hash(Password.Text));
cmd.Parameters.AddWithValue("@account_type", Convert.ToInt32(AccountType.SelectedIndex + 1));
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText =
"INSERT INTO accounts_info(account_id, name, date_created, time_created, creator)" +
"VALUES(@account_id, @emp_name, @date_created, @time_created, @creator)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@account_id", accID);
cmd.Parameters.AddWithValue("@emp_name", Username.Text);
cmd.Parameters.AddWithValue("@date_created", curDate);
cmd.Parameters.AddWithValue("@time_created", curTime);
cmd.Parameters.AddWithValue("@creator", uid);
stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
MsgSuccess();
pmsutil.LogAccount("Created an account - Username: "******" Type: " + Convert.ToInt32(priv));
this.Close();
}
else
{
MsgFail();
}
}
else
{
}
}
}
}
else
{
}
}
