public int InsertPaymentsReceived(PaymentsReceived pEst)
 {
     try
     {
         return(_AD.InsertPaymentsReceived(pEst));
     }
     catch (Exception ex)
     {
         throw;
     }
 }
 public bool UpdatePaymentsReceivedStatus(PaymentsReceived pEst)
 {
     try
     {
         _AD.UpdatePaymentsReceivedStatus(pEst);
         return(true);
     }
     catch (Exception ex)
     {
         throw;
     }
 }
        public void UpdatePaymentsReceivedStatus(PaymentsReceived pPaymentsReceived)
        {
            string sql = @"[spUpdatePaymentsReceivedStatus] '{0}', '{1}', '{2}'";

            sql = string.Format(sql, pPaymentsReceived.Id, pPaymentsReceived.Status.Id,
                                pPaymentsReceived.ModificationUser);
            try
            {
                _MB.EjecutarSQL(_CN, sql);
            }
            catch (Exception err)
            {
                throw err;
            }
        }
        public void UpdatePaymentsReceived(PaymentsReceived pPaymentsReceived)
        {
            string sql = @"[spUpdatePaymentsReceived] '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}'";

            sql = string.Format(sql, pPaymentsReceived.Id, pPaymentsReceived.IdFolio, pPaymentsReceived.Company.Id, pPaymentsReceived.UserCliente.Id, pPaymentsReceived.Amount,
                                pPaymentsReceived.PaymentDate.ToString("yyyyMMdd"), pPaymentsReceived.PaymentMode.Id, pPaymentsReceived.DepositTo.Id, pPaymentsReceived.Status.Id,
                                pPaymentsReceived.CreationDate.ToString("yyyyMMdd"), pPaymentsReceived.CreatorUser, pPaymentsReceived.ModificationUser);
            try
            {
                _MB.EjecutarSQL(_CN, sql);
            }
            catch (Exception err)
            {
                throw err;
            }
        }
 public object DeletePaymentsReceived(PaymentsReceived dPaymentsReceived)
 {
     throw new NotImplementedException();
 }