public int InsertCreditNotesxInvoicess(CreditNotesxInvoices pEst)
 {
     try
     {
         return(_AD.InsertCreditNotesxInvoices(pEst));
     }
     catch (Exception ex)
     {
         throw;
     }
 }
        public int InsertCreditNotesxInvoices(CreditNotesxInvoices pCreditNotesxInvoices)
        {
            string sql = @"[spInsertCreditNotesxInvoices] '{0}', '{1}', '{2}'";

            sql = string.Format(sql, pCreditNotesxInvoices.CreditNotes.Id, pCreditNotesxInvoices.Invoice.Id, pCreditNotesxInvoices.Amount);
            try
            {
                return(_MB.EjecutarSQL(_CN, sql));
            }
            catch (Exception err)
            {
                throw err;
            }
        }