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;
}
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();
}
}
public void LoadAll_PC_Page()
{
tbl_CompanyDAO companyDAO = new tbl_CompanyDAO();
companyDAO.GetAllCompany(ref gvSmallList);
//tbl_PartnerDAO partnerDAO = new tbl_PartnerDAO();
//tbl_ProjectDAO projectDAO = new tbl_ProjectDAO();
//for (int i = 0; i < gvSmallList.Rows.Count; i++)
//{
// int comId = int.Parse(gvSmallList.Rows[i].Cells[0].Value.ToString());
// if (projectDAO.GetNumberProjectsOfCompany(partnerDAO.GetListPartnerId(comId)) == 0)
// {
// gvSmallList.Rows[i].Visible = false;
// }
//}
InitProject_Company();
}
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);
}
}
}
public void LoadCompanyInfor()
{
// load company infor
tbl_CompanyDAO companyDAO = new tbl_CompanyDAO();
tbl_CompanyDTO company = companyDAO.GetById(ComanyId);
txtComId.Text = ComanyId.ToString();
txtCompanyName.Text = company.Name.ToUpper();
txtCompanyName.Enabled = false;
txtComAddress.Text = company.Address;
txtComAddress.Enabled = false;
txtCompanyEmail.Text = company.Email.ToLower();
txtCompanyEmail.Enabled = false;
txtBankNumber.Text = company.BankNumber;
txtBankNumber.Enabled = false;
btnUpdate.Text = "ADD NEW";
}
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;
}
}
// 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_PC_Page()
{
tbl_CompanyDAO companyDAO = new tbl_CompanyDAO();
companyDAO.SearchCompanyByName(ref gvSmallList, txtSearchSmall.Text);
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
{
lbCompanyName.Text = gvSmallList.Rows[0].Cells[1].Value.ToString();
}
}
/// <summary>
/// Load form
/// </summary>
private void frmNewProject_Load(object sender, EventArgs e)
{
// load all company
tbl_CompanyDAO companyDAO = new tbl_CompanyDAO();
listCompany = companyDAO.GetAllCompany();
foreach (tbl_CompanyDTO company in listCompany)
{
cbCompany.Items.Add(company.Name + " - ID :" + company.Id);
}
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
// 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;
}
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())));
}
}
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;
}
}
