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!");
}
