// 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 LoadFrm_PC_Page(int companyId, string partnerInfor) { btnUpdate.Text = "UPDATE"; // load company infor tbl_CompanyDAO companyDAO = new tbl_CompanyDAO(); tbl_CompanyDTO company = companyDAO.GetById(companyId); txtComId.Text = companyId.ToString(); txtCompanyName.Text = company.Name.ToUpper(); txtComAddress.Text = company.Address; txtCompanyEmail.Text = company.Email.ToLower(); txtBankNumber.Text = company.BankNumber; currentCom = company; // load partner infor tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); tbl_PartnerDTO partner = partnerDAO.GetByName_Phone_CompanyId(partnerInfor, companyId); txtPartnerId.Text = partner.Id.ToString(); txtPartnerName.Text = partner.Name.ToUpper(); txtPosition.Text = partner.Position; txtPartnerPhone.Text = partner.Phone; txtPartnerEmail.Text = partner.Email; txtPartnerAdd.Text = partner.Address; currentPartner = partner; }
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; }
public void DisplayPartnerInfor(int partnerId) { tbl_PartnerDAO dao = new tbl_PartnerDAO(); String[] partner = { dao.GetPartnerById(partnerId) }; cbPartners.DataSource = partner; }
public void CellClickBIgList_PC_Page() { int projectId = int.Parse(gvBigList.CurrentRow.Cells[0].Value.ToString()); tbl_ProjectDAO projectDAO = new tbl_ProjectDAO(); tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); string infor = partnerDAO.GetPartnerById(projectDAO.GetPartnerId(projectId)); cbPartners.Text = infor; }
private void cbCompany_SelectedIndexChanged(object sender, EventArgs e) { string company = cbCompany.SelectedItem.ToString(); tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); listPartner = partnerDAO.GetListPartners(int.Parse(company.Split(':')[1].Trim())); foreach (tbl_PartnerDTO partner in listPartner) { cbPartner.Items.Add(partner.Name + " - ID :" + partner.Id); } }
private void btnUpdate_Click(object sender, EventArgs e) { if (Page.Equals("Project-Company") || Page.Equals("Employee-Project")) { if (ValidData()) { try { // company int comId = int.Parse(txtComId.Text.Trim()); string comName = txtCompanyName.Text.Trim(); string email = txtCompanyEmail.Text.Trim(); string address = txtComAddress.Text.Trim(); string bankNumber = txtBankNumber.Text.Trim(); tbl_CompanyDTO company = new tbl_CompanyDTO(comId, comName, address, email, bankNumber, false); tbl_CompanyDAO comDAO = new tbl_CompanyDAO(); bool updateCompany = comDAO.Update(company); if (updateCompany) { int partnerId = int.Parse(txtPartnerId.Text.Trim()); string name = txtPartnerName.Text.Trim(); string position = txtPosition.Text.Trim(); string partAdd = txtPartnerAdd.Text.Trim(); string phone = txtPartnerPhone.Text.Trim(); string partEmail = txtPartnerEmail.Text.Trim(); tbl_PartnerDTO partner = new tbl_PartnerDTO(partnerId, name, position, partAdd, phone, comId, partEmail); tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); bool updatePartner = partnerDAO.Update(partner); if (updatePartner) { currentPartner = partner; currentCom = company; saveFrmPartner = true; MessageBox.Show("Update Successful!"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } // add if (Page.Equals("New_Project")) { AddNewCompany(); } if (Page.Equals("New_Project_CP")) { AddNewPartner(); } }
// display combobox public void DisplayComboboxPartner(int companyId) { tbl_PartnerDAO dao = new tbl_PartnerDAO(); List <tbl_PartnerDTO> listPartnerId = dao.GetListPartners(companyId); List <string> items = new List <string>(); foreach (tbl_PartnerDTO dto in listPartnerId) { items.Add(dto.Name + " - " + dto.Phone); } cbPartners.DataSource = items; }
// change item in combo box partner private void cbPartners_SelectedIndexChanged(object sender, EventArgs e) { ++flagCbPartners; if (flagCbPartners > 1) { string[] partnerInfor = cbPartners.SelectedValue.ToString().Split('-'); tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); int partId = partnerDAO.GetIdByPhone(partnerInfor[1].Trim()); tbl_ProjectDAO projectDAO = new tbl_ProjectDAO(); projectDAO.GetByPartnerId(partId, ref gvBigList); } }
public void CellClick_PC_Page() { int companyId = int.Parse(gvSmallList.CurrentRow.Cells[0].Value.ToString()); // load company name in list project lbCompanyName.Text = gvSmallList.CurrentRow.Cells[1].Value.ToString(); // load combobox partners DisplayComboboxPartner(companyId); // with company selected, display list project tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); tbl_ProjectDAO projectDAO = new tbl_ProjectDAO(); projectDAO.GetProjectsOfCompany(partnerDAO.GetListPartnerId(companyId), ref gvBigList); }
public void AddNewCompany() { if (ValidData()) { try { // company tbl_CompanyDTO company = new tbl_CompanyDTO() { Name = txtCompanyName.Text.Trim(), Email = txtCompanyEmail.Text.Trim(), Address = txtComAddress.Text.Trim(), BankNumber = txtBankNumber.Text.Trim(), }; tbl_CompanyDAO comDAO = new tbl_CompanyDAO(); bool insertCompany = comDAO.Insert(company); if (insertCompany) { int comId = int.Parse(comDAO.GetEndCom().Split(':')[1].Trim()); tbl_PartnerDTO partner = new tbl_PartnerDTO() { Name = txtPartnerName.Text.Trim(), Position = txtPosition.Text.Trim(), Address = txtPartnerAdd.Text.Trim(), Phone = txtPartnerPhone.Text.Trim(), Email = txtPartnerEmail.Text.Trim(), CompanyId = comId, }; tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); bool insetPartner = partnerDAO.Insert(partner); if (insetPartner) { currentPartner = partner; currentCom = company; saveFrmPartner = true; this.Close(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void btnRefesh_Click(object sender, EventArgs e) { try { if (string.IsNullOrWhiteSpace(cbCompany.Text) && string.IsNullOrWhiteSpace(cbPartner.Text)) { tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); cbPartner.Text = partnerDAO.GetEndPartner(); if (flag == 0) { tbl_CompanyDAO comDAO = new tbl_CompanyDAO(); cbCompany.Text = comDAO.GetEndCom(); } } } catch (Exception) { throw; } }
public void AddNewPartner() { if (ValidData()) { NewPartner = new tbl_PartnerDTO() { Name = txtPartnerName.Text.Trim(), Position = txtPosition.Text.Trim(), Address = txtPartnerAdd.Text.Trim(), Phone = txtPartnerPhone.Text.Trim(), Email = txtPartnerEmail.Text.Trim(), CompanyId = int.Parse(txtComId.Text.Trim()), }; tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); bool result = partnerDAO.Insert(NewPartner); if (result) { this.Close(); } } }
// init data public void InitProject_Company() { picNew.Visible = true; picDelete.Visible = true; picUpdate.Visible = true; flagCbPartners = 0; //load lable all project lbAllProject.Visible = true; tbl_CompanyDAO companyDAO = new tbl_CompanyDAO(); companyDAO.GetAllCompany(ref gvSmallList); // get list project by company of row 1 lbCompanyName.Text = gvSmallList.Rows[0].Cells[1].Value.ToString(); int companyId = int.Parse(gvSmallList.Rows[0].Cells[0].Value.ToString()); tbl_ProjectDAO projectDAO = new tbl_ProjectDAO(); tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO(); projectDAO.GetProjectsOfCompany(partnerDAO.GetListPartnerId(companyId), ref gvBigList); // display combobox partner DisplayComboboxPartner(companyId); }
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()))); } }
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; }
private void btnAddProject_Click(object sender, EventArgs e) { try { if (ValidData()) { tbl_ProjectDTO project = new tbl_ProjectDTO() { Name = txtName.Text, PartnerId = int.Parse(cbPartner.Text.Split(':')[1].Trim()), AdvancePayment = float.Parse(txtAdPayment.Text), Cost = float.Parse(txtCost.Text), BeginTime = dateStart.Value }; if (!string.IsNullOrWhiteSpace(txtDescription.Text)) { project.Description = txtDescription.Text; } if (chbDone.Checked) { project.Status = "Done"; project.Deadline = dateDeadline.Value; project.EndTime = dateEnd.Value; } else { project.Status = "Doing..."; } tbl_ProjectDAO projectDAO = new tbl_ProjectDAO(); bool result = projectDAO.Insert(project); if (result) { if (listEmployee.Count() > 0) { tbl_JoiningDAO joinDAO = new tbl_JoiningDAO(); foreach (tbl_EmployeeDTO employee in listEmployee) { joinDAO.Insert(projectDAO.GetEndId(), employee.Id); } } MessageBox.Show("Add new project successfull"); } else { tbl_PartnerDAO dao = new tbl_PartnerDAO(); dao.Delete(project.PartnerId); if (flag == 0) { tbl_CompanyDAO comDAO = new tbl_CompanyDAO(); comDAO.Delete(int.Parse(cbCompany.Text.Split(':')[1].Trim())); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); throw; } }