public void insertTimeout(Employee employee)
{
int last_id = int.Parse(readScalar("id", "1 = 1 ORDER BY datetime_in DESC").ToString());
string condition = String.Format("user_id = '{0}' AND id = {1}", employee.User_id, last_id);
string set = "datetime_out = NOW()";
update(updateSet(condition, set));
}
public void appearWithUser(Employee employee){
if (employee.Position == UserLevel.ADMIN)
loginName.ForeColor = Color.Gold;
else
loginName.ForeColor = Color.White;
accessLoginName = employee.User_id;
if (System.IO.File.Exists(@employee.ImagePath))
accessLoginImage = Randy.GraphicsLibrary.Renderer.resizeImage(Image.FromFile(@employee.ImagePath) as Bitmap, panelImage.Width, panelImage.Height) as Image;
else
accessLoginImage = null;
appear(DockStyle.Fill);
}
public void showUser(Employee employee)
{
lblName.Text = employee.Firstname + " " + employee.MiddleName + " " + employee.Lastname;
lblPosition.Text = employee.Position.ToString();
lblMobileno.Text = employee.MobileNo.ToString();
lblTelno.Text = employee.TelNo.ToString();
lblEmailadd.Text = employee.EmailAddress.ToString();
lblRegistrationdate.Text = employee.RegisteredDate.ToLongDateString();
lblUsername.Text = employee.User_id;
lblAddress.Text = employee.Address;
if (File.Exists(@employee.ImagePath))
userImage.Image = Renderer.resizeImage(Image.FromFile(@employee.ImagePath) as Bitmap, userImage.Width, userImage.Height) as Image;
else
userImage.Image = Renderer.resizeImage(Properties.Resources.userBlack, userImage.Width, userImage.Height) as Image;
}
public bool updateEmployee(Employee oldE, Employee newE){
// Make sure that the employee have the same user_id
if (oldE.User_id != newE.User_id)
return false;
string updateFirstname, updateMiddlename, updateLastname, updateMobileno, updateTelno, updateEmailAdd, updateAddress, updateImagepath;
updateFirstname = updateMiddlename = updateLastname = updateMobileno = updateTelno = updateEmailAdd = updateAddress = updateAddress = updateImagepath = "";
if (oldE.Firstname != newE.Firstname && !String.IsNullOrEmpty(newE.Firstname))
updateFirstname = String.Format("firstname = '{0}'", newE.Firstname);
if (oldE.MiddleName != newE.MiddleName && !String.IsNullOrEmpty(newE.MiddleName))
updateMiddlename = String.Format("middlename = '{0}'", newE.MiddleName);
if (oldE.Lastname != newE.Lastname && !String.IsNullOrEmpty(newE.Lastname))
updateLastname = String.Format("lastname = '{0}'", newE.Lastname);
if (oldE.MobileNo != newE.MobileNo && !String.IsNullOrEmpty(newE.MobileNo))
updateMobileno = String.Format("mobile_no = '{0}'", newE.MobileNo);
if (oldE.TelNo != newE.TelNo && !String.IsNullOrEmpty(newE.TelNo))
updateTelno = String.Format("telephone_no = '{0}'", newE.TelNo);
if (oldE.EmailAddress != newE.EmailAddress && !String.IsNullOrEmpty(newE.EmailAddress))
updateEmailAdd = string.Format("email_address = '{0}'", newE.EmailAddress);
if (oldE.Address != newE.Address && !String.IsNullOrEmpty(newE.Address))
updateAddress = String.Format("address = '{0}'", newE.Address);
if (oldE.ImagePath != newE.ImagePath && !String.IsNullOrEmpty(newE.ImagePath))
updateImagepath = String.Format("image_path = '{0}'", newE.ImagePath);
string condition = String.Format("user_id = '{0}'", newE.User_id);
return update(
updateSet(condition, updateFirstname, updateMiddlename,
updateLastname, updateMobileno, updateTelno, updateEmailAdd, updateAddress,
formatImagePath(updateImagepath))
);
}
public void init(UserAdminMode mode)
{
txtFirstname.Focus();
masterController.setFormReturnkey = btnSave;
this.mode = mode;
hasPictureChanged = false;
if (mode == UserAdminMode.Add_user)
{
clearTextboxes();
togglePasswordInputs(true);
updateStatus("You are creating a New User", SystemColors.menuLightBlue);
}
else if (mode == UserAdminMode.Edit_user)
{
togglePasswordInputs(false);
updateStatus("You are updating an Existing User", SystemColors.menuBarBlue);
currentEmployee = userAdministration.selectedEmployee;
txtLastname.Text = currentEmployee.Lastname;
txtFirstname.Text = currentEmployee.Firstname;
txtMiddlename.Text = currentEmployee.MiddleName;
txtMobno.Text = currentEmployee.MobileNo;
txtUsername.Text = currentEmployee.User_id;
txtImagepath.Text = currentEmployee.ImagePath;
txtAddress.Text = currentEmployee.Address;
domainPosition.Text = currentEmployee.Position.ToString();
if (File.Exists(currentEmployee.ImagePath))
imageUser.Image = Renderer.resizeImage(Image.FromFile(currentEmployee.ImagePath) as Bitmap, imageUser.Width, imageUser.Height) as Image;
else
imageUser.Image = null;
}
}
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;
}
public string createEmployee(Employee employee)
{
return insertValues(employee.User_id, employee.Firstname, employee.MiddleName, employee.Lastname, employee.MobileNo, employee.TelNo, employee.EmailAddress , employee.Address, formatImagePath(employee.ImagePath));
}
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 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();
}
public string createEmployee(Employee employee)
{
return employeeMapper.createEmployee(employee);
}
public void insertTimeIn(Employee employee)
{
insertQuery = String.Format("INSERT INTO login_trail_tbl(user_id) VALUES('{0}')",employee.User_id);
create(insertQuery);
}
public bool insertAuditTrail(Employee employee, string action, DateTime date)
{
return create(
insertValues(employee.User_id, action, MyExtension.MySqlToCSharp.convertDate(date), MyExtension.MySqlToCSharp.convertTime(date))
);
}
public void insertTimeIn(Employee employee)
{
insertQuery = String.Format("INSERT INTO login_trail_tbl(user_id, datetime_in) VALUES('{0}' ,'{1}')", employee.User_id, MyExtension.MySqlToCSharp.convertDateTime(DateTime.Now));
create(insertQuery);
}
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 updateEmployee(Employee oldE, Employee newE)
{
if (employeeMapper.updateEmployee(oldE, newE))
{
EntityArgs e = new EntityArgs(newE);
OnUpdateEntity(e);
}
}
void viewUser()
{
try
{
if (addUserPane != null && addUserPane.IsDirty)
{
DialogResult result = MessageBox.Show("There are seems unsaved work.. Are you sure you want to continue?",
"You are going to leave unsave work", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.No)
return;
else
addUserPane.clearTextboxes();
}
if (mode != UserAdminMode.View_user)
{
userView = new UserView(userPanel, masterController);
mode = UserAdminMode.View_user;
flipColors();
}
lbUsers.Focus();
selectedEmployee = userEmployeeMap[lbUsers.SelectedItem.ToString()];
userView.showUser(selectedEmployee);
}
catch (NullReferenceException)
{
if (lbUsers.SelectedItem == null)
MessageBox.Show("No selected user.. ");
}
}
public EmployeeArgs(Employee e)
{
employee = e;
}