public void Save(DispatchNote documentEntity)
{
tblDocument docToSave = SaveDocument(documentEntity);
DispatchNote DN = documentEntity ;
docToSave.OrderOrderTypeId = (int)DN.DispatchType;
docToSave.InvoiceOrderId = DN.OrderId;
foreach (DispatchNoteLineItem DNitem in DN.LineItems)
{
tblLineItems ll = null;
if (docToSave.tblLineItems.Any(n => n.id == DNitem.Id))
ll = docToSave.tblLineItems.First(p => p.id == DNitem.Id);
else
{
ll = new tblLineItems();
ll.id = DNitem.Id;
ll.DocumentID = documentEntity.Id;
docToSave.tblLineItems.Add(ll);
}
ll.ProductID = DNitem.Product.Id;
ll.LineItemSequenceNo = DNitem.LineItemSequenceNo;
ll.Value = DNitem.Value;
ll.Description = DNitem.Description;
ll.Quantity = DNitem.Qty;
ll.LineItemSequenceNo = DNitem.LineItemSequenceNo;
ll.OrderLineItemType = (int)DNitem.LineItemType;
ll.DiscountLineItemTypeId = (int)DNitem.DiscountType;
ll.ProductDiscount = DNitem.ProductDiscount;
ll.Vat = DNitem.LineItemVatValue;
ll.Description = DNitem.Description;
}
_ctx.SaveChanges();
}
public void Save(PaymentNote documentEntity)
{
tblDocument docToSave = SaveDocument(documentEntity);
PaymentNote payement = documentEntity as PaymentNote;
docToSave.OrderOrderTypeId = (int)payement.PaymentNoteType;
foreach (PaymentNoteLineItem LossItem in payement.LineItems)
{
tblLineItems ll = null;
if (docToSave.tblLineItems.Any(n => n.id == LossItem.Id))
ll = docToSave.tblLineItems.First(p => p.id == LossItem.Id);
else
{
ll = new tblLineItems();
ll.id = LossItem.Id;
ll.DocumentID = documentEntity.Id;
docToSave.tblLineItems.Add(ll);
}
ll.LineItemSequenceNo = LossItem.LineItemSequenceNo;
ll.Value = LossItem.Amount;
ll.LineItemSequenceNo = LossItem.LineItemSequenceNo;
ll.OrderLineItemType = (int)LossItem.PaymentMode;
_log.DebugFormat("DocumentRepository:ll.Reason");
}
_ctx.SaveChanges();
}
public void Save(ReturnsNote documentEntity)
{
tblDocument docToSave = SaveDocument(documentEntity);
ReturnsNote rn = documentEntity;
docToSave.OrderOrderTypeId = (int)rn.ReturnsNoteType;
foreach (ReturnsNoteLineItem lineItem in rn._lineItems)
{
tblLineItems ll = null;
if (docToSave.tblLineItems.Any(p => p.id == lineItem.Id))
ll = docToSave.tblLineItems.First(p => p.id.ToString() == lineItem.Id.ToString());
else
{
ll = new tblLineItems();
ll.id = lineItem.Id;
docToSave.tblLineItems.Add(ll);
}
if (lineItem.Product != null)
ll.ProductID = lineItem.Product.Id;
ll.DocumentID = documentEntity.Id;
ll.Description = lineItem.Description;
ll.Quantity = lineItem.Qty;
ll.IAN_Actual = lineItem.Actual;
ll.LineItemSequenceNo = lineItem.LineItemSequenceNo;
ll.Value = lineItem.Value;
ll.Receipt_PaymentTypeId = (int)lineItem.ReturnType;
ll.OrderLineItemType = (int)lineItem.LossType;
ll.ReturnsNoteReason = lineItem.Reason;
ll.Other = lineItem.Other;
}
_ctx.SaveChanges();
}
public void Save(DisbursementNote documentEntity)
{
tblDocument docToSave = SaveDocument(documentEntity);
DisbursementNote r = documentEntity as DisbursementNote;
foreach (DisbursementNoteLineItem rli in r.LineItems)
{
tblLineItems ll = null;
if (docToSave.tblLineItems.Any(n => n.id == rli.Id))
ll = docToSave.tblLineItems.First(n => n.id == rli.Id);
else
{
ll = new tblLineItems();
ll.id = rli.Id;
ll.DocumentID = documentEntity.Id;
docToSave.tblLineItems.Add(ll);
}
ll.ProductID = rli.Product.Id;
ll.Value = rli.Value;
ll.Quantity = rli.Qty;
ll.Description = rli.Description;
ll.LineItemSequenceNo = rli.LineItemSequenceNo;
}
_ctx.SaveChanges();
}
public void SaveLineItem(InvoiceLineItem ili, Guid invoiceId)
{
tblLineItems lineItem = null;
if (_ctx.tblLineItems.Any(n => n.id == ili.Id))
lineItem = _ctx.tblLineItems.First(n => n.id == ili.Id);
else
{
lineItem = new tblLineItems();
lineItem.id = ili.Id;
lineItem.DocumentID = invoiceId;
_ctx.tblLineItems.AddObject(lineItem);
}
lineItem.ProductID = ili.Product.Id;
lineItem.DocumentID = invoiceId;
lineItem.Description = ili.Description;
lineItem.Quantity = ili.Qty;
lineItem.LineItemSequenceNo = ili.LineItemSequenceNo;
lineItem.Value = ili.Value;
lineItem.Vat = ili.LineItemVatValue;
lineItem.OrderLineItemType = (int)ili.LineItemType;
lineItem.ProductDiscount = ili.ProductDiscount;
lineItem.DiscountLineItemTypeId = (int)ili.DiscountType;
_ctx.SaveChanges();
}
private InventoryTransferNoteLineItem MapITNLineItem(tblLineItems li)
{
var _li = DocumentLineItemPrivateConstruct<InventoryTransferNoteLineItem>(li.id);
_li.Description = li.Description;
_li.LineItemSequenceNo = li.LineItemSequenceNo.Value;
_li.Product = _productRepository.GetById(li.ProductID.Value);
_li.Qty = li.Quantity.Value;
return _li;
}
private PaymentNoteLineItem MapPayementLineItem(tblLineItems li)
{
return new PaymentNoteLineItem(li.id)
{
Description = li.Description,
LineItemSequenceNo = li.LineItemSequenceNo.Value,
PaymentMode = (PaymentMode)li.OrderLineItemType.Value,
Amount = li.Value.Value,
};
}
public void Save(Order documentEntity)
{
tblDocument docToSave = SaveDocument(documentEntity);
Order order = documentEntity as Order;
docToSave.OrderDateRequired = order.DateRequired;
docToSave.OrderIssuedOnBehalfOfCC = order.IssuedOnBehalfOf == null ? Guid.Empty : order.IssuedOnBehalfOf.Id;
docToSave.OrderOrderTypeId = (int)order.OrderType;
docToSave.SaleDiscount = order.SaleDiscount;
docToSave.Note = order.Note;
foreach (OrderLineItem lineItem in order._allLineItems())
{
tblLineItems ll = null;
if (docToSave.tblLineItems.Any(p => p.id == lineItem.Id))
ll = docToSave.tblLineItems.First(p => p.id.ToString() == lineItem.Id.ToString());
else
{
ll = new tblLineItems();
ll.id = lineItem.Id;
docToSave.tblLineItems.Add(ll);
}
ll.ProductID = lineItem.Product.Id;
ll.DocumentID = documentEntity.Id;
ll.Description = lineItem.Description;
ll.Quantity = lineItem.Qty;
ll.LineItemSequenceNo = lineItem.LineItemSequenceNo;
ll.Value = lineItem.Value;
ll.Vat = lineItem.LineItemVatValue;
ll.OrderLineItemType = (int)lineItem.LineItemType;
ll.ProductDiscount = lineItem.ProductDiscount;
ll.DiscountLineItemTypeId = (int)lineItem.DiscountType;
ll.Description = lineItem.Description;
}
_ctx.SaveChanges();
}
/// <summary>
/// Deprecated Method for adding a new object to the tblLineItems EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotblLineItems(tblLineItems tblLineItems)
{
base.AddObject("tblLineItems", tblLineItems);
}
private InvoiceLineItem MapInvoiceLineItem(tblLineItems n)
{
var lineItem = DocumentLineItemPrivateConstruct<InvoiceLineItem>(n.id);
lineItem.Description = n.Description;
lineItem.LineItemSequenceNo = n.LineItemSequenceNo.Value;
lineItem.LineItemVatValue = n.Vat.Value;
lineItem.Qty = n.Quantity.Value;
lineItem.Value = n.Value.Value;
lineItem.LineItemType = (OrderLineItemType) n.OrderLineItemType;
lineItem.ProductDiscount = n.ProductDiscount.Value;
lineItem.DiscountType = (DiscountType) n.DiscountLineItemTypeId;
if (n.ProductID != null)
lineItem.Product = _productRepository.GetById(n.ProductID.Value);
return lineItem;
}
MapSubOrderLineItem(tblLineItems s)
{
SubOrderLineItem item = DocumentLineItemPrivateConstruct<SubOrderLineItem>(s.id);
item.Description = s.Description;
if (s.LineItemSequenceNo != null) item.LineItemSequenceNo = s.LineItemSequenceNo.Value;
if (s.Vat != null)
item.LineItemVatValue = s.Vat.Value;
item.Product = s.ProductID == null ? null : _productRepository.GetById(s.ProductID.Value);
//if (s.ProductDiscount != null) item.ProductDiscount = s.ProductDiscount.Value;
if (s.Quantity != null) item.Qty = s.Quantity.Value;
if (s.Value != null) item.Value = s.Value.Value;
if (s.ProductDiscount != null) item.ProductDiscount = s.ProductDiscount.Value;
if (s.DiscountLineItemTypeId != null) item.DiscountType = (DiscountType) s.DiscountLineItemTypeId;
if (s.LostSaleQuantity != null) item.LostSaleQuantity = s.LostSaleQuantity.Value;
if (s.ApprovedQuantity != null) item.ApprovedQuantity = s.ApprovedQuantity.Value;
if (s.BackOrderQuantity != null) item.BackOrderQuantity = s.BackOrderQuantity.Value;
if (s.DispatchedQuantity != null) item.DispatchedQuantity = s.DispatchedQuantity.Value;
item.InitialQuantity = s.InitialQuantity;
if (s.LineItemStatusId != null) item.LineItemStatus = (MainOrderLineItemStatus) s.LineItemStatusId;
if (s.OrderLineItemType != null) item.LineItemType = (MainOrderLineItemType) s.OrderLineItemType;
return item;
}
internal OrderLineItem MapOrderLineItem(tblLineItems s)
{
return new OrderLineItem(s.id)
{
Description = s.Description,
LineItemSequenceNo = s.LineItemSequenceNo.Value,
LineItemVatValue = s.Vat.Value,
Product = s.ProductID == null ? null : _productRepository.GetById(s.ProductID.Value),
Qty = s.Quantity.Value,
Value = s.Value.Value,
LineItemType = (OrderLineItemType)s.OrderLineItemType.Value,
ProductDiscount = s.ProductDiscount.Value,
DiscountType = (DiscountType)s.DiscountLineItemTypeId
};
}
private DisbursementNoteLineItem MapDisbursementNoteLineItems(tblLineItems n)
{
return new DisbursementNoteLineItem(n.id)
{
Description = n.Description,
Product = _productRepository.GetById(n.ProductID.Value),
LineItemSequenceNo = n.LineItemSequenceNo.Value,
Value = n.Value.Value,
Qty = n.Quantity.Value,
};
}
public void SaveLineItem(OrderLineItem lineItem, Guid orderId)
{
tblLineItems ll = null;
if (_ctx.tblLineItems.Any(p => p.id == lineItem.Id))
ll = _ctx.tblLineItems.First(p => p.id == lineItem.Id);
else
{
ll = new tblLineItems();
ll.id = lineItem.Id;
_ctx.tblLineItems.AddObject(ll);
}
ll.ProductID = lineItem.Product.Id;
ll.DocumentID = orderId;
ll.Description = lineItem.Description;
ll.Quantity = lineItem.Qty;
ll.LineItemSequenceNo = lineItem.LineItemSequenceNo;
ll.Value = lineItem.Value;
ll.Vat = lineItem.LineItemVatValue;
ll.OrderLineItemType = (int)lineItem.LineItemType;
ll.ProductDiscount = lineItem.ProductDiscount;
ll.DiscountLineItemTypeId = (int)lineItem.DiscountType;
ll.Description = lineItem.Description;
_ctx.SaveChanges();
}
private DispatchNoteLineItem MapDNLineItem(tblLineItems li)
{
return new DispatchNoteLineItem(li.id)
{
Description = li.Description,
LineItemSequenceNo = li.LineItemSequenceNo.Value,
Product = _productRepository.GetById(li.ProductID.Value),
Qty = li.Quantity.Value,
Value = li.Value.Value,
LineItemType = (OrderLineItemType)li.OrderLineItemType,
ProductDiscount = li.ProductDiscount.Value,
LineItemVatValue = li.Vat.Value,
DiscountType = (DiscountType)li.DiscountLineItemTypeId
};
}
protected tblLineItems NewLineItem(Guid lineItemId,
Guid documentId,
Guid? productId,
string description,
decimal? quantity,
int? lineItemSequenceNo
)
{
var li = new tblLineItems
{
id = lineItemId,
DocumentID = documentId,
ProductID = productId,
Description = description==null? "" : description,
Quantity = quantity,
LineItemSequenceNo = lineItemSequenceNo
};
return li;
}
/// <summary>
/// Create a new tblLineItems object.
/// </summary>
/// <param name="id">Initial value of the id property.</param>
/// <param name="initialQuantity">Initial value of the InitialQuantity property.</param>
public static tblLineItems CreatetblLineItems(global::System.Guid id, global::System.Decimal initialQuantity)
{
tblLineItems tblLineItems = new tblLineItems();
tblLineItems.id = id;
tblLineItems.InitialQuantity = initialQuantity;
return tblLineItems;
}
private CreditNoteLineItem MapCreditLineItem(tblLineItems n)
{
return new CreditNoteLineItem(n.id)
{
Description = n.Description,
LineItemSequenceNo = n.LineItemSequenceNo.Value,
Value = n.Value.Value,
Product = _productRepository.GetById(n.ProductID.Value),
Qty = n.Quantity.Value
};
}
private ReturnsNoteLineItem MapReturnsNoteLineItem(tblLineItems li)
{
var lineItem = new ReturnsNoteLineItem(li.id)
{
Description = li.Description,
LineItemSequenceNo = li.LineItemSequenceNo.Value,
Qty = li.Quantity.Value,
Value = li.Value.Value,
Actual = li.IAN_Actual.Value,
ReturnType = (ReturnsType)li.Receipt_PaymentTypeId.Value,
LossType = (LossType)li.OrderLineItemType.Value,
Reason = li.ReturnsNoteReason,
Other = li.Other,
};
if (li.ProductID != null)
lineItem.Product = _productRepository.GetById(li.ProductID.Value);
return lineItem;
}
