private void SaveChanges() { ctx.SaveChanges(); _isDirty = false; btnSave.Enabled = false; view.Rows.Clear(); BindGrid(); bsLineItems.ResetBindings(false); }
public OrderReciept Create(int employeeID, int purchaseOrderID = 0) { var result = new OrderReciept { ReceiptDate = DateTime.Now, EmployeeId = employeeID, OrderNum = purchaseOrderID, }; context.OrderReciept.Add(result); context.SaveChanges(); return(result); }
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; }
private void SaveChanges() { _ctx.SaveChanges(); _ordersService.CreateOrUpdateOrder(orderHeader); _isDirty = false; btnSave.Enabled = false; view.Rows.Clear(); BindGrid(); bsLineItems.ResetBindings(false); }
public void CreateOrUpdateOrder(ResourceDto resourceDTO) { var resource = ctx.Resource.FirstOrDefault(o => o.ResourceID == resourceDTO.ResourceID); if (resource == null) { resource = new Resource(); ctx.Resource.Add(resource); // Save to DB to get the new ID -- ctx.SaveChanges(); } //Map properties -------------------------------------------------- resource.Createdby = resourceDTO.Createdby; resource.CurrentVersion = resourceDTO.CurrentVersion; resource.ResourceDescription = resourceDTO.ResourceDescription; //resource.ResourceID = resourceDTO.ResourceID; //remove deleted details - resource.Versions .Where(d => !resourceDTO.Versions.Any(ResourceVersionDto => ResourceVersionDto.ResourceVersionID == d.ResourceVersionID)).ToList() .ForEach(deleted => ctx.ResourceVersion.Remove(deleted)); //update or add details resourceDTO.Versions.ToList().ForEach(ResourceVersionDTO => { var detail = resource.Versions.FirstOrDefault(d => d.ResourceVersionID == ResourceVersionDTO.ResourceVersionID); if (detail == null) { detail = new ResourceVersion(); resource.Versions.Add(detail); } detail.ResourceID = resource.ResourceID; detail.Resource = ResourceVersionDTO.Resource; //detail.ResourceVersionID = ResourceVersionDTO.ResourceVersionID; detail.RVersion = ResourceVersionDTO.RVersion; }); ctx.SaveChanges(); }
private void btnSave_Click(object sender, EventArgs e) { // If the part is new-detached if (_context.Entry(_part).State == EntityState.Detached) { _context.Part.Add(_part); } // Date and Name stamp modifications -- var user = Globals.CurrentLoggedUserID; _part.ModifiedBy = Globals.CurrentUserName; _part.ModifiedDate = DateTime.Today; //------------------------------------- _context.SaveChanges(); _isDirty = false; TabPage tabpage = (TabPage)this.Parent; TabControl tabControl = (TabControl)tabpage.Parent; tabControl.TabPages.Remove(tabpage); }
/// <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); }
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); }
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); }
public Resource PushVersion(Resource pushResource, Byte[] newfile, string comment, string user) { var resource = ctx.Resource.FirstOrDefault(o => o.ResourceID == pushResource.ResourceID); // Create a new Resource Version Object and populate it ResourceVersion version = new ResourceVersion(); version.ModDate = DateTime.Today; version.ModifiedBy = user; version.ResourceID = resource.ResourceID; version.RVersion = resource.CurrentVersion.GetValueOrDefault(); version.VersionComment = comment; version.Resource = newfile; ctx.ResourceVersion.Add(version); resource.CurrentVersion = version.RVersion; ctx.SaveChanges(); return(resource); }
public bool AssociateSKU(Part part, string sku) { bool result = false; if (part == null) { return(false); } var originalPart = _context.Part.Find(part.PartID); originalPart.Sku = sku; try { _context.SaveChanges(); result = true; } catch (Exception) { throw; } return(result); }
public void Save() { context.SaveChanges(); }
private void btnSaveChanges_Click(object sender, EventArgs e) { _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(); }
//Recieve Order -- public OrderReciept RecievedOrder(PurchaseOrder order, int employeeID) { // Build and save OrderReceipt -- OrderReciept oreciept = new OrderReciept(); oreciept.OrderNum = order.OrderNum; oreciept.EmployeeId = employeeID; oreciept.ReceiptDate = DateTime.Now; context.OrderReciept.Add(oreciept); context.SaveChanges(); List <ClaimItem> claimItems = new List <ClaimItem>(); foreach (PurchaseLineItem item in order.PurchaseLineItem) { Inventory inv = new Inventory(); inv.DateStamp = DateTime.Now; inv.Description = item.Description.ToString().TrimEnd(); inv.JobId = order.JobId; inv.LineID = item.LineID; inv.Location = string.Empty; inv.Note = item.Note; inv.OrderReceiptID = oreciept.OrderReceiptId; inv.UnitOfMeasure = item.Uom ?? 1; inv.Qnty = item.Qnty ?? 0; item.Recieved = true; item.OrderReceiptId = oreciept.OrderReceiptId; inv.PartID = item.PartID ?? null; if (!(item.Description.Length == 0) && !(item.Qnty == default(decimal))) { context.Entry(inv).State = EntityState.Added; context.Inventory.Add(inv); context.Entry(item).State = EntityState.Modified; if (item.Rejected == true) { var c = new ClaimItem { LineID = item.LineID, Description = item.Description, Bcode = item.Bcode, PartID = item.PartID }; claimItems.Add(c); } } } order.Recieved = true; order.RecievedDate = DateTime.Today; if (claimItems.Count > 0) { //ClaimService claimService = new ClaimService(context); //var newClaim = claimService.NewClaim(order.OrderNum, Globals.CurrentLoggedUserID); //foreach (ClaimItem clm in claimItems) //{ // newClaim.ClaimItem.Add(clm); //} context.SaveChanges(); } try { context.SaveChanges(); } catch (DbUpdateException ex) { string err = ex.InnerException.ToString(); Console.Write(err); throw; } return(oreciept); }
public Document Add(Document document) { _context.Document.Add(document); _context.SaveChanges(); return(document); }