private void addEmployeeBtn_Click(object sender, RoutedEventArgs e)
{
SecurityManagementSystemEngine.EmployeeInformation newEmployee = new SecurityManagementSystemEngine.EmployeeInformation();
newEmployee.id = GenerateId();
newEmployee.name = employeeNameTxtbox.Text;
newEmployee.addres = AddressNameTxtbox.Text;
newEmployee.contact = contactTxtbox.Text;
newEmployee.email = emailTxtbox.Text;
newEmployee.homeNumber = homeNumberTxtbox.Text;
newEmployee.joiningdate = joiningdateP.SelectedDate.Value;
newEmployee.employeeType= employeeTypeCombobox.Text;
newEmployee.remark = remarkTxtbox.Text;
SecurityManagementSystemStorage.SecurityManagementSystemStorageInteraction.DoEnterEmployee(newEmployee);
EmployeeTC.SelectedIndex = 0;
clearEmployeeFields();
}
private static List<EmployeeInformation> QueryAllEmployeeList()
{
List<EmployeeInformation> EmployeeList = new List<EmployeeInformation>();
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{ //define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "Select * From employee ;";
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
while (msqlReader.Read())
{
EmployeeInformation Employee = new EmployeeInformation();
Employee.id = msqlReader.GetString("id");
Employee.name = msqlReader.GetString("name");
Employee.addres = msqlReader.GetString("address");
Employee.contact = msqlReader.GetString("contact");
Employee.joiningdate = msqlReader.GetDateTime("joiningdate");
Employee.email = msqlReader.GetString("email");
Employee.homeNumber = msqlReader.GetString("homenumber");
Employee.employeeType = msqlReader.GetString("employeeType");
Employee.remark = msqlReader.GetString("remark");
EmployeeList.Add(Employee);
}
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return EmployeeList;
}
private static int DoRegisterNewEmployeeindb(EmployeeInformation Newemployee)
{
int returnVal = 0;
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
//define the connection used by the command object
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "INSERT INTO employee(id,name,address,contact,joiningdate,email,homenumber,employeeType,remark) "
+ "VALUES(@id,@name,@address,@contact,@joiningdate,@email,@homenumber,@employeeType,@remark)";
msqlCommand.Parameters.AddWithValue("@id", Newemployee.id);
msqlCommand.Parameters.AddWithValue("@name", Newemployee.name);
msqlCommand.Parameters.AddWithValue("@address", Newemployee.addres);
msqlCommand.Parameters.AddWithValue("@contact", Newemployee.contact);
msqlCommand.Parameters.AddWithValue("@joiningdate", Newemployee.joiningdate);
msqlCommand.Parameters.AddWithValue("@email", Newemployee.email);
msqlCommand.Parameters.AddWithValue("@homenumber", Newemployee.homeNumber);
msqlCommand.Parameters.AddWithValue("@employeeType", Newemployee.employeeType);
msqlCommand.Parameters.AddWithValue("@remark", Newemployee.remark);
msqlCommand.ExecuteNonQuery();
returnVal = 1;
}
catch (Exception er)
{
returnVal = 0;
}
finally
{
//always close the connection
msqlConnection.Close();
}
return returnVal;
}
public static EmployeeInformation GetEmployeeInfo(string employeeId)
{
EmployeeInformation employee = new EmployeeInformation();
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{ //define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "Select * From employee WHERE id=@id;";
msqlCommand.Parameters.AddWithValue("@id", employeeId);
MySql.Data.MySqlClient.MySqlDataReader msqlReader = msqlCommand.ExecuteReader();
msqlReader.Read();
employee.id = msqlReader.GetString("id");
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
return employee;
}
public static void EditEmployee(EmployeeInformation newUpdateEmployee)
{
MySql.Data.MySqlClient.MySqlConnection msqlConnection = OpenDbConnection();
try
{
//define the command reference
MySql.Data.MySqlClient.MySqlCommand msqlCommand = new MySql.Data.MySqlClient.MySqlCommand();
msqlCommand.Connection = msqlConnection;
msqlCommand.CommandText = "UPDATE employee SET name=@name,address=@address,contact=@contact,joiningdate=@joiningdate,email=@email,homenumber=@homenumber,employeeType=@employeeType,remark=@remark WHERE id=@id";
msqlCommand.Parameters.AddWithValue("@name", newUpdateEmployee.name);
msqlCommand.Parameters.AddWithValue("@address", newUpdateEmployee.addres);
msqlCommand.Parameters.AddWithValue("@contact", newUpdateEmployee.contact);
msqlCommand.Parameters.AddWithValue("@joiningdate", newUpdateEmployee.joiningdate);
msqlCommand.Parameters.AddWithValue("@email", newUpdateEmployee.email);
msqlCommand.Parameters.AddWithValue("@homenumber", newUpdateEmployee.homeNumber);
msqlCommand.Parameters.AddWithValue("@employeeType", newUpdateEmployee.employeeType);
msqlCommand.Parameters.AddWithValue("@remark", newUpdateEmployee.remark);
msqlCommand.Parameters.AddWithValue("@id", newUpdateEmployee.id);
msqlCommand.ExecuteNonQuery();
}
catch (Exception er)
{
}
finally
{
//always close the connection
msqlConnection.Close();
}
}
public static int DoEnterEmployee(EmployeeInformation NewEmployee)
{
return DoRegisterNewEmployeeindb(NewEmployee);
}