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 DeleteReceiptNoteToDatabase(CReceiptNoteDTO _ReceiptNoteObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "DeleteReceiptNoteDataToDatabase";
m_cmd.Parameters.Add("MaPhieuNhap", SqlDbType.NVarChar).Value = _ReceiptNoteObject.maPhieuNhap;
return(m_ReceiptNoteExecute.updateData(m_cmd) > 0);
}
public bool UpdateReceiptNoteToDatabase(CReceiptNoteDTO _ReceiptNoteObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "UpdateReceiptNoteDataToDatabase";
m_cmd.Parameters.Add("MaPhieuNhap", SqlDbType.NVarChar).Value = _ReceiptNoteObject.maPhieuNhap;
m_cmd.Parameters.Add("MaNV", SqlDbType.NVarChar).Value = _ReceiptNoteObject.maNhanVien;
m_cmd.Parameters.Add("NgayNhapSach", SqlDbType.SmallDateTime).Value = _ReceiptNoteObject.ngayNhap;
m_cmd.Parameters.Add("TongSoLuong", SqlDbType.Int).Value = _ReceiptNoteObject.TongSoLuong;
m_cmd.Parameters.Add("TongTien", SqlDbType.Int).Value = _ReceiptNoteObject.TongTien;
return(m_ReceiptNoteExecute.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 CReceiptNoteDAL()
{
m_ReceiptNoteObject = null;
m_ReceiptNoteExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
public CReceiptNoteDAL(CReceiptNoteDTO _ReceiptNoteObject)
{
m_ReceiptNoteObject = _ReceiptNoteObject;
m_ReceiptNoteExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
public bool UpdateReceiptNoteToDatabase(CReceiptNoteDTO _ReceiptNoteObject)
{
return(m_ReceiptNoteDAL.UpdateReceiptNoteToDatabase(_ReceiptNoteObject));
}
public bool AddReceiptNoteToDatabase(CReceiptNoteDTO _ReceiptNoteObject)
{
return(m_ReceiptNoteDAL.AddReceiptNoteToDatabase(_ReceiptNoteObject));
}
