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;
}
