private void VendorForm_Load(object sender, EventArgs e)
{
VendorBindingList vendorList = new VendorBindingList();
ContactBindingList contactList = new ContactBindingList();
contactList.AddNew();
using (Ambient.DbSession.Activate())
{
vendorList.Add(OrderingRepositories.Vendor.GetAll());
contactList.Add(OrderingRepositories.Contact.GetAll());
}
mHelper.AddAllColumns(contactList);
mHelper.DataSource = vendorList;
}
private void LoadOrders()
{
PurOrderBindingList orderList = new PurOrderBindingList();
VendorBindingList vendorList = new VendorBindingList();
DateTime startDate;
if (!DateTime.TryParse(txtStartDate.Text, out startDate))
{
MessageBox.Show("Invalid start date.");
return;
}
DateTime endDate;
if (!DateTime.TryParse(txtEndDate.Text, out endDate))
{
MessageBox.Show("Invalid end date.");
return;
}
if (startDate > endDate)
{
MessageBox.Show("Start date may not be after end date.");
return;
}
Vendor searchVendor = (Vendor)cboVendor.SelectedItem;
using (Ambient.DbSession.Activate())
{
List <PurOrder> orders = OrderingRepositories.PurOrder.Get(startDate, endDate);
foreach (PurOrder order in orders)
{
if (searchVendor.Id.IsNull)
{
orderList.Add(order);
}
else if (searchVendor.Id == order.VendorId)
{
orderList.Add(order);
}
}
vendorList.AddNew();
vendorList.Add(mVendors);
}
mHelper.AddAllColumns(vendorList);
mHelper.DataSource = orderList;
}
public void AddAllColumns(VendorBindingList vendorList)
{
mVendorIdCol = AddComboBoxColumn("VendorId", "Vendor", 14, false, vendorList, "VendorName", "Id");
mVendorIdCol.Frozen = true;
mOrderDateCol = AddDateColumn("OrderDate", "Order Date", 6, false);
mOrderDateCol.Frozen = true;
AddTextBoxColumn("OrderNumber", "Order Number", 8, false).Frozen = true;
mSubmitDateCol = AddDateColumn("SubmitDate", "Submit Date", 6, false);
mShipDateCol = AddDateColumn("ShipDate", "Ship Date", 6, false);
AddTextBoxColumn("CreatedBy", "Created By", 7, false);
mDiscountCol = AddIntegerColumn("Discount", "Disc%", 4, false);
mFreightCol = AddCurrencyColumn("Freight", "Freight", 6, false);
AddTextBoxColumn("InvoiceNumber", "Invoice Number", 8, false);
AddTextBoxColumn("Terms", "Terms", 7, false);
AddCheckBoxColumn("Imported", "Imported", 4, false);
AddTextBoxColumn("Notes", "Notes", 30, false).DefaultCellStyle.WrapMode = DataGridViewTriState.True;
AddTextBoxColumn("Id", "ID", 5, true);
AddTextBoxColumn("CreateDate", "Created", 10, true);
AddTextBoxColumn("ModifyDate", "Modified", 10, true);
}
