public int Insert(MilkingEntry milkEntry) { int cmd_success; SqlConnection con = DALHelper.getConnection(); SqlCommand cmd = new SqlCommand("sp_insertMilkEntry", con); cmd.CommandType = CommandType.StoredProcedure; #region Procedure Parameters //@TagNo varchar(30), // @RegistrationDate datetime, // @MilkingDate date, //@Shift varchar(7), // @Quantity float, // @Comments varchar(50) #endregion cmd.Parameters.AddWithValue("@ID", DALHelper.getNullORValue(milkEntry.MilkingCattle.ID)); //Modified on 01-Apr cmd.Parameters.AddWithValue("@RegistrationDate", DALHelper.getNullORValue(DateTime.Now)); cmd.Parameters.AddWithValue("@MilkingDate", DALHelper.getNullORValue(milkEntry.MilkingDate)); cmd.Parameters.AddWithValue("@Shift", DALHelper.getNullORValue(milkEntry.MilkingShift)); cmd.Parameters.AddWithValue("@Quantity", DALHelper.getNullORValue(milkEntry.Quantity)); cmd.Parameters.AddWithValue("@Comments", DALHelper.getNullORValue(milkEntry.Comments)); con.Open(); using (con) { //Modified by Talha: Jan 26th, 2012 - Added Return variable to ensure data inserted successfully cmd_success = cmd.ExecuteNonQuery(); } return(cmd_success); }
private List <MilkingEntry> selectMilkingEntries(SqlCommand cmd) { cmd.CommandType = CommandType.StoredProcedure; SqlConnection con = cmd.Connection; List <MilkingEntry> listMilkEntry = new List <MilkingEntry>(); con.Open(); using (con) { SqlDataReader dr = cmd.ExecuteReader(); // [ID] //,[Milk_Animal] //,[EntryDate] //,[MilkingDate] //,[Shift] //,[Quantity] //,[Comments] if (dr.HasRows) { listMilkEntry = new List <MilkingEntry>(); while (dr.Read()) { Cattle currCattle = new Cattle(); currCattle.TagNo = Convert.ToString(dr[1]); MilkingEntry currMilkEntry = new MilkingEntry { Comments = Convert.ToString(dr[6]), EntryTime = Convert.ToDateTime(dr[2]), MilkingDate = Convert.ToDateTime(dr[3]), MilkingShift = Convert.ToString(dr[4]), Quantity = Convert.ToDouble(dr[5]), MilkingCattle = currCattle }; listMilkEntry.Add(currMilkEntry); } } } return(listMilkEntry); }
public void AddMilkingEntry(MilkingEntry milkingEntry) { new MilkingDAL().Insert(milkingEntry); }
public void Save() { milkingHandler = new MilkingHandler(); MilkingEntry milkingEntry = new MilkingEntry(); #region Validation for valid Milking data //Check if all text boxes are empty IEnumerable <TextBox> textBoxcollection = EntryGrid.Children.OfType <TextBox>(); IEnumerable <ComboBox> comboBoxcollection = EntryGrid.Children.OfType <ComboBox>(); foreach (TextBox box in textBoxcollection) { if (box.Name == "textBoxComments") { //ignore } else { if (string.IsNullOrWhiteSpace(box.Text)) { MessageBox.Show("Kindly Fill all the boxes. (Only Comments are Optional)"); return; } } } foreach (ComboBox box in comboBoxcollection) { if (box.SelectedIndex == -1) { MessageBox.Show("Kindly Select all the fields"); return; } } #endregion try { //Inserting values in Object milkingEntry.EntryTime = DateTime.Now; if (milkingShiftComboBox.SelectedIndex == 0) { milkingEntry.MilkingShift = "Morning"; } if (milkingShiftComboBox.SelectedIndex == 1) { milkingEntry.MilkingShift = "Evening"; } //milkingEntry.MilkingShift = (MilkingShift)milkingShiftComboBox.SelectedItem; milkingEntry.MilkingDate = datePickerMilking.SelectedDate.Value; Cattle milkCattle = new Cattle(); milkCattle = (Cattle)tagNoComboBox.SelectedItem; milkingEntry.MilkingCattle = milkCattle; milkingEntry.Quantity = Convert.ToDouble(textBoxQuantity.Text); milkingHandler.AddMilkingEntry(milkingEntry); } catch (ArgumentException exc) { MessageBox.Show(exc.Message, "Error!"); return; } //catch (InvalidCastException exc) //{ // MessageBox.Show(exc.Message, "Error!"); // return; //} //Clear all the TextBoxes foreach (TextBox box in textBoxcollection) { box.Text = ""; } foreach (ComboBox box in comboBoxcollection) { box.SelectedIndex = -1; } //MessageBox.Show("Successfully Saved!"); }