private void btn_change_Click(object sender, EventArgs e)
{
bll_contract = new BLL_Contract();
_dtocontract = new DTO_Contract();
setAllcontrolToDTO(ref _dtocontract);
table = bll_contract.GetDataTableViewContract(ref err);
string num_no = string.Empty;
bool stt = false;
foreach (DataRow row in table.Rows)
{
num_no = (string)row["Notary_Number"];
stt = _dtocontract.No_number.Equals(num_no) ? true : false;
}
if (stt)
{
dialog = MessageBox.Show("Dữ liệu đã tồn tại");
}
if (dialog == DialogResult.OK)
{
Update_Contract(_dtocontract, bll_contract);
}
else
{
Add_Contract(_dtocontract, bll_contract);
}
this.Close();
Frm_detail_contract frm_Detail = new Frm_detail_contract();
frm_Detail.Show();
}
private void LoadGridViewContract()
{
bll_contact = new BLL_Contract();
table_Contract = new DataTable();
table_Contract = bll_contact.GetDataTableViewContract(ref err);
dataGridView1.DataSource = table_Contract;
}
private void Update_Contract(DTO_Contract con, BLL_Contract bll)
{
bool bo = bll.UpdateContractExcuNonQue(ref err, con.No_number, con.Dto_person_notary.Name, con.Dto_person_notary.Id_code, con.Dto_person_notary.Address, con.Dto_person_notary.Phone, con.Notary_date, con.Sign_date, con.Dto_notarybook.Number_book, con.Description, con.Dto_name_contract.Name_contract, con.Dto_type_contract.Name_type, (int)con.Price, con.Dto_notary.Name, con.Note, con.Dto_notarybook.Year_book);
if (bo == true)
{
MessageBox.Show("Đã update hợp đồng");
}
else
{
MessageBox.Show("Không update được hợp đồng");
}
}
private void Frm_Manage_Contract_Load(object sender, EventArgs e)
{
if (_dtocontract != null)
{
SetDTOToControl(_dtocontract);
}
else
{
DataTable dataTable = new DataTable();
bll_contract = new BLL_Contract();
dataTable = bll_contract.GetDataTableViewContract(ref err);
load_defaul_view(dataTable);
}
}
// auto select cbo type when choose cbo name_contract
private void cbo_name_contract_SelectedIndexChanged(object sender, EventArgs e)
{
bll_contract = new BLL_Contract();
DataTable tabletype = new DataTable();
tabletype = bll_contract.GetDataConboTypeContract(ref err);
foreach (DataRow row in tabletype.Rows)
{
if (cbo_name_contract.SelectedItem.Equals(row["Type_Name_Contract"]))
{
cbo_type_contract.SelectedItem = row["Name_Type"];
}
}
}
// check id_code exits in table person notary
private bool check_id_code(ref string err, string id_code, ref DTO_Person_Notatry dto)
{
bll_contract = new BLL_Contract();
DataTable dt = new DataTable();
dt = bll_contract.Check_id_code(ref err, id_code);
foreach (DataRow row in dt.Rows)
{
dto.Id = (int)row["ID_NPerson"];
dto.Id_code = (string)row["ID_Code"];
dto.Name = (string)row["LastName"];
dto.Address = (string)row["NPerson_Address"];
dto.Phone = "";
}
return(dt.Rows.Count != 0 ? true : false);
}
private void txt_number_no_Leave(object sender, EventArgs e)
{
table = new DataTable();
bll_contract = new BLL_Contract();
DTO_Contract dto_contract = new DTO_Contract();
table = bll_contract.Load_data_all_control_with_noNum(ref err, txt_number_no.Text);
bool stt = false;
stt = table.Rows.Count > 0 ? true : false;
if (stt)
{
setDatabaseToDTO(table, bll_contract, ref dto_contract);
SetDTOToControl(dto_contract);
}
}
private void tol_cbo_show_SelectedIndexChanged(object sender, EventArgs e)
{
table_Contract = new DataTable();
bll_contact = new BLL_Contract();
tol_cbo_year.Enabled = true;
tol_cbo_month.Enabled = true;
tol_cbo_day.Enabled = true;
if (tol_cbo_show.SelectedItem.Equals("Xem Tất Cả"))
{
tol_cbo_year.Enabled = false;
tol_cbo_month.Enabled = false;
tol_cbo_day.Enabled = false;
table_Contract = bll_contact.GetDataTableViewContract(ref err);
dataGridView1.DataSource = table_Contract;
}
if (tol_cbo_show.SelectedItem.Equals("Xem Theo Năm"))
{
tol_cbo_month.Enabled = false;
tol_cbo_day.Enabled = false;
int year = (int)tol_cbo_year.SelectedItem;
table_Contract = bll_contact.Load_data_with_Year(ref err, year);
dataGridView1.DataSource = table_Contract;
}
if (tol_cbo_show.SelectedItem.Equals("Xem Theo Tháng"))
{
tol_cbo_day.Enabled = false;
int month = (int)tol_cbo_month.SelectedItem;
table_Contract = bll_contact.Load_data_with_Month(ref err, month);
dataGridView1.DataSource = table_Contract;
}
if (tol_cbo_show.SelectedItem.Equals("Xem Theo Ngày"))
{
tol_cbo_day.Enabled = (tol_cbo_day.Enabled == false) ? true : true;
int day = DateTime.Now.Day;
if (tol_cbo_day.SelectedItem != null)
{
day = (int)tol_cbo_day.SelectedItem;
}
table_Contract = bll_contact.Load_data_with_Day(ref err, day);
dataGridView1.DataSource = table_Contract;
}
}
private void tol_find_SelectedIndexChanged(object sender, EventArgs e)
{
table_Contract = new DataTable();
dto_contract = new DTO_Contract();
bll_contact = new BLL_Contract();
if (tol_find.SelectedItem.Equals("Theo Tên"))
{
table_Contract = bll_contact.Load_data_with_name(ref err, tol_txt_find.Text);
if (stt)
{
if (tol_txt_find.Text == "")
{
MessageBox.Show("Bạn chưa điền tên");
tol_txt_find.Focus();
}
}
dataGridView1.DataSource = table_Contract;
}
if (tol_find.SelectedItem.Equals("Theo CMND"))
{
table_Contract = bll_contact.Load_data_with_id_code(ref err, tol_txt_find.Text);
if (stt)
{
if (tol_txt_find.Text == "")
{
MessageBox.Show("Bạn chưa điền CMND");
tol_txt_find.Focus();
}
}
dataGridView1.DataSource = table_Contract;
}
if (tol_find.SelectedItem.Equals("Theo SCC"))
{
table_Contract = bll_contact.Load_data_with_no_num(ref err, tol_txt_find.Text);
if (stt)
{
if (tol_txt_find.Text == "")
{
MessageBox.Show("Bạn chưa điền SCC");
tol_txt_find.Focus();
}
}
dataGridView1.DataSource = table_Contract;
}
}
//private bool LoadDatabaseDTO(ref List<DTO_Person_Notatry> ls_dto, string id_code)
//{
// bll_contract = new BLL_Contract();
// SqlDataReader dataReader = null;
// if (dataReader != null)
// {
// while (dataReader.Read())
// {
// foreach (DTO_Person_Notatry item in ls_dto)
// {
// item.Id = (int)dataReader["ID_NPerson"];
// item.Id_code = (string)dataReader["ID_Code"];
// item.Name = (string)dataReader["LastName"];
// item.Address = (string)dataReader["NPerson_Address"];
// item.Phone = "";
// }
// }
// return true;
// }
// return false;
//}
private bool LoadDatabaseDTO(ref DTO_Person_Notatry dto, string id_code)
{
bll_contract = new BLL_Contract();
SqlDataReader dataReader = null;
if (dataReader != null)
{
while (dataReader.Read())
{
dto.Id = (int)dataReader["ID_NPerson"];
dto.Id_code = (string)dataReader["ID_Code"];
dto.Name = (string)dataReader["LastName"];
dto.Address = (string)dataReader["NPerson_Address"];
dto.Phone = "";
}
return(true);
}
return(false);
}
private void setDatabaseToDTO(DataTable table, BLL_Contract bll, ref DTO_Contract dto)
{
foreach (DataRow row in table.Rows)
{
dto.No_number = (string)row["Notary_Number"];
dto.Description = (string)row["Description"];
dto.Notary_date = (DateTime)row["Notary_Date"];
dto.Sign_date = (DateTime)row["Sign_Date"];
dto.Price = (double)row["Notary_Price"];
dto.Note = (string)row["Note"];
dto.Dto_person_notary.Id_code = (string)row["ID_Code"];
dto.Dto_person_notary.Name = (string)row["LastName"];
dto.Dto_person_notary.Address = (string)row["NPerson_Address"];
dto.Dto_person_notary.Phone = "";
dto.Dto_name_contract.Name_contract = (string)row["Type_Name_Contract"];
dto.Dto_type_contract.Name_type = (string)row["Name_Type"];
dto.Dto_notarybook.Number_book = (int)row["Number_Of_Book"];
dto.Dto_notarybook.Year_book = (int)row["Year_Book"];
dto.Dto_notary.Name = (string)row["Name_Notary"];
}
}
