public List <SupplierOrderDTO> GetSupplierOrdersDTO(int SupplierID)
{
List <SupplierOrderDTO> result = new List <SupplierOrderDTO>();
SupplierOrderDTO dto;
using (BadgerDataModel ctx = new BadgerDataModel())
{
// Get all the Suppliers Orders --
var pOrders = ctx.PurchaseOrder.Where(p => p.SupplierId == SupplierID).ToList();
foreach (var P in pOrders)
{
dto = new SupplierOrderDTO();
dto.PurchaserName = P.Employee.Lastname;
if (P.Job != null)
{
dto.JobName = P.Job.Jobname;
}
dto.OrderDate = P.OrderDate;
dto.OrderNum = P.OrderNum;
dto.Received = P.Recieved;
dto.SupplierName = P.Supplier.SupplierName;
dto.ReceiveStatus = "none";
result.Add(dto);
}
}
return(result);
}
public InventoryLookupItem(Inventory inventory, BadgerDataModel ctx)
{
if (inventory == null)
{
return;
}
_context = ctx;
jobService = new JobsService(_context);
orderService = new OrdersService(_context);
recieptService = new OrderRecieptService(_context);
employeeService = new EmployeeService(_context);
po = orderService.GetOrderByID(recieptService.GetOrderReciept
(inventory.OrderReceiptID.Value).OrderNum.Value);
job = jobService.Find(inventory.JobId.Value);
receipt = recieptService.GetOrderReciept(inventory.OrderReceiptID.Value);
emp = employeeService.Find(receipt.EmployeeId.Value);
orderNum = po.OrderNum.ToString();
orderDate = po.OrderDate.Value.ToShortDateString();
jobName = job.Jobname.ToString();
quantity = inventory.Qnty.ToString();
unitCost = "0.0";
itemDescription = inventory.Description;
supplierName = po.Supplier.SupplierName.ToString();
receivedDate = receipt.ReceiptDate.Value.ToShortDateString();
receivedBy = emp.Firstname + " " + emp.Lastname;
orderedBy = po.Employee.Firstname.ToString() + " " + po.Employee.Lastname.ToString();
}
public void SetContext(BadgerDataModel context)
{
ctx = context;
_partService = new PartsService(ctx);
tvPartTypes.AfterSelect += TvPartTypes_AfterSelect;
LoadTree();
}
public OrderEditControl()
{
InitializeComponent();
_context = new BadgerDataModel();
_orderService = new OrdersService(_context);
_partService = new PartsService(_context);
//disable AutoGenerate Columns on grids
dgOrderLineItem.AutoGenerateColumns = false;
dgOrderFees.AutoGenerateColumns = false;
dgAttachments.AutoGenerateColumns = false;
// Event wiring -------------------------------------------------------------------
dgOrderLineItem.DataError += DgOrderLineItem_DataError;
dgOrderLineItem.CellValidating += DgOrderLineItem_CellValidating;
dgOrderLineItem.CellEndEdit += DgOrderLineItem_CellEndEdit;
dgOrderLineItem.CellValueChanged += DgOrderLineItem_CellValueChanged;
bslineItems.ListChanged += BslineItems_ListChanged;
bsOrderFees.ListChanged += BsOrderFees_ListChanged;
bsAttachments.ListChanged += BsAttachments_ListChanged;
partFinderControl1.OnJobPartAdded += PartFinderControl1_OnJobPartAdded;
partFinderControl1.OnPartAdded += PartFinderControl1_OnPartAdded;
// Event Wiring -------------------------------------------------------------------
InitializeGrid();
btnSave.Enabled = _isDirty;
}
private void btnLogin_Click(object sender, EventArgs e)
{
string username = txtUserName.Text;
string password = txtPassWord.Text;
using (_context = new BadgerDataModel())
{
_employeeService = new EmployeeService(_context);
var user = _context.Employee.Where(c => c.Login == username).FirstOrDefault();
if (user != null)
{
if (password == user.Password)
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
isValidated = true;
this._employeeID = user.EmployeeId;
Globals.CurrentLoggedUserID = user.EmployeeId;
Globals.CurrentUserName = _employeeService.FullName(user.EmployeeId);
}
else
{
isValidated = false;
txtPassWord.Clear();
}
}
else
{
txtUserName.Clear();
txtPassWord.Clear();
txtUserName.Focus();
}
}
}
public NewOrderDialog(BadgerDataModel context)
{
InitializeComponent();
_context = context;
_jobService = new JobsService(_context);
_supplierService = new SuppliersService(context);
tbSupplier.Validated += TbSupplier_Validated;
tbJobSelection.Validated += TbJobSelection_Validated;
AutoCompleteStringCollection jobNames = new AutoCompleteStringCollection();
foreach (var item in _jobService.All())
{
jobNames.Add(item.JobName);
}
this.tbJobSelection.AutoCompleteMode = AutoCompleteMode.Suggest;
this.tbJobSelection.AutoCompleteSource = AutoCompleteSource.CustomSource;
tbJobSelection.AutoCompleteCustomSource = jobNames;
AutoCompleteStringCollection supplierNames = new AutoCompleteStringCollection();
foreach (var item in _supplierService.GetAll())
{
supplierNames.Add(item.SupplierName);
}
this.tbSupplier.AutoCompleteMode = AutoCompleteMode.Suggest;
this.tbSupplier.AutoCompleteSource = AutoCompleteSource.CustomSource;
tbSupplier.AutoCompleteCustomSource = supplierNames;
CheckState();
}
public OrderEditSplitPanelControl(BadgerDataModel context, BindingSource BSorder)
{
InitializeComponent();
ctx = context;
orderDTO = (OrderDetailDto)BSorder.DataSource;
this.orderHeaderVerticalControl1.OnSaveHandler += OrderHeaderVerticalControl1_OnSaveHandler;
this.orderHeaderVerticalControl1.OnPrintHandler += OrderHeaderVerticalControl1_OnPrintHandler;
}
public OrderReceiptControl(OrderReciept receipt, BadgerDataModel ctx)
{
InitializeComponent();
this._context = ctx;
_receipt = receipt;
jService = new JobsService(ctx);
oService = new OrdersService(ctx);
}
public SupplierEditForm(int supplierID)
{
InitializeComponent();
ctx = new BadgerDataModel();
_supplierService = new SuppliersService(ctx);
_supplierToEdit = _supplierService.Find(supplierID);
BindText();
}
public PartEditor(BadgerDataModel ctx)
{
InitializeComponent();
dgPartsList.AutoGenerateColumns = false;
_context = ctx;
partsService = new PartsService(_context);
labelService = new LabelService();
dgResources.AutoGenerateColumns = false;
}
public AssemblyManagerControl(BadgerDataModel context)
{
InitializeComponent();
_context = context;
productionRepository = new ProductionRepository(_context);
jobsService = new JobsService(_context);
// testing only
_selectedJob = jobsService.Find(1172);
}
public Main()
{
InitializeComponent();
// This should be the main contect wireup for everything else
_context = new BadgerDataModel();
_ordersService = new OrdersService(_context);
MainTabs = MainTabControl;
Mediator.GetInstance().OrderOpen += Main_OrderOpen;
}
public OrderManager(BadgerDataModel context)
{
InitializeComponent();
ctx = context;
ordersService = new OrdersService(ctx);
supplierService = new SuppliersService(ctx);
jobsService = new JobsService(ctx);
dgOrders.AutoGenerateColumns = false;
}
//BindingSource BSorder = new BindingSource();
//OrderDetailDto orderDTO = new OrderDetailDto();
//OrdersService _orderService;
public Harness()
{
InitializeComponent();
ctx = new BadgerDataModel();
PartResourceEditorControl ctr = new PartResourceEditorControl();
this.Controls.Add(ctr);
ctr.SetDataSource(ctx, 7991);
}
public void Get_All_Job_list()
{
var ctx = new BadgerDataModel();
JobsService service = new JobsService(ctx);
var jobs = service.All();
Assert.IsTrue(jobs.Count > 100);
}
//cTor
public ClaimControl(int claimID, BadgerDataModel context)
{
InitializeComponent();
_ctx = context;
_claimService = new ClaimService(_ctx);
_employeeService = new EmployeeService(_ctx);
_claim = _claimService.Find(claimID);
bsClaimBindingSource.DataSource = _claim;
///TODO need claim child navigation added to claim class
// bsClaimItemBindingSource.DataSource = _claim.ClaimItems;
}
public JobOrdersControl(BadgerDataModel ctx)
{
InitializeComponent();
_context = ctx;
dgJobOrders.AutoGenerateColumns = false;
dgJobOrderItems.AutoGenerateColumns = false;
_jobService = new JobsService(_context);
_lineService = new LineItemsService(_context);
// Use last entered search term ---
txtJobNameSearch.Text = (InventoryFerret.Properties.Settings.Default.LastJobSearch != String.Empty)?
Properties.Settings.Default.LastJobSearch : string.Empty;
}
public DataForm()
{
InitializeComponent();
ctx = new BadgerDataModel();
_selectedMeasure = new UnitOfMeasure {
UID = 1, Uom = "Each"
};
_partService = new PartsService(ctx);
_ordersService = new OrdersService(ctx);
bsLineItems = new BindingSource();
this.Size = new Size(800, 450);
}
public MyOrdersControl(BadgerDataModel context, int employeeID)
{
InitializeComponent();
ctx = context;
_employeeID = employeeID;
_ordersService = new OrdersService(ctx);
_employeeService = new EmployeeService(ctx);
//---
dgMyOrdersGrid.AutoGenerateColumns = false;
//---
dgMyOrdersGrid.CellFormatting += DgMyOrdersGrid_CellFormatting;
}
/// <summary>
/// TODO use PartID and DTO to hydrate the control
/// </summary>
/// <param name="part"></param>
/// <param name="ctx"></param>
public PartView(Part part, BadgerDataModel ctx)
{
InitializeComponent();
_context = ctx;
ISuppliersService var = new SuppliersService(_context);
inventoryService = new InventoryService(_context);
partsService = new PartsService(_context);
this.dataGridView1.AutoGenerateColumns = false;
this.dgvTransactions.AutoGenerateColumns = false;
if (part.PartID > 0)
{
_part = partsService.Find(part.PartID);
}
else
{
_part = partsService.New();
_part.AddedBy = Globals.CurrentUserName;
_part.DateAdded = DateTime.Today;
}
cboSuppliers.DisplayMember = "SupplierName";
cboSuppliers.ValueMember = "SupplierID";
cboSuppliers.SelectedItem = _part.SupplierId;
cboSuppliers.DataSource = var.GetAll();
cboUnits.DisplayMember = "UOM";
cboUnits.ValueMember = "UID";
cboUnits.SelectedItem = _part.UID;
cboUnits.DataSource = partsService.Units();
cboManus.DisplayMember = "Manufacturer";
cboManus.ValueMember = "ManuID";
cboManus.SelectedItem = _part.ManuId;
cboManus.DataSource = partsService.Manufacturers();
bsPart.DataSource = _part;
// This triggers the Save Button On changed--
bsPart.CurrentItemChanged += BsPart_CurrentItemChanged;
this.btnSave.Enabled = _isDirty;
this.txtSupplierDesc.Enabled = false;
_documents = _context.Document.Where(r => r.PartID == _part.PartID).ToList();
// _documents = _part.Document.ToList();
bsDocuments.DataSource = _documents;
this.dataGridView1.DataSource = bsDocuments;
LoadTransaction();
this.rbRecieved.Checked = true;
}
public OrderReceiptsControl(BadgerDataModel Context)
{
InitializeComponent();
dgRecieptItems.AutoGenerateColumns = false;
context = Context;
ordersService = new OrderRecieptService(context);
suppliersService = new SuppliersService(context);
jobsService = new JobsService(context);
inventoryService = new InventoryService(context);
poService = new OrdersService(context);
empService = new EmployeeService(context);
}
public ClaimDetailControl(BadgerDataModel context)
{
InitializeComponent();
_ctx = context;
supService = new SuppliersService(_ctx);
ordersService = new OrdersService(_ctx);
claimService = new ClaimService(_ctx);
dgSupplierOrders.AutoGenerateColumns = false;
bsLineItems.DataSource = supplierOrders;
dgSupplierOrders.DataSource = bsLineItems;
dgSupplierClaims.AutoGenerateColumns = false;
tbSupplierSearch.Text = Properties.Settings.Default.LastSupplierSearch;
}
public static void RecieveOrder(PurchaseOrder order, BadgerDataModel ctx)
{
OrderReciept receipt = new OrderReciept();
receipt.OrderNum = order.OrderNum;
receipt.ReceiptDate = DateTime.Today;
receipt.EmployeeId = 8;
ctx.OrderReciept.Add(receipt);
ctx.SaveChanges();
foreach (PurchaseLineItem item in order.PurchaseLineItem)
{
Inventory inv = new Inventory();
inv.OrderReceiptID = receipt.OrderReceiptId;
inv.LineID = item.LineID;
if (item.PartID.HasValue)
{
inv.PartID = item.PartID.Value;
}
inv.JobId = item.PurchaseOrderId.Value;
inv.DateStamp = DateTime.Today;
if (item.AmountReceived.HasValue)
{
inv.Qnty = item.AmountReceived.Value;
}
//inv.Note = item.N
inv.Description = item.Description.ToString();
if (inv.UnitOfMeasure.HasValue)
{
inv.UnitOfMeasure = item.Uom;
}
receipt.Inventory.Add(inv);
}
order.Recieved = true;
order.RecievedDate = DateTime.Today;
ctx.SaveChanges();
//// Push the new Order Receipt to The New Tab
//MainFrm f = (MainFrm)Application.OpenForms["MainFrm"];
//TabControl.TabPageCollection col = f.tabMain.TabPages;
//TabPage orderReceiptPage = new TabPage();
//orderReceiptPage.Text = "Order Receipt -> " + receipt.OrderReceiptID.ToString();
//OrderReceiptControl control = new OrderReceiptControl(receipt,ctx);
//control.Dock = DockStyle.Fill;
//orderReceiptPage.Controls.Add(control);
//col.Add(orderReceiptPage);
//f.tabMain.SelectedTab = orderReceiptPage;
}
public void Orders_OrdersFee_ShouldSaveNewOrderFee()
{
var ctx = new BadgerDataModel();
OrderFee orderFee = new OrderFee();
//orderFee.PurchaseOrderID = 23415;
orderFee.FeeName = "Big Fat Fee";
orderFee.Cost = 1.25m;
orderFee.Qnty = 5.0m;
orderFee.Extension = decimal.Add(orderFee.Cost.Value, orderFee.Qnty.Value);
ctx.OrderFee.Add(orderFee);
ctx.SaveChanges();
Assert.IsTrue(orderFee.OrderfeeID != default);
}
private void Main_Load(object sender, EventArgs e)
{
closeImage = Properties.Resources.baseline_close_black_18dp;
MainTabs.Padding = new System.Drawing.Point(26, 4);
this.toolStripStatusLabel1.Text = "UserID=" + _loggedOnUserID.ToString();
_context = new BadgerDataModel();
var emp = _context.Employee.Where(p => p.EmployeeId == LoggedOnUserID).FirstOrDefault();
this.toolStripStatusLabel1.Text = "User= "******" " + emp.Lastname;
TabPage myOrdersTab = PageFactory.GetNewTabPage(_context, PageFactory.TabPageType.MyOrdersPage);
myOrdersTab.Name = "myOrdersTab";
MainTabControl.TabPages.Add(myOrdersTab);
}
public void SetDataSource(BadgerDataModel context, int partID)
{
ctx = context;
partService = new PartsService(ctx);
units = partService.Units();
// Load the Unit Combo ----
cboUnitOfMeasure.DisplayMember = "Uom";
cboUnitOfMeasure.ValueMember = "UID";
cboUnitOfMeasure.DataSource = units;
loadData(7991);
bsPart.ListChanged += BsPart_ListChanged;
bsResources.ListChanged += BsResources_ListChanged;
BindPart();
}
// Main preferred control datasource --
public void SetDataSource(BadgerDataModel context, int orderID)
{
// reference the context object
ctx = context;
// create a new DTO to hold the order
orderDTO = new OrderDetailDto();
_orderService = new OrdersService(ctx);
// Init the mapper
// Retrieve to PurchaseOrder Entity
_purchaseOrder = _orderService.GetOrderByID(orderID);
if (_purchaseOrder != null)
{
// Map to the DTO detached data transfer object
mapper.Map(_purchaseOrder, orderDTO);
// wire a BindingSource for the order binding
bsOrder.DataSource = orderDTO;
// Bind line items to the grid
bsLineitems.DataSource = orderDTO.LineItems;
BindLineItemsToGrid(bsLineitems);
bsOrderFees.DataSource = orderDTO.OrderFees;
bsAttachments.DataSource = orderDTO.Attachments;
}
// Event wiring -------------------------------------------------------------------
// dgOrderLineItem.DataError += DgOrderLineItem_DataError;
dgOrderLineItem.CellValidating += DgOrderLineItem_CellValidating;
dgOrderLineItem.CellEndEdit += DgOrderLineItem_CellEndEdit;
dgOrderLineItem.CellValueChanged += DgOrderLineItem_CellValueChanged;
bsLineitems.ListChanged += BslineItems_ListChanged;
bsOrder.ListChanged += BsOrder_ListChanged;
bsOrderFees.ListChanged += BsOrderFees_ListChanged;;
bsAttachments.ListChanged += BsAttachments_ListChanged;
// Event Wiring -------------------------------------------------------------------
// start with the PartFinder
// partFinderControl
// .LoadDatasource(ctx, orderDTO.SupplierID);
orderHeaderVerticalControl1.LoadDataSource(bsOrder);
}
public void Resource_Add_ResourceVersion()
{
var ctx = new BadgerDataModel();
ResourceVersion _version = new ResourceVersion();
_version.ResourceID = 5;
_version.RVersion = 1;
_version.VersionComment = "Revised for some reason";
_version.ModifiedBy = "dick";
_version.ModDate = DateTime.Today;
ctx.ResourceVersion.Add(_version);
ctx.SaveChanges();
Assert.IsTrue(_version.ResourceVersionID != default);
}
private void OpenPartDetails(int PartID, BadgerDataModel ctx)
{
if (PartID != 0)
{
Main main = (Main)Application.OpenForms["Main"];
var tabs = main.MainTabControl.TabPages;
TabPage newPage = PageFactory.GetNewTabPage(_context, PageFactory.TabPageType.PartDetailEdit, PartID);
tabs.Add(newPage);
main.MainTabControl.SelectTab(newPage);
}
//The part is new/added
else
{
Main main = (Main)Application.OpenForms["Main"];
var tabs = main.MainTabControl.TabPages;
TabPage newPage = PageFactory.GetNewTabPage(_context, PageFactory.TabPageType.PartDetailEdit, PartID);
tabs.Add(newPage);
main.MainTabControl.SelectTab(newPage);
}
}
/// <summary>
/// Create a new Claim Document
/// </summary>
/// <param name="OrderNum"></param>
/// <returns>Claim</returns>
public Claim NewClaim(int OrderNum, int Employee)
{
Claim _claim = null;
if (OrderNum > 0)
{
_claim = new Claim();
_claim.ClaimDate = DateTime.Today;
_claim.OrderNum = OrderNum;
_claim.EmployeeId = Employee;
using (_ctx = new BadgerDataModel())
{
var po = _ctx.PurchaseOrder.Where(p => p.OrderNum == OrderNum).First();
_claim.SupplierId = po.SupplierId.Value;
_ctx.Claim.Add(_claim);
_ctx.SaveChanges();
int claimID = _claim.ClaimId;
var lineitem = po.PurchaseLineItem.ToList();
foreach (PurchaseLineItem l in lineitem)
{
ClaimItem cItem = new ClaimItem();
cItem.ClaimId = claimID;
cItem.LineID = l.LineID;
cItem.PartID = l.PartID;
cItem.Bcode = l.Bcode;
cItem.Description = l.Description;
cItem.TransActionType = 1;
_ctx.ClaimItem.Add(cItem);
}
_ctx.SaveChanges();
}
}
return(_claim);
}
