private void SetInteractionTimes()
{
List <InteractionCount> interactionLog = new List <InteractionCount>();
InteractionCount ins;
SqlConnection sqlConn = DataBaseConnection.SqlConn();
using (var con = sqlConn)
{
con.Open();
using (SqlCommand cmd = new SqlCommand("exec service_GetEstrousFromInteractionTime @TestDate, @Sensitivity", con))
{
cmd.Parameters.AddWithValue("@Testdate", DateTime.Today);
cmd.Parameters.AddWithValue("@Sensitivity", this.InteractionSensitivity);
using (var drI = cmd.ExecuteReader())
{
int AnimalId = drI.GetOrdinal("AnimalId");
int Average = drI.GetOrdinal("AveragePerDay");
int Last = drI.GetOrdinal("LastDay");
while (drI.Read())
{
ins = new InteractionCount();
ins.AnimalId = Convert.ToInt32(drI[AnimalId]);
ins.AveragePerDay = Convert.ToInt32(drI[Average]);
ins.LastPeriod = Convert.ToInt32(drI[Last]);
interactionLog.Add(ins);
}
}
}
con.Close();
con.Dispose();
}
//Console.WriteLine("Done Inserting Interaction Times in object list @ " + DateTime.Now.ToString());
this.TimeOfInteractions = interactionLog;
}
private void SetNumberOfInteractions()
{
List<InteractionCount> interactionLog = new List<InteractionCount>();
InteractionCount ins;
SqlConnection sqlConn = DataBaseConnection.SqlConn();
using (var con = sqlConn)
{
con.Open();
using (SqlCommand cmd = new SqlCommand("exec service_GetEstrousFromInteractions @TestDate, @Sensitivity", con))
{
cmd.Parameters.AddWithValue("@Testdate", DateTime.Today);
cmd.Parameters.AddWithValue("@Sensitivity", this.InteractionSensitivity);
using (var drI = cmd.ExecuteReader())
{
int AnimalId = drI.GetOrdinal("AnimalId");
int Average = drI.GetOrdinal("AveragePerDay");
int Last = drI.GetOrdinal("LastDay");
while (drI.Read())
{
ins = new InteractionCount();
ins.AnimalId = Convert.ToInt32(drI[AnimalId]);
ins.AveragePerDay = Convert.ToInt32(drI[Average]);
ins.LastPeriod = Convert.ToInt32(drI[Last]);
interactionLog.Add(ins);
}
}
}
con.Close();
con.Dispose();
}
//Console.WriteLine("Done Inserting Interactions in object list @ " + DateTime.Now.ToString());
this.NumberOfInteractions = interactionLog;
}
