public override void search_textBox_TextChanged(object sender, EventArgs e) { if (search_textBox.Text != "") { ListBox lb = new ListBox(); lb.Items.Add(supplierIDGV); lb.Items.Add(suppliernameGV); lb.Items.Add(contactpersonnameGV); lb.Items.Add(phone1GV); lb.Items.Add(phone2GV); lb.Items.Add(addressGV); lb.Items.Add(ntnGV); lb.Items.Add(statusGV); Hashtable ht = new Hashtable(); ht.Add("@data", search_textBox.Text); SQL_TASKS.load_data("st_searchSUPPLIERS", suppliers_dataGridView, lb, ht); } else { loadSuppliers(); } }
public override void search_textBox_TextChanged(object sender, EventArgs e) { if (search_textBox.Text != "") { ListBox lb = new ListBox(); lb.Items.Add(productidGV); lb.Items.Add(productnameGV); lb.Items.Add(productbarcodeGV); lb.Items.Add(expirydateGV); lb.Items.Add(categoryIDGV); lb.Items.Add(productcategoryGV); Hashtable ht = new Hashtable(); ht.Add("@data", search_textBox.Text); SQL_TASKS.load_data("st_searchPRODUCTS", products_dataGridView, lb, ht); } else { LoadProducts(); } }
private void STOCK_Load(object sender, EventArgs e) { ListBox lb = new ListBox(); lb.Items.Add(productidGV); lb.Items.Add(productnameGV); lb.Items.Add(productbarcodeGV); lb.Items.Add(productbuyingpriceGV); lb.Items.Add(BuyingDateGV); lb.Items.Add(expirydateGV); lb.Items.Add(productcategoryGV); lb.Items.Add(availablestockGV); lb.Items.Add(statusGV); SQL_TASKS.load_data("st_getSTOCK", stocks_dataGridView, lb); //foreach(DataGridViewRow row in stocks_dataGridView.Rows) //{ // if(Convert.ToInt32(row.Cells["availablestockGV"].Value) == 0) // { // stocks_dataGridView.Columns["availablestockGV"].DefaultCellStyle.BackColor = Color.Red; // //row.Cells["availablestockGV"].Style.BackColor = Color.Red; // //row.DefaultCellStyle.BackColor = Color.Red; // } //} }
public void LoadStocks() { ListBox lb = new ListBox(); lb.Items.Add(productidGV); lb.Items.Add(productnameGV); lb.Items.Add(productbarcodeGV); //lb.Items.Add(PerUnitPriceGV); lb.Items.Add(productbuyingpriceGV); lb.Items.Add(BuyingDateGV); lb.Items.Add(expirydateGV); lb.Items.Add(productcategoryGV); lb.Items.Add(availablestockGV); lb.Items.Add(statusGV); SQL_TASKS.load_data("st_getSTOCK", stocks_dataGridView, lb); }
public void LoadCategory() { ListBox lb = new ListBox(); lb.Items.Add(categoryidGV); lb.Items.Add(categorynameGV); lb.Items.Add(categorystatusGV); SQL_TASKS.load_data("st_getcategoriesdata", categories_dataGridView, lb); }
void LoadProducts() { ListBox lb = new ListBox(); lb.Items.Add(productidGV); lb.Items.Add(productnameGV); lb.Items.Add(productbarcodeGV); lb.Items.Add(expirydateGV); lb.Items.Add(categoryIDGV); lb.Items.Add(productcategoryGV); SQL_TASKS.load_data("st_getPRODUCTS", products_dataGridView, lb); }
private void textBox1_TextChanged(object sender, EventArgs e) { if (search_stock_textBox.Text != "") { ListBox lb = new ListBox(); lb.Items.Add(productnameGV); Hashtable ht = new Hashtable(); ht.Add("@data", search_stock_textBox.Text); SQL_TASKS.load_data("st_searchSTOCKS", stocks_dataGridView, lb, ht); } else { LoadStocks(); } }
public void loadUsers() { ListBox lb = new ListBox(); lb.Items.Add(useridGV); lb.Items.Add(nameGV); lb.Items.Add(emailGV); lb.Items.Add(passwordGV); lb.Items.Add(phonenumberGV); lb.Items.Add(statusGV); lb.Items.Add(roleGV); SQL_TASKS.load_data("st_getusersdata", users_dataGridView, lb); }
private void search_textBox_TextChanged_1(object sender, EventArgs e) { if (search_textBox.Text != "") { ListBox lb = new ListBox(); lb.Items.Add(useridGV); lb.Items.Add(nameGV); lb.Items.Add(emailGV); lb.Items.Add(passwordGV); lb.Items.Add(phonenumberGV); lb.Items.Add(statusGV); lb.Items.Add(roleGV); Hashtable ht = new Hashtable(); ht.Add("@data", search_textBox.Text); SQL_TASKS.load_data("st_searchUSERS", users_dataGridView, lb, ht); if (users_dataGridView.Rows.Count == 0) { not_found_label.Visible = true; } else { not_found_label.Visible = false; } } else { loadUsers(); } }
void LoadSales() { var ht = new Hashtable(); ht.Add("@saleID", Convert.ToInt64(sale_ID_textBox.Text)); var lb = new ListBox(); lb.Items.Add(saleIDGV); lb.Items.Add(BarcodeGV); lb.Items.Add(ProductGV); lb.Items.Add(QuantityGV); lb.Items.Add(TotalDiscountGV); lb.Items.Add(TotalAmountGV); lb.Items.Add(AmountGivenGV); lb.Items.Add(AmountReturnedGV); lb.Items.Add(DateGV); lb.Items.Add(ProductPriceGV); lb.Items.Add(PerProductDiscountGV); lb.Items.Add(PerProductTotalGV); lb.Items.Add(UserIDGV); lb.Items.Add(PaymentGV); lb.Items.Add(ProductIDGV); SQL_TASKS.load_data("st_getSalesReceiptwrtSalesID", sales_return_dataGridView, lb, ht); }
private void LoadPurchaseInvoiceDetails() { Hashtable ht = new Hashtable(); ht.Add("@purchaseinvoiceID", Convert.ToInt64(purchaseinvoice_comboBox.SelectedValue)); ListBox lb = new ListBox(); lb.Items.Add(purchaseinvoiceIDGV); lb.Items.Add(productIDGV); lb.Items.Add(productnameGV); lb.Items.Add(productquantityGV); lb.Items.Add(perunitpriceGV); lb.Items.Add(totalGV); SQL_TASKS.load_data("st_getPURCHASEINVOICEDETAILS", purchaseinvoice_dataGridView, lb, ht); }
public void loadSuppliers() { ListBox lb = new ListBox(); lb.Items.Add(supplierIDGV); lb.Items.Add(suppliernameGV); lb.Items.Add(contactpersonnameGV); lb.Items.Add(phone1GV); lb.Items.Add(phone2GV); lb.Items.Add(addressGV); lb.Items.Add(ntnGV); lb.Items.Add(statusGV); SQL_TASKS.load_data("st_getSUPPLIERS", suppliers_dataGridView, lb); }
void LoadProducts() { Hashtable ht = new Hashtable(); ht.Add("@categID", Convert.ToInt32(category_comboBox_product_pricing.SelectedValue)); ListBox lb = new ListBox(); lb.Items.Add(productIDGV); lb.Items.Add(productnameGV); lb.Items.Add(buyingpriceGV); lb.Items.Add(PerUnitPriceGV); lb.Items.Add(QuantityGV); lb.Items.Add(BarcodeGV); SQL_TASKS.load_data("getPRODUCTSwrtCATEGORIES", product_pricing_dataGridView, lb, ht); }
public override void search_textBox_TextChanged(object sender, EventArgs e) { if (search_textBox.Text != "") { ListBox lb = new ListBox(); lb.Items.Add(categoryidGV); lb.Items.Add(categorynameGV); lb.Items.Add(categorystatusGV); Hashtable ht = new Hashtable(); ht.Add("@data", search_textBox.Text); SQL_TASKS.load_data("st_searchCATEGORIES", categories_dataGridView, lb, ht); } else { LoadCategory(); } }
void LoadSalesDetails() { var ht = new Hashtable(); ht.Add("@date", dateTimePicker_sales.Value); var lb = new ListBox(); lb.Items.Add(saleIDGV); lb.Items.Add(TotalAmountGV); lb.Items.Add(AmountGivenGV); lb.Items.Add(AmountReturnedGV); lb.Items.Add(UserGV); lb.Items.Add(TotalDiscountGV); lb.Items.Add(UserIDGV); SQL_TASKS.load_data("st_GetDailySales", sales_details_dataGridView, lb, ht); }