// //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); } }