private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (m_IsAdd)
{
m_BookObject = new CBookDTO(txtBookId.Text,
lkBookTitlesName.EditValue.ToString(),
lkPublisherName.EditValue.ToString(),
(int)spBookRealeaseYear.Value,
spBookPrices.Value, 0);
m_BookExecute.AddBookToDatabase(m_BookObject);
m_BookData = m_BookExecute.getBookDataFromDatabase();
}
else
{
m_BookObject = new CBookDTO(txtBookId.Text,
lkBookTitlesName.EditValue.ToString(),
lkPublisherName.EditValue.ToString(),
(int)spBookRealeaseYear.Value,
spBookPrices.Value,
(int)spBookCount.Value);
m_BookExecute.UpdateBookToDatabase(m_BookObject);
}
}
catch (System.Exception)
{
}
finally
{
updateEnableButtonAndResetValueOfControl(ref btnUpdate);
}
}
public bool DeleteBookToDatabase(CBookDTO _bookObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "DeleteBookDataToDatabase";
m_cmd.Parameters.Add("MaSach", SqlDbType.NVarChar).Value = _bookObject.maSach;
return(m_bookExecute.updateData(m_cmd) > 0);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!checkData())
{
return;
}
if (m_IsAdd)
{
try
{
m_BookObject = new CBookDTO("SA0000000",
lkBookTitlesName.EditValue.ToString(),
lkPublisherName.EditValue.ToString(),
int.Parse(txtBookRealeaseYear.Text),
0, 0);
if (m_BookExecute.AddBookToDatabase(m_BookObject))
{
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);
}
}
catch (System.Exception)
{
XtraCustomMessageBox.Show("Thêm dữ liệu thất bại!", "Lỗi", true);
}
}
else
{
try
{
m_BookObject = new CBookDTO(txtBookId.Text,
lkBookTitlesName.EditValue.ToString(),
lkPublisherName.EditValue.ToString(),
int.Parse(txtBookRealeaseYear.Text),
int.Parse(txtBookPrices.Text), int.Parse(txtBookCount.Text));
if (!m_BookExecute.UpdateBookToDatabase(m_BookObject))
{
XtraCustomMessageBox.Show("Cập nhật dữ liệu thất bại!", "Thông báo", true);
}
else
{
XtraCustomMessageBox.Show("Cập nhật dữ liệu thành công!", "Thông báo", true);
}
}
catch (System.Exception)
{
}
}
updateEnableButtonAndResetValueOfControl(ref btnSave);
}
public bool UpdateBookToDatabase(CBookDTO _bookObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "UpdateBookDataToDatabase";
m_cmd.Parameters.Add("MaSach", SqlDbType.NVarChar).Value = _bookObject.maSach;
m_cmd.Parameters.Add("MaDauSach", SqlDbType.NVarChar).Value = _bookObject.maDauSach;
m_cmd.Parameters.Add("MaNXB", SqlDbType.NVarChar).Value = _bookObject.maNhaXuatBan;
m_cmd.Parameters.Add("GiaNhap", SqlDbType.Int).Value = _bookObject.giaNhap;
m_cmd.Parameters.Add("SoLuong", SqlDbType.Int).Value = _bookObject.soLuong;
m_cmd.Parameters.Add("NamXB", SqlDbType.Int).Value = _bookObject.namXuatBan;
return(m_bookExecute.updateData(m_cmd) > 0);
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
ArrayList _listBookObject = new ArrayList();
foreach (object _rowObjectItem in m_BookMultiSelect.Selection)
{
grdvListBook.FocusedRowHandle -= 1;
DataRowView _rowObjectDetail = _rowObjectItem as DataRowView;
m_BookObject = new CBookDTO();
m_BookObject.maSach = _rowObjectDetail["MaSach"].ToString();
//m_BookObject = new CBookDTO(txtBookId.Text, lkBookTitlesName.EditValue.ToString(), lkPublisherName.EditValue.ToString(), (int)spBookRealeaseYear.Value, spBookPrices.Value, (int)spBookCount.Value);
if (!m_BookExecute.DeleteBookToDatabase(m_BookObject))
{
_listBookObject.Add(_rowObjectDetail.Row["MaSach"]);
}
}
if (_listBookObject.Count != 0)
{
String _erroContent = "Không thể xóa các cuốn sách có mã sau: \n";
foreach (var item in _listBookObject)
{
_erroContent += item.ToString() + "\n";
}
XtraCustomMessageBox.Show(_erroContent, "Lỗi", true);
}
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!", "Thông báo", true);
}
finally
{
updateEnableButtonAndResetValueOfControl(ref btnDelete);
}
}
public CBookDAL()
{
m_bookObject = null;
m_bookExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
public CBookDAL(CBookDTO _bookObject)
{
m_bookObject = _bookObject;
m_bookExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
public bool UpdateBookToDatabase(CBookDTO _bookObject)
{
return(m_BookDAL.UpdateBookToDatabase(_bookObject));
}
public bool DeleteBookToDatabase(CBookDTO _bookObject)
{
return(m_BookDAL.DeleteBookToDatabase(_bookObject));
}
public bool AddBookToDatabase(CBookDTO _bookObject)
{
return(m_BookDAL.AddBookToDatabase(_bookObject));
}
