/// <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)
{
}
}
//
// add employee
//
private void btnAddEmp_Click(object sender, EventArgs e)
{
try
{
string[] employeeInf = cbEmployee.SelectedItem.ToString().Split(':');
string id = employeeInf[1].Trim().Split('(')[0].Trim();
int flag = 0;
foreach (tbl_EmployeeDTO item in listEmployee)
{
if (item.Id == int.Parse(id))
{
flag++;
}
}
if (flag > 0)
{
MessageBox.Show("The employee is already exited in project!");
}
else
{
foreach (tbl_EmployeeDTO dto in listAllEmp)
{
if (dto.Id == int.Parse(id))
{
listEmployee.Add(dto);
tbl_JoiningDAO joinDAO = new tbl_JoiningDAO();
joinDAO.Insert(int.Parse(txtID.Text), dto.Id);
gvListEmployee.DataSource = null;
gvListEmployee.DataSource = listEmployee;
}
}
}
}
catch (Exception)
{
MessageBox.Show("Add employee not successfull!");
}
}
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;
}
}