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