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