//Added 14 May
public int GetAnimalStatusID(AnimalStatusNew ast)
{
int id = 0;
SqlConnection con = DALHelper.getConnection();
SqlCommand cmd = new SqlCommand("sp_select_AnimalStatus_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
char isFemale = 'Y';
char IsMilk = 'Y';
if (ast.IsFemale == false)
{
isFemale = 'N';
}
if (ast.IsMilking == false)
{
IsMilk = 'N';
}
cmd.Parameters.AddWithValue("@Desc", DALHelper.getNullORValue(ast.Description));
cmd.Parameters.AddWithValue("@IsFemale", DALHelper.getNullORValue(isFemale));
cmd.Parameters.AddWithValue("@IsMilk", DALHelper.getNullORValue(IsMilk));
con.Open();
using (con)
{
id = (Int32)cmd.ExecuteScalar();
}
return(id);
}
public List <AnimalStatusNew> GetAnimalStatuses()
{
List <AnimalStatusNew> statusList = new List <AnimalStatusNew>();
SqlCommand cmd = new SqlCommand("sp_selectAnimalStatusesAll", DALHelper.getConnection());
cmd.CommandType = CommandType.StoredProcedure;
SqlConnection con = cmd.Connection;
con.Open();
using (con)
{
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
statusList = new List <AnimalStatusNew>();
while (dr.Read())
{
AnimalStatusNew mObject = new AnimalStatusNew();
mObject.ID = Convert.ToInt32(dr[0]);
mObject.Description = Convert.ToString(dr[1]);
mObject.Comments = Convert.ToString(dr[2]);
if (Convert.ToChar(dr[3]) == 'N')
{
mObject.IsMilking = false;
}
else
{
mObject.IsMilking = true;
}
if (Convert.ToChar(dr[4]) == 'N')
{
mObject.IsFemale = false;
}
else
{
mObject.IsFemale = true;
}
if (Convert.ToChar(dr[5]) == 'N')
{
mObject.IsCalf = false;
}
else
{
mObject.IsCalf = true;
}
statusList.Add(mObject);
}
}
}
return(statusList);
}
public void Save()
{
try
{
//Added on May 14
AnimalStatusNew ast = new AnimalStatusNew();
ast.Description = (string)comboBoxStatus.SelectedItem;
ast.IsMilking = (bool)comboBoxMilkingStatus.SelectedItem;
selectedAnimal = ((Cattle)comboBoxAnimal.SelectedItem);
string gender = selectedAnimal.Gender.Description;
if (gender == "F")
{
ast.IsFemale = true;
}
else
{
ast.IsFemale = false;
}
updatedStatus = animalHandler.GetAnimalStatusID(ast);
animalHandler.UpdateStatus(selectedAnimal, updatedStatus);
}
catch (Exception fexp)
{
MessageBox.Show(fexp.Message);
return;
}
//textBoxComments.Text = "";
//comboBoxMother.SelectedIndex = -1;
//datePickerStatus.Text = "";
}
