public ArrayList GetMostrePaged(int pageIndex, int pageSize)
{
int startIdx = pageSize * pageIndex + 1;
int endIdx = pageSize * (pageIndex + 1);
ArrayList values = new ArrayList();
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = GetSelectStatement(startIdx, endIdx);
cmd.CommandTimeout = 300;
cnn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
VMostre vm = new VMostre();
vm.id = Convert.ToString(reader["ID"]);
vm.codbare = Convert.ToString(reader["CodBare"]);
vm.idzilnic = Convert.ToString(reader["IdZilnic"]);
vm.datat = Convert.ToString(reader["DataTestare"]);
vm.grasime = Convert.ToString(reader["Grasime"]);
vm.proteina = Convert.ToString(reader["ProcentProteine"]);
vm.lactoza = Convert.ToString(reader["ProcentLactoza"]);
vm.substu = Convert.ToString(reader["SubstantaUscata"]);
vm.pcti = Convert.ToString(reader["PunctInghet"]);
vm.apaad = "";
if (!string.IsNullOrEmpty(vm.pcti) && vm.pcti != "0" && vm.pcti.IndexOf(".") < 0)
{
vm.apaad = UMostre.ApaAdaugata(vm.pcti);
}
vm.antib = Convert.ToString(reader["Antibiotice"]);
if (vm.antib == "-1" || vm.antib == "1")
{
vm.antib = "Pozitiv";
}
else if (vm.antib == "0")
{
vm.antib = "Negativ";
}
vm.ncs = Convert.ToString(reader["NumarCeluleSomatice"]);
vm.ntg = Convert.ToString(reader["IncarcaturaGermeni"]);
vm.urea = Convert.ToString(reader["Urea"]);
vm.ph = Convert.ToString(reader["PH"]);
vm.casein = Convert.ToString(reader["Caseina"]);
vm.validat = Convert.ToString(reader["Validat"]);
vm.bvalidat = Convert.ToBoolean(reader["Validat"]);
vm.bdefinitiv = Convert.ToBoolean(reader["Definitiv"]);
vm.definitiv = Convert.ToString(reader["Definitiv"]);
vm.dataf = Convert.ToString(reader["DataTestareFinala"]);
values.Add(vm);
}
reader.Close();
cnn.Close();
return(values);
}
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));
}
}
}
