/// <summary>
/// FrmAddEmployee()
/// Constructor
/// </summary>
/// <param name="bus"></param>
public FrmAddEmployee(Business bus)
{
InitializeComponent();
business = bus;
newEmployee = new Employee();
updateEmployee = new Employee();
clerks = business.Employees;
}
/// <summary>
/// The constructor for the confirmation form.
/// </summary>
/// <param name="b"></param>
/// <param name="orderDetailList"></param>
/// <param name="c"></param>
/// <param name="emp"></param>
public FrmConfirmation(Business businessArg, Order order, List<OrderDetail> orderDetailList, Customer cust, Employee emp)
{
InitializeComponent();
currentOrder = order;
business = businessArg;
orderDetails = orderDetailList;
currentCustomer = cust;
currentEmp = emp;
}
public override void addReportedBy(Employee e)
{
if(e != null)
{
e.ReportsTo = this;
m_ReportedBy.Add(e);
this.markDirty();
}
else
{
throw new ApplicationException();
}
}
public abstract void addReportedBy(Employee e);
/// <summary>
/// loadConfirmation
/// loads confirmation form after order is placed
/// </summary>
/// <param name="o"></param>
/// <param name="od"></param>
/// <param name="c"></param>
/// <param name="emp"></param>
private void loadConfirmation(Order o, List<OrderDetail> od, Customer c, Employee emp)
{
FrmConfirmation frmConfirmation = new FrmConfirmation(business, o, od, c, emp);
frmConfirmation.Text = "Confirmation Window ";
frmConfirmation.ShowDialog();
}
/// <summary>
/// cmbClerks_SelectedIndexChanged()
/// When clerk is selected clear error and set clerk equal to employee selected - passed to confirmation form
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmbClerks_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbClerks.SelectedIndex != -1)
{
errorProvider.SetError(cmbClerks, "");
clerkSelected = (Employee)cmbClerks.SelectedItem;
}
}
//add employee to DB and call delegate
public string UpdateEmployee(Employee emp)
{
String updateQuery = "UPDATE Employees "
+ "SET LastName = " + ((String.IsNullOrEmpty(emp.LastName)) ? "null" : "\"" + emp.LastName + "\"")
+ ", FirstName = " + ((String.IsNullOrEmpty(emp.FirstName)) ? "null" : "\"" + emp.FirstName + "\"")
+ ", Title = " + ((String.IsNullOrEmpty(emp.Title)) ? "null" : "'" + emp.Title + "'")
+ ", TitleOfCourtesy = " + ((String.IsNullOrEmpty(emp.TitleOfCourtesy)) ? "null" : "\"" + emp.TitleOfCourtesy + "\"")
+ ", BirthDate = " + ((emp.BirthDate == null) ? "null" : "#" + emp.BirthDate.ToShortDateString()) + "#"
+ ", HireDate = " + ((emp.HireDate == null) ? "null" : "#" + emp.HireDate.ToShortDateString()) + "#"
+ ", Address = " + ((String.IsNullOrEmpty(emp.Address)) ? "null" : "'" + emp.Address + "'")
+ ", City = " + ((String.IsNullOrEmpty(emp.City)) ? "null" : "\"" + emp.City + "\"")
+ ", Region = " + ((String.IsNullOrEmpty(emp.Region)) ? "null" : "\"" + emp.Region + "\"")
+ ", PostalCode = " + ((String.IsNullOrEmpty(emp.PostalCode)) ? "null" : "'" + emp.PostalCode + "'")
+ ", Country = " + ((String.IsNullOrEmpty(emp.Country)) ? "null" : "\"" + emp.Country + "\"")
+ ", HomePhone = " + ((String.IsNullOrEmpty(emp.HomePhone)) ? "null" : "'" + emp.HomePhone + "'")
+ ", Extension = " + ((String.IsNullOrEmpty(emp.Extension)) ? "null" : "'" + emp.Extension + "'")
+ ", Photo = " + ((String.IsNullOrEmpty(emp.Photo)) ? "null" : "'" + emp.Photo + "'")
+ ", Notes = " + ((String.IsNullOrEmpty(emp.Notes)) ? "null" : "\"" + emp.Notes + "\"")
+ ", ReportsTo = " + ((emp.ReportsTo == 0) ? "null" : emp.ReportsTo.ToString())
+ " WHERE EmployeeID = " + emp.EmployeeID;
OleDbCommand cmUpdate = new OleDbCommand(updateQuery, con);
try
{
con.Open();
cmUpdate.ExecuteNonQuery();
}
catch (Exception)
{
//can't display any error feedback in data access layer
return "Employee Updated failed";
}
finally
{
con.Close();
}
//raise event
if (employeeAdded_Changed != null)//check to makes sure at least one handler registered
{
employeeAdded_Changed();
}
return "Employee Updated";
}
//add employee to DB and call delegate
/// <summary>
/// InsertEmployee()
/// Takes a Employee object and adds a new record to the database table Employees
/// </summary>
/// <param name="p">Object of type Employee</param>
public string InsertEmployee(Employee emp)
{
String insertQuery = "INSERT INTO Employees (LastName, FirstName, Title, TitleOfCourtesy, "
+ "BirthDate, HireDate, Address, City, Region, PostalCode, Country, HomePhone, Extension, "
+ "Photo, Notes, ReportsTo) VALUES ("
+ ((String.IsNullOrEmpty(emp.LastName)) ? "null" : "\"" + emp.LastName + "\"") + ","
+ ((String.IsNullOrEmpty(emp.FirstName)) ? "null" : "\"" + emp.FirstName + "\"") + ","
+ ((String.IsNullOrEmpty(emp.Title)) ? "null" : "'" + emp.Title + "'") + ","
+ ((String.IsNullOrEmpty(emp.TitleOfCourtesy)) ? "null" : "\"" + emp.TitleOfCourtesy + "\"") + ","
+ ((emp.BirthDate == null) ? "null" : "#" + emp.BirthDate.ToShortDateString()) + "#" + ","
+ ((emp.HireDate == null) ? "null" : "#" + emp.HireDate.ToShortDateString()) + "#" + ","
+ ((String.IsNullOrEmpty(emp.Address)) ? "null" : "\"" + emp.Address + "\"") + ","
+ ((String.IsNullOrEmpty(emp.City)) ? "null" : "\"" + emp.City + "\"") + ","
+ ((String.IsNullOrEmpty(emp.Region)) ? "null" : "\"" + emp.Region + "\"") + ","
+ ((String.IsNullOrEmpty(emp.PostalCode)) ? "null" : "'" + emp.PostalCode + "'") + ","
+ ((String.IsNullOrEmpty(emp.Country)) ? "null" : "\"" + emp.Country + "\"") + ","
+ ((String.IsNullOrEmpty(emp.HomePhone)) ? "null" : "'" + emp.HomePhone + "'") + ","
+ ((String.IsNullOrEmpty(emp.Extension)) ? "null" : "'" + emp.Extension + "'") + ","
+ ((String.IsNullOrEmpty(emp.Photo)) ? "null" : "'" + emp.Photo + "'") + ","
+ ((String.IsNullOrEmpty(emp.Notes)) ? "null" : "\"" + emp.Notes + "\"") + ","
+ ((emp.ReportsTo == 0) ? "null" : emp.ReportsTo.ToString()) + ")";
OleDbCommand cmInsert = new OleDbCommand(insertQuery, con);
try
{
con.Open();
cmInsert.ExecuteNonQuery();
}
catch (Exception e)
{
//can't display any error feedback in data access layer
MessageBox.Show(e.Message);
return "Employee Added Failed";
}
finally
{
con.Close();
}
//raise event
if (employeeAdded_Changed != null)//check to makes sure at least one handler registered
{
employeeAdded_Changed();
}
return "Employee Added";
}
/// <summary>
/// updateEmployee()
/// Updates a record in Employees Table
/// </summary>
/// <param name="_product">takes and object of type Employee</param>
public string updateEmployee(Employee _employee)
{
string confirmation = database.UpdateEmployee(_employee);
return confirmation;
}
/// <summary>
/// fetchEmployees()
/// Gets Employee records from database and returns a copy of it
/// </summary>
/// <returns>List of type Employee</returns>
public void loadEmployeeData()
{
employees = database.FetchEmployees();
List<Employee> copyEmployees = new List<Employee>();
Employee copy;
foreach (Employee e in employees)
{
copy = new Employee();//create new object
//add properties
copy.EmployeeID = e.EmployeeID;
copy.LastName = e.LastName;
copy.FirstName = e.FirstName;
copy.Title = e.Title;
copy.TitleOfCourtesy = e.TitleOfCourtesy;
copy.BirthDate = e.BirthDate;
copy.HireDate = e.HireDate;
copy.Address = e.Address;
copy.City = e.City;
copy.Region = e.Region;
copy.PostalCode = e.PostalCode;
copy.Country = e.Country;
copy.HomePhone = e.HomePhone;
copy.Extension = e.Extension;
copy.Photo = e.Photo;
copy.Notes = e.Notes;
copy.ReportsTo = e.ReportsTo;
copyEmployees.Add(copy);//add to new list
employees = copyEmployees;
}
}
/// <summary>
/// addEmployee()
/// Adds new record to Employees Table
/// </summary>
/// <param name="_product">takes and object of type Employee</param>
public string addEmployee(Employee _employee)
{
string confirmation = database.InsertEmployee(_employee);
return confirmation;
}
