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