private void Button_Click(object sender, RoutedEventArgs e)
{
StationId = wasteTrackerStationsComboBox.SelectedIndex;
MenuItem = menuItemTextBox.Text;
Par = decimal.Parse(parTextBox.Text);
IsActive = true;
UoM = uomCombobox.SelectedValue.ToString();
SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter da = new SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter();
try
{
//Custom Insert Statement to insert new menu items into MenuItems Table
da.InsertQuery(StationId, MenuItem, Par, UoM, IsActive);
BIMessageBox.Show("New Menu Item Added");
}
catch (Exception ex)
{
BIMessageBox.Show("Oops there was a problem, please contact Business Intelligence \n" + ex.Message);
}
#endregion
#region Reset Combobox to 0 and clear TextBoxes
//clear textbox
wasteTrackerStationsComboBox.SelectedIndex = 0;
menuItemTextBox.Clear();
parTextBox.Clear();
uomCombobox.SelectedIndex = 0;
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
SandboxDataSet ds = ((SandboxDataSet)(FindResource("sandboxDataSet")));
SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter da = new SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter();
DateTime?Date = dateDatePicker.SelectedDate;
SqlConnection conn = ConnectionHelper.GetConn();
conn.Open();
//iterate over datagrid, update values
foreach (DataRow dr in ds.WasteTrackerDB.Rows)
{
string sqlString = "UPDATE WasteTrackerDB SET LeftOver = @LeftOver, Ordered = @Ordered WHERE MenuItem = @MenuItem AND Date = @Date";
Cmd = new SqlCommand(sqlString, conn);
Cmd.Parameters.AddWithValue("@MenuItem", dr[2]);
Cmd.Parameters.AddWithValue("@LeftOver", dr[3]);
Cmd.Parameters.AddWithValue("@Ordered", dr[8]);
Cmd.Parameters.AddWithValue("@Date", Date);
Cmd.ExecuteNonQuery();
}
BIMessageBox.Show("Leftover values have been updated");
conn.Close();
}
private void wasteTrackerStationsComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
SandboxDataSet ds = ((SandboxDataSet)(FindResource("sandboxDataSet")));
//get index of combobox selected item 0 based
int item = wasteTrackerStationsComboBox.SelectedIndex;
SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter da = new SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter();
//fill datagrid with dataset of menu items that match station selection
da.FillByStation2(ds.WasteTrackerDB, item);
}
public void FillData(DateTime?start, DateTime?end, int item)
{
SandboxDataSet ds = ((SandboxDataSet)(FindResource("sandboxDataSet")));
SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter da = new SandboxDataSetTableAdapters.WasteTrackerDBTableAdapter();
string startdate = start.ToString();
string enddate = end.ToString();
if (startdate == null)
{
BIMessageBox.Show("Please Select a Date");
return;
}
else
{
da.FillByDateRange(ds.WasteTrackerDB, item, startdate, enddate);
}
}
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;
}
}
