private void BtnSave_Click(object sender, EventArgs e) { PrintArea printArea = new PrintArea(); //Transfering content of dgvInvoice and txtGTotal to PrintArea.dgvPrint and PrintArea.txtPrintTotal String dateNow = DateTime.Now.ToString(), tDate = DateTime.Now.ToShortDateString(); String tTime = DateTime.Now.ToShortTimeString(); String transactionId = "TTc" + dateNow; foreach (DataGridViewRow dr in this.dgvInvoice.SelectedRows) { String insertQuery = "INSERT INTO business_transaction(TRANSACTION_ID, TRANSACTION_DATE, TRANSACTION_TIME, ITEM_SOLD, QUANTITY_SOLD) VALUES ('" + transactionId + "','" + tDate + "','" + tTime + "','" + dr.Cells[0].Value + "', '" + dr.Cells[2].Value + "') "; dbConnect connect = new dbConnect(); connect.Insert(insertQuery); //printArea.dgvPrintF.Rows.Add(dr.Cells[0].Value, dr.Cells[1].Value, dr.Cells[2].Value, dr.Cells[3].Value); } //printArea.txtPrintTotal.Text = this.txtGTotal.Text; dgvInvoice.Rows.Clear(); txtGTotal.Text = ""; MessageBox.Show("Transaction Completed Successfully"); //printArea.Show(); //this.Hide(); }
//Add employee Data private void btnAdd_Click(object sender, EventArgs e) { try { String insertQuery = "INSERT INTO employee(STAFF_ID, FIRST_NAME, LAST_NAME, GENDER, DATE_OF_BIRTH, USER_TYPE, USER_PASSWORD, SECURITY_QUESTION, ANSWER) VALUES ('" + txtStaff_id.Text + "','" + txtFName.Text + "','" + txtLName.Text + "','" + cmbGender.Text + "','" + dtpDod.Text + "','" + cmbUserType.Text + "','" + txtPassword.Text + "','" + cmbSQ.Text + "','" + txtAnswer.Text + "') "; dbConnect connect = new dbConnect(); connect.Insert(insertQuery); MessageBox.Show("Data Inserted Successfully"); } catch (Exception error) { MessageBox.Show(error.Message); } loadEmployee(); }
//Add Product private void btnInsertP_Click(object sender, EventArgs e) { String insertQuery = "INSERT INTO products(PRODUCT_ID, PRODUCT_NAME, QUANTITY, PRICE ) VALUES ('" + txtPID.Text + "','" + txtPName.Text + "','" + txtQty.Text + "','" + txtPrice.Text + "') "; dbConnect connect = new dbConnect(); if (txtPID.Text != "" && txtPName.Text != "" && txtQty.Text != "" && txtPrice.Text != "") { connect.Insert(insertQuery); MessageBox.Show("Product Inserted Successfully"); } else { MessageBox.Show("Invalid Entry"); } loadProduct(); }