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