public bool DeleteBookTitlesToDatabase(CBookTitlesDTO _bookTitlesObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "DeleteBookTitlesDataToDatabase";
m_cmd.Parameters.Add("MaDauSach", SqlDbType.NVarChar).Value = _bookTitlesObject.maDauSach;
return(m_bookTitlesExecute.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);
}
}
public bool UpdateBookTitlesToDatabase(CBookTitlesDTO _bookTitlesObject)
{
return(m_BookTitlesDAL.UpdateBookTitlesToDatabase(_bookTitlesObject));
}
public bool AddBookTitlesToDatabase(CBookTitlesDTO _bookTitlesObject)
{
return(m_BookTitlesDAL.AddBookTitlesToDatabase(_bookTitlesObject));
}
public CBookTitlesDAL()
{
m_bookTitlesObject = null;
m_bookTitlesExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
public CBookTitlesDAL(CBookTitlesDTO _bookTitlesObject)
{
m_bookTitlesObject = _bookTitlesObject;
m_bookTitlesExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
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);
}
}
