//
//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>
/// add project
/// </summary>
private void btnJoin_Click(object sender, EventArgs e)
{
try
{
string projectItem = cbProject.SelectedItem.ToString();
int projectID = int.Parse(projectItem.Split(':')[1].Trim());
tbl_ProjectDAO dao = new tbl_ProjectDAO();
int flag = 0;
foreach (tbl_ProjectDTO dto in listProject)
{
if (dto.Id == projectID)
{
MessageBox.Show(txtName.Text + " already joined in this project!");
flag++;
return;
}
}
if (flag == 0)
{
tbl_ProjectDTO project = dao.GetById(projectID);
// insert db
tbl_JoiningDAO joinDAO = new tbl_JoiningDAO();
bool resutl = joinDAO.Insert(projectID, int.Parse(txtId.Text));
if (resutl)
{
listProject.Add(project);
gvProject.DataSource = null;
gvProject.DataSource = listProject;
}
else
{
MessageBox.Show("Error");
}
}
}
catch (Exception)
{
}
}
/// <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);
}
}
