private void Button_Click(object sender, RoutedEventArgs e)
{
SandboxDataSet ds = ((SandboxDataSet)(FindResource("sandboxDataSet")));
SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter da = new SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter();
DateTime?Date = dateDatePicker.SelectedDate;
//if there is a date selected
if (Date != null)
{
try
{
//use SQL command to insert into DB
SqlConnection conn = ConnectionHelper.GetConn();
conn.Open();
decimal LeftOver;
decimal Ordered;
//iterate over each row of DataGrid, get values of each cell, and insert into DB
foreach (DataRow dr in ds.WasteTrackerDB.Rows)
{
string sqlString = "INSERT INTO WasteTrackerDB VALUES (@StationId, @MenuItem, @LeftOver, @Par, @UoM, @Date, @IsActive, @Ordered, @Notes)";
Cmd = new SqlCommand(sqlString, conn);
Cmd.Parameters.AddWithValue("@StationId", dr[1]);
Cmd.Parameters.AddWithValue("@MenuItem", dr[2]);
Cmd.Parameters.AddWithValue("@LeftOver", dr[3]);
Cmd.Parameters.AddWithValue("@Par", dr[4]);
Cmd.Parameters.AddWithValue("@UoM", dr[5]);
Cmd.Parameters.AddWithValue("@Date", Date);
Cmd.Parameters.AddWithValue("@IsActive", 1);
Cmd.Parameters.AddWithValue("@Ordered", dr[8]);
Cmd.Parameters.AddWithValue("@Notes", dr[12]);
string leftOver = dr[3].ToString();
string ordered = dr[8].ToString();
if (leftOver == "" || ordered == "")
{
BIMessageBox.Show("Please enter a valid number between 0 and 99999999");
return;
}
else
{
LeftOver = decimal.Parse(leftOver);
Ordered = decimal.Parse(ordered);
if (LeftOver < 0 || Ordered < 0 || LeftOver == -1 || Ordered == -1)
{
BIMessageBox.Show("Please enter a valid number between 0 and 9999999999");
return;
}
else
{
Cmd.ExecuteNonQuery();
}
}
}
BIMessageBox.Show("Leftover values have been added");
conn.Close();
}
catch (Exception ex)
{
BIMessageBox.Show("Oops there was a problem, please contact Business Intelligence \n" + ex);
}
}
//oops there was no date selected
else
{
BIMessageBox.Show("Please Enter a Date");
return;
}
}
