private void btnPrintSelectedItemsLabels_Click(object sender, EventArgs e) { DataGridView dg = dgOrderItems; if (dgOrderItems.DataSource != null) { if (dgOrderItems.RowCount > 0) { PurchaseLineItem lineItem = (PurchaseLineItem)dg.CurrentRow.DataBoundItem; if (lineItem != null) { int id = lineItem.JobId.Value; Job job = jobService.Find(id); string JobName = job.Jobname; string revdate = lineItem.PurchaseOrder.RecievedDate?.ToShortDateString() ?? "---NA---"; string orderNum = lineItem.PurchaseOrderId?.ToString() ?? "---NA---"; string receiver = lineItem.PurchaseOrder.Employee?.Lastname ?? "---NA---"; ThermalLabel label = labelService.GenerateInventoryDetailLabel(lineItem.LineID.ToString(), JobName, orderNum, receiver, revdate); labelService.PrintLabel(label, int.Parse(this.numericUpDownCopies.Value.ToString())); } } } }
private void dgOrderItems_SelectionChanged(object sender, EventArgs e) { DataGridView dg = (DataGridView)sender; if (dgOrderItems.DataSource != null) { if (dgOrderItems.RowCount > 0) { txtItemNotes.DataBindings.Clear(); PurchaseLineItem lineItem = (PurchaseLineItem)dg.CurrentRow.DataBoundItem; if (lineItem != null) { txtItemNotes.DataBindings.Add("Text", lineItem, "Note"); label4.Text = String.Format("Order Number : {0}", lineItem.PurchaseOrderId.Value); if (lineItem.PurchaseOrder.JobId.HasValue) { txtJobName.Text = lineItem.PurchaseOrder.Job?.Jobname ?? "Error"; } else { txtJobName.Text = "***Job Assignment Error***"; } txtPurchaser.Text = lineItem.PurchaseOrder.Employee.Firstname + " " + lineItem.PurchaseOrder.Employee.Lastname; txtOrderDate.Text = lineItem.PurchaseOrder.OrderDate.Value.ToShortDateString(); _selectedLineItem = lineItem; } } } }
private void dgOrderItems_CellClick(object sender, DataGridViewCellEventArgs e) { var dg = (DataGridView)sender; if (dg.DataSource != null) { if (dg.RowCount > 0) { PurchaseLineItem lineItem = (PurchaseLineItem)dg.CurrentRow.DataBoundItem; if (e.ColumnIndex == 1) { if (lineItem.PartID > 0) { PartForm partForm = new PartForm(); if (lineItem != null) { var part = partsService.Find(lineItem.PartID.Value); PartView partView = new PartView(part, _context); partForm.Controls.Add(partView); partView.Dock = DockStyle.Fill; partForm.Show(); } } } } } }
/// <summary> /// Initializes a new instance of the <see cref="PurchaseLineItemWithOffer"/> class. /// </summary> /// <param name="purchaseLineItem">The purchase line item.</param> /// <param name="partnerOffer">The partner offer.</param> public PurchaseLineItemWithOffer(PurchaseLineItem purchaseLineItem, PartnerOffer partnerOffer) { purchaseLineItem.AssertNotNull(nameof(purchaseLineItem)); partnerOffer.AssertNotNull(nameof(partnerOffer)); this.PurchaseLineItem = purchaseLineItem; this.PartnerOffer = partnerOffer; }
public static bool ForceSerialFormatFor(PurchaseOrder order, Part part) { PurchaseLineItem pli = OrderRepository.GetPurchaseLineItemFor(order, part); if (pli == null) { return(false); } return(pli.ForceSerialFormat); }
public InventoryItem MapFrom(Receipt input) { InventoryItem item = InventoryRepository.GetItemById(input.Session, input.UnitTrackingId); if (item == null) { item = Scout.Core.Data.CreateEntity <InventoryItem>(input.Session); } item.Part = input.Part; item.LotId = input.UnitTrackingId; item.Qty = input.Qty; item.Grade = input.Grade; item.Tote = input.ReceivingCart; item.RoutingRequired = input.RoutingRequired; item.CustomFields = input.CustomFields; item.SerialNumber = input.SerialNumber; item.ShopfloorProgram = input.PurchaseOrder.Program; // Copy the program into the receipt record for archival purposes input.Program = item.ShopfloorProgram; // Map the receive location to the line item spec PurchaseLineItem lineItem = input.PurchaseOrder.LineItemByPart(item.Part); if (lineItem != null && lineItem.ReceiveDomain != null) { item.Site = lineItem.ReceiveDomain.Parent.Parent; item.Shopfloorline = lineItem.ReceiveDomain.Parent; if (item.Tote != null) { item.Tote.Domain = lineItem.ReceiveDomain; } item.ChangeDomain(lineItem.ReceiveDomain); } // If a line item spec is not defined use the order spec else { item.Site = input.PurchaseOrder.RecDomain.Parent.Parent; item.Shopfloorline = input.PurchaseOrder.RecDomain.Parent; if (item.Tote != null) { item.Tote.Domain = input.PurchaseOrder.RecDomain; } item.ChangeDomain(input.PurchaseOrder.RecDomain); } return(item); }
void routeSelList_ButtonClick(object sender, ButtonPressedEventArgs e) { if (e.Button.Kind == ButtonPredefines.Undo) { PurchaseLineItem item = lineItemsView.GetFocusedRow() as PurchaseLineItem; if (item != null) { item.ServiceRoute = null; } } }
private void LoadPartEditor() { PurchaseLineItem lineItem = lineItemsView.GetFocusedRow() as PurchaseLineItem; if (lineItem != null) { if (lineItem.Part != null) { PartEditForm form = new PartEditForm(lineItem.Part); form.ShowDialog(); } } }
private void ProcessRouting(PurchaseLineItem lineItem, InventoryItem inventoryItem) { if (lineItem == null) { return; } // Get the post receipt service route from the line item if it exists if (lineItem.ServiceRoute != null && inventoryItem.SerialNumber != "NON SERIALIZED") { Scout.Core.Service <IShopfloorService>() .StageUnitAtFirstStation(lineItem.ServiceRoute, inventoryItem); } }
private void view_SelectionChanged(object sender, EventArgs e) { DataGridView dg = (DataGridView)sender; if (dg.DataSource != null) { if (dg.RowCount > 0) { if (dg.CurrentRow.DataBoundItem != null) { _selectedPurchaseLineItem = ((PurchaseLineItemWrapper)dg.CurrentRow.DataBoundItem).Model; } } } }
public void NewPurchaseOrder() { EditPurchaseOrder = new PurchaseOrder(); MobileModel.EditMobile = new Mobile(); MobileModel.SelectedCategory = MobileModel.EditMobile.Category; MobileModel.SelectedBrand = MobileModel.EditMobile.Brand; MobileModel.SelectedVendor = MobileModel.EditMobile.Vendor; MobileModel.SelectedPhoneType = MobileModel.SelectedPhoneType; MobileModel.SelectedCondition = MobileModel.SelectedCondition; PurchaseLineItem = new PurchaseLineItem(); CanEditPurchaseOrder = true; CanAddPurchaseOrder = false; PurchaseLineItems = new BindableCollection <PurchaseLineItem>(_context.PurchaseLineItems.GetAllItems()); }
private void On_JobPartClicked(object sender, EventArgs e) { PurchaseLineItem newItem = new PurchaseLineItem { LineID = 1102, Qnty = 0.0m, PartID = 0, UnitCost = 0.0m, Extended = decimal.Zero, Description = String.Empty }; PurchaseLineItemWrapper wrap = new PurchaseLineItemWrapper(newItem); bsLineItems.Add(wrap); bsLineItems.EndEdit(); }
private void btnAddToOrder_Click(object sender, EventArgs e) { if (_selectedPart != null) { PurchaseLineItem newItem = new PurchaseLineItem { LineID = 1102, PartID = _selectedPart.PartID, PurchaseOrderId = _po.OrderNum, Qnty = 0.0m, VendorId = _supplier.SupplierId, UnitCost = _selectedPart.Cost.GetValueOrDefault(), Extended = decimal.Zero, Description = _selectedPart.ItemDescription }; PurchaseLineItemWrapper wrap = new PurchaseLineItemWrapper(newItem); bsLineItems.Add(wrap); bsLineItems.EndEdit(); } }
public static int GetReceiveQtyForLine(PurchaseLineItem lineItem) { ReceivingLineSummary partSummary; try { partSummary = OrderRepository.GetReceivingLineSummary(lineItem); } catch (Exception ex) { return(0); } if (partSummary == null) { return(0); } return(partSummary.Qty); }
private void AddPartbyNumber(Part part) { if (part != null) { var newLine = new PurchaseLineItem { Description = part.ItemDescription, PartID = part.PartID, UnitCost = part.Cost, Uom = part.UID, Qnty = 1.0m, Extended = 0.0m, AmountReceived = 0.0m, PurchaseOrderId = 5000 }; ctx.Entry(newLine).State = Microsoft.EntityFrameworkCore.EntityState.Added; var addLine = new PurchaseLineItemWrapper(newLine); bsLineItems.Add(addLine); _isDirty = true; btnSave.Enabled = _isDirty; } }
private void btnRemove_Click(object sender, EventArgs e) { if (view.DataSource != null) { if (view.Rows.Count > 0) { foreach (DataGridViewRow row in view.SelectedRows) { if (row.DataBoundItem != null) { PurchaseLineItem line = ((PurchaseLineItemWrapper)row.DataBoundItem).Model; if (line.LineID != default(int)) { _ctx.PurchaseLineItem.Remove(line); } SaveChanges(); } } } } }
public static PartIdentType GetReceivingIdentTypeFor(PurchaseOrder order, Part part) { PartIdentType partIdentType; if (order.LineItems.Count > 0) { PurchaseLineItem purchaseLineItem = order.LineItemByPart(part); if (purchaseLineItem != null) { partIdentType = purchaseLineItem.IdentType; } else { partIdentType = part.IdentType; } } else { partIdentType = part.IdentType; } return(partIdentType); }
public OutgoingPartAssignment(PurchaseLineItem lineItem, Part outgoingPart) { m_lineItem = lineItem; m_outgoingPart = outgoingPart; }
public static void Initialize(ApplicationDbContext context) { context.Database.EnsureCreated(); if (!context.Categories.Any()) { var categories = new Category[] { new Category { Name = "Beverages", Description = "coffee/tea, juice, soda" }, new Category { Name = "Bread/Bakery", Description = "sandwich loaves, dinner rolls, tortillas, bagels" }, new Category { Name = "Dairy", Description = "cheeses, eggs, milk, yogurt, butter" }, new Category { Name = "Dry/Baking Goods", Description = "cereals, flour, sugar, pasta, mixes" }, new Category { Name = "Frozen Foods", Description = "waffles, vegetables, individual meals, ice cream" }, new Category { Name = "Meat", Description = "lunch meat, poultry, beef, pork" }, new Category { Name = "Produce", Description = "fruits, vegetables" }, new Category { Name = "Cleaners", Description = "laundry detergent, dishwashing liquid/detergent" }, new Category { Name = "Paper Goods", Description = "paper towels, toilet paper, aluminum foil, sandwich bags" }, new Category { Name = "Personal Care", Description = "shampoo, soap, hand soap, shaving cream" }, new Category { Name = "Other", Description = "baby items, pet items, batteries, greeting cards" }, }; foreach (Category c in categories) { context.Categories.Add(c); } context.SaveChanges(); } if (!context.Products.Any()) { var products = new Product[] { new Product { Name = "Nescafe Gold Coffee-50gm", Description = "Nescafe Gold is a blend of mountain grown Arabica and Robusta beans.", Price = 450.00m, CategoryId = 1 }, new Product { Name = "Himalayan Java Coffee - Thamel Roast, 250 gms", Description = "Himalayan Java Coffee", Price = 825.00m, CategoryId = 1 }, new Product { Name = "Himalayan Java Coffee - Medium Roast, 450 gms", Description = "Himalayan Java Coffee", Price = 1400.00m, CategoryId = 1 }, new Product { Name = "Nescafe Gold Coffee - 100gm", Description = "Premium, imported, freeze dried soluble coffee powder.", Price = 780.00m, CategoryId = 1 }, new Product { Name = "Somersby Apple Cider Bottle 250ML", Description = "Somersby is Carlsberg Group's biggest selling cider", Price = 165.00m, CategoryId = 1 }, new Product { Name = "Rakura Supreme CTC Tea, 500gm", Description = "Rakura Tea", Price = 295.00m, CategoryId = 1 }, new Product { Name = "Tokla Tea Bags - 100 Packets", Description = "Tokla Tea", Price = 165.00m, CategoryId = 1 }, new Product { Name = "Trisara Bakery Soup Stick Bread, 15 piece", Description = "Bread sticks are commonly served with soups", Price = 75.00m, CategoryId = 2 }, new Product { Name = "European Bakery Brown Bread", Description = "", Price = 140.00m, CategoryId = 2 }, new Product { Name = "Nanglo Brown Bread - 500 gm", Description = "Brown Bread", Price = 88.00m, CategoryId = 2 }, new Product { Name = "Nanglo Croissant - 300gm (5Pcs)", Description = "", Price = 90.00m, CategoryId = 2 }, new Product { Name = "Trisara Bakery Mini Chocolate Doughnut, 4piece", Description = "Small portions of chocolate or cocoa is beneficial for heart health.", Price = 130.00m, CategoryId = 2 }, new Product { Name = "Amul Butter-200gm", Description = "Spread on Bread, Parantha, Roti, Nans, Sandwiches", Price = 255.00m, CategoryId = 3 }, new Product { Name = "Amul Butter-500gm", Description = "Spread on Bread, Parantha, Roti, Nans, Sandwiches", Price = 620.00m, CategoryId = 3 }, new Product { Name = "Vegan Dairy Pumpkin Seed Butter, 200ml", Description = "Pumpkin seed butter is a great source of zinc and magnesium", Price = 600.00m, CategoryId = 3 }, new Product { Name = "Ferments Almond Butter, 190gm", Description = "Almond butter is high in monounsaturated fats.", Price = 775.00m, CategoryId = 3 }, new Product { Name = "DDC Yak Cheese - 500 gm", Description = "Local DDC Cheese", Price = 845.00m, CategoryId = 3 }, new Product { Name = "Amul Yummy Plain Cheese Spreed, 200gm", Description = "Amul Cheese Spread - Yummy Plain is a good supply of calcium and milk proteins.", Price = 175.00m, CategoryId = 3 }, new Product { Name = "Weikfield Baking Soda, 100gm", Description = "Baking soda is a magical ingredient which works wonderfully with a batter of khaman, dhokla or idli.", Price = 52.00m, CategoryId = 4 }, new Product { Name = "Blue Cow Condensed Milk - 390 gms", Description = "Bluecow Condened Milk is an establish brand in Nepal used by the top bakeries and hotels", Price = 190.00m, CategoryId = 4 }, new Product { Name = "Kent Syrup Caramel, 624 gm", Description = "", Price = 390.00m, CategoryId = 4 }, new Product { Name = "Weikfield Cocoa Powder, 50gm", Description = "Makes delicious and flavourful chocolate sauces, cakes and other chocolate desserts", Price = 109.00m, CategoryId = 4 }, new Product { Name = "American Garden Strawberry Syrup-680gm", Description = "Our strawberry syrup adds a hint of sweetness and freshness when drizzled over any dessert!", Price = 575.00m, CategoryId = 4 }, new Product { Name = "Morde Compound White - 500 gms", Description = "Morde White Compound is a vegetable fat based chocolate", Price = 398.00m, CategoryId = 4 }, new Product { Name = "McCain French Fries, Favorita 9mm-2.5kg", Description = "McCain offers this pack of frozen French fries", Price = 935.00m, CategoryId = 5 }, new Product { Name = "McCain Smiles-415gm", Description = "McCain Smiles are appetizing delicacies that are made up of mashed potatoes", Price = 297.00m, CategoryId = 5 }, new Product { Name = "Golden Fresh Ready To Cook Veg Momo-40Pc", Description = "Frozen Momo", Price = 400.00m, CategoryId = 5 }, new Product { Name = "European Bakery Veg Momo - 10 Pcs", Description = "Frozen Momo", Price = 180.00m, CategoryId = 5 }, new Product { Name = "McCain Super Wedges-400gm", Description = "McCain Super Wedges are crispy coated potatoes", Price = 297.00m, CategoryId = 5 }, new Product { Name = "Norsk Sjomat Norwegian Smoked Salmon, 200 g", Description = "", Price = 1550.00m, CategoryId = 6 }, new Product { Name = "Urban Food Medium Prawns - 500 gms", Description = "", Price = 1000.00m, CategoryId = 6 }, new Product { Name = "Nina & Hager Frozen Trout - Per KG", Description = "", Price = 1400.00m, CategoryId = 6 }, new Product { Name = "Golden Fresh Prawn 16/20 ,1kg", Description = "", Price = 2100.00m, CategoryId = 6 }, new Product { Name = "Gourmet Vienna Pork Ribs- Per Kg", Description = "", Price = 1080.00m, CategoryId = 6 }, new Product { Name = "Gourmet Vienna Pork Slice-200gm", Description = "", Price = 310.00m, CategoryId = 6 }, new Product { Name = "Kiwi, 1kg", Description = "", Price = 680.00m, CategoryId = 7 }, new Product { Name = "Apple ( Fuzi ), 1kg", Description = "", Price = 280.00m, CategoryId = 7 }, new Product { Name = "Avocado, 1kg", Description = "Avocados are oval shaped fruits with a thick green and a bumpy, leathery outer skin.", Price = 520.00m, CategoryId = 7 }, new Product { Name = "Pomegranate, 1kg", Description = "", Price = 360.00m, CategoryId = 7 }, new Product { Name = "Green Apple, 1kg", Description = "", Price = 520.00m, CategoryId = 7 }, new Product { Name = "Mousam, 1kg", Description = "", Price = 220.00m, CategoryId = 7 }, new Product { Name = "Guava, 1kg", Description = "", Price = 130.00m, CategoryId = 7 }, new Product { Name = "American Strawberry, 500gm", Description = "", Price = 600.00m, CategoryId = 7 }, new Product { Name = "Comfort Fabric Conditioner (Sense of Pleasure)-2ltr", Description = "", Price = 890.00m, CategoryId = 8 }, new Product { Name = "Comfort Fabric Conditioner(Touch of Love)-2ltr", Description = "Comfort Fabric Conditioner keep your clothes from wearing out too soon.", Price = 850.00m, CategoryId = 8 }, new Product { Name = "Tide Bar, 250gm (Pack of 3)", Description = "New Tide + with Extra Power detergent, now with the added Power of Bar", Price = 105.00m, CategoryId = 8 }, new Product { Name = "Surf Excel Stain Eraser Bar - 250 g", Description = "Removes tough stains such as tea, coffee, turmeric, curry, ketchup", Price = 47.00m, CategoryId = 8 }, new Product { Name = "Surf Excel Matic Top Load Detergent Powder, 1 kg", Description = "Tough stain removal in machine with Surf excel matic", Price = 360.00m, CategoryId = 8 }, new Product { Name = "Ariel Matic Front Load, 1kg", Description = "Best used for front load fully automatic washing machines", Price = 400.00m, CategoryId = 8 }, new Product { Name = "Paseo Toilet Roll 200's 4Ply Dolphin- 10rolls", Description = "", Price = 870.00m, CategoryId = 9 }, new Product { Name = "Paseo Elegant Toilet Roll 280's, 3Ply-4roll", Description = "Toilet Rolls: Paseo Elegant 3 Ply Bathroom Tissue 4 Roll 280 Sheet", Price = 380.00m, CategoryId = 9 }, new Product { Name = "Paseo Toilet Roll 300's 3Ply-8roll", Description = "Hygenic, soft and natural", Price = 830.00m, CategoryId = 9 }, new Product { Name = "Newlook Suncontrol spf 50 for Normal & Dry skin-100ml", Description = "NEWLOOK’s Daily Sun Control PA+++ SPF-50", Price = 460.00m, CategoryId = 10 }, new Product { Name = "Lifebuoy Total - 95gm", Description = "", Price = 35.00m, CategoryId = 10 }, new Product { Name = "Dettol Soap Regular 125gm (Buy 4 and Get 1 Free)", Description = "", Price = 320.00m, CategoryId = 10 }, new Product { Name = "Naturo Earth Pink Salt Soap For Face And Body, 100gm", Description = "Naturo Earth’s Pink Salt Soap is infused with Himalayan Pink Salt", Price = 300.00m, CategoryId = 10 }, new Product { Name = "Head & Shoulder Smooth And Silky Shampoo 720ml", Description = "", Price = 690.00m, CategoryId = 10 }, new Product { Name = "Black & Green Extra Virgin Avocado Oil, 220ml", Description = "", Price = 2500.00m, CategoryId = 11 }, new Product { Name = "Juas Grass Fed Ghee-1000ml", Description = "Raw free range organic pastured ghee. No salt, sugar or preservatives added.", Price = 1750.00m, CategoryId = 11 }, new Product { Name = "Baby Dove Rich Moisture Head to Toe Wash, 400 ml", Description = "A tear-free and hypoallergenic baby wash and shampoo that helps moisturise your baby’s delicate skin to keep it soft.", Price = 425.00m, CategoryId = 11 }, new Product { Name = "Johnson & Johnson Baby Shampoo No More Tears, 100ml", Description = "Johnson's Baby shampoo is as gentle to the eyes as pure water", Price = 144.00m, CategoryId = 11 }, new Product { Name = "Kennel Adult Dog Food Pouch 1.5Kg", Description = "Shinier coats, Healthier skin...", Price = 475.00m, CategoryId = 11 }, new Product { Name = "BonaCibo Adult Lamb & Rice, 15kg", Description = "", Price = 5500.00m, CategoryId = 11 }, new Product { Name = "Alpha Electric Kettle Stainless Steel Cordless Jug-2Ltr", Description = "", Price = 730.00m, CategoryId = 11 }, new Product { Name = "Baltra Prima Induction Cooker", Description = "2000W Energy Saving", Price = 4400.00m, CategoryId = 11 }, }; foreach (Product p in products) { context.Products.Add(p); } context.SaveChanges(); } if (!context.Customers.Any()) { var customers = new Customer[] { new Customer { Name = "Reiko Bridewell", MemberNumber = "12160609" }, new Customer { Name = "Ruben Ketchaside", MemberNumber = "23665561", Phone = "6039991683", Email = "*****@*****.**" }, new Customer { Name = "Jilly Bendall", MemberNumber = "60673715", MemberType = "Bronze", Phone = "1825693497", Address = "134 Blackbird Hill", Email = "*****@*****.**" }, new Customer { Name = "Maritsa Wildber ", MemberNumber = "20697860", MemberType = "Bronze", Phone = "3661740034", Address = "4780 2nd Circle", Email = "*****@*****.**" }, new Customer { Name = "Winni Di Iorio", MemberNumber = "55966772", MemberType = "Gold", Phone = "6499054605", Address = "902 Pawling Street", Email = "*****@*****.**" }, new Customer { Name = "Kissiah Gaitone", MemberNumber = "56339888" }, new Customer { Name = "Gabriell Bartolozzi", MemberNumber = "96900296", Phone = "7412745335", Email = "*****@*****.**" }, new Customer { Name = "Feodor Hansod", MemberNumber = "40625989", Phone = "4558027879", Email = "*****@*****.**" }, }; foreach (Customer c in customers) { context.Customers.Add(c); } context.SaveChanges(); } if (!context.Stocks.Any()) { var stocks = new Stock[] { new Stock { Id = 1, Quantity = 12 }, new Stock { Id = 2, Quantity = 10 }, new Stock { Id = 3, Quantity = 10 }, new Stock { Id = 4, Quantity = 5 }, new Stock { Id = 7, Quantity = 4 }, new Stock { Id = 8, Quantity = 15 }, new Stock { Id = 9, Quantity = 20 }, new Stock { Id = 10, Quantity = 8 }, new Stock { Id = 11, Quantity = 22 }, new Stock { Id = 12, Quantity = 25 }, new Stock { Id = 13, Quantity = 50 }, new Stock { Id = 14, Quantity = 46 }, new Stock { Id = 15, Quantity = 35 }, new Stock { Id = 16, Quantity = 23 }, new Stock { Id = 17, Quantity = 22 }, new Stock { Id = 18, Quantity = 16 }, new Stock { Id = 19, Quantity = 19 }, new Stock { Id = 21, Quantity = 12 }, new Stock { Id = 22, Quantity = 22 }, new Stock { Id = 25, Quantity = 30 }, new Stock { Id = 26, Quantity = 21 }, new Stock { Id = 27, Quantity = 26 }, new Stock { Id = 28, Quantity = 16 }, new Stock { Id = 29, Quantity = 6 }, new Stock { Id = 30, Quantity = 36 }, new Stock { Id = 32, Quantity = 33 }, new Stock { Id = 33, Quantity = 22 }, new Stock { Id = 35, Quantity = 11 }, new Stock { Id = 37, Quantity = 2 }, new Stock { Id = 39, Quantity = 26 }, new Stock { Id = 42, Quantity = 37 }, new Stock { Id = 45, Quantity = 24 }, new Stock { Id = 46, Quantity = 15 }, new Stock { Id = 47, Quantity = 16 }, new Stock { Id = 48, Quantity = 15 }, new Stock { Id = 49, Quantity = 11 }, new Stock { Id = 50, Quantity = 18 }, new Stock { Id = 52, Quantity = 32 }, new Stock { Id = 53, Quantity = 19 }, new Stock { Id = 55, Quantity = 22 }, new Stock { Id = 57, Quantity = 27 }, new Stock { Id = 59, Quantity = 26 }, new Stock { Id = 60, Quantity = 32 }, new Stock { Id = 61, Quantity = 12 }, new Stock { Id = 62, Quantity = 16 }, new Stock { Id = 63, Quantity = 19 }, new Stock { Id = 65, Quantity = 14 }, }; foreach (Stock s in stocks) { context.Stocks.Add(s); } context.SaveChanges(); } if (!context.Sales.Any()) { var sales = new Sales[] { new Sales { SalesDate = new DateTime(2021, 4, 15), CustomerId = 1 }, new Sales { SalesDate = new DateTime(2021, 4, 8), CustomerId = 7 }, new Sales { SalesDate = new DateTime(2021, 4, 12), CustomerId = 4 }, new Sales { SalesDate = new DateTime(2021, 3, 29), CustomerId = 2 }, new Sales { SalesDate = new DateTime(2021, 3, 30), CustomerId = 2 }, new Sales { SalesDate = new DateTime(2021, 2, 5), CustomerId = 5 }, new Sales { SalesDate = new DateTime(2021, 4, 21), CustomerId = 3 }, new Sales { SalesDate = new DateTime(2021, 4, 25), CustomerId = 6 }, new Sales { SalesDate = new DateTime(2021, 4, 26), CustomerId = 2 }, new Sales { SalesDate = new DateTime(2021, 2, 3), CustomerId = 7 }, }; foreach (Sales s in sales) { context.Sales.Add(s); } context.SaveChanges(); } if (!context.SalesLineItems.Any()) { var salesLineItems = new SalesLineItem[] { new SalesLineItem { Quantity = 2, ProductId = 5, SalesId = 1 }, new SalesLineItem { Quantity = 1, ProductId = 10, SalesId = 2 }, new SalesLineItem { Quantity = 1, ProductId = 12, SalesId = 2 }, new SalesLineItem { Quantity = 2, ProductId = 50, SalesId = 3 }, new SalesLineItem { Quantity = 10, ProductId = 14, SalesId = 3 }, new SalesLineItem { Quantity = 1, ProductId = 25, SalesId = 3 }, new SalesLineItem { Quantity = 2, ProductId = 31, SalesId = 4 }, new SalesLineItem { Quantity = 1, ProductId = 42, SalesId = 4 }, new SalesLineItem { Quantity = 5, ProductId = 16, SalesId = 5 }, new SalesLineItem { Quantity = 12, ProductId = 17, SalesId = 5 }, new SalesLineItem { Quantity = 3, ProductId = 8, SalesId = 5 }, new SalesLineItem { Quantity = 6, ProductId = 61, SalesId = 6 }, new SalesLineItem { Quantity = 2, ProductId = 55, SalesId = 6 }, new SalesLineItem { Quantity = 1, ProductId = 34, SalesId = 7 }, new SalesLineItem { Quantity = 1, ProductId = 56, SalesId = 7 }, new SalesLineItem { Quantity = 2, ProductId = 23, SalesId = 7 }, new SalesLineItem { Quantity = 2, ProductId = 29, SalesId = 7 }, new SalesLineItem { Quantity = 3, ProductId = 19, SalesId = 8 }, new SalesLineItem { Quantity = 2, ProductId = 18, SalesId = 9 }, new SalesLineItem { Quantity = 5, ProductId = 4, SalesId = 9 }, new SalesLineItem { Quantity = 2, ProductId = 2, SalesId = 9 }, new SalesLineItem { Quantity = 5, ProductId = 39, SalesId = 10 }, new SalesLineItem { Quantity = 1, ProductId = 58, SalesId = 10 }, }; foreach (SalesLineItem s in salesLineItems) { context.SalesLineItems.Add(s); } context.SaveChanges(); } if (!context.Purchases.Any()) { var purchases = new Purchase[] { new Purchase { PurchaseDate = new DateTime(2020, 8, 12), Vendor = "ABC Suppliers" }, new Purchase { PurchaseDate = new DateTime(2020, 12, 1), Vendor = "Zero Distributors" }, new Purchase { PurchaseDate = new DateTime(2021, 1, 10), Vendor = "OK Pvt. Ltd." }, new Purchase { PurchaseDate = new DateTime(2021, 2, 9), Vendor = "Index Distributors" }, new Purchase { PurchaseDate = new DateTime(2021, 3, 15), Vendor = "OK Pvt. Ltd." }, }; foreach (Purchase p in purchases) { context.Purchases.Add(p); } context.SaveChanges(); } if (!context.PurchaseLineItems.Any()) { var purchaseLineItems = new PurchaseLineItem[] { new PurchaseLineItem { ProductId = 1, Quantity = 30, PurchaseId = 1 }, new PurchaseLineItem { ProductId = 2, Quantity = 20, PurchaseId = 1 }, new PurchaseLineItem { ProductId = 3, Quantity = 15, PurchaseId = 1 }, new PurchaseLineItem { ProductId = 4, Quantity = 6, PurchaseId = 1 }, new PurchaseLineItem { ProductId = 7, Quantity = 9, PurchaseId = 1 }, new PurchaseLineItem { ProductId = 8, Quantity = 28, PurchaseId = 1 }, new PurchaseLineItem { ProductId = 9, Quantity = 14, PurchaseId = 1 }, new PurchaseLineItem { ProductId = 10, Quantity = 34, PurchaseId = 2 }, new PurchaseLineItem { ProductId = 11, Quantity = 22, PurchaseId = 2 }, new PurchaseLineItem { ProductId = 12, Quantity = 26, PurchaseId = 2 }, new PurchaseLineItem { ProductId = 13, Quantity = 59, PurchaseId = 2 }, new PurchaseLineItem { ProductId = 14, Quantity = 99, PurchaseId = 2 }, new PurchaseLineItem { ProductId = 15, Quantity = 65, PurchaseId = 2 }, new PurchaseLineItem { ProductId = 16, Quantity = 53, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 17, Quantity = 29, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 18, Quantity = 46, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 19, Quantity = 29, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 21, Quantity = 19, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 22, Quantity = 25, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 25, Quantity = 32, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 26, Quantity = 26, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 27, Quantity = 22, PurchaseId = 3 }, new PurchaseLineItem { ProductId = 28, Quantity = 18, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 29, Quantity = 69, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 30, Quantity = 47, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 32, Quantity = 53, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 33, Quantity = 42, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 35, Quantity = 17, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 37, Quantity = 23, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 39, Quantity = 29, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 42, Quantity = 56, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 45, Quantity = 28, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 46, Quantity = 19, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 47, Quantity = 26, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 48, Quantity = 35, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 49, Quantity = 17, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 50, Quantity = 38, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 52, Quantity = 39, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 53, Quantity = 29, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 55, Quantity = 23, PurchaseId = 4 }, new PurchaseLineItem { ProductId = 57, Quantity = 29, PurchaseId = 5 }, new PurchaseLineItem { ProductId = 59, Quantity = 46, PurchaseId = 5 }, new PurchaseLineItem { ProductId = 60, Quantity = 36, PurchaseId = 5 }, new PurchaseLineItem { ProductId = 61, Quantity = 22, PurchaseId = 5 }, new PurchaseLineItem { ProductId = 62, Quantity = 20, PurchaseId = 5 }, new PurchaseLineItem { ProductId = 63, Quantity = 37, PurchaseId = 5 }, new PurchaseLineItem { ProductId = 65, Quantity = 25, PurchaseId = 5 }, }; foreach (PurchaseLineItem p in purchaseLineItems) { context.PurchaseLineItems.Add(p); } context.SaveChanges(); } }
public void CreateOrUpdateOrder(OrderDetailDto orderDTO) { //var ctx = context; var order = ctx.PurchaseOrder.FirstOrDefault(o => o.OrderNum == orderDTO.PurchaseOrderID); if (order == null) { order = new PurchaseOrder(); ctx.PurchaseOrder.Add(order); } //Map properties order.OrderDate = DateTime.Parse(orderDTO.OrderDate); order.OrderTotal = orderDTO.OrderTotal; order.ExpectedDate = orderDTO.ExpectedDate; order.JobId = orderDTO.JobID; order.Memo = orderDTO.Memo; order.SalesRep = orderDTO.SalesRep; order.EmployeeId = orderDTO.EmployeeID; order.OrderNum = orderDTO.PurchaseOrderID; order.ShipId = orderDTO.ShipID; order.ShippingCost = orderDTO.ShippingCost; order.SubTotal = orderDTO.SubTotal; order.SupplierId = orderDTO.SupplierID; order.SuppressTax = orderDTO.Taxable; order.Tax = orderDTO.Tax; order.TaxRate = orderDTO.TaxRate; //remove deleted details - order.PurchaseLineItem .Where(d => !orderDTO.LineItems.Any(LineItemDto => LineItemDto.LineID == d.LineID)).ToList() .ForEach(deleted => ctx.PurchaseLineItem.Remove(deleted)); //update or add details orderDTO.LineItems.ToList().ForEach(detailDTO => { var detail = order.PurchaseLineItem.FirstOrDefault(d => d.LineID == detailDTO.LineID); if (detail == null) { detail = new PurchaseLineItem(); order.PurchaseLineItem.Add(detail); } detail.JobId = detailDTO.JobID; detail.Qnty = detailDTO.Quantity; detail.Description = detailDTO.Description; detail.PurchaseOrderId = detailDTO.PurchaseOrderID; detail.PartID = detailDTO.PartID; detail.UnitCost = detailDTO.Price; detail.Uom = detailDTO.UiD; detail.Extended = detailDTO.Extended; }); //remove deleted orderfees - order.OrderFee .Where(d => !orderDTO.OrderFees.Any(OrderFeeDto => OrderFeeDto.OrderFeeID == d.OrderfeeID)).ToList() .ForEach(deleted => ctx.OrderFee.Remove(deleted)); //update or add OrderFees orderDTO.OrderFees.ToList().ForEach(od => { var orderfee = order.OrderFee.FirstOrDefault(r => r.OrderfeeID == od.OrderFeeID); if (orderfee == null) { orderfee = new OrderFee(); order.OrderFee.Add(orderfee); } orderfee.PurchaseOrderID = order.OrderNum; orderfee.FeeName = od.FeeName; orderfee.Cost = od.Cost; orderfee.Extension = od.Extension; orderfee.Qnty = od.Qnty; }); //remove deleted attachments - order.Attachment .Where(a => !orderDTO.Attachments.Any(attachDTO => attachDTO.AttachmentID == a.AttachmentId)).ToList() .ForEach(deleted => ctx.Attachment.Remove(deleted)); //update or add Attachments orderDTO.Attachments.ToList().ForEach(ad => { var attachmnt = order.Attachment.FirstOrDefault(r => r.AttachmentId == ad.AttachmentID); if (attachmnt == null) { attachmnt = new Attachment(); order.Attachment.Add(attachmnt); } attachmnt.OrderNum = ad.OrderNum; attachmnt.Filesource = ad.FileSource; attachmnt.AttachmentDescription = ad.AttachmentDescription; attachmnt.Ext = ad.Ext; attachmnt.Src = ad.Src; attachmnt.FileSize = ad.FileSize; attachmnt.Creator = ad.Creator; attachmnt.CreateDate = ad.CreatedDate; }); ctx.SaveChanges(); }
public PurchaseLineItemReceiptValidator(PurchaseLineItem lineItem) { m_lineItem = lineItem; }