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"]; } }