private void selectEmployeeComboBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            EmployeeManager anEmployeeManager = new EmployeeManager();
            Employee anEmployee = new Employee();
            anEmployee.Email = anEmployeeManager.Get((int)selectEmployeeComboBox.SelectedValue).Email;
            anEmployee.Contact = anEmployeeManager.Get((int)selectEmployeeComboBox.SelectedValue).Contact;
            emailTextBox.Text = anEmployee.Email;
            contactTextBox.Text = anEmployee.Contact;

            employeeId = (int)selectEmployeeComboBox.SelectedValue;
        }
 private void saveButton_Click(object sender, System.EventArgs e)
 {
     Employee anEmployee = new Employee();
     anEmployee.Name = nameTextBox.Text;
     anEmployee.Email = emailTextBox.Text;
     anEmployee.Contact = contactTextBox.Text;
     anEmployee.JoiningDate = joiningDateDateTimePicker.Value;
     anEmployee.DepartmentId = (int) departmentComboBox.SelectedValue;
     EmployeeManager anEmployeeManager = new EmployeeManager();
     string msg = anEmployeeManager.Save(anEmployee);
     MessageBox.Show(msg);
 }
 public string Save(Employee anEmployee)
 {
     string query = "INSERT INTO t_employee(name, email, contact, department_id, joiningdate)" +
                    " VALUES ('" + anEmployee.Name + "','" + anEmployee.Email + "','" +
                    anEmployee.Contact + "'," + anEmployee.DepartmentId + ",'" + anEmployee.JoiningDate + "')";
     SqlConnection sqlConnection = new SqlConnection(connectionString);
     sqlConnection.Open();
     SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
     sqlCommand.ExecuteNonQuery();
     sqlConnection.Close();
     return "Employee saved";
 }
        public Employee Get(int employeeId)
        {
            string query = "SELECT * FROM t_employee WHERE id = '" + employeeId + "'";
            SqlConnection sqlConnection = new SqlConnection(connectionString);
            sqlConnection.Open();
            SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            if (sqlDataReader.HasRows)
            {
                sqlDataReader.Read();
                Employee aEmployee = new Employee();
                aEmployee.Name = sqlDataReader[1].ToString();
                aEmployee.Email = sqlDataReader[2].ToString();
                aEmployee.Contact = sqlDataReader[3].ToString();
                aEmployee.DepartmentId = Convert.ToInt32(sqlDataReader[4]);
                aEmployee.JoiningDate = Convert.ToDateTime(sqlDataReader[5]);
                sqlConnection.Close();
                return aEmployee;
            }

            sqlConnection.Close();
            return null;
        }
 public string Save(Employee anEmployee)
 {
     return anEmployeeGateway.Save(anEmployee);
 }
        public List<Employee> GetAllEmployees(int theDeaprtmentId)
        {
            string query = "SELECT * FROM t_employee WHERE department_id = '"+ theDeaprtmentId + "'";
            SqlConnection sqlConnection = new SqlConnection(connectionString);
            sqlConnection.Open();
            SqlCommand sqlCommand = new SqlCommand(query, sqlConnection);
            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            List<Employee> employees = new List<Employee>();
            while (sqlDataReader.Read())
            {
                Employee aEmployee = new Employee();
                aEmployee.Id = Convert.ToInt32(sqlDataReader[0]);
                aEmployee.Name = sqlDataReader[1].ToString();
                aEmployee.Email = sqlDataReader[2].ToString();
                aEmployee.Contact = sqlDataReader[3].ToString();
                aEmployee.DepartmentId = Convert.ToInt32(sqlDataReader[4]);
                aEmployee.JoiningDate = Convert.ToDateTime(sqlDataReader[5]);
                employees.Add(aEmployee);

            }

            sqlConnection.Close();
            return employees;
        }