public void loadUserInfo(User user)
{
User u = user;
tbFullName.Text = u.fullname;
tbAddress.Text = u.address;
tbBirthdate.Text = u.birthdate;
tbEmail.Text = u.email;
tbContact.Text = u.contact;
lblCurrentBalance.Text = Convert.ToDouble(u.balance).ToString();
lblTotalExpense.Text = Convert.ToDouble(u.totalExpense).ToString();
}
public AdminUserProfileForm(UsersForm uf, User u)
{
adminView = true;
this.uf = uf;
this.u = u;
InitializeComponent();
gbChangePassword.Visible = false;
gbBalance.Location = new Point(12, 270);
this.Size = new Size(this.Width, 470);
loadUserInfo(u);
disableControls();
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (tbUsername.Text.Trim() == "" || tbPassword.Text == "" || tbConfirmPassword.Text == "")
{
MessageBox.Show("Please enter a username and password correctly.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
if (tbPassword.Text == tbConfirmPassword.Text)
{
if (admin)
{
Admin a = new Admin(0, tbUsername.Text, tbPassword.Text, tbFullName.Text,
tbAddress.Text, tbBirthdate.Text, tbEmail.Text, tbContact.Text);
try
{
Result r = DataServices.SaveAdmin(a, false);
if (r.success == true)
{
MessageBox.Show(r.message, "Result", MessageBoxButtons.OK, MessageBoxIcon.Information);
uf.updateUsers();
this.Dispose();
}
else
{
MessageBox.Show(r.message, "Result", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception x)
{
MessageBox.Show("Error in adding admin: " + x.Message, "Client Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
User u = new User(0, tbUsername.Text, tbPassword.Text, tbFullName.Text,
tbAddress.Text, tbBirthdate.Text, tbEmail.Text, tbContact.Text, DateTime.Today, 0, 0);
try
{
Result r = DataServices.SaveUser(u, false);
if (r.success == true)
{
MessageBox.Show(r.message, "Result", MessageBoxButtons.OK, MessageBoxIcon.Information);
uf.updateUsers();
this.Dispose();
}
else
{
MessageBox.Show(r.message, "Result", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception x)
{
MessageBox.Show("Error in adding user: "******"Client Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("Password did match!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
internal static List<User> searchUsers(string key)
{
List<User> list = new List<User>();
try
{
cmd = new OleDbCommand("SELECT * FROM Users WHERE Username LIKE '%" + key + "%';", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10));
list.Add(u);
}
return list;
}
catch (Exception e)
{
MessageBox.Show("Error getting usersList in searchUsers: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
internal static Result SaveUser(User u, bool update)
{
Result r = new Result();
if (update)
{
cmd = new OleDbCommand("UPDATE Users SET Fullname = ?, Address = ?, Birthdate = ?, Email = ?, Contact = ? WHERE ID = ?;", conn);
try
{
cmd.Parameters.Add("Fullname", OleDbType.VarChar).Value = u.fullname;
cmd.Parameters.Add("Address", OleDbType.VarChar).Value = u.address;
cmd.Parameters.Add("Birthdate", OleDbType.VarChar).Value = u.birthdate;
cmd.Parameters.Add("Email", OleDbType.VarChar).Value = u.email;
cmd.Parameters.Add("Contact", OleDbType.VarChar).Value = u.contact;
cmd.Parameters.Add("ID", OleDbType.Integer).Value = u.id;
cmd.ExecuteNonQuery();
r.success = true;
r.message = "Updating User Information Successful!";
}
catch (Exception e)
{
MessageBox.Show("Error Occured: " + e.Message + " : " + e.Source, "Server Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
r.success = false;
r.message = "Updating User Information Failed!";
}
}
else
{
List<User> usersList = GetUsers();
foreach (User user in usersList)
{
if (user.username == u.username)
{
r.success = false;
r.message = "Username is already taken.";
return r;
}
}
cmd = new OleDbCommand("INSERT INTO Users (Username, [Password], Fullname, Address, Birthdate, Email, Contact, DateRegistered) VALUES(?, ?, ?, ?, ?, ?, ?, ?)", conn);
try
{
cmd.Parameters.Add("Username", OleDbType.VarChar).Value = u.username;
cmd.Parameters.Add("Password", OleDbType.VarChar).Value = u.password;
cmd.Parameters.Add("Fullname", OleDbType.VarChar).Value = u.fullname;
cmd.Parameters.Add("Address", OleDbType.VarChar).Value = u.address;
cmd.Parameters.Add("Birthdate", OleDbType.VarChar).Value = u.birthdate;
cmd.Parameters.Add("Email", OleDbType.VarChar).Value = u.email;
cmd.Parameters.Add("Contact", OleDbType.VarChar).Value = u.contact;
cmd.Parameters.Add("DateRegistered", OleDbType.Date).Value = u.dateregistered;
cmd.ExecuteNonQuery();
r.success = true;
r.message = "Adding User Successful!";
}
catch (Exception e)
{
MessageBox.Show("Error Occured: " + e.Message + " : " + e.Source, "Server Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
r.success = false;
r.message = "Adding User Failed!";
}
}
return r;
}
internal static List<User> GetUsers()
{
List<User> usersList = new List<User>();
try
{
cmd = new OleDbCommand("SELECT * FROM Users ORDER BY ID;", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10));
usersList.Add(u);
}
reader.Close();
return usersList;
}
catch (Exception e)
{
MessageBox.Show("Error getting usersList: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
internal static Result addBalance(User u, double balance)
{
Result r = new Result();
double newBalance = u.balance + balance;
double newTotalExpense = u.totalExpense + balance;
try
{
cmd = new OleDbCommand("UPDATE Users SET CurrentBalance = ?, TotalExpense = ? WHERE Username = ?", conn);
cmd.Parameters.Add("CurrentBalance", OleDbType.Integer).Value = newBalance;
cmd.Parameters.Add("TotalExpense", OleDbType.Integer).Value = newTotalExpense;
cmd.Parameters.Add("Username", OleDbType.VarChar).Value = u.username;
cmd.ExecuteNonQuery();
r.success = true;
r.message = "Adding balance successful!";
}
catch (Exception e)
{
r.success = false;
r.message = "Adding balance failed! " + e.Message;
}
return r;
}
public Result SaveUser(User u)
{
Result r = new Result();
cmd = new OleDbCommand("UPDATE Users SET Fullname = ?, Address = ?, Birthdate = ?, Email = ?, Contact = ? WHERE ID = ?;", conn);
try
{
cmd.Parameters.Add("Fullname", OleDbType.VarChar).Value = u.fullname;
cmd.Parameters.Add("Address", OleDbType.VarChar).Value = u.address;
cmd.Parameters.Add("Birthdate", OleDbType.VarChar).Value = u.birthdate;
cmd.Parameters.Add("Email", OleDbType.VarChar).Value = u.email;
cmd.Parameters.Add("Contact", OleDbType.VarChar).Value = u.contact;
cmd.Parameters.Add("ID", OleDbType.Integer).Value = u.id;
cmd.ExecuteNonQuery();
r.success = true;
r.message = "Updating User Information Successful!";
}
catch (Exception e)
{
MessageBox.Show("Error Occured: " + e.Message + " : " + e.Source, "Server Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
r.success = false;
r.message = "Updating User Information Failed!";
}
return r;
}
public Result getUserInfo(string username)
{
Result r = new Result();
try
{
cmd = new OleDbCommand("SELECT * FROM Users WHERE Username = ?;", conn);
cmd.Parameters.Add("Username", OleDbType.VarChar).Value = username;
reader = cmd.ExecuteReader();
if (reader.Read())
{
User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10));
r.user = u;
r.success = true;
}
return r;
}
catch (Exception e)
{
MessageBox.Show("Error getting userInfo: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
public void updateInfo()
{
List<User> usersList = DataServices.GetUsers();
foreach (User user in usersList)
{
if (u.username == user.username)
{
this.u = user;
loadUserInfo(u);
}
}
}
