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