public void LoadAll_EP_Page()
{
tbl_ProjectDAO dao = new tbl_ProjectDAO();
dao.GetAllProject(ref gvSmallList);
InitEmployee_Project();
}
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 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;
}
//
//load project detail
//
private void frmProjectManagement_Load(object sender, EventArgs e)
{
lbCompanyName.Text = ComName;
lbPartnerInfor.Text = PartnerInfor;
tbl_ProjectDAO dao = new tbl_ProjectDAO();
tbl_ProjectDTO dto = dao.GetById(ProjectId);
currentDTO = dto;
txtID.Text = dto.Id.ToString();
txtName.Text = dto.Name;
txtDescription.Text = dto.Description;
lbStatus.Text = dto.Status;
txtAdPayment.Text = dto.AdvancePayment.ToString();
txtCost.Text = dto.Cost.ToString();
dateStart.Value = dto.BeginTime;
if (dto.Deadline != null)
{
dateDeadline.Value = dto.Deadline.Value;
}
if (dto.Status.Equals("Doing..."))
{
chbDone.Visible = true;
chbDone.Checked = false;
dateEnd.Visible = false;
lbStatus.BackColor = Color.Red;
}
else
{
chbDone.Checked = true;
dateEnd.Visible = true;
dateEnd.Value = dto.EndTime.Value;
lbStatus.BackColor = Color.Blue;
}
// display list employee
tbl_JoiningDAO joiningDAO = new tbl_JoiningDAO();
List <int> employeeIDs = joiningDAO.GetListEmIDByProjectId(ProjectId);
listEmployee = new List <tbl_EmployeeDTO>();
listFirt = listEmployee;
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
foreach (var emId in employeeIDs)
{
listEmployee.Add(emDAO.GetById(emId));
}
gvListEmployee.DataSource = listEmployee;
// 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;
}
// 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);
}
}
private void picDelete_Click(object sender, EventArgs e)
{
if (page.Equals("Project-Company"))
{
if (MessageBox.Show("Do you want delete this project?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int projectID = int.Parse(gvBigList.CurrentRow.Cells[0].Value.ToString());
tbl_ProjectDAO projectDAO = new tbl_ProjectDAO();
bool result = projectDAO.Delete(projectID);
LoadAll_PC_Page();
CellClick_PC_Page();
}
}
}
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);
}
//
//update
//
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidData())
{
SaveMode = true;
try
{
tbl_ProjectDTO project = new tbl_ProjectDTO()
{
Id = int.Parse(txtID.Text),
Name = txtName.Text,
AdvancePayment = float.Parse(txtAdPayment.Text),
Cost = float.Parse(txtCost.Text),
BeginTime = dateStart.Value,
Deadline = dateDeadline.Value,
Description = txtDescription.Text,
Status = lbStatus.Text
};
if (lbStatus.Text.Equals("Done"))
{
project.EndTime = dateEnd.Value;
}
else
{
project.EndTime = null;
}
tbl_ProjectDAO dao = new tbl_ProjectDAO();
bool result = dao.Update(project);
if (result)
{
SaveMode = true;
MessageBox.Show("Update successfull!");
}
else
{
MessageBox.Show("Update not successfull!");
}
}
catch (Exception)
{
MessageBox.Show("Update not successfull!");
}
}
}
/// <summary>
/// add project
/// </summary>
private void btnJoin_Click(object sender, EventArgs e)
{
try
{
string projectItem = cbProject.SelectedItem.ToString();
int projectID = int.Parse(projectItem.Split(':')[1].Trim());
tbl_ProjectDAO dao = new tbl_ProjectDAO();
int flag = 0;
foreach (tbl_ProjectDTO dto in listProject)
{
if (dto.Id == projectID)
{
MessageBox.Show(txtName.Text + " already joined in this project!");
flag++;
return;
}
}
if (flag == 0)
{
tbl_ProjectDTO project = dao.GetById(projectID);
// insert db
tbl_JoiningDAO joinDAO = new tbl_JoiningDAO();
bool resutl = joinDAO.Insert(projectID, int.Parse(txtId.Text));
if (resutl)
{
listProject.Add(project);
gvProject.DataSource = null;
gvProject.DataSource = listProject;
}
else
{
MessageBox.Show("Error");
}
}
}
catch (Exception)
{
}
}
// 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);
}
/// <summary>
/// Load employee information
/// </summary>
private void frmEmployeeDetail_Load(object sender, EventArgs e)
{
try
{
tbl_EmployeeDAO emDAO = new tbl_EmployeeDAO();
currentEm = emDAO.GetById(EmId);
txtId.Text = currentEm.Id.ToString();
txtName.Text = currentEm.Name;
txtAddress.Text = currentEm.Address;
birthday.Value = currentEm.Birthday;
txtPhone.Text = currentEm.Phone;
txtEmail.Text = currentEm.Email;
string[] role = currentEm.Role.Split('-');
cbPosition.Text = role[1].Trim().ToUpper();
tbl_RoleDAO roleDAO = new tbl_RoleDAO();
roleDAO.GetAll(ref cbPosition);
txtSalary.Text = currentEm.Salary.ToString();
// display list project
tbl_JoiningDAO joinDAO = new tbl_JoiningDAO();
List <int> listProId = joinDAO.GetListProjectByEmId(EmId);
tbl_ProjectDAO projectDAO = new tbl_ProjectDAO();
listProject = new List <tbl_ProjectDTO>();
foreach (int id in listProId)
{
listProject.Add(projectDAO.GetById(id));
}
gvProject.DataSource = listProject;
// load all project
List <string> items = projectDAO.GetAllProject();
cbProject.DataSource = items;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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;
}
}
