public List <TubeSim> GetTubes(int CompanyId)
{
List <TubeSim> ReturnObject = new List <TubeSim>();
TubeSim ins;
DataBaseConnection dbConn = new DataBaseConnection();
using (var con = dbConn.SqlConn())
{
con.Open();
using (SqlCommand cmd = new SqlCommand("exec " + CommonStrings.SimTubes + " @CompanyId", con))
{
cmd.Parameters.AddWithValue("@CompanyId", CompanyId);
using (var drI = cmd.ExecuteReader())
{
while (drI.Read())
{
ins = new TubeSim();
ins.AnimalId = Convert.ToInt32(drI["AnimalId"]);
ins.TubeId = Convert.ToInt32(drI["TubeId"]);
ReturnObject.Add(ins);
}
}
}
}
return(ReturnObject);
}
public List<TubeSim> GetTubes(int CompanyId)
{
List<TubeSim> ReturnObject = new List<TubeSim>();
TubeSim ins;
DataBaseConnection dbConn = new DataBaseConnection();
using (var con = dbConn.SqlConn())
{
con.Open();
using (SqlCommand cmd = new SqlCommand("exec " + CommonStrings.SimTubes + " @CompanyId", con))
{
cmd.Parameters.AddWithValue("@CompanyId", CompanyId);
using (var drI = cmd.ExecuteReader())
{
while (drI.Read())
{
ins = new TubeSim();
ins.AnimalId = Convert.ToInt32(drI["AnimalId"]);
ins.TubeId = Convert.ToInt32(drI["TubeId"]);
ReturnObject.Add(ins);
}
}
}
}
return ReturnObject;
}
