public void BindData() { GridView1.DataSource = GetMostrePaged(GridView1.PageIndex, GridView1.PageSize); GridView1.VirtualItemCount = GetMostreCount(); lcount.Text = GridView1.VirtualItemCount + " mostre"; GridView1.DataBind(); for (int i = 0; i < GridView1.Rows.Count; i++) { try { if (GridView1.Rows[i].Cells[4].Text.Trim() != "" && !GridView1.Rows[i].Cells[4].Text.StartsWith(" ")) { if (UMostre.VerificGrasime(GridView1.Rows[i].Cells[4].Text) == 1) { GridView1.Rows[i].Cells[4].BackColor = Color.Red; } string grasime = GridView1.Rows[i].Cells[4].Text.Trim(); GridView1.Rows[i].Cells[4].Text = (Convert.ToDouble(grasime) == 0) ? "" : (Convert.ToDouble(grasime) == 0.00001) ? "0" : grasime; } if (GridView1.Rows[i].Cells[5].Text.Trim() != "" && !GridView1.Rows[i].Cells[5].Text.StartsWith(" ")) { if (UMostre.VerificProteine(GridView1.Rows[i].Cells[5].Text) == 1) { GridView1.Rows[i].Cells[5].BackColor = Color.Red; } string proteine = GridView1.Rows[i].Cells[5].Text.Trim(); GridView1.Rows[i].Cells[5].Text = (Convert.ToDouble(proteine) == 0) ? "" : (Convert.ToDouble(proteine) == 0.00001) ? "0" : proteine; } if (GridView1.Rows[i].Cells[7].Text.Trim() != "" && !GridView1.Rows[i].Cells[7].Text.StartsWith(" ")) { if (UMostre.VerificLactoza(GridView1.Rows[i].Cells[7].Text) == 1) { GridView1.Rows[i].Cells[7].BackColor = Color.Red; } string lactoza = GridView1.Rows[i].Cells[7].Text.Trim(); GridView1.Rows[i].Cells[7].Text = (Convert.ToDouble(lactoza) == 0) ? "" : (Convert.ToDouble(lactoza) == 0.00001) ? "0" : lactoza; } if (GridView1.Rows[i].Cells[8].Text.Trim() != "" && !GridView1.Rows[i].Cells[8].Text.StartsWith(" ")) { if (UMostre.VerificSolids(GridView1.Rows[i].Cells[8].Text) == 1) { GridView1.Rows[i].Cells[8].BackColor = Color.Red; } string substu = GridView1.Rows[i].Cells[8].Text.Trim(); GridView1.Rows[i].Cells[8].Text = (Convert.ToDouble(substu) == 0) ? "" : (Convert.ToDouble(substu) == 0.00001) ? "0" : substu; } //ph if (GridView1.Rows[i].Cells[9].Text.Trim() != "" && !GridView1.Rows[i].Cells[9].Text.StartsWith(" ")) { if (UMostre.VerificPh(GridView1.Rows[i].Cells[9].Text) == 1) { GridView1.Rows[i].Cells[9].BackColor = Color.Red; } string ph = GridView1.Rows[i].Cells[9].Text.Trim(); GridView1.Rows[i].Cells[9].Text = (Convert.ToDouble(ph) == 0) ? "" : (Convert.ToDouble(ph) == 0.00001) ? "0" : ph; } string pcti = GridView1.Rows[i].Cells[10].Text.Trim(); if (pcti != "" && !pcti.StartsWith(" ") && Convert.ToDouble(pcti) != 0.00001) { if (UMostre.VerificPctInghet(pcti) == 1) { GridView1.Rows[i].Cells[10].BackColor = Color.Red; } GridView1.Rows[i].Cells[10].Text = (Convert.ToDouble(pcti) == 0) ? "" : (Convert.ToDouble(pcti) == 0.00001) ? "0" : "-0." + pcti; } //urea if (GridView1.Rows[i].Cells[13].Text.Trim() != "" && !GridView1.Rows[i].Cells[13].Text.StartsWith(" ")) { if (UMostre.VerificUrea(GridView1.Rows[i].Cells[13].Text) == 1) { GridView1.Rows[i].Cells[13].BackColor = Color.Red; } string urea = GridView1.Rows[i].Cells[13].Text.Trim(); GridView1.Rows[i].Cells[13].Text = (Convert.ToDouble(urea) == 0) ? "" : (Convert.ToDouble(urea) == 0.00001) ? "0" : urea; } if (GridView1.Rows[i].Cells[14].Text.Trim() != "" && !GridView1.Rows[i].Cells[14].Text.StartsWith(" ")) { if (UMostre.VerificNCS(GridView1.Rows[i].Cells[14].Text) == 1) { GridView1.Rows[i].Cells[14].BackColor = Color.Red; } string ncs = GridView1.Rows[i].Cells[14].Text.Trim(); GridView1.Rows[i].Cells[14].Text = (Convert.ToDouble(ncs) == 0) ? "" : (Convert.ToDouble(ncs) == 0.00001) ? "0" : ncs; } if (GridView1.Rows[i].Cells[15].Text.Trim() != "" && !GridView1.Rows[i].Cells[15].Text.StartsWith(" ")) { if (UMostre.VerificNTG(GridView1.Rows[i].Cells[15].Text) == 1) { GridView1.Rows[i].Cells[15].BackColor = Color.Red; } string ntg = GridView1.Rows[i].Cells[15].Text.Trim(); GridView1.Rows[i].Cells[15].Text = (Convert.ToDouble(ntg) == 0) ? "" : (Convert.ToDouble(ntg) == 0.00001) ? "0" : ntg; } } catch (Exception ex) { logger.Error(string.Format("BindData|ERROR:{0}", ex.Message)); } } }
public void BindData() { GridView1.DataSource = GetMostrePaged(GridView1.PageIndex, GridView1.PageSize); GridView1.VirtualItemCount = GetMostreCount(); lcount.Text = GridView1.VirtualItemCount + " mostre"; GridView1.DataBind(); for (int i = 0; i < GridView1.Rows.Count; i++) { try { if (GridView1.Rows[i].Cells[5].Text.Trim() != "" && !GridView1.Rows[i].Cells[5].Text.StartsWith(" ")) { if (UMostre.VerificGrasime(GridView1.Rows[i].Cells[5].Text) == 1) { GridView1.Rows[i].Cells[5].BackColor = Color.Red; } string grasime = GridView1.Rows[i].Cells[5].Text.Trim(); GridView1.Rows[i].Cells[5].Text = (Convert.ToDouble(grasime, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(grasime, CultureInfo.InvariantCulture) == 0.00001) ? "0" : grasime; } if (GridView1.Rows[i].Cells[6].Text.Trim() != "" && !GridView1.Rows[i].Cells[6].Text.StartsWith(" ")) { if (UMostre.VerificProteine(GridView1.Rows[i].Cells[6].Text) == 1) { GridView1.Rows[i].Cells[6].BackColor = Color.Red; } string proteine = GridView1.Rows[i].Cells[6].Text.Trim(); GridView1.Rows[i].Cells[6].Text = (Convert.ToDouble(proteine, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(proteine, CultureInfo.InvariantCulture) == 0.00001) ? "0" : proteine; } if (GridView1.Rows[i].Cells[7].Text.Trim() != "" && !GridView1.Rows[i].Cells[7].Text.StartsWith(" ")) { string cazeina = GridView1.Rows[i].Cells[7].Text.Trim(); GridView1.Rows[i].Cells[7].Text = (Convert.ToDouble(cazeina, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(cazeina, CultureInfo.InvariantCulture) == 0.00001) ? "0" : cazeina; } if (GridView1.Rows[i].Cells[8].Text.Trim() != "" && !GridView1.Rows[i].Cells[8].Text.StartsWith(" ")) { if (UMostre.VerificLactoza(GridView1.Rows[i].Cells[8].Text) == 1) { GridView1.Rows[i].Cells[8].BackColor = Color.Red; } string lactoza = GridView1.Rows[i].Cells[8].Text.Trim(); GridView1.Rows[i].Cells[8].Text = (Convert.ToDouble(lactoza, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(lactoza, CultureInfo.InvariantCulture) == 0.00001) ? "0" : lactoza; } if (GridView1.Rows[i].Cells[9].Text.Trim() != "" && !GridView1.Rows[i].Cells[9].Text.StartsWith(" ")) { if (UMostre.VerificSolids(GridView1.Rows[i].Cells[9].Text) == 1) { GridView1.Rows[i].Cells[9].BackColor = Color.Red; } string substu = GridView1.Rows[i].Cells[9].Text.Trim(); GridView1.Rows[i].Cells[9].Text = (Convert.ToDouble(substu, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(substu, CultureInfo.InvariantCulture) == 0.00001) ? "0" : substu; } //ph if (GridView1.Rows[i].Cells[10].Text.Trim() != "" && !GridView1.Rows[i].Cells[10].Text.StartsWith(" ")) { if (UMostre.VerificPh(GridView1.Rows[i].Cells[10].Text) == 1) { GridView1.Rows[i].Cells[10].BackColor = Color.Red; } string ph = GridView1.Rows[i].Cells[10].Text.Trim(); GridView1.Rows[i].Cells[10].Text = (Convert.ToDouble(ph, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(ph, CultureInfo.InvariantCulture) == 0.00001) ? "0" : ph; } //urea if (GridView1.Rows[i].Cells[11].Text.Trim() != "" && !GridView1.Rows[i].Cells[11].Text.StartsWith(" ")) { string urea = GridView1.Rows[i].Cells[11].Text.Trim(); if ((Convert.ToDouble(urea, CultureInfo.InvariantCulture) >= 0.1) && UMostre.VerificUrea(urea) == 1) { GridView1.Rows[i].Cells[11].BackColor = Color.Red; } GridView1.Rows[i].Cells[11].Text = (Convert.ToDouble(urea, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(urea, CultureInfo.InvariantCulture) == 0.00001) ? "" : (Convert.ToDouble(urea, CultureInfo.InvariantCulture) < 0.1) ? "" : urea; } if (GridView1.Rows[i].Cells[12].Text.Trim() != "" && !GridView1.Rows[i].Cells[12].Text.StartsWith(" ")) { if (UMostre.VerificNCS(GridView1.Rows[i].Cells[12].Text) == 1) { GridView1.Rows[i].Cells[12].BackColor = Color.Red; } string ncs = GridView1.Rows[i].Cells[12].Text.Trim(); GridView1.Rows[i].Cells[12].Text = (Convert.ToDouble(ncs, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(ncs, CultureInfo.InvariantCulture) == 0.00001) ? "0" : ncs; } } catch (Exception ex) { logger.Error(string.Format("BindData|ERROR:{0}", ex.Message)); } } }