private void metroLink2_Click(object sender, EventArgs e) { try { int pid = 0; M_Product_BS IndexObj = new M_Product_BS(); foreach (DataGridViewRow item in this.tblProduct.SelectedRows) { pid = Convert.ToInt32(item.Cells[0].Value.ToString()); } bool result = cObjList.Any(); if (result) { if (tblProduct.RowCount > 0) { foreach (M_Product_BS item in cObjList) { if (item.ID == pid) { IndexObj = item; } } if (IndexObj.Delete(con)) { MetroMessageBox.Show(this, "Product data Successfully deleted", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Information); loadGrid(); } else { MetroMessageBox.Show(this, "Product was not deleted", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } txtEPid.Enabled = false; txtEPname.Enabled = false; txtEPrice.Enabled = false; txtECost.Enabled = false; cmbECategory.Enabled = false; //txtEBoundlePrice.Enabled = false; lnkSearch.Enabled = false; numericUpDown1.Enabled = false; //txtPackagecost.Enabled = false; } else { MetroMessageBox.Show(this, "Table data is empty ", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MetroMessageBox.Show(this, "Table list is empty ", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void InitialloadGrid() { try { List <GetProductStock> GridList = new List <GetProductStock>(); BusinessObjects.GetProductStock spObj = new GetProductStock(); GridList = spObj.getProdAlongWithStockQuantity_All(con); List <M_Product_BS> cObjList = new List <M_Product_BS>(); BusinessObjects.M_Product_BS cObj = new M_Product_BS(); cObjList = cObj.GetProducts(con); //MessageBox.Show(cObjList.Count.ToString()); //this is to set the category name List <Category_BS> catList = new List <Category_BS>(); Category_BS catObj = new Category_BS(); catList = catObj.GetCategory(con); foreach (Category_BS itemCat in catList) { foreach (GetProductStock itemProd in GridList) { if (itemProd.category == itemCat.ID) { itemProd.catObj = itemCat; } } } int i = 0; tblProduct.Rows.Clear(); foreach (GetProductStock item in GridList) { if (item.TotalQuantity > 3) { continue; } tblProduct.Rows.Add(); tblProduct.Rows[i].Cells[0].Value = item.ID; tblProduct.Rows[i].Cells[1].Value = item.name; tblProduct.Rows[i].Cells[2].Value = item.catObj.name; tblProduct.Rows[i].Cells[3].Value = item.cost; tblProduct.Rows[i].Cells[4].Value = item.unitPrice; tblProduct.Rows[i].Cells[5].Value = item.warranty; tblProduct.Rows[i].Cells[6].Value = item.TotalQuantity; i++; } } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void autoComplete() { try { txtInvoiceSearch.AutoCompleteMode = AutoCompleteMode.Suggest; txtInvoiceSearch.AutoCompleteSource = AutoCompleteSource.CustomSource; txtSNameSearch.AutoCompleteMode = AutoCompleteMode.Suggest; txtSNameSearch.AutoCompleteSource = AutoCompleteSource.CustomSource; txtPNameSearch.AutoCompleteMode = AutoCompleteMode.Suggest; txtPNameSearch.AutoCompleteSource = AutoCompleteSource.CustomSource; txtSupName.AutoCompleteMode = AutoCompleteMode.Suggest; txtSupName.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection stringColl = new AutoCompleteStringCollection(); AutoCompleteStringCollection stringColl2 = new AutoCompleteStringCollection(); AutoCompleteStringCollection stringColl3 = new AutoCompleteStringCollection(); M_Product_BS product = new M_Product_BS(); ProductList = product.GetProducts(con); foreach (BusinessObjects.M_Product_BS item in ProductList) { stringColl.Add(item.name); } //retreive stock data Stock sc = new Stock(); StockList = sc.GetStockList(con); foreach (BusinessObjects.Stock item in StockList) { stringColl2.Add(item.sup_name); stringColl3.Add(item.invoice_no.ToString()); } txtPNameSearch.AutoCompleteCustomSource = stringColl; txtSNameSearch.AutoCompleteCustomSource = stringColl2; txtInvoiceSearch.AutoCompleteCustomSource = stringColl3; txtSupName.AutoCompleteCustomSource = stringColl2; BusinessObjects.Category_BS catObj = new BusinessObjects.Category_BS(); CategoryList = catObj.GetCategory(con); cmbECategory.DataSource = null; cmbECategory.DataSource = CategoryList; cmbECategory.DisplayMember = "name"; cmbECategory.ValueMember = "ID"; } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void loadGrid(List <GetProductStock> List_) { try { GridList = List_; BusinessObjects.M_Product_BS cObj = new M_Product_BS(); cObjList = cObj.GetProducts(con); //this is to set the category name foreach (Category_BS itemCat in catList) { foreach (GetProductStock itemProd in GridList) { if (itemProd.category == itemCat.ID) { itemProd.catObj = itemCat; } } } int i = 0; tblProduct.Rows.Clear(); foreach (GetProductStock item in GridList) { tblProduct.Rows.Add(); tblProduct.Rows[i].Cells[0].Value = item.ID; tblProduct.Rows[i].Cells[1].Value = item.name; tblProduct.Rows[i].Cells[2].Value = item.catObj.name; tblProduct.Rows[i].Cells[3].Value = item.cost; tblProduct.Rows[i].Cells[4].Value = item.unitPrice; tblProduct.Rows[i].Cells[5].Value = item.warranty; tblProduct.Rows[i].Cells[6].Value = item.TotalQuantity; tblProduct.Rows[i].Cells[7].Value = item.date_; i++; } // autoComplete(); } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void InitialloadGrid() { try { BusinessObjects.GetProductStock spObj = new GetProductStock(); BusinessObjects.M_Product_BS cObj = new M_Product_BS(); cObjList = cObj.GetProducts(con); Category_BS catObj = new Category_BS(); catList = catObj.GetCategory(con); } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void loadGrid() { try { BusinessObjects.M_Product_BS cObj = new M_Product_BS(); cObjList = cObj.GetProducts(con); //MessageBox.Show(cObjList.Count.ToString()); Category_BS catObj = new Category_BS(); catList = catObj.GetCategory(con); foreach (Category_BS itemCat in catList) { foreach (M_Product_BS itemProd in cObjList) { if (itemProd.category == itemCat.ID) { itemProd.catObj = itemCat; } } } int i = 0; tblProduct.Rows.Clear(); //MessageBox.Show(cObjList.Count.ToString()); foreach (M_Product_BS item in cObjList) { tblProduct.Rows.Add(); tblProduct.Rows[i].Cells[0].Value = item.ID; tblProduct.Rows[i].Cells[1].Value = item.name; tblProduct.Rows[i].Cells[2].Value = item.catObj.name; tblProduct.Rows[i].Cells[3].Value = item.cost; tblProduct.Rows[i].Cells[4].Value = item.unitPrice; tblProduct.Rows[i].Cells[5].Value = item.warranty; tblProduct.Rows[i].Cells[6].Value = "Edit"; i++; } autoComplete(); } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void autoComplete() { try { txtReceiptNo.AutoCompleteMode = AutoCompleteMode.Suggest; txtReceiptNo.AutoCompleteSource = AutoCompleteSource.CustomSource; txtProductName.AutoCompleteMode = AutoCompleteMode.Suggest; txtProductName.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection stringColl = new AutoCompleteStringCollection(); AutoCompleteStringCollection stringColl2 = new AutoCompleteStringCollection(); BusinessObjects.M_Product_BS p = new M_Product_BS(); BusinessObjects.Sales_BM s = new Sales_BM(); List <M_Product_BS> PList = new List <M_Product_BS>(); List <Sales_BM> SList = new List <Sales_BM>(); PList = p.GetProducts(con); SList = s.getSales(con); SalesList_Public = SList; foreach (M_Product_BS item in PList) { // stringColl.Add(item.ID.ToString()); stringColl.Add(item.name); } foreach (Sales_BM item in SList) { stringColl2.Add(item.sales_id.ToString()); } txtProductName.AutoCompleteCustomSource = stringColl; txtReceiptNo.AutoCompleteCustomSource = stringColl2; } catch (Exception ex) { MetroMessageBox.Show(this, "! System Error . Code 104. " + ex.Message, "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void autoComplete() { try { txtPID.AutoCompleteMode = AutoCompleteMode.Suggest; txtPID.AutoCompleteSource = AutoCompleteSource.CustomSource; txtPName.AutoCompleteMode = AutoCompleteMode.Suggest; txtPName.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection stringColl = new AutoCompleteStringCollection(); AutoCompleteStringCollection stringColl2 = new AutoCompleteStringCollection(); BusinessObjects.M_Product_BS cObj = new M_Product_BS(); cObjList = cObj.GetProducts(con); Category_BS catObj = new Category_BS(); catList = catObj.GetCategory(con); foreach (M_Product_BS item in cObjList) { stringColl.Add(item.ID.ToString()); stringColl2.Add(item.name); } txtPID.AutoCompleteCustomSource = stringColl; txtPName.AutoCompleteCustomSource = stringColl2; cmbPCat.DataSource = null; cmbPCat.DataSource = catList; cmbPCat.DisplayMember = "name"; cmbPCat.ValueMember = "ID"; } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "MetroMessageBox", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void lnkSearch_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtECost.Text) || string.IsNullOrEmpty(txtEPname.Text) || string.IsNullOrEmpty(txtEPrice.Text) || cmbECategory.SelectedIndex == -1) { MetroMessageBox.Show(this, "Please enter valid data to the text fields", "System Warning!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (Convert.ToDecimal(txtEPrice.Text) < Convert.ToDecimal(txtECost.Text)) { MetroMessageBox.Show(this, "Unit Price should be higher than or equal to Unit Cost ", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Warning);; } else { int pid = 0; M_Product_BS IndexObj = new M_Product_BS(); pid = Convert.ToInt32(txtEPid.Text); string waran = ""; if (cmbMonth.Checked) { waran = " /Month"; } else { waran = " /Week"; } bool result = cObjList.Any(); if (result) { foreach (M_Product_BS item in cObjList) { if (item.ID == pid) { IndexObj.ID = pid; IndexObj.name = txtEPname.Text; IndexObj.unitPrice = Convert.ToDecimal(txtEPrice.Text); //IndexObj.boundlePrice = Convert.ToDecimal(txtEBoundlePrice.Text); IndexObj.cost = Convert.ToDecimal(txtECost.Text); IndexObj.catObj = (BusinessObjects.Category_BS)cmbECategory.SelectedItem; IndexObj.category = IndexObj.catObj.ID; //IndexObj.boundleCost = Convert.ToDecimal(txtPackagecost.Text); IndexObj.warranty = numericUpDown1.Value.ToString() + waran; if (string.IsNullOrEmpty(txtDes.Text)) { IndexObj.description = ""; } else { IndexObj.description = txtDes.Text; } } } if (IndexObj.Update(con)) { MetroMessageBox.Show(this, "Product data Successfully updated", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearText(); loadGrid(); } else { MetroMessageBox.Show(this, "Process encountered an error. Please try again", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } txtEPid.Enabled = false; txtEPname.Enabled = false; txtEPrice.Enabled = false; txtECost.Enabled = false; cmbECategory.Enabled = false; //txtEBoundlePrice.Enabled = false; lnkSearch.Enabled = false; //txtPackagecost.Enabled = false; txtDes.Enabled = false; numericUpDown1.Enabled = false; txtDes.Text = "Description"; } else { MetroMessageBox.Show(this, "Table is empty ", "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception ex) { MetroMessageBox.Show(this, "System Error " + ex.Message, "System Error ", MessageBoxButtons.OK, MessageBoxIcon.Error); } }