public void Add(AnimalInsemnation currAnimalInsemnation)
{
SqlConnection con = DALHelper.getConnection();
SqlCommand cmd = new SqlCommand("sp_insertAnimalInsemnation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Animal", DALHelper.getNullORValue(currAnimalInsemnation.CurrCattle.ID));
cmd.Parameters.AddWithValue("@Date", DALHelper.getNullORValue(currAnimalInsemnation.DateofInsemnation));
cmd.Parameters.AddWithValue("@Comments", DALHelper.getNullORValue(currAnimalInsemnation.Comments));
con.Open();
using (con)
{
cmd.ExecuteNonQuery();
}
//return cmd_success;
}
private List <AnimalInsemnation> selectInsemnations(SqlCommand cmd)
{
cmd.CommandType = CommandType.StoredProcedure;
SqlConnection con = cmd.Connection;
List <AnimalInsemnation> listInsemnation = new List <AnimalInsemnation>();
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
// i.ID,
//i.Animal,
//a.TagNo,
//i.Date,
//i.Comments
if (dr.HasRows)
{
listInsemnation = new List <AnimalInsemnation>();
while (dr.Read())
{
Cattle currCattle = new Cattle
{
ID = Convert.ToInt32(dr[1]),
TagNo = Convert.ToString(dr[2]),
};
AnimalInsemnation currInsem = new AnimalInsemnation();
currInsem.CurrCattle = currCattle;
currInsem.Comments = Convert.ToString(dr[4]);
currInsem.DateofInsemnation = Convert.ToDateTime(dr[3]);
listInsemnation.Add(currInsem);
}
}
}
return(listInsemnation);
}
public void Save()
{
try
{
currAnimalInsemnation = new AnimalInsemnation();
currAnimalInsemnation.Comments = textBoxComments.Text;
currAnimalInsemnation.CurrCattle = (Cattle)comboBoxMother.SelectedItem;
currAnimalInsemnation.DateofInsemnation = datePickerInsemnation.SelectedDate.Value;
insemnationHandler.Add(currAnimalInsemnation);
}
catch (Exception fexp)
{
MessageBox.Show(fexp.Message);
return;
}
textBoxComments.Text = "";
comboBoxMother.SelectedIndex = -1;
datePickerInsemnation.Text = "";
}
public void Add(AnimalInsemnation currAnimalInsemnation)
{
new AnimalInseminationsDAL().Add(currAnimalInsemnation);
}