GO
/****** Object:  StoredProcedure [dbo].[sp_SaveDeliveryNote]    Script Date: 27-03-2025 12:24:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


 ALTER PROCEDURE [dbo].[sp_SaveDeliveryNote]
(
@DnNo nvarchar(50),
@BranchCode varchar(10)
)
AS  
begin  
select DeliveryNote.InvoiceDate as InVDate,DeliveryNote.PoDate,DeliveryNote.Del1,DeliveryNote.Del2,DeliveryNote.Del3,DeliveryNote.Del4,DeliveryNote. InvoiceNo ,
DeliveryNote.Attention,DeliveryNote.mobAttention,DeliveryNote.emailAttention,DeliveryNote.QuotationNo,DeliveryNote.DNNo,DeliveryNote.EntryDate,
DeliveryNote.PONo,DeliveryNote.RefNo,DeliveryNote.CustomerName,DeliveryNote.CustomerCode,DeliveryNote.Address,DeliveryNote.Telephone,DeliveryNote.Fax,
DeliveryNote.Attended,DeliveryNote.GrossAmount,DeliveryNote.DISAMT as Less,DeliveryNote.NetAmount,DeliveryNote.vattotal,DeliveryNoteItem.SlNo,DeliveryNoteItem.ItemCode,DeliveryNoteItem.ItemName,DeliveryNoteItem.Unit,DeliveryNoteItem.Qty,DeliveryNoteItem.OrderedQty as ORDQTY,
DeliveryNoteItem.Amount,ISNULL(DeliveryNoteItem.PartNo,'') AS PartNo,ISNULL(DeliveryNote.VATNO,'') AS VATNO,ISNULL(deliverynoteitem.VATPER,0) AS VATPER,ISNULL(VATAMT,0) AS VATAMT 
,ISNULL(C.namear,'') as Arabicname,isnull(C.address1ar,'') as ArabicAddress 
, dbo.currency_conversion(DeliveryNote.NetAmount) as ARABICNETAMOUNT
  ,isnull(logoimage,'')as logoimage,isnull(signatureimage,'')as signatureimage,isnull(sealimage,'')as sealimage,isnull(footerimage,'')as footerimage,isnull(headderimage,'')as headderimage,
  j.Model,j.PlateNo,j.JobCardDate,i.Category
from DeliveryNote 
JOIN Companydetails CD ON ISNULL(CD.BranchCode,@BranchCode)=@BranchCode
inner join DeliveryNoteItem on DeliveryNote.DnNo=DeliveryNoteItem.DnNo
 LEFT JOIN CUSTOMER C ON C.CODE=DeliveryNote.CUSTOMERCODE
 left join JobCard j on j.JobCardNo=DeliveryNote.JobCardNo
 left join item i on i.itemcode=DeliveryNoteItem.ItemCode
 where DeliveryNote.DnNo=@DnNo ORDER BY DeliveryNoteItem.SlNo  
end