private void LookupBtn_Click(object sender, EventArgs e)
{
try
{
if (cboShippers.SelectedIndex <= 0)
{
MessageBox.Show("Please select a shipper before clicking [Lookup Shipper]");
}
else
{
int shipperId = Convert.ToInt32(cboShippers.SelectedValue);
NorthwindManager mgr = new NorthwindManager();
var shipper = mgr.GetShipper(shipperId);
if (shipper != null)
{
lblShipperID.Text = shipper.ShipperID.ToString();
txtCompanyName.Text = shipper.CompanyName;
txtPhone.Text = shipper.Phone;
}
}
}
catch (Exception ex)
{
//TODO: Log the exception
MessageBox.Show("Error: " + ex.Message);
}
}
private void btnLookupShippers_Click(object sender, EventArgs e)
{
try
{
if (cboShippers.SelectedIndex <= 0)
{
MessageBox.Show("Please select a shipper before clicking [Lookup]");
}
else
{
int shipperId = Convert.ToInt32(cboShippers.SelectedValue);
NorthwindManager nwm = new NorthwindManager();
Shipper shipr = nwm.GetShipper(shipperId);
ShipperID.Text = shipr.ShipperID.ToString();
txtCompanyName.Text = shipr.CompanyName;
txtPhone.Text = shipr.Phone;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
private void btnUpdateShipper_Click(object sender, EventArgs e)
{
try
{
int shipperId;
if (int.TryParse(tboShipperID.Text, out shipperId))
{
//Do the update
var info = new Shipper()
{
ShipperID = shipperId,
CompanyName = tboCompanyName.Text,
Phone = tboPhone.Text
};
var mgr = new NorthwindManager();
mgr.UpdateShipper(info);
PopulateShippersComboBox();
cboShippers.SelectedValue = info.ShipperID;
}
else
{
MessageBox.Show("Please lookup a shipper before trying to update.");
}
}
catch (Exception ex)
{
//TODO: Log the exception
MessageBox.Show(ex.Message);
}
}
private void btnAdShipper_Click(object sender, EventArgs e)
{
try
{
Shipper elem = new Shipper()
{
CompanyName = txtCompanyName.Text,
Phone = txtPhone.Text
};
var mgr = new NorthwindManager();
elem.ShipperID = mgr.AddShipper(elem);
//give feed back to user
// updater shipper combobox and select right shipper
//display id of added shipper
PopulateShippersComboBox();
cboShippers.SelectedValue = elem.ShipperID;
ShipperID.Text = elem.ShipperID.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
NorthwindManager mgr = new NorthwindManager();
int shipperId = mgr.AddShipper(new Shipper()
{
CompanyName = txtCompanyName.Text,
Phone = txtPhone.Text
});
//update the combobox
PopulateShippersComboBox();
//has right shipper selected
cboShippers.SelectedValue = shipperId;
//display id of added shipper
lblShipperID.Text = shipperId.ToString();
}
catch (Exception ex)
{
//TODO: Log the exception
MessageBox.Show("Error: " + ex.Message);
}
}
public ActionResult Categories()
{
NorthwindManager mgr = new NorthwindManager(Properties.Settings.Default.ConStr);
IEnumerable <Category> categories = mgr.GetCategories();
return(View(categories));
}
public ActionResult OrderDetails()
{
NorthwindManager mgr = new NorthwindManager(Properties.Settings.Default.ConStr);
IEnumerable <OrderDetail> orderDetails = mgr.GetOrderDetailsFor1997();
return(View(orderDetails));
}
private void btnDeleteShipper_Click(object sender, EventArgs e)
{
try
{
int temp;
if (int.TryParse(ShipperID.Text, out temp))
{
var elem = new Shipper()
{
ShipperID = temp
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(elem);
PopulateShippersComboBox();
ShipperID.Text = "";
txtCompanyName.Text = "";
txtPhone.Text = "";
}
else
{
MessageBox.Show("Please look up a shipper before trying delete.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
private void btnDeleteShipper_Click(object sender, EventArgs e)
{
try
{
int temp;
if (int.TryParse(tboShipperID.Text, out temp))
{
var data = new Shipper()
{
ShipperID = temp
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(data);
//feedback to user
PopulateShippersComboBox();
//clear the form textboxes
tboShipperID.Text = "";
tboCompanyName.Text = "";
tboPhone.Text = "";
}
else
{
MessageBox.Show("Please lookup a shipper before trying to delete.");
}
}
catch (Exception ex)
{
//TODO: Log the exception
Program.LogMessage(ex.Message);
MessageBox.Show(ex.Message);
}
}
private void btnDeleteShipper_Click(object sender, EventArgs e)
{
try
{
int temp;
if (int.TryParse(lblShipperID.Text, out temp))
{
var info = new Shipper()
{
ShipperID = temp
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(info);
// Feedback to user
PopulateShippersComboBox();
// clear the form textboxes
Clear();
}
else
{
MessageBox.Show("Please lookup a shipper before trying to delete.");
}
}
catch (Exception ex)
{
// TODO: log exception
MessageBox.Show(ex.Message);
}
}
private void UpdateShipper_Click(object sender, EventArgs e)
{
try
{
int tempShipper;
if (int.TryParse(ShipperId.Text, out tempShipper))
{
// do the update...this is an initializer list, constructor runs, properties of the Shipper Object get values
var info = new Shipper()
{
ShipperID = tempShipper,
CompanyName = CompanyName.Text,
Phone = Phone.Text
};
var mgr = new NorthwindManager();
mgr.UpdateShipper(info);
PopulateShippersComboBox();
cboShippers.SelectedValue = info.ShipperID;
}
else
{
MessageBox.Show("Please look up a shipper before trying to update.");
}
}
catch (Exception ex)
{
// TODO: Update logging
MessageBox.Show(ex.Message);
}
}
private void btnLookupShipper_Click(object sender, EventArgs e)
{
try
{ // get data from form
if (cboShippers.SelectedIndex <= 0)
{
MessageBox.Show("Please select a shipper before clicking [lookup]");
}
else
{
int shipperId = Convert.ToInt32(cboShippers.SelectedValue);
NorthwindManager mgr = new NorthwindManager();
Shipper data = mgr.GetShipper(shipperId);
// unpack the data
ShipperId.Text = data.ShipperID.ToString();
CompanyName.Text = data.CompanyName;
Phone.Text = data.Phone;
}
}
catch (Exception)
{
throw;
}
}
private void btnLookupShipper_Click(object sender, EventArgs e)
{
try
{
if (cboShippers.SelectedIndex <= 0)
{
MessageBox.Show("Please select a shipper before clicking [Lookup]");
}
else
{
int shipperId = Convert.ToInt32(cboShippers.SelectedValue);
NorthwindManager mgr = new NorthwindManager();
Shipper data = mgr.GetShipper(shipperId);
// Unpack the data
lblShipperID.Text = data.ShipperID.ToString();
txtCompanyName.Text = data.CompanyName;
txtPhone.Text = data.Phone;
}
}
catch (Exception ex)
{
// TODO: log exception
MessageBox.Show(ex.Message);
}
}
private void btnUpdateShipper_Click(object sender, EventArgs e)
{
try
{
int shipperId;
if (int.TryParse(lblShipperID.Text, out shipperId))
{
var info = new Shipper()
{
ShipperID = shipperId,
CompanyName = txtCompanyName.Text,
Phone = txtPhone.Text
};
var mgr = new NorthwindManager();
mgr.UpdateShipper(info);
PopulateShippersComboBox();
cboShippers.SelectedValue = info.ShipperID;
// Maybe there should be some indication to the user that the update was successful. MessageBox? Label?
}
else
{
MessageBox.Show("Please lookup a shipper before trying to update.");
}
}
catch (Exception ex)
{
// TODO: log exception
MessageBox.Show(ex.Message);
}
}
private void btnLookupShipper_Click(object sender, EventArgs e)
{
try
{
//Get data from form
if (cboShippers.SelectedIndex <= 0)
{
MessageBox.Show("Please select a shipper.");
}
else
{
int shipperId = Convert.ToInt32(cboShippers.SelectedValue);
NorthwindManager mgr = new NorthwindManager();
Shipper data = mgr.GetShipper(shipperId);
//Unpack the data
tboShipperID.Text = data.ShipperID.ToString();
tboCompanyName.Text = data.CompanyName;
tboPhone.Text = data.Phone;
}
}
catch (Exception ex)
{
//TODO: Log the exception
MessageBox.Show("Error: " + ex.Message, "Error Loading Form", MessageBoxButtons.OK);
}
}
private void btnAddShipper_Click(object sender, EventArgs e)
{
try
{
Shipper item = new Shipper()
{
CompanyName = tboCompanyName.Text,
Phone = tboPhone.Text
};
var mgr = new NorthwindManager();
item.ShipperID = mgr.AddShipper(item);
//Give some feedback to the user...
// - Update my combo-box
PopulateShippersComboBox();
// - My combo-box has the right shipper selected
cboShippers.SelectedValue = item.ShipperID;
// - Display the id fo the addd shipper
tboShipperID.Text = item.ShipperID.ToString();
}
catch (Exception ex)
{
//TODO: Log the exception
MessageBox.Show(ex.Message);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
int shipperId;
if (int.TryParse(lblShipperID.Text, out shipperId))
{
//do the delete...
var info = new Shipper()
{
ShipperID = shipperId
};
NorthwindManager mgr = new NorthwindManager();
mgr.DeleteShipper(info);
PopulateShippersComboBox();
cboShippers.SelectedItem = 0;
}
else
{
MessageBox.Show("Please select a shipper before clicking [Lookup Shipper]");
}
}
catch (Exception ex)
{
//TODO: Log the exception
MessageBox.Show("Error: " + ex.Message);
}
}
public ActionResult DetailsForOrder(int orderId)
{
NorthwindManager manager = new NorthwindManager(Settings.Default.ConStr);
IEnumerable <OrderDetail> details = manager.GetDetailsForOrder(orderId);
return(View(details));
}
public ActionResult SearchProducts(string searchText, int minPrice)
{
NorthwindManager mgr = new NorthwindManager(Properties.Settings.Default.ConStr);
IEnumerable <Product> products = mgr.SearchProducts(searchText, minPrice);
return(View(products));
}
public ActionResult OrdersForEmployee(int employeeId)
{
NorthwindManager mgr = new NorthwindManager(Properties.Settings.Default.ConStr);
IEnumerable <Order> orders = mgr.GetOrdersForEmployee(employeeId);
OrdersViewModel vm = new OrdersViewModel();
vm.Orders = orders;
vm.Date = DateTime.Now;
return(View(vm));
}
private void ViewRegions_Load(object sender, EventArgs e)
{
// Populate the comboBox
NorthwindManager manager = new NorthwindManager();
var data = manager.GetRegions();
cboRegions.DataSource = data;
cboRegions.DisplayMember = "RegionDescription";
cboRegions.ValueMember = "RegionID";
}
public ActionResult Orders()
{
NorthwindManager manager = new NorthwindManager(Settings.Default.ConStr);
OrdersWithDate ordersWithDate = new OrdersWithDate
{
Orders = manager.GetOrders(),
CurrentDate = DateTime.Now
};
return(View(ordersWithDate));
}
public ActionResult Products(int categoryId)
{
NorthwindManager mgr = new NorthwindManager(Properties.Settings.Default.ConStr);
IEnumerable <Product> products = mgr.GetProducts(categoryId);
ProductsViewModel vm = new ProductsViewModel();
vm.Products = products;
vm.CategoryName = mgr.GetCategoryName(categoryId);
return(View(vm));
}
public ActionResult Products(int catId)
{
NorthwindManager mgr = new NorthwindManager(Settings.Default.ConStr);
ProductsAndCatName obj = new ProductsAndCatName
{
Products = mgr.GetProductsForCategory(catId),
CategoryName = mgr.GetCategoryName(catId)
};
return(View(obj));
}
public ActionResult Search(string searchText)
{
NorthwindManager manager = new NorthwindManager(Settings.Default.ConStr);
IEnumerable <Product> products = manager.SearchProducts(searchText);
SearchResults results = new SearchResults
{
SearchText = searchText,
Products = products
};
return(View(results));
}
public ActionResult Products(int catId)
{
NorthwindManager manager = new NorthwindManager(Settings.Default.ConStr);
IEnumerable <Product> products = manager.GetProducts(catId);
ProductsAndCategoryName data = new ProductsAndCategoryName
{
Products = products,
CurrentCategoryName = manager.GetCategoryName(catId)
};
return(View(data));
}
public ActionResult Orders()
{
NorthwindManager mgr = new NorthwindManager(Settings.Default.ConStr);
IEnumerable <Order> orders = mgr.GetOrders();
OrdersAndDate obj = new OrdersAndDate
{
Orders = orders,
CurrentDate = DateTime.Now
};
return(View(obj));
}
private void ProductSalesForm_Load(object sender, EventArgs e)
{
List <ProductSaleSummary> list = new NorthwindManager().GetProductSalesSummeries();
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.ReportEmbeddedResource = "DesktopApp.Reports.ProductSalesReport.rdlc";
Microsoft.Reporting.WinForms.ReportDataSource dataset = new Microsoft.Reporting.WinForms.ReportDataSource("ProductSalesDataSet", list);
reportViewer1.LocalReport.DataSources.Add(dataset);
dataset.Value = list;
reportViewer1.LocalReport.Refresh();
this.reportViewer1.RefreshReport();
}
private void PopulateRegions()
{
try
{
var controller = new NorthwindManager();
var data = controller.GetRegions();
RegionListView.DataSource = data;
RegionListView.DataBind();
}
catch (Exception ex)
{
MessageLabel.Text = ex.Message;
}
}
public void Should_Update_Shipper(Shipper existing)
{
//arrange
existing.Phone = "780.999.9999";
var sut = new NorthwindManager();
//act
sut.UpdateShipper(existing);
//assert
var actual = sut.GetShipper(existing.ShipperID);
Assert.NotNull(actual);
Assert.Equal(existing.Phone, actual.Phone);
}
