public void ShowDataOnGrid() { retrieve.ShowStock(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductUnitGv, ProductMinValGv, AvailableStocks, ReworkedStock, RejectedStock, OnholdStock); foreach (DataGridViewRow rows in dataGridViewProduct.Rows) { if (Convert.ToDecimal(rows.Cells["ProductMinValGv"].Value) < Convert.ToDecimal(rows.Cells["AvailableStocks"].Value)) { rows.Cells["ProductNameGv"].Style.BackColor = Color.LightGreen; rows.Cells["ProductNameGv"].Style.ForeColor = Color.Black; rows.Cells["AvailableStocks"].Style.BackColor = Color.LightGreen; rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; } else { rows.Cells["ProductNameGv"].Style.BackColor = Color.IndianRed; rows.Cells["ProductNameGv"].Style.ForeColor = Color.Black; rows.Cells["AvailableStocks"].Style.BackColor = Color.IndianRed; rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; } } }
public override void textBoxSearch_TextChanged(object sender, EventArgs e) { if (textBoxSearch.Text != "") { retrieve.ShowRejectedStock(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductUnitGv, ProductMinValGv, AvailableStocks, ReworkedStock, RejectedStock, OnholdStock, textBoxSearch.Text); //foreach (DataGridViewRow rows in dataGridViewProduct.Rows) //{ // if (Convert.ToDecimal(rows.Cells["ProductMinValGv"].Value) < Convert.ToDecimal(rows.Cells["AvailableStocks"].Value)) // { // rows.Cells["AvailableStocks"].Style.BackColor = Color.LightGreen; // rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; // } // else // { // rows.Cells["AvailableStocks"].Style.BackColor = Color.IndianRed; // rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; // } //} } else { retrieve.ShowStock(dataGridViewProduct, ProductIdGv, ProductNameGv, ProductCodeGv, ProductUnitGv, ProductMinValGv, AvailableStocks, ReworkedStock, RejectedStock, OnholdStock); //foreach (DataGridViewRow rows in dataGridViewProduct.Rows) //{ // if (Convert.ToDecimal(rows.Cells["ProductMinValGv"].Value) < Convert.ToDecimal(rows.Cells["AvailableStocks"].Value)) // { // rows.Cells["AvailableStocks"].Style.BackColor = Color.LightGreen; // rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; // } // else // { // rows.Cells["AvailableStocks"].Style.BackColor = Color.IndianRed; // rows.Cells["AvailableStocks"].Style.ForeColor = Color.Black; // } //} } }