public Employee(User user)
{
User_id = user.UserId;
Position = user.getUserLevel();
user.Dispose();
}
public Employee getEmployeeFromUserId(User user){
string condition = String.Format("user_id = '{0}'", user.UserId);
Employee employee = new Employee(getEntityWhere(condition));
employee.Position = user.getUserLevel();
return employee;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (userAdministration.usernames.Contains(txtUsername.Text) && mode != UserAdminMode.Edit_user){
MessageBox.Show(String.Format("The username {0} did already exists!", txtUsername.Text));
txtUsername.Focus();
txtUsername.SelectAll();
return;
}
else if (txtPassword.Text != txtRepassword.Text)
{
MessageBox.Show("Passwords didn't match!");
txtPassword.Focus();
txtRepassword.Clear();
return;
}
if (hasPictureChanged)
saveImage();
User user = new User()
{
UserId = txtUsername.Text,
Password = txtPassword.Text,
userLevel = domainPosition.Text
};
Employee employee = new Employee(user)
{
Firstname = txtFirstname.Text,
MiddleName = txtMiddlename.Text,
Lastname = txtLastname.Text,
MobileNo = txtMobno.Text,
EmailAddress = textBox2.Text,
TelNo = txtTelno.Text,
ImagePath = txtImagepath.Text,
Address = txtAddress.Text
};
MessageBanner banner;
if (mode == UserAdminMode.Add_user)
{
dbController.createUserEmployee(user, employee);
banner = new MessageBanner(string.Format("New User was added: {0}", user.UserId), 2000);
banner.Show();
// audit
string action = string.Format("added new User {0}", user.UserId);
dbController.insertAuditTrail(action);
}
else if (mode == UserAdminMode.Edit_user)
{
dbController.updateEmployee(currentEmployee, employee);
banner = new MessageBanner(String.Format("User {0} was updated",employee.User_id), 2000);
banner.Show();
// audit
string action = string.Format("updated User {0}", employee.User_id);
dbController.insertAuditTrail(action);
}
this.disappear();
}
public void createUserEmployee(User user, Employee employee)
{
string insertUser = userMapper.createUser(user);
string insertEmployee = employeeMapper.createEmployee(employee);
if (createTransaction(insertUser, insertEmployee)){
EntityArgs e = new EntityArgs(employee);
OnInsertEntity(e);
}
user.Dispose();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (Validation.isFilled(panel_AddUser, txtMiddlename, txtPassword, txtRepassword))
{
if (mode == UserAdminMode.Add_user)
{
if (string.IsNullOrWhiteSpace(txtPassword.Text) || string.IsNullOrWhiteSpace(txtRepassword.Text))
{
MessageBanner banner0 = new MessageBanner("Please fill up all the fields and try again.", 2000);
banner0.BackColor = System.Drawing.Color.DarkRed;
banner0.ForeColor = System.Drawing.Color.White;
banner0.Opacity = 1;
banner0.Show();
return;
}
}
if (userAdministration.usernames.Contains(txtUsername.Text) && mode != UserAdminMode.Edit_user)
{
MessageBox.Show(String.Format("The username {0} did already exists!", txtUsername.Text));
txtUsername.Focus();
txtUsername.SelectAll();
return;
}
else if (txtPassword.Text != txtRepassword.Text)
{
MessageBox.Show("Passwords didn't match!");
txtPassword.Focus();
txtRepassword.Clear();
return;
}
if (hasPictureChanged)
saveImage();
User user = new User()
{
UserId = txtUsername.Text,
Password = txtPassword.Text,
userLevel = domainPosition.Text,
Squery = SelectedIndex(cmbSquery.SelectedIndex),
FBAnswer = txtAnswer.Text,
};
Employee employee = new Employee(user)
{
Firstname = txtFirstname.Text,
MiddleName = txtMiddlename.Text,
Lastname = txtLastname.Text,
MobileNo = txtMobno.Text,
EmailAddress = textBox2.Text,
TelNo = txtTelno.Text,
ImagePath = txtImagepath.Text,
Address = txtAddress.Text
};
MessageBanner banner;
if (mode == UserAdminMode.Add_user)
{
dbController.createUserEmployee(user, employee);
banner = new MessageBanner(string.Format("New User was added: {0}", user.UserId), 2000);
banner.Show();
// audit
string action = string.Format("added new User {0}", user.UserId);
dbController.insertAuditTrail(action);
}
else if (mode == UserAdminMode.Edit_user)
{
dbController.updateEmployee(currentEmployee, employee);
banner = new MessageBanner(String.Format("User {0} was updated", employee.User_id), 2000);
banner.Show();
// audit
string action = string.Format("updated User {0}", employee.User_id);
dbController.insertAuditTrail(action);
}
this.disappear();
}
else
{
MessageBanner banner1 = new MessageBanner("Please fill up all the fields and try again.", 2000);
banner1.BackColor = System.Drawing.Color.DarkRed;
banner1.ForeColor = System.Drawing.Color.White;
banner1.Opacity = 1;
banner1.Show();
}
}
public void createUser(User user)
{
userMapper.createUser(user);
}
public bool removeUser(User user)
{
if (userMapper.inactivateUser(user)){
EntityArgs e = new EntityArgs(user);
OnDeleteEntity(e);
return true;
}
return false;
}
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
user = dbController.authenticateUser(Username, Password);
backgroundWorker1.ReportProgress(100);
}
public Employee getEmployeeFromUser(User user)
{
return employeeMapper.getEmployeeFromUserId(user);
}
// MasterController masterController;
public LoginTrail(User user)
{
this.currentUser = user;
}
public bool isAlreadyLogin(User user)
{
return userMapper.isAlreadyLogin(user);
}
public bool isAlreadyLogin(User user)
{
string condition = string.Format("id = '{0}' && session_status = 1", user.UserId);
object foo = readScalar("session_status", condition);
if (foo != null)
return true;
else
return false;
}
public bool inactivateUser(User user)
{
string condition = String.Format("id = '{0}'", user);
return update(updateSet(condition, "active = 0"));
}
public string createUser(User user)
{
return insertValues(user.UserId, PasswordHash.PasswordHash.CreateHash(user.Password), user.getUserLevel().ToString(), ACTIVE , "NOW()", 0, user.Squery, PasswordHash.PasswordHash.CreateHash(user.FBAnswer));
}
public bool updateSquery(User oldSquery, User newSquery)
{
if (oldSquery.UserId != newSquery.UserId)
return false;
int updateSquery;
string updateAns;
if (!string.IsNullOrWhiteSpace(Convert.ToString(newSquery.Squery)))
updateSquery = Convert.ToInt32(String.Format("fallbackid = {0}", newSquery.Squery));
if (!string.IsNullOrWhiteSpace(newSquery.FBAnswer))
updateAns = String.Format("fallbackans = '{0}'", newSquery.FBAnswer);
string condition = String.Format("id = '{0}'", newSquery.UserId);
//What to do when parameters contains non-string inputs (update)?
//return update(updateSet(condition, updateSquery, updateAns));
return false;
}
public UserArgs(User user)
{
User = user;
}
