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; }
// view detail partner and company private void btnViewDetailPartner_Click(object sender, EventArgs e) { if (cbPartners.Visible) { frmPartnerManagement frmPartner = frmPartnerManagement.GetInstance(); if (!frmPartner.Visible) { if (page.Equals("Project-Company")) { frmPartner.Page = "Project-Company"; int companyId = int.Parse(gvSmallList.CurrentRow.Cells[0].Value.ToString()); string partnerInfo = cbPartners.SelectedValue.ToString(); frmPartner.ComanyId = companyId; frmPartner.PartnerInfor = partnerInfo; } if (page.Equals("Employee-Project")) { frmPartner.Page = "Employee-Project"; int partnerId = int.Parse(gvSmallList.CurrentRow.Cells[3].Value.ToString()); tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); int companyId = partnerDAO.GetCompanyIdById(partnerId); string partnerInfo = cbPartners.SelectedValue.ToString(); frmPartner.ComanyId = companyId; frmPartner.PartnerInfor = partnerInfo; } frmPartner.Show(); } else { frmPartner.BringToFront(); } } }
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; }
public void Search_EP_Page() { tbl_ProjectDAO projectDAO = new tbl_ProjectDAO(); projectDAO.SearchByName(txtSearchSmall.Text, ref gvSmallList); lbNotFound.Visible = false; gvSmallList.Visible = true; cbPartners.Visible = true; gvBigList.Visible = true; if (gvSmallList.RowCount == 0) { lbNotFound.Visible = true; gvSmallList.Visible = false; lbCompanyName.Text = ""; cbPartners.Visible = false; gvBigList.Visible = false; } else { tbl_CompanyDAO companyDAO = new tbl_CompanyDAO(); tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); lbCompanyName.Text = companyDAO.GetNameById(partnerDAO.GetCompanyIdById(int.Parse(gvSmallList.CurrentRow.Cells[3].Value.ToString()))); } }