public bool DeleteAuthorDetailToDatabase(CAuthorDetailDTO _auhorDetailObject) { m_cmd = new SqlCommand(); m_cmd.CommandType = CommandType.StoredProcedure; m_cmd.CommandText = "DeleteAuthorDetailDataToDatabase"; m_cmd.Parameters.Add("MaDauSach", SqlDbType.NVarChar).Value = _auhorDetailObject.maDauSach; return(m_auhorDetailExecute.updateData(m_cmd) > 0); }
private void btnSave_Click(object sender, EventArgs e) { try { if (m_IsAdd) { m_BookTitlesObject = new CBookTitlesDTO(txtBookTitlesId.Text, lkBookGenreName.EditValue.ToString(), txtBookTitlesName.Text); m_BookTitlesExecute.AddBookTitlesToDatabase(m_BookTitlesObject); foreach (CheckedListBoxItem _authorName in chkCmbAuthorName.Properties.Items) { if (_authorName.CheckState == CheckState.Checked) { m_AuthorDetailObject = new CAuthorDetailDTO(m_BookTitlesExecute.getBookTitlesMaxIdFromDatabase(), _authorName.Value.ToString()); m_AuthorDetailExecute.AddAuthorDetailToDatabase(m_AuthorDetailObject); } } } else { m_BookTitlesObject = new CBookTitlesDTO(txtBookTitlesId.Text, lkBookGenreName.EditValue.ToString(), txtBookTitlesName.Text); m_BookTitlesExecute.UpdateBookTitlesToDatabase(m_BookTitlesObject); _listAuthorNameSecond = new ArrayList(chkCmbAuthorName.EditValue.ToString().Split(new string[] { ", " }, StringSplitOptions.None)); foreach (object item in _listAuthorNameFirst) { if (!_listAuthorNameSecond.Contains(item)) { m_AuthorDetailExecute.DeleteAuthorDetailToDatabase(new CAuthorDetailDTO(txtBookTitlesId.Text, item.ToString())); } } foreach (object item in _listAuthorNameSecond) { if (!_listAuthorNameFirst.Contains(item)) { m_AuthorDetailExecute.AddAuthorDetailToDatabase(new CAuthorDetailDTO(txtBookTitlesId.Text, item.ToString())); } } } //m_AuthorDetailObject = new CAuthorDetailDTO(m_BookTitlesExecute.getBookTitlesMaxIdFromDatabase(),chkCmbAuthorName.) } catch (System.Exception ex) { XtraMessageBox.Show(ex.ToString(), "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); } finally { updateEnableButtonAndResetValueOfControl(ref btnSave); } }
private void btnDelete_Click(object sender, EventArgs e) { try { ArrayList _listBookTitleObjectInDelibility = new ArrayList(); foreach (object _rowObjectItem in m_BookTitlesMulitSelect.Selection) { grdvListBookTitles.FocusedRowHandle -= 1; DataRowView _rowObjectDetail = _rowObjectItem as DataRowView; m_BookTitlesObject = new CBookTitlesDTO(); m_BookTitlesObject.maDauSach = _rowObjectDetail["MaDauSach"].ToString(); m_AuthorDetailObject = new CAuthorDetailDTO(); m_AuthorDetailObject.maDauSach = _rowObjectDetail["MaDauSach"].ToString(); if (m_AuthorDetailExecute.DeleteAuthorDetailToDatabase(m_AuthorDetailObject)) { if (!m_BookTitlesExecute.DeleteBookTitlesToDatabase(m_BookTitlesObject)) { _listBookTitleObjectInDelibility.Add(_rowObjectDetail["MaDauSach"]); } } else { _listBookTitleObjectInDelibility.Add(_rowObjectDetail["MaDauSach"]); } } if (_listBookTitleObjectInDelibility.Count != 0) { String _erroContent = "Không thể xóa các cuốn sách có mã: \n"; foreach (var item in _listBookTitleObjectInDelibility) { _erroContent += item.ToString() + "\n"; } XtraMessageBox.Show(_erroContent); } else { XtraCustomMessageBox.Show("Xóa dữ liệu thành công!", "Thông báo", true); } } catch (System.Exception) { XtraCustomMessageBox.Show("Xóa dữ liệu thất bại!", "Lỗi", true); } finally { updateEnableButtonAndResetValueOfControl(ref btnDelete); } }
private void btnSave_Click(object sender, EventArgs e) { if (!checkData()) { return; } try { if (m_IsAdd) { m_BookTitlesObject = new CBookTitlesDTO("DS0000000", lkBookGenreName.EditValue.ToString(), txtBookTitlesName.Text); if (m_BookTitlesExecute.AddBookTitlesToDatabase(m_BookTitlesObject)) { XtraCustomMessageBox.Show("Thêm dữ liệu thành công!", "Thông báo", true); } else { XtraCustomMessageBox.Show("Thêm dữ liệu thất bại!", "Lỗi", true); } foreach (CheckedListBoxItem _authorName in chkCmbAuthorName.Properties.Items) { if (_authorName.CheckState == CheckState.Checked) { m_AuthorDetailObject = new CAuthorDetailDTO(m_BookTitlesExecute.getBookTitlesMaxIdFromDatabase(), _authorName.Value.ToString()); m_AuthorDetailExecute.AddAuthorDetailToDatabase(m_AuthorDetailObject); } } } else { m_BookTitlesObject = new CBookTitlesDTO(txtBookTitlesId.Text, lkBookGenreName.EditValue.ToString(), txtBookTitlesName.Text); if (m_BookTitlesExecute.UpdateBookTitlesToDatabase(m_BookTitlesObject)) { XtraCustomMessageBox.Show("Cập nhật dữ liệu thành công!", "Thông báo", true); } else { XtraCustomMessageBox.Show("Cập nhật dữ liệu thất bại!", "Lỗi", true); } _listAuthorNameSecond = new ArrayList(chkCmbAuthorName.EditValue.ToString().Split(new string[] { ", " }, StringSplitOptions.None)); foreach (object item in _listAuthorNameFirst) { if (!_listAuthorNameSecond.Contains(item)) { m_AuthorDetailExecute.DeleteAuthorDetailToDatabase(new CAuthorDetailDTO(txtBookTitlesId.Text, item.ToString())); } } foreach (object item in _listAuthorNameSecond) { if (!_listAuthorNameFirst.Contains(item)) { m_AuthorDetailExecute.AddAuthorDetailToDatabase(new CAuthorDetailDTO(txtBookTitlesId.Text, item.ToString())); } } } //m_AuthorDetailObject = new CAuthorDetailDTO(m_BookTitlesExecute.getBookTitlesMaxIdFromDatabase(),chkCmbAuthorName.) } catch (System.Exception) { XtraCustomMessageBox.Show("Lưu dữ liệu thất bại", "Thông báo", true); } finally { updateEnableButtonAndResetValueOfControl(ref btnSave); } }
public bool UpdateAuthorDetailToDatabase(CAuthorDetailDTO _authorDetailObject) { return(m_AuthorDetailDAL.UpdateAuthorDetailToDatabase(_authorDetailObject)); }
public bool AddAuthorDetailToDatabase(CAuthorDetailDTO _authorDetailObject) { return(m_AuthorDetailDAL.AddAuthorDetailToDatabase(_authorDetailObject)); }
public CAuthorDetailDAL() { m_auhorDetailObject = null; m_auhorDetailExecute = new CDataExecute(); m_cmd = new SqlCommand(); }
public CAuthorDetailDAL(CAuthorDetailDTO _auhorDetailObject) { m_auhorDetailObject = _auhorDetailObject; m_auhorDetailExecute = new CDataExecute(); m_cmd = new SqlCommand(); }