private void btnSave_Click(object sender, EventArgs e)
{
if (m_ReceiptNoteDetailData.Rows.Count != 0)
{
m_ReceiptNoteObject = new CReceiptNoteDTO("PN00000000",
DateTime.ParseExact(labReceiptDateValue.Text, "dd/MM/yyyy", null),
"NV0000001",
int.Parse(grdvReceiptBook.Columns["SoLuong"].SummaryItem.SummaryValue.ToString()),
int.Parse(grdvReceiptBook.Columns["ThanhTien"].SummaryItem.SummaryValue.ToString()));
if (m_ReceiptNoteExecute.AddReceiptNoteToDatabase(m_ReceiptNoteObject))
{
_maPhieuNhap = m_ReceiptNoteExecute.getReceiptNoteMaxIdFromDatabase();
foreach (DataRow _rowValue in m_ReceiptNoteDetailData.Select())
{
m_ReceiptNoteDetailObject = new CReceiptNoteDetailDTO();
m_ReceiptNoteDetailObject.maPhieuNhap = _maPhieuNhap;
m_ReceiptNoteDetailObject.maSach = _rowValue["MaSach"].ToString();
m_ReceiptNoteDetailObject.soLuong = int.Parse(_rowValue["SoLuong"].ToString());
m_ReceiptNoteDetailObject.thanhTien = int.Parse(_rowValue["ThanhTien"].ToString());
m_ReceiptNoteDetailObject.giaNhap = int.Parse(_rowValue["DonGia"].ToString());
m_ReceiptNoteDetailExecute.AddReceiptNoteDetailToDatabase(m_ReceiptNoteDetailObject);
}
}
m_BookData = m_BookExecute.getBookDataFromDatabase();
grdListBook.DataSource = m_BookData;
}
else
{
XtraMessageBox.Show("Không có cuốn sách nào được nhập!\nXin vui lòng kiểm tra lại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public bool DeleteReceiptNoteDetailToDatabase(CReceiptNoteDetailDTO _ReceiptNoteDetailObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "DeleteReceiptNoteDetailDataToDatabase";
m_cmd.Parameters.Add("MaPhieuNhap", SqlDbType.NVarChar).Value = _ReceiptNoteDetailObject.maPhieuNhap;
return(m_ReceiptNoteDetailExecute.updateData(m_cmd) > 0);
}
public bool UpdateReceiptNoteDetailToDatabase(CReceiptNoteDetailDTO _ReceiptNoteDetailObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "UpdateReceiptNoteDetailDataToDatabase";
m_cmd.Parameters.Add("MaPhieuNhap", SqlDbType.NVarChar).Value = _ReceiptNoteDetailObject.maPhieuNhap;
m_cmd.Parameters.Add("MaSach", SqlDbType.NVarChar).Value = _ReceiptNoteDetailObject.maSach;
m_cmd.Parameters.Add("DonGia", SqlDbType.Money).Value = _ReceiptNoteDetailObject.giaNhap;
m_cmd.Parameters.Add("SoLuong", SqlDbType.Int).Value = _ReceiptNoteDetailObject.soLuong;
m_cmd.Parameters.Add("ThanhTien", SqlDbType.Money).Value = _ReceiptNoteDetailObject.thanhTien;
return(m_ReceiptNoteDetailExecute.updateData(m_cmd) > 0);
}
private void btnWrite_Click(object sender, EventArgs e)
{
try
{
if (m_ReceiptNoteDetailData.Rows.Count != 0)
{
m_ReceiptNoteObject = new CReceiptNoteDTO("PN00000000",
DateTime.ParseExact(labReceiptDateValue.Text, "dd/MM/yyyy", null),
ucLogin.m_EmployeeObject.maNhanVien,
int.Parse(grdvReceiptBook.Columns["SoLuong"].SummaryItem.SummaryValue.ToString()),
int.Parse(grdvReceiptBook.Columns["ThanhTien"].SummaryItem.SummaryValue.ToString()));
if (m_ReceiptNoteExecute.AddReceiptNoteToDatabase(m_ReceiptNoteObject))
{
_maPhieuNhap = m_ReceiptNoteExecute.getReceiptNoteMaxIdFromDatabase();
foreach (DataRow _rowValue in m_ReceiptNoteDetailData.Select())
{
m_ReceiptNoteDetailObject = new CReceiptNoteDetailDTO();
m_ReceiptNoteDetailObject.maPhieuNhap = _maPhieuNhap;
m_ReceiptNoteDetailObject.maSach = _rowValue["MaSach"].ToString();
m_ReceiptNoteDetailObject.soLuong = int.Parse(_rowValue["SoLuong"].ToString());
m_ReceiptNoteDetailObject.thanhTien = int.Parse(_rowValue["ThanhTien"].ToString());
m_ReceiptNoteDetailObject.giaNhap = int.Parse(_rowValue["DonGia"].ToString());
m_ReceiptNoteDetailExecute.AddReceiptNoteDetailToDatabase(m_ReceiptNoteDetailObject);
}
}
updateEnableButtonAndResetValueOfControl(ref btnWrite);
XtraCustomMessageBox.Show("Ghi dữ liệu thành công!", "Thông báo", true);
}
else
{
XtraCustomMessageBox.Show("Không có cuốn sách nào được nhập!\nXin vui lòng kiểm tra lại", "Thông báo", true);
}
}
catch (System.Exception)
{
XtraCustomMessageBox.Show("Không thể ghi dữ liệu!", "Lỗi", true);
}
}
public bool UpdateReceiptNoteDetailToDatabase(CReceiptNoteDetailDTO _ReceiptNoteDetailObject)
{
return(m_ReceiptNoteDetailDAL.UpdateReceiptNoteDetailToDatabase(_ReceiptNoteDetailObject));
}
public CReceiptNoteDetailDAL()
{
m_ReceiptNoteDetailObject = null;
m_ReceiptNoteDetailExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
public CReceiptNoteDetailDAL(CReceiptNoteDetailDTO _ReceiptNoteDetailObject)
{
m_ReceiptNoteDetailObject = _ReceiptNoteDetailObject;
m_ReceiptNoteDetailExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
