private static List <PurchaseHeader> GetPurchasesBy(string NAVDatabaseName, string NAVCompanyName, NAVBaseDocumentTypes type, string supplierId, string orderId, string externalDocNo)
{
try
{
List <PurchaseHeader> result = new List <PurchaseHeader>();
using (var ctx = new SuchDBContextExtention())
{
var parameters = new[] {
new SqlParameter("@DBName", NAVDatabaseName),
new SqlParameter("@CompanyName", NAVCompanyName),
new SqlParameter("@Type", (int)type),
new SqlParameter("@SupplierId", supplierId),
new SqlParameter("@OrderId", orderId),
new SqlParameter("@ExternalDocNo", externalDocNo)
};
IEnumerable <dynamic> data = ctx.execStoredProcedure("exec NAV2017Encomendas @DBName, @CompanyName, @Type, @SupplierId, @OrderId, @ExternalDocNo", parameters);
foreach (dynamic temp in data)
{
var item = new PurchaseHeader();
item.DocumentType = (int)temp.DocumentType;
item.No = temp.No;
item.OrderDate = temp.OrderDate is DBNull ? string.Empty : ((DateTime)temp.OrderDate).ToString("yyyy-MM-dd");
item.DueDate = temp.DueDate is DBNull ? string.Empty : ((DateTime)temp.DueDate).ToString("yyyy-MM-dd");
item.LocationCode = temp.LocationCode;
item.RegionId = temp.RegionId is DBNull ? string.Empty : temp.RegionId;
item.FunctionalAreaId = temp.FunctionalAreaId is DBNull ? string.Empty : temp.FunctionalAreaId;
item.RespCenterId = temp.RespCenterId is DBNull ? string.Empty : temp.RespCenterId;
item.VendorOrderNo = temp.VendorOrderNo;
item.VendorInvoiceNo = temp.VendorInvoiceNo;
item.VendorCrMemoNo = temp.VendorCrMemoNo;
item.BuyFromVendorNo = temp.BuyFromVendorNo;
item.BuyFromVendorName = temp.BuyFromVendorName;
item.DocumentDate = temp.DocumentDate is DBNull ? string.Empty : ((DateTime)temp.DocumentDate).ToString("yyyy-MM-dd");
item.DimensionSetID = temp.DimensionSetID;
item.RelatedDocument = temp.RelatedDocument;
item.ValorFactura = temp.ValorFactura;
item.SourceDocNo = temp.SourceDocNo;
item.Quantity = temp.Quantity;
item.QuantityReceived = temp.QuantityReceived;
item.AmountRcdNotInvoiced = temp.AmountRcdNotInvoiced;
item.Amount = temp.Amount;
item.AmountIncludingVAT = temp.AmountIncludingVAT;
result.Add(item);
}
}
return(result);
}
catch (Exception ex)
{
return(null);
}
}
public static NAVSalesHeaderViewModel GetSalesHeader(string NAVDatabaseName, string NAVCompanyName, string NAVContractNo, NAVBaseDocumentTypes documentType)
{
try
{
List <NAVSalesHeaderViewModel> result = new List <NAVSalesHeaderViewModel>();
using (var ctx = new SuchDBContextExtention())
{
var parameters = new[] {
new SqlParameter("@DBName", NAVDatabaseName),
new SqlParameter("@CompanyName", NAVCompanyName),
new SqlParameter("@DocumentType", (int)documentType),
new SqlParameter("@ContractNo_", NAVContractNo)
};
IEnumerable <dynamic> data = ctx.execStoredProcedure("exec NAV2017CabecalhoVendas @DBName, @CompanyName, @DocumentType, @ContractNo_", parameters);
foreach (dynamic temp in data)
{
result.Add(new NAVSalesHeaderViewModel()
{
ContractNo = (string)temp.ContractNo_,
DocumentType = (int)temp.DocumentType,
});
}
}
return(result[0]);
}
catch (Exception ex)
{
return(null);
}
}
public static PurchaseHeader GetByExternalDocNo(string NAVDatabaseName, string NAVCompanyName, NAVBaseDocumentTypes type, string externalDocNo)
{
var items = GetPurchasesBy(NAVDatabaseName, NAVCompanyName, type, string.Empty, string.Empty, externalDocNo);
if (items != null)
{
return(items.FirstOrDefault());
}
return(null);
}
