private void getExistingShowPiecesSold() { //Open connection if not already if (connection.State == ConnectionState.Closed) { connection.Open(); } try { string selectStatement = "SELECT * FROM ShowPieces WHERE ShowNo = " + show.showNo + " AND Sold = " + true + " ;"; OleDbCommand selectCmd = new OleDbCommand(selectStatement, connection); //execute reader and close reader OleDbDataReader reader = selectCmd.ExecuteReader(); while (reader.Read()) { showPiece temp = new showPiece(); temp.itemNo = Convert.ToInt32(reader["ItemNo"]); temp.patternName = Convert.ToString(reader["PatternName"]); temp.pieceName = Convert.ToString(reader["PieceName"]); temp.showNo = Convert.ToInt32(reader["ShowNo"]); temp.pieceSize = Convert.ToDecimal(reader["PieceSize"]); temp.sold = Convert.ToBoolean(reader["Sold"]); getShowPieceSold(temp, false); } } catch (Exception exp) { MessageBox.Show(exp.ToString()); } connection.Close(); }
private void btnMoveToTaken_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dgvSold.SelectedRows) { showPiece temp = new showPiece(); temp.showNo = show.showNo; temp.itemNo = Convert.ToInt32((this.dgvSold.Rows[row.Index].Cells[0].Value).ToString()); temp.pieceName = Convert.ToString((this.dgvSold.Rows[row.Index].Cells[1].Value).ToString()); temp.patternName = Convert.ToString((this.dgvSold.Rows[row.Index].Cells[2].Value).ToString()); temp.pieceSize = Convert.ToDecimal((this.dgvSold.Rows[row.Index].Cells[3].Value).ToString()); temp.sold = false; piecesSold.RemoveAt(row.Index); dgvSold.Rows.Remove(row); getShowPieceTaken(temp); } }
private void getShowPieceTaken(showPiece pPiece) { showPiece temp = new showPiece(); temp.showNo = pPiece.showNo; temp.itemNo = pPiece.itemNo; temp.sold = pPiece.sold; temp.pieceName = pPiece.pieceName; temp.patternName = pPiece.patternName; temp.pieceSize = pPiece.pieceSize; piecesTaken.Add(temp); DataGridViewRow newRow = new DataGridViewRow(); newRow.CreateCells(dgvPiecesTaken); newRow.Cells[0].Value = temp.itemNo; newRow.Cells[1].Value = temp.pieceName; newRow.Cells[2].Value = temp.patternName; newRow.Cells[3].Value = temp.pieceSize; dgvPiecesTaken.Rows.Add(newRow); }
public void getShowPieceTaken(LineItem pItem) { showPiece temp = new showPiece(); temp.showNo = show.showNo; temp.itemNo = takenPieces; temp.sold = false; temp.pieceName = DatabaseAccess.GetPieceByNo(pItem.pieceNo).pieceName; temp.patternName = DatabaseAccess.GetPatternByNo(pItem.patternNo).patternName; temp.pieceSize = DatabaseAccess.GetPieceSizeByNo(pItem.pieceNo, pItem.sizeNo).totalPounds; piecesTaken.Add(temp); DataGridViewRow newRow = new DataGridViewRow(); newRow.CreateCells(dgvPiecesTaken); newRow.Cells[0].Value = temp.itemNo; newRow.Cells[1].Value = temp.pieceName; newRow.Cells[2].Value = temp.patternName; newRow.Cells[3].Value = temp.pieceSize; dgvPiecesTaken.Rows.Add(newRow); updateShowPieces(); takenPieces++; }
private void getShowPieceSold(showPiece pPiece, bool newPieceSold) { showPiece temp = new showPiece(); temp.showNo = pPiece.showNo; temp.itemNo = pPiece.itemNo; temp.sold = pPiece.sold; temp.pieceName = pPiece.pieceName; temp.patternName = pPiece.patternName; temp.pieceSize = pPiece.pieceSize; piecesSold.Add(temp); DataGridViewRow newRow = new DataGridViewRow(); newRow.CreateCells(dgvSold); newRow.Cells[0].Value = temp.itemNo; newRow.Cells[1].Value = temp.pieceName; newRow.Cells[2].Value = temp.patternName; newRow.Cells[3].Value = temp.pieceSize; dgvSold.Rows.Add(newRow); if (newPieceSold) { updateShowPieces(); } }