/// <summary>
 /// Function to delete particular details based on the parameter From Table BankReconciliation
 /// </summary>
 /// <param name="PurchaseReturnDetailsId"></param>
 public void PurchaseReturnDetailsDelete(decimal PurchaseReturnDetailsId)
 {
     PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();
        try
        {
        SPPurchaseReturnDetails.PurchaseReturnDetailsDelete(PurchaseReturnDetailsId);
        }
        catch (Exception ex)
        {
        MessageBox.Show("PrBll 10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
 }
 /// <summary>
 /// Function to insert values to accountgroup Table and return the Curresponding row's Id
 /// </summary>
 /// <param name="purchasereturndetailsinfo"></param>
 /// <returns></returns>
 public decimal PurchaseReturnDetailsAddWithReturnIdentity(PurchaseReturnDetailsInfo purchasereturndetailsinfo)
 {
     PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();
        decimal decIdentity = 0;
        try
        {
        decIdentity = SPPurchaseReturnDetails.PurchaseReturnDetailsAddWithReturnIdentity(purchasereturndetailsinfo);
        }
        catch (Exception ex)
        {
        MessageBox.Show("PrBll 5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
        return decIdentity;
 }
        /// <summary>
        /// Function to Update values in accountgroup Table
        /// </summary>
        /// <param name="purchasereturndetailsinfo"></param>
        public void PurchaseReturnDetailsEdit(PurchaseReturnDetailsInfo purchasereturndetailsinfo)
        {
            PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();

               try
               {
               SPPurchaseReturnDetails.PurchaseReturnDetailsEdit(purchasereturndetailsinfo);
               }
               catch (Exception ex)
               {
               MessageBox.Show("PrBll 6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
               }
        }
        /// <summary>
        /// FUnction to use the Vouchertype combofill for purchase return
        /// </summary>
        /// <returns></returns>
        public List<DataTable> VoucherTypeComboFillForPurchaseReturn()
        {
            PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();
               List<DataTable> ListObj = new List<DataTable>();
               try
               {
               ListObj = SPPurchaseReturnDetails.VoucherTypeComboFillForPurchaseReturn();
               }
               catch (Exception ex)
               {
               MessageBox.Show("PrBll 2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);

               }
               return ListObj;
        }
        /// <summary>
        /// Function to get the PurchaseReturn Details  By Purchase return MasterId
        /// </summary>
        /// <param name="decPurchaseReturnMasterId"></param>
        /// <returns></returns>
        public List<DataTable> PurchaseReturnDetailsViewByMasterId(decimal decPurchaseReturnMasterId)
        {
            PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();
               List<DataTable> ListObj = new List<DataTable>();
               try
               {
               ListObj = SPPurchaseReturnDetails.PurchaseReturnDetailsViewByMasterId(decPurchaseReturnMasterId);
               }
               catch (Exception ex)
               {
               MessageBox.Show("PrBll 14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);

               }
               return ListObj;
        }
        /// <summary>
        /// Function to use the PurchaseReturn Details Qty View By PurchaseDetailsId for Purchase Invoice
        /// </summary>
        /// <param name="decPurchaseDetailsId"></param>
        /// <returns></returns>
        public decimal PurchaseReturnDetailsQtyViewByPurchaseDetailsId(decimal decPurchaseDetailsId)
        {
            decimal decQty = 0;

            PurchaseReturnDetailsSP SPPurchaseReturnDetails = new PurchaseReturnDetailsSP();

            try
            {
                decQty = SPPurchaseReturnDetails.PurchaseReturnDetailsQtyViewByPurchaseDetailsId(decPurchaseDetailsId);
            }
            catch (Exception ex)
            {
                MessageBox.Show("PrBll 21:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }
            return decQty;
        }