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;
// }
//}
}
}
