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 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 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_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 void setAllcontrolToDTO(ref DTO_Contract dto) { dto.No_number = (string)txt_number_no.Text; dto.Dto_person_notary.Name = txt_name_p.Text; dto.Dto_person_notary.Id_code = txt_id_code.Text; dto.Dto_person_notary.Address = txt_address.Text; dto.Dto_person_notary.Phone = ""; dto.Notary_date = dpk_date_ask.Value; dto.Sign_date = dpk_date_sign.Value; dto.Dto_notarybook.Number_book = Convert.ToInt32(cbo_num_bo.SelectedItem.ToString()); dto.Description = txt_description.Text; dto.Dto_name_contract.Name_contract = cbo_name_contract.SelectedItem.ToString(); dto.Dto_type_contract.Name_type = cbo_type_contract.SelectedItem.ToString(); dto.Price = Convert.ToDouble(txt_price.Text); dto.Note = txt_note.Text; dto.Dto_notary.Name = "Lê Thị Ngọc hiêp"; dto.Dto_notarybook.Year_book = Convert.ToInt32(cbo_year.SelectedItem.ToString()); }
public void LoadGridViewToDTO(DTO_Contract dto) { dto.No_number = dataGridView1.CurrentRow.Cells["col_no_num"].Value.ToString(); dto.Dto_person_notary.Name = dataGridView1.CurrentRow.Cells["col_name"].Value.ToString(); dto.Dto_person_notary.Id_code = dataGridView1.CurrentRow.Cells["col_id_code"].Value.ToString(); dto.Dto_person_notary.Address = dataGridView1.CurrentRow.Cells["col_address"].Value.ToString(); dto.Dto_person_notary.Phone = ""; dto.Notary_date = (DateTime)dataGridView1.CurrentRow.Cells["col_no_date"].Value; dto.Sign_date = (DateTime)dataGridView1.CurrentRow.Cells["col_sig_date"].Value; dto.Dto_notarybook.Number_book = Convert.ToInt32(dataGridView1.CurrentRow.Cells["col_nu_book"].Value.ToString()); dto.Description = dataGridView1.CurrentRow.Cells["col_des"].Value.ToString(); dto.Dto_name_contract.Name_contract = dataGridView1.CurrentRow.Cells["col_type_name"].Value.ToString(); dto.Dto_type_contract.Name_type = dataGridView1.CurrentRow.Cells["col_type"].Value.ToString(); dto.Price = Convert.ToDouble(dataGridView1.CurrentRow.Cells["col_price"].Value.ToString()); dto.Note = dataGridView1.CurrentRow.Cells["col_not"].Value.ToString(); dto.Dto_notary.Name = dataGridView1.CurrentRow.Cells["col_name_no"].Value.ToString(); dto.Dto_notarybook.Year_book = Convert.ToInt32(((DateTime)dataGridView1.CurrentRow.Cells["col_no_date"].Value).Year); }
// Area set controls and DTO private void SetDTOToControl(DTO_Contract _dto) { if (_dto != null) { txt_number_no.Text = _dto.No_number; txt_name_p.Text = _dto.Dto_person_notary.Name; txt_id_code.Text = _dto.Dto_person_notary.Id_code; txt_address.Text = _dto.Dto_person_notary.Address; dpk_date_ask.Value = _dto.Notary_date; dpk_date_sign.Value = _dto.Sign_date; cbo_num_bo.SelectedItem = _dto.Dto_notarybook.Number_book; txt_description.Text = _dto.Description; cbo_name_contract.SelectedItem = _dto.Dto_name_contract.Name_contract; cbo_type_contract.SelectedItem = _dto.Dto_type_contract.Name_type; txt_price.Text = _dto.Price.ToString(); txt_note.Text = _dto.Note; cbo_year.SelectedItem = _dto.Dto_notarybook.Year_book; } }
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"]; } }
private void dataGridView1_Click(object sender, EventArgs e) { dto_contract = new DTO_Contract(); dto_contract.No_number = dataGridView1.CurrentRow.Cells[""].Value.ToString(); }
private void dataGridView1_Click(object sender, EventArgs e) { dto_contract = new DTO_Contract(); LoadGridViewToDTO(dto_contract); }