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