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