private void Load_AllProducts_DataGrid() { dgvDataFrom_Initialize(); DataAccessPOS dbPOS = new DataAccessPOS(); prods = dbPOS.Get_All_Products(); lbl_AllProds.Text = "All Products ( " + prods.Count.ToString() + " )"; if (prods.Count > 0) { foreach (var prod in prods) { this.dgvDataFrom.Rows.Add(new String[] { prod.Id.ToString(), dbPOS.Get_ProductTypeName_By_Id(prod.ProductTypeId), prod.ProductName, prod.OutUnitPrice.ToString() }); /* if (ptype.IsBatchDonation) * { * this.dgvData.Rows[dgvData.RowCount - 2].Cells[3].Style.BackColor = Color.Green; * } * if (ptype.IsBatchDiscount) * { * this.dgvData.Rows[dgvData.RowCount - 2].Cells[4].Style.BackColor = Color.Green; * }*/ this.dgvDataFrom.FirstDisplayedScrollingRowIndex = dgvDataFrom.RowCount - 1; } } }
private void bt_Product_Click(object sender, EventArgs e) { //pnl_Product.Show(); //pnl_User.Hide(); bt_Product.BackColor = Color.Yellow; bt_LoginUser.BackColor = Color.Khaki; bt_ProdType.BackColor = Color.LightGreen; bt_RFIDTags.BackColor = Color.LightGreen; bt_Tax.BackColor = Color.DarkOrange; bt_SysConfig.BackColor = Color.Orchid; DataAccessPOS dbPOS = new DataAccessPOS(); prods = dbPOS.Get_All_Products(); isProduct = true; isLoginUser = false; isPType = false; isRFIDTag = false; isSysConfig = false; isTax = false; isStation = false; isPromotion = false; dgvData_Prod_Initialize(); if (prods.Count > 0) { foreach (var prod in prods) { this.dgvData.Rows.Add(new String[] { prod.Id.ToString(), prod.ProductName, prod.SecondName, prod.OutUnitPrice.ToString(), prod.IsTax1.ToString(), prod.IsTax2.ToString(), prod.IsTax3.ToString(), prod.IsPrinter1.ToString(), prod.IsPrinter2.ToString(), prod.IsPrinter3.ToString(), prod.IsPrinter4.ToString(), prod.IsPrinter5.ToString() }); if (prod.IsTax1) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[4].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[4].Style.BackColor = Color.LightSalmon; }; if (prod.IsTax2) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[5].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[5].Style.BackColor = Color.LightSalmon; }; if (prod.IsTax3) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[6].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[6].Style.BackColor = Color.LightSalmon; }; if (prod.IsPrinter1) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[7].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[7].Style.BackColor = Color.LightSalmon; }; if (prod.IsPrinter2) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[8].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[8].Style.BackColor = Color.LightSalmon; }; if (prod.IsPrinter3) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[9].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[9].Style.BackColor = Color.LightSalmon; }; if (prod.IsPrinter4) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[10].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[10].Style.BackColor = Color.LightSalmon; }; if (prod.IsPrinter5) { this.dgvData.Rows[dgvData.RowCount - 2].Cells[11].Style.BackColor = Color.Green; } else { this.dgvData.Rows[dgvData.RowCount - 2].Cells[11].Style.BackColor = Color.LightSalmon; }; this.dgvData.FirstDisplayedScrollingRowIndex = dgvData.RowCount - 1; } } }