private PaymentNote Map(tblDocument tblDoc)
{
var doc = new PaymentNote(tblDoc.Id);
_Map(tblDoc, doc);
doc.PaymentNoteType = (PaymentNoteType)tblDoc.OrderOrderTypeId;
doc._SetLineItems(tblDoc.tblLineItems.Select(n => MapPayementLineItem(n)).ToList());
return doc;
}
private InventoryTransferNote Map(tblDocument tblDoc)
{
var itn = PrivateConstruct<InventoryTransferNote>(tblDoc.Id);
_Map(tblDoc, itn);
itn.DocumentIssueredOnBehalfCostCentre = _costCentreRepository.GetById(tblDoc.OrderIssuedOnBehalfOfCC.Value);
itn._SetLineItems(tblDoc.tblLineItems.Select(n => MapITNLineItem(n)).ToList());
return itn;
}
private CreditNote Map(tblDocument tblDoc)
{
var cn = new CreditNote(tblDoc.Id);
_Map(tblDoc, cn);
cn.InvoiceId = tblDoc.InvoiceOrderId == null ? Guid.Empty : tblDoc.InvoiceOrderId.Value;
cn._SetLineItems(tblDoc.tblLineItems.Select(n => MapCreditLineItem(n)).ToList());
return cn;
}
private InventoryAdjustmentNote Map(tblDocument tblDoc)
{
var doc = PrivateConstruct<InventoryAdjustmentNote>(tblDoc.Id); //new InventoryAdjustmentNote(tblDoc.Id);
_Map(tblDoc, doc);
doc.InventoryAdjustmentNoteType = tblDoc.OrderOrderTypeId.HasValue == true ? (InventoryAdjustmentNoteType)tblDoc.OrderOrderTypeId.Value : 0;
doc._SetLineItems(tblDoc.tblLineItems.Select(n => MapIANLineItem(n)).ToList());
return doc;
}
private PaymentNote Map(tblDocument tblDoc)
{
var pn = new PaymentNote(tblDoc.Id);
_Map(tblDoc, pn);
pn.PaymentNoteType = (PaymentNoteType)tblDoc.OrderOrderTypeId;
pn._SetLineItems(tblDoc.tblLineItems.Select(n => MapPayementLineItem(n)).ToList());
return pn;
}
private ReturnsNote Map(tblDocument tblDoc)
{
var doc = PrivateConstruct<ReturnsNote>(tblDoc.Id);
doc.EnableAddCommands();
_Map(tblDoc, doc);
doc.ReturnsNoteType = tblDoc.OrderOrderTypeId.HasValue ? (ReturnsNoteType)tblDoc.OrderOrderTypeId : ReturnsNoteType.SalesmanToDistributor;
var lineItem = tblDoc.tblLineItems.Select(MapReturnsNoteLineItem).ToList();
doc._SetLineItems(lineItem);
return doc;
}
private tblDocument _NewDocument(Guid documentId,
DocumentType documentType,
Guid documentIssuerCostCentreId,
Guid documentIssuerUserId,
Guid documentIssuerCostCentreApplicationId,
DateTime documentDateIssued,
DocumentStatus documentStatus,
string documentReference,
DateTime sendDateTime,
Guid documentRecipientCostCentreId,
Guid documentparentId,
double? longitude = null,
double? latitude = null
)
{
var doc = new tblDocument
{
Id = documentId,
DocumentIssuerCostCentreId = documentIssuerCostCentreId,
DocumentIssuerUserId = documentIssuerUserId,
DocumentRecipientCostCentre = documentRecipientCostCentreId,
DocumentTypeId = (int) documentType,
DocumentDateIssued = documentDateIssued,
DocumentStatusId = (int) documentStatus,
DocumentReference = documentReference,
IM_DateCreated = DateTime.Now,
DocumentIssuerCostCentreApplicationId = documentIssuerCostCentreApplicationId,
IM_IsActive = true,
Latitude = latitude,
Longitude = longitude,
DocumentParentId = documentparentId,
SendDateTime = sendDateTime.Equals(new DateTime()) ? DateTime.Now : sendDateTime
};
if (sendDateTime.ToString("dd/MM/yyyy") == "01/01/0001")
{
doc.SendDateTime = DateTime.Now;
}
doc.IM_DateLastUpdated = DateTime.Now;
return doc;
}
string HandleShipTo(tblDocument order)
{
var shipTo=string.Empty;
if (string.IsNullOrEmpty(order.ShipToAddress) || order.ShipToAddress.Contains("--Select Shipto address----"))
{
return shipTo;
}
var separator = new[] { '[', ']' };
//[name][code][physical] address format=>name is outlet name
var temp = order.ShipToAddress.Split(separator, StringSplitOptions.RemoveEmptyEntries);
if (temp.Any())
{
//Take only takes shiptocode-nothing else...
shipTo = temp.Count() >= 2 ? temp[1] : shipTo;
}
return shipTo;
}
string HandleOutlet(tblDocument order)
{
if (order.OrderIssuedOnBehalfOfCC != null && order.OrderIssuedOnBehalfOfCC != Guid.Empty)
{
var costCentre = _ctx.tblCostCentre.FirstOrDefault(p => p.Id == order.OrderIssuedOnBehalfOfCC);
if (costCentre != null)
return costCentre.Cost_Centre_Code;
}
return string.Empty;
}
protected virtual decimal GetOutstandingAmount(tblDocument order)
{
decimal salediscount = order.SaleDiscount.HasValue ? order.SaleDiscount.Value : 0;
var invoiceList = (from d in _ctx.tblDocument
where d.DocumentTypeId == (int)DocumentType.Invoice
where d.InvoiceOrderId == order.Id
from l in d.tblLineItems
select new { l.Quantity, l.Value, l.Vat }).ToList();
var invoiceAmount = invoiceList.Sum(x => ((x.Quantity.Value * x.Value.Value) + (x.Vat.Value * x.Quantity.GetValueOrDefault(0))).GetTruncatedValue()).GetTotalGross();
//var invoiceAmount = (decimal?) (from d in _ctx.tblDocument
// where d.DocumentTypeId == (int) DocumentType.Invoice
// where d.InvoiceOrderId == order.Id
// from l in d.tblLineItems
// select new {l.Quantity, l.Value, l.Vat})
// .Sum(x => (x.Quantity*x.Value) + (x.Vat*x.Quantity)) ?? 0;
var receiptAmount = (decimal?) (from d in _ctx.tblDocument
where d.DocumentTypeId == (int) DocumentType.Receipt
where d.DocumentParentId == order.Id
from l in d.tblLineItems
select new {l.Value})
.Sum(x => x.Value) ?? 0;
var creditNoteSum = (decimal?) (from d in _ctx.tblDocument
where d.DocumentTypeId == (int) DocumentType.CreditNote
where d.DocumentParentId == order.Id
from l in d.tblLineItems
select new {l.Quantity, l.Value, l.Vat})
.Sum(x => (x.Quantity*x.Value) + (x.Vat*x.Quantity)) ?? 0;
decimal totalInvoiceAmount = (invoiceAmount - salediscount).GetTotalGross();
decimal totalPaidAmount = (receiptAmount + creditNoteSum);
decimal outstandingAmnt = totalInvoiceAmount - totalPaidAmount;
return outstandingAmnt;
}
private DispatchNote Map(tblDocument tblDoc)
{
var dn = new DispatchNote(tblDoc.Id);
_Map(tblDoc, dn);
if (tblDoc.OrderOrderTypeId != null)
dn.DispatchType = (DispatchNoteType)tblDoc.OrderOrderTypeId;
if (tblDoc.InvoiceOrderId != null)
dn.OrderId = tblDoc.InvoiceOrderId.Value;
dn._SetLineItems(tblDoc.tblLineItems.Select(n => MapDNLineItem(n)).ToList());
return dn;
}
/// <summary>
/// Deprecated Method for adding a new object to the tblDocument EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotblDocument(tblDocument tblDocument)
{
base.AddObject("tblDocument", tblDocument);
}
private PzCussonsOrderIntegrationDto MapPzDto(tblDocument document)
{
if (document != null)
{
var orderdateRequired = document.OrderDateRequired.HasValue
? document.OrderDateRequired.Value.ToString("dd/MM/yy")
: document.DocumentDateIssued.ToString("dd/MM/yy");
var dto = new PzCussonsOrderIntegrationDto()
{
GenericOrderReference = document.DocumentReference,
ExternalOrderReference = document.ExtDocumentReference,
Currency = "KES",
Note = document.Note,
DocumentDateIssued = document.DocumentDateIssued.ToString("dd/MM/yy"),
OrderDateRequired = orderdateRequired,
SalesmanCode = HandleSalesmanCode(document),
ShiptoAddressCode = HandleShipTo(document),
ChequeReferenceNo = GetChequePayment(document),
OutletCode = HandleOutlet(document)
};
int count = 1;
var lineItems = _ctx.tblLineItems.Where(p => p.DocumentID == document.Id).ToList();
foreach (var lineItem in lineItems)
{
if (lineItem.ProductID != null && lineItem.ProductID != Guid.Empty)
{
var product = _ctx.tblProduct.FirstOrDefault(p => p.id == lineItem.ProductID);
if(product !=null)
{
var item = new PzCussonsIntegrationDtoOrderLineItem()
{
ProductCode = product.ProductCode,
ApprovedQuantity = (lineItem.Quantity != null) ? lineItem.Quantity.Value : 0,
Count = count,
Location = string.Empty,
OrderDateRequired = orderdateRequired,
Site = string.Empty,
Value = lineItem.Value.HasValue ? lineItem.Value.Value : 0m
};
dto.LineItems.Add(item);
count++;
}
}
}
dto.TotalNet = GetOrderNetValue(document);
return dto;
}
return null;
}
private decimal GetSaleValue(tblDocument document)
{
var lineitems = document.tblLineItems.Where(s => s.LineItemStatusId != (int)MainOrderLineItemStatus.Removed).ToList();
if (lineitems.Any())
{
var totalVat = lineitems.Sum(n => (n.Vat ?? 0) * (n.Quantity ?? 0));
return (lineitems.Sum(n => (n.Value ?? 0)*(n.Quantity ?? 0)) + totalVat);
}
return 0m;
}
private List<ShellOrderExportDto> MapSage(tblDocument doc)
{
List<ShellOrderExportDto> orders=null;
if(doc !=null)
{
orders=new List<ShellOrderExportDto>();
var payments = _ctx.tblOrderPaymentInfo.Where(p => p.DocumentId == doc.Id).ToList();
var modes = payments.Select(n => ((PaymentMode)n.PaymentMode).ToString());
var cheque = payments.FirstOrDefault(p => p.PaymentMode == (int) PaymentMode.Cheque);
var paid = (GetPaidAmount(doc)*-1);
var lineItems = _ctx.tblLineItems.Where(p => p.DocumentID == doc.Id).ToList();
foreach (var lineItem in lineItems)
{
ShellOrderExportDto orderLineItem = null;
if (lineItem.ProductID != null && lineItem.ProductID != Guid.Empty)
{
var product = _ctx.tblProduct.FirstOrDefault(p => p.id == lineItem.ProductID);
if (product != null)
{
var quantity = (lineItem.Quantity != null) ? lineItem.Quantity.Value : 0;
var totalvat = (lineItem.Vat.HasValue ? lineItem.Vat.Value : 0m)*quantity;
var totalValue = (lineItem.Value.HasValue ? lineItem.Value.Value : 0m)*quantity;
orderLineItem = new ShellOrderExportDto
{
ExternalOrderReference = doc.ExtDocumentReference,
Note = doc.Note,
OrderDate = doc.OrderDateRequired.HasValue
? doc.OrderDateRequired.Value.ToShortDateString()
: string.Empty,
OutletCode = HandleOutlet(doc),
SalesmanCode = HandleSalesmanCode(doc),
AmountPaid = paid < 0 ? (paid = paid * -1).ToString("0.00") : paid.ToString("0.00"),
ChequeNo = cheque != null ? cheque.PaymentRefId : string.Empty,
ShiptoAddressCode = HandleShipTo(doc),
ModeOfpayment = modes != null && modes.Any() ? string.Join(",", modes) : string.Empty,
ProductCode = product.ProductCode,
Quantity = quantity.ToString(),
NetAmountExlVAT = (totalValue).ToString("0.00"),
TotalVATAmount = (totalvat).ToString("0.00"),
NetAmountIncVAT = (totalValue + totalvat).ToString("0.00")
};
orderLineItem.PricingTierCode = GetPricingTierCode(orderLineItem.OutletCode);
orderLineItem.OrderDateRequired = orderLineItem.OrderDate;
orderLineItem.SalesmanCodeTwo = orderLineItem.SalesmanCode;
}
}
orders.Add(orderLineItem);
}
}
return orders;
}
private List<SapDocumentExportDto> MapSAP(tblDocument arg)
{
if (arg == null) return null;
return (from line in _ctx.tblLineItems.Where(p => p.DocumentID == arg.Id).ToList()
where line.ProductID != null && line.ProductID != Guid.Empty
let product = _ctx.tblProduct.FirstOrDefault(p => p.id == line.ProductID)
where product != null
select new SapDocumentExportDto
{
OrderDate = arg.DocumentDateIssued.ToShortDateString(),
OrderDueDate =
arg.OrderDateRequired.HasValue
? arg.OrderDateRequired.Value.ToShortDateString()
: DateTime.Now.ToShortDateString(),
OrderRef = arg.ExtDocumentReference,
OutletCode = HandleOutlet(arg),
ProductCode = product.ProductCode.Trim(),
SalesmanCode = HandleSalesmanCode(arg),
Quantity = ((line.Quantity != null) ? line.Quantity.Value : 0).ToString("0.0"),
VatClass = GetVatClass(product)
}).ToList();
}
private GenericDocument Map(tblDocument tblDoc)
{
var doc = new GenericDocument(tblDoc.Id);
_Map(tblDoc, doc);
return doc;
}
/// <summary>
/// Create a new tblDocument object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="documentTypeId">Initial value of the DocumentTypeId property.</param>
/// <param name="iM_DateCreated">Initial value of the IM_DateCreated property.</param>
/// <param name="iM_DateLastUpdated">Initial value of the IM_DateLastUpdated property.</param>
/// <param name="iM_IsActive">Initial value of the IM_IsActive property.</param>
/// <param name="documentIssuerCostCentreId">Initial value of the DocumentIssuerCostCentreId property.</param>
/// <param name="documentIssuerUserId">Initial value of the DocumentIssuerUserId property.</param>
/// <param name="documentDateIssued">Initial value of the DocumentDateIssued property.</param>
/// <param name="documentStatusId">Initial value of the DocumentStatusId property.</param>
/// <param name="documentRecipientCostCentre">Initial value of the DocumentRecipientCostCentre property.</param>
public static tblDocument CreatetblDocument(global::System.Guid id, global::System.Int32 documentTypeId, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Boolean iM_IsActive, global::System.Guid documentIssuerCostCentreId, global::System.Guid documentIssuerUserId, global::System.DateTime documentDateIssued, global::System.Int32 documentStatusId, global::System.Guid documentRecipientCostCentre)
{
tblDocument tblDocument = new tblDocument();
tblDocument.Id = id;
tblDocument.DocumentTypeId = documentTypeId;
tblDocument.IM_DateCreated = iM_DateCreated;
tblDocument.IM_DateLastUpdated = iM_DateLastUpdated;
tblDocument.IM_IsActive = iM_IsActive;
tblDocument.DocumentIssuerCostCentreId = documentIssuerCostCentreId;
tblDocument.DocumentIssuerUserId = documentIssuerUserId;
tblDocument.DocumentDateIssued = documentDateIssued;
tblDocument.DocumentStatusId = documentStatusId;
tblDocument.DocumentRecipientCostCentre = documentRecipientCostCentre;
return tblDocument;
}
private FclExportOrderDto MapFCLDTO(tblDocument document,string append)
{
if(document !=null)
{
var dto = new FclExportOrderDto()
{
OrderDate = document.DocumentDateIssued.ToString("dd-MM-yyyy"),
ExternalOrderReference = GetOrderReference(document,append),
GenericOrderReference = document.DocumentReference,
OutletCode =HandleOutlet(document),
SalesmanCode =HandleSalesmanCode(document),
ShiptoAddressCode =HandleShipTo(document)
};
foreach (var lineItem in document.tblLineItems)
{
if (lineItem.ProductID != null && lineItem.ProductID != Guid.Empty)
{
var product = _ctx.tblProduct.FirstOrDefault(p => p.id == lineItem.ProductID);
if (product != null)
{
var item = new FclExportOrderLineItem()
{
ProductCode = product.ProductCode,
ApprovableQuantity =
(lineItem.Quantity != null) ? lineItem.Quantity.Value : 0,
};
dto.LineItems.Add(item);
}
}
}
return dto;
}
return null;
}
private DisbursementNote Map(tblDocument tblDoc)
{
var doc = new DisbursementNote(tblDoc.Id);
_Map(tblDoc,doc);
var lineItem = tblDoc.tblLineItems.Select(n => MapDisbursementNoteLineItems(n)).ToList();
doc._SetLineItems(lineItem);
return doc;
}
internal MainOrderSummary MapSummary(tblDocument tblDocument, bool calculateOutstanding = false,
bool getapproveddate = false)
{
string salesman = "";
var issuer =
_ctx.tblCostCentre.Where(s => s.Id == tblDocument.DocumentIssuerCostCentreId).Select(
s => new {s.Name, s.CostCentreType.Value, s.Id}).FirstOrDefault();
var recepient =
_ctx.tblCostCentre.Where(s => s.Id == tblDocument.DocumentRecipientCostCentre).Select(
s => new {s.Name, s.CostCentreType.Value, s.Id}).FirstOrDefault();
var outlet =
_ctx.tblCostCentre.Where(s => s.Id == tblDocument.OrderIssuedOnBehalfOfCC).Select(
s => new {s.Name, s.CostCentreType.Value, s.Id}).FirstOrDefault();
var mainOrderSummary = new MainOrderSummary();
if (issuer != null && recepient != null && (CostCentreType) issuer.Value == CostCentreType.Distributor)
{
salesman = recepient.Name + "(" + issuer.Name + ")";
mainOrderSummary.SalesmanId = recepient.Id;
}
else if (issuer != null && recepient != null)
{
salesman = issuer.Name + "(" + recepient.Name + ")";
mainOrderSummary.SalesmanId = issuer.Id;
}
if (outlet != null)
{
mainOrderSummary.Outlet = outlet.Name;
}
if (getapproveddate)
{
var invoicedoc = _ctx.tblDocument.FirstOrDefault(s => s.DocumentParentId == tblDocument.Id);
if (invoicedoc != null)
mainOrderSummary.DateProcessed = invoicedoc.DocumentDateIssued;
}
var lineitems =
tblDocument.tblLineItems.Where(s => s.LineItemStatusId != (int) MainOrderLineItemStatus.Removed);
mainOrderSummary.OrderId = tblDocument.Id;
mainOrderSummary.Status = (DocumentStatus) tblDocument.DocumentStatusId;
mainOrderSummary.TotalVat = lineitems.Sum(n => (n.Vat ?? 0)*(n.Quantity ?? 0));
mainOrderSummary.GrossAmount = (lineitems.Sum(n => (n.Value ?? 0) * (n.Quantity ?? 0)).GetTruncatedValue() +
mainOrderSummary.TotalVat.GetTruncatedValue()).GetTotalGross();
//mainOrderSummary.GrossAmount = lineitems.Sum(n => DiscountProWorkflow.GetTruncatedValue((n.Value ?? 0) * (n.Quantity ?? 0))) +
// mainOrderSummary.TotalVat;
mainOrderSummary.OrderReference = tblDocument.DocumentReference;
mainOrderSummary.Required = tblDocument.OrderDateRequired != null
? tblDocument.OrderDateRequired.Value
: DateTime.Now;
decimal salediscount = tblDocument.SaleDiscount.HasValue ? tblDocument.SaleDiscount.Value : 0;
mainOrderSummary.SaleDiscount = salediscount;
mainOrderSummary.NetAmount = (mainOrderSummary.GrossAmount) - mainOrderSummary.SaleDiscount;
mainOrderSummary.Salesman = salesman;
mainOrderSummary.ExternalRefNo = tblDocument.ExtDocumentReference ?? "";
if (tblDocument.OrderIssuedOnBehalfOfCC != null)
mainOrderSummary.OutletId = tblDocument.OrderIssuedOnBehalfOfCC.Value;
if (calculateOutstanding)
{
var invoiceList = (from d in _ctx.tblDocument
where d.DocumentTypeId == (int) DocumentType.Invoice
where d.InvoiceOrderId == tblDocument.Id
from l in d.tblLineItems
select new {l.Quantity, l.Value, l.Vat}).ToList();
var invoiceAmount =invoiceList.Sum(x => ((x.Quantity.Value * x.Value.Value) + (x.Vat.Value * x.Quantity.GetValueOrDefault(0))).GetTruncatedValue()).GetTotalGross();
//var invoiceAmount = (decimal?) (from d in _ctx.tblDocument
// where d.DocumentTypeId == (int) DocumentType.Invoice
// where d.InvoiceOrderId == tblDocument.Id
// from l in d.tblLineItems
// select new {l.Quantity, l.Value, l.Vat})
// .Sum(x => (x.Quantity*x.Value) + (x.Vat*x.Quantity)) ?? 0;
var receiptAmount = (decimal?) (from d in _ctx.tblDocument
where d.DocumentTypeId == (int) DocumentType.Receipt
where d.DocumentParentId == tblDocument.Id
from l in d.tblLineItems
select new {l.Value})
.Sum(x => x.Value) ?? 0;
var creditNoteSum = (decimal?) (from d in _ctx.tblDocument
where d.DocumentTypeId == (int) DocumentType.CreditNote
where d.DocumentParentId == tblDocument.Id
from l in d.tblLineItems
select new {l.Quantity, l.Value, l.Vat})
.Sum(x => (x.Quantity*x.Value) + (x.Vat*x.Quantity)) ?? 0;
decimal totalInvoiceAmount =(invoiceAmount - salediscount).GetTotalGross();
decimal totalPaidAmount = (receiptAmount + creditNoteSum);
decimal outstandingAmount = totalInvoiceAmount - totalPaidAmount;
mainOrderSummary.OutstandingAmount = outstandingAmount>0?outstandingAmount:0;
mainOrderSummary.PaidAmount = receiptAmount;
}
return mainOrderSummary;
}
private string GetPaymentReference(tblDocument doc, string append)
{
var returnValue = string.Empty;
var counter = string.Empty;
if (doc.OrderIssuedOnBehalfOfCC != null && doc.OrderIssuedOnBehalfOfCC != Guid.Empty)
{
var costcenter = _ctx.tblCostCentre.FirstOrDefault(p => p.Id == doc.OrderIssuedOnBehalfOfCC);
if (costcenter != null)
{
counter = doc.ExtDocumentReference;
var routeId = costcenter.RouteId;
if (routeId != null)
{
var routeName = _routeRepository.GetById((Guid)routeId).Name;
returnValue = routeName;
}
}
}
return returnValue + append + counter;
}
private Order Map(tblDocument tblDoc)
{
var o = new Order(tblDoc.Id);
_Map(tblDoc, o);
o.DateRequired = tblDoc.OrderDateRequired.Value;
o.IssuedOnBehalfOf = _costCentreRepository.GetById(tblDoc.OrderIssuedOnBehalfOfCC.Value);
o.OrderType = (OrderType)tblDoc.OrderOrderTypeId.Value;
o.SaleDiscount = tblDoc.SaleDiscount.Value;
o.Note = tblDoc.Note;
//tblDoc.tblLineItems.Any();
o._SetLineItems(tblDoc.tblLineItems.Select(s => MapOrderLineItem(s)).ToList());
return o;
}
private static void MapPaymentInfo(tblDocument tblMainOrder, MainOrder mo)
{
foreach (var paymentInfo in tblMainOrder.tblOrderPaymentInfo)
{
var item = new PaymentInfo
{
Amount = paymentInfo.Amount,
ConfirmedAmount = paymentInfo.ConfirmedAmount,
Id = paymentInfo.Id,
Description = paymentInfo.Description,
IsConfirmed = paymentInfo.IsConfirmed.Value,
IsProcessed = paymentInfo.IsProcessed.Value,
MMoneyPaymentType = paymentInfo.MMoneyPaymentType,
NotificationId = paymentInfo.NotificationId,
PaymentModeUsed = (PaymentMode) paymentInfo.PaymentMode,
PaymentRefId = paymentInfo.PaymentRefId,
Bank = paymentInfo.BankCode,
BankBranch = paymentInfo.BranchCode,
DueDate = paymentInfo.ChequeDueDate
};
if (paymentInfo.ChequeDueDate.HasValue)
paymentInfo.ChequeDueDate = paymentInfo.ChequeDueDate.Value;
mo.AddPayment(item);
}
}
string GetOrderNetValue(tblDocument order)
{
var lineitems =
_ctx.tblLineItems.Where(
s => s.DocumentID == order.Id && s.LineItemStatusId != (int) MainOrderLineItemStatus.Removed).ToList
();
if (lineitems.Any())
{
var totalVat = lineitems.Sum(n => (n.Vat ?? 0)*(n.Quantity ?? 0));
var grossAmount = lineitems.Sum(n => (n.Value ?? 0)*(n.Quantity ?? 0)) + totalVat;
decimal salediscount = order.SaleDiscount.HasValue ? order.SaleDiscount.Value : 0;
return (grossAmount - salediscount).ToString("#0.00");
}
return "0.00";
}
protected virtual decimal GetPaidAmount(tblDocument order)
{
decimal paidamount =
_ctx.ExecuteStoreQuery<decimal>(string.Format(MainOrderResource.PaidAmount, order.Id)).FirstOrDefault();
return paidamount;
//decimal salediscount = order.SaleDiscount.HasValue ? order.SaleDiscount.Value : 0;
//var invoiceAmount = (decimal?) (from d in _ctx.tblDocument
// where d.DocumentTypeId == (int) DocumentType.Invoice
// where d.InvoiceOrderId == order.Id
// from l in d.tblLineItems
// select new {l.Quantity, l.Value, l.Vat})
// .Sum(x => (x.Quantity*x.Value) + (x.Vat*x.Quantity)) ?? 0;
//var receiptAmount = (decimal?) (from d in _ctx.tblDocument
// where d.DocumentTypeId == (int) DocumentType.Receipt
// where d.DocumentParentId == order.Id
// from l in d.tblLineItems
// select new {l.Value})
// .Sum(x => x.Value) ?? 0;
//var creditNoteSum = (decimal?) (from d in _ctx.tblDocument
// where d.DocumentTypeId == (int) DocumentType.CreditNote
// where d.DocumentParentId == order.Id
// from l in d.tblLineItems
// select new {l.Quantity, l.Value, l.Vat})
// .Sum(x => (x.Quantity*x.Value) + (x.Vat*x.Quantity)) ?? 0;
//decimal totalPaidAmount = (receiptAmount + creditNoteSum);
// return totalPaidAmount;
}
string GetChequePayment(tblDocument order)
{
var payment =_ctx.tblOrderPaymentInfo.Where(p =>p.DocumentId==order.Id && p.PaymentMode == (int) PaymentMode.Cheque).ToList();
if (payment.Any())
{
var tblOrderPaymentInfo = payment.FirstOrDefault();
if (tblOrderPaymentInfo != null) return tblOrderPaymentInfo.PaymentRefId;
}
return string.Empty;
}
private Invoice Map(tblDocument tblDoc)
{
var inv = PrivateConstruct<Invoice>(tblDoc.Id);
_Map(tblDoc, inv);
inv.OrderId = tblDoc.InvoiceOrderId.Value;
inv.SaleDiscount = tblDoc.SaleDiscount.Value;
inv._SetLineItems(tblDoc.tblLineItems.Select(n => MapInvoiceLineItem(n)).ToList());
return inv;
}
string HandleSalesmanCode(tblDocument order)
{
var issuer = _costCentreRepository.GetById(order.DocumentIssuerCostCentreId);
if (issuer is Distributor)
{
var costCentre = _ctx.tblCostCentre.FirstOrDefault(p => p.Id == order.DocumentRecipientCostCentre);
if (costCentre != null)
return costCentre.Cost_Centre_Code;
}
else
{
var costCentre = _ctx.tblCostCentre.FirstOrDefault(p => p.Id == order.DocumentIssuerCostCentreId);
if (costCentre != null)
return costCentre.Cost_Centre_Code;
}
return string.Empty;
}