private void backupDatabaseToolStripMenuItem_Click(object sender, EventArgs e) { SaveFileDialog saveDb = new SaveFileDialog(); string path = Registry.GetValue(@"HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders", "{374DE290-123F-4565-9164-39C4925E467B}", String.Empty).ToString(); dbGc db = new dbGc(); try { saveDb.Filter = "bak files (*.bak)|*.bak|All files (*.*)|*.*"; saveDb.InitialDirectory = path; saveDb.RestoreDirectory = true; saveDb.DefaultExt = "bak"; if (saveDb.ShowDialog() == DialogResult.OK) { db.backupDb(saveDb.FileName); notification notification = new notification("Database backup completed.", notification.AlertType.success); notification.ShowDialog(); } } catch (Exception a) { notification notification = new notification("Database backup error.", notification.AlertType.error); notification.ShowDialog(); return; } }
private void btnUpdate_Click(object sender, EventArgs e) { if (txtSuppName.Text != "" && txtContact.Text != "") { StringBuilder param = new StringBuilder(); StringBuilder values = new StringBuilder(); StringBuilder where = new StringBuilder(); param.Append( "gc_supp_name," + "gc_supp_add," + "gc_contact," + "gc_email," + "gc_other_info" ); values.Append( txtSuppName.Text + "," + txtAddress.Text + "," + txtContact.Text + "," + txtEmail.Text + "," + txtOtherInfo.Text ); where.Append("gc_supp_name='" + suppName + "'"); db.GCUpdateDb("suppliers", param, values, where); notification = new notification("Supplier has been updated.", notification.AlertType.success); notification.ShowDialog(); } else { notification = new notification("Error updating, Please check the fields.", notification.AlertType.success); notification.ShowDialog(); } }
private void BtnSave_Click(object sender, EventArgs e) { StringBuilder param = new StringBuilder(); StringBuilder values = new StringBuilder(); StringBuilder where = new StringBuilder(); param.Append( "gc_item_name," + "gc_item_supp," + "gc_item_brand," + "gc_item_status," + "gc_delivery_date," + "gc_item_cost," + "gc_item_srp," + "gc_item_qty," + "gc_item_code," + "gc_item_type," + "gc_item_desc," + "gc_item_um" ); values.Append( deliveryInfoPage.txtItemName.Text + "," + deliveryInfoPage.cmbSupp.Text + "," + deliveryInfoPage.txtBrand.Text + "," + deliveryInfoPage.cmbItemStatus.Text + "," + deliveryInfoPage.dtDeliveryDate.Value + "," + float.Parse(deliveryInfoPage.txtCost.Text) + "," + float.Parse(deliveryInfoPage.txtSrp.Text) + "," + int.Parse(deliveryInfoPage.txtQty.Text) + "," + deliveryInfoPage.txtItemCode.Text + "," + deliveryInfoPage.cmbItemType.Text + "," + deliveryInfoPage.txtDesc.Text + "," + deliveryInfoPage.txtUm.Text ); where.Append("gc_item_name='" + deliveryInfoPage.itemName + "'"); //where.Append("gc_item_brand='"+deliveryInfoPage.itemBrand+"'"); //where.Append("gc_item_supp='"+deliveryInfoPage.itemSupp+"'"); db.GCUpdateDb("delivery", param, values, where); DataTable dt = db.GCSelectFromDb("delivery", null, null); dgDelivery.DataSource = null; dgDelivery.DataSource = dt; notification = new notification("Changes has been saved.", notification.AlertType.success); notification.ShowDialog(); deliveryInfoPage.Close(); deliveryInfoPage.btnSave.Click -= BtnSave_Click; }
private void dgUsers_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridView senderGrid = (DataGridView)sender; if (e.ColumnIndex == 6) { editPage.txtFullName.Text = senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString(); editPage.txtUsername.Text = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); editPage.txtPass.Text = senderGrid.Rows[e.RowIndex].Cells[2].Value.ToString(); editPage.txtEmail.Text = senderGrid.Rows[e.RowIndex].Cells[3].Value.ToString(); editPage.txtContact.Text = senderGrid.Rows[e.RowIndex].Cells[4].Value.ToString(); editPage.txtOtherInfo.Text = senderGrid.Rows[e.RowIndex].Cells[5].Value.ToString(); editPage.lblFullName.Text = senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString(); editPage.lblUserName.Text = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); editPage.lblEmail.Text = senderGrid.Rows[e.RowIndex].Cells[3].Value.ToString(); editPage.lblContact.Text = senderGrid.Rows[e.RowIndex].Cells[4].Value.ToString(); uname = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); pword = senderGrid.Rows[e.RowIndex].Cells[2].Value.ToString(); editPage.btnUpdate.Click += BtnUpdate_Click; editPage.ShowDialog(); } else if (e.ColumnIndex == 7) { uname = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); pword = senderGrid.Rows[e.RowIndex].Cells[2].Value.ToString(); StringBuilder whereDel = new StringBuilder(); StringBuilder valDel = new StringBuilder(); whereDel.Append("username,password"); valDel.Append(uname + "," + pword); DialogResult delRes = MessageBox.Show("Are you sure you want to delete this record?", "Delete record?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (delRes == DialogResult.Yes) { db.GCDeleteFromDb("users", valDel, whereDel); DataTable dt = db.GCSelectFromDb("users", null, null); dgUsers.DataSource = null; dgUsers.DataSource = dt; editPage.btnUpdate.Click -= BtnUpdate_Click; notification = new notification("Successfully updated deleted Record.", notification.AlertType.success); notification.ShowDialog(); } } }
private void btnAddDeliver_Click(object sender, EventArgs e) { try { if (txtItemName.Text != "") { StringBuilder param = new StringBuilder(); StringBuilder values = new StringBuilder(); param.Append( "gc_item_name," + "gc_item_supp," + "gc_item_brand," + "gc_item_status," + "gc_order_terms," + "gc_delivery_date," + "gc_item_cost," + "gc_total_price," + "gc_item_qty" ); values.Append( txtItemName.Text + "," + cmbSupp.Text + "," + txtBrand.Text + "," + "not delivered" + "," + int.Parse(txtOrderTerms.Text) + "," + dtDeliveryDate.Value.ToShortDateString() + "," + float.Parse(txtItemPrice.Text) + "," + int.Parse(txtQty.Text) * float.Parse(txtItemPrice.Text) + "," + int.Parse(txtQty.Text) ); delivery.saveDelivery(param, values); dgDelivery.DataSource = null; DataTable dt = db.GCSelectFromDb("delivery", null, null); dgDelivery.DataSource = dt; notification = new notification("Delivery of items is saved.", notification.AlertType.success); notification.ShowDialog(); } else { notification = new notification("Error. Check fields before saving.", notification.AlertType.error); notification.ShowDialog(); } } catch (Exception a) { notification = new notification("Error. Check fields before saving.", notification.AlertType.error); notification.ShowDialog(); } }
private void dgProducts_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridView senderGrid = (DataGridView)sender; if (e.ColumnIndex == 10) { editItemPage.itemCode = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); editItemPage.txtItemName.Text = senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString(); editItemPage.txtItemCode.Text = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); editItemPage.txtUm.Text = senderGrid.Rows[e.RowIndex].Cells[2].Value.ToString(); editItemPage.txtDesc.Text = senderGrid.Rows[e.RowIndex].Cells[3].Value.ToString(); editItemPage.cmbSupp.Text = senderGrid.Rows[e.RowIndex].Cells[4].Value.ToString(); editItemPage.txtBrand.Text = senderGrid.Rows[e.RowIndex].Cells[5].Value.ToString(); editItemPage.txtCost.Text = senderGrid.Rows[e.RowIndex].Cells[6].Value.ToString(); editItemPage.txtSrp.Text = senderGrid.Rows[e.RowIndex].Cells[7].Value.ToString(); editItemPage.cmbItemType.Text = senderGrid.Rows[e.RowIndex].Cells[8].Value.ToString(); editItemPage.btnSave.Click += BtnSave_Click; editItemPage.ShowDialog(); } else if (e.ColumnIndex == 11) { StringBuilder whereDelProd = new StringBuilder(); StringBuilder valuesDelProd = new StringBuilder(); StringBuilder whereDelInv = new StringBuilder(); StringBuilder valuesDelInv = new StringBuilder(); DialogResult delRes = MessageBox.Show("Are you sure you want to delete this Product?", "Delete Product?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (delRes == DialogResult.Yes) { whereDelProd.Append("gc_item_code"); valuesDelProd.Append(senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString()); whereDelInv.Append("gc_item_code"); valuesDelInv.Append(senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString()); db.GCDeleteFromDb("inventory", valuesDelInv, whereDelInv); db.GCDeleteFromDb("products", valuesDelProd, whereDelProd); notification = new notification("Product has been deleted.", notification.AlertType.success); notification.ShowDialog(); DataTable dt = db.GCSelectFromDb("products", null, null, "ORDER BY id DESC"); dgProducts.DataSource = null; dgProducts.DataSource = dt; } } }
private void btnSave_Click(object sender, EventArgs e) { StringBuilder where = new StringBuilder(); where.Append("username='******' AND password='******'"); int resUser = db.searchData("users", null, where); if (resUser >= 1) { notification notification = new notification("Username or password already existing.", notification.AlertType.error); notification.ShowDialog(); } else if (txtUsername.Text != "" && txtPassword.Text != "" && txtFullName.Text != "") { StringBuilder param = new StringBuilder(); StringBuilder values = new StringBuilder(); param.Append( "username," + "password," + "email," + "contact," + "other_info," + "full_name" ); values.Append( txtUsername.Text + "," + txtPassword.Text + "," + txtEmail.Text + "," + txtContact.Text + "," + txtOtherInfo.Text + "," + txtFullName.Text ); db.GCInsertToDb("users", param, values); notification notification = new notification("User has been saved to the database.", notification.AlertType.success); notification.Show(); DataTable dt = db.GCSelectFromDb("users", null, null); dgUsers.DataSource = null; dgUsers.DataSource = dt; } else { notification notification = new notification("Check the fields before saving.", notification.AlertType.error); notification.Show(); } }
private void btnSave_Click(object sender, EventArgs e) { if (txtSuppName.Text != "" && txtContact.Text != "") { StringBuilder whereSearch = new StringBuilder(); whereSearch.Append("gc_supp_name LIKE '" + txtSuppName.Text + "'"); int resSupp = db.searchData("suppliers", null, whereSearch); if (resSupp >= 1) { notification = new notification("Supplier already existing.", notification.AlertType.error); notification.ShowDialog(); } else { StringBuilder param = new StringBuilder(); StringBuilder values = new StringBuilder(); param.Append( "gc_supp_name," + "gc_supp_add," + "gc_contact," + "gc_email," + "gc_other_info" ); values.Append( txtSuppName.Text + "," + txtAddress.Text + "," + txtContact.Text + "," + txtEmail.Text + "," + txtOtherInfo.Text ); db.GCInsertToDb("suppliers", param, values); DataTable dt = db.GCSelectFromDb("suppliers", null, null); dgSuppliers.DataSource = null; dgSuppliers.DataSource = dt; notification = new notification("Supplier saved to the database.", notification.AlertType.success); notification.ShowDialog(); } } }
private void progressTimer_Tick(object sender, EventArgs e) { if (pBar.Value <= 99) { pBar.Value = counter; lblPercent.Text = counter.ToString() + "%"; } else { progressTimer.Stop(); this.Hide(); main = new Inventory_Main(); main.Show(); notification notification = new notification("Welcome Admin!", notification.AlertType.info); notification.ShowDialog(); } counter++; }
private void BtnUpdate_Click(object sender, EventArgs e) { StringBuilder param = new StringBuilder(); StringBuilder values = new StringBuilder(); StringBuilder where = new StringBuilder(); param.Append("username,password,email,contact,other_info,full_name"); values.Append( editPage.txtUsername.Text + "," + editPage.txtPass.Text + "," + editPage.txtEmail.Text + "," + editPage.txtContact.Text + "," + editPage.txtOtherInfo.Text + "," + editPage.txtFullName.Text ); where.Append("username='******' AND password='******'"); if (editPage.txtFullName.Text != "" && editPage.txtUsername.Text != "" && editPage.txtPass.Text != "") { db.GCUpdateDb("users", param, values, where); DataTable dt = db.GCSelectFromDb("users", null, null); dgUsers.DataSource = null; dgUsers.DataSource = dt; editPage.btnUpdate.Click -= BtnUpdate_Click; notification = new notification("Successfully updated fields.", notification.AlertType.success); notification.ShowDialog(); } else { editPage.btnUpdate.Click -= BtnUpdate_Click; notification = new notification("Error updating. Please check fields.", notification.AlertType.error); notification.ShowDialog(); } editPage.Close(); }
private void BtnSave_Click(object sender, EventArgs e) { DataTable dtSave = db.GCSelectFromDb("inventory", null, null, "ORDER BY id DESC"); dgStock.DataSource = null; dgStock.DataSource = dtSave; foreach (DataGridViewRow row in dgStock.Rows) { if (row.Cells[0].Value != null) { if (int.Parse(row.Cells[2].Value.ToString()) <= 5) { row.DefaultCellStyle.BackColor = Color.Maroon; row.DefaultCellStyle.ForeColor = Color.White; } } } inventoryInfoPage.btnSave.Click -= BtnSave_Click; notification = new notification("Product has been updated.", notification.AlertType.success); notification.ShowDialog(); inventoryInfoPage.Close(); }
private void dgSuppliers_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridView senderGrid = (DataGridView)sender; if (e.ColumnIndex == 5) { editSuppPage.txtSuppName.Text = senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString(); editSuppPage.txtAddress.Text = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); editSuppPage.txtContact.Text = senderGrid.Rows[e.RowIndex].Cells[2].Value.ToString(); editSuppPage.txtEmail.Text = senderGrid.Rows[e.RowIndex].Cells[3].Value.ToString(); editSuppPage.txtOtherInfo.Text = senderGrid.Rows[e.RowIndex].Cells[4].Value.ToString(); editSuppPage.suppName = senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString(); editSuppPage.btnUpdate.Click += BtnUpdate_Click; editSuppPage.ShowDialog(); } else if (e.ColumnIndex == 6) { StringBuilder whereDelSupp = new StringBuilder(); StringBuilder valuesDelSupp = new StringBuilder(); DialogResult delRes = MessageBox.Show("Are you sure you want to delete this supplier?", "Delete Supplier?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (delRes == DialogResult.Yes) { whereDelSupp.Append("gc_supp_name"); valuesDelSupp.Append(senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString()); db.GCDeleteFromDb("suppliers", valuesDelSupp, whereDelSupp); notification = new notification("Supplier has been deleted.", notification.AlertType.success); notification.ShowDialog(); DataTable dt = db.GCSelectFromDb("suppliers", null, null); dgSuppliers.DataSource = null; dgSuppliers.DataSource = dt; } } }
private void BtnAddQty_Click(object sender, EventArgs e) { try { StringBuilder paramInv = new StringBuilder(); StringBuilder whereInv = new StringBuilder(); StringBuilder whereSearch = new StringBuilder(); whereSearch.Append("gc_item_code='" + itemCode + "'"); int resItemCode = db.searchData("stock", null, whereSearch); paramInv.Append("gc_item_qty"); whereInv.Append("gc_item_code='" + itemCode + "'"); DataTable dtInv = db.GCSelectFromDb("inventory", paramInv, whereInv); foreach (DataRow rowInv in dtInv.Rows) { currInventory = int.Parse(rowInv[0].ToString()); } if (currInventory >= int.Parse(invQtyPage.txtQty.Text)) { StringBuilder param = new StringBuilder(); StringBuilder where = new StringBuilder(); param.Append("gc_item_qty"); where.Append("gc_item_code='" + itemCode + "'"); DataTable dt = db.GCSelectFromDb("stock", param, where); foreach (DataRow row in dt.Rows) { currStock = int.Parse(row[0].ToString()); } if (resItemCode == 1) { StringBuilder paramUpdate = new StringBuilder(); StringBuilder valuesUpdate = new StringBuilder(); StringBuilder whereUpdate = new StringBuilder(); whereUpdate.Append("gc_item_code='" + itemCode + "'"); paramUpdate.Append("gc_item_qty"); valuesUpdate.Append(currStock + int.Parse(invQtyPage.txtQty.Text)); db.GCUpdateDb("stock", paramUpdate, valuesUpdate, whereUpdate); notification = new notification("Stock has been updated", notification.AlertType.success); notification.ShowDialog(); invQtyPage.btnAddQty.Click -= BtnAddQty_Click; } else { StringBuilder paramInsert = new StringBuilder(); StringBuilder valuesInsert = new StringBuilder(); paramInsert.Append( "gc_item_name," + "gc_item_qty," + "gc_item_desc," + "gc_item_supp," + "gc_item_brand," + "gc_item_um," + "gc_item_cost," + "gc_item_srp," + "gc_date_added," + "gc_item_code," + "gc_item_type" ); valuesInsert.Append( itemName + "," + int.Parse(invQtyPage.txtQty.Text) + "," + itemDesc + "," + itemSupp + "," + itemBrand + "," + itemUm + "," + itemCost + "," + itemSrp + "," + DateTime.Today.ToString("MM/dd/yyyy") + "," + itemCode + "," + itemType ); db.GCInsertToDb("stock", paramInsert, valuesInsert); notification = new notification("Item has been added to stock!", notification.AlertType.success); notification.ShowDialog(); invQtyPage.btnAddQty.Click -= BtnAddQty_Click; } updateTrans("stock", itemCode, "in", int.Parse(invQtyPage.txtQty.Text), currStock, itemName); StringBuilder paramUpdateInv = new StringBuilder(); StringBuilder valuesUpdteInv = new StringBuilder(); StringBuilder whereUpdateInv = new StringBuilder(); whereUpdateInv.Append("gc_item_code='" + itemCode + "'"); paramUpdateInv.Append("gc_item_qty"); valuesUpdteInv.Append(currInventory - int.Parse(invQtyPage.txtQty.Text)); db.GCUpdateDb("inventory", paramUpdateInv, valuesUpdteInv, whereUpdateInv); updateTrans("inventory", itemCode, "out", int.Parse(invQtyPage.txtQty.Text), currInventory, itemName); dgStock.DataSource = null; DataTable dtRefresh = db.GCSelectFromDb("inventory", null, null, "ORDER BY id DESC"); dgStock.DataSource = dtRefresh; invQtyPage.btnAddQty.Click -= BtnAddQty_Click; } else { MessageBox.Show("Not enough item on inventory", "Inventory Dont have enought Item", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation); invQtyPage.btnAddQty.Click -= BtnAddQty_Click; } } catch (Exception a) { MessageBox.Show(a.Message); invQtyPage.btnAddQty.Click -= BtnAddQty_Click; } invQtyPage.btnAddQty.Click -= BtnAddQty_Click; dgStock.Refresh(); invQtyPage.Close(); }
private void BtnAddQty_Click(object sender, EventArgs e) { StringBuilder paramStock = new StringBuilder(); StringBuilder whereStock = new StringBuilder(); StringBuilder valuesStock = new StringBuilder(); StringBuilder paramInv = new StringBuilder(); StringBuilder whereInv = new StringBuilder(); paramInv.Append("gc_item_qty"); whereInv.Append("gc_item_code='" + itemCode + "'"); DataTable dtInv = db.GCSelectFromDb("inventory", paramInv, whereInv); foreach (DataRow row in dtInv.Rows) { currInventory = int.Parse(row[0].ToString()); } foreach (DataGridViewRow row in dgStock.Rows) { if (row.Cells[0].Value != null) { if (int.Parse(row.Cells[2].Value.ToString()) <= 5) { row.DefaultCellStyle.BackColor = Color.Maroon; row.DefaultCellStyle.ForeColor = Color.White; } } } if (currInventory >= int.Parse(stockAddPage.txtQty.Text)) { paramStock.Append("gc_item_qty"); valuesStock.Append(qty + int.Parse(stockAddPage.txtQty.Text)); whereStock.Append("gc_item_code='" + itemCode + "'"); db.GCUpdateDb("stock", paramStock, valuesStock, whereStock); StringBuilder paramUpdateInv = new StringBuilder(); StringBuilder valuesUpdateInv = new StringBuilder(); StringBuilder whereUpdateInv = new StringBuilder(); paramUpdateInv.Append("gc_item_qty"); valuesUpdateInv.Append(currInventory - int.Parse(stockAddPage.txtQty.Text)); whereUpdateInv.Append("gc_item_code='" + itemCode + "'"); db.GCUpdateDb("inventory", paramUpdateInv, valuesUpdateInv, whereUpdateInv); updateTrans("stock", itemCode, "in", int.Parse(stockAddPage.txtQty.Text), qty, itemName); updateTrans("inventory", itemCode, "out", int.Parse(stockAddPage.txtQty.Text), currInventory, itemName); notification = new notification("Stock has been updated.", notification.AlertType.success); notification.ShowDialog(); dgStock.DataSource = null; DataTable dt = db.GCSelectFromDb("stock", null, null, "ORDER BY id DESC"); dgStock.DataSource = dt; stockAddPage.Close(); } else { notification = new notification("Not enough item on inventory.", notification.AlertType.error); notification.ShowDialog(); } }
private void dgTransHistory_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridView senderGrid = (DataGridView)sender; if (e.ColumnIndex == 7) { StringBuilder where = new StringBuilder(); StringBuilder param = new StringBuilder(); param.Append( "gc_item_name," + "gc_item_code," + "gc_item_qty," + "gc_item_srp," + "gc_item_cost," + "gc_um," + "gc_item_desc," + "gc_curr_qty," + "gc_cust_cash," + "gc_cust_change," + "gc_customer_name," + "gc_customer_add," + "gc_unique_id" ); where.Append( "gc_unique_id='" + senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString() + "' " + "AND gc_customer_name='" + senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString() + "'" ); DataTable dt = db.GCSelectFromDb("transact", param, where); transPage.lvCart.Items.Clear(); foreach (DataRow row in dt.Rows) { items[0] = row[0].ToString(); items[1] = row[1].ToString(); items[2] = row[2].ToString(); items[3] = row[3].ToString(); items[4] = row[4].ToString(); items[5] = row[5].ToString(); items[6] = row[6].ToString(); items[7] = row[7].ToString(); transPage.txtCustomerName.Text = row[10].ToString(); transPage.txtAddress.Text = row[11].ToString(); transPage.txtCash.Text = row[8].ToString(); transID = row[12].ToString(); ListViewItem lvi = new ListViewItem(items); transPage.lvCart.Items.Add(lvi); } //transPage.lblTotal.Text = row[12].ToString(); transPage.btnSaveTrans.Text = "Update Transaction"; transPage.SaveMode = false; totalPrice = 0; foreach (ListViewItem lviTotal in transPage.lvCart.Items) { totalPrice += float.Parse(lviTotal.SubItems[3].Text) * float.Parse(lviTotal.SubItems[2].Text); } transPage.lblTotal.Text = totalPrice.ToString(); transPage.btnSaveTrans.Click += BtnSaveTrans_Click; transPage.ShowDialog(); } else if (e.ColumnIndex == 8) { receiptPage.transID = senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString(); receiptPage.ShowDialog(); } else if (e.ColumnIndex == 9) { DialogResult delTransHist = MessageBox.Show("Are you sure you want to delete this purchase history?", "Delete purchased History?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (delTransHist == DialogResult.Yes) { StringBuilder whereDelHist = new StringBuilder(); StringBuilder valuesDelHist = new StringBuilder(); StringBuilder whereHist = new StringBuilder(); StringBuilder paramHist = new StringBuilder(); paramHist.Append("DISTINCT gc_unique_id,gc_customer_name,gc_customer_add,gc_trans_date,gc_cust_cash,gc_cust_change"); whereHist.Append("gc_from_tbl='sales'"); whereDelHist.Append("gc_unique_id,gc_customer_name"); valuesDelHist.Append( senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString() + "," + senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString() ); db.GCDeleteFromDb("transact", valuesDelHist, whereDelHist); dgTransHistory.DataSource = null; DataTable dtDelHist = db.GCSelectFromDb("transact", paramHist, whereHist); dgTransHistory.DataSource = dtDelHist; notification = new notification("Purchased history deleted", notification.AlertType.error); notification.ShowDialog(); } } }
private void BtnSaveTrans_Click(object sender, EventArgs e) { if (float.Parse(transPage.lblTotal.Text) > float.Parse(transPage.txtCash.Text)) { notification = new notification("Cash is not enough to make transaction.", notification.AlertType.error); notification.ShowDialog(); return; } StringBuilder whereTransUpdate = new StringBuilder(); StringBuilder paramTransUpdate = new StringBuilder(); StringBuilder valuesTransUpdate = new StringBuilder(); foreach (ListViewItem lvi in transPage.lvCart.Items) { StringBuilder whereRes = new StringBuilder(); StringBuilder whereDel = new StringBuilder(); whereRes.Append("gc_item_code='" + lvi.SubItems[1].Text + "' AND gc_unique_id='" + transID + "'"); int result = db.searchData("transact", null, whereRes); if (result == 0) { StringBuilder values = new StringBuilder(); StringBuilder paramUpdate = new StringBuilder(); StringBuilder valuesUpdate = new StringBuilder(); StringBuilder whereUpdate = new StringBuilder(); values.Append( "Sales," + "out," + lvi.SubItems[2].Text + "," + itemQty + "," + DateTime.Now.ToString("MM/dd/yyyy") + "," + transID + "," + lvi.SubItems[1].Text + "," + transPage.txtCustomerName.Text + "," + transPage.txtAddress.Text + "," + lvi.SubItems[5].Text + "," + lvi.SubItems[6].Text + "," + lvi.Text + "," + float.Parse(lvi.SubItems[3].Text) * float.Parse(lvi.SubItems[2].Text) + "," + float.Parse(lvi.SubItems[4].Text) + "," + float.Parse(lvi.SubItems[3].Text) + "," + float.Parse(transPage.txtCash.Text) + "," + (float.Parse(transPage.txtCash.Text) - totalPrice) + "," + float.Parse(lvi.SubItems[4].Text) * float.Parse(lvi.SubItems[2].Text) ); paramUpdate.Append("gc_item_qty"); valuesUpdate.Append(int.Parse(lvi.SubItems[7].Text) - int.Parse(lvi.SubItems[2].Text)); whereUpdate.Append("gc_item_code='" + lvi.SubItems[1].Text + "'"); db.GCUpdateDb("stock", paramUpdate, valuesUpdate, whereUpdate); transaction.insertToTrans(values); } whereDel.Append("gc_unique_id='" + transID + "'"); DataTable dt = db.GCSelectFromDb("transact", null, whereDel); foreach (DataRow row in dt.Rows) { var resItem = transPage.lvCart.FindItemWithText(row[7].ToString(), true, 0); if (resItem == null) { StringBuilder whereDelItem = new StringBuilder(); StringBuilder valueDelItem = new StringBuilder(); StringBuilder paramStockUpdate = new StringBuilder(); StringBuilder valuesStockUpdate = new StringBuilder(); StringBuilder whereStockUpdate = new StringBuilder(); StringBuilder paramStock = new StringBuilder(); StringBuilder whereStock = new StringBuilder(); paramStock.Append("gc_item_qty"); whereStock.Append("gc_item_code='" + row[7].ToString() + "'"); DataTable dtQty = db.GCSelectFromDb("stock", paramStock, whereStock); foreach (DataRow dtQtyRow in dtQty.Rows) { currStockQty = int.Parse(dtQtyRow[0].ToString()); } whereDelItem.Append("gc_item_code,gc_unique_id"); valueDelItem.Append(row[7].ToString() + "," + row[6].ToString()); db.GCDeleteFromDb("transact", valueDelItem, whereDelItem); paramStockUpdate.Append("gc_item_qty"); whereStockUpdate.Append("gc_item_code='" + row[7].ToString() + "'"); valuesStockUpdate.Append(currStockQty + int.Parse(row[3].ToString())); db.GCUpdateDb("stock", paramStockUpdate, valuesStockUpdate, whereStockUpdate); DataTable dtStock = db.GCSelectFromDb("stock", null, null); transPage.dgStock.DataSource = null; transPage.dgStock.DataSource = dtStock; } else if (resItem != null) { StringBuilder wheretSelStock = new StringBuilder(); StringBuilder paramSelStock = new StringBuilder(); paramSelStock.Append("gc_item_qty"); wheretSelStock.Append("gc_item_code='" + lvi.SubItems[1].Text + "' AND gc_unique_id='" + transID + "'"); DataTable dtSelectStock = db.GCSelectFromDb("transact", paramSelStock, wheretSelStock); foreach (DataRow rowQty in dtSelectStock.Rows) { StringBuilder paramUpdateStock = new StringBuilder(); StringBuilder whereUpdateStock = new StringBuilder(); StringBuilder valuesUpdateStock = new StringBuilder(); StringBuilder whereSelItem = new StringBuilder(); StringBuilder paramSelItem = new StringBuilder(); paramSelItem.Append("gc_item_qty"); whereSelItem.Append("gc_item_code='" + lvi.SubItems[1].Text + "'"); DataTable dtSelItem = db.GCSelectFromDb("stock", paramSelItem, whereSelItem); foreach (DataRow rowSelItem in dtSelItem.Rows) { currStock = int.Parse(rowSelItem[0].ToString()); } paramUpdateStock.Append("gc_item_qty"); whereUpdateStock.Append("gc_item_code='" + lvi.SubItems[1].Text + "'"); if (int.Parse(rowQty[0].ToString()) < int.Parse(lvi.SubItems[2].Text)) { addedQty = int.Parse(lvi.SubItems[2].Text) - int.Parse(rowQty[0].ToString()); valuesUpdateStock.Append(currStock - addedQty); db.GCUpdateDb("stock", paramUpdateStock, valuesUpdateStock, whereUpdateStock); } else if (int.Parse(rowQty[0].ToString()) > int.Parse(lvi.SubItems[2].Text)) { addedQty = int.Parse(rowQty[0].ToString()) - int.Parse(lvi.SubItems[2].Text); valuesUpdateStock.Append(currStock + addedQty); db.GCUpdateDb("stock", paramUpdateStock, valuesUpdateStock, whereUpdateStock); } } whereTransUpdate.Append( "gc_from_tbl='sales' " + "AND gc_unique_id='" + transID + "' " + "AND gc_item_code='" + lvi.SubItems[1].Text + "'" ); paramTransUpdate.Append( "gc_item_qty," + "gc_total_price," + "gc_item_cost," + "gc_cust_cash," + "gc_cust_change," + "gc_trans_date," + "gc_cost_total" ); valuesTransUpdate.Append( lvi.SubItems[2].Text + "," + (float.Parse(lvi.SubItems[3].Text) * float.Parse(lvi.SubItems[2].Text)) + "," + float.Parse(lvi.SubItems[4].Text) + "," + float.Parse(transPage.txtCash.Text) + "," + (float.Parse(transPage.txtCash.Text) - float.Parse(transPage.lblTotal.Text)) + "," + DateTime.Now.ToString("MM/dd/yyyy") + "," + float.Parse(lvi.SubItems[2].Text) * float.Parse(lvi.SubItems[4].Text) ); try { transaction.GCUpdateDb("transact", paramTransUpdate, valuesTransUpdate, whereTransUpdate); DataTable dtStock = db.GCSelectFromDb("stock", null, null); transPage.dgStock.DataSource = null; transPage.dgStock.DataSource = dtStock; notification = new notification("Transaction has been updated.", notification.AlertType.success); notification.Show(); } catch (Exception a) { notification = new notification("Transaction error. Please check fields.", notification.AlertType.error); MessageBox.Show(a.Message); notification.Show(); } } } } transPage.dgStock.DataSource = null; DataTable dtTransHist = db.GCSelectFromDb("stock", null, null); transPage.dgStock.DataSource = dtTransHist; transPage.btnSaveTrans.Click -= BtnSaveTrans_Click; }
private void btnSaveTrans_Click(object sender, EventArgs e) { if (SaveMode == true) { if (txtCustomerName.Text == "" && txtAddress.Text == "") { notification = new notification("Error saving. Check fields before saving.", notification.AlertType.error); notification.Show(); return; } string randID = view.Random("ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789", 5); foreach (ListViewItem lvi in lvCart.Items) { StringBuilder values = new StringBuilder(); StringBuilder paramUpdate = new StringBuilder(); StringBuilder valuesUpdate = new StringBuilder(); StringBuilder whereUpdate = new StringBuilder(); values.Append( "Sales," + "out," + lvi.SubItems[2].Text + "," + itemQty + "," + DateTime.Today + "," + randID + "," + lvi.SubItems[1].Text + "," + txtCustomerName.Text + "," + txtAddress.Text + "," + lvi.SubItems[5].Text + "," + lvi.SubItems[6].Text + "," + lvi.Text + "," + float.Parse(lvi.SubItems[3].Text) * float.Parse(lvi.SubItems[2].Text) + "," + float.Parse(lvi.SubItems[4].Text) + "," + float.Parse(lvi.SubItems[3].Text) + "," + float.Parse(txtCash.Text) + "," + (float.Parse(txtCash.Text) - totalPrice) + "," + float.Parse(lvi.SubItems[4].Text) * float.Parse(lvi.SubItems[2].Text) ); paramUpdate.Append("gc_item_qty"); valuesUpdate.Append(int.Parse(lvi.SubItems[7].Text) - int.Parse(lvi.SubItems[2].Text)); whereUpdate.Append("gc_item_code='" + lvi.SubItems[1].Text + "'"); db.GCUpdateDb("stock", paramUpdate, valuesUpdate, whereUpdate); transaction.insertToTrans(values); } dgStock.DataSource = null; DataTable dt = db.GCSelectFromDb("stock", null, null); dgStock.DataSource = dt; foreach (Control ctrl in panel1.Controls) { if (ctrl.GetType() == typeof(TextBox)) { ctrl.Text = ""; } } lvCart.Items.Clear(); DialogResult drPrint = MessageBox.Show("Do you want to print this transaction?", "Print this transaction?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (drPrint == DialogResult.Yes) { receiptPage.transID = randID; receiptPage.ShowDialog(); } else { notification = new notification("Transaction has been saved.", notification.AlertType.success); notification.Show(); } } }
private void BtnAddQty_Click(object sender, EventArgs e) { if (salesQtyPage.txtQty.Text != "") { if (itemQty >= int.Parse(salesQtyPage.txtQty.Text)) { string[] items = { itemName, itemCode, salesQtyPage.txtQty.Text, itemPrice.ToString(), itemCost.ToString(), itemUm, itemDesc, itemQty.ToString() }; ListViewItem strValues = new ListViewItem(items); if (lvCart.Items.Count > 0) { var resItem = lvCart.FindItemWithText(itemCode, true, 0, false); if (resItem != null && resItem.SubItems[1].Text == itemCode) { int resTotal = int.Parse(resItem.SubItems[2].Text) + int.Parse(salesQtyPage.txtQty.Text); resItem.SubItems[2].Text = resTotal.ToString(); } else { lvCart.Items.Add(strValues); } } else { lvCart.Items.Add(strValues); } totalPrice = 0; foreach (ListViewItem lvi in lvCart.Items) { totalPrice += float.Parse(lvi.SubItems[2].Text) * float.Parse(lvi.SubItems[3].Text); } lblTotal.Text = totalPrice.ToString(); salesQtyPage.btnAddQty.Click -= BtnAddQty_Click; salesQtyPage.Close(); } else { MessageBox.Show("Invalid Quantity, not enough item on stock.", "Not enough item on stock", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation); salesQtyPage.btnAddQty.Click -= BtnAddQty_Click; return; } } else { notification notification = new notification("Cannot insert blank value!", notification.AlertType.error); notification.Show(); salesQtyPage.btnAddQty.Click -= BtnAddQty_Click; } }
private void btnSave_Click(object sender, EventArgs e) { StringBuilder whereItemCode = new StringBuilder(); StringBuilder whereUpdate = new StringBuilder(); StringBuilder paramUpdate = new StringBuilder(); StringBuilder valuesUpdate = new StringBuilder(); StringBuilder whereInvUpdate = new StringBuilder(); StringBuilder paramInvUpdate = new StringBuilder(); StringBuilder valuesInvUpdate = new StringBuilder(); StringBuilder whereStockUpdate = new StringBuilder(); StringBuilder paramStockUpdate = new StringBuilder(); StringBuilder valuesStockUpdate = new StringBuilder(); if (itemCode != "" && itemCode != txtItemCode.Text) { whereItemCode.Append("gc_item_code='" + txtItemCode.Text + "'"); int resItemCode = db.searchData("products", null, whereItemCode); if (resItemCode == 1) { notification = new notification("Item Code already Existing", notification.AlertType.error); notification.ShowDialog(); } else { paramInvUpdate.Append( "gc_item_name," + "gc_item_code," + "gc_item_um," + "gc_item_desc," + "gc_item_supp," + "gc_item_brand," + "gc_item_cost," + "gc_item_srp," + "gc_item_type" ); valuesInvUpdate.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtUm.Text + "," + txtDesc.Text + "," + cmbSupp.Text + "," + txtBrand.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + cmbItemType.Text ); paramStockUpdate.Append( "gc_item_name," + "gc_item_code," + "gc_item_um," + "gc_item_desc," + "gc_item_supp," + "gc_item_brand," + "gc_item_cost," + "gc_item_srp," + "gc_item_type" ); valuesStockUpdate.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtUm.Text + "," + txtDesc.Text + "," + cmbSupp.Text + "," + txtBrand.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + cmbItemType.Text ); paramUpdate.Append( "gc_item_name," + "gc_item_code," + "gc_item_um," + "gc_item_desc," + "gc_item_supp," + "gc_item_brand," + "gc_item_cost," + "gc_item_srp," + "gc_item_type," + "gc_item_status" ); valuesUpdate.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtUm.Text + "," + txtDesc.Text + "," + cmbSupp.Text + "," + txtBrand.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + cmbItemType.Text + "," + "in-active" ); whereInvUpdate.Append("gc_item_code='" + itemCode + "'"); whereStockUpdate.Append("gc_item_code='" + itemCode + "'"); whereUpdate.Append("gc_item_code='" + itemCode + "'"); db.GCUpdateDb("stock", paramStockUpdate, valuesStockUpdate, whereStockUpdate); db.GCUpdateDb("inventory", paramInvUpdate, valuesInvUpdate, whereInvUpdate); db.GCUpdateDb("products", paramUpdate, valuesUpdate, whereUpdate); notification = new notification("Product information updated.", notification.AlertType.success); notification.ShowDialog(); } } else if (itemCode != "" && txtItemName.Text != "") { paramInvUpdate.Append( "gc_item_name," + "gc_item_code," + "gc_item_um," + "gc_item_desc," + "gc_item_supp," + "gc_item_brand," + "gc_item_cost," + "gc_item_srp," + "gc_item_type" ); valuesInvUpdate.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtUm.Text + "," + txtDesc.Text + "," + cmbSupp.Text + "," + txtBrand.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + cmbItemType.Text ); paramStockUpdate.Append( "gc_item_name," + "gc_item_code," + "gc_item_um," + "gc_item_desc," + "gc_item_supp," + "gc_item_brand," + "gc_item_cost," + "gc_item_srp," + "gc_item_type" ); valuesStockUpdate.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtUm.Text + "," + txtDesc.Text + "," + cmbSupp.Text + "," + txtBrand.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + cmbItemType.Text ); paramUpdate.Append( "gc_item_name," + "gc_item_code," + "gc_item_um," + "gc_item_desc," + "gc_item_supp," + "gc_item_brand," + "gc_item_cost," + "gc_item_srp," + "gc_item_type," + "gc_item_status" ); valuesUpdate.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtUm.Text + "," + txtDesc.Text + "," + cmbSupp.Text + "," + txtBrand.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + cmbItemType.Text + "," + "in-active" ); whereInvUpdate.Append("gc_item_code='" + itemCode + "'"); whereStockUpdate.Append("gc_item_code='" + itemCode + "'"); whereUpdate.Append("gc_item_code='" + itemCode + "'"); db.GCUpdateDb("stock", paramStockUpdate, valuesStockUpdate, whereStockUpdate); db.GCUpdateDb("inventory", paramInvUpdate, valuesInvUpdate, whereInvUpdate); db.GCUpdateDb("products", paramUpdate, valuesUpdate, whereUpdate); notification = new notification("Product information updated.", notification.AlertType.success); notification.ShowDialog(); } else { notification = new notification("Error. Please check fields before saving.", notification.AlertType.error); notification.ShowDialog(); } }
private void dgStock_CellContentClick(object sender, DataGridViewCellEventArgs e) { var senderGrid = (DataGridView)sender; if (e.ColumnIndex == 12) { try { itemName = senderGrid.Rows[e.RowIndex].Cells[0].Value.ToString(); itemCode = senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString(); qty = int.Parse(senderGrid.Rows[e.RowIndex].Cells[2].Value.ToString()); itemDesc = senderGrid.Rows[e.RowIndex].Cells[3].Value.ToString(); itemSupp = senderGrid.Rows[e.RowIndex].Cells[4].Value.ToString(); itemBrand = senderGrid.Rows[e.RowIndex].Cells[5].Value.ToString(); itemUm = senderGrid.Rows[e.RowIndex].Cells[6].Value.ToString(); itemCost = float.Parse(senderGrid.Rows[e.RowIndex].Cells[7].Value.ToString()); itemSrp = float.Parse(senderGrid.Rows[e.RowIndex].Cells[8].Value.ToString()); itemType = senderGrid.Rows[e.RowIndex].Cells[10].Value.ToString(); stockAddPage.btnAddQty.Click += BtnAddQty_Click; stockAddPage.ShowDialog(); } catch (Exception a) { MessageBox.Show(a.Message); } } else if (e.ColumnIndex == 11) { StringBuilder whereDel = new StringBuilder(); StringBuilder valuesDel = new StringBuilder(); StringBuilder paramInvUpdate = new StringBuilder(); StringBuilder valuesInvUpdate = new StringBuilder(); StringBuilder whereInvUpdate = new StringBuilder(); StringBuilder paramInvAdd = new StringBuilder(); StringBuilder whereInvAdd = new StringBuilder(); DialogResult delRes = MessageBox.Show("Are you sure you want to delete this stock?", "Delete Supplier?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (delRes == DialogResult.Yes) { paramInvAdd.Append("gc_item_qty"); whereInvAdd.Append("gc_item_code='" + senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString() + "'"); DataTable dtInv = db.GCSelectFromDb("inventory", paramInvAdd, whereInvAdd); foreach (DataRow row in dtInv.Rows) { currInventory = int.Parse(row[0].ToString()); } whereDel.Append("gc_item_code"); valuesDel.Append(senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString()); db.GCDeleteFromDb("stock", valuesDel, whereDel); paramInvUpdate.Append("gc_item_qty"); valuesInvUpdate.Append(currInventory + int.Parse(senderGrid.Rows[e.RowIndex].Cells[2].Value.ToString())); whereInvUpdate.Append("gc_item_code='" + senderGrid.Rows[e.RowIndex].Cells[1].Value.ToString() + "'"); db.GCUpdateDb("inventory", paramInvUpdate, valuesInvUpdate, whereInvUpdate); notification = new notification("Stock has been deleted.", notification.AlertType.success); notification.ShowDialog(); dgStock.DataSource = null; DataTable dtRemove = db.GCSelectFromDb("stock", null, null, "ORDER BY id DESC"); dgStock.DataSource = dtRemove; } } }
private void btnSave_Click(object sender, EventArgs e) { StringBuilder whereSearch = new StringBuilder(); StringBuilder whereSearchInv = new StringBuilder(); StringBuilder whereSearchStock = new StringBuilder(); main = new Inventory_Main(); whereSearch.Append("gc_item_code='" + txtItemCode.Text + "'"); whereSearchInv.Append("gc_item_code='" + txtItemCode.Text + "'"); whereSearchStock.Append("gc_item_code='" + txtItemCode.Text + "'"); int resInv = db.searchData("inventory", null, whereSearchInv); int resStock = db.searchData("stock", null, whereSearchStock); int resProd = db.searchData("products", null, whereSearch); if (resProd >= 1 || resInv >= 1 || resStock >= 1) { notification = new notification("Item Code is already existing.", notification.AlertType.error); notification.ShowDialog(); } else if (txtItemName.Text != "" && txtItemCode.Text != "") { try { StringBuilder param = new StringBuilder(); StringBuilder paramInv = new StringBuilder(); StringBuilder values = new StringBuilder(); StringBuilder valuesInv = new StringBuilder(); StringBuilder whereInvSearch = new StringBuilder(); StringBuilder paramStock = new StringBuilder(); StringBuilder valuesStock = new StringBuilder(); param.Append( "gc_item_name," + "gc_item_code," + "gc_item_brand," + "gc_item_type," + "gc_item_supp," + "gc_item_um," + "gc_item_cost," + "gc_item_srp," + "gc_item_desc," + "gc_item_status" ); values.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtBrand.Text + "," + cmbItemType.Text + "," + cmbSupp.Text + "," + txtUm.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + txtDesc.Text + "," + cmbStatus.Text ); paramInv.Append( "gc_item_name," + "gc_item_code," + "gc_item_brand," + "gc_item_type," + "gc_item_supp," + "gc_item_um," + "gc_item_cost," + "gc_item_srp," + "gc_item_desc," + "gc_item_status," + "gc_item_qty" ); valuesInv.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtBrand.Text + "," + cmbItemType.Text + "," + cmbSupp.Text + "," + txtUm.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + txtDesc.Text + "," + "registered," + int.Parse(txtInvQty.Text) ); whereInvSearch.Append("gc_item_code='" + txtItemCode.Text + "'"); int invSearch = db.searchData("inventory", null, whereInvSearch); if (invSearch <= 0) { db.GCInsertToDb("inventory", paramInv, valuesInv); } paramStock.Append( "gc_item_name," + "gc_item_code," + "gc_item_brand," + "gc_item_type," + "gc_item_supp," + "gc_item_um," + "gc_item_cost," + "gc_item_srp," + "gc_item_desc," + "gc_item_status," + "gc_item_qty" ); valuesStock.Append( txtItemName.Text + "," + txtItemCode.Text + "," + txtBrand.Text + "," + cmbItemType.Text + "," + cmbSupp.Text + "," + txtUm.Text + "," + float.Parse(txtCost.Text) + "," + float.Parse(txtSrp.Text) + "," + txtDesc.Text + "," + "registered," + int.Parse(txtStockQty.Text) ); db.GCInsertToDb("stock", paramStock, valuesStock); db.GCInsertToDb("products", param, values); DataTable dt = db.GCSelectFromDb("products", null, null, "ORDER BY id DESC"); dgProducts.DataSource = null; dgProducts.DataSource = dt; notification = new notification("Product saved to the database", notification.AlertType.success); notification.ShowDialog(); } catch (Exception a) { notification = new notification("Please check the values on the fields. : ", notification.AlertType.error); notification.ShowDialog(); } } else { notification = new notification("Please check the values on the fields.", notification.AlertType.error); notification.ShowDialog(); } }