public tbl_PartnerDTO GetByName_Phone_CompanyId(string partnerInfor, int companyId)
{
try
{
using (con = DBConnection.MakeConnection(con))
{
con.Open();
SqlCommand command = new SqlCommand("Select id, position, address, phone, email from tbl_Partner where phone like @phone and companyID = @companyId", con);
string[] infor = partnerInfor.Split('-');
command.Parameters.AddWithValue("@phone", infor[1].Trim());
command.Parameters.AddWithValue("@companyId", companyId);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
int id = reader.GetInt32(0);
string position = reader.GetString(1);
string address = reader.GetString(2);
string phone = reader.GetString(3);
string email = reader.GetString(4);
tbl_PartnerDTO dto = new tbl_PartnerDTO(id, infor[0].Trim(), position, address, phone, companyId, email);
return(dto);
}
}
}
catch (Exception)
{
throw;
}
return(null);
}
public bool Update(tbl_PartnerDTO dto)
{
try
{
using (con = DBConnection.MakeConnection(con))
{
con.Open();
SqlCommand command = new SqlCommand("Update tbl_Partner set name=@name, position=@positon, address=@add, phone=@phone, email=@email where id=@id", con);
command.Parameters.AddWithValue("@name", dto.Name);
command.Parameters.AddWithValue("@positon", dto.Position);
command.Parameters.AddWithValue("@add", dto.Address);
command.Parameters.AddWithValue("@phone", dto.Phone);
command.Parameters.AddWithValue("@email", dto.Email);
command.Parameters.AddWithValue("@id", dto.Id);
int row = command.ExecuteNonQuery();
if (row > 0)
{
return(true);
}
}
}
catch (Exception)
{
throw;
}
return(false);
}
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;
}
// close
public void Check_Save()
{
if (Page.Equals("Project-Company") || Page.Equals("Employee-Project"))
{
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);
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, email);
tbl_CompanyBLL companyBLL = new tbl_CompanyBLL();
tbl_PartnerBLL partnerBLL = new tbl_PartnerBLL();
if (companyBLL.Check_Save(currentCom, company) && partnerBLL.Check_Save(currentPartner, partner))
{
saveFrmPartner = true;
}
else
{
saveFrmPartner = false;
}
}
}
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 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 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();
}
}
}
public List <tbl_PartnerDTO> GetListPartners(int companyId)
{
List <tbl_PartnerDTO> listDTO = new List <tbl_PartnerDTO>();
try
{
using (con = DBConnection.MakeConnection(con))
{
con = DBConnection.OpenConnection(con);
SqlCommand command = new SqlCommand("Select id, name, position, address,phone, email from tbl_Partner where companyID = @Id and deleteStatus = 'False'", con);
command.Parameters.AddWithValue("@Id", companyId);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
string position = reader.GetString(2);
string address;
try
{
address = reader.GetString(3);
}
catch (Exception)
{
address = "";
}
string phone = reader.GetString(4);
string email = reader.GetString(5);
tbl_PartnerDTO dto = new tbl_PartnerDTO(id, name, position, address, phone, companyId, email);
listDTO.Add(dto);
}
}
}
catch (Exception)
{
throw;
}
return(listDTO);
}
public bool Check_Save(tbl_PartnerDTO current, tbl_PartnerDTO now)
{
if (!current.Name.ToLower().Equals(now.Name.ToLower()))
{
return(false);
}
if (!current.Position.ToLower().Equals(now.Position.ToLower()))
{
return(false);
}
if (!current.Address.ToLower().Equals(now.Address.ToLower()))
{
return(false);
}
if (!current.Phone.ToLower().Equals(now.Phone.ToLower()))
{
return(false);
}
if (!current.Email.ToLower().Equals(now.Email.ToLower()))
{
return(false);
}
return(true);
}
public bool Insert(tbl_PartnerDTO dto)
{
try
{
using (con = DBConnection.MakeConnection(con))
{
con.Open();
SqlCommand command;
if (dto.Address != null)
{
command = new SqlCommand("Insert into tbl_Partner(name, position, address, phone, companyID, email) values(@name, @position, @address, @phone, @companyID, @email)", con);
command.Parameters.AddWithValue("@name", dto.Name);
command.Parameters.AddWithValue("@position", dto.Position);
command.Parameters.AddWithValue("@address", dto.Address);
command.Parameters.AddWithValue("@phone", dto.Phone);
command.Parameters.AddWithValue("@companyID", dto.CompanyId);
command.Parameters.AddWithValue("@email", dto.Email);
}
else
{
command = new SqlCommand("Insert into tbl_Partner(name, position, phone, companyID, email) values(@name, @position, @phone, @companyID, @email)", con);
command.Parameters.AddWithValue("@name", dto.Name);
command.Parameters.AddWithValue("@position", dto.Position);
command.Parameters.AddWithValue("@phone", dto.Phone);
command.Parameters.AddWithValue("@companyID", dto.CompanyId);
command.Parameters.AddWithValue("@email", dto.Email);
}
return(command.ExecuteNonQuery() > 0);
}
}
catch (Exception ex)
{
throw;
}
}
