public void InitEmployee_Project()
{
picNew.Visible = false;
picDelete.Visible = false;
picUpdate.Visible = false;
flagCbPartners = 0;
// load lable AllProject
lbAllProject.Visible = false;
tbl_ProjectDAO projectDAO = new tbl_ProjectDAO();
projectDAO.GetAllProject(ref gvSmallList);
// load lable company name
tbl_CompanyDAO companyDAO = new tbl_CompanyDAO();
tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO();
int companyId = partnerDAO.GetCompanyIdById(int.Parse(gvSmallList.CurrentRow.Cells[3].Value.ToString()));
lbCompanyName.Text = companyDAO.GetNameById(companyId);
// load partner infor
int parnerId = int.Parse(gvSmallList.CurrentRow.Cells[3].Value.ToString());
DisplayPartnerInfor(parnerId);
// display employees
tbl_JoiningDAO joiningDAO = new tbl_JoiningDAO();
List <int> employeeIDs = joiningDAO.GetListEmIDByProjectId(int.Parse(gvSmallList.CurrentRow.Cells[0].Value.ToString()));
List <tbl_EmployeeDTO> listEmployee = new List <tbl_EmployeeDTO>();
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
foreach (var emId in employeeIDs)
{
listEmployee.Add(emDAO.GetById(emId));
}
gvBigList.DataSource = listEmployee;
}
//
//load project detail
//
private void frmProjectManagement_Load(object sender, EventArgs e)
{
lbCompanyName.Text = ComName;
lbPartnerInfor.Text = PartnerInfor;
tbl_ProjectDAO dao = new tbl_ProjectDAO();
tbl_ProjectDTO dto = dao.GetById(ProjectId);
currentDTO = dto;
txtID.Text = dto.Id.ToString();
txtName.Text = dto.Name;
txtDescription.Text = dto.Description;
lbStatus.Text = dto.Status;
txtAdPayment.Text = dto.AdvancePayment.ToString();
txtCost.Text = dto.Cost.ToString();
dateStart.Value = dto.BeginTime;
if (dto.Deadline != null)
{
dateDeadline.Value = dto.Deadline.Value;
}
if (dto.Status.Equals("Doing..."))
{
chbDone.Visible = true;
chbDone.Checked = false;
dateEnd.Visible = false;
lbStatus.BackColor = Color.Red;
}
else
{
chbDone.Checked = true;
dateEnd.Visible = true;
dateEnd.Value = dto.EndTime.Value;
lbStatus.BackColor = Color.Blue;
}
// display list employee
tbl_JoiningDAO joiningDAO = new tbl_JoiningDAO();
List <int> employeeIDs = joiningDAO.GetListEmIDByProjectId(ProjectId);
listEmployee = new List <tbl_EmployeeDTO>();
listFirt = listEmployee;
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
foreach (var emId in employeeIDs)
{
listEmployee.Add(emDAO.GetById(emId));
}
gvListEmployee.DataSource = listEmployee;
// display domainEmployee
listAllEmp = emDAO.GetAllEmployee();
List <String> itemsCbEmployee = new List <string>();
foreach (tbl_EmployeeDTO employee in listAllEmp)
{
itemsCbEmployee.Add(employee.Name + " - ID :" + employee.Id + " (" + employee.Role + ")");
}
cbEmployee.DataSource = itemsCbEmployee;
}
/// <summary>
/// Load employee information
/// </summary>
private void frmEmployeeDetail_Load(object sender, EventArgs e)
{
try
{
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
currentEm = emDAO.GetById(EmId);
txtId.Text = currentEm.Id.ToString();
txtName.Text = currentEm.Name;
txtAddress.Text = currentEm.Address;
birthday.Value = currentEm.Birthday;
txtPhone.Text = currentEm.Phone;
txtEmail.Text = currentEm.Email;
string[] role = currentEm.Role.Split('-');
cbPosition.Text = role[1].Trim().ToUpper();
tbl_RoleDAO roleDAO = new tbl_RoleDAO();
roleDAO.GetAll(ref cbPosition);
txtSalary.Text = currentEm.Salary.ToString();
// display list project
tbl_JoiningDAO joinDAO = new tbl_JoiningDAO();
List <int> listProId = joinDAO.GetListProjectByEmId(EmId);
tbl_ProjectDAO projectDAO = new tbl_ProjectDAO();
listProject = new List <tbl_ProjectDTO>();
foreach (int id in listProId)
{
listProject.Add(projectDAO.GetById(id));
}
gvProject.DataSource = listProject;
// load all project
List <string> items = projectDAO.GetAllProject();
cbProject.DataSource = items;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Load form
/// </summary>
private void frmNewProject_Load(object sender, EventArgs e)
{
// load all company
tbl_CompanyDAO companyDAO = new tbl_CompanyDAO();
listCompany = companyDAO.GetAllCompany();
foreach (tbl_CompanyDTO company in listCompany)
{
cbCompany.Items.Add(company.Name + " - ID :" + company.Id);
}
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
// display domainEmployee
listAllEmp = emDAO.GetAllEmployee();
List <String> itemsCbEmployee = new List <string>();
foreach (tbl_EmployeeDTO employee in listAllEmp)
{
itemsCbEmployee.Add(employee.Name + " - ID :" + employee.Id + " (" + employee.Role + ")");
}
cbEmployee.DataSource = itemsCbEmployee;
}
/// <summary>
/// Update employee information
/// </summary>
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidData())
{
SaveMode = true;
try
{
tbl_EmployeeDTO employee = new tbl_EmployeeDTO()
{
Id = int.Parse(txtId.Text),
Name = txtName.Text,
Address = txtAddress.Text,
Birthday = birthday.Value,
Phone = txtPhone.Text,
Role = cbPosition.Text.ToString(),
Email = txtEmail.Text,
Salary = float.Parse(txtSalary.Text),
};
tbl_EmployeeDAO dao = new tbl_EmployeeDAO();
bool result = dao.Update(employee);
if (result)
{
SaveMode = true;
MessageBox.Show("Update successfull!");
}
else
{
MessageBox.Show("Update not successfull!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void CellClick_EP_Page()
{
//load company name
tbl_CompanyDAO companyDAO = new tbl_CompanyDAO();
tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO();
int companyId = partnerDAO.GetCompanyIdById(int.Parse(gvSmallList.CurrentRow.Cells[3].Value.ToString()));
lbCompanyName.Text = companyDAO.GetNameById(companyId);
// load partner infor
int parnerId = int.Parse(gvSmallList.CurrentRow.Cells[3].Value.ToString());
DisplayPartnerInfor(parnerId);
// display employees
tbl_JoiningDAO joiningDAO = new tbl_JoiningDAO();
List <int> employeeIDs = joiningDAO.GetListEmIDByProjectId(int.Parse(gvSmallList.CurrentRow.Cells[0].Value.ToString()));
List <tbl_EmployeeDTO> listEmployee = new List <tbl_EmployeeDTO>();
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
foreach (var emId in employeeIDs)
{
listEmployee.Add(emDAO.GetById(emId));
}
gvBigList.DataSource = listEmployee;
}
