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 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);
}
}