public static List <SampleAnalizeExt> GetSampleAnalizeExt(int fermaid, int curryear)
{
// int curryear = DateTime.Now.Year;
List <SampleAnalizeExt> samples = new List <SampleAnalizeExt>();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT NrComanda, CodFerma, CodBare, DataTestare,CantitateLaPrelevare,Grasime,ProcentProteine,Caseina,ProcentLactoza,SubstantaUscata,PH,Urea,NumarCeluleSomatice from MostreTancuri Where FermaId =" + fermaid
+ " and Year(DataTestare) =" + curryear
+ " Order By DataTestare ASC, NrComanda ASC";
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable table = ds.Tables[0];
if (table.Rows != null && table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
int nrrows = table.Rows.Count;
int count = 0;
string nrc = "C1";
if (curryear == 2012)
{
nrc = "C3";
}
while (count < nrrows)
{
row = table.Rows[count];
SampleAnalizeExt sample = new SampleAnalizeExt();
string nrcontrol = row["NrComanda"].ToString();
if (nrcontrol.StartsWith("C"))
{
int cratima = -1;
if (nrcontrol.IndexOf("-") > 0)
{
cratima = nrcontrol.IndexOf("-");
}
if (cratima > 2)
{
nrc = nrcontrol.Substring(0, cratima);
}
else
{
nrc = nrcontrol.Substring(0, 2);
}
}
sample.Datatestare = row["DataTestare"].ToString();
sample.Nrcontrol = nrc;
sample.Cantitate = Convert.ToDouble(row["CantitateLaPrelevare"]);
sample.Nrmatricol = row["CodFerma"].ToString();
sample.Codbare = row["CodBare"].ToString();
try
{
sample.Grasime = Convert.ToDouble(row["Grasime"]);
}
catch { sample.Grasime = 0.0; }
try
{
sample.Proteine = Convert.ToDouble(row["ProcentProteine"]);
}
catch { sample.Proteine = 0.0; }
try
{
sample.Caseina = Convert.ToDouble(row["Caseina"]);
}
catch { sample.Caseina = 0.0; }
try
{
sample.Lactoza = Convert.ToDouble(row["ProcentLactoza"]);
}
catch { sample.Lactoza = 0.0; }
try
{
sample.Solide = Convert.ToDouble(row["SubstabtaUscata"]);
}
catch { sample.Solide = 0.0; }
try
{
sample.Ph = Convert.ToDouble(row["PH"]);
}
catch { sample.Ph = 0.0; }
try
{
sample.Urea = Convert.ToDouble(row["Urea"]);
}
catch { sample.Urea = 0.0; }
try
{
sample.Ncs = Convert.ToDouble(row["NumarCeluleSomatice"]);
}
catch { sample.Ncs = 0.0; }
samples.Add(sample);
count++;
}
} //if data exists
return(samples);
}
public static List<SampleAnalizeExt> GetSampleAnalizeExt(int fermaid, int curryear)
{
// int curryear = DateTime.Now.Year;
List<SampleAnalizeExt> samples = new List<SampleAnalizeExt>();
SqlConnection conn =
new SqlConnection(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText =
"SELECT NrComanda, CodFerma, CodBare, DataTestare,CantitateLaPrelevare,Grasime,ProcentProteine,Caseina,ProcentLactoza,SubstantaUscata,PH,Urea,NumarCeluleSomatice from MostreTancuri Where FermaId =" +
fermaid
+ " and Year(DataTestare) =" + curryear
+ " Order By DataTestare ASC, NrComanda ASC";
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable table = ds.Tables[0];
if (table.Rows != null && table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
int nrrows = table.Rows.Count;
int count = 0;
string nrc = "C1";
if (curryear == 2012)
nrc = "C3";
while (count < nrrows)
{
row = table.Rows[count];
SampleAnalizeExt sample = new SampleAnalizeExt();
string nrcontrol = row["NrComanda"].ToString();
if (nrcontrol.StartsWith("C"))
{
int cratima = -1;
if (nrcontrol.IndexOf("-") > 0)
cratima = nrcontrol.IndexOf("-");
if (cratima > 2)
nrc = nrcontrol.Substring(0, cratima);
else
nrc = nrcontrol.Substring(0, 2);
}
sample.DataTestare = DateTime.Parse(row["DataTestare"].ToString());
sample.Nrcontrol = nrc;
sample.INrcontrol = Convert.ToInt32(nrc.Substring(1));
sample.Cantitate = Convert.ToDouble(row["CantitateLaPrelevare"], CultureInfo.InvariantCulture);
sample.Nrmatricol = row["CodFerma"].ToString();
sample.Codbare = row["CodBare"].ToString();
sample.Grasime = TryCast(row["Grasime"], 0.0);
sample.Proteine = TryCast(row["ProcentProteine"], 0.0);
sample.Caseina = TryCast(row["Caseina"], 0.0);
sample.Lactoza = TryCast(row["ProcentLactoza"], 0.0);
sample.Solide = TryCast(row["SubstantaUscata"], 0.0);
sample.Ph = TryCast(row["PH"], 0.0);
sample.Urea = TryCast(row["Urea"], 0.0);
sample.Ncs = TryCast(row["NumarCeluleSomatice"], 0.0);
samples.Add(sample);
count++;
}
} //if data exists
return samples;
}
