//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 = ""; }